用户工具

站点工具


数据库:world数据库:quest_template

这是本文档旧的修订版!


目录

quest_template 表


<-返回:World 数据库

Contains all basic definitions of available quests.

表结构

FieldTypeAttributesKeyNullDefaultExtraComment
IDMEDIUMINTUNSIGNEDPRINO0
QuestTypeTINYINTUNSIGNED NO2
QuestLevelSMALLINT NO1
MinLevelTINYINTUNSIGNED NO0
QuestSortIDSMALLINT NO0
QuestInfoIDSMALLINTUNSIGNED NO0
SuggestedGroupNumTINYINTUNSIGNED NO0
RequiredFactionId1SMALLINTUNSIGNED NO0
RequiredFactionId2SMALLINTUNSIGNED NO0
RequiredFactionValue1MEDIUMINT NO0
RequiredFactionValue2MEDIUMINT NO0
RewardNextQuestMEDIUMINTUNSIGNED NO0
RewardXPDifficultyTINYINTUNSIGNED NO0
RewardMoneyINT NO0
RewardMoneyDifficultyINTUNSIGNED NO0
RewardBonusMoneyINTUNSIGNED NO0
RewardDisplaySpellMEDIUMINTUNSIGNED NO0
RewardSpellINT NO0
RewardHonorINT NO0
RewardKillHonorFLOAT NO0
StartItemMEDIUMINTUNSIGNED NO0
FlagsINTUNSIGNED NO0
RequiredPlayerKillsTINYINTUNSIGNED NO0
RewardItem1MEDIUMINTUNSIGNED NO0
RewardAmount1SMALLINTUNSIGNED NO0
RewardItem2MEDIUMINTUNSIGNED NO0
RewardAmount2SMALLINTUNSIGNED NO0
RewardItem3MEDIUMINTUNSIGNED NO0
RewardAmount3SMALLINTUNSIGNED NO0
RewardItem4MEDIUMINTUNSIGNED NO0
RewardAmount4SMALLINTUNSIGNED NO0
ItemDrop1MEDIUMINTUNSIGNED NO0
ItemDropQuantity1SMALLINTUNSIGNED NO0
ItemDrop2MEDIUMINTUNSIGNED NO0
ItemDropQuantity2SMALLINTUNSIGNED NO0
ItemDrop3MEDIUMINTUNSIGNED NO0
ItemDropQuantity3SMALLINTUNSIGNED NO0
ItemDrop4MEDIUMINTUNSIGNED NO0
ItemDropQuantity4SMALLINTUNSIGNED NO0
RewardChoiceItemID1MEDIUMINTUNSIGNED NO0
RewardChoiceItemQuantity1SMALLINTUNSIGNED NO0
RewardChoiceItemID2MEDIUMINTUNSIGNED NO0
RewardChoiceItemQuantity2SMALLINTUNSIGNED NO0
RewardChoiceItemID3MEDIUMINTUNSIGNED NO0
RewardChoiceItemQuantity3SMALLINTUNSIGNED NO0
RewardChoiceItemID4MEDIUMINTUNSIGNED NO0
RewardChoiceItemQuantity4SMALLINTUNSIGNED NO0
RewardChoiceItemID5MEDIUMINTUNSIGNED NO0
RewardChoiceItemQuantity5SMALLINTUNSIGNED NO0
RewardChoiceItemID6MEDIUMINTUNSIGNED NO0
RewardChoiceItemQuantity6SMALLINTUNSIGNED NO0
POIContinentSMALLINTUNSIGNED NO0
POIxFLOAT NO0
POIyFLOAT NO0
POIPriorityMEDIUMINTUNSIGNED NO0
RewardTitleTINYINTUNSIGNED NO0
RewardTalentsTINYINTUNSIGNED NO0
RewardArenaPointsSMALLINTUNSIGNED NO0
RewardFactionID1SMALLINTUNSIGNED NO0
RewardFactionValue1MEDIUMINT NO0
RewardFactionOverride1MEDIUMINT NO0
RewardFactionID2SMALLINTUNSIGNED NO0
RewardFactionValue2MEDIUMINT NO0
RewardFactionOverride2MEDIUMINT NO0
RewardFactionID3SMALLINTUNSIGNED NO0
RewardFactionValue3MEDIUMINT NO0
RewardFactionOverride3MEDIUMINT NO0
RewardFactionID4SMALLINTUNSIGNED NO0
RewardFactionValue4MEDIUMINT NO0
RewardFactionOverride4MEDIUMINT NO0
RewardFactionID5SMALLINTUNSIGNED NO0
RewardFactionValue5MEDIUMINT NO0
RewardFactionOverride5MEDIUMINT NO0
TimeAllowedINTUNSIGNED NO0
AllowableRacesSMALLINTUNSIGNED NO0
LogTitleTEXT YES
LogDescriptionTEXT YES
QuestDescriptionTEXT YES
AreaDescriptionTEXT YES
QuestCompletionLogTEXT YES
RequiredNpcOrGo1MEDIUMINT NO0
RequiredNpcOrGo2MEDIUMINT NO0
RequiredNpcOrGo3MEDIUMINT NO0
RequiredNpcOrGo4MEDIUMINT NO0
RequiredNpcOrGoCount1SMALLINTUNSIGNED NO0
RequiredNpcOrGoCount2SMALLINTUNSIGNED NO0
RequiredNpcOrGoCount3SMALLINTUNSIGNED NO0
RequiredNpcOrGoCount4SMALLINTUNSIGNED NO0
RequiredItemId1MEDIUMINTUNSIGNED NO0
RequiredItemId2MEDIUMINTUNSIGNED NO0
RequiredItemId3MEDIUMINTUNSIGNED NO0
RequiredItemId4MEDIUMINTUNSIGNED NO0
RequiredItemId5MEDIUMINTUNSIGNED NO0
RequiredItemId6MEDIUMINTUNSIGNED NO0
RequiredItemCount1SMALLINTUNSIGNED NO0
RequiredItemCount2SMALLINTUNSIGNED NO0
RequiredItemCount3SMALLINTUNSIGNED NO0
RequiredItemCount4SMALLINTUNSIGNED NO0
RequiredItemCount5SMALLINTUNSIGNED NO0
RequiredItemCount6SMALLINTUNSIGNED NO0
Unknown0TINYINTUNSIGNED NO0
ObjectiveText1TEXT YES
ObjectiveText2TEXT YES
ObjectiveText3TEXT YES
ObjectiveText4TEXT YES
VerifiedBuildSMALLINT YES0

