Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Merchant Rate Query

Experienced Elementalist
Joined
Sep 27, 2011
Messages
285
Reaction score
229
PHP:
DECLARE @NewQuot FLOAT					-- @ SRO_VT_SHARD //by Caipi
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9			-- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999			-- Goods Price @ the Shop
SET @NewStack = 9999			-- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999		-- Goods Price if you sell them directly again - without trading.

-- Profit %

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

-- Price / SellPrice

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672

-- MaxStack

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160

-- Price

UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCodeName like '%ITEM_ETC_TRADE%'

Old trash..
To adjust the necessary Exp for the Joblevels (bigint)..
PHP:
DECLARE @NewEXPQuot INT	-- At first _RefLevel and Dependencies -> Design -> JobExp_Trader/JobExp_Hunter/Job_Exp_Robber -> bigint; Cause Exp = Max INT value
SET @NewEXPQuot = 999   -- Currently: 999x more necessary Exp


UPDATE [dbo].[_RefLevel]
SET JobExp_Trader = JobExp_Trader*NewEXPQuot
WHERE JobExp_Trader > 0

UPDATE [dbo].[_RefLevel]
SET JobExp_Hunter = JobExp_Hunter*NewEXPQuot
WHERE JobExp_Hunter > 0

UPDATE [dbo].[_RefLevel]
SET JobExp_Robber = JobExp_Robber*NewEXPQuot
WHERE JobExp_Robber > 0
Have fun :)
 
Last edited:
Experienced Elementalist
Joined
Sep 27, 2011
Messages
285
Reaction score
229
My pleasure, but don't forget to change those values also @ the pk2! @Itemdata etc.
 
Experienced Elementalist
Joined
Sep 27, 2011
Messages
285
Reaction score
229
I put randomly values in it, you shouldn't keep them.



Okay I accidentaly tried it out with those values and I made with a 1* from Alexandria to Jangan 4b+ Gold. You shouldn't take those, for real ;)
 
Last edited:
Banned
Banned
Joined
Sep 27, 2011
Messages
7
Reaction score
0
thanks for that script !

but i think those are only for hunter / trader or ?? my thief rates are still the same
 
Banned
Banned
Joined
Oct 26, 2011
Messages
6
Reaction score
0
bump, caipi do u have a solution for thief rewards ?

thanks
 
Experienced Elementalist
Joined
Sep 27, 2011
Messages
285
Reaction score
229
Aw well I can't try it out at the moment, since I left my last pServer :) Track the NPC ID of the Thief Sellers and look at the _ItemQuotation if there's the ID under AssocNPC - shud work then too, theoretical ^^
 
Experienced Elementalist
Joined
Sep 27, 2011
Messages
285
Reaction score
229
Re: [Release] Merchant Rate Query

Right Click on Shard, New Query, Copy Pasta, Run it - ready :)

Keep in mind to choose your desired values:

SET @NewQuot = xx.xx
SET @NewPrice = xx
SET @NewStack = xx
SET @NewSellPrice = xx
 
Initiate Mage
Joined
Sep 28, 2011
Messages
24
Reaction score
0
Re: [Release] Merchant Rate Query

how to set max SAFE TRADE?
i need only 3 not 8 safe trades...
 
Initiate Mage
Joined
Sep 18, 2011
Messages
32
Reaction score
0
Re: [Release] Merchant Rate Query

lchemy how will rise nad where change 2x for ?

11 DG Sox Rates where change drop ?

thank you
 
Skilled Illusionist
Joined
Dec 3, 2011
Messages
318
Reaction score
23
Re: [Release] Merchant Rate Query

Anyone ever tell you your queries are awesome?:thumbup1:
 
Experienced Elementalist
Joined
Nov 14, 2011
Messages
260
Reaction score
54
Re: [Release] Merchant Rate Query

you are the maaaaaaaaaaaaaan :DD thanks :)
 
Skilled Illusionist
Joined
Dec 3, 2011
Messages
318
Reaction score
23
Re: [Release] Merchant Rate Query

This works fine for traders and it's working fine with 10x, but this doesn't seem to work for when theif's sell goods. I assume it doesn't help hunters either.
 
Initiate Mage
Joined
Dec 22, 2011
Messages
47
Reaction score
1
Re: [Release] Merchant Rate Query

so like help traders, too help thiefs?
where i need to change on txdata?
 
Initiate Mage
Joined
Aug 15, 2011
Messages
30
Reaction score
24
Re: [Release] Merchant Rate Query

Caipi i did this without the queery but on the subject the problem with setting the sell value so high for the trading is that the XP gained is insane, 1 5* will get you too level 7. Any idea how the XP could be reduced to keep the feeling of level 7 meaning something?
 
Initiate Mage
Joined
Dec 22, 2011
Messages
47
Reaction score
1
Re: [Release] Merchant Rate Query

need to change anything on textdata? if yes, what are the txt's?
 
Junior Spellweaver
Joined
Aug 2, 2004
Messages
125
Reaction score
16
Re: [Release] Merchant Rate Query

To adjust the necessary Exp for the Joblevels (bigint)..
PHP:
DECLARE @NewEXPQuot INT	-- At first _RefLevel and Dependencies -> Design -> JobExp_Trader/JobExp_Hunter/Job_Exp_Robber -> bigint; Cause Exp = Max INT value
SET @NewEXPQuot = 999   -- Currently: 999x more necessary Exp


UPDATE [dbo].[_RefLevel]
SET JobExp_Trader = JobExp_Trader*NewEXPQuot
WHERE JobExp_Trader > 0

UPDATE [dbo].[_RefLevel]
SET JobExp_Hunter = JobExp_Hunter*NewEXPQuot
WHERE JobExp_Hunter > 0

UPDATE [dbo].[_RefLevel]
SET JobExp_Robber = JobExp_Robber*NewEXPQuot
WHERE JobExp_Robber > 0

Have fun :)

Hi, i got GS_Gameserver error when i change int to bigint. I changed both _RefLevel table and Stored Procedures too. Can you tell me where i can fix it?

Thanks.
 
Back
Top