طريقة ظبط ال Rate لكل حاجه ف السيرفر

[Mohamed Gad]

كنت عاوز اعرف اظبط الريت بتاع كل حاجه ازاي
drops
sox
alchemy++
alchemy stone
exp
gold
lucky powder
job exp
job gold
عاوز اخليهم بال rate الطبيعي بتاع زمان زي zszc كده

 

[Dev.Ri3o]

رد: طريقة ظبط ال Rate لكل حاجه ف السيرفر

Exp Rates
Exp Party Rates
Drop Item Rate
Gold Drop Rate
ده من ال Server.cfg
بالنسبة لل Alchemy ++ وال Stone و ل Luxky Powder من Query بيتعمل بس ال Query خاص بال Lucky Powder بس
بالنسبة لل job gold بيتعمل ب Query بتقلل وتزود الارباح
بالنسبة لل Exp Rate Job هو هو نفس ال Exp Rate بس لو بتتكلم على ال Exp نفسو من ال RefLevel

 

[Mohamed Gad]

رد: طريقة ظبط ال Rate لكل حاجه ف السيرفر

Exp Rates
Exp Party Rates
Drop Item Rate
Gold Drop Rate
ده من ال Server.cfg
بالنسبة لل Alchemy ++ وال Stone و ل Luxky Powder من Query بيتعمل بس ال Query خاص بال Lucky Powder بس
بالنسبة لل job gold بيتعمل ب Query بتقلل وتزود الارباح
بالنسبة لل Exp Rate Job هو هو نفس ال Exp Rate بس لو بتتكلم على ال Exp نفسو من ال RefLevel

طيب انا عاوز اعرف الكويري بتاع كل واحد و ازاي استخدمه
وعشان اسهل عليك انا هكتبلك الكويري اللى مهايا بتاع كل واحد وقولى اتعامل معاه ازاي

SOX Drop Rate

USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE

alchemy rate

USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2044'

lucky powder

USE [SRO_VT_SHARD]
DECLARE @RATE INT
SET @RATE=1
UPDATE dbo._RefObjItem SET Param2=(Param2*@RATE) WHERE ID BETWEEN '2033' AND '2054'
UPDATE dbo._RefObjItem SET Param3=(Param3*@RATE) WHERE ID BETWEEN '2033' AND '2054'
UPDATE dbo._RefObjItem SET Param4=(Param4*@RATE) WHERE ID BETWEEN '2033' AND '2054'

stone Rate

USE SRO_VT_SHARD 
GO 
UPDATE _RefObjItem 
SET Param4 = Here Put The Rate You Want % 
WHERE ID BETWEEN 4630 AND 5013

Job Exp Rate

USE [SRO_VT_SHARD] 
DECLARE @Rate INT 
SET @Rate = '100' -- Rate here 
UPDATE [dbo].[_RefLevel] 
SET 

[JobExp_Trader] = [JobExp_Trader]/@Rate 
, 
[JobExp_Robber] = [JobExp_Robber]/@Rate 
, 
[JobExp_Hunter] = [JobExp_Hunter]/@Rate 
WHERE [Lvl] BETWEEN 1 and 7 


SELECT  
* 
FROM _RefLevel 
WHERE Lvl BETWEEN 1 AND 140;

Job Gold Rate

USE [SRO_VT_SHARD] 
DECLARE @NewQuot FLOAT   
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%'

دول كل الكويري اللى معايا بخصوص الموضوع بس مش عارف ايه النسبه اللى بيعملوها وهما تمام ولا لا
لو كده يا ريت حضرتك تشوفهم وتقولى احط عليهم النسبه ال Hard ازاي

 

[Gamer]

رد: طريقة ظبط ال Rate لكل حاجه ف السيرفر

SET @RATE = 10 -- Here we set the multiplier value! Default: 10

اظن واضحه ..

alchemy rate

شوف ده ..

الرابط مخفي تسجيل الدخول او تسجيل !!

SET @Rate = '100' -- Rate here

واضحة برضه

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.

 

[tocsro1]

رد: طريقة ظبط ال Rate لكل حاجه ف السيرفر

سؤال ممكن كونت عاوز اظبط الرتي بتاع sox hogd legk ;g 2000 mobs ygebo men 1sox >2