الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**Dr.Islam** · 02-04-2014, 02:05 AM

لما اجي امسع حاجات في الداتابيز [Shard] بيطلعلي الرسالة دي!

**ŜħēVØManser** · 02-04-2014, 02:06 AM

انت فاتح كويرى ولا حاجة ؟؟

**ŜħēVØManser** · 02-04-2014, 02:07 AM

اعمل كلين و اقفل sql و افتحه تانى و شيل

**Dr.Islam** · 02-04-2014, 02:14 AM

بردو نفس المشكلة , عندك Query يمسح من SRO_SV_ACCOUNT + SRO_VT_SHARD?

**Hamza FiGo** · 02-04-2014, 02:25 AM

Clean ACCOUNTS

كود:

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]

Clean Shard

كود:

USE SRO_VT_SHARD GO truncate table _CharSkill truncate table _CharSkillMastery truncate table _GuildMember truncate table _BlockedWhisperers truncate table _Inventory truncate table _InventoryForAvatar truncate table _InventoryForLinkedStorage truncate table _TrainingCampMember truncate table _TrainingCampSubMentorHonorPoint truncate table _TrainingCampHonorRank truncate table _TrainingCampBuffStatus delete from _TrainingCamp truncate table _StaticAvatar truncate table _User truncate table _Friend truncate table _Memo truncate table _TimedJob truncate table _CharTrijobSafeTrade delete from _CharTrijob truncate table _InvCOS delete from _CharCOS where ID > 0 delete from _Char where charid > 0 truncate table _Chest truncate table _ChestInfo truncate table _ItemPool delete from _Items where ID64 > 0 delete from _AccountJID truncate table _GuildChest update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 truncate table _GuildWar delete from _Guild where ID > 0 delete from _AlliedClans where ID > 0 truncate table _CharNameList truncate table _CharQuest truncate table _ClientConfig truncate table _DeletedChar truncate table _SiegeFortressStruct truncate table _SiegeFortressStoneState truncate table _SiegeFortressRequest truncate table _SiegeFortressObject truncate table _SiegeFortressItemForge truncate table _SiegeFortressBattleRecord delete from _SiegeFortress truncate table _OpenMarket

**Dr.Islam** · 02-04-2014, 02:26 AM

شكرا ياباشا

**Hamza FiGo** · 02-04-2014, 02:39 AM

انت تامر يا باشا. لم موضوعك اتحل . اعملة مجاب علشان يغلق

**iLead** · 02-04-2014, 10:39 AM

!!!

**iLead** · 02-04-2014, 10:39 AM

##

**Dr.Islam** · 02-04-2014, 07:23 PM

##

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

	حفظ بياناتي ؟

شـريـط الاهـداءات