[Request] HELP about job profit ..

[Neko_]

Hello ..

guys i was trying to do fixed job rates and fun like Atomix ..
but i think there is something wrong ...

the DB by default without touching this job profit is like that ..
i buy 1* from downhang , then go jangan ... i sell items and get NO GOLD At all .. like i never sold anything , and i gain about 11k EXP per stack

when i tried to use this query ..

 Spoiler

PHP Code:

DECLARE @NewQuot FLOAT                    -- @ SRO_VT_SHARD 
DECLARE @NewPrice INT 
DECLARE @NewStack INT 
DECLARE @NewSellPrice INT 
SET @NewQuot = 2.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 


it should douple it .. but when i make same trade 1* from downhang to jangan i gain about 840 BILLION ....

SO I Am trying to get a good query that fix the job profit rates like ATOMIX ..
to be balanced , like start 1* trade by 26m then from jangan to downhang i gain from 29m to 120m ...

it is the best rates i ever seen , and i think it can be done in my DB Too ..

well can you help me , by any good queries , and btw i never care about trader level if it is jump to level 7 from first trade , i just care about profit , etc ..

if you don't have queries so please ..just help me with explain how to do this ..


THANKS ALOT

[Dr.Abdelfattah]

At normal you must take some rewards from 1* trade like if you make trade with 100K from downhang to jangan must take all rewards about 180K and so on
After that I just change the trade items price to higher (at database and media) and change lvl require exp from _RefLevel for job and at media too
and it should works fine, I was making trade 5* by 2B and gain 5B from samarkand to Constantinople