05-01-2013, 09:03 PM
|
#2
|
|
• الانـتـسـاب » Nov 2009
|
• رقـم العـضـويـة » 66029
|
• المشـــاركـات » 278
|
• الـدولـة »
|
• الـهـوايـة »
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
كود PHP:
USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE _SiegeFortressObject
TRUNCATE TABLE _SiegeFortressBattleRecord
TRUNCATE TABLE _SiegeFortressRequest
TRUNCATE TABLE _SiegeFortressStoneState
كود PHP:
USE [SRO_VT_SHARD]
GO
DELETE FROM _SiegeFortressStruct
WHERE RefObjID IN (SELECT [ID] FROM _RefObjCommon WITH (NOLOCK) WHERE TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 5 AND TypeID4 = 6)
UPDATE _SiegeFortressStruct SET OwnerGuildID=0
UPDATE _SiegeFortress SET GuildID=0, TaxRatio=0, Tax=0, NPCHired=0, TempGuildID=0, Introduction=NULL,
CreatedDungeonTime=NULL, CreatedDungeonCount=NULL, IntroductionModificationPermission=1
|
|
|