12-01-2016, 04:19 AM
#1
• الانـتـسـاب » May 2011
• رقـم العـضـويـة » 87556
• المشـــاركـات » 3,424
• الـدولـة » In My Own World
• الـهـوايـة » DBA, C#, APS.NET
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 663
[C-SRo] Database Cleaning Querys By Black_Shield
ازيكم يا شباب
الموضوع باين من عنوانه الـQuerys ديه عشان تمسح الداته القديمه في الـDatabase بتاعت C-Sro Files
الموضوع مش مهم قوي دلوقتي بس هايفيد الناس بعد كده لما تنتشر الـ C-Sro Databases
لو جربتم الكويريس الي معموله ل Vsro هتلاقوا فيها Errors
انا ظبطها و صلحت موضوع الـ Errors ده و بقت متظبطه لل C-Sro Files DB
---[SRO_FEIER_AcCcountdb]---
كود PHP:
/****** 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]---
كود PHP:
/****** 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]---
كود PHP:
/****** 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 ]
دمتم,,
توقيع Black Shield
:
اللَّهُمَّ أَنْتَ رَبِّي ، لا إِلَه إِلاَّ أَنْتَ خَلَقْتَني وأَنَا عَبْدُكَ ، وأَنَا على عهْدِكَ ووعْدِكَ ما اسْتَطَعْتُ ،
أَعُوذُ بِكَ مِنْ شَرِّ ما صنَعْتُ ، أَبوءُ لَكَ بِنِعْمتِكَ علَيَ ، وأَبُوءُ بذَنْبي فَاغْفِرْ لي ، فَإِنَّهُ لا يغْفِرُ الذُّنُوبِ إِلاَّ أَنْتَ
تريخ الأنضمام الفعلي Oct 2008 بعضوية عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تاريخ الخروج Dec 17 2016
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]