Need a query !!!!!!

Quote:

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

Quote:

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 =)

Quote:

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

Quote:

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

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')

Quote:

Originally Posted by hamzafigo Thnx so much Rock, and sry if i`m asking so much. [Only registered and activated users can see links. Click Here To Register...] 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

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')

Quote:

Originally Posted by Sir*EviL Update your media with it too

Quote:

Originally Posted by Sir*EviL itemdata_xxx