All gists

archgeus / WebApp.ServerList

0 likes
0 forks
1 files
Last active 1 month ago
ServerList query for v31.04. Remember to replace server details and credentials accordingly.
1 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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 likes
0 forks
1 files
Last active 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')
Newer Older

Powered by Opengist ⋅ Load: 163ms⋅

English