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
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
and another way by making a group with _RefDropItemGroup and _RefMonster_AssignedItemRndDrop
when u look at the both tables u will get it
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