Merchant Rate Query

PHP Code:

---

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

PHP Code:

---

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

thx so much bro

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

this config is good?
or i need change it?

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

thanks for that script !

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

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

thanks

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

explain to us how we add this to database

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

How add avatar in game?

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

lchemy how will rise nad where change 2x for ?

11 DG Sox Rates where change drop ?

thank you

Anyone ever tell you your queries are awesome?:thumbup1:

you are the maaaaaaaaaaaaaan :DD thanks :)

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.

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

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?

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

Quote:

---

Originally Posted by Caipi

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

PHP Code:

---

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.

how to add new Job System ^^

thanks bro =)

Quote:

---

Originally Posted by kellogz

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?

---

+1 is there a way to keep the job exp rate low and still get increased profit?
Posted via Mobile Device

Nice work

Quote:

---

Originally Posted by SL1MSH4DY

+1 is there a way to keep the job exp rate low and still get increased profit?
Posted via Mobile Device

---

Eventually in _Reward_3Job_Related_Item

PHP Code:

---

if (@TotalReward > 0)
        begin
            update _char set remaingold = remaingold + @TotalReward where charid = @CharID
        end 


---

-> UPDATE _Char set RemainGold = RemainGold + (@TotalReward/10) WHERE CharID = @CharID