alpha_world.quest_template

Table

2845 rows in this table. Schema below.

Name Type Null Key Default
entry mediumint(8) unsigned NO PRI 0
Method tinyint(3) unsigned NO 2
ZoneOrSort smallint(6) NO 0
MinLevel tinyint(3) unsigned NO 0
MaxLevel tinyint(3) unsigned NO 0
QuestLevel tinyint(3) unsigned NO 0
Type smallint(5) unsigned NO 0
RequiredClasses smallint(5) unsigned NO 0
RequiredRaces smallint(5) unsigned NO 0
RequiredSkill smallint(5) unsigned NO 0
RequiredSkillValue smallint(5) unsigned NO 0
RequiredCondition mediumint(8) unsigned NO 0
RepObjectiveFaction smallint(5) unsigned NO 0
RepObjectiveValue mediumint(9) NO 0
RequiredMinRepFaction smallint(5) unsigned NO 0
RequiredMinRepValue mediumint(9) NO 0
RequiredMaxRepFaction smallint(5) unsigned NO 0
RequiredMaxRepValue mediumint(9) NO 0
SuggestedPlayers tinyint(3) unsigned NO 0
LimitTime int(10) unsigned NO 0
QuestFlags smallint(5) unsigned NO 0
SpecialFlags tinyint(3) unsigned NO 0
PrevQuestId mediumint(9) NO 0
NextQuestId mediumint(9) NO 0
ExclusiveGroup mediumint(9) NO 0
NextQuestInChain mediumint(8) unsigned NO 0
SrcItemId mediumint(8) unsigned NO 0
SrcItemCount tinyint(3) unsigned NO 0
SrcSpell mediumint(8) unsigned NO 0
Title text YES NULL
Details text YES NULL
Objectives text YES NULL
OfferRewardText text YES NULL
RequestItemsText text YES NULL
EndText text YES NULL
ObjectiveText1 text YES NULL
ObjectiveText2 text YES NULL
ObjectiveText3 text YES NULL
ObjectiveText4 text YES NULL
ReqItemId1 mediumint(8) unsigned NO 0
ReqItemId2 mediumint(8) unsigned NO 0
ReqItemId3 mediumint(8) unsigned NO 0
ReqItemId4 mediumint(8) unsigned NO 0
ReqItemCount1 smallint(5) unsigned NO 0
ReqItemCount2 smallint(5) unsigned NO 0
ReqItemCount3 smallint(5) unsigned NO 0
ReqItemCount4 smallint(5) unsigned NO 0
ReqSourceId1 mediumint(8) unsigned NO 0
ReqSourceId2 mediumint(8) unsigned NO 0
ReqSourceId3 mediumint(8) unsigned NO 0
ReqSourceId4 mediumint(8) unsigned NO 0
ReqSourceCount1 mediumint(8) unsigned NO 0
ReqSourceCount2 mediumint(8) unsigned NO 0
ReqSourceCount3 mediumint(8) unsigned NO 0
ReqSourceCount4 mediumint(8) unsigned NO 0
ReqCreatureOrGOId1 mediumint(9) NO 0
ReqCreatureOrGOId2 mediumint(9) NO 0
ReqCreatureOrGOId3 mediumint(9) NO 0
ReqCreatureOrGOId4 mediumint(9) NO 0
ReqCreatureOrGOCount1 smallint(5) unsigned NO 0
ReqCreatureOrGOCount2 smallint(5) unsigned NO 0
ReqCreatureOrGOCount3 smallint(5) unsigned NO 0
ReqCreatureOrGOCount4 smallint(5) unsigned NO 0
ReqSpellCast1 mediumint(8) unsigned NO 0
ReqSpellCast2 mediumint(8) unsigned NO 0
ReqSpellCast3 mediumint(8) unsigned NO 0
ReqSpellCast4 mediumint(8) unsigned NO 0
RewChoiceItemId1 mediumint(8) unsigned NO 0
RewChoiceItemId2 mediumint(8) unsigned NO 0
RewChoiceItemId3 mediumint(8) unsigned NO 0
RewChoiceItemId4 mediumint(8) unsigned NO 0
RewChoiceItemId5 mediumint(8) unsigned NO 0
RewChoiceItemId6 mediumint(8) unsigned NO 0
RewChoiceItemCount1 smallint(5) unsigned NO 0
RewChoiceItemCount2 smallint(5) unsigned NO 0
RewChoiceItemCount3 smallint(5) unsigned NO 0
RewChoiceItemCount4 smallint(5) unsigned NO 0
RewChoiceItemCount5 smallint(5) unsigned NO 0
RewChoiceItemCount6 smallint(5) unsigned NO 0
RewItemId1 mediumint(8) unsigned NO 0
RewItemId2 mediumint(8) unsigned NO 0
RewItemId3 mediumint(8) unsigned NO 0
RewItemId4 mediumint(8) unsigned NO 0
RewItemCount1 smallint(5) unsigned NO 0
RewItemCount2 smallint(5) unsigned NO 0
RewItemCount3 smallint(5) unsigned NO 0
RewItemCount4 smallint(5) unsigned NO 0
RewRepFaction1 smallint(5) unsigned NO 0
RewRepFaction2 smallint(5) unsigned NO 0
RewRepFaction3 smallint(5) unsigned NO 0
RewRepFaction4 smallint(5) unsigned NO 0
RewRepFaction5 smallint(5) unsigned NO 0
RewRepValue1 mediumint(9) NO 0
RewRepValue2 mediumint(9) NO 0
RewRepValue3 mediumint(9) NO 0
RewRepValue4 mediumint(9) NO 0
RewRepValue5 mediumint(9) NO 0
RewXP mediumint(9) unsigned NO 0
RewOrReqMoney int(11) NO 0
RewSpell mediumint(8) unsigned NO 0
RewSpellCast mediumint(8) unsigned NO 0
RewMailTemplateId mediumint(8) NO 0
RewMailDelaySecs int(11) unsigned NO 0
RewMailMoney int(10) unsigned NO 0
PointMapId smallint(5) unsigned NO 0
PointX float NO 0
PointY float NO 0
PointOpt mediumint(8) unsigned NO 0
DetailsEmote1 smallint(5) unsigned NO 0
DetailsEmote2 smallint(5) unsigned NO 0
DetailsEmote3 smallint(5) unsigned NO 0
DetailsEmote4 smallint(5) unsigned NO 0
DetailsEmoteDelay1 int(11) unsigned NO 0
DetailsEmoteDelay2 int(11) unsigned NO 0
DetailsEmoteDelay3 int(11) unsigned NO 0
DetailsEmoteDelay4 int(11) unsigned NO 0
IncompleteEmote smallint(5) unsigned NO 0
CompleteEmote smallint(5) unsigned NO 0
OfferRewardEmote1 smallint(5) unsigned NO 0
OfferRewardEmote2 smallint(5) unsigned NO 0
OfferRewardEmote3 smallint(5) unsigned NO 0
OfferRewardEmote4 smallint(5) unsigned NO 0
OfferRewardEmoteDelay1 int(11) unsigned NO 0
OfferRewardEmoteDelay2 int(11) unsigned NO 0
OfferRewardEmoteDelay3 int(11) unsigned NO 0
OfferRewardEmoteDelay4 int(11) unsigned NO 0
StartScript mediumint(8) unsigned NO 0
CompleteScript mediumint(8) unsigned NO 0
ignored tinyint(1) unsigned NO 0
parse_timestamp date NO '2004-12-04'