drop d13

Results 1 to 9 of 9
  1. #1
    Member Fantans is offline
    MemberRank
    Nov 2008 Join Date
    82Posts

    drop d13

    Hello i edited my own files and try with this is code and hav a much drop eu and dont chinese

    Try edit _RefDropItemAssign and gameserver dont start: local overlap job exception!! : CServerProcessOverlap


    Code:
    USE SRO_VT_SHARD_INIT
    GO
    
    DECLARE @MonsterID int
    DECLARE @ItemID int
    DECLARE @DropRatio real
    
    
    
    SET @MonsterID = 41423
    SET @DropRatio = 0.00004
    SET @ItemID = 39002
    
    
    
    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(@MonsterID ,   @ItemID, 0,          0,        1,             1,             @DropRatio,           0,                 0,           0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0 ,                0 ,           'xxx')
    Pls, help me, thanks..


  2. #2
    Member 123we is offline
    MemberRank
    Apr 2012 Join Date
    Any Where :>Location
    87Posts

    Re: drop d13

    Quote Originally Posted by Fantans View Post
    Hello i edited my own files and try with this is code and hav a much drop eu and dont chinese

    Try edit _RefDropItemAssign and gameserver dont start: local overlap job exception!! : CServerProcessOverlap


    Code:
    USE SRO_VT_SHARD_INIT
    GO
    
    DECLARE @MonsterID int
    DECLARE @ItemID int
    DECLARE @DropRatio real
    
    
    
    SET @MonsterID = 41423
    SET @DropRatio = 0.00004
    SET @ItemID = 39002
    
    
    
    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(@MonsterID ,   @ItemID, 0,          0,        1,             1,             @DropRatio,           0,                 0,           0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0 ,                0 ,           'xxx')
    Pls, help me, thanks..
    Add to _RefMonster_AssignedItemDrop

  3. #3
    Member Fantans is offline
    MemberRank
    Nov 2008 Join Date
    82Posts

    Re: drop d13

    Querry INSERT into db

  4. #4
    Sorcerer Supreme serend is offline
    Member +Rank
    Mar 2012 Join Date
    eurosro.coLocation
    338Posts

    Re: drop d13

    do it manually

  5. #5
    Member Fantans is offline
    MemberRank
    Nov 2008 Join Date
    82Posts

    Re: drop d13

    Quote Originally Posted by serend View Post
    do it manually
    Manually in _RefMonster_AssignedItemDrop (?)

  6. #6
    Sorcerer Supreme serend is offline
    Member +Rank
    Mar 2012 Join Date
    eurosro.coLocation
    338Posts

    Re: drop d13

    _RefMonster_AssignedItemDrop

    here an example this will make jupiter drop between 1 & 5 global chats

    Code:
    41419	3851	0	0	1	5	1	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	xxx

  7. #7
    Member Fantans is offline
    MemberRank
    Nov 2008 Join Date
    82Posts

    Re: drop d13

    Quote Originally Posted by serend View Post
    _RefMonster_AssignedItemDrop

    here an example this will make jupiter drop between 1 & 5 global chats

    Code:
    41419	3851	0	0	1	5	1	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	xxx
    Code:
    41419	39002	0	0	1	1	0,0004	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	NULL	0	xxx
    Here my code, work?

    Ty u help me :)

  8. #8
    Sorcerer Supreme serend is offline
    Member +Rank
    Mar 2012 Join Date
    eurosro.coLocation
    338Posts

    Re: drop d13

    yea that will make drop ITEM_CH_SWORD_13_A_RARE with a 0.0004% chance of dropping

  9. #9
    Member Fantans is offline
    MemberRank
    Nov 2008 Join Date
    82Posts

    Re: drop d13

    Why item have 0% in stats and others?



Advertisement