[Release] Sql Query for Clean Blues From Avatar

[xxnukertube]

^^ 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 Code:

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
Thx

[Supportlar]

keep on,

[Jimmy*]

no offense but kinda useless you'll clean it up once then they will use it once again.
will u be just using this query all day long ?

[xxnukertube]

Originally Posted by Jimmy*

no offense but kinda useless you'll clean it up once then they will use it once again.
will u be just using this query all day long ?

if ur server now protected from exploits and was not protected maybe have avatar's with unsuportable blues
thx

[​Goofie​]

Originally Posted by xxnukertube

if ur server now protected from exploits and was not protected maybe have avatar's with unsuportable blues
thx

Good release, keep it up. Do not mind these people.

[xxnukertube]

Originally Posted by ​Goofie​

Good release, keep it up. Do not mind these people.

Yes, I'll keep it, maybe it can help someone.
thank you

[Justin1337*]

Originally Posted by ​Goofie​

Good release, keep it up. Do not mind these people.

+1 no matter what you release there's always gonna be hatters, so just ignore them and keep sharing.

[xxxnukertube]

Originally Posted by Justin1337*

+1 no matter what you release there's always gonna be hatters, so just ignore them and keep sharing.

yeah i know
btw thx

[undermaker4535]

i dont get it.
is this code to fix this exploit of adding unsupportable blues?

[​Goofie​]

Originally Posted by undermaker4535

i dont get it.
is this code to fix this exploit of adding unsupportable blues?

No, but let's say you have a live server and didn't have the exploit fix, people will still have the blues on their avatars which is bugged, if you run this query all avatars will be clean from blues and players need to re-add their avatar blues.

[chronyc]

well released, simply ignore those hater pro coders which dont like your way of resetting those avatar blues.

[xxnukertube]

yes, keep shared

[xxnukertube]

Originally Posted by undermaker4535

i dont get it.
is this code to fix this exploit of adding unsupportable blues?

just remove blue from all avatar

[xxnukertube]

Originally Posted by chronyc

well released, simply ignore those hater pro coders which dont like your way of resetting those avatar blues.

ofc