quest_template

Field	Type	Attributes	Key	Null	Default	Comment
ID	mediumint	unsigned	PRI	NO	0
QuestType	tinyint	unsigned		NO	2
QuestLevel	smallint	signed		NO	1
MinLevel	tinyint	unsigned		NO	0
QuestSortID	smallint	signed		NO	0
QuestInfoID	smallint	unsigned		NO	0
SuggestedGroupNum	tinyint	unsigned		NO	0
RequiredFactionId1	smallint	unsigned		NO	0
RequiredFactionId2	smallint	unsigned		NO	0
RequiredFactionValue1	mediumint	signed		NO	0
RequiredFactionValue2	mediumint	signed		NO	0
RewardNextQuest	mediumint	unsigned		NO	0
RewardXPDifficulty	tinyint	unsigned		NO	0
RewardMoney	int	signed		NO	0
RewardBonusMoney	int	unsigned		NO	0
RewardDisplaySpell	mediumint	unsigned		NO	0
RewardSpell	int	signed		NO	0
RewardHonor	int	signed		NO	0
RewardKillHonor	float			NO	0
StartItem	mediumint	unsigned		NO	0
Flags	int	unsigned		NO	0
RequiredPlayerKills	tinyint	unsigned		NO	0
RewardItem1	mediumint	unsigned		NO	0
RewardAmount1	smallint	unsigned		NO	0
RewardItem2	mediumint	unsigned		NO	0
RewardAmount2	smallint	unsigned		NO	0
RewardItem3	mediumint	unsigned		NO	0
RewardAmount3	smallint	unsigned		NO	0
RewardItem4	mediumint	unsigned		NO	0
RewardAmount4	smallint	unsigned		NO	0
ItemDrop1	mediumint	unsigned		NO	0
ItemDropQuantity1	smallint	unsigned		NO	0
ItemDrop2	mediumint	unsigned		NO	0
ItemDropQuantity2	smallint	unsigned		NO	0
ItemDrop3	mediumint	unsigned		NO	0
ItemDropQuantity3	smallint	unsigned		NO	0
ItemDrop4	mediumint	unsigned		NO	0
ItemDropQuantity4	smallint	unsigned		NO	0
RewardChoiceItemID1	mediumint	unsigned		NO	0
RewardChoiceItemQuantity1	smallint	unsigned		NO	0
RewardChoiceItemID2	mediumint	unsigned		NO	0
RewardChoiceItemQuantity2	smallint	unsigned		NO	0
RewardChoiceItemID3	mediumint	unsigned		NO	0
RewardChoiceItemQuantity3	smallint	unsigned		NO	0
RewardChoiceItemID4	mediumint	unsigned		NO	0
RewardChoiceItemQuantity4	smallint	unsigned		NO	0
RewardChoiceItemID5	mediumint	unsigned		NO	0
RewardChoiceItemQuantity5	smallint	unsigned		NO	0
RewardChoiceItemID6	mediumint	unsigned		NO	0
RewardChoiceItemQuantity6	smallint	unsigned		NO	0
POIContinent	smallint	unsigned		NO	0
POIx	float			NO	0
POIy	float			NO	0
POIPriority	mediumint	unsigned		NO	0
RewardTitle	tinyint	unsigned		NO	0
RewardTalents	tinyint	unsigned		NO	0
RewardArenaPoints	smallint	unsigned		NO	0
RewardFactionID1	smallint	unsigned		NO	0	faction id from Faction.dbc in this case
RewardFactionValue1	mediumint	signed		NO	0
RewardFactionOverride1	mediumint	signed		NO	0
RewardFactionID2	smallint	unsigned		NO	0	faction id from Faction.dbc in this case
RewardFactionValue2	mediumint	signed		NO	0
RewardFactionOverride2	mediumint	signed		NO	0
RewardFactionID3	smallint	unsigned		NO	0	faction id from Faction.dbc in this case
RewardFactionValue3	mediumint	signed		NO	0
RewardFactionOverride3	mediumint	signed		NO	0
RewardFactionID4	smallint	unsigned		NO	0	faction id from Faction.dbc in this case
RewardFactionValue4	mediumint	signed		NO	0
RewardFactionOverride4	mediumint	signed		NO	0
RewardFactionID5	smallint	unsigned		NO	0	faction id from Faction.dbc in this case
RewardFactionValue5	mediumint	signed		NO	0
RewardFactionOverride5	mediumint	signed		NO	0
TimeAllowed	int	unsigned		NO	0
AllowableRaces	smallint	unsigned		NO	0
LogTitle	text			YES	NULL
LogDescription	text			YES	NULL
QuestDescription	text			YES	NULL
AreaDescription	text			YES	NULL
QuestCompletionLog	text			YES	NULL
RequiredNpcOrGo1	mediumint	signed		NO	0
RequiredNpcOrGo2	mediumint	signed		NO	0
RequiredNpcOrGo3	mediumint	signed		NO	0
RequiredNpcOrGo4	mediumint	signed		NO	0
RequiredNpcOrGoCount1	smallint	unsigned		NO	0
RequiredNpcOrGoCount2	smallint	unsigned		NO	0
RequiredNpcOrGoCount3	smallint	unsigned		NO	0
RequiredNpcOrGoCount4	smallint	unsigned		NO	0
RequiredItemId1	mediumint	unsigned		NO	0
RequiredItemId2	mediumint	unsigned		NO	0
RequiredItemId3	mediumint	unsigned		NO	0
RequiredItemId4	mediumint	unsigned		NO	0
RequiredItemId5	mediumint	unsigned		NO	0
RequiredItemId6	mediumint	unsigned		NO	0
RequiredItemCount1	smallint	unsigned		NO	0
RequiredItemCount2	smallint	unsigned		NO	0
RequiredItemCount3	smallint	unsigned		NO	0
RequiredItemCount4	smallint	unsigned		NO	0
RequiredItemCount5	smallint	unsigned		NO	0
RequiredItemCount6	smallint	unsigned		NO	0
Unknown0	tinyint	unsigned		NO	0
ObjectiveText1	text			YES	NULL
ObjectiveText2	text			YES	NULL
ObjectiveText3	text			YES	NULL
ObjectiveText4	text			YES	NULL
VerifiedBuild	smallint	signed		YES	0

