|
You last visited: Today at 15:42
Advertisement
[Release] Sql Query for Clean Blues From Avatar
Discussion on [Release] Sql Query for Clean Blues From Avatar within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
02/10/2016, 03:08
|
#1
|
elite*gold: 0 
Join Date: May 2010
Posts: 579
Received Thanks: 166
|
[Release] Sql Query for Clean Blues From Avatar
^^ 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
|
|
|
|
02/10/2016, 03:21
|
#2
|
elite*gold: 0
Join Date: Jan 2016
Posts: 81
Received Thanks: 15
|
keep on,
|
|
|
|
|
02/10/2016, 10:06
|
#3
|
elite*gold: 10
Join Date: May 2013
Posts: 1,986
Received Thanks: 1,154
|
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
|
#4
|
elite*gold: 0
Join Date: May 2010
Posts: 579
Received Thanks: 166
|
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
|
#5
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,444
Received Thanks: 1,373
|
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
|
#6
|
elite*gold: 0
Join Date: May 2010
Posts: 579
Received Thanks: 166
|
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
|
#7
|
elite*gold: 480
Join Date: Jan 2012
Posts: 655
Received Thanks: 579
|
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
|
#8
|
elite*gold: 0
Join Date: Jun 2010
Posts: 49
Received Thanks: 2
|
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
|
#9
|
elite*gold: 0
Join Date: Aug 2009
Posts: 71
Received Thanks: 5
|
i dont get it.
is this code to fix this exploit of adding unsupportable blues?
|
|
|
|
|
02/15/2016, 07:00
|
#10
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,444
Received Thanks: 1,373
|
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
|
#11
|
elite*gold: 0
Join Date: Jan 2016
Posts: 322
Received Thanks: 71
|
well released, simply ignore those hater pro coders which dont like your way of resetting those avatar blues.
|
|
|
|
|
02/17/2016, 01:23
|
#12
|
elite*gold: 0
Join Date: May 2010
Posts: 579
Received Thanks: 166
|
yes, keep shared
|
|
|
|
|
08/23/2016, 14:45
|
#13
|
elite*gold: 0
Join Date: May 2010
Posts: 579
Received Thanks: 166
|
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
|
|
|
|
 |
Similar Threads
|
bug adding unsupported blues to avatar
02/24/2019 - SRO Private Server - 14 Replies
Hello,
there is some kind of new bug where you can add unsupported blues to avatars.
Example: you can add only 1 STR on your hat avatar but some how someone can add 3 STR which is not showing if you try to add the blues from blacksmith.
Or adding Resistance 30% on all set on the avatar attachment which is also not supported by the default blues. I checked refmagicopt and refmagicoptassign but everything looks normal.
picture showing this blues added.
http://i.imgur.com/h0NZA0z.jpg
|
Silkroad Avatar Blues
09/20/2014 - Silkroad Online - 0 Replies
im bow/fire/force and i want to know what blues i should add to my avatar for FTW PVP ...
|
[Question]Avatar Blues For Wizard/Cleric
10/30/2008 - Silkroad Online - 3 Replies
I just bought Angel wings for my Wizard/Cleric. Chose 3 blues already, 1% ignore mobs defense, int1, damage 5%. now my other choices I can't pick are hp150 or attack rating 5%..
What should I get , and why? ^^
|
[Help] Avatar Items multi blues
07/18/2008 - Silkroad Online - 5 Replies
dose anyone know if "HP 25% recovery increse" has effect when you drink potions? i mean, do you gain 125 HP when you are supposed to gain 100?? And 1 more thing, if you have HP 25% recovery on both your dress and attachment, do you get 50% HP recovery increase intotal?? like, you get 150 HP when you are supposed to get 100 when you drink pots
|
[Help] Avatar Items multi blues
07/17/2008 - Silkroad Online - 1 Replies
dose anyone know if "HP 25% recovery increse" has effect when you drink potions? i mean, do you gain 125 HP when you are supposed to gain 100?? And 1 more thing, if you have HP 25% recovery on both your dress and attachment, do you get 50% HP recovery increase intotal?? like, you get 150 HP when you are supposed to get 100 when you drink pots
|
All times are GMT +1. The time now is 15:43.
|
|
![[Release] Sql Query for Clean Blues From Avatar](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-sql-query-clean-blues-avatar_ltr.gif){kind=avatar}
