الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**ahmedjemy** · 10-10-2017, 01:05 AM

ياريت query اخلي بيه rate ال nova في d11 و sun-moon-star في d10 قليل جدا يعني اخليه 1 drop في الشهر.
ياريت query او طريقة manuel بالتفصيل.
شكرا

**Neoon** · 10-10-2017, 11:08 AM

الكويري ده بيغير sox drop

كود PHP:

USE [SRO_VT_SHARD] UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_CH%RARE' UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_EU%RARE' UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_CH%RARE%' UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'

يا اما تعملها بالـ SR_PATCHER وتختار SR_GAMESERVER وتختار FixRates والرقم بيكون كدة مثلا لو عايز الدروب 75% بيكون " 75000 "

ومتنساش تعدل على Server.cfg

**HB#** · 10-10-2017, 11:47 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة Neoon عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

الكويري ده بيغير sox drop

كود PHP:

USE [SRO_VT_SHARD] UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_CH%RARE' UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_EU%RARE' UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_CH%RARE%' UPDATE dbo._RefObjCommon SET Rarity=1 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'

يا اما تعملها بالـ SR_PATCHER وتختار SR_GAMESERVER وتختار FixRates والرقم بيكون كدة مثلا لو عايز الدروب 75% بيكون " 75000 "

ومتنساش تعدل على Server.cfg

يا باشا ال rarity ال في ال _refobjcommon دي بتعدل على نوع الايتم (نوعها زي : Seal Of Star , Seal Of Sun , Seal Of Nova وكدا)

دي الكويري بقا ال بتغير نسبه ال sox drop :

كود:

USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10 // by Artuuro_lv (rz)/Miki Maus (epvp)
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

هتعدل على ال SET @RATE = 10 هتغير ال 10 اللونها احمر دي بس (10 يعني 10 اضعاف النسبه العاديه .. وشوف انت بقا)

**Neoon** · 10-10-2017, 12:04 PM

#HB

ال Rarity دي بتعدل على النسبة High / Low / Medium

بمعنى انك لو عملتها 3 مثلا

كود PHP:

USE [SRO_VT_SHARD_INIT] UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE' UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE' UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%' UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'

هتبقى عالية جدا

...............................

لو عايز تتحكم ف ال Sox Drop Rate
حط ده في Query وكبر دمــــــــــــاعك

كود PHP:

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

set rate=10
حتغيرها للي عايزه

**ahmedjemy** · 10-10-2017, 03:32 PM

انا لو استخدمت الكويري دا و عدلت عليها و بقت 10 .
نسبة ال drop اللي هتقع كل قد ايه ! بمعني يعني كل يوم ولا كل اسبوع ولا ايه بالظبط

**ahmedjemy** · 10-10-2017, 03:35 PM

معلش يا رجالة انا بسأل علي الحاجة بالتفصيل لاني لسه مبتدا في المجال دا و بحاول افهم .

**Neoon** · 10-10-2017, 03:37 PM

نسبة الدروب هتبقى 10% يعني تقريبا ممكن تقع كل 100 وحش و الله اعلم

**HB#** · 11-10-2017, 04:01 AM

لا مش 10 يعني 10% ... اقرأ الكويري .. هوا بيضرب ال 10 في النسبه العاديه .. يبقا 10 يعني 10 اضعاف النسبه العاديه

**ahmedjemy** · 11-10-2017, 11:33 PM

طيب انا لو حابب اقلل النسبة اخليها مثلا كل 10000الف وحش ينزل drop اقلل ال 10 دي اخلها 1 مثلا!؟

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

	حفظ بياناتي ؟

شـريـط الاهـداءات