الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   كويري لل jop (https://silkroad4arab.com/vb/showthread.php?t=550808)

Emely 06-03-2014 09:03 AM

كويري لل jop
 
يا جماعه انا عايز كويري يظبط التريدا

يعنى فى كل المدن تكون بسعر واحد

فهمتونى

Emely 06-03-2014 03:57 PM

up

Ch3tos 06-03-2014 08:10 PM

كود:

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


Emely 07-03-2014 12:51 AM

ممكن تشرحلى ايه الى بيتغير بلظبط ؟

Emely 07-03-2014 03:50 PM

up

che_9299 07-03-2014 05:50 PM

كود:

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

NewSellPrice
NewPrice
غير دول

Emely 07-03-2014 07:29 PM

على فكره برضو نفس الموضوع بص كده ده وارجو التابعه
http://www.silkroad4arab.com/vb/show...52#post5022052


الساعة الآن 02:57 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions, Inc.