¶ Structure

¶ Description of fields

¶ ID

¶ QuestType

¶ QuestLevel

¶ MinLevel

¶ QuestSortID

¶ QuestInfoID

¶ SuggestedGroupNum

¶ RequiredFactionId1

¶ RequiredFactionId2

¶ RequiredFactionValue1

¶ RequiredFactionValue2

¶ RewardNextQuest

¶ RewardXPDifficulty

¶ RewardMoney

¶ RewardBonusMoney

¶ RewardDisplaySpell

¶ RewardSpell

¶ RewardHonor

¶ RewardKillHonor

¶ StartItem

¶ Flags

¶ RequiredPlayerKills

¶ RewardItem1

¶ RewardAmount1

¶ RewardItem2

¶ RewardAmount2

¶ RewardItem3

¶ RewardAmount3

¶ RewardItem4

¶ RewardAmount4

¶ ItemDrop1

¶ ItemDropQuantity1

¶ ItemDrop2

¶ ItemDropQuantity2

¶ ItemDrop3

¶ ItemDropQuantity3

¶ ItemDrop4

¶ ItemDropQuantity4

¶ RewardChoiceItemID1

¶ RewardChoiceItemQuantity1

¶ RewardChoiceItemID2

¶ RewardChoiceItemQuantity2

¶ RewardChoiceItemID3

¶ RewardChoiceItemQuantity3

¶ RewardChoiceItemID4

¶ RewardChoiceItemQuantity4

¶ RewardChoiceItemID5

¶ RewardChoiceItemQuantity5

¶ RewardChoiceItemID6

¶ RewardChoiceItemQuantity6

¶ POIContinent

¶ POIx

¶ POIy

¶ POIPriority

¶ RewardTitle

¶ RewardTalents

¶ RewardArenaPoints

¶ RewardFactionID1

¶ RewardFactionValue1

¶ RewardFactionOverride1

¶ RewardFactionID2

¶ RewardFactionValue2

¶ RewardFactionOverride2

¶ RewardFactionID3

¶ RewardFactionValue3

¶ RewardFactionOverride3

¶ RewardFactionID4

¶ RewardFactionValue4

¶ RewardFactionOverride4

¶ RewardFactionID5

¶ RewardFactionValue5

¶ RewardFactionOverride5

¶ TimeAllowed

¶ AllowableRaces

¶ LogTitle

¶ LogDescription

¶ QuestDescription

¶ AreaDescription