| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
04-08-2013, 09:36 PM
|
#1 | ||||||||||
 
|
يا رجاله انا كل ما اجى اعمل اكونت يجيلى كدا و shard manger بيعمل كدا والسيرفر بيقفل الصوره للتوضيح ارجو المساعده  عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||
|
|
| إعلانات google |
|
|
|
04-08-2013, 10:27 PM
|
#2 | ||||||||||
  
|
ده سببه ان حضرتك مستخدم داتا بيس كان حد شغال بيها قبلك مش 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 كود:
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 كود:
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' كود:
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]
كود:
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] |
||||||||||
|
|
|
04-08-2013, 10:33 PM
|
#3 | ||||||||||
  
|
the wrong only in _AddNewChar |
||||||||||
|
|
|
05-08-2013, 03:29 AM
|
#4 | ||||||||||
|
طيب الحل يا انس ايه انا عايز حل يا جدعان المشكله دى مش مخليانى اعرف افتح اللعبه  |
||||||||||
|
|
|
05-08-2013, 03:31 AM
|
#5 | ||||||||||
 
|
اعمل resture وجرب تاني ثانيا داتا بيز ايه |
||||||||||
|
|
|
05-08-2013, 03:48 AM
|
#6 | ||||||||||
|
Database and Client Blue Sro انا بصراحه اتخنقت منها ياريت داتا Evoutlion يبقى ميا ميا |
||||||||||
|
|
|
05-08-2013, 11:48 AM
|
#7 | ||||||||||
|
إتفضل عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||
|
|
|
05-08-2013, 09:39 PM
|
#8 | ||||||||||
|
يغلق |
||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه
|
||||
| الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
| مساعده 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 |
.gif){kind=icon}
.gif){kind=icon}
العرض العادي
