archgeus

Unito 2 years ago

archgeus / CollectionDB Procedure

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
100.02
1 -- ------------------------------ Table structure for DbInfo-- ----------------------------
2
3 IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
4
5 DROP TABLE [dbo].[DbInfo]
6
7 GO
8
9 CREATE TABLE [dbo].[DbInfo] ( [version] int NULL)

archgeus / SharedDB Procedures

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
92.03/04 347932
1 -- ------------------------------ Table structure for DbInfo-- ----------------------------
2
3 IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
4
5 DROP TABLE [dbo].[DbInfo]
6
7 GO
8
9 CREATE TABLE [dbo].[DbInfo] ( [version] int NULL)

archgeus / PlanetDB Procedure

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
92.03/04 363898
1 -- ------------------------------ Table structure for DbInfo-- ----------------------------
2
3 IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
4
5 DROP TABLE [dbo].[DbInfo]
6
7 GO
8
9 CREATE TABLE [dbo].[DbInfo] ([version] int NULL)

archgeus / LogDB_*

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
LogDB_ Procedure
1 USE [LogDB_2800]
2 GO
3 /****** Object: StoredProcedure [dbo].[spCreateBcpResult] Script Date: 7/19/2022 8:22:02 PM ******/
4 SET ANSI_NULLS ON
5 GO
6 SET QUOTED_IDENTIFIER ON
7 GO
8 -- =============================================
9 -- Author: <Author,,Name>
10 -- Create date: <Create Date,,>

archgeus / World QA Commands

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
1 /@abnormality abnormal state ID //force abnormal state
2 /@abnormality_off abnormality ID //force abnormality
3 /@abnormality_show abnormality ID //force abnormality
4 /@abnormality_time [abnormality ID] [duration] //force abnormality by specifying duration
5 /@accept_revival // resurrect if resurrected
6 /@accomplish_achievement_rate //achieve achievements until the current season achievement rate is exceeded
7 /@add_actpoint [actPoint value] //Change coin of adventure
8 /@add_bf_score //Addition of battlefield control points [Score]
9 /@add_daily_clear_count [addBonusCount] //Increase the number of daily bonus quests completed in the Valkyon Order
10 /@add_ep [EpPoint] //Change EP Point

archgeus / Arbiter QA Commands

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
1 /@add_card_collection_point [point] //Add card book score
2 /@add_city_war_guild_ban [leagueId][guildDbId] //Add Battle Battle Guild Ven List
3 /@add_citywar_taxpot [taxId][taxMoney] //add tax
4 /@add_dungeon_abnormality [continentId] [abnormalId] [startTime] [endTime] //Add Dungeon Abnormality Event
5 /@add_event_system [Condition Minimum Level][Condition Maximum Level][Condition Class][Event Type][TargetTemplateId][Number of Achievements] //Add event system event
6 /@add_friend [userName] //add friend
7 /@add_friendship [userName] [point] //Increase friendship with the friend
8 /@add_friendship_party [point] //Add friendliness to friends among party members
9 /@add_guild_contribution_point [point] //Acquisition of guild contribution (weekly repayment cannot be exceeded)
10 /@add_guild_exp [exp] //Acquire Guild EXP

archgeus / server_info_de

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
71.03
1 INSERT INTO `teraapi`.`server_info` (`serverId`, `loginIp`, `loginPort`, `language`, `nameString`, `descrString`, `permission`, `tresholdLow`, `tresholdMedium`, `isPvE`, `isCrowdness`, `isAvailable`, `isEnabled`, `usersOnline`, `usersTotal`) VALUES (4009, '1.1.1.1', 7801, 'de', 'Kaiator', 'Enmasse Entertainment', 0, 50, 100, 1, 0, 0, 1, 0, 0);
2
3 Replace 4009 with your server id and 1.1.1.1 with your public ip

archgeus / server_strings_de

0 mi piace
0 forks
1 files
Ultima volta attivo 1 month ago
71.03
1 INSERT INTO `teraapi`.`server_strings` (`language`, `categoryPvE`, `categoryPvP`, `serverOffline`, `serverLow`, `serverMedium`, `serverHigh`, `crowdNo`, `crowdYes`, `popup`) VALUES ('de', 'PvE', 'PvP', 'Offline', 'Low', 'Medium', 'High', 'Nein', 'Ja', 'Der Zugriff auf den Server ist zur Zeit nicht möglich.');
Più nuovi Più vecchi

Creato da Opengist ⋅ Load: 102ms⋅

Italiano