PHP Code:
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
PHP Code:
SET [MENTION=769700]Monster[/MENTION]ID = 24160 -- You can find Monster ID's at RefObjCommonSET [MENTION=1333344650]Drop[/MENTION]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 [MENTION=769700]Monster[/MENTION]ID , @ItemID, 0, 0, 1, 1, [MENTION=1333344650]Drop[/MENTION]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