quest_properties

This table contains the information about the quests.

Structure

Field Type Default Comment
entry int(10) unsigned NOT NULL DEFAULT ‘0’ key
build smallint(6) 12340 key
ZoneId int(10) unsigned NOT NULL DEFAULT ‘0’  
sort int(10) unsigned NOT NULL DEFAULT ‘0’  
flags int(10) unsigned NOT NULL DEFAULT ‘0’  
MinLevel int(10) unsigned NOT NULL DEFAULT ‘0’  
questlevel int(10) unsigned NOT NULL DEFAULT ‘0’  
Type int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredRaces int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredClass int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredTradeskill int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredTradeskillValue int(5) unsigned NOT NULL DEFAULT ‘0’  
RequiredRepFaction int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredRepValue int(10) unsigned NOT NULL DEFAULT ‘0’  
LimitTime int(10) unsigned NOT NULL DEFAULT ‘0’ NOT IMPLEMENTED!
SpecialFlags int(10) unsigned NOT NULL DEFAULT ‘0’ NOT USED!
PrevQuestId int(10) unsigned NOT NULL DEFAULT ‘0’  
NextQuestId int(10) unsigned NOT NULL DEFAULT ‘0’  
srcItem int(10) unsigned NOT NULL DEFAULT ‘0’  
SrcItemCount int(10) unsigned NOT NULL DEFAULT ‘0’  
Title char(255) NOT NULL  
Details text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
Objectives text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
CompletionText text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
IncompleteText text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
EndText text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
ObjectiveText1 text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
ObjectiveText2 text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
ObjectiveText3 text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
ObjectiveText4 text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  
ReqItemId1 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemId2 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemId3 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemId4 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemId5 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemId6 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemCount1 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemCount2 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemCount3 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemCount4 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemCount5 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqItemCount6 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOId1 int(10) NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOId2 int(10) NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOId3 int(10) NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOId4 int(10) NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOCount1 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOCount2 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOCount3 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqKillMobOrGOCount4 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReqCastSpellId1 int(11) NOT NULL DEFAULT ‘0’  
ReqCastSpellId2 int(11) NOT NULL DEFAULT ‘0’  
ReqCastSpellId3 int(11) NOT NULL DEFAULT ‘0’  
ReqCastSpellId4 int(11) NOT NULL DEFAULT ‘0’  
ReqEmoteId1 int(10) unsigned DEFAULT ‘0’  
ReqEmoteId2 int(10) unsigned DEFAULT ‘0’  
ReqEmoteId3 int(10) unsigned DEFAULT ‘0’  
ReqEmoteId4 int(10) unsigned DEFAULT ‘0’  
RewChoiceItemId1 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemId2 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemId3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemId4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemId5 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemId6 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemCount1 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemCount2 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemCount3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemCount4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemCount5 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewChoiceItemCount6 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemId1 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemId2 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemId3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemId4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemCount1 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemCount2 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemCount3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewItemCount4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepFaction1 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepFaction2 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepFaction3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepFaction4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepFaction5 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepFaction6 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepValue1 int(10) NOT NULL DEFAULT ‘0’  
RewRepValue2 int(10) NOT NULL DEFAULT ‘0’  
RewRepValue3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepValue4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepValue5 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepValue6 int(10) unsigned NOT NULL DEFAULT ‘0’  
RewRepLimit int(10) unsigned NOT NULL DEFAULT ‘0’  
RewMoney int(10) NOT NULL DEFAULT ‘0’  
RewXP int(10) unsigned NOT NULL DEFAULT ‘0’  
RewSpell int(10) unsigned NOT NULL DEFAULT ‘0’  
CastSpell int(10) unsigned NOT NULL DEFAULT ‘0’  
MailTemplateId int(10) unsigned NOT NULL DEFAULT ‘0’  
MailDelaySecs int(10) unsigned NOT NULL DEFAULT ‘0’  
MailSendItem int(10) unsigned NOT NULL DEFAULT ‘0’  
PointMapId int(10) unsigned NOT NULL DEFAULT ‘0’  
PointX float NOT NULL DEFAULT ‘0’  
PointY float NOT NULL DEFAULT ‘0’  
PointOpt int(10) unsigned NOT NULL DEFAULT ‘0’  
RewardMoneyAtMaxLevel int(10) unsigned NOT NULL DEFAULT ‘0’  
ExploreTrigger1 int(10) unsigned NOT NULL DEFAULT ‘0’  
ExploreTrigger2 int(10) unsigned NOT NULL DEFAULT ‘0’  
ExploreTrigger3 int(10) unsigned NOT NULL DEFAULT ‘0’  
ExploreTrigger4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredOneOfQuest longtext NOT NULL  
RequiredQuest1 int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredQuest2 int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredQuest3 int(10) unsigned NOT NULL DEFAULT ‘0’  
RequiredQuest4 int(10) unsigned NOT NULL DEFAULT ‘0’  
RemoveQuests longtext NOT NULL  
ReceiveItemId1 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemId2 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemId3 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemId4 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemCount1 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemCount2 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemCount3 int(10) unsigned NOT NULL DEFAULT ‘0’  
ReceiveItemCount4 int(10) unsigned NOT NULL DEFAULT ‘0’  
IsRepeatable int(11) NOT NULL DEFAULT ‘0’  
bonushonor int(10) unsigned NOT NULL DEFAULT ‘0’  
bonusarenapoints int(10) unsigned NOT NULL DEFAULT ‘0’  
rewardtitleid int(10) unsigned NOT NULL DEFAULT ‘0’  
rewardtalents int(10) unsigned NOT NULL DEFAULT ‘0’  
suggestedplayers int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemotecount int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemote1 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemote2 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemote3 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemote4 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemotedelay1 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemotedelay2 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemotedelay3 int(10) unsigned NOT NULL DEFAULT ‘0’  
detailemotedelay4 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemotecnt int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemote1 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemote2 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemote3 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemote4 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemotedelay1 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemotedelay2 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemotedelay3 int(10) unsigned NOT NULL DEFAULT ‘0’  
completionemotedelay4 int(10) unsigned NOT NULL DEFAULT ‘0’  
completeemote int(10) unsigned NOT NULL DEFAULT ‘0’  
incompleteemote int(10) unsigned NOT NULL DEFAULT ‘0’  
iscompletedbyspelleffect int(10) unsigned NOT NULL DEFAULT ‘0’  
RewXPId int(10) unsigned NOT NULL DEFAULT ‘0’  

