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	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

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

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)

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.

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

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

¶ Structure

¶ Description of fields

¶ ID

¶ QuestType

¶ QuestPackageID

¶ ContentTuningID

¶ QuestSortID

¶ QuestInfoID

¶ SuggestedGroupNum

¶ RewardNextQuest

¶ RewardXPDifficulty

¶ RewardXPMultiplier

¶ RewardMoneyDifficulty

¶ RewardMoneyMultiplier

¶ RewardBonusMoney

¶ RewardDisplaySpell[1-3]

¶ RewardSpell

¶ RewardHonor

¶ RewardKillHonor

¶ StartItem

¶ RewardArtifactXPDifficulty

¶ RewardArtifactXPMultiplier

¶ RewardArtifactCategoryID

¶ Flags

¶ FlagsEx

¶ FlagsEx2

¶ RewardItem[1-4]

¶ RewardAmount[1-4]

¶ ItemDrop[1-4]

¶ ItemDropQuantity[1-4]

¶ RewardChoiceItemID[1-6]

¶ RewardChoiceItemQuantity[1-6]

¶ POIContinent

¶ POIx

¶ POIy

¶ POIPriority

¶ RewardTitle

¶ RewardArenaPoints

¶ RewardSkillLineID

¶ RewardNumSkillUps

¶ PortraitGiver

¶ PortraitGiverMount

¶ PortraitGiverModelSceneID

¶ PortraitTurnIn

¶ RewardFactionID[1-5]

¶ RewardFactionValue[1-5]

¶ RewardFactionOverride[1-5]

¶ RewardFactionCapIn[1-5]

¶ RewardFactionFlags

¶ RewardCurrencyID1

¶ RewardCurrencyQty1

¶ RewardCurrencyID2

¶ RewardCurrencyQty2

¶ RewardCurrencyID3

¶ RewardCurrencyQty3

¶ RewardCurrencyID4

¶ RewardCurrencyQty4

¶ AcceptedSoundKitID

¶ CompleteSoundKitID

¶ AreaGroupID

¶ TimeAllowed

¶ AllowableRaces

¶ Expansion

¶ ManagedWorldStateID

¶ QuestSessionBonus

¶ LogTitle

¶ LogDescription

¶ QuestDescription

¶ AreaDescription

¶ PortraitGiverText

¶ PortraitGiverName

¶ PortraitTurnInText

¶ PortraitTurnInName

¶ QuestCompletionLog

¶ ResetByScheduler

¶ VerifiedBuild