Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • groups


    antz
     NOTE:  This page is auto-generated from the MAGNET DBDocs module,
                 Any changes made directly to this page will be lost when it is regenerated.

    Description of the 'groups' table for MaNGOSThree

    This table holds basic info about groups.

    Table Notes

    This table uses the 'InnoDB' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    groupId int(11) unsigned NO PRI NULL   Uniquie ID for the group.
    leaderGuid int(11) unsigned NO UNI NULL   Guid of the group's leader
    mainTank int(11) unsigned NO NULL   Guid of the character who is that main tank.
    mainAssistant int(11) unsigned NO NULL   Guid of the character who is that main assist.
    lootMethod tinyint(4) unsigned NO NULL   This is the loot method used by the group.
    looterGuid int(11) unsigned NO NULL   Guid of the character who retrieves the loot.
    lootThreshold tinyint(4) unsigned NO NULL   The quality of the items in the loot to be rolled for.
    icon1 int(11) unsigned NO NULL   Guid of the target that has the star raid target on it.
    icon2 int(11) unsigned NO NULL   Guid of the target that has the circle raid target on it.
    icon3 int(11) unsigned NO NULL   Guid of target that has the dimond raid target on it.
    icon4 int(11) unsigned NO NULL   Guid of the target that has the triangler raid target on it.
    icon5 int(11) unsigned NO NULL   Guid of the target that has the moon raid target on it.
    icon6 int(11) unsigned NO NULL   Guid of the target that has the square raid target on it.
    icon7 int(11) unsigned NO NULL   Guid of the target that has the cross raid target on it.
    icon8 int(11) unsigned NO NULL   Guid of the target that has the skull raid target on it.
    groupType tinyint(1) unsigned NO NULL    
    difficulty tinyint(3) unsigned NO '0'    
    raiddifficulty int(11) unsigned NO '0'    

    Description of the fields

    groupId int(11) unsigned

    Uniquie ID for the group.

    leaderGuid int(11) unsigned

    Guid of the group's leader, from the characters table.

    mainTank int(11) unsigned

    Guid of the character who is that main tank.

    mainAssistant int(11) unsigned

    Guid of the character who is that main assit.

    This group member calls the shots as to the order in which mobs are taken on.

    lootMethod tinyint(4) unsigned

    This is the loot method used by the group.

    Method Value
    FREE_FOR_ALL 0
    ROUND_ROBIN 1
    MASTER_LOOT 2
    GROUP_LOOT 3
    NEED_BEFORE_GREED 4

    looterGuid int(11) unsigned

    Guid of the character who retrieves the loot.

    lootThreshold tinyint(4) unsigned

    The quality of theitems in the loot to be rolled for. This will be the minimum quality level to throw for, any loot below that will not be thrown for.

    Quality Value Colour
    ITEM_QUALITY_POOR 0 GREY
    ITEM_QUALITY_NORMAL 1 WHITE
    ITEM_QUALITY_UNCOMMON 2 GREEN
    ITEM_QUALITY_RARE 3 BLUE
    ITEM_QUALITY_EPIC 4 PURPLE
    ITEM_QUALITY_LEGENDAR 5 ORANGE
    ITEM_QUALITY_ARTIFACT 6 LIGHT YELLOW

    icon1 int(11) unsigned

    Guid of the target that has the star raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon2 int(11) unsigned

    Guid of the target that has the circle raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon3 int(11) unsigned

    Guid of target that has the dimond raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon4 int(11) unsigned

    Guid of the target that has the triangler raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon5 int(11) unsigned

    Guid of the target that has the moon raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon6 int(11) unsigned

    Guid of the target that has the square raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon7 int(11) unsigned

    Guid of the target that has the cross raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    icon8 int(11) unsigned

    Guid of the target that has the skull raid target on it.

    These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

    groupType tinyint(1) unsigned

    difficulty tinyint(3) unsigned

    raiddifficulty int(11) unsigned


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use