# quest\_template **Table: quest\_template** Contains all basic definitions of available quests. ## **Structure**
| Field | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|
int(10) unsigned |
NO |
PRI |
0 |
|
|
|
tinyint(3) unsigned |
NO |
|
2 |
|
|
|
int(11) |
NO |
|
-1 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(11) |
NO |
|
0 |
|
|
|
smallint(6) |
NO |
|
0 |
|
|
|
smallint(5) unsigned |
NO |
|
0 |
|
|
|
tinyint(3) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
float |
NO |
|
1 |
|
|
|
int(11) |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
float |
NO |
|
1 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
float |
NO |
|
1 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
float |
NO |
|
0 |
|
|
|
float |
NO |
|
0 |
|
|
|
int(11) |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(11) |
NO |
|
0 |
|
|
|
int(11) |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
int(11) |
NO |
|
-1 |
|
|
|
int(10) unsigned |
NO |
|
0 |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
text |
YES |
|
(NULL) |
|
|
|
smallint(5) |
YES |
|
0 |
|
|
Flag |
Name |
Comments |
|---|---|---|
0 |
QUEST_FLAGS_NONE |
No flags, so no groups assigned to this quest. |
1 |
QUEST_FLAGS_STAY_ALIVE |
If the player dies, the quest is failed. |
2 |
QUEST_FLAGS_PARTY_ACCEPT |
Escort quests or any other event-driven quests. If player in party, all players that can accept this quest will receive confirmation box to accept quest. |
4 |
QUEST_FLAGS_EXPLORATION |
Involves the activation of an areatrigger. |
8 |
QUEST_FLAGS_SHARABLE |
Allows the quest to be shared with other players. |
16 |
QUEST_FLAGS_HAS_CONDITION |
Not used currently |
32 |
QUEST_FLAGS_HIDE_REWARD_POI |
Not used currently: Unsure of content |
64 |
QUEST_FLAGS_RAID |
Can be completed while in raid |
128 |
QUEST_FLAGS_TBC |
Not used currently: Available if TBC expansion enabled only |
256 |
QUEST_FLAGS_NO_MONEY_FROM_XP |
Not used currently: Experience is not converted to gold at max level |
512 |
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 |
QUEST_FLAGS_TRACKING |
These quests are automatically rewarded on quest complete and they will never appear in quest log client side. |
2048 |
QUEST_FLAGS_DEPRECATE_REPUTATION |
Not used currently |
4096 |
QUEST_FLAGS_DAILY |
Daily repeatable quests (only flag that the core applies specific behavior for) |
8192 |
QUEST_FLAGS_FLAGS_PVP |
Having this quest in log forces PvP flag |
16384 |
QUEST_FLAGS_UNAVAILABLE |
Used on quests that are not generically available |
32768 |
QUEST_FLAGS_WEEKLY |
Weekly repeatable quests (only flag that the core applies specific behavior for) |
65536 |
QUEST_FLAGS_AUTOCOMPLETE |
Auto complete |
131072 |
QUEST_FLAGS_DISPLAY_ITEM_IN_TRACKER |
Displays usable item in quest tracker |
262144 |
QUEST_FLAGS_OBJ_TEXT |
Use Objective text as Complete text |
524288 |
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. |
| 1048576 | QUEST_FLAGS_PLAYER_CAST_ON_ACCEPT | Quests with this flag player submit automatically by special button in player GUI |
| 2097152 | QUEST_FLAGS_PLAYER_CAST_ON_COMPLETE | Automatically suggestion of accepting quest. Not from npc. |
| 4194304 | QUEST_FLAGS_UPDATE_PHASE_SHIFT | |
| 8388608 | QUEST_FLAGS_SOR_WHITELIST | |
| 16777216 | QUEST_FLAGS_LAUNCH_GOSSIP_COMPLETE | |
| 54432 | QUEST_FLAGS_REMOVE_EXTRA_GET_ITEMS | |
| 67108864 | QUEST_FLAGS_HIDE_UNTIL_DISCOVERED | |
| 134217728 | QUEST_FLAGS_PORTRAIT_IN_QUEST_LOG | |
| 268435456 | QUEST_FLAGS_SHOW_ITEM_WHEN_COMPLETED | |
| 536870912 | QUEST_FLAGS_LAUNCH_GOSSIP_ACCEPT | |
| 1073741824 | QUEST_FLAGS_ITEMS_GLOW_WHEN_DONE | |
| 2147483648 | QUEST_FLAGS_FAIL_ON_LOGOUT |