[F77]

بص انا استخدمت الكويري ده
بس جاب ربح ارقام فلكية

USE [SRO_VT_SHARD]                     

DECLARE @NewQuot FLOAT                     
DECLARE @NewPrice INT  
DECLARE @NewStack INT  
DECLARE @NewSellPrice INT  
SET @NewQuot = 650            -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible) 
SET @NewPrice = 60000           -- Goods Price @ the Shop 
SET @NewStack = 100000            -- Increases/Decreases the maximum Stack, Default = 40 
SET @NewSellPrice = 10000000        -- Goods Price if you sell them directly again - without trading. 
 
  
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

هي النسبة بتاعت الربح الي هي 650
بس انا مش عارف اظبطها ايه عشان تبقي مناسبة وتجيب مثلا في حد من 4 بل ل 5 وكده
عندك علم بها ؟