job

[bmz]

ازاى اخلى ال job trader بتدى Gold كتيير
ازاى احدد يعنى

[MORJANA]

أستخدم الكويري ده و عدل فيه القيمة المناسبة ليك
هو مكتوب قدام الاماكن اللي هتعدل فيها

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%'

و ممكن تستخدم ده نفس المهمة باردو

USE [SRO_VT_SHARD_INIT] GO UPDATE dbo._RefObjCommon SET Price = 383*20 WHERE Price = 383 UPDATE dbo._RefObjCommon SET SellPrice = 191*20 WHERE SellPrice = 191 UPDATE dbo._RefPricePolicyOfItem SET Cost = 383*20 WHERE Cost = 383

و تغير *20 للقيمة اللي انت عايزها

[bmz]

طيب لو عاوز اعملها 60x
يبقه اكتب مكان

SET @NewQuot = 60000 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible) SET @NewPrice = 60000 -- Goods Price @ the Shop SET @NewStack = 60000 -- Increases/Decreases the maximum Stack, Default = 40 SET @NewSellPrice = 60000 -- Goods Price if you sell them directly again - without trading.

[MORJANA]

SET @NewQuot = 6.2 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible) SET @NewPrice = 243 -- Goods Price @ the Shop SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40 SET @NewSellPrice = 243 -- Goods Price if you sell them directly again - without trading.

و ده كويري للـ ْ60

USE [SRO_VT_SHARD_INIT] GO UPDATE dbo._RefObjCommon SET Price = 383*60 WHERE Price = 383 UPDATE dbo._RefObjCommon SET SellPrice = 191*60 WHERE SellPrice = 191 UPDATE dbo._RefPricePolicyOfItem SET Cost = 383*60 WHERE Cost = 383

[bmz]

طيب ازاى احطهم ew query مظنش

[MORJANA]

كليك يمين على الـ SHARD و New Query
و بعده ما تحطه دوس F5

USE [SRO_VT_SHARD] GO UPDATE dbo._RefObjCommon SET Price = 383*60 WHERE Price = 383 UPDATE dbo._RefObjCommon SET SellPrice = 191*60 WHERE SellPrice = 191 UPDATE dbo._RefPricePolicyOfItem SET Cost = 383*60 WHERE Cost = 383

[bmz]

تم شكرا

[MORJANA]

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

العفو تحت أمرك

##

[Mahmoud Rashwan]

@@