some info about items drop

Results 1 to 7 of 7
  1. #1
    Member abdo1020 is offline
    MemberRank
    Jan 2013 Join Date
    behind youLocation
    53Posts

    some info about items drop

    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 Code:
    SELECT r.IDr.CodeName128r.ReqLevel1ItemClass '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 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,RentCodeNameVALUES [MENTION=769700]Monster[/MENTION]ID ,   @ItemID0,          0,        1,             1,             [MENTION=1333344650]Drop[/MENTION]Ratio,           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


  2. #2
    Member abdo1020 is offline
    MemberRank
    Jan 2013 Join Date
    behind youLocation
    53Posts

    Re: some info about items drop

    little messy but i hope it help

  3. #3
    Apprentice Kudo Shinichi is offline
    MemberRank
    Aug 2014 Join Date
    22Posts

    Re: some info about items drop

    you surprised me that's it

  4. #4
    Member abdo1020 is offline
    MemberRank
    Jan 2013 Join Date
    behind youLocation
    53Posts

    Re: some info about items drop

    Quote Originally Posted by Kudo Shinichi View Post
    you surprised me that's it

  5. #5
    Valued Member trytokillme is offline
    MemberRank
    Nov 2011 Join Date
    101Posts

    Re: some info about items drop

    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.

  6. #6
    Member abdo1020 is offline
    MemberRank
    Jan 2013 Join Date
    behind youLocation
    53Posts

    Re: some info about items drop

    Quote Originally Posted by trytokillme View Post
    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

  7. #7
    Valued Member trytokillme is offline
    MemberRank
    Nov 2011 Join Date
    101Posts

    Re: some info about items drop

    Quote Originally Posted by abdo1020 View Post
    you can just set it's rarity to 3 and it will rain sox
    Thank you mate. I'm gonna test it!



Advertisement