字段说明


ID

The quest ID. This column is the Primary Key for the Table. Each quest ID must be unique!

QuestType

Accepted values: 0, 1, 2 or 3. Their meaning is described in table below.

Value Result 0 Quest is enabled, but it is auto-completed when accepted; this skips quest objectives and quest details. 1 Quest is disabled (not yet implemented in the core). 2 Quest is enabled (does not auto-complete). 3 Quest is a World Quest.

QuestLevel

Level of quest. Player receives full experience amount only if their level is less than or equal to Level+5. If Level is set to -1, the player's level will be used as (Quest)Level for the experience calculation.

MinLevel

Minimum level at which a player can get the quest.

QuestSortID

This field defines under what category the quest falls in the quest log.

If value > 0 then value is Zone IDs taken from AreaTable.dbc.

if value < 0 then (-value) is quest sort id: (in general profession or class quests. Also see RequiredSkillPoints ) Value is ID from QuestSort.dbc

QuestInfoID

These values are ID taken from QuestInfo.dbc

SuggestedGroupNum

Recommended number of players to do the quest together.

RewardFactionId1

Faction Id (from Faction.dbc) for which the quest give reputation points. Number of gain or lost reputation points for Faction at quest completion. This is special reputation rewarding. Normal reputation reward to quest rewarding creature faction calculated and added automatically.

RewardFactionId2

