مشكلة فالــ Trader

[TryOutMe]

1- الــ Trader بتجيب 150B
انا عايز أقللها أخليها 11B مثلا أيه الحل !!؟


2- الــ SMC لما باجى أعمل أبديت مش بيعمل و بيجبلى أيرور مكتوب فيه 0 Files Found
مع انى عامل الفولدر بتاع الأبديت و كله تمام !

[TryOutMe]

Up Up Up :@ @:

[che_9299]

1-

use [SRO_VT_SHARD]
DECLARE @NewPrice INT
DECLARE @NewSellPrice INT

SET @NewPrice = 9999            -- Goods Price @ the Shop
SET @NewSellPrice = 999        -- Goods Price if you sell them directly again - without trading.

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

2- حمل واحد جديد

[merazz012]

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

1-

use [SRO_VT_SHARD]
DECLARE @NewPrice INT
DECLARE @NewSellPrice INT

SET @NewPrice = 9999            -- Goods Price @ the Shop
SET @NewSellPrice = 999        -- Goods Price if you sell them directly again - without trading.

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

2- حمل واحد جديد

هعدل حاحه في الكويري ؟ price دي لو عايزها لما توصل ياخد 14/15b اعملها كام ؟