• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Sql Query for Clean Blues From Avatar

Experienced Elementalist
Joined
Jul 1, 2012
Messages
215
Reaction score
83
^^ about mag options exploit's i hate this
i made this short query before buy Supermike
Clean Blue's from all avatars in DB
PHP:
USE SHARD_DB
UPDATE _Items SET MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL
WHERE RefItemID  in (SELECT ID FROM _RefObjCommon WHERE  TypeID1 = 3 and TypeID2 = 1 and TypeID3 = 13 and TypeID4 in (1,2,3) and Country = 3)
Just Exec and have Fun :D
Thx :D
 
Newbie Spellweaver
Joined
Apr 3, 2014
Messages
86
Reaction score
22
Can make a scroll to it and trigger the query in the log items.
 
Back
Top