quest_template

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
QuestType	tinyint	unsigned		NO	2
QuestPackageID	int	unsigned		NO	0
ContentTuningID	int	unsigned		NO	0
QuestSortID	smallint	signed		NO	0
QuestInfoID	smallint	unsigned		NO	0
SuggestedGroupNum	tinyint	unsigned		NO	0
RewardNextQuest	int	unsigned		NO	0
RewardXPDifficulty	int	unsigned		NO	0
RewardXPMultiplier	float			NO	1
RewardMoneyDifficulty	int	unsigned		NO	0
RewardMoneyMultiplier	float			NO	1
RewardBonusMoney	int	unsigned		NO	0
RewardDisplaySpell1	int	unsigned		NO	0
RewardDisplaySpell2	int	unsigned		NO	0
RewardDisplaySpell3	int	unsigned		NO	0
RewardSpell	int	unsigned		NO	0
RewardHonor	int	unsigned		NO	0
RewardKillHonor	int	unsigned		NO	0
StartItem	int	unsigned		NO	0
RewardArtifactXPDifficulty	int	unsigned		NO	0
RewardArtifactXPMultiplier	float			NO	1
RewardArtifactCategoryID	int	unsigned		NO	0
Flags	int	unsigned		NO	0
FlagsEx	int	unsigned		NO	0
FlagsEx2	int	unsigned		NO	0
RewardItem1	int	unsigned		NO	0
RewardAmount1	int	unsigned		NO	0
RewardItem2	int	unsigned		NO	0
RewardAmount2	int	unsigned		NO	0
RewardItem3	int	unsigned		NO	0
RewardAmount3	int	unsigned		NO	0
RewardItem4	int	unsigned		NO	0
RewardAmount4	int	unsigned		NO	0
ItemDrop1	int	unsigned		NO	0
ItemDropQuantity1	int	unsigned		NO	0
ItemDrop2	int	unsigned		NO	0
ItemDropQuantity2	int	unsigned		NO	0
ItemDrop3	int	unsigned		NO	0
ItemDropQuantity3	int	unsigned		NO	0
ItemDrop4	int	unsigned		NO	0
ItemDropQuantity4	int	unsigned		NO	0
RewardChoiceItemID1	int	unsigned		NO	0
RewardChoiceItemQuantity1	int	unsigned		NO	0
RewardChoiceItemDisplayID1	int	unsigned		NO	0
RewardChoiceItemID2	int	unsigned		NO	0
RewardChoiceItemQuantity2	int	unsigned		NO	0
RewardChoiceItemDisplayID2	int	unsigned		NO	0
RewardChoiceItemID3	int	unsigned		NO	0
RewardChoiceItemQuantity3	int	unsigned		NO	0
RewardChoiceItemDisplayID3	int	unsigned		NO	0
RewardChoiceItemID4	int	unsigned		NO	0
RewardChoiceItemQuantity4	int	unsigned		NO	0
RewardChoiceItemDisplayID4	int	unsigned		NO	0
RewardChoiceItemID5	int	unsigned		NO	0
RewardChoiceItemQuantity5	int	unsigned		NO	0
RewardChoiceItemDisplayID5	int	unsigned		NO	0
RewardChoiceItemID6	int	unsigned		NO	0
RewardChoiceItemQuantity6	int	unsigned		NO	0
RewardChoiceItemDisplayID6	int	unsigned		NO	0
POIContinent	int	unsigned		NO	0
POIx	float			NO	0
POIy	float			NO	0
POIPriority	int	signed		NO	0
RewardTitle	int	unsigned		NO	0
RewardArenaPoints	int	unsigned		NO	0
RewardSkillLineID	int	unsigned		NO	0
RewardNumSkillUps	int	unsigned		NO	0
PortraitGiver	int	unsigned		NO	0
PortraitGiverMount	int	signed		NO	0
PortraitGiverModelSceneID	int	signed		NO	0
PortraitTurnIn	int	unsigned		NO	0
RewardFactionID1	int	unsigned		NO	0
RewardFactionValue1	int	signed		NO	0
RewardFactionOverride1	int	signed		NO	0
RewardFactionCapIn1	int	signed		NO	0
RewardFactionID2	int	unsigned		NO	0
RewardFactionValue2	int	signed		NO	0
RewardFactionOverride2	int	signed		NO	0
RewardFactionCapIn2	int	signed		NO	0
RewardFactionID3	int	unsigned		NO	0
RewardFactionValue3	int	signed		NO	0
RewardFactionOverride3	int	signed		NO	0
RewardFactionCapIn3	int	signed		NO	0
RewardFactionID4	int	unsigned		NO	0
RewardFactionValue4	int	signed		NO	0
RewardFactionOverride4	int	signed		NO	0
RewardFactionCapIn4	int	signed		NO	0
RewardFactionID5	int	unsigned		NO	0
RewardFactionValue5	int	signed		NO	0
RewardFactionOverride5	int	signed		NO	0
RewardFactionCapIn5	int	signed		NO	0
RewardFactionFlags	int	unsigned		NO	0
RewardCurrencyID1	int	unsigned		NO	0
RewardCurrencyQty1	int	unsigned		NO	0
RewardCurrencyID2	int	unsigned		NO	0
RewardCurrencyQty2	int	unsigned		NO	0
RewardCurrencyID3	int	unsigned		NO	0
RewardCurrencyQty3	int	unsigned		NO	0
RewardCurrencyID4	int	unsigned		NO	0
RewardCurrencyQty4	int	unsigned		NO	0
AcceptedSoundKitID	int	unsigned		NO	0
CompleteSoundKitID	int	unsigned		NO	0
AreaGroupID	int	unsigned		NO	0
TimeAllowed	bigint	signed		NO	0
AllowableRaces	bigint	unsigned		YES	0
Expansion	int	signed		NO	0
ManagedWorldStateID	int	signed		NO	0
QuestSessionBonus	int	signed		NO	0
LogTitle	mediumtext			YES	NULL
LogDescription	mediumtext			YES	NULL
QuestDescription	mediumtext			YES	NULL
AreaDescription	mediumtext			YES	NULL
PortraitGiverText	mediumtext			YES	NULL
PortraitGiverName	mediumtext			YES	NULL
PortraitTurnInText	mediumtext			YES	NULL
PortraitTurnInName	mediumtext			YES	NULL
QuestCompletionLog	mediumtext			YES	NULL
ResetByScheduler	tinyint	signed		NO	0
VerifiedBuild	int	signed		NO	0

