أHamza Figo او Hero ياريت تدخل هنا - الموقع العربي الاول للعبة Silkroad Online

**loverslove** · 08-01-2015, 01:22 AM

عندى مشكله فى special trade مش بتجيب اى جولد واستخدمت الكورى ده
وبرده thife اما بيبع trade مش بيطلعله اى جولد

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

**Hamza FiGo** · 08-01-2015, 01:56 AM

ياباشا الــ Trade Gold صعب شوية علشان تغيرة لانة بيبقي لية صلة بــ GameServer

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

**loverslove** · 08-01-2015, 02:08 AM

طب ايه الحل انا عايز يجيب 20 billion

**Hero** · 08-01-2015, 03:35 PM

[COLOR="SeaGreen"]عدل عادى على سعرة و اتاكد منة فى الداتا و الميديا /COLOR]

**loverslove** · 08-01-2015, 09:35 PM

اعدل ازاى منا لو كنت اعرف مكنتش سألت يا Hero

**loverslove** · 09-01-2015, 04:02 PM

**loverslove** · 14-01-2015, 03:52 AM

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
مساعدة علي السريع و لو يريت تدخل يا Hamza FiGo هتفدني جامد	ahmedjak1993	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	10	27-06-2019 01:03 AM
أHamza Figo او Hero ياريت تدخل هنا	loverslove	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	33	23-01-2015 10:10 AM
أHamza Figo او Hero ياريت تدخل هنا	loverslove	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	4	15-01-2015 12:28 PM
أHamza Figo او Hero ياريت تدخل هنا	loverslove	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	1	01-01-2015 07:41 PM

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