Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

some info about items drop

Newbie Spellweaver
Joined
Jan 29, 2013
Messages
53
Reaction score
33
generally
attrib stone drop rate can be controlled from _RefDropClassSel_Alchemy_ATTRStone
mag stone from _RefDropClassSel_Alchemy_MagicStone
normal items from _RefDropClassSel_Equip
sox from _RefDropClassSel_RareEquip
elixir from _RefDropClassSel_Reinforce
extra...

now like _RefDropClassSel_Equip which drops normal items linked with _refobjcommon (column : rarity)
rarity for normal items cion and elixir extra is 0
rarity for sox is 3


now a table like _RefDropClassSel_RareEquip for sox drop rate you can see probgroup
which linked with _RefDropItemAssign
to search for an item, sox or coin group u can use a query

PHP:
SELECT r.ID, r.CodeName128, r.ReqLevel1, ItemClass 'DropGroup', CEILING(ItemClass / 3.0) 'Degree' FROM _RefObjCommon r JOIN _RefObjItem i on r.Link = i.ID WHERE codename128 like 'item name'

Sox deg 11 for example it's group is 31
so in table _RefDropClassSel_RareEquip search for probgroup 31 and set it's rate
to what ever u like in mobs lvl u like
same with other tables

ofc u can add drop another way with a query
PHP:
SET [USER=769700]Monster[/USER]ID = 24160 -- You can find Monster ID's at RefObjCommonSET [USER=1333344650]Drop[/USER]Ratio = 1 -- 100% = 1 / 50% = 0.5 / 0% = 0 of courseSET @ItemID = 25834 -- You can find Item ID's at RefObjCommon

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 [USER=769700]Monster[/USER]ID ,   @ItemID, 0,          0,        1,             1,             [USER=1333344650]Drop[/USER]Ratio,           0,                 0,           0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0 ,                0 ,           'xxx')

and another way by making a group with _RefDropItemGroup and _RefMonster_AssignedItemRndDrop
when u look at the both tables u will get it
 
Newbie Spellweaver
Joined
Nov 21, 2011
Messages
84
Reaction score
6
The SoX Rate isn't correct. If you set it to 1 it isn't 100%. I don't know why but you can't make a 100% SoX drop Rate at the SRO Files with normal mob drops. You can only do it with custom item groups and custom mob drops.
 
Newbie Spellweaver
Joined
Jan 29, 2013
Messages
53
Reaction score
33
The SoX Rate isn't correct. If you set it to 1 it isn't 100%. I don't know why but you can't make a 100% SoX drop Rate at the SRO Files with normal mob drops. You can only do it with custom item groups and custom mob drops.

you can just set it's rarity to 3 and it will rain sox
 
Back
Top