/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_SHARDDB]
GO
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_OpenMarket]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
DELETE FROM [dbo].[_TrainingCamp]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
DELETE FROM [dbo].[_CharTrijob]
TRUNCATE TABLE [dbo].[_InvCOS]
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DELETE FROM [dbo].[_TradeEquipInventory] WHERE charid > 0
DELETE FROM [dbo].[_TradeBagInventory] WHERE charid > 0
DELETE FROM [dbo].[_CharAlchemy_MK_Recipe] WHERE charid > 0
DELETE FROM [dbo].[_Char] WHERE charid > 0
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_ItemPool]
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
DELETE FROM [dbo].[_AccountJID]
TRUNCATE TABLE [dbo].[_GuildChest]
UPDATE [dbo].[_AlliedClans] set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
TRUNCATE TABLE [dbo].[_GuildWar]
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_SiegeFortressStruct]
TRUNCATE TABLE [dbo].[_SiegeFortressStoneState]
TRUNCATE TABLE [dbo].[_SiegeFortressRequest]
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
TRUNCATE TABLE [dbo].[_SiegeFortressBattleRecord]
DELETE FROM [dbo].[_SiegeFortress]
TRUNCATE TABLE [dbo].[_UserTradeConflictJob]
---[SRO_FEIER_SHARDDB_LOG]---
كود PHP:
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_SHARDDB_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].[_LogWebCashItem]
ودى صورة مهمه يا رجاله عشان فى ناس لسه بتجرب C-Sro
iD Vsro = 22
اما
iD C-Sro= 34
دى بتحل مشكله C8 الى الناس بتقبل بعض الناس
يتبع .......
احب ازود على كلامك لو انت واخد الداتا من حمزة متعملش الكويرى دى لو مش من حمزة اعمها
و حاجة اخيرة ال ver :106 مش 107 لان احنا عملنا تحديث من 106 ل 107 افتكر كويس
كود PHP:
USE SRO_R_Accountdb UPDATE _ModuleVersion
SET nContentID = 34
التعديل الأخير تم بواسطة Dev.Klito ; 30-11-2016 الساعة 10:43 AM
30-11-2016, 01:26 AM
المواضيع المتشابهه
.gif){kind=icon}
العرض المتطور