entry

The unique entry ID of the quest.

build

Build number to determine if the data is for our current compiled version.

ZoneId

The entry ID of the Zone

sort

  0 = -NOT SET-
  1 = Epic
 21 = REUSE - Old Wailing Caverns
 22 = Seasonal
 23 = REUSE - Old Undercity
 24 = Herbalism
 25 = Battlegrounds
 41 = REUSE - Old Uldaman
 61 = Warlock
 81 = Warrior
 82 = Shaman
101 = Fishing
121 = Blacksmithing
141 = Paladin
161 = Mage
162 = Rogue
181 = Alchemy
182 = Leatherworking
201 = Engineering
221 = Treasure Map
241 = REUSE - Old Sunken Temple
261 = Hunter
262 = Priest
263 = Druid
264 = Tailoring
284 = Special
304 = Cooking
324 = First Aid
344 = Legendary
364 = Darkmoon Faire
365 = Ahn'Qiraj War
366 = Lunar Festival
367 = Reputation
368 = Invasion
369 = Midsummer
370 = Brewfest
371 = Inscription
372 = Death Knight
373 = Jewelcrafting

flags

Value Name Hex Comment
0 QUEST_FLAG_NONE 0x00000000 No flag
1 QUEST_FLAG_DELIVER 0x00000001 ?
2 QUEST_FLAG_KILL 0x00000002 ?
4 QUEST_FLAG_SPEAKTO 0x00000004 ?
8 QUEST_FLAG_REPEATABLE 0x00000008 ?
16 QUEST_FLAG_EXPLORATION 0x00000010 ?
32 QUEST_FLAG_TIMED 0x00000020 ?
64 QUEST_FLAG_UNK1 0x00000040 ?
128 QUEST_FLAG_REPUTATION 0x00000080 Not used currently: DELIVER_MORE Quest needs more than normal _q-item drops from mobs
256 QUEST_FLAGS_UNK2 0x00000100 Not used currently: DELIVER_MORE Quest needs more than normal _q-item drops from mobs
512 QUEST_FLAGS_HIDDEN_REWARDS 0x00000200 Items and money rewarded only sent in SMSG_QUESTGIVER_OFFER_REWARD (not in SMSG_QUESTGIVER_QUEST_DETAILS or in client quest log(SMSG_QUEST_QUERY_RESPONSE))
1024 QUEST_FLAGS_AUTO_REWARDED 0x00000400 These quests are automatically rewarded on quest complete and they will never appear in quest log client side.
2048 QUEST_FLAGS_TBC_RACES 0x00000800 Not used currently: Blood elf/Draenei starting zone quests
4096 QUEST_FLAGS_DAILY 0x00001000 Daily quest. Can be done once a day. Quests reset at regular intervals for all players.
8192 QUEST_FLAGS_FLAGS_PVP 0x00002000 activates PvP on accept
16384 QUEST_FLAGS_UNK4 0x00004000 ? Membership Card Renewal
32768 QUEST_FLAGS_WEEKLY 0x00008000 Weekly quest. Can be done once a week. Quests reset at regular intervals for all players.
65536 QUEST_FLAGS_AUTOCOMPLETE 0x00010000 auto complete
131072 QUEST_FLAGS_UNK5 0x00020000 has something to do with ReqItemId and SrcItemId
262144 QUEST_FLAGS_UNK6 0x00040000 use Objective text as Complete text
524288 QUEST_FLAGS_AUTO_ACCEPT 0x00080000 quests in starting areas