Faction Id (from Faction.dbc) for which the quest give reputation points. Number of gain or lost reputation points for Faction at quest completion. This is special reputation rewarding. Normal reputation reward to quest rewarding creature faction calculated and added automatically.

RewardFactionValueId1

This field is used for reputation lookup in QuestFactionReward.dbc if quest_template#RewardFactionValueId is 0. Value X in this field indicates RepX column of QuestFactionReward.dbc. If RewardRepValueId is positive, reputation from the first row of QuestFactionReward.dbc will be used, for negative values the second row is used.

RewardFactionValueId2

This field is used for reputation lookup in QuestFactionReward.dbc if quest_template#RewardFactionValueId is 0. Value X in this field indicates RepX column of QuestFactionReward.dbc. If RewardRepValueId is positive, reputation from the first row of QuestFactionReward.dbc will be used, for negative values the second row is used.

RewardNextQuest

RewardNextQuest (Old field name: NextQuestIdChain)

The quest entry from a creature or gameobject that ends a quest and starts a new one. The result is, that if you end the quest, the new quest instantly appears from the quest giver.

See the examples section for examples.

RewardXPDifficulty

According to the Level, the basic experience with index RewardXPDifficulty is taken from QuestXP.dbc.

This field also controls the XP given as the XP is calculated from the value in this field by the following formula. If the quest is repeatable, XP will be given only once. The total XP that a character will receive is also affected by the level difference between the character's level and the quest's level.

The formula for calculating XP from the value in this field:

  • QuestLevel >= 65: XP = RewMoneyMaxLevel / 6.0
  • QuestLevel h1. 64: XP = RewMoneyMaxLevel / 4.8
  • QuestLevel 63: XP = RewMoneyMaxLevel / 3.6
  • QuestLevel h1. 62: XP = RewMoneyMaxLevel / 2.4
  • QuestLevel 61: XP = RewMoneyMaxLevel / 1.2
  • QuestLevel ⇐ 60: XP = RewMoneyMaxLevel / 0.6

RewardMoney

Money earned by completing the quest (if value > 0) or money requirement to complete the quest (if value < 0) .

RewardMoneyDifficulty

ID refers to one of the money factor included in MoneyFactor ordered by level.

RewardBonusMoney

The money a character at level 80 would get when they complete this quest.

RewardDisplaySpell

Spell that is shown to be casted on quest completion in the quest log. Note that this spell will NOT be casted if RewardSpell is non-zero. The spell in the other field will be casted instead, in which case the spell here only serves as the visual in the quest log.

RewardSpell

Spell that is shown to be casted on quest completion in the quest log. Note that this spell will NOT be casted if RewardSpellCast is non-zero. The spell in the other field will be casted instead, in which case the spell here only serves as the visual in the quest log.

NOTE: This field comes straight from the WDB and should not be changed.

RewardHonor

Number of honorable kill honor rewarded for completing this quest.

Example: An example value is 15 for quest 8388: At level 80 an honorable kill is 124 honor worth. Multiply this with 15 and you receive 1860, after the multiplication the value is rounded up. So the honor rewarded at level 80 is 1860 for this quest.

RewardKillHonor

StartItem

Items given by the quest giver at beginning of the quest. Items will be deleted when quest is abandoned.

Flags

This flag field defines more specifically the type of quest it is. Aside from the daily flag and sharable flag, this field is used just for grouping purposes and NOT for any other quest requirements. The quest requirements are calculated from non-zero values in other quest template fields. Also, while some of these flags are known, others have yet an unknown purpose and the comments below is simply guesswork on them.

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 Like all flag based fields, QuestFlags can be added for the different types of quest.

Note that some flags may not be supported by core.

RequiredPlayerKills

Displays how much players you need to kill betd class=td class=a class=/td data-linked-resource-default-alias=fore completing the quest.

RewardItem1

item Id 1 given for reward (no choice).

RewardAmount1

Amount to be obtained from the above-mentioned item

RewardItem2

item Id 2 given for reward (no choice).

RewardAmount2

Amount to be obtained from the above-mentioned item

