الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**mostafa alrayk** · 04-08-2013, 09:36 PM

يا رجاله انا كل ما اجى اعمل اكونت يجيلى كدا و shard manger بيعمل كدا والسيرفر بيقفل الصوره للتوضيح ارجو المساعده

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**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]

**™Anas™** · 04-08-2013, 10:33 PM

the wrong only in _AddNewChar

**mostafa alrayk** · 05-08-2013, 03:29 AM

طيب الحل يا انس ايه انا عايز حل يا جدعان المشكله دى مش مخليانى اعرف افتح اللعبه

**TYKE** · 05-08-2013, 03:31 AM

اعمل resture وجرب تاني
ثانيا داتا بيز ايه

**mostafa alrayk** · 05-08-2013, 03:48 AM

Database and Client Blue Sro انا بصراحه اتخنقت منها ياريت داتا Evoutlion يبقى ميا ميا

**™Anas™** · 05-08-2013, 11:48 AM

إتفضل
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**TYKE** · 05-08-2013, 09:39 PM

يغلق

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
العرض العادي الانتقال إلى العرض المتطور الانتقال إلى العرض الشجري

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

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

	حفظ بياناتي ؟