MinLevel

The minimum level of the character to start the quest.

questlevel

Type

The type of the quest:

 0 = Normal
 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)

RequiredRaces

Races who can accept/view this quest:

   0 = All Races
   1 = Human
   2 = Orc
   4 = Dwarf
   8 = Night Elf
  16 = Undead
  32 = Tauren
  64 = Gnome
 128 = Troll
 512 = Blood Elf
1024 = Draenei
Special definitions:
 690 = All the Hordes Races
1101 = All the Alliance Races

RequiredClass

   0 = All Classes
   1 = Warrior
   2 = Paladin
   4 = Hunter
   8 = Rogue
  16 = Priest
  32 = Death Knight
  64 = Shaman
 128 = Mage
 256 = Warlock
1024 = Druid

RequiredTradeskill

129 = First Aid
164 = Blacksmith
165 = Leatherworking
171 = Alchemy
182 = Herbalism
185 = Cooking
186 = Mining
197 = Tailoring
202 = Engineering
333 = Enchanting
356 = Fishing
393 = Skinning
755 = Jewelcrafting
762 = Riding

RequiredTradeskillValue

The skill value of the specific Tradeskill

RequiredRepFaction

The ID of the Faction.

RequiredRepValue

 3000 = Friendly
 9000 = Honored
21000 = Revered
42000 = Exalted

LimitTime

Quests that need to be completed in specified time.

SpecialFlags

Not used?

PrevQuestId

The Quest Id of the previous quest.

NextQuestId

The Quest Id of the next quest.

srcItem

SrcItemCount

Title

The Title of the Quest.

Details

The Details of the Quest.

Objectives

The Objectives of the Quest.

CompletionText

The completion text of the Quest.

IncompleteText

The incomplete text of the Quest.

EndText

The end text of the Quest.

ObjectiveText

ReqItemId

The required Item (entry) ID.

ReqItemCount

The required count of Item entry.

ReqKillMobOrGOId

The entry ID of the rquired npc (to kill)

or gameobject (to destroy/open?)

.

ReqKillMobOrGOCount

The required count of killing

/destroying/opening

(ref. to ReqKillMobOrGOId)

ReqCastSpellId

The required spell (ID)

ReqEmoteId

The required emote Id.

RewChoiceItemId

Item entry ID’s from which player can choose as a quest reward. From item_properties table.

RewChoiceItemCount

Count of each item.

RewItemId

ID of Item you attain when you complete the quest from item_properties table, can be mixed with rewchoiceitems.

RewItemCount

Amount of the items you are rewarded with.

RewRepFaction

The faction ID from dbc-file.

RewRepValue

Value of Reputation You will gain on quest finish.

RewRepLimit

Reputation value on player at which the quest wont give anymore reputation (will only disable reputation given. Quest can still be completed).

RewMoney

Money you earn when finishing quest (in copper [e.x. - 105075 = 10g 50s 75c) Negative value means that quest require money.

RewXP

EXP your are rewarded with when you complete a custom quest.

RewSpell

Spell you ATTAIN when finishing quest, SHOULD BE AVOIDED (only use it if you know what you are doing).

CastSpell

Spell cast on the player, when they complete the quest (this SHOULD be used for teaching player spells, using the TRAINER spells).

MailTemplateId

The template of the mail from dbc “MailTemplateEntry”.

MailDelaySecs

The time delay before the mail is send to the player in seconds.

MailSendItem

The item entry ID which would be attached to the mail from item_properties table.

PointMapId

PointX

PointY

PointOpt

RewardMoneyAtMaxLevel

Money you receive when you complete the quest at the server’s max level.

ExploreTrigger

Areatriggers entry ID from areatriggers players need to go to, for finishing quest.

RequiredOneOfQuest

IDs of quests that you must have completed one of to obtain this quest

RequiredQuest

The quest entry IDs the player must complete before attaining this quest.

RemoveQuests

ReceiveItemId

The item entry ID the player revieves from item_properties table.

ReceiveItemCount

Count of item received.

IsRepeatable

Boolean…

0 = Not repeatable (Default)
1 = Repeatable

bonushonor

The amount of Honor you get when you complete the quest.

bonusarenapoints

The amount of arenapoints you get when you complete the quest.

rewardtitleid

The Entry of the reward title.

rewardtalents

The ID of a Title you get when you complete the quest (found in DBC files).

suggestedplayers

The amount of players suggested to complete the quest.

detailemotecount

detailemote

detailemotedelay

completionemotecnt

completionemote

completionemotedelay

completeemote

incompleteemote

iscompletedbyspelleffect

RewXPId