الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**3ashek El7ozn** · 04-08-2013, 10:27 PM

ده سببه ان حضرتك مستخدم داتا بيس كان حد شغال بيها قبلك مش 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]

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
مساعده Shard Manger	BashA_Mn_Youme	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	24	05-07-2016 08:00 PM
مشكله في shard manger	zombi2011	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	19-01-2016 12:01 PM
Problem in Sr Shard Manger	ruxana	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	15-04-2014 02:23 AM
shard manger	V.I.P9	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	01-07-2012 12:53 AM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	تسجيل الدخول دائمآ