Description of the 'npc_trainer_template' table for MaNGOSTwo

The npc_trainer_template table holds spell lists usable for multiple training creatures.

For example, I've created a spell that combines the detection of mines & herbs so that they both appear on the minimap. I simply created an entry in the template table* to reference it as such:

REPLACE INTO mangos0.npc_trainer_template(entry,spell,spellcost,reqskill,reqskillvalue) VALUES (182,50000,100,182,1);

UPDATE mangos0.creature_template SET TrainerTemplateId=182 WHERE (SubName="Herbalism Trainer" AND TrainerType=2 AND (NpcFlags=17 OR NpcFlags=19 OR NpcFlags=21));

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

The unique identifier for the training template. A "creature_template" table references this from its trainer_id column.

spell mediumint(8) unsigned

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc [See Spell.dbc]. This has to be a spell which teaches the actual spell.

spellcost int(10) unsigned

The cost that the player needs to pay in order to learn the spell in copper.

reqskill smallint(5) unsigned

The required skill to be able to learn the spell. This references the skill's entry in the SkillLine.dbc table [See Spell.dbc].

reqskillvalue smallint(5) unsigned

The minimum skill level required for the skill referenced in reqskill.

reqlevel tinyint(3) unsigned

The character level required in order to learn the spell.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'npc_vendor' table for MaNGOSTwo

This table holds the vendor data for all NPCs that sell items. The gold price for each item is in its item template as BuyPrice.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

ID ofNPC which is a vendor, see item_template.entry.

item mediumint(8) unsigned

ID of item, see item_template.entry.

maxcount tinyint(3) unsigned

Maximum count of the available item instances. If equal to 0, ulimited supply.

incrtime int(10) unsigned

Time interval (sec) at the end of which the limited items are fully restored, i.e. come back in stock.

ExtendedCost mediumint(8) unsigned

condition_id mediumint(8) unsigned

ID of condition [See conditions.condition_entry] which player must fulfill to see this item in the stock. If equal to 0, unconditionally.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'npc_vendor_template' table for MaNGOSTwo

The npc_vendor_template table holds item lists usable for multiple vending creatures.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

The unique identifier for the vending template. A "creature_template" table references this from its vendor_id column.

item mediumint(8) unsigned

The item a vendor should sell. This references the "item_template" tables unique ID.

maxcount tinyint(3) unsigned

The maximum amount of the item a vendor should carry. Set to 0 to provide unlimited supplies.

incrtime int(10) unsigned

This field decides how frequently a vendor will restock an item having a maximum count. The value is given in seconds, and for limited items, the BuyCount column of the "item_template" table is taken into account when restocking.

ExtendedCost mediumint(8) unsigned

condition_id mediumint(8) unsigned

This references the "conditions" tables unique ID for which the entry is valid.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'page_text' table for MaNGOSTwo

This table holds the text for letter items or any items that when moused-over turn the cursor into a magnifying glass and on right-click will open up a window where you can read the contents of the letter.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

Reference to item_template.PageText.

text longtext

Text of single page.

next_page mediumint(8) unsigned

ID of the next page, see page_text.entry. Equals to 0 for the last page.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pet_levelstats' table for MaNGOSTwo

This table holds information on individual pet base stats based on level.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

creature_entry mediumint(8) unsigned

Creature ID [See creature_template.entry] of the pet.

level tinyint(3) unsigned

Pet level.

hp smallint(5) unsigned

Pet HP at the level.

mana smallint(5) unsigned

Pet mana points at the level.

armor int(10) unsigned

Pet armor at the level.

str smallint(5) unsigned

Pet strength at the level.

agi smallint(5) unsigned

Pet agility at the level.

sta smallint(5) unsigned

Pet stamina at the level.

inte smallint(5) unsigned

Pet intellect at the level.

spi smallint(5) unsigned

Pet spirit at the level.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pet_name_generation' table for MaNGOSTwo

This table holds pieces of names (first and last half) that are use for pet name generation.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id mediumint(8) unsigned

Table index, increases sequentially starting from 1.

word tinytext

Part of the name.
The first namepart for half equal to 0, the second part otherwise.

entry mediumint(8) unsigned

Creature ID [See creature_template.entry].

half tinyint(4)

Type of the word. If equal to 0, the word is first namepart, otherwise is the second one.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pickpocketing_loot_template' table for MaNGOSTwo

This table format is used to generate different loot items. Loot templates define only items in the loot. See comments about money drop in corpse, pickpocketing and luggage loot in creature_template and item_template.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

The ID of the loot definition (loot template). The rows with the same ID defines a single loot. It is often the same ID as the loot source (item, creature, etc) but when the link is made not on entry field of the Related table then ID can be different. For example, when several loot sources should provide the same loot, single loot definition can be used. In this case the loot sources have the same value in the link field. It is possible also to set up artificial loot templates which are not used directly at all as they have ID which are not referenced from the related source. Such "support templates" can be referenced from "normal" loot templates. When a common or artificial loot template is used a problem arises: what ID to use for that template? Depending on the loot table, different rules can be agreed on to simplify maintenance for the table. Moreover, such rules would be very handy but it seems at the moment there are very few rules explicitly defined. Agreements on entry field values are described there.

item mediumint(8) unsigned

Template ID of the item which can be included into the loot. NOTE: For reference entries this field has no meaning and not used by the core in any way. Yet because of the PRIMARY KEY on the entry + item combination, this field will nonetheless need to be a unique number for each reference entry so that no indexing conflicts arise.

ChanceOrQuestChance float