Description of fields

ID

The quest ID. This column is the Primary Key for the Table. Each quest ID must be unique!  

QuestType

• 0: Quest is enabled, but it is auto-completed when accepted; this skips quest objectives and quest details.
• 1: Quest is disabled (not yet implemented in the core).
• 2: Quest is enabled (does not auto-complete).
• 3: Quest is a World Quest.  

QuestPackageID

- no description -  

ContentTuningID

- no description -  

QuestSortID

This field defines under what category the quest falls in the quest log.

• QuestSortID > 0: positive AreaTable ID
• QuestSortID < 0: negative QuestSort ID (in general profession, class or holiday quests)

QuestSort excerpt:

ID	Name		ID	Name
22	Seasonal		261	Hunter
24	Herbalism		262	Priest
25	Battlegrounds		263	Druid
41	Day of the Dead		264	Tailoring
61	Warlock		304	Cooking
81	Warrior		324	First Aid
82	Shaman		364	Darkmoon Faire
101	Fishing		366	Lunar Festival
121	Blacksmithing		369	Midsummer
141	Paladin		370	Brewfest
161	Mage		371	Inscription
162	Rogue		372	Death Knight
181	Alchemy		373	Jewelcrafting
182	Leatherworking		374	Noblegarden
201	Engineering		375	Pilgrim's Bounty
241	Tournament		376	Love is in the Air

 

QuestInfoID

QuestInfo ID

ID	Name
1	Group
21	Life
41	PvP
62	Raid
81	Dungeon
82	World Event
83	Legendary
84	Escort
85	Heroic
88	Raid (10)
89	Raid (25)

 

SuggestedGroupNum

Recommended number of players to do the quest together.  

RewardNextQuest

ID of the next quest in a chain. The result is, that if you end the quest, the new quest instantly appears from the quest giver.  

RewardXPDifficulty

