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

[MandoLove]

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





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

المشكلة التانية


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

[Mahmoud Rashwan]

استخدم دة

كود 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 


[Mahmoud Rashwan]

و دة

كود 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 


[BomBom]

اعمل 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