عاوز اعلى Jop Rates - الموقع العربي الاول للعبة Silkroad Online

**kakan** · 18-10-2012, 03:23 PM

بسم الله الرحمن الرحيم

يا ريت شرح تفصيلى ازاى اعلى Jop Rates يكون 10x

شكرا

**●♥ Marwan1337 ♥●** · 18-10-2012, 03:35 PM

خد يا أحمد ...

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

الاسعار واللفل وده كله من هنا فوق حتغيره وتحط قدامه الرقم المناسب ... !!

**kakan** · 18-10-2012, 03:39 PM

تمام شكرا يا حبى
نخدمك فى الافراح

**●♥ Marwan1337 ♥●** · 18-10-2012, 03:54 PM

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
عاوز اشترى اك لفل 90 او اعلى وزرد	the smoke	Ceres	2	15-03-2010 03:44 PM
انا عاوز اشترى اى اكونت +90 او اعلى	marmora_smsm2003	Ceres	19	06-01-2010 02:15 AM
عاوز اكونت اعلي من 64 في برسيا	midomixalove2	Bellona	3	09-06-2008 09:17 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)