references QuestXP Difficulty The amount of XP is determined by the QuestLevel (row) and RewardXPDifficulty (column) when reading from QuestXP table.

If the quest is repeatable, XP will be given only once. The total XP that a character will receive is also affected by the level difference between the character's level and the quest's level.  

RewardXPMultiplier

- no description -  

RewardMoneyDifficulty

- no description -  

RewardMoneyMultiplier

- no description -  

RewardBonusMoney

The money a character at level 80 would get when they complete this quest.  

RewardDisplaySpell[1-3]

Spell that is shown to be casted on quest completion in the quest log. Note that this spell will NOT be casted if RewardSpell is non-zero. The spell in the other field will be casted instead, in which case the spell here only serves as the visual in the quest log.

Note: This field comes straight from the WDB and should not be changed.

 

RewardSpell

Spell that will always be casted at player when completing the quest. This can be a learn spell and player the learned some spell in result, or a buff spell for example. If this field is non-zero then this spell will ALWAYS be casted and the spell in RewardDisplaySpell will not.

Note: This field comes straight from the WDB and should not be changed.

 

RewardHonor

Number of honor points rewarded for completing this quest.  

RewardKillHonor

Number of honorable kill honor rewarded for completing this quest.

Example: An example value is 8 for For Great Honor. At level 80 an honorable kill is worth 124 honor. Multiply this with 8 and you receive 992 honor as reward.  

StartItem

Item entry given when accepting the quest. Item will be deleted when the quest is abandoned.  

RewardArtifactXPDifficulty

- no description -  

RewardArtifactXPMultiplier

- no description -  

RewardArtifactCategoryID

- no description -  

Flags

enum QuestFlags

Value	Flag	Name	Description
1	0x000001	QUEST_FLAGS_STAY_ALIVE	Not used currently; If the player dies, the quest is failed.
2	0x000002	QUEST_FLAGS_PARTY_ACCEPT	Not used currently. If player in party, all players that can accept this quest will receive confirmation box to accept quest CMSG_QUEST_CONFIRM_ACCEPT/SMSG_QUEST_CONFIRM_ACCEPT
4	0x000004	QUEST_FLAGS_EXPLORATION	Not used currently; Involves the activation of an areatrigger.
8	0x000008	QUEST_FLAGS_SHARABLE	Can be shared: Player::CanShareQuest()
16	0x000010	QUEST_FLAGS_HAS_CONDITION	Not used currently
32	0x000020	QUEST_FLAGS_HIDE_REWARD_POI	Not used currently: Unsure of content
64	0x000040	QUEST_FLAGS_RAID	Can be completed while in raid
128	0x000080	QUEST_FLAGS_TBC	Not used currently: Available if TBC expansion enabled only
256	0x000100	QUEST_FLAGS_NO_MONEY_FROM_XP	Not used currently: Experience is not converted to gold at max level
512	0x000200	QUEST_FLAGS_HIDDEN_REWARDS	Item and monetary rewards are hidden in the initial quest details page and in the quest log but will appear once ready to be rewarded.
1024	0x000400	QUEST_FLAGS_TRACKING	These quests are automatically rewarded on quest complete and they will never appear in quest log client side.
2048	0x000800	QUEST_FLAGS_DEPRECATE_REPUTATION	Not used currently
4096	0x001000	QUEST_FLAGS_DAILY	Daily repeatable quests
8192	0x002000	QUEST_FLAGS_FLAGS_PVP	Having this quest in log forces PvP flag
16384	0x004000	QUEST_FLAGS_UNAVAILABLE	Used on quests that are not generically available
32768	0x008000	QUEST_FLAGS_WEEKLY	Weekly repeatable quests
65536	0x010000	QUEST_FLAGS_AUTOCOMPLETE	auto complete
131072	0x020000	QUEST_FLAGS_DISPLAY_ITEM_IN_TRACKER	Displays usable item in quest tracker
262144	0x040000	QUEST_FLAGS_OBJ_TEXT	use Objective text as Complete text
524288	0x080000	QUEST_FLAGS_AUTO_ACCEPT	The client recognizes this flag as auto-accept. However, NONE of the current quests (3.3.5a) have this flag. Maybe blizz used to use it, or will use it in the future.

FlagsEx

- no description -  

FlagsEx2

