[Release] MSSQL Script for Setting RARE (SOX) Rates with ease!

10/26/2011 11:53 Miki Maus#1
Code:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10 // by Artuuro_lv (rz)/Miki Maus (epvp)
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
Change the SET @RATE = 10 - "10" to the value you would like your rates to be multiplied and execute.
Have fun.
Script created by me - do not re-relase under your name.
And remember - giving thanks is the way to awesomeness!
10/26/2011 14:19 Reality_xXx#2
And once again you're improving your kindness, even that I find it useless I'm glad to see that there are people which willing to help like me and some others in this forum.
10/26/2011 14:54 PortalDark#3
Quote:
Originally Posted by Reality_xXx View Post
And once again you're improving your kindness, even that I find it useless I'm glad to see that there are people which willing to help like me and some others in this forum.
that because many of ppl here are a little selfish to release stuff
agree that ppl should find out about stuff by themselves, but a little help works
10/26/2011 18:09 Reality_xXx#4
Quote:
Originally Posted by PortalDark View Post
that because many of ppl here are a little selfish to release stuff
agree that ppl should find out about stuff by themselves, but a little help works
Well, if you realized just now that our forum is filled with about 90% leechers then you're crazy boy :awesome:
10/26/2011 18:14 PortalDark#5
Quote:
Originally Posted by Reality_xXx View Post
Well, if you realized just now that our forum is filled with about 90% leechers then you're crazy boy :awesome:
ohh, boy to think that
you poor thing
10/26/2011 19:26 Reality_xXx#6
Quote:
Originally Posted by PortalDark View Post
ohh, boy to think that
you poor thing
Hehe, sure it always been like this.
Just now you feel it stronger.
10/26/2011 19:46 spartai333#7
How should we use theese scripts? Because everyone release just a code. And if we ask how to use, everybody answers that we are noobs. So please tell me how to use this script thanks.
10/27/2011 00:00 sonsen#8
For those who dont know how to "use" it. New query(Shard Db)-> Execute. If your Shard db has a different name change this USE SRO_VT_SHARD to USE Your_Shard_DB.
10/27/2011 00:22 Miki Maus#9
Quote:
Originally Posted by spartai333 View Post
How should we use theese scripts? Because everyone release just a code. And if we ask how to use, everybody answers that we are noobs. So please tell me how to use this script thanks.
you're noob. atleast l2use google if you dont know anything - [Only registered and activated users can see links. Click Here To Register...]
10/27/2011 01:13 Rosalinda#10
Joymax need u
10/27/2011 04:00 Keyeight#11
can someone help me with TeamV please guys i have alill problem
10/27/2011 09:03 Dragonz2105#12
Quote:
Originally Posted by mats0o0o0 View Post
can someone help me with TeamV please guys i have alill problem
what is ur problem?
10/27/2011 09:37 FoxRayz#13
This guy is thze kinq :D
10/27/2011 10:33 dimkacool#14
Default SoX rates are 1?
10/27/2011 12:59 PortalDark#15
Quote:
Originally Posted by mats0o0o0 View Post
can someone help me with TeamV please guys i have alill problem
cool bro, posting here and sending pms to random ppl sure will help