مساعده

[BashA_Mn_Youme]

ازاى اعلى نسبة ال Sox Drop
او منين اعليها

[Dangers SrO]

اتفصل ال Query دي هتعدل النسبه
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
غير 10 للرقم اللى انتا عايزه[/QUOTE]

[BashA_Mn_Youme]

يعنى 10 دى نسبة %100 ولا ايه انا مش فاهم

[MarOz]

1 = 100%
0.5 = %50
0.1 = 10%
لو عاوز بقا تخلي ال sox صعب و mbot و الكلام دة
النسبة دة حلوة 0.002163
بس لازم تعملها بايدك مش ب query

[BashA_Mn_Youme]

طب اعملها منين بايدى

[Dangers SrO]

انا سايف ان ال query دي احسن ونغير اي error
10 يعني 10% وشوف انتا بقي عايز تعمل ايه

[MarOz]

انت بتقول alex يعني لف الوحوش 101 ~ 110
بتفتح ال _RefDropClassSel_RareEquip و بتنزل ع رقم الوحوش تحت
و بروح علي ال Group و بتعدل
وادي صورة

http://i.epvpimg.com/UUNsg.png

http://i.epvpimg.com/yfLfh.png

[BashA_Mn_Youme]

يا استاذ انا استخدمت ال Quary وعملت نسبة %100 ووموقعش اى حاجه
واستخدمت يدوى عند موبس لفل 111 : 120 عشان انا فى Mirror وموقعش حاجه مع انى عاملها 1 يعنى %100
والصور اهى http://i.epvpimg.com/msEzc.jpg

[Dangers SrO]

يا باشا انا قولتلك 10 بمعني 10%

[BashA_Mn_Youme]

واللهى انا فاهم وحطيت جوا ال Quary 100 عشان يبقا %100

[MarOz]

جرب زي ما انا قولتلك
او قولي انت عاوز النسبة تبقا ازاي يعني صعبة ولا سهل
و انا هديك النسبة طحطها ع طول

[Dangers SrO]

جرب كدا 1=100

[BashA_Mn_Youme]

انا عايزها تبقا Dg12 نسبه بين Star Moon Sun
sun %1
Moon %5
Star%10

[Dangers SrO]

لا مخدنهاش في الفصل دي ^^

[BashA_Mn_Youme]

:nosweat::nosweat::nosweat::nosweat:

[MarOz]

انا عايزها تبقا Dg12 نسبه بين Star Moon Sun
sun %1
Moon %5
Star%10
كلها نسبة واحدة
بص اعملها Manaul

وادي النسب اهي اللي انت عاوزها

0.01 = 1%
0.05 = 5%

USE SRO_VT_SHARD -----> ( MaDenGo ) <-----
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50%
SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop


INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

[BashA_Mn_Youme]

الف سكر

[Dangers SrO]

##