|
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 'game_event_mail' table for MaNGOSThree
This table holds definitions for mails sent out during game events and conditions for when to send the mail.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| event | smallint(6) | NO | PRI | '0' | Event ID [See game_events.entry]. | |
| raceMask | mediumint(8) unsigned | NO | PRI | '0' | Races of affected players. | |
| quest | mediumint(8) unsigned | NO | PRI | '0' | Quest [See quest_template.entry] which should be rewarded. | |
| mailTemplateId | mediumint(8) unsigned | NO | '0' | Mail template ID [See MailTemplate.dbc]. | ||
| senderEntry | mediumint(8) unsigned | NO | '0' | NPC entry [See creature_template.entry]. |
Description of the fields
event smallint(6)
Event ID [See game_events.entry].
raceMask mediumint(8) unsigned
Races of affected players based on enum Races [See ChrRaces.dbc] in the bitmask form. Values from the table 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 |
quest mediumint(8) unsigned
The quest [See quest_template.entry] which the player should have REWARDED (handed off) for receiving the mail.
mailTemplateId mediumint(8) unsigned
Mail template ID [See MailTemplate.dbc] of the mail which will be sent to the player when all conditions are satisfied.
senderEntry mediumint(8) unsigned
Entry [See creature_template.entry] of the NPC which will sign the mail.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
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 accountSign in
Already have an account? Sign in here.
Sign In Now