Meaning of that field is a bit different depending on its sign and the sign of mincountOrRef: Plain entry ChanceOrQuestChance > 0, mincountOrRef > 0 Absolute value of ChanceOrQuestChance (actuallu just the value as it's positive in this case) signifies the percent chance that the item has to drop. Any floating point number is allowed but indeed any value larger that 100 will make the same result as 100. Quest drop ChanceOrQuestChance 0 Just as for plain entries absolute value of ChanceOrQuestChance signifies the percent chance that the item has to drop. But in addition negative ChanceOrQuestChance informs the core that the item should be shown only to characters having appropriate quest. This means that even if item is dropped, in order to see it in the loot the player must have at least one quest that has the item ID in its ReqItemIdN fields or in its ReqSourceIdN fields. The player must also have less copies of the item than ReqItemCountN or ReqSourceCountN. Chanced references mincountOrRef

groupid tinyint(3) unsigned

A group is a set of loot definitions processed in such a way that at any given looting event the loot generated can receive only 1 (or none) item from the items declared in the loot definitions of the group. Groups are formed by loot definitions having the same values of entry and groupid fields. A group may consists of explicitly-chanced (having non-zero ChanceOrQuestChance) and equal-chanced (ChanceOrQuestChance = 0) entries. Every equal-chanced entry of a group is considered having such a chance that: ¦all equal-chanced entries have the same chance ¦group chance (sum of chances of all entries) is 100% Of course group may consist of ¦only explicitly-chanced entries or ¦only equal-chanced entries or ¦entries of both type. The easies way to understand what are groups is to understand how core processes grouped entries: At loading time: ¦groups are formed - all grouped entries with the same values of groupid and entry fields are gathered into two sets - one for explicitly-chanced entries and one for equal-chanced. Note that order of entries in the sets can not be defined by DB - you should assume that the entries are in an unknown order. But indeed every time core processes a group the entries are in some order, constant during processing. During loot generation: ¦core rolls for explicitly-chanced entries (if any): ¦a random number R is rolled in range 0 to 100 (floating point value). ¦chance to drop is checked for every (explicitly-chanced) entry in the group: ¦if R is less than absolute value of ChanceOrQuestChance of the entry then the entry 'wins': the item is included in the loot. Group processing stops, the rest of group entries are just skipped. ¦otherwise the entry 'looses': the item misses its chance to get into the loot. R is decreased by the absolute value of ChanceOrQuestChance and next explicitly-chanced entry is checked. ¦if none of explicitly-chanced entries got its chance then equal-chanced part (if any) is processed: ¦a random entry is selected from the set of equal-chanced entries and corresponding item is included in the loot. ¦If nothing selected yet (this never happens if the group has some equal-chanced entries) - no item from the group is included into the loot. Let us use term group chance as the sum of ChanceOrQuestChance (absolute) values for the group. Please note that even one equal-chanced entry makes group chance to be 100% (provided that sum of explicit chances does not exceed 100%). If you understand the process you can understand the results: ¦Not more than one item from a group may drop at any given time. ¦If group chance is at least 100 then one item will be dropped for sure. ¦If group chance does not exceed 100 then every item defined in group entries has exactly that chance to drop as set in ChanceOrQuestChance. ¦If group chance is greater than 100 then some entries will lost a part of their chance (or even not be checked at all - that will be the case for all equal-chanced entries) whatever value takes the roll R. So for some items chance to drop will be less than their ChanceOrQuestChance. That is very bad and that is why having group chance > 100 is strictly prohibited. ¦Processing of equal-chanced part takes much less time then of explicitly-chanced one. So usage of equal-chanced groups is recommended when possible. So now basic applications of the groups are clear: ¦Groups with group chance of 100% generate exactly one item every time. This is needed quite often, for example such behavior is needed to define a loot template for tier item drop from a boss. ¦Groups with group chance

mincountOrRef mediumint(9)

Depending on the value of the field it may either define the minimum number of copies for the item to be dropped, or it may reference another loot template.

maxcount tinyint(3) unsigned

For non-reference entries - the maximum number of copies of the item that can drop in a single loot. For references value of maxcount field is used as a repetition factor for references - the reference will be processed not just once but exactly maxcount times. This is designed to serve a single purpose: to make definition of tier token drops a bit simplier (tokens of a tier are defined as a 100%-chance group of an artificial template and bosses' loot templates include 100%-chanced reference to that group with repetition factor of 2 or 3 depending on the case). Using non-1 repetition factor for other things (references to a group with group chance less than 100% or chanced references with chance less than 100%) must be agreed with UDB devs first (and described here). Note: core rolls chance for any loot definition entry just one time - so if a references looses its chance it is skipped for the current loot completely whatever is maxcount value.

condition_id mediumint(8) unsigned

Value that represents a loot condition that must be filled in order for the item to drop. This field combined with condition_value1-2 fields can provide conditions on when an item can be dropped. Value Condition Comments 0 CONDITION_NONE Regular drop 1 CONDITION_AURA Player looting must have an aura active 2 CONDITION_ITEM Player must have a number of items in his/her inventory 3 CONDITION_ITEM_EQUIPPED Player must have an item equipped 4 CONDITION_ZONEID Player must be in a certain zone 5 CONDITION_REPUTATION_RANK Player must have a certain reputation rank with a certain faction 6 CONDITION_TEAM Player must be part of the specified team (Alliance or Horde) 7 CONDITION_SKILL Player must have a certain skill value 8 CONDITION_QUESTREWARDED Player must have completed a quest first 9 CONDITION_QUESTTAKEN Players must have the quest in the quest log and not completed yet 10 CONDITION_AD_COMMISSION_AURA 11 CONDITION_NO_AURA Player looting must have no aura active mentioned in condition_value1 12 CONDITION_ACTIVE_EVENT The loot with that condition can be looted only while the Event (condition_value1) is active NOTE: For reference entries this field has no meaning, not used by the core in any way and should have the default value of 0.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'player_classlevelstats' table for MaNGOSTwo

This table holds information on the base health and mana of characters when they level up. Each class has different level stats. All of the values in this table signify only the base health and mana of the class at a specific level.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

class tinyint(3) unsigned

level tinyint(3) unsigned

basehp smallint(5) unsigned

basemana smallint(5) unsigned

Base mana value for any creature of this level and class.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'player_levelstats' table for MaNGOSTwo

This table holds information on what stats are gained by characters when they level up. Each race-class combination has different level stats. All of the values in this table signify only the base stats of the race-class combination at a specific level.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

race tinyint(3) unsigned

A bit-mask corresponding to races that should get the spell. The value has to match with races defined in ChrRaces.dbc.

class tinyint(3) unsigned

A bit-mask corresponding to class that should get the spell. The value has to match with classes defined in ChrClasses.dbc.

level tinyint(3) unsigned

The level at which the stats should be applied.

str tinyint(3) unsigned

The base strength of the character.

agi tinyint(3) unsigned

The base agility of the character.

sta tinyint(3) unsigned

The base stamina of the character.

inte tinyint(3) unsigned

The base intellect of the character.

spi tinyint(3) unsigned

The base spirit of the character.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'player_xp_for_level' table for MaNGOSTwo

Includes information on how much experience needed for next level.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

lvl int(3) unsigned

The player's level.

xp_for_next_level int(10) unsigned

The experience needed to upgrade from the value in lvl field to lvl +1.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'playercreateinfo' table for MaNGOSTwo

This table holds the start positions of each class-race combinations for all newly created characters.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

race tinyint(3) unsigned

A bit-mask corresponding to races that should get the spell. The value has to match with races defined in ChrRaces.dbc.

class tinyint(3) unsigned

A bit-mask corresponding to class that should get the spell. The value has to match with classes defined in ChrClasses.dbc.

map smallint(5) unsigned

A map identifier. The value has to match with a map identifier defined in Map.dbc.

zone mediumint(8) unsigned

A zone identifier. The value has to match with a map identifier defined in AreaTable.dbc.

position_x float

The X position for the characters initial position.

position_y float

The Y position for the characters initial position.

position_z float

The Z position for the characters initial position.

orientation float

The orientation for the characters initial position.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'playercreateinfo_action' table for MaNGOSTwo

This table holds information on what default actions a brand new character should start out with. Each race-class combination can have a different default starting setup.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

race tinyint(3) unsigned

A bit-mask corresponding to races that should get the spell. The value has to match with races defined in ChrRaces.dbc.

class tinyint(3) unsigned

A bit-mask corresponding to class that should get the spell. The value has to match with classes defined in ChrClasses.dbc.

button smallint(5) unsigned

The ID of the button on the action bar where the action icon will be placed. Special bars are used for stances, auras, pets, stealth and other similar special modes.

action int(11) unsigned

Depending on the type value, this could reference either a spell identifier as defined in Spell.dbc, a reference to the unique identifier of an "item_template" table, or the identifier for a macro.

type smallint(5) unsigned

The following values are valid types:

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'playercreateinfo_item' table for MaNGOSTwo

This table holds information on what items each race-class combination of a new character starts out with.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

race tinyint(3) unsigned

A bit-mask corresponding to races that should get the spell. The value has to match with races defined in ChrRaces.dbc.

class tinyint(3) unsigned

A bit-mask corresponding to class that should get the spell. The value has to match with classes defined in ChrClasses.dbc.

itemid mediumint(8) unsigned

The item a character should receive upon creation. This references the "item_template" tables unique ID.

amount tinyint(3) unsigned

The number of copies of the item to be awarded.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'playercreateinfo_spell' table for MaNGOSTwo

This table holds information on what spells newly created characters should start out with. A character in this table is defined by his/her race and class combination.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

race tinyint(3) unsigned

A bit-mask corresponding to races that should get the spell. The value has to match with races defined in ChrRaces.dbc.

class tinyint(3) unsigned

A bit-mask corresponding to class that should get the spell. The value has to match with classes defined in ChrClasses.dbc.

Spell mediumint(8) unsigned

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc.

Note varchar(255)

A note explaining what the spell is. This is only for reference purposes.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'points_of_interest' table for MaNGOSTwo

This table holds definitions for points of interests in various locations.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

POI ID.

x float

X coordinate of the POI.

y float

Y coordinate of the POI.

icon mediumint(8) unsigned

Icon for the POI. An incomplete list of icons follows.

flags mediumint(8) unsigned

data mediumint(8) unsigned

Custom data to be sent for a point of interest. This currently is 0 for all points of interests in vanilla WoW.

icon_name text

The text to display as tooltip for the icon on the in-game map.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pool_creature' table for MaNGOSTwo

Contains all pool instances that participate, in particular, to any game event.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

guid int(10) unsigned

GUID of the creature, see creature.guid.

pool_entry mediumint(8) unsigned

ID of the pool, see pool_template.entry.

chance float unsigned

Chance (%) for the creature to be spawned in the pool.
Either the sum of chances should be equal to 100, or all the chances for a pool should be 0. The latter is provided for description of even-chance pools.

description varchar(255)

Textual description ignored by the core.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pool_creature_template' table for MaNGOSTwo

Contains all pool instances that participate, in particular, to any game event.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(10) unsigned

ID of the creature, see creature_template.entry.

pool_entry mediumint(8) unsigned

Pool ID [See pool_template.entry].

chance float unsigned

Chance (%) of the creature to be spawned within the pool.
For a pool, either sum of chances should be equal to 100, or all chances should be 0. The latter describes an even-chanced pool.

description varchar(255)

Textual description, ignored by the core.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pool_gameobject' table for MaNGOSTwo

Contains all pool instances that participate, in particular, to any game event.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

guid int(10) unsigned

GUID of the gameobject, see gameobject.guid.

pool_entry mediumint(8) unsigned

ID of the pool, see pool_template.entry.

chance float unsigned

Chance (%) for the gameobject to be spawned within the pool.
For a pool, either the sum of chances should be equal to 100, or all chances should be 0. The latter describes an even-chanced pool.

description varchar(255)

Textual description, ignored by the core.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pool_gameobject_template' table for MaNGOSTwo

Contains all pool instances that participate, in particular, to any game event.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(10) unsigned

ID of the gameobject, see gameobject_template.entry.

pool_entry mediumint(8) unsigned

ID of the pool, see pool_template.entry.

chance float unsigned

Chance (%) for the gameobject to be spawned within the pool.
For a pool, either the sum of chances should be equal to 100, or all chances should be 0. The latter describes an even-chanced pool.

description varchar(255)

Textual description, ignored by the core.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pool_pool' table for MaNGOSTwo

This is the pool of pools table. Like creatures and gameobjects, pools are the objects that may be gathered into other pools. You can create a pool with a chance of a range of pools in that pool being activated.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

pool_id mediumint(8) unsigned

ID of the pool, see pool_template.entry.

mother_pool mediumint(8) unsigned

ID of the pool to which the pool belongs.

chance float

Chance (%) for the pool to be spawned within the mother pool.
For a pool, either the sum of chances should be equal to 100, or all chances should be 0. The latter describes an even-chanced pool.

description varchar(255)

Textual description, ignored by the core.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pool_template' table for MaNGOSTwo

Defines all pool instances that participate, in particular, to any game event.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

ID of the pool. It is mentioned in other pool_* tables like pool_creature.pool_entry.

max_limit int(10) unsigned

Maximum number of entities spawned within the pool.

description varchar(255)

Textual description, ignored by the core.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'prospecting_loot_template' table for MaNGOSTwo

'Loot System'

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

item mediumint(8) unsigned

ChanceOrQuestChance float

groupid tinyint(3) unsigned

mincountOrRef mediumint(9)

maxcount tinyint(3) unsigned

condition_id mediumint(8) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'quest_poi' table for MaNGOSTwo

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

questId mediumint(8) unsigned

poiId tinyint(3) unsigned

objIndex int(11)

mapId int(11) unsigned

mapAreaId mediumint(8) unsigned

floorId tinyint(3) unsigned

unk3 int(11) unsigned

unk4 int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'quest_poi_points' table for MaNGOSTwo

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

questId mediumint(8) unsigned

poiId tinyint(3) unsigned

x int(11)

y int(11)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'quest_relations' table for MaNGOSTwo

This table holds the relations of various objects and quests

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

actor tinyint(3) unsigned

Entity involved in quest:

entry int(11) unsigned

Creature or GO entry from *_template, AreaTrigger ID

quest int(11) unsigned

Quest ID from quest_template

role tinyint(3) unsigned

Role of the actor:

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'quest_template' table for MaNGOSTwo

Contains all basic definitions of quests available.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry mediumint(8) unsigned

The unique identifier of the quest template entry.

Method tinyint(3) unsigned

This flag decides how a quest will be handled.
Allowed values: 0 autocompleted, 1 disabled, 2 usual handling.

ZoneOrSort smallint(6)

Defines the category under which a quest will be listed in the in-game quest log. Depending on the sign of the value different category sources will be used. * If the value is > 0, the value references an entry from AreaTable.dbc. * If the value is < 0, the value references an entry from QuestSort.dbc. This is usually the case for class or skill related quests.

MinLevel tinyint(3) unsigned

The lowest level allowed to accept the quest.

QuestLevel smallint(6)

The quest's level. Depending on the quest's level, the experience rewarded for the quest will be awarded. *If a character's level is <= QuestLevel+5, full experience will be given. *If QuestLevel is set to -1, the character's level will be used as QuestLevel.

Type smallint(5) unsigned

Classifies a quest's difficulty. This references an entry from QuestInfo.dbc [See QuestInfo.dbc]. The following table lists allowed values:

Type	Value	Meaning
QUEST_TYPE_ELITE	1	Killing an elite mob.
QUEST_TYPE_LIFE	21	Character should not die during the quest.
QUEST_TYPE_PVP	41	Killing other characters or PvP flagged NPCs.
QUEST_TYPE_RAID	62	Completable in raid only.
QUEST_TYPE_DUNGEON	81	Dungeon-related.
QUEST_TYPE_WORLD_EVENT	82	Calendar event related.
QUEST_TYPE_LEGENDARY	83	Unique and complex.
QUEST_TYPE_ESCORT	84	(Escort quest is not listed in QuestInfo.dbc.)

RequiredClasses smallint(5) unsigned

Bitmask of the classes which may obtain the quest (any if 0).

Class	Value (hex)	Value (dec)
CLASS_WARRIOR	0x1	1
CLASS_PALADIN	0x2	2
CLASS_HUNTER	0x4	4
CLASS_ROGUE	0x8	8
CLASS_PRIEST	0x10	16
CLASS_DEATHKNIGHT	0x20	32
CLASS_SHAMAN	0x40	64
CLASS_MAGE	0x80	128
CLASS_WARLOCK	0x100	256
CLASS_DRUID	0x400	1024

RequiredRaces smallint(5) unsigned

Mask of the races which may obtain the quest (any if 0).

Race	Mask Value (hex)	Mask Value (dec)	First Expansion Available
Human	0x1	1	Classic
Orc	0x2	2	Classic
Dwarf	0x4	4	Classic
Night Elf	0x8	8	Classic
Undead	0x10	16	Classic
Tauren	0x20	32	Classic
Gnome	0x40	64	Classic
Troll	0x80	128	Classic
Goblin	0x100	256	Classic
Blood Elf	0x200	512	TBC
Dranei	0x400	1024	TBC
Fel Orc	0x800	2048	TBC
Naga	0x1000	4096	TBC
Broken	0x2000	8192	TBC
Skeleton	0x4000	16384	TBC
Vrykul	0x8000	32768	WotLK
Turkarr	0x10000	65536	WotLK
Forest Troll	0x20000	131072	WotLK
Taunka	0x40000	262144	WotLK
Northrend Skeleton	0x80000	524288	WotLK
Ice Troll	0x100000	1048576	WotLK
Worgen	0x200000	2097152	Cata

RequiredSkill smallint(5) unsigned

Skill type required from character to obtain the quest.

Skill name	Value
SKILL_FROST	6
SKILL_FIRE	8
SKILL_ARMS	26
SKILL_COMBAT	38
SKILL_SUBTLETY	39
SKILL_POISONS	40
SKILL_SWORDS	43
SKILL_AXES	44
SKILL_BOWS	45
SKILL_GUNS	46
SKILL_BEAST_MASTERY	50
SKILL_SURVIVAL	51
SKILL_MACES	54
SKILL_2H_SWORDS	55
SKILL_HOLY	56
SKILL_SHADOW	78
SKILL_DEFENSE	95
SKILL_LANG_COMMON	98
SKILL_RACIAL_DWARVEN	101
SKILL_LANG_ORCISH	109
SKILL_LANG_DWARVEN	111
SKILL_LANG_DARNASSIAN	113
SKILL_LANG_TAURAHE	115
SKILL_DUAL_WIELD	118
SKILL_RACIAL_TAUREN	124
SKILL_ORC_RACIAL	125
SKILL_RACIAL_NIGHT_ELF	126
SKILL_FIRST_AID	129
SKILL_FERAL_COMBAT	134
SKILL_STAVES	136
SKILL_LANG_THALASSIAN	137
SKILL_LANG_DRACONIC	138
SKILL_LANG_DEMON_TONGUE	139
SKILL_LANG_TITAN	140
SKILL_LANG_OLD_TONGUE	141
SKILL_SURVIVAL2	142
SKILL_RIDING_HORSE	148
SKILL_RIDING_WOLF	149
SKILL_RIDING_TIGER	150
SKILL_RIDING_RAM	152
SKILL_SWIMING	155
SKILL_2H_MACES	160
SKILL_UNARMED	162
SKILL_MARKSMANSHIP	163
SKILL_BLACKSMITHING	164
SKILL_LEATHERWORKING	165
SKILL_ALCHEMY	171
SKILL_2H_AXES	172
SKILL_DAGGERS	173
SKILL_THROWN	176
SKILL_HERBALISM	182
SKILL_GENERIC_DND	183
SKILL_RETRIBUTION	184
SKILL_COOKING	185
SKILL_MINING	186
SKILL_PET_IMP	188
SKILL_PET_FELHUNTER	189
SKILL_TAILORING	197
SKILL_ENGINEERING	202
SKILL_PET_SPIDER	203
SKILL_PET_VOIDWALKER	204
SKILL_PET_SUCCUBUS	205
SKILL_PET_INFERNAL	206
SKILL_PET_DOOMGUARD	207
SKILL_PET_WOLF	208
SKILL_PET_CAT	209
SKILL_PET_BEAR	210
SKILL_PET_BOAR	211
SKILL_PET_CROCILISK	212
SKILL_PET_CARRION_BIRD	213
SKILL_PET_CRAB	214
SKILL_PET_GORILLA	215
SKILL_PET_RAPTOR	217
SKILL_PET_TALLSTRIDER	218
SKILL_RACIAL_UNDED	220
SKILL_CROSSBOWS	226
SKILL_WANDS	228
SKILL_POLEARMS	229
SKILL_PET_SCORPID	236
SKILL_ARCANE	237
SKILL_PET_TURTLE	251
SKILL_ASSASSINATION	253
SKILL_FURY	256
SKILL_PROTECTION	257
SKILL_BEAST_TRAINING	261
SKILL_PROTECTION2	267
SKILL_PET_TALENTS	270
SKILL_PLATE_MAIL	293
SKILL_LANG_GNOMISH	313
SKILL_LANG_TROLL	315
SKILL_ENCHANTING	333
SKILL_DEMONOLOGY	354
SKILL_AFFLICTION	355
SKILL_FISHING	356
SKILL_ENHANCEMENT	373
SKILL_RESTORATION	374
SKILL_ELEMENTAL_COMBAT	375
SKILL_SKINNING	393
SKILL_MAIL	413
SKILL_LEATHER	414
SKILL_CLOTH	415
SKILL_SHIELD	433
SKILL_FIST_WEAPONS	473
SKILL_RIDING_RAPTOR	533
SKILL_RIDING_MECHANOSTRIDER	553
SKILL_RIDING_UNDEAD_HORSE	554
SKILL_RESTORATION2	573
SKILL_BALANCE	574
SKILL_DESTRUCTION	593
SKILL_HOLY2	594
SKILL_DISCIPLINE	613
SKILL_LOCKPICKING	633
SKILL_PET_BAT	653
SKILL_PET_HYENA	654
SKILL_PET_OWL	655
SKILL_PET_WIND_SERPENT	656
SKILL_LANG_GUTTERSPEAK	673
SKILL_RIDING_KODO	713
SKILL_RACIAL_TROLL	733
SKILL_RACIAL_GNOME	753
SKILL_RACIAL_HUMAN	754
SKILL_PET_EVENT_RC	758
SKILL_RIDING	762

RequiredSkillValue smallint(5) unsigned

Required value of the skill allowing character to obtain the quest.

RepObjectiveFaction smallint(5) unsigned

Faction [See Faction.dbc] to which the character should have a given reputation for completing the quest.

RepObjectiveValue mediumint(9)

The value of the reputation the character should have to a given faction for completing the quest.

RequiredMinRepFaction smallint(5) unsigned

The faction [See Faction.dbc] to which the character should have a given reputation value (not below) for obtaining the quest.

RequiredMinRepValue mediumint(9)

The reputation value that should not be above the character standing in order to obtain teh quest.

RequiredMaxRepFaction smallint(5) unsigned

If a quest is obtainable if the character has a specific maximum reputation with a faction, this value is set to a faction identifier, referencing an entry from the Faction.dbc table.

RequiredMaxRepValue mediumint(9)

If RequiredManRepFaction is defined, this value specifies the highest reputation value allowed for obtaining the quest.

SuggestedPlayers tinyint(3) unsigned

If a quest would require more characters to cooperate for completing the quest - when the characters are in a valid level range - this value may be set to the amount of characters recommended to group up for completing the quest.

LimitTime int(10) unsigned

Setting this to a value in seconds will put a time limit on a quest, ticking from the moment a quest was accepted.

QuestFlags mediumint(8) unsigned

The quest flags give additional details on the quest type. Flags set here will determine mostly grouping behaviour. Multiple flags may be combined.

The following table list known flags.

Value	Name	Description
0	QUEST_FLAGS_NONE	Nothing special going on.
1	QUEST_FLAGS_STAY_ALIVE	If the character dies, the quest will fail
2	QUEST_FLAGS_PARTY_ACCEPT	If the character is grouped, all players that can accept this quest will receive confirmation box to accept quest
4	QUEST_FLAGS_EXPLORATION	Quest requires the character to explore a zone
8	QUEST_FLAGS_SHARABLE	Quest may be shared with other characters
16	QUEST_FLAGS_UNUSED1	Not used by any quest.
32	QUEST_FLAGS_EPIC	Epic class quests?
64	QUEST_FLAGS_RAID	Raid quests.
128	QUEST_FLAGS_UNUSED2	Not used by any quest.
256	QUEST_FLAGS_UNK2	Not used currently: DELIVERMORE Quest needs more than normal q-item drops from mobs
512	QUEST_FLAGS_HIDDEN_REWARDS	Items and money rewarded only sent in SMSG_QUESTGIVER_OFFER_REWARD (not in SMSG_QUESTGIVER_QUEST_DETAILS or in client quest log(SMSG_QUEST_QUERY_RESPONSE))
1024	QUEST_FLAGS_AUTO_REWARDED	These quests are automatically rewarded on quest complete and they will never appear in quest log client side.

Note:
Not all quest flags are currently supported by the core.

SpecialFlags tinyint(3) unsigned

If quests need any special behaviour, these flags can be used to allow for it. Multiple special flags may be combined.

Currently the following special cases are available.

Value	Description
0	Nothing special going on.
1	The quest is repeatable.
2	Quest requires exploration or an event, handled by the script library.

CharTitleId tinyint(3) unsigned

PlayersSlain tinyint(3) unsigned

BonusTalents tinyint(3) unsigned

PrevQuestId mediumint(9)

This points to a "quest_template" table being a previous requirement. Depending on the signedness of the value, different requirements are set.

If the value is > 0, the given quest needs to be completed prior to getting this quest.
If the value is < 0, the given quest has to be active in the quest log to get this quest.

NextQuestId mediumint(9)

This points to a "quest_template" table being a follow-up. Depending on the signedness of the value, different requirements are set.

If the value is > 0, this contains the quest identifier of the next quest, if setting the previous quest identifier on it is not sufficient.
If the value is < 0, this contains a quest identifier for quests where multiple follow-ups are possible. Previous quest identifier can be set to this quest identifier, too.

ExclusiveGroup mediumint(9)

Allows to group multiple quests into a group, where only one quest can be completed from, or all quests need to be completed.

If the value is > 0, all quests having this value set, will be put into a group of which only one quest may be completed to get this quest.
If the value is < 0, all quests having this value set, will be put into a group of which all quests have to be completed to get this quest.

NextQuestInChain mediumint(8) unsigned

If ending a quest should immediately start a new quest set this to a quest identifier referencing the "quest_template" table.

RewXPId tinyint(3) unsigned

SrcItemId mediumint(8) unsigned

If starting a quest should give items to the character, set this field to an item identifier referencing the "item_template" table.

SrcItemCount tinyint(3) unsigned

If SrcItemId is set, this can be set to the amount of item copies to give to the character.

SrcSpell mediumint(8) unsigned

If a spell should be casted on a character upon starting the quest, set this to a spell identifier referencing the Spell.dbc table.

Title text

The title of the quest.

Details text

The quest text, supporting a few variables to insert character related data into the quest's text.

Value	Description
%S	Creature Name
$A	Achievement
$B	Carriage Return
$C	Character Class
$GmaleText:FemaleText;	Gender Text - See Below
$N	Character Name
$R	Character Race
$T	Character Title (Wotlk and above)
$G Example:
Such a generous $G man:woman;, you will go far
The order male:female needs to be kept

Objectives text

The quest's objective in text form. If the quest should auto-complete, leave this empty.

OfferRewardText text

The text sent to a character when talking to the quest giver, and having completed the quest. Variables are supported.

Varible Placeholders:

Value	Description
$B	Line break
$N	Character name
$R	Character race
$C	Character class
$G m:f	Inserts string based on character gender. Example: Such a generous $G man:woman. The order male:female needs to be kept.

RequestItemsText text

The text sent to a character when talking to a quest giver, and not missing to fulfill the quest's requirements. Variables are supported.

Value	Description
$B	Line break
$N	Character name
$R	Character race
$C	Character class
$G m:f	Inserts string based on character gender. Example: Such a generous $G man:woman. The order male:female needs to be kept.

EndText text

If the quest's SpecialFlag requires an action validated by the script library this text will be sent to the character.

CompletedText text

ObjectiveText1 text

Set to a text string, to show up as requirement in the quest log entry.

ObjectiveText2 text

Set to a text string, to show up as requirement in the quest log entry.

ObjectiveText3 text

Set to a text string, to show up as requirement in the quest log entry.

ObjectiveText4 text

Set to a text string, to show up as requirement in the quest log entry.

ReqItemId1 mediumint(8) unsigned

If set to an item identifier, this references an entry in the "item_template" table which is required to complete the quest.

ReqItemId2 mediumint(8) unsigned

If set to an item identifier, this references an entry in the "item_template" table which is required to complete the quest.

ReqItemId3 mediumint(8) unsigned

If set to an item identifier, this references an entry in the "item_template" table which is required to complete the quest.

ReqItemId4 mediumint(8) unsigned

If set to an item identifier, this references an entry in the "item_template" table which is required to complete the quest.

ReqItemId5 mediumint(8) unsigned

If set to an item identifier, this references an entry in the "item_template" table which is required to complete the quest.

ReqItemId6 mediumint(8) unsigned

If set to an item identifier, this references an entry in the "item_template" table which is required to complete the quest.

ReqItemCount1 smallint(5) unsigned

If ReqItemId1 is set, this defines the amount of items needed to complete the quest.

ReqItemCount2 smallint(5) unsigned

If ReqItemId2 is set, this defines the amount of items needed to complete the quest.

ReqItemCount3 smallint(5) unsigned

If ReqItemId3 is set, this defines the amount of items needed to complete the quest.

ReqItemCount4 smallint(5) unsigned

If ReqItemId4 is set, this defines the amount of items needed to complete the quest.

ReqItemCount5 smallint(5) unsigned

If ReqItemId5 is set, this defines the amount of items needed to complete the quest.

ReqItemCount6 smallint(5) unsigned

If ReqItemId6 is set, this defines the amount of items needed to complete the quest.

ReqSourceId1 mediumint(8) unsigned

If the quest requires items created by using another item, set this to an item identifier, referencing the creating items entry in the "item_template" table.

Note:
This is required to decide if these items should be included in loot or not.

ReqSourceId2 mediumint(8) unsigned

If the quest requires items created by using another item, set this to an item identifier, referencing the creating items entry in the "item_template" table.

Note:
This is required to decide if these items should be included in loot or not.

ReqSourceId3 mediumint(8) unsigned

If the quest requires items created by using another item, set this to an item identifier, referencing the creating items entry in the "item_template" table.

Note:
This is required to decide if these items should be included in loot or not.

ReqSourceId4 mediumint(8) unsigned

If the quest requires items created by using another item, set this to an item identifier, referencing the creating items entry in the "item_template" table.

Note:
This is required to decide if these items should be included in loot or not.

ReqSourceCount1 smallint(5) unsigned

If ReqSourceId1 is set, set this to the amount of required items.

ReqSourceCount2 smallint(5) unsigned

If ReqSourceId2 is set, set this to the amount of required items.

ReqSourceCount3 smallint(5) unsigned

If ReqSourceId3 is set, set this to the amount of required items.

ReqSourceCount4 smallint(5) unsigned

If ReqSourceId4 is set, set this to the amount of required items.

ReqCreatureOrGOId1 mediumint(9)

If the quest targets creatures or game objects, this references their unique identifier.

If the value is > 0, this references an entry in the "creature_template" table.
If the value is < 0, this references an entry in the "gameobject_template" table.

ReqCreatureOrGOId2 mediumint(9)

If the quest targets creatures or game objects, this references their unique identifier.

If the value is > 0, this references an entry in the "creature_template" table.
If the value is < 0, this references an entry in the "gameobject_template" table.

ReqCreatureOrGOId3 mediumint(9)

If the quest targets creatures or game objects, this references their unique identifier.

If the value is > 0, this references an entry in the "creature_template" table.
If the value is < 0, this references an entry in the "gameobject_template" table.

ReqCreatureOrGOId4 mediumint(9)

If the quest targets creatures or game objects, this references their unique identifier.

If the value is > 0, this references an entry in the "creature_template" table.
If the value is < 0, this references an entry in the "gameobject_template" table.

ReqCreatureOrGOCount1 smallint(5) unsigned

The amount of creatures or game objects required for the quest.

ReqCreatureOrGOCount2 smallint(5) unsigned

The amount of creatures or game objects required for the quest.

ReqCreatureOrGOCount3 smallint(5) unsigned

The amount of creatures or game objects required for the quest.

ReqCreatureOrGOCount4 smallint(5) unsigned

The amount of creatures or game objects required for the quest.

ReqSpellCast1 mediumint(8) unsigned

Set to an entry referencing an entry from Spell.dbc table to require a spell to be cast. Spells usually need a target identifier set in the ReqCreatureOrGOId1.

If a spell has an effect to send and event or signal quest completion, targets do not have to be set.

ReqSpellCast2 mediumint(8) unsigned

Set to an entry referencing an entry from Spell.dbc table to require a spell to be cast. Spells usually need a target identifier set in the ReqCreatureOrGOId2.

If a spell has an effect to send and event or signal quest completion, targets do not have to be set.

ReqSpellCast3 mediumint(8) unsigned

Set to an entry referencing an entry from Spell.dbc table to require a spell to be cast. Spells usually need a target identifier set in the ReqCreatureOrGOId3.

If a spell has an effect to send and event or signal quest completion, targets do not have to be set.

ReqSpellCast4 mediumint(8) unsigned

Set to an entry referencing an entry from Spell.dbc table to require a spell to be cast. Spells usually need a target identifier set in the ReqCreatureOrGOId4.

If a spell has an effect to send and event or signal quest completion, targets do not have to be set.

RewChoiceItemId1 mediumint(8) unsigned

If the quest allows to choose between multiple items as a reward, this field contains an item identifier of one of the possible rewards, referencing the item's entry in the "item_template" table.

RewChoiceItemId2 mediumint(8) unsigned

If the quest allows to choose between multiple items as a reward, this field contains an item identifier of one of the possible rewards, referencing the item's entry in the "item_template" table.

RewChoiceItemId3 mediumint(8) unsigned

If the quest allows to choose between multiple items as a reward, this field contains an item identifier of one of the possible rewards, referencing the item's entry in the "item_template" table.

RewChoiceItemId4 mediumint(8) unsigned

If the quest allows to choose between multiple items as a reward, this field contains an item identifier of one of the possible rewards, referencing the item's entry in the "item_template" table.

RewChoiceItemId5 mediumint(8) unsigned

If the quest allows to choose between multiple items as a reward, this field contains an item identifier of one of the possible rewards, referencing the item's entry in the "item_template" table.

RewChoiceItemId6 mediumint(8) unsigned

If the quest allows to choose between multiple items as a reward, this field contains an item identifier of one of the possible rewards, referencing the item's entry in the "item_template" table.

RewChoiceItemCount1 smallint(5) unsigned

If RewChoiceItemId1 contains an item identifier, this defines the number of charges available for the rewarded item.

RewChoiceItemCount2 smallint(5) unsigned

If RewChoiceItemId2 contains an item identifier, this defines the number of charges available for the rewarded item.

RewChoiceItemCount3 smallint(5) unsigned

If RewChoiceItemId3 contains an item identifier, this defines the number of charges available for the rewarded item.

RewChoiceItemCount4 smallint(5) unsigned

If RewChoiceItemId4 contains an item identifier, this defines the number of charges available for the rewarded item.

RewChoiceItemCount5 smallint(5) unsigned

If RewChoiceItemId5 contains an item identifier, this defines the number of charges available for the rewarded item.

RewChoiceItemCount6 smallint(5) unsigned

If RewChoiceItemId6 contains an item identifier, this defines the number of charges available for the rewarded item.

RewItemId1 mediumint(8) unsigned

If the quest rewards items without any choice, this contains an item identifier, referencing the item's entry in the "item_template" table.

RewItemId2 mediumint(8) unsigned

If the quest rewards items without any choice, this contains an item identifier, referencing the item's entry in the "item_template" table.

RewItemId3 mediumint(8) unsigned

If the quest rewards items without any choice, this contains an item identifier, referencing the item's entry in the "item_template" table.

RewItemId4 mediumint(8) unsigned

If the quest rewards items without any choice, this contains an item identifier, referencing the item's entry in the "item_template" table.

RewItemCount1 smallint(5) unsigned

If RewItemId1 contains an item identifier, this defines the amount if items to be rewarded.

RewItemCount2 smallint(5) unsigned

If RewItemId2 contains an item identifier, this defines the amount if items to be rewarded.

RewItemCount3 smallint(5) unsigned

If RewItemId3 contains an item identifier, this defines the amount if items to be rewarded.

RewItemCount4 smallint(5) unsigned

If RewItemId4 contains an item identifier, this defines the amount if items to be rewarded.

RewRepFaction1 smallint(5) unsigned

If the quest should reward reputation towards a faction, this references a faction identifier from the Faction.dbc table.

Note
This is intended to reward extra reputation. Normal reputation is awarded automatically by the server.

RewRepFaction2 smallint(5) unsigned

If the quest should reward reputation towards a faction, this references a faction identifier from the Faction.dbc table.

Note
This is intended to reward extra reputation. Normal reputation is awarded automatically by the server.

RewRepFaction3 smallint(5) unsigned

If the quest should reward reputation towards a faction, this references a faction identifier from the Faction.dbc table.

Note
This is intended to reward extra reputation. Normal reputation is awarded automatically by the server.

RewRepFaction4 smallint(5) unsigned

If the quest should reward reputation towards a faction, this references a faction identifier from the Faction.dbc table.

Note
This is intended to reward extra reputation. Normal reputation is awarded automatically by the server.

RewRepFaction5 smallint(5) unsigned

If the quest should reward reputation towards a faction, this references a faction identifier from the Faction.dbc table.

Note
This is intended to reward extra reputation. Normal reputation is awarded automatically by the server.

RewRepValueId1 tinyint(3)

Notes: This defines the amount of reputation gain or loss for the referenced faction.

RewRepValueId2 tinyint(3)

Notes: This defines the amount of reputation gain or loss for the referenced faction.

RewRepValueId3 tinyint(3)

Notes: This defines the amount of reputation gain or loss for the referenced faction.

RewRepValueId4 tinyint(3)

Notes: This defines the amount of reputation gain or loss for the referenced faction.

RewRepValueId5 tinyint(3)

Notes: This defines the amount of reputation gain or loss for the referenced faction.

RewRepValue1 mediumint(9)

If RewRepFaction1 references a faction, this defines the amount of reputation gain or loss for the referenced faction.

RewRepValue2 mediumint(9)

If RewRepFaction2 references a faction, this defines the amount of reputation gain or loss for the referenced faction.

RewRepValue3 mediumint(9)

If RewRepFaction3 references a faction, this defines the amount of reputation gain or loss for the referenced faction.

RewRepValue4 mediumint(9)

If RewRepFaction4 references a faction, this defines the amount of reputation gain or loss for the referenced faction.

RewRepValue5 mediumint(9)

If RewRepFaction5 references a faction, this defines the amount of reputation gain or loss for the referenced faction.

RewHonorAddition int(10) unsigned

RewHonorMultiplier float

RewOrReqMoney int(11)

This field can be used to either require money for starting the quest, or award money for completing the quest.

If set to a value > 0, the quest will reward money upon completion
If set to a value < 0, the quest will require money to accept it.

RewMoneyMaxLevel int(10) unsigned

The value of this field decides how much experience or money (at level 60) a quest will reward.

Experience is calculated as follows: RewMoneyMaxLevel / 0.6

RewSpell mediumint(8) unsigned

If a spell should be shown as being casted as quest reward, set this to a spell identifier referencing the Spell.dbc table.

Note
If RewSpellCast is set, this spell will only be shown, but not cast.

RewSpellCast mediumint(8) unsigned

If a spell should be cast as a quest reward different from the spell shown as quest reward, set this to a spell identifier referencing the Spell.dbc table.

RewMailTemplateId mediumint(8) unsigned

If upon completion a quest should send out mail, this can be set to reference a mail template identifier in the MailTemplate.dbc table.

RewMailDelaySecs int(11) unsigned

The number of seconds to wait before sending the reward mail.

PointMapId smallint(5) unsigned

References an entry in the points_of_interest (POI) table, if it should be shown while the quest is active.

PointX float

If a point of interest should be shown while the quest is active, this will contain the X coordinate.

PointY float

If a point of interest should be shown while the quest is active, this will contain the Y coordinate.

PointOpt mediumint(8) unsigned

DetailsEmote1 smallint(5) unsigned

If an emote should be shown upon displaying quest details, this references the emotes identifier in the Emotes.dbc table.

DetailsEmote2 smallint(5) unsigned

If an emote should be shown upon displaying quest details, this references the emotes identifier in the Emotes.dbc table.

DetailsEmote3 smallint(5) unsigned

If an emote should be shown upon displaying quest details, this references the emotes identifier in the Emotes.dbc table.

DetailsEmote4 smallint(5) unsigned

If an emote should be shown upon displaying quest details, this references the emotes identifier in the Emotes.dbc table.

DetailsEmoteDelay1 int(11) unsigned

The number of seconds to delay the emote, if one is referenced in the DetailsEmote1 column.

DetailsEmoteDelay2 int(11) unsigned

The number of seconds to delay the emote, if one is referenced in the DetailsEmote2 column.

DetailsEmoteDelay3 int(11) unsigned

The number of seconds to delay the emote, if one is referenced in the DetailsEmote3 column.

DetailsEmoteDelay4 int(11) unsigned

The number of seconds to delay the emote, if one is referenced in the DetailsEmote4 column.

IncompleteEmote smallint(5) unsigned

If an emote should be shown upon displaying the incomplete quest text, this references the emotes identifier in the Emotes.dbc table.

CompleteEmote smallint(5) unsigned

If an emote should be shown upon displaying the quest completion text, this references the emotes identifier in the Emotes.dbc table.

OfferRewardEmote1 smallint(5) unsigned

If an emote should be shown upon displaying rewarding the quest, this references the emotes identifier in the Emotes.dbc table.

OfferRewardEmote2 smallint(5) unsigned

If an emote should be shown upon displaying rewarding the quest, this references the emotes identifier in the Emotes.dbc table.

OfferRewardEmote3 smallint(5) unsigned

If an emote should be shown upon displaying rewarding the quest, this references the emotes identifier in the Emotes.dbc table.

OfferRewardEmote4 smallint(5) unsigned

If an emote should be shown upon displaying rewarding the quest, this references the emotes identifier in the Emotes.dbc table.

OfferRewardEmoteDelay1 int(11) unsigned

The number of seconds to delay before the emote is actioned, if one is referenced in the OfferRewardEmote1 column.

OfferRewardEmoteDelay2 int(11) unsigned

The number of seconds to delay before the emote is actioned, if one is referenced in the OfferRewardEmote2 column.

OfferRewardEmoteDelay3 int(11) unsigned

The number of seconds to delay before the emote is actioned, if one is referenced in the OfferRewardEmote3 column.

OfferRewardEmoteDelay4 int(11) unsigned

The number of seconds to delay before the emote is actioned, if one is referenced in the OfferRewardEmote4 column.

StartScript mediumint(8) unsigned

If a script should be executed on quest start, this references an entry in the "db_scripts" table with a type of 0 to form a unique key.

CompleteScript mediumint(8) unsigned

If a script should be executed on quest end, this references an entry in the "db_scripts" table with a type of 1 to form a unique key.

Table Contents