|
You last visited: Today at 22:54
Advertisement
[Release] MSSQL Script for Setting RARE (SOX) Rates with ease!
Discussion on [Release] MSSQL Script for Setting RARE (SOX) Rates with ease! within the SRO Private Server forum part of the Silkroad Online category.
10/26/2011, 11:53
|
#1
|
elite*gold: 0 
Join Date: Aug 2010
Posts: 346
Received Thanks: 416
|
[Release] MSSQL Script for Setting RARE (SOX) Rates with ease!
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
|
#2
|
elite*gold: 0
Join Date: Oct 2011
Posts: 166
Received Thanks: 244
|
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
|
#3
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,390
Received Thanks: 6,508
|
Quote:
Originally Posted by Reality_xXx
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
|
#4
|
elite*gold: 0
Join Date: Oct 2011
Posts: 166
Received Thanks: 244
|
Quote:
Originally Posted by PortalDark
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 
|
|
|
|
|
10/26/2011, 18:14
|
#5
|
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,390
Received Thanks: 6,508
|
Quote:
Originally Posted by Reality_xXx
Well, if you realized just now that our forum is filled with about 90% leechers then you're crazy boy |
ohh, boy to think that
you poor thing
is 99% leechers
and, no, it was always like this, Server files or not
|
|
|
|
|
10/26/2011, 19:26
|
#6
|
elite*gold: 0
Join Date: Oct 2011
Posts: 166
Received Thanks: 244
|
Quote:
Originally Posted by PortalDark
ohh, boy to think that
you poor thing
is 99% leechers
and, no, it was always like this, Server files or not
|
Hehe, sure it always been like this.
Just now you feel it stronger.
|
|
|
|
|
10/26/2011, 19:46
|
#7
|
elite*gold: 0
Join Date: Jun 2009
Posts: 48
Received Thanks: 9
|
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
|
#8
|
elite*gold: 0
Join Date: Sep 2008
Posts: 38
Received Thanks: 6
|
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
|
#9
|
elite*gold: 0
Join Date: Aug 2010
Posts: 346
Received Thanks: 416
|
Quote:
Originally Posted by spartai333
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 - 
|
|
|
|
|
10/27/2011, 01:13
|
#10
|
elite*gold: 0
Join Date: Feb 2008
Posts: 1,641
Received Thanks: 358
|
Joymax need u
|
|
|
|
|
10/27/2011, 04:00
|
#11
|
elite*gold: 844
Join Date: Oct 2010
Posts: 839
Received Thanks: 192
|
can someone help me with TeamV please guys i have alill problem
|
|
|
|
|
10/27/2011, 09:03
|
#12
|
elite*gold: 0
Join Date: Dec 2010
Posts: 384
Received Thanks: 152
|
Quote:
Originally Posted by mats0o0o0
can someone help me with TeamV please guys i have alill problem
|
what is ur problem?
|
|
|
|
|
10/27/2011, 09:37
|
#13
|
elite*gold: 0
Join Date: Apr 2009
Posts: 1,715
Received Thanks: 892
|
This guy is thze kinq 
|
|
|
|
|
10/27/2011, 10:33
|
#14
|
elite*gold: 0
Join Date: Jun 2009
Posts: 3,448
Received Thanks: 2,330
|
Default SoX rates are 1?
|
|
|
|
|
10/27/2011, 12:59
|
#15
|
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,390
Received Thanks: 6,508
|
Quote:
Originally Posted by mats0o0o0
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
|
|
|
|
 |
Similar Threads
|
[Release]CLEAN database + MSSQL cleaning script
11/02/2020 - Dekaron Private Server - 31 Replies
My 666th post!
Ok, so I know everyone is expecting the IPbanV2/3 from me as my next release, but I decided I will do this first, because it took me a lot less time.
LINK (megaupload)
ALL info is deleted, except what is required to run the server with all functions like in the silkbotter's database. Tested by myself, and working.
NOTE: Siege is not added, but you can add it easily with the script. I didn't add siege, because I thought that you will want to set the start time like you...
|
MSSQL Reg script fehler
02/05/2011 - Flyff Private Server - 2 Replies
wenn ich die sql vom reg script aus führe er halte ich immer als error muss ich die acc tabele vorher leeren...? wäre schade
hab ihr vielleicht lösungen ?
Naja ich geh nu erst mal pennen^^ bis morgen
|
MSSQL Script to ban players
02/03/2011 - Shaiya PServer Development - 6 Replies
Hi.
Is there any1 who has a mssql player ban scipt by char name?
Or maybe by account name?
So a script that changes the status of a player to -5 ?
Thank You.
|
Setting mob rates in Interlude
02/11/2010 - Lin2 Private Server - 1 Replies
I have a Pserver going now for my own use and my kid wants to play on it. when i log a Mystic on it is impossible for it to kill level 1 mobs, Why??? can someone tell me how to make mobs easier to kill. Or just tell me how to make mystics able to kill them in this p server.
|
Setting rates
02/06/2010 - Metin2 Private Server - 0 Replies
Hey! - I don't understand this with setting my rates.. i want to set them like it is like the normal metin2 but i don't understand this MAKRO?
Can anyone help me over teamviewer or just tell me how to do this?
I really need help
Btw i tried to do it some times and i even asked the owner of the Rate set thread but he didn't answer yet..
so can anyone please help me?
-Nicklas
|
All times are GMT +1. The time now is 22:55.
|
|
![[Release] MSSQL Script for Setting RARE (SOX) Rates with ease!](https://www.elitepvpers.com/forum/iconimages/sro-private-server/release-mssql-script-setting-rare-sox-rates-ease_ltr.gif){kind=small}
