Wszystkie Gisty - Opengist

archgeus / WebApp.ServerList

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

ServerList query for v31.04. Remember to replace server details and credentials accordingly.

INSERT INTO [dbo].[ServerList] ([adminAddr], [adminPort], [connString], [logDbConn], [mergeReportDbConn], [orderId], [planetId], [reportDbConn], [serverName], [serverNo], [sharedDBConnString]) VALUES (N'127.0.0.1', 8081, N'Data Source={SQL Server};Server=127.0.0.1;Database=PlanetDB_3104;UID=sa;PWD=yourpassword', N'Data Source={SQL Server};Server=127.0.0.1;Database=LogDB_3104;UID=sa;PWD=yourpassword', NULL, 1, 10, N'Data Source={SQL Server};Server=127.0.0.1;Database=ReportDB_3104;UID=sa;PWD=yourpassword', N'TERA', 1, N'Data Source={SQL Server};Server=127.0.0.1;Database=SharedDB_3104;UID=sa;PWD=yourpassword');

archgeus / WorldServer QA Commands p31

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

1	_helpworld [keyword] //
2	/@abnormality abnormal state ID //force abnormal state
3	/@abnormality_off abnormality ID //force abnormality
4	/@abnormality_show abnormality ID //force abnormality
5	/@accept_revival // resurrect if resurrected
6	/@accomplish_achievement_rate //achieve achievements until the current season achievement rate is exceeded
7	/@add_bf_score //Addition of battlefield control points [Score]
8	/@add_exp [EXP value] //Add experience value
9	/@add_hp [HP value] //Adjust HP value
10	/@add_mp [MP value] //Adjust MP value

archgeus / ArbiterServer QA Commands p31

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

1	/@add_allunionguild_seasoncp
2	/@add_allunionmember_seasoncp
3	/@add_guild_skill [Skill ID] [Guildmaster Skill: 0\|1] [Permanent Skill: [0\|1] //Guild Skill
4	/@add_guildmember [count]
5	/@add_package [PackageId] [ExpireSecond] {[UserName]} //Account Trait Package setting
6	/@addcompetitionpoint
7	/@addunioncommanderpolicyhistory
8	/@addunionconsulpolicyhistory
9	/@addunionelitepolicyhistory
10	/@addunionmemberhistory

archgeus / 31.04_CHANGES

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

1	\Art_Data\Maps\AEN\AEN_B_4761.gmp
2	\Art_Data\Maps\ASW\ASW_A_4055.gmp
3	\Art_Data\Maps\ATW\ATW.gmp
4	\Art_Data\Maps\BattleField\BF_FreeFight.gmp
5	\Art_Data\Maps\BattleField\BF_FreeFight_Asset.gmp
6	\Art_Data\Maps\BattleField\BF_FreeFight_P.gmp
7	\Art_Data\Maps\BattleField\BF_FreeFight_Void.gmp
8	\Art_Data\Maps\BattleField\BF_KumasWorld.gmp
9	\Art_Data\Maps\BattleField\BF_KumasWorld_Asset.gmp
10	\Art_Data\Maps\BattleField\BF_KumasWorld_Sea.gmp

archgeus / server_strings

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

FR & DE machine translated

1	INSERT INTO `server_strings` (`language`, `categoryPvE`, `categoryPvP`, `serverOffline`, `serverLow`, `serverMedium`, `serverHigh`, `crowdNo`, `crowdYes`, `popup`) VALUES ('fr', 'PvE', 'PvP', 'Hors ligne', 'Faible', 'Moyenne', 'Élevé', 'Non', 'Oui', 'Impossible d\'\accéder au serveur pour le moment.');
2	INSERT INTO `server_strings` (`language`, `categoryPvE`, `categoryPvP`, `serverOffline`, `serverLow`, `serverMedium`, `serverHigh`, `crowdNo`, `crowdYes`, `popup`) VALUES ('de', 'PvE', 'PvP', 'Offline', 'Niedrig', 'Mittel', 'Hoch', 'Nein', 'Ja', 'Zu diesem Zeitpunkt kann nicht auf den Server zugegriffen werden.');

archgeus / protocol.333782.map

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

71.03 EME 333782

1	C_ADD_FRIEND = 63965
2	C_ADD_TELEPORT_TO_POS_LIST = 31182
3	C_ADMIN = 52689
4	C_APPLY_PARTY = 53726
5	C_ASK_INTERACTIVE = 39159
6	C_BAN_PARTY_MEMBER = 29645
7	C_BIND_ITEM_BEGIN_PROGRESS = 24285
8	C_BIND_ITEM_EXECUTE = 60986
9	C_BLOCK_USER = 42106
10	C_CANCEL_CHANGE_USER_APPEARANCE = 24969

archgeus / Create TERA Databases

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

Script to automatically create databases: PlanetDB_2800, SharedDB_2800, CollectionDB_2800, and LogDB_2800

1	-- Create PlanetDB_2800
2	IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'PlanetDB_2800')
3	BEGIN
4	PRINT 'Creating PlanetDB_2800...'
5	CREATE DATABASE PlanetDB_2800
6	PRINT 'PlanetDB_2800 created successfully.'
7	END
8	ELSE
9	BEGIN
10	PRINT 'PlanetDB_2800 already exists.'

archgeus / Black Desert Simple Field Starter.cmd

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

1	@echo off
2
3	:menu
4	cls
5	echo ################################
6	echo Menu:
7	echo ################################
8	echo --------------------------------
9	echo 1. Start CH1 - Calpheon
10	echo 2. Start CH2 - Serendia

archgeus / SharedDB Procedure

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

100.02

1	-- ------------------------------ Table structure for DbInfo-- ----------------------------
2	IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
3	DROP TABLE [dbo].[DbInfo]
4	GO
5	CREATE TABLE [dbo].[DbInfo] ( [version] int NULL)
6	GO
7	ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE)
8	GO
9	-- ------------------------------ Records of DbInfo-- ----------------------------
10	INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'374749')

archgeus / PlanetDB Procedure

0 polubień

0 forków

1 plików

Ostatnio aktywne 1 month ago

100.02

1	-- ------------------------------ Table structure for DbInfo-- ----------------------------
2	IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
3	DROP TABLE [dbo].[DbInfo]
4	GO
5	CREATE TABLE [dbo].[DbInfo] ([version] int NULL)
6	GO
7	ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE)
8	GO
9	-- ------------------------------ Records of DbInfo-- ----------------------------
10	INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'375960')