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(8)	unsigned	PRI	NO	0	Unique ID (quest_template.ID)
Emote1	smallint(5)	unsigned		NO	0	Quest NPC Emote
Emote2	smallint(5)	unsigned		NO	0	Quest NPC Emote
Emote3	smallint(5)	unsigned		NO	0	Quest NPC Emote
Emote4	smallint(5)	unsigned		NO	0	Quest NPC Emote
EmoteDelay1	int(10)	unsigned		NO	0	Emote delay in milliseconds
EmoteDelay2	int(10)	unsigned		NO	0	Emote delay in milliseconds
EmoteDelay3	int(10)	unsigned		NO	0	Emote delay in milliseconds
EmoteDelay4	int(10)	unsigned		NO	0	Emote delay in milliseconds
RewardText	text	utf8_general_ci		YES	NULL	Quest gossip text, single quest dialogue
VerifiedBuild	smallint(5)			NO	0	Game client Build number or manually set value

Description of the fields:

Emote (from Emotes.dbc) played by NPC

Emote (from Emotes.dbc) played by NPC

Emote (from Emotes.dbc) played by NPC

Emote (from Emotes.dbc) played by NPC

Emote delay in milliseconds

Emote delay in milliseconds

Emote delay in milliseconds

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.