Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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?
if (@TotalReward > 0)
begin
update _char set remaingold = remaingold + @TotalReward where charid = @CharID
end
not working with me .. the profit jump to 83 bill ..
When I try to run the query To adjust the necessary Exp for the Joblevels , I get this error
Msg 207, Level 16, State 1, Line 5
Invalid column name 'NewEXPQuot'.
Can I simply just modfify the default "JobExp_Trade,Robber,Hunter" to the new Exp I need?
ex: Lv4 needs 38745000, If I divide it by 100 and change it to 387450. Exp rate now is 100% lower than before to get lvl 4?
so like help traders, too help thiefs?
where i need to change on txdata?
SET @NewQuot = 0.2 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 343 -- Goods Price @ the Shop
SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 250 -- Goods Price if you sell them directly again - without trading.
Yah increase the Sell Price. Thieves steal your merchendise and sell it without buying them so they have 100% profit over to how much they sell.
Yah increase the Sell Price. Thieves steal your merchendise and sell it without buying them so they have 100% profit over to how much they sell.
Its funny how no one even bothered to answer you.
So can someone please tell us what needs to be changed client sided?
EDIT: Nvm i got it.
just edit pricepolicyofitem.txt clientsided.
DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD //by Caipi
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 3.0 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
-- 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