مشكله فى التريده

[Flsteny]

انا عايز اخلى التريده تشتريها بى 2b وابعها بى 12b وتتباع فى نفس المدينه الى انت شارى منها التريده بخساره

عملت Query بس مش عايز يظبت بصراحه وانا تعبت من الحوار ده ياريت لو حد يقدر يظبتلى Query

Bye Treda 5* 2b
Sell Treda 5* 12b
وتتباع فى نفس المدينا الى انت شارى منها التريده بى خصاره

وده ال Query الى انا استخدمتو

use [SRO_VT_SHARD] DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD DECLARE @NewPrice INT DECLARE @NewStack INT DECLARE @NewSellPrice INT SET @NewQuot = 900 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible) SET @NewPrice = 1000 -- Goods Price @ the Shop SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40 SET @NewSellPrice = 100000 -- 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%'

[Hamza FiGo]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

افضل يا باشا جرب لحد لما توصل للرات اللي انت عايزة