الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**khaledowies** · 01-04-2018, 02:52 AM

بعد ازنكم انا كنت محتاج 2 كيوري واحد للتعديل علي سعر التريد يعني عايز الخمسة ستار بدل ماتيدي 50 تيدي 100 او العكس
وتاني كيوري عايز اضيف ريورد مع الجولد يعني عايز التريد تسلم جولد وايرون كوين كمان ارجو المساعدة

**khaledowies** · 01-04-2018, 09:49 AM

**HB#** · 01-04-2018, 12:12 PM

ومتنساش تعدل على ال itemdata_%.txt

كود:

USE [SRO_VT_SHARD] DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD //by Caipi 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%'

**khaledowies** · 01-04-2018, 01:22 PM

اقتباس:

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

ومتنساش تعدل على ال itemdata_%.txt

كود:

USE [SRO_VT_SHARD] DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD //by Caipi 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%'

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

**khaledowies** · 01-04-2018, 05:59 PM

ايه ياجماعة فين الاجابة ^^ انا شايف المواضيع كلها غير مجابة

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Trade edit	eslamsaied	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	10	06-01-2018 07:42 AM
Edit Trade Reward Silkroad4arab	.Gamer.	قسم المواضيع المكررة و المخالفة	0	29-12-2015 03:35 AM
How to edit Trade Rewards :)	lordbotereslam	قسم المواضيع المكررة و المخالفة	1	21-02-2014 09:01 PM
edit trade reward	uleader2	قسم المواضيع المكررة و المخالفة	12	17-11-2013 01:55 AM
How to edit trade rewards?!	Roi	قسم المواضيع المكررة و المخالفة	1	14-07-2013 03:20 AM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