الموقع العربي الاول للعبة Silkroad Online

انا دلوقتى ظبط trade بلكود ده
كود بلغة HTML:
DECLARE @NewQuot FLOAT                    -- @ SRO_VT_SHARD 

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%'
عايز اظبط trade special واعلى رات بتاع thife عشان مش بيدى جولد خالص