06-03-2014, 08:10 PM
|
#3
|
|
|
• الانـتـسـاب » Dec 2012
|
|
• رقـم العـضـويـة » 107799
|
|
• المشـــاركـات » 623
|
|
• الـدولـة » Imbaba
|
|
• الـهـوايـة » DB&Media , Security
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 11
|
|
|
|
كود:
DECLARE @NewPrice INT -- @ SRO_VT_SHARD
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewPrice = 80000 -- Goods Price @ the Shop
SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 40000 -- 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
-- 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%'
|
|
|
|