SR__GameServer :S

[MeMo@Love]

اعمل كلين للداتا بيس اتفضل اعمل دول فى كويري

USE [SRO_VT_SHARD] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_ExistsServiceOffRentItem] as if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) ) begin return -1 end GO

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]