quest_offer_reward

Table: quest_offer_reward

This table is used for quests offering rewards without any required quest items (no item delivery involved).

Field	Type	Attributes	Key	NULL	Default	Comment
ID	MEDIUMINT	UNSIGNED	PRI	NO	0	Unique ID (quest_template.ID)
Emote1	SMALLINT	UNSIGNED		NO	0	Quest NPC Emote
Emote2	SMALLINT	UNSIGNED		NO	0	Quest NPC Emote
Emote3	SMALLINT	UNSIGNED		NO	0	Quest NPC Emote
Emote4	SMALLINT	UNSIGNED		NO	0	Quest NPC Emote
EmoteDelay1	INT	UNSIGNED		NO	0	Emote delay in milliseconds
EmoteDelay2	INT	UNSIGNED		NO	0	Emote delay in milliseconds
EmoteDelay3	INT	UNSIGNED		NO	0	Emote delay in milliseconds
EmoteDelay4	INT	UNSIGNED		NO	0	Emote delay in milliseconds
RewardText	text	utf8_general_ci		YES	NULL	Quest gossip text, single quest dialogue
VerifiedBuild	SMALLINT			NO	0	Game client Build number or manually set value

Description of the fields:

Unique ID (quest_template.ID)

Emote (from Emotes.dbc) played by NPC

Emote delay in milliseconds

Quest gossip text shown when turning in a quest where no item delivery is involved.

Some of the quests are just a reward pick-up without the need to accept an initial new quest.

Such quests can be either class specific, repeatable or quest item retrieval in case of lost items.

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

If value is 0, it has not been parsed yet.
If value is > 0, it has been parsed with WDB files from that specific Client Build.
If value is -1, it is just a place holder until proper data are found on WDBs.
If value is -Client Build, it was parsed with WDB files from that specific client build and manually edited later for some specific necessity.