الموقع العربي الاول للعبة Silkroad Online

- قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)

- - حاجة غريبة ومحيرانى (https://silkroad4arab.com/vb/showthread.php?t=490155)

حاجة غريبة ومحيرانى

هما مشكلتين المشكلة الاولى

https://fbcdn-sphotos-h-a.akamaihd.n...34253715_n.jpg

دخلت PrivilegedIP لقبت كل ده وانا لسة منزلو دلوقتى اعمل فيهم اى عشان اكتب الاى بى بتاعى

المشكلة التانية
https://fbcdn-sphotos-d-a.akamaihd.n...54396573_n.jpg

دخلت فى TB_User لقيت اسماء كتيرة ذى ما فى الصورة عندكو يريت حل للمشكلتين

استخدم دة

كود PHP:

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

و دة

كود PHP:

USE [SRO_VT_ACCOUNT] GO /****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DROP TABLE _PrivilegedIP GO CREATE TABLE [dbo].[_PrivilegedIP]( [IP1] [tinyint] NOT NULL, [IP2] [tinyint] NOT NULL, [IP3] [tinyint] NOT NULL, [IP4] [tinyint] NOT NULL, [IP5] [tinyint] NOT NULL, [IP6] [tinyint] NOT NULL, [IP7] [tinyint] NOT NULL, [IP8] [tinyint] NOT NULL ) ON [PRIMARY] GO

اعمل Clean للsro_vt_account استخدم دى

كود:

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

و استخدم دى

كود:

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