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

ده سببه ان حضرتك مستخدم داتا بيس كان حد شغال بيها قبلك مش clean واللى عمل clean عمل للـ ACCOUNT_DB بس مكملش الـ SHARD والـ LOG
الحل يا تستخدم Query وتنضف بيها الداتا بيس كلها يا اما تنزل Clean DB من الموضوع المثبت

SRO_VT_ACCOUNT

كود:

USE [SRO_VT_ACCOUNT]

GO



SET ANSI_NULLS ON

GO



SET QUOTED_IDENTIFIER ON

GO



CREATE TABLE [dbo].[SK_gamebang_ip](

        [nID] [smallint] NOT NULL,

        [ip] [int] NOT NULL,

        [capacity] [smallint] NOT NULL

) ON [PRIMARY]



GO

SRO_VT_ACCOUNT

كود:

USE [SRO_VT_ACCOUNT]

GO



SET ANSI_NULLS ON

GO



SET QUOTED_IDENTIFIER ON

GO



DROP TABLE [dbo].[_PrivilegedIP]

GO



CREATE TABLE [dbo].[_PrivilegedIP](

        [IP1] [tinyint] NOT NULL,

        [IP2] [tinyint] NOT NULL,

        [IP3] [tinyint] NOT NULL,

        [IP4] [tinyint] NOT NULL,

        [IP5] [tinyint] NOT NULL,

        [IP6] [tinyint] NOT NULL,

        [IP7] [tinyint] NOT NULL,

        [IP8] [tinyint] NOT NULL

) ON [PRIMARY]



GO

SRO_VT_ACCOUNT

كود:

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

كود:

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

SRO_VT_SHARD

كود:

    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

كود:

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]