Merchant Rate Query

[Caipi]

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

Spoiler

To adjust the necessary Exp for the Joblevels (bigint)..

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

 

[ktkoti]

thx so much bro

 

[Caipi]

My pleasure, but don't forget to change those values also @ the pk2! @Itemdata etc.

 

[shukamu]

this config is good?
or i need change it?

 

[Caipi]

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

 

[peter0010]

thanks for that script !

but i think those are only for hunter / trader or ?? my thief rates are still the same

 

[kraLoqe]

bump, caipi do u have a solution for thief rewards ?

thanks

 

[Caipi]

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

 

[zieon]

explain to us how we add this to database

 

[Caipi]

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

 

[enis1994]

Re: [Release] Merchant Rate Query

How add avatar in game?

 

[shukamu]

Re: [Release] Merchant Rate Query

how to set max SAFE TRADE?
i need only 3 not 8 safe trades...

 

[asi41]

Re: [Release] Merchant Rate Query

lchemy how will rise nad where change 2x for ?

11 DG Sox Rates where change drop ?

thank you

 

[SL1MSH4DY]

Re: [Release] Merchant Rate Query

Anyone ever tell you your queries are awesome?

 

[3d2000]

Re: [Release] Merchant Rate Query

you are the maaaaaaaaaaaaaan D thanks

 

[SL1MSH4DY]

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.

 

[jschilling]

Re: [Release] Merchant Rate Query

so like help traders, too help thiefs?
where i need to change on txdata?

 

[kellogz]

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?

 

[jschilling]

Re: [Release] Merchant Rate Query

need to change anything on textdata? if yes, what are the txt's?

 

[khongtuong]

Re: [Release] Merchant Rate Query

To adjust the necessary Exp for the Joblevels (bigint)..

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.