شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
21-04-2015, 05:40 PM | #1 | ||||||||||||
|
انا عايز اخلى التريده تشتريها بى 2b وابعها بى 12b وتتباع فى نفس المدينه الى انت شارى منها التريده بخساره
عملت Query بس مش عايز يظبت بصراحه وانا تعبت من الحوار ده ياريت لو حد يقدر يظبتلى Query Bye Treda 5* 2b Sell Treda 5* 12b وتتباع فى نفس المدينا الى انت شارى منها التريده بى خصاره وده ال Query الى انا استخدمتو كود بلغة HTML:
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%' |
||||||||||||
|
22-04-2015, 03:39 PM | #2 | ||||||||||||
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
افضل يا باشا جرب لحد لما توصل للرات اللي انت عايزة |
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|