• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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