Quest template
Ir a la navegación
Ir a la búsqueda
La tabla `quest_template`
Contiene los datos básicos de todas las misiones.
Estructura
| Field | Type | Attributes | Key | NULL | Default | Extra | Comment | |
|---|---|---|---|---|---|---|---|---|
| Id | mediumint(8) | unsigned | PRI | NO | 0 | |||
| Method | tinyint(3) | unsigned | NO | 2 | ||||
| Level | smallint(3) | signed | NO | 0 | ||||
| MinLevel | tinyint(3) | signed | NO | 0 | ||||
| MaxLevel | tinyint(3) | unsigned | NO | 0 | ||||
| ZoneOrSort | smallint(6) | signed | NO | 1 | ||||
| Type | smallint(5) | unsigned | NO | 0 | ||||
| SuggestedPlayers | tinyint(3) | unsigned | NO | 0 | ||||
| LimitTime | int(10) | unsigned | NO | 0 | ||||
| RequiredClasses | smallint(5) | unsigned | NO | 0 | ||||
| RequiredRaces | smallint(5) | NO | 0 | |||||
| RequiredSkillId | smallint(5) | unsigned | NO | 0 | ||||
| RequiredSkillPoints | smallint(5) | unsigned | NO | 0 | ||||
| RequiredFactionId1 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredFactionId2 | smallint(5) | signed | NO | 0 | ||||
| RequiredFactionValue1 | mediumint(9) | signed | NO | 0 | ||||
| RequiredFactionValue2 | mediumint(9) | unsigned | NO | 0 | ||||
| RequiredMinRepFaction | smallint(5) | signed | NO | 0 | ||||
| RequiredMaxRepFaction | smallint(5) | unsigned | NO | 0 | ||||
| RequiredMinRepValue | mediumint(9) | signed | NO | 0 | ||||
| RequiredMaxRepValue | mediumint(9) | signed | NO | 0 | ||||
| PrevQuestId | mediumint(9) | signed | NO | 0 | ||||
| NextQuestId | mediumint(9) | signed | NO | 0 | ||||
| ExclusiveGroup | mediumint(9) | signed | NO | 0 | ||||
| NextQuestIdChain | mediumint(8) | unsigned | NO | 0 | ||||
| RewXPId | tinyint(2) | unsigned | NO | 0 | ||||
| RewardOrRequiredMoney | int(11) | signed | NO | 0 | ||||
| RewardMoneyMaxLevel | int(10) | unsigned | NO | 0 | ||||
| RewardSpell | mediumint(8) | unsigned | NO | 0 | ||||
| RewardSpellCast | int(11) | signed | NO | 0 | ||||
| RewardHonor | int(10) | unsigned | NO | 0 | ||||
| RewardHonorMultiplier | float | signed | NO | 1 | ||||
| RewardMailTemplateId | mediumint(8) | unsigned | NO | 0 | ||||
| RewardMailDelay | int(11) | unsigned | NO | 0 | ||||
| SourceItemId | mediumint(8) | unsigned | NO | 0 | ||||
| SourceItemCount | tinyint(3) | unsigned | NO | 0 | ||||
| SourceSpell | mediumint(8) | unsigned | NO | 0 | ||||
| Flags | int(10) | unsigned | NO | 0 | ||||
| SpecialFlags | tinyint(3) | unsigned | NO | 0 | ||||
| RewardTitleId | tinyint(3) | unsigned | NO | 0 | ||||
| RequiredPlayerKills | tinyint(3) | unsigned | NO | 0 | ||||
| RewardTalents | tinyint(3) | unsigned | NO | 0 | ||||
| RewardArenaPoints | smallint(5) | unsigned | NO | 0 | ||||
| RewardItemId1 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardItemId2 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardItemId3 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardItemId4 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardItemCount1 | smallint(5) | unsigned | NO | 0 | ||||
| RewardItemCount2 | smallint(5) | unsigned | NO | 0 | ||||
| RewardItemCount3 | smallint(5) | unsigned | NO | 0 | ||||
| RewardItemCount4 | smallint(5) | unsigned | NO | 0 | ||||
| RewardChoiceItemId1 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardChoiceItemId2 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardChoiceItemId3 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardChoiceItemId4 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardChoiceItemId5 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardChoiceItemId6 | mediumint(8) | unsigned | NO | 0 | ||||
| RewardChoiceItemCount1 | smallint(5) | unsigned | NO | 0 | ||||
| RewardChoiceItemCount2 | smallint(5) | unsigned | NO | 0 | ||||
| RewardChoiceItemCount3 | smallint(5) | unsigned | NO | 0 | ||||
| RewardChoiceItemCount4 | smallint(5) | unsigned | NO | 0 | ||||
| RewardChoiceItemCount5 | smallint(5) | unsigned | NO | 0 | ||||
| RewardChoiceItemCount6 | smallint(5) | unsigned | NO | 0 | ||||
| RewardFactionId1 | smallint(5) | unsigned | NO | 0 | faction id from Faction.dbc in this case | |||
| RewardFactionId2 | smallint(5) | unsigned | NO | 0 | faction id from Faction.dbc in this case | |||
| RewardFactionId3 | smallint(5) | unsigned | NO | 0 | faction id from Faction.dbc in this case | |||
| RewardFactionId4 | smallint(5) | unsigned | NO | 0 | faction id from Faction.dbc in this case | |||
| RewardFactionId5 | smallint(5) | unsigned | NO | 0 | faction id from Faction.dbc in this case | |||
| RewardRepValueId1 | mediumint(6) | signed | NO | 0 | ||||
| RewardRepValueId2 | mediumint(6) | signed | NO | 0 | ||||
| RewardRepValueId3 | mediumint(6) | signed | NO | 0 | ||||
| RewardRepValueId4 | mediumint(6) | signed | NO | 0 | ||||
| RewardRepValueId5 | mediumint(6) | signed | NO | 0 | ||||
| RewardFactionValueIdOverride1 | mediumint(9) | signed | NO | 0 | ||||
| RewardFactionValueIdOverride2 | mediumint(9) | signed | NO | 0 | ||||
| RewardFactionValueIdOverride3 | mediumint(9) | signed | NO | 0 | ||||
| RewardFactionValueIdOverride4 | mediumint(9) | signed | NO | 0 | ||||
| RewardFactionValueIdOverride5 | mediumint(9) | signed | NO | 0 | ||||
| PointMapId | smallint(5) | unsigned | NO | 0 | ||||
| PointX | float | signed | NO | 0 | ||||
| PointY | float | signed | NO | 0 | ||||
| PointOption | mediumint(8) | unsigned | NO | 0 | ||||
| Title | text | signed | YES | NULL | ||||
| Objectives | text | signed | YES | NULL | ||||
| Details | text | signed | YES | NULL | ||||
| EndText | text | signed | YES | NULL | ||||
| OfferRewardText | text | signed | YES | NULL | ||||
| RequestItemsText | text | signed | YES | NULL | ||||
| CompletedText | text | signed | YES | NULL | ||||
| RequiredNpcOrGo1 | mediumint(9) | signed | NO | 0 | ||||
| RequiredNpcOrGo2 | mediumint(9) | signed | NO | 0 | ||||
| RequiredNpcOrGo3 | mediumint(9) | signed | NO | 0 | ||||
| RequiredNpcOrGo4 | mediumint(9) | signed | NO | 0 | ||||
| RequiredNpcOrGoCount1 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredNpcOrGoCount2 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredNpcOrGoCount3 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredNpcOrGoCount4 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredSourceItemId1 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredSourceItemId2 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredSourceItemId3 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredSourceItemId4 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredSourceItemCount1 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredSourceItemCount2 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredSourceItemCount3 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredSourceItemCount4 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredItemId1 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredItemId2 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredItemId3 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredItemId4 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredItemId5 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredItemId6 | mediumint(8) | unsigned | NO | 0 | ||||
| RequiredItemCount1 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredItemCount2 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredItemCount3 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredItemCount4 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredItemCount5 | smallint(5) | unsigned | NO | 0 | ||||
| RequiredItemCount6 | smallint(5) | unsigned | NO | 0 | ||||
| Unknown0 | tinyint(2) | unsigned | NO | 0 | ||||
| ObjectiveText1 | text | signed | YES | NULL | ||||
| ObjectiveText2 | text | signed | YES | NULL | ||||
| ObjectiveText3 | text | signed | YES | NULL | ||||
| ObjectiveText4 | text | signed | YES | NULL | ||||
| 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(10) | unsigned | NO | 0 | ||||
| DetailsEmoteDelay2 | int(10) | unsigned | NO | 0 | ||||
| DetailsEmoteDelay3 | int(10) | unsigned | NO | 0 | ||||
| DetailsEmoteDelay4 | int(10) | unsigned | NO | 0 | ||||
| EmoteOnIncomplete | smallint(5) | unsigned | NO | 0 | ||||
| EmoteOnComplete | 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(10) | unsigned | NO | 0 | ||||
| OfferRewardEmoteDelay2 | int(10) | unsigned | NO | 0 | ||||
| OfferRewardEmoteDelay3 | int(10) | unsigned | NO | 0 | ||||
| OfferRewardEmoteDelay4 | int(10) | unsigned | NO | 0 | ||||
| WDBVerified | smallint(5) | signed | YES | 1 |