AzerothCore
quest_request_items
The `quest_request_items` table
This table basically handles 3 quest details:
- NPC Emote when quest is completed
- NPC Emote when quest is incomplete
- Completion text for quests requiring quest items
Table Structure
| Field | Type | Attributes | Key | NULL | Default | Comment |
|---|---|---|---|---|---|---|
| ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | |
| EmoteOnComplete | SMALLINT | UNSIGNED | NO | 0 | ||
| EmoteOnIncomplete | SMALLINT | UNSIGNED | NO | 0 | ||
| CompletionText | text | YES | NULL | |||
| VerifiedBuild | SMALLINT | NO | 0 |
Description of the fields
ID
Quest ID for quests showing a completion text upon turning in an item delivery quest. Primary Key for this table. Each quest ID must be unique.
EmoteOnComplete
Emote (from Emotes.dbc played by the quest ender NPC when all quest objectives are completed.
EmoteOnIncomplete
Emote (from聽Emotes.dbc)聽played by the quest ender NPC if any of the quest objectives are incomplete.
CompletionText
Quest gossip text shown in the final gossip dialogue window when聽turning in an item delivery quest. The quest item(s) involved in the quest can either聽be provided by the quest giver or collected by the player.
VerifiedBuild
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.
聽