Black Shield
12-01-2016, 04:19 AM
ازيكم يا شباب
الموضوع باين من عنوانه الـQuerys ديه عشان تمسح الداته القديمه في الـDatabase بتاعت C-Sro Files
الموضوع مش مهم قوي دلوقتي بس هايفيد الناس بعد كده لما تنتشر الـ C-Sro Databases
لو جربتم الكويريس الي معموله ل Vsro هتلاقوا فيها Errors
انا ظبطها و صلحت موضوع الـ Errors ده و بقت متظبطه لل C-Sro Files DB
---[SRO_FEIER_AcCcountdb]---
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_AcCcountdb] //*By Black Shield*//
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_PrivilegedIP]
---[SRO_FEIER_SHARDDB]---
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_SHARDDB] //*By Black Shield*//
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]---
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_SHARDDB_LOG] //*By Black Shield*//
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]
دمتم,,
الموضوع باين من عنوانه الـQuerys ديه عشان تمسح الداته القديمه في الـDatabase بتاعت C-Sro Files
الموضوع مش مهم قوي دلوقتي بس هايفيد الناس بعد كده لما تنتشر الـ C-Sro Databases
لو جربتم الكويريس الي معموله ل Vsro هتلاقوا فيها Errors
انا ظبطها و صلحت موضوع الـ Errors ده و بقت متظبطه لل C-Sro Files DB
---[SRO_FEIER_AcCcountdb]---
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_AcCcountdb] //*By Black Shield*//
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_PrivilegedIP]
---[SRO_FEIER_SHARDDB]---
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_SHARDDB] //*By Black Shield*//
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]---
/****** Object: Cleaning [SRO_FEIER_AcCcountdb] By Black Shield Script Date: 1/12/2016 3:13:09 AM ******/
USE [SRO_FEIER_SHARDDB_LOG] //*By Black Shield*//
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]
دمتم,,