- no description -  

RewardItem[1-4]

Item entry given as reward (no choice).  

RewardAmount[1-4]

The amount of items forced onto the player.  

ItemDrop[1-4]

Item entry that is needed indirectly by the quest. For example, the quests asks for item X but the only way to get item X is by activating item Y; however, item Y is also a quest item. Therefore you set item Y's entry in this field. This requirement will not appear in the quest text, it is just for the core to know when to drop a quest item that isn't in the RequiredItemId* field but is still needed by the quest.  

ItemDropQuantity[1-4]

The maximum number of copies of the item in RequiredSourceItemId* that can be picked up (and dropped by the core).  

RewardChoiceItemID[1-6]

The player has to pick one of RewardChoiceItemID* as a reward.  

RewardChoiceItemQuantity[1-6]

The amount of items to reward if if the correspondig RewardChoiceItemID* is selected.  

POIContinent

Map ID of a quest point of interest (POI - Point Of Interest). POI will be shown on the map when quest is active.  

POIx

X coordinate of quest POI.  

POIy

Y coordinate of quest POI.  

POIPriority

unknown / just sent to client  

RewardTitle

CharTitle ID to reward on completion.  

RewardArenaPoints

An amount of arena points to reward on completion.  

RewardSkillLineID

- no description -  

RewardNumSkillUps

- no description -  

PortraitGiver

- no description -  

PortraitGiverMount

- no description -  

PortraitGiverModelSceneID

- no description -  

PortraitTurnIn

- no description -  

RewardFactionID[1-5]

Faction ID for which the quest rewards reputation points.  

RewardFactionValue[1-5]

This field is used for reputation lookup in QuestFactionReward. The value X in this field indicates index of QuestFactionReward Difficulty.

• RewardFactionValue* > 0: Reputation from the first row of QuestFactionReward is used.
• RewardFactionValue* < 0: Reputation from the second row of QuestFactionReward is used.

ID	Rep0	Rep1	Rep2	Rep3	Rep4	Rep5	Rep6	Rep7	Rep8	Rep9
1	0	10	25	75	150	250	350	500	1000	5
2	0	-10	-25	-75	-150	-250	-350	-500	-1000	-5

 

RewardFactionOverride[1-5]

This field is used to give reputation values not present in QuestFactionReward or to override them if RewardFactionValue* is wrong for some reason. The value in this field is 100� the intended reputation reward (if you want to give 400 rep, put 40000 in RewardFactionOverride*).  

RewardFactionCapIn[1-5]

- no description -  

RewardFactionFlags

- no description -  

RewardCurrencyID1

- no description -  

RewardCurrencyQty1

- no description -  

RewardCurrencyID2

- no description -  

RewardCurrencyQty2

- no description -  

RewardCurrencyID3

- no description -  

RewardCurrencyQty3

- no description -  

RewardCurrencyID4

- no description -  

RewardCurrencyQty4

- no description -  

AcceptedSoundKitID

- no description -  

CompleteSoundKitID

- no description -  

AreaGroupID

- no description -  

TimeAllowed

Time in seconds that the player has to complete this quest.  

AllowableRaces

Race mask of ChrRace IDs allowed to get the quest. 0 means the quest is accessible for all races.

Value	Flag	Name		Value	Flag	Name
1	0x0001	Human		2	0x0002	Orc
4	0x0004	Dwarf		16	0x0010	Undead
8	0x0008	Night Elf		32	0x0020	Tauren
64	0x0040	Gnome		128	0x0080	Troll
1024	0x0400	Draenei		512	0x0200	Blood Elf
1101	0x044D	Alliance		690	0x02B2	Horde
UPDATE ME

Expansion

- no description -  

ManagedWorldStateID

- no description -  

QuestSessionBonus

- no description -  

LogTitle

- no description -  

LogDescription

- no description -  

QuestDescription

- no description -  

AreaDescription

- no description -  

PortraitGiverText

- no description -  

PortraitGiverName

- no description -  

PortraitTurnInText

- no description -  

PortraitTurnInName

- no description -  

QuestCompletionLog

Objective text displayed after all other objectives are completed. Example: Return to <NPC> at <Location> in <Zone>.  

ResetByScheduler

- no description -  

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.