[Release] Vsro helpfull edit

Page 1 of 2 1 2
11/26/2011 00:35 penelopee#1
Hello Epvp.

Today i would like to show you the most helpfull mssql querys for Vsro server (110cap or 120cap, doenst madder.)

First of all, i DON'T made them, i just wrote them in a new Thread for easy-using. I will make a source to the "maker / releaser" of those codes/querys.

Important:
Do not post this codes in other forums with your name, you can write those codes on other sites with the Credits. But ONLY with the credits !


First the Alchemy plus rate change.

Now we come to how to chage the Magic Pop rate

Here is the guide how to add all avatars in item mall



Thats it for now.
Here are a few nice threads:

- [Only registered and activated users can see links. Click Here To Register...]


Sources:
Alchemy rate : [Only registered and activated users can see links. Click Here To Register...]
Magic Pop rate: [Only registered and activated users can see links. Click Here To Register...]
Item mall editing: [Only registered and activated users can see links. Click Here To Register...]

Greets: Penelopee.

(If i find any other usefull thread, i will post it here, so please ofthe check this thread :) )
11/29/2011 23:24 gengkey02#2
hi how to change the Sp rates ingame? i cant find it anywhere in server.cfg..thx
11/29/2011 23:30 B3GOD0FW4R#3
Quote:
Originally Posted by gengkey02 View Post
hi how to change the Sp rates ingame? i cant find it anywhere in server.cfg..thx
Exp rate with sp rate too
you can not change sp rate without change exp rate the same
Ex:-
Exp rate 60x
Sp will be 60x

you cant change sp alone!
11/29/2011 23:33 gengkey02#4
Quote:
Originally Posted by B3GOD0FW4R View Post
Exp rate with sp rate too
you can not change sp rate without change exp rate the same
Ex:-
Exp rate 60x
Sp will be 60x

you cant change sp alone!
Thx for your info...
12/18/2011 12:17 chinowy#5
well. i have a question, how to start with a character but with 100k sp grab pet reverse etc...? i hope ur answer!
12/21/2011 21:01 vantuto#6
1. Open PK2ExtractorSE.exe and open media.pk2.
1.1 Extract " refpackageitem.txt " (/server_dep/silkroad/textdata)
2. Open " refpackageitem.txt " and change all Saletag to "0" ( ZERO )
3. Open the table dbo._refpackageitem in you Shard db (maybe you named it SRO_VT_SHARD) and change all Saletag to "0"

i dont understand ( all saletag) i open refpackageitem i dont understand
12/21/2011 21:14 wolff66#7
i made some screens , i hope u now can understand :D
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
12/23/2011 16:15 posgesd#8
how to do it would be more money for trade ...? :)
01/09/2012 02:39 kaydhm2#9
1. Go to Shard DB ( maybe its called Sro_vt_shard or stm. else.)
2. There you right-click the DB and click "New Query"
3. Write the code in the New Query.

Quote:
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! ******** ! */
DECLARE @Rate int
SET @Rate = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
4. Change the rate as you like.
5. Push the "! Execute" button on the 3. toolbar.
6. Have fun with magic pop


which rates that i change and what if i want make it 100% can u help ?
01/10/2012 03:10 smallmama9#10
is the alchemy plus rate change applicable for players or is it only for the host of pservers?
01/18/2012 17:57 sido999#11
How can i edit the job rates??
03/11/2012 14:17 penelopee#12
Quote:
Originally Posted by smallmama9 View Post
is the alchemy plus rate change applicable for players or is it only for the host of pservers?
It's serversided, so only host can do it.


Quote:
Originally Posted by sido999 View Post
How can i edit the job rates??
I will search for a Jobrate change.
07/07/2012 18:48 m4a1silent#13
how to edit elixir dro rate.
01/29/2013 02:47 lido81#14
i have error when open game server
bsobj plugin
insert price policy condition level
Package_item_mall_balloon_kerberos_dmgup


can any one help me ?
04/02/2014 11:59 Gangson#15
guys i have a problem with theiffs town.I teleport in it with my gm acc but i cant move and i see black holes in map i guess npc is not existing but idk.


Help :D
Page 1 of 2 1 2