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

  • spell_area

     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 'spell_area' table for MaNGOSFour

    This table holds information on what spells are applied to npcs/players in some areas.

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    spell mediumint(8) unsigned NO PRI '0'   Spell ID [See Spell.dbc].
    area mediumint(8) unsigned NO PRI '0'   Area ID [See AreaTable.dbc].
    quest_start mediumint(8) unsigned NO PRI '0'   Quest ID [See quest_template.entry].
    quest_start_active tinyint(1) unsigned NO PRI '0'   Flag for quest_start.
    quest_end mediumint(8) unsigned NO '0'   Quest ID [See quest_template.entry].
    condition_id mediumint(8) unsigned NO '0'   Condition ID [See conditions.condition_entry].
    aura_spell mediumint(8) NO PRI '0'   Spell ID [See Spell.dbc].
    racemask mediumint(8) unsigned NO PRI '0'   Race mask value.
    gender tinyint(1) unsigned NO PRI '2'   The gender of characters to which the spell is applied.
    autocast tinyint(1) unsigned NO '0'   Autocast flag.

    Description of the fields

    spell mediumint(8) unsigned

    Spell ID, see Spell.dbc. The spell is either cast on the character or allows the character to cast.

    area mediumint(8) unsigned

    Area ID, see AreaTable.dbc. If equals to 0, is not limited to any zone.

    quest_start mediumint(8) unsigned

    Quest ID [See quest_template.entry] that should be either active or rewarded.

    quest_start_active tinyint(1) unsigned

    If set, this flag allows the quest mentioned in the quest_start field to be rewarded, not only be active.

    quest_end mediumint(8) unsigned

    Quest ID [See quest_template.entry] of the quest that should not be rewarded.

    condition_id mediumint(8) unsigned

    Condition ID [See conditions.condition_entry] of the condition which should be fulfilled.

    aura_spell mediumint(8)

    Spell ID [See Spell.dbc] of the aura spell which the character should already have applied (if positive) or do not have (if negative).

    racemask mediumint(8) unsigned

    Race mask value. The entries may be combined by simple adding.

    Race Mask Value (hex) Mask Value (dec)
    Human 0x1 1
    Orc 0x2 2
    Dwarf 0x4 4
    Night Elf 0x8 8
    Undead 0x10 16
    Tauren 0x20 32
    Gnome 0x40 64
    Troll 0x80 128
    Goblin 0x100 256
    Blood Elf 0x200 512
    Dranei 0x400 1024

    gender tinyint(1) unsigned

    The gender of characters to which the spell is applied. The following table list available values.

    Gender of the creature

    Value Gender
    0 Male
    1 Female
    2 Both

    autocast tinyint(1) unsigned

    If set, this flag requires the spell to be cast on the character as they enter the area. If unset, the spell is enabled for the character to cast.

    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