quest_template

Field	Type	Attributes	Key	Null	Default
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	int	unsigned		NO	0
AllowableRaces	bigint	unsigned		YES	0
TreasurePickerID	int	signed		NO	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
VerifiedBuild	int	signed		NO	0

¶ Structure

¶ Description of fields

¶ ID

¶ QuestType

¶ QuestPackageID

¶ ContentTuningID

¶ QuestSortID

¶ QuestInfoID

¶ SuggestedGroupNum

¶ RewardNextQuest

¶ RewardXPDifficulty

¶ RewardXPMultiplier

¶ RewardMoneyDifficulty

¶ RewardMoneyMultiplier

¶ RewardBonusMoney

¶ RewardDisplaySpell1

¶ RewardDisplaySpell2

¶ RewardDisplaySpell3

¶ RewardSpell

¶ RewardHonor

¶ RewardKillHonor

¶ StartItem

¶ RewardArtifactXPDifficulty

¶ RewardArtifactXPMultiplier

¶ RewardArtifactCategoryID

¶ Flags

¶ FlagsEx

¶ FlagsEx2

¶ RewardItem1

¶ RewardAmount1

¶ RewardItem2

¶ RewardAmount2

¶ RewardItem3

¶ RewardAmount3

¶ RewardItem4

¶ RewardAmount4

¶ ItemDrop1

¶ ItemDropQuantity1

¶ ItemDrop2

¶ ItemDropQuantity2

¶ ItemDrop3

¶ ItemDropQuantity3

¶ ItemDrop4

¶ ItemDropQuantity4

¶ RewardChoiceItemID1

¶ RewardChoiceItemQuantity1

¶ RewardChoiceItemDisplayID1

¶ RewardChoiceItemID2

¶ RewardChoiceItemQuantity2

¶ RewardChoiceItemDisplayID2

¶ RewardChoiceItemID3

¶ RewardChoiceItemQuantity3

¶ RewardChoiceItemDisplayID3

¶ RewardChoiceItemID4

¶ RewardChoiceItemQuantity4

¶ RewardChoiceItemDisplayID4

¶ RewardChoiceItemID5

¶ RewardChoiceItemQuantity5

¶ RewardChoiceItemDisplayID5

¶ RewardChoiceItemID6

¶ RewardChoiceItemQuantity6

¶ RewardChoiceItemDisplayID6

¶ POIContinent

¶ POIx

¶ POIy

¶ POIPriority

¶ RewardTitle

¶ RewardArenaPoints

¶ RewardSkillLineID

¶ RewardNumSkillUps

¶ PortraitGiver

¶ PortraitGiverMount

¶ PortraitGiverModelSceneID

¶ PortraitTurnIn

¶ RewardFactionID1

¶ RewardFactionValue1

¶ RewardFactionOverride1

¶ RewardFactionCapIn1

¶ RewardFactionID2

¶ RewardFactionValue2