Need a query !!!!!!

[Hamza FiGo]

1- Query increase the FGW Books Rate

2- Increase the trader gold Rate

Ty

[AceSpace]

- Vsro FGW D11 talisman drop rates query.

Hello ********! =)

i've joined ******** to make some [HELP]Threads and people here helped me.. so i'm here today to help some of people who don't know how to change the D11 FGW talisman drop rates..


here is the Query..

USE [SRO_VT_SHARD]

UPDATE _RefMonster_AssignedItemRndDrop set DropRatio = '1.65' where DropRatio = '0.11'
UPDATE _RefMonster_AssignedItemRndDrop set DropRatio = '0.825' where DropRatio = '0.055'

This Query will change your drop rates to 15x
__________________________________________________ ___________________________

Explanation

if you want to make it 10x for example, do like the following..

USE [SRO_VT_SHARD]

UPDATE _RefMonster_AssignedItemRndDrop set DropRatio = '1.65' where DropRatio = '1.1'
UPDATE _RefMonster_AssignedItemRndDrop set DropRatio = '0.825' where DropRatio = '0.55'

What we did there to make it 10x?

I simply opened the calculator and
1-( 0.11*10 = 1.1 )
2-( 0.055*10 = 0.55 )

i guess it's so clear.



Wish i helped you guys.

- Adding Job Rates

Well, that will increase the price also
(At my opinion more enjoymend for Traders because they get scared of they expensive loot )
, but it works for Thiefs and Hunters, here is the query.


Hope you like it

USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjCommon
SET Price = 383*20
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 191*20
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*20
WHERE Cost = 383

Change the *20 to your value =)

Credits goes to Hean & winsnoop from RG.

[Hamza FiGo]

O.o U can give me just the query

not ( you are...s*** ) idk why, when we are asking from something we get insulted !! Pff

Ty anyway

And btw. i searched for a post about this, i get nothing

Or i didn`t searched well

Another Question if u don`t mind.

The query about the trade gold rate, in my server 4* from jangan to const. gives 1.2b

If i need it to be like 2.5b or 3b. What is the correct value pls ? Ty

[PlayVSro]

Originally Posted by ²²Rock²²

You're............ piece of s***.

- Vsro FGW D11 talisman drop rates query.



- Adding Job Rates



Credits goes to Hean & winsnoop from RG.


Advice; Give up on creating a server If you can't even use google

thank you

[AceSpace]

Originally Posted by hamzafigo

O.o U can give me just the query

not ( you are...s*** ) idk why, when we are asking from something we get insulted !! Pff

Ty anyway

And btw. i searched for a post about this, i get nothing

Or i didn`t searched well

Another Question if u don`t mind.

The query about the trade gold rate, in my server 4* from jangan to const. gives 1.2b

If i need it to be like 2.5b or 3b. What is the correct value pls ? Ty

I deeply apologize, I was in a bad mood.
Use that query;

SElect SellPrice from _RefObjCommon where CodeName128 in ('ITEM_ETC_TRADE_CH_01',
'ITEM_ETC_TRADE_CH_02',
'ITEM_ETC_TRADE_CH_03',
'ITEM_ETC_TRADE_CH_04',
'ITEM_ETC_TRADE_WC_01',
'ITEM_ETC_TRADE_WC_02',
'ITEM_ETC_TRADE_WC_03',
'ITEM_ETC_TRADE_WC_04',
'ITEM_ETC_TRADE_KT_01',
'ITEM_ETC_TRADE_KT_02',
'ITEM_ETC_TRADE_KT_03',
'ITEM_ETC_TRADE_KT_04',
'ITEM_ETC_TRADE_EU_01',
'ITEM_ETC_TRADE_EU_02',
'ITEM_ETC_TRADE_EU_03',
'ITEM_ETC_TRADE_EU_04',
'ITEM_ETC_TRADE_CH_05',
'ITEM_ETC_TRADE_CH_06',
'ITEM_ETC_TRADE_CH_07',
'ITEM_ETC_TRADE_WC_05',
'ITEM_ETC_TRADE_WC_06',
'ITEM_ETC_TRADE_WC_07',
'ITEM_ETC_TRADE_TK_01',
'ITEM_ETC_TRADE_TK_02',
'ITEM_ETC_TRADE_TK_03',
'ITEM_ETC_TRADE_RM_01',
'ITEM_ETC_TRADE_RM_02',
'ITEM_ETC_TRADE_RM_03',
'ITEM_ETC_TRADE_AM_01',
'ITEM_ETC_TRADE_AM_02',
'ITEM_ETC_TRADE_AM_03',
'ITEM_ETC_TRADE_CA_01',
'ITEM_ETC_TRADE_CA_02',
'ITEM_ETC_TRADE_CA_03',
'ITEM_ETC_TRADE_CA_04',
'ITEM_ETC_TRADE_SD_01',
'ITEM_ETC_TRADE_SD_02',
'ITEM_ETC_TRADE_VE_01',
'ITEM_ETC_TRADE_VE_02',
'ITEM_ETC_TRADE_DE_01',
'ITEM_ETC_TRADE_DE_02')

