الموقع العربي الاول للعبة Silkroad Online

دي في الــــSRO_VT_ACCOUNT

كود بلغة HTML:

USE [SRO_VT_ACCOUNT]

GO

TRUNCATE TABLE [dbo].[__SiegeFortressStatus__]

TRUNCATE TABLE [dbo].[_BlockedUser]

TRUNCATE TABLE [dbo].[_CasGMChatLog]

TRUNCATE TABLE [dbo].[_Notice]

TRUNCATE TABLE [dbo].[_Punishment]

TRUNCATE TABLE [dbo].[_ServiceManagerLog]

TRUNCATE TABLE [dbo].[_ShardCurrentUser]

TRUNCATE TABLE [dbo].[_SMCLog]

TRUNCATE TABLE [dbo].[QuaySoEpoint]

TRUNCATE TABLE [dbo].[SK_CharRenameLog]

TRUNCATE TABLE [dbo].[SK_DownLevelLog]

TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]

TRUNCATE TABLE [dbo].[SK_ItemSaleLog]

TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]

TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]

TRUNCATE TABLE [dbo].[SK_ResetSkillLog]

TRUNCATE TABLE [dbo].[SK_Silk]

TRUNCATE TABLE [dbo].[SK_SilkBuyList]

TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]

TRUNCATE TABLE [dbo].[SR_ShardCharNames]

TRUNCATE TABLE [dbo].[TB_Net2e]

TRUNCATE TABLE [dbo].[TB_Net2e_Bak]

TRUNCATE TABLE [dbo].[tb_partnerInfo]

TRUNCATE TABLE [dbo].[tb_paygate_trans]

TRUNCATE TABLE [dbo].[TB_User]

TRUNCATE TABLE [dbo].[TB_User_Bak]

TRUNCATE TABLE [dbo].[Test_HN]

UPDATE [dbo].[_ShardService] SET ShardID = '64

'

و دي في الـــSRO_VT_SHARD

كود بلغة HTML:

USE [SRO_VT_SHARD]

GO

TRUNCATE TABLE [dbo].[_Chest]

TRUNCATE TABLE [dbo].[_ChestInfo]

TRUNCATE TABLE [dbo].[_User]

TRUNCATE TABLE [dbo].[_OpenMarket]

DELETE FROM [dbo].[_AccountJID] 

TRUNCATE TABLE [dbo].[_GuildWar]

TRUNCATE TABLE [dbo].[_GuildMember]

TRUNCATE TABLE [dbo].[_GuildChest]

TRUNCATE TABLE [dbo].[_SiegeFortressStruct]

TRUNCATE TABLE [dbo].[_SiegeFortressObject]

TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]

DELETE FROM [dbo].[_SiegeFortress]

INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)

INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)

INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)

UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'

DELETE FROM [dbo].[_Guild] WHERE ID > 0

DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0

TRUNCATE TABLE [dbo].[_InventoryForAvatar]

TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]

TRUNCATE TABLE [dbo].[_BlockedWhisperers]

TRUNCATE TABLE [dbo].[_TrainingCampMember]

TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]

DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0

TRUNCATE TABLE [dbo].[_TimedJob]

TRUNCATE TABLE [dbo].[_StaticAvatar]

TRUNCATE TABLE [dbo].[_Inventory]

TRUNCATE TABLE [dbo].[_Memo]

TRUNCATE TABLE [dbo].[_FleaMarketNetwork]

TRUNCATE TABLE [dbo].[_Friend]

TRUNCATE TABLE [dbo].[_CharSkillMastery]

TRUNCATE TABLE [dbo].[_CharSkill]

TRUNCATE TABLE [dbo].[_InvCOS]

DELETE FROM [dbo].[_CharCOS] WHERE ID > 0

DELETE FROM [dbo].[_Char] WHERE CharID > 0

TRUNCATE TABLE [dbo].[_CharCollectionBook]

TRUNCATE TABLE [dbo].[_CharInstanceWorldData]

TRUNCATE TABLE [dbo].[_CharNameList]

TRUNCATE TABLE [dbo].[_CharNickNameList]

TRUNCATE TABLE [dbo].[_CharQuest]

TRUNCATE TABLE [dbo].[_ClientConfig]

TRUNCATE TABLE [dbo].[_DeletedChar]

TRUNCATE TABLE [dbo].[_GPHistory]

TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage]

TRUNCATE TABLE [dbo].[_ItemPool]

DELETE FROM [dbo].[_Items] WHERE ID64 > 0

TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET]

TRUNCATE TABLE [dbo].[_TimedJobForPet]

TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]

TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)

INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)

EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]

DELETE FROM [dbo].[_TrainingCamp]

TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]

TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]

TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]

و دي في الـــSRO_VT_LOG

كود بلغة HTML:

USE [SRO_VT_LOG]

GO

TRUNCATE TABLE [dbo].[_LogCashItem]

TRUNCATE TABLE [dbo].[_LogEventChar]

TRUNCATE TABLE [dbo].[_LogEventItem]

TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]

TRUNCATE TABLE [dbo].[_LogSchedule]

TRUNCATE TABLE [dbo].[_LogServerEvent]