Versiones comparadas

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.
Comentarios: zurückgeholt von v. 117

Table: quest_template

...

FieldTypeNullKeyDefaultExtraComment

74218806ID

int(10) unsigned

NO

PRI

0



74218806QuestType

tinyint(3) unsigned

NO


2



74218806QuestLevel

int(11)

NO


-1



74218806QuestPackageID

int(10) unsigned

NO


0



74218806MinLevel

int(11)

NO


0



74218806QuestSortID

smallint(6)

NO


0



74218806QuestInfoID

smallint(5) unsigned

NO


0



74218806SuggestedGroupNum

tinyint(3) unsigned

NO


0



74218806RewardNextQuest

int(10) unsigned

NO


0



74218806RewardXPDifficulty

int(10) unsigned

NO


0



74218806RewardXPMultiplier

float

NO


1



74218806RewardMoney

int(11)

NO


0



74218806RewardMoneyDifficulty

int(10) unsigned

NO


0



74218806RewardMoneyMultiplier

float

NO


1



74218806RewardBonusMoney

int(10) unsigned

NO


0



RewardDisplaySpell(X=1...3)

int(10) unsigned

NO


0



74218806RewardSpell

int(10) unsigned

NO


0



74218806RewardHonor

int(10) unsigned

NO


0



RewardKillHonor

int(10) unsigned

NO


0



74218806StartItem

int(10) unsigned

NO


0



RewardArtifactXPDifficulty

int(10) unsigned

NO


0



RewardArtifactXPMultiplier

float

NO


1



RewardArtifactCategoryID

int(10) unsigned

NO


0



74218806Flags

int(10) unsigned

NO


0



74218806FlagsEx

int(10) unsigned

NO


0



74218806RewardItem(X=1...4)

int(10) unsigned

NO


0



RewardAmount(X=1...4)

int(10) unsigned

NO


0



ItemDrop(X=1...4)

int(10) unsigned

NO


074218806



ItemDropQuantity(X=1...4)

int(10) unsigned

NO


0



RewardChoiceItemID(X=1...6)

int(10) unsigned

NO


0



RewardChoiceItemQuantity(X=1...6)

int(10) unsigned

NO


0



RewardChoiceItemDisplayID(X=1...6)

int(10) unsigned

NO


0



74218806POIContinent

int(10) unsigned

NO


0



POIx

float

NO


0



POIy

float

NO


0



74218806POIPriority

int(11)

NO


0



74218806RewardTitle

int(10) unsigned

NO


0



RewardArenaPoints

int(10) unsigned

NO


0



RewardSkillLineID

int(10) unsigned

NO


0



74218806RewardNumSkillUps

int(10) unsigned

NO


0



PortraitGiver

int(10) unsigned

NO


0



74218806PortraitTurnIn

int(10) unsigned

NO


0



RewardFactionID(X=1...5)

int(10) unsigned

NO


0



RewardFactionValue(X=1...5)

int(11)

NO


0

74218806



int(11RewardFactionOverride(X=1...5)

int(11)

NO


074218806



RewardFactionCapIn(X=1...5)

int(10) unsigned

NO


0



74218806RewardFactionFlags

int(10) unsigned

NO


0



RewardCurrencyID(X=1...4)

int(10) unsigned

NO


0



RewardCurrencyQty(X=1...4)

int(10) unsigned

NO


0



74218806AcceptedSoundKitID

int(10) unsigned

NO


0



74218806CompleteSoundKitID

int(10) unsigned

NO


0



74218806AreaGroupID

int(10) unsigned

NO


0



74218806TimeAllowed

int(10) unsigned

NO


0



74218806AllowableRaces

int(11)

NO


-1



74218806QuestRewardID

int(10) unsigned

NO


0



74218806LogTitle

text

YES


(NULL)



LogDescription

text

YES


(NULL)



74218806QuestDescription

text

YES


(NULL)



AreaDescription

text

YES


(NULL)



PortraitGiverText

text

YES


(NULL)



PortraitGiverName

text

YES


(NULL)



74218806PortraitTurnInText

text

YES


(NULL)



PortraitTurnInName

text

YES


(NULL)



QuestCompletionLog

text

YES


(NULL)



74218806VerifiedBuild

smallint(5)

YES


0




Description of the fields

...

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

...

Mist of Pandaria and all Expansions after:

33555378 (33554432 + 256 + 128 + 32 + 16 + 2 + 512)  = Horde

18875469 (16777216 + 2097152 + 1024 + 64 + 8 + 4 + 1) = Alliance

RequiredSkillId

Skill required to know to accept the quest. See SkillIne.dbc
0 means no skill is required.

...

Reputation value that the player must achieve with the faction in 74218806 RepObjectiveFaction as part of the quest objectives.

...

If value < 0: Contains the parent quest id, that must be active before this quest can be started.

See the examples section for examples.

NextQuestId

If value > 0: Contains the next quest id, if PrevQuestId of that quest is not sufficient.

If value < 0: Contains the sub quest id, if PrevQuestId of that quest is not sufficient. If quest have many alternative next quests (class specific quests lead from single not class specific quest) field PrevQuestId in next quests can used for setting this dependence.

See the examples section for examples.

ExclusiveGroup

...

Note: All quests that use an ExclusiveGroup must also have entries in pool_template and pool_quest in order for the core to choose one randomly. See the examples section for examples.

RewardNextQuest

...

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 74218806 Level, the basic experience with index RewardXPDifficulty is taken from QuestXP.dbc.

...

Spell that is shown to be casted on quest completion in the quest log. Note that this spell will NOT be casted if 74218806 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.

...

Spell that will always be casted at player when completing the quest. This can be learn spell and player learned some spell in result, or buff spell, for example. If this field is non-zero then this spell will ALWAYS be casted and the spell in 74218806 RewardSpell will not.

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

...

How many seconds to wait until the mail is sent to the character that turned in a quest rewarding items from a loot template defined in 74218806 RewardMailTemplateId

RewardHonor

Number of honorable kill honor rewarded for completing this quest.

...

RewardHonorMultiplier

Multiplies 74218806 RewardHonor, so if value is 2, it will give double.

WARNING: If this field is 1 and 74218806 RewardHonor is 0, the quest will reward default honor kill value (124 honor at level 80)

...

RewardItemCount

field-no-description|46

...

RewardFactionId

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.

...

RewardFactionValueId

This field is used for reputation lookup in QuestFactionReward.dbc if 74218806 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.

...

RewardFactionValueIdOverride

This field is used to give reputation values not present in QuestFactionReward.dbc or to override them if 74218806 RewardRepValueId is wrong for some reason. The value in this field is 100× the intended reputation reward (if you want to give 400 rep, put 40000 in RewardFactionValueIdOverride).

...

Y coordinate of quest POI.

POIPriority

TODO

...

Title

Title of the quest.

Objectives

...

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)

EndText

TODO

QuestCompletionLog

TODO

RequiredNpcOrGo

field-no-description|57

OfferRewardText

First text send to the player by the NPC when completing the quest. 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)

RequestItemsText

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)

CompletedText

field-no-description|59

RequiredNpcOrGo

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.

...

Spell Id required to cast on 74218806 RequiredNpcOrGo to update Objective.

ObjectiveText

...