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

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

كود:

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]