And then give me the sellprice which is in the column and I'll give you another query to make it 3b.

It should look like that:



So you'll have to give me the number which appeared in the column. In mine it was 343.

[Hamza FiGo]

Thnx so much Rock, and sry if i`m asking so much.



btw, in my server the 4 * trade is the max. 5* closed make my sr_gameserver crash

So when i make 4* trade from jangan to const. i got 1,2b

Thnx for help Rock

[AceSpace]

Originally Posted by hamzafigo

Thnx so much Rock, and sry if i`m asking so much.



btw, in my server the 4 * trade is the max. 5* closed make my sr_gameserver crash

So when i make 4* trade from jangan to const. i got 1,2b

Thnx for help Rock

Use this and test it.

update _RefObjCommon set SellPrice = 100000 where CodeName128 in ('ITEM_ETC_TRADE_CH_01',
'ITEM_ETC_TRADE_CH_02',
'ITEM_ETC_TRADE_CH_03',
'ITEM_ETC_TRADE_CH_04',
'ITEM_ETC_TRADE_WC_01',
'ITEM_ETC_TRADE_WC_02',
'ITEM_ETC_TRADE_WC_03',
'ITEM_ETC_TRADE_WC_04',
'ITEM_ETC_TRADE_KT_01',
'ITEM_ETC_TRADE_KT_02',
'ITEM_ETC_TRADE_KT_03',
'ITEM_ETC_TRADE_KT_04',
'ITEM_ETC_TRADE_EU_01',
'ITEM_ETC_TRADE_EU_02',
'ITEM_ETC_TRADE_EU_03',
'ITEM_ETC_TRADE_EU_04',
'ITEM_ETC_TRADE_CH_05',
'ITEM_ETC_TRADE_CH_06',
'ITEM_ETC_TRADE_CH_07',
'ITEM_ETC_TRADE_WC_05',
'ITEM_ETC_TRADE_WC_06',
'ITEM_ETC_TRADE_WC_07',
'ITEM_ETC_TRADE_TK_01',
'ITEM_ETC_TRADE_TK_02',
'ITEM_ETC_TRADE_TK_03',
'ITEM_ETC_TRADE_RM_01',
'ITEM_ETC_TRADE_RM_02',
'ITEM_ETC_TRADE_RM_03',
'ITEM_ETC_TRADE_AM_01',
'ITEM_ETC_TRADE_AM_02',
'ITEM_ETC_TRADE_AM_03',
'ITEM_ETC_TRADE_CA_01',
'ITEM_ETC_TRADE_CA_02',
'ITEM_ETC_TRADE_CA_03',
'ITEM_ETC_TRADE_CA_04',
'ITEM_ETC_TRADE_SD_01',
'ITEM_ETC_TRADE_SD_02',
'ITEM_ETC_TRADE_VE_01',
'ITEM_ETC_TRADE_VE_02',
'ITEM_ETC_TRADE_DE_01',
'ITEM_ETC_TRADE_DE_02')

[Hamza FiGo]

Thanks. I`ll test it

[D1nt3]

beware of using the jop query twice because if u made it for example 20bil if u used that query agian to make it 30b it won't be edited
it just plus it the old one with the new one to become 50b
so if if you alredy made it you have to make it the old price and then use it

[Hamza FiGo]

I used it but still the same price. idk why

[Hamza FiGo]

Up ?

[Zodiao]

Update your media with it too

[Hamza FiGo]

Originally Posted by Sir*EviL

Update your media with it too

But i take the same gold!

But which file pls ?

[Zodiao]

itemdata_xxx

[Hamza FiGo]

Originally Posted by Sir*EviL

itemdata_xxx

Still the same pff.