عرض مشاركة واحدة
قديم 12-10-2018, 07:35 AM   #2

#3mr
عضو مميز



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


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

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

4279  


إرسال رسالة عبر Skype إلى #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 :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]