archgeus / WebApp.ServerList
0 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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 / server_strings
0 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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 gustos
0 bifurcaciones
1 archivos
Última actividad 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') |
Siguiente
Anterior