RewardItem3

item Id 3 given for reward (no choice).

RewardAmount3

Amount to be obtained from the above-mentioned item

RewardItem4

item Id 4 given for reward (no choice).

RewardAmount4

Amount to be obtained from the above-mentioned item

ItemDrop1

ItemDropQuantity1

ItemDrop2

ItemDropQuantity2

ItemDrop3

ItemDropQuantity3

ItemDrop4

ItemDropQuantity4

RewardChoiceItemID1

RewardChoiceItemQuantity1

RewardChoiceItemID2

RewardChoiceItemQuantity2

RewardChoiceItemID3

RewardChoiceItemQuantity3

RewardChoiceItemID4

RewardChoiceItemQuantity4

RewardChoiceItemID5

RewardChoiceItemQuantity5

RewardChoiceItemID6

RewardChoiceItemQuantity6

POIContinent

MapId of a quest point of interest (POI - Point Of Interest). POI will be shown on the map when quest is active.

POIx

X coordinate of quest POI.

POIy

Y coordinate of quest POI.

POIPriority

TODO

RewardTitle

RewardTalents

RewardArenaPoints

RewardFactionID1

RewardFactionValue1

RewardFactionOverride1

RewardFactionID2

RewardFactionValue2

ItemDrop

RewardFactionOverride2

RewardFactionID3

ItemDropQuantity

The maximum number of copies of the item in ItemDrop that can be picked up (and dropped by the core).

RewardFactionValue3

RewardFactionOverride3

RewardFactionID4

RewardFactionValue4

RewardFactionOverride4

RewardFactionID5

RewardFactionValue5

RewardFactionOverride5

TimeAllowed

AllowableRaces

LogTitle

Title of the quest.

LogDescription

Objectives of the quest. If empty, quest is an auto-complete quest that can be immediately finished without accepting it first.

QuestDescription

The quest text. You can use certain placeholders that will be filled in in-game: $B - line break, $N - name, $R - race, $C - class, $Gmale:female; (male and female can be replace with any synonymn you want, but the order must stay the same. IE: boy:girl / man:woman / sir:madam / dude:chick)

AreaDescription

QuestCompletionLog

Text sent to player when the player tries to talk to the NPC with the quest active but incomplete. (The text under the “Progress” title in Wowhead.) You can use certain placeholders that will be filled in in-game: $B - line break, $N - name, $R - race, $C - class, $Gmale:female; (male and female can be replace with any synonymn you want, but the order must stay the same. IE: boy:girl / man:woman / sir:madam / dude:chick)

RequiredNpcOrGo1

RequiredNpcOrGo2

RequiredNpcOrGo3

RequiredNpcOrGo4

  • Value > 0:required creature_template ID the player needs to kill/cast on in order to complete the quest.
  • Value < 0:required gameobject_template ID the player needs to cast on in order to complete the quest.
  • If*RequiredSpellCast*is != 0, the objective is to cast on target, else kill.

NOTE: If RequiredSpellCast is != 0 and the spell has effects Send Event or Quest Complete, this field may be left empty.

RequiredNpcOrGoCount1

RequiredNpcOrGoCount2

RequiredNpcOrGoCount3

RequiredNpcOrGoCount4

The number of times the creature or gameobject must be killed or casted upon.

RequiredItemId1

RequiredItemId2

RequiredItemId3

RequiredItemId4

RequiredItemId5

RequiredItemId6

Id of required item to complete the quest.

RequiredItemCount1

RequiredItemCount2

RequiredItemCount3

RequiredItemCount4

RequiredItemCount5

RequiredItemCount6

Amount of required items

Unknown0

ObjectiveText1

ObjectiveText2

ObjectiveText3

ObjectiveText4

Used to define non-standard objective texts, that show up in the questlog. Example, “Heal fallen warrior” and the number gets added by Count values.

VerifiedBuild

数据库/world数据库/quest_template.1696324052.txt.gz · 最后更改: 2023/10/03 17:07 由 admin

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki