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

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

bmz 08-04-2017 07:40 PM
job
 
ازاى اخلى ال job trader بتدى Gold كتيير
ازاى احدد يعنى

MORJANA 08-04-2017 07:46 PM
رد: job
 
أستخدم الكويري ده و عدل فيه القيمة المناسبة ليك
هو مكتوب قدام الاماكن اللي هتعدل فيها

كود:
DECLARE @NewQuot FLOAT                    -- @ SRO_VT_SHARD //
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%'
و ممكن تستخدم ده نفس المهمة باردو
كود:
USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjCommon
SET Price = 383*20
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 191*20
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*20
WHERE Cost = 383
و تغير *20 للقيمة اللي انت عايزها
:mf_chieftain:

:cheers:

bmz 08-04-2017 07:58 PM
رد: job
 
طيب لو عاوز اعملها 60x
يبقه اكتب مكان
كود بلغة HTML:
SET @NewQuot = 60000            -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 60000            -- Goods Price @ the Shop
SET @NewStack = 60000            -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 60000        -- Goods Price if you sell them directly again - without trading.

MORJANA 08-04-2017 08:08 PM
رد: job
 
كود:
SET @NewQuot = 6.2 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 243 -- Goods Price @ the Shop
SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 243 -- Goods Price if you sell them directly again - without trading.
و ده كويري للـ ْ60

اقتباس:
USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjCommon
SET Price = 383*60
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 191*60
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*60
WHERE Cost = 383

bmz 08-04-2017 08:12 PM
رد: job
 
طيب ازاى احطهم ew query مظنش

MORJANA 08-04-2017 08:16 PM
رد: job
 
كليك يمين على الـ SHARD و New Query
و بعده ما تحطه دوس F5
كود:
USE [SRO_VT_SHARD]
GO

UPDATE dbo._RefObjCommon
SET Price = 383*60
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 191*60
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*60
WHERE Cost = 383

bmz 08-04-2017 08:52 PM
رد: job
 
تم شكرا

MORJANA 08-04-2017 09:00 PM
رد: job
 
اقتباس:
المشاركة الأصلية كتبت بواسطة bmz (المشاركة 5312157)
تم شكرا
العفو تحت أمرك :cowboy:

##

Mahmoud Rashwan 15-04-2017 10:29 PM
رد: job
 
@@


الساعة الآن 06:21 AM.

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