Dev. a balanced job profit rate ..

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

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

I wonder at the moment if you've set the values always on default before you tried another quotation out

i thin your = 99.9 = 99x !

as i understand :D

e.g. = for example ;)