[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 اعملها كام ؟