ط§ظ„ط¨ظ‚ط§ط، ظ…ط³ط¬ظ„ ط¯ط§ط¦ظ…ط¢
ط§ظ„ط¥ط¹ظ„ط§ظ†ط§طھ
قديم 12-10-2018, 07:35 AM   #1

#3mr
عضو مميز



الصورة الرمزية #3mr


• الانـتـسـاب » Aug 2009
• رقـم العـضـويـة » 63477
• المشـــاركـات » 684
• الـدولـة » أم الدنيــــا
• الـهـوايـة » Silkroad
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 17
#3mr صـاعـد

#3mr غير متواجد حالياً



افتراضي رد: مشكلة فى ال clean querys



أتفضل أعمل دول

كود:
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'
كود بلغة HTML:
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]


وده علشان log

كود:
USE [SRO_VT_SHARDLOG] 
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]


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


إعلانات google

قديم 12-10-2018, 11:34 AM   #2

testmis
عضو فعال





• الانـتـسـاب » Mar 2018
• رقـم العـضـويـة » 134646
• المشـــاركـات » 336
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
testmis صـاعـد

testmis غير متواجد حالياً



افتراضي رد: مشكلة فى ال clean querys



اقتباس:
المشاركة الأصلية كتبت بواسطة #3mr عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
[FONT="Comic Sans MS"][COLOR="DarkSlateBlue"][SIZE="3"][B]أتفضل أعمل دول
حضرتك فى ناس ادتنى Querys مختلفة ممكن حضرتك تفهمنى انى الاصح من التانى علشان انا مش عاوز اعمل اى حاجة غلط فى الداتا
SRO_VT_ACCOUNT
كود بلغة HTML:
USE [SRO_VT_ACCOUNT] 
GO 
TRUNCATE TABLE [dbo].[TB_User] 
TRUNCATE TABLE [dbo].[TB_User_Bak] 
TRUNCATE TABLE [dbo].[SK_CharRenameLog] 
TRUNCATE TABLE [dbo].[_Punishment] 
TRUNCATE TABLE [dbo].[_ServiceManagerLog] 
TRUNCATE TABLE [dbo].[Test_HN] 
TRUNCATE TABLE [dbo].[_BlockedUser] 
TRUNCATE TABLE [dbo].[_CasGMChatLog] 
TRUNCATE TABLE [dbo].[_Notice] 
TRUNCATE TABLE [dbo].[_SMCLog] 
TRUNCATE TABLE [dbo].[QuaySoEpoint] 
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_SilkGoods] 
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_paygate_trans]
SRO_VT_SHARD
كود بلغة HTML:
USE [SRO_VT_SHARD] 
GO 
truncate table _OpenMarket 
print 'Cleaned _OpenMarket' 
truncate table _CharSkill 
print 'Cleaned _CharSkill' 
truncate table _CharSkillMastery 
print 'Cleaned _CharSkillMastery' 
truncate table _GuildMember 
print 'Cleaned _GuildMember' 
truncate table _BlockedWhisperers 
print 'Cleaned _BlockedWhisperers' 
truncate table _Inventory 
print 'Cleaned _Inventory' 
truncate table _InventoryForAvatar 
print 'Cleaned _InventoryForAvatar' 
truncate table _InventoryForLinkedStorage 
print 'Cleaned _InventoryForLinkedStorage' 
truncate table _TrainingCampMember 
print 'Cleaned _TrainingCampMember' 
truncate table _TrainingCampSubMentorHonorPoint 
print 'Cleaned _TrainingCampSubMentorHonorPoint' 
update _TrainingCampHonorRank set CampID = NULL, Rank = NULL 
print 'Cleaned _TrainingCampHonorRank' 
truncate table _TrainingCampBuffStatus 
print 'Cleaned _TrainingCampBuffStatus' 
delete from _TrainingCamp 
print 'Cleaned _TrainingCamp' 
truncate table _StaticAvatar 
print 'Cleaned _StaticAvatar' 
truncate table _User 
print 'Cleaned _User' 
truncate table _Friend 
print 'Cleaned _Friend' 
truncate table _Memo 
print 'Cleaned _Memo' 
truncate table _TimedJob 
print 'Cleaned _TimedJob' 
truncate table _CharTrijobSafeTrade 
print 'Cleaned _CharTrijobSafeTrade' 
delete from _CharTrijob 
print 'Cleaned _CharTrijob' 
truncate table _InvCOS 
print 'Cleaned _InvCOS' 
delete from _CharCOS where ID > 0 
print 'Cleaned _CharCOS' 
delete from _Char where charid > 0 
print 'Cleaned _Char' 
truncate table _Chest 
print 'Cleaned _Chest' 
truncate table _ChestInfo 
print 'Cleaned _ChestInfo' 
truncate table _ItemPool 
print 'Cleaned _ItemPool' 
delete from _Items where ID64 > 0 
print 'Cleaned _Items' 
delete from _AccountJID 
print 'Cleaned _AccountJID' 
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 
print 'Cleaned _AlliedClans' 
truncate table _GuildWar 
print 'Cleaned _GuildWar' 
truncate table _CharNameList 
print 'Cleaned _CharNameList' 
truncate table _CharQuest 
print 'Cleaned _CharQuest' 
truncate table _ClientConfig 
print 'Cleaned _ClientConfig' 
truncate table _DeletedChar 
print 'Cleaned _DeletedChar' 
truncate table _SiegeFortressStoneState 
print 'Cleaned _SiegeFortressStoneState' 
truncate table _SiegeFortressRequest 
print 'Cleaned _SiegeFortressRequest' 
truncate table _SiegeFortressObject 
print 'Cleaned _SiegeFortressObject' 
truncate table _SiegeFortressItemForge 
print 'Cleaned _SiegeFortressItemForge' 
truncate table _SiegeFortressBattleRecord 
print 'Cleaned _SiegeFortressBattleRecord' 
update _SiegeFortressStruct SET OwnerGuildID = '0' 
print 'Cleaned _SiegeFortressStruct' 
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL 
print 'Cleaned _SiegeFortress' 
truncate table _CharNickNameList 
print 'Cleaned _CharNickNameList' 
truncate table _GPHistory 
print 'Cleaned _GPHistory' 
truncate table _GuildChest 
print 'Cleaned _GuildChest' 
delete from _Guild where ID > 0 
print 'Cleaned _Guild' 
delete from _AlliedClans where ID > 0 
print 'Cleaned _AlliedClans'




قديم 12-10-2018, 05:05 PM   #3

Scrox
عضو لامع



الصورة الرمزية Scrox


• الانـتـسـاب » Apr 2017
• رقـم العـضـويـة » 132672
• المشـــاركـات » 1,355
• الـدولـة » GB
• الـهـوايـة » miMobXD
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 38
Scrox صـاعـد

Scrox غير متواجد حالياً


إرسال رسالة عبر ICQ إلى Scrox إرسال رسالة عبر AIM إلى Scrox إرسال رسالة عبر Yahoo إلى Scrox

افتراضي رد: مشكلة فى ال clean querys



اقتباس:
المشاركة الأصلية كتبت بواسطة testmis عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
حضرتك فى ناس ادتنى Querys مختلفة ممكن حضرتك تفهمنى انى الاصح من التانى علشان انا مش عاوز اعمل اى حاجة غلط فى الداتا
SRO_VT_ACCOUNT
كود بلغة HTML:
USE [SRO_VT_ACCOUNT] 
GO 
TRUNCATE TABLE [dbo].[TB_User] 
TRUNCATE TABLE [dbo].[TB_User_Bak] 
TRUNCATE TABLE [dbo].[SK_CharRenameLog] 
TRUNCATE TABLE [dbo].[_Punishment] 
TRUNCATE TABLE [dbo].[_ServiceManagerLog] 
TRUNCATE TABLE [dbo].[Test_HN] 
TRUNCATE TABLE [dbo].[_BlockedUser] 
TRUNCATE TABLE [dbo].[_CasGMChatLog] 
TRUNCATE TABLE [dbo].[_Notice] 
TRUNCATE TABLE [dbo].[_SMCLog] 
TRUNCATE TABLE [dbo].[QuaySoEpoint] 
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_SilkGoods] 
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_paygate_trans]
SRO_VT_SHARD
كود بلغة HTML:
USE [SRO_VT_SHARD] 
GO 
truncate table _OpenMarket 
print 'Cleaned _OpenMarket' 
truncate table _CharSkill 
print 'Cleaned _CharSkill' 
truncate table _CharSkillMastery 
print 'Cleaned _CharSkillMastery' 
truncate table _GuildMember 
print 'Cleaned _GuildMember' 
truncate table _BlockedWhisperers 
print 'Cleaned _BlockedWhisperers' 
truncate table _Inventory 
print 'Cleaned _Inventory' 
truncate table _InventoryForAvatar 
print 'Cleaned _InventoryForAvatar' 
truncate table _InventoryForLinkedStorage 
print 'Cleaned _InventoryForLinkedStorage' 
truncate table _TrainingCampMember 
print 'Cleaned _TrainingCampMember' 
truncate table _TrainingCampSubMentorHonorPoint 
print 'Cleaned _TrainingCampSubMentorHonorPoint' 
update _TrainingCampHonorRank set CampID = NULL, Rank = NULL 
print 'Cleaned _TrainingCampHonorRank' 
truncate table _TrainingCampBuffStatus 
print 'Cleaned _TrainingCampBuffStatus' 
delete from _TrainingCamp 
print 'Cleaned _TrainingCamp' 
truncate table _StaticAvatar 
print 'Cleaned _StaticAvatar' 
truncate table _User 
print 'Cleaned _User' 
truncate table _Friend 
print 'Cleaned _Friend' 
truncate table _Memo 
print 'Cleaned _Memo' 
truncate table _TimedJob 
print 'Cleaned _TimedJob' 
truncate table _CharTrijobSafeTrade 
print 'Cleaned _CharTrijobSafeTrade' 
delete from _CharTrijob 
print 'Cleaned _CharTrijob' 
truncate table _InvCOS 
print 'Cleaned _InvCOS' 
delete from _CharCOS where ID > 0 
print 'Cleaned _CharCOS' 
delete from _Char where charid > 0 
print 'Cleaned _Char' 
truncate table _Chest 
print 'Cleaned _Chest' 
truncate table _ChestInfo 
print 'Cleaned _ChestInfo' 
truncate table _ItemPool 
print 'Cleaned _ItemPool' 
delete from _Items where ID64 > 0 
print 'Cleaned _Items' 
delete from _AccountJID 
print 'Cleaned _AccountJID' 
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 
print 'Cleaned _AlliedClans' 
truncate table _GuildWar 
print 'Cleaned _GuildWar' 
truncate table _CharNameList 
print 'Cleaned _CharNameList' 
truncate table _CharQuest 
print 'Cleaned _CharQuest' 
truncate table _ClientConfig 
print 'Cleaned _ClientConfig' 
truncate table _DeletedChar 
print 'Cleaned _DeletedChar' 
truncate table _SiegeFortressStoneState 
print 'Cleaned _SiegeFortressStoneState' 
truncate table _SiegeFortressRequest 
print 'Cleaned _SiegeFortressRequest' 
truncate table _SiegeFortressObject 
print 'Cleaned _SiegeFortressObject' 
truncate table _SiegeFortressItemForge 
print 'Cleaned _SiegeFortressItemForge' 
truncate table _SiegeFortressBattleRecord 
print 'Cleaned _SiegeFortressBattleRecord' 
update _SiegeFortressStruct SET OwnerGuildID = '0' 
print 'Cleaned _SiegeFortressStruct' 
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL 
print 'Cleaned _SiegeFortress' 
truncate table _CharNickNameList 
print 'Cleaned _CharNickNameList' 
truncate table _GPHistory 
print 'Cleaned _GPHistory' 
truncate table _GuildChest 
print 'Cleaned _GuildChest' 
delete from _Guild where ID > 0 
print 'Cleaned _Guild' 
delete from _AlliedClans where ID > 0 
print 'Cleaned _AlliedClans'
حاضرك الكويرى دى بتمسح جميع الاكونت و ftw بعد ما تعملهم تقفل الجيم سيرفر وتفتحوا تانى مش هتلقى اى حاجة موجودة فى الجيم


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


موضوع مغلق


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

ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع

المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى الردود آخر مشاركة
querys forlove2020 قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 6 18-11-2018 08:17 PM
مشكلة في فتح اللعبة Clean-Sro eslamsaied قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 2 14-04-2018 09:05 PM
[C-SRo] Database Cleaning Querys By Black_Shield Black Shield قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة 8 03-12-2017 03:12 AM
شوية Querys هتساعدك جامد Mr.Serag قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة 18 28-09-2014 12:50 PM


الساعة الآن 09:39 AM.