[Release] Sql Query for Clean Blues From Avatar

02/10/2016 03:08 xxnukertube#1

^^ 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 :D
Thx :D

02/10/2016 03:21 Supportlar#2

keep on,

02/10/2016 10:06 Jimmy*#3

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 ?

02/10/2016 20:31 xxnukertube#4

Quote:

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

02/10/2016 23:57 Goofie#5

Quote:

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.

02/11/2016 00:48 xxnukertube#6

Quote:

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

02/11/2016 08:20 Justin1337*#7

Quote:

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. ;)

02/13/2016 06:03 xxxnukertube#8

Quote:

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

02/14/2016 22:52 undermaker4535#9

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

02/15/2016 07:00 Goofie#10

Quote:

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.

02/16/2016 18:10 chronyc#11

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

02/17/2016 01:23 xxnukertube#12

yes, keep shared

08/23/2016 14:45 xxnukertube#13

Quote:

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