[Release] Vsro helpfull edit

[penelopee]

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.

 Spoiler

With this guide, you can setup alchemy rate to 2x, 3x 4x 5x, however you want!
Its DB editing, not gameserver or shardmanager ^_^

1.Open Shard DB.
2.Open _RefObjItem

2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043

3.Go to number 2033.
3.1 scroll right, untill you reach to the params.
3.2 change the rates as you like.
(If you like to make it e.g. to 5x then you need to change it from "168101125" to "840505625")
"840832008" 1,2,3,4 "168101125" 5,6,7,8 "168101125" 9,10,11,12
param1 "840832008"
"1,2,3,4" ~ "168101125" means the plus chance,
"16,81%" to plus "1,2,3,4",
and same for 5,6,7,8 + 9,10,11,12 ,
up to higher +13, it decrase by 2, so its only 9% upchance.

To make it 2x, set 168101125 to 326202210 for every lucky powder and restart gameserver.

("168101125" x1,9 = "326202210", i dont even know why this is x1,9...)

Now we come to how to chage the Magic Pop rate

 Spoiler

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.

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

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

 Spoiler

Program Required :
- Pk2ExtractorSE.exe
- Pk2Editor.exe
(The download links are NOT from me, i just copied it from . )

Steps :
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"

4. Open Pk2Editor.exe
4.1 Open your Media.pk2
4.2 Import the edited refpackageitem.txt file.
5. Close Media.pk2 and have fun .

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

-


Sources:
Alchemy rate :
Magic Pop rate:
Item mall editing:

Greets: Penelopee.

(If i find any other usefull thread, i will post it here, so please ofthe check this thread )

[gengkey02]

hi how to change the Sp rates ingame? i cant find it anywhere in server.cfg..thx

[B3GOD0FW4R]

Originally Posted by gengkey02

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!

[gengkey02]

Originally Posted by B3GOD0FW4R

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

[chinowy]

well. i have a question, how to start with a character but with 100k sp grab pet reverse etc...? i hope ur answer!

[vantuto]

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

[wolff66]

i made some screens , i hope u now can understand

[posgesd]

how to do it would be more money for trade ...?

[kaydhm2]

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 ?

[smallmama9]

is the alchemy plus rate change applicable for players or is it only for the host of pservers?

[sido999]

How can i edit the job rates??

[penelopee]

Originally Posted by smallmama9

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.

Originally Posted by sido999

How can i edit the job rates??

I will search for a Jobrate change.

[m4a1silent]

how to edit elixir dro rate.

[lido81]

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 ?

[Gangson]

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