[Last_Fiddler]

السلام عليكم شباب
ايه مفيش حد يقضر يسعيدنى فى حكاية انى امسح السكل الى بيجبلى بج يا جماعه ؟
انا منتضر حد يعرف يحلهالى
والكورى بتاع التريدر غلط وانا اخزته عدلت عليه الصح اتفضلو اهوت

use  [SRO_VT_SHARD] 

DECLARE @NewQuot FLOAT       
 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%'

ياريت حد يشوف الى انا طلبه بس بسرعه