Versiones comparadas

Versión anterior 115

changes.mady.by.user Magnus

Guardado el

comparado con

Nueva versión Actual

changes.mady.by.user Tikki

Guardado el

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.

Table: quest_template

...

FieldTypeNullKeyDefaultExtraComment

ID74218806

int(10) unsigned

NO

PRI

0



QuestType74218806

tinyint(3) unsigned

NO


2



QuestLevel74218806

int(11)

NO


-1



QuestPackageID74218806

int(10) unsigned

NO


0



MinLevel74218806

int(11)

NO


0



QuestSortID74218806

smallint(6)

NO


0



QuestInfoID74218806

smallint(5) unsigned

NO


0



SuggestedGroupNum74218806

tinyint(3) unsigned

NO


0



RewardNextQuest74218806

int(10) unsigned

NO


0



RewardXPDifficulty74218806

int(10) unsigned

NO


0



RewardXPMultiplier74218806

float

NO


1



RewardMoney74218806

int(11)

NO


0



RewardMoneyDifficulty74218806

int(10) unsigned

NO


0



RewardMoneyMultiplier74218806

float

NO


1



RewardBonusMoney74218806

int(10) unsigned

NO


0



RewardDisplaySpell(X=1...3)

int(10) unsigned

NO


0



RewardSpell74218806

int(10) unsigned

NO


0



RewardHonor74218806

int(10) unsigned

NO


0



RewardKillHonor

int(10) unsigned

NO


0



StartItem74218806

int(10) unsigned

NO


0



RewardArtifactXPDifficulty

int(10) unsigned

NO


0



RewardArtifactXPMultiplier

float

NO


1



RewardArtifactCategoryID

int(10) unsigned

NO


0



Flags74218806

int(10) unsigned

NO


0



FlagsEx74218806

int(10) unsigned

NO


0



RewardItem(X=1...4)74218806

int(10) unsigned

NO


0



RewardAmount(X=1...4)

int(10) unsigned

NO


0



ItemDrop(X=1...4)

int(10) unsigned

NO


0



ItemDropQuantity(X=1...4)74218806

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



POIContinent74218806

int(10) unsigned

NO


0



POIx

float

NO


0



POIy

float

NO


0



POIPriority74218806

int(11)

NO


0



RewardTitle74218806

int(10) unsigned

NO


0



RewardArenaPoints

int(10) unsigned

NO


0



RewardSkillLineID

int(10) unsigned

NO


0



RewardNumSkillUps74218806

int(10) unsigned

NO


0



PortraitGiver

int(10) unsigned

NO


0



PortraitTurnIn74218806

int(10) unsigned

NO


0



RewardFactionID(X=1...5)

int(10) unsigned

NO


0



RewardFactionValue(X=1...5)

int(11)

NO


0

RewardFactionOverride(X=1...5)



int(1174218806

int(11)

NO


0



RewardFactionCapIn(X=1...5)74218806

int(10) unsigned

NO


0



RewardFactionFlags74218806

int(10) unsigned

NO


0



RewardCurrencyID(X=1...4)

int(10) unsigned

NO


0



RewardCurrencyQty(X=1...4)

int(10) unsigned

NO


0



AcceptedSoundKitID74218806

int(10) unsigned

NO


0



CompleteSoundKitID74218806

int(10) unsigned

NO


0



AreaGroupID74218806

int(10) unsigned

NO


0



TimeAllowed74218806

int(10) unsigned

NO


0



AllowableRaces74218806

int(11)

NO


-1



QuestRewardID74218806

int(10) unsigned

NO


0



LogTitle74218806

text

YES


(NULL)



LogDescription

text

YES


(NULL)



QuestDescription74218806

text

YES


(NULL)



AreaDescription

text

YES


(NULL)



PortraitGiverText

text

YES


(NULL)



PortraitGiverName

text

YES


(NULL)



PortraitTurnInText74218806

text

YES


(NULL)



PortraitTurnInName

text

YES


(NULL)



QuestCompletionLog

text

YES


(NULL)



VerifiedBuild74218806

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

RewardMoney

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

RewardMoneyMaxLevel

The money a character at level 80 would get when they complete this quest. 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 repeatableThis 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

RewardSpell

...

RewardMoney

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

RewardBonusMoney

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

RewardSpell

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

RewardHonor

Number of honorable kill honor rewarded for completing this quest.

...

RewardHonorMultiplier

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

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

...

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.(question)

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_NONE2Unknown at this time and not used.CONDITION

Not used currently

32

QUEST_FLAGS_HIDE_REWARD_EPICEpic class quests (hunter) (??)POI

Not used currently: Unsure of content

64

QUEST_FLAGS_RAIDRaid

or similiar player group needed for quest.Can be completed while in raid

128

QUEST_FLAGS_TBCAdded with or after TBC.

Not used currently: Available if TBC expansion enabled only

256

QUEST_FLAGS_DELIVER_MOREQuest needs extra non-objective items dropped (eg. RequiredSourceItemId fields) (question)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__AUTO_REWARDEDTRACKING

These quests are automatically rewarded on quest complete and they will never appear in quest log client side.

2048

QUEST_FLAGS_TBCDEPRECATE_RACESBlood elf/draenei starting zone quests.REPUTATION

Not used currently

4096

QUEST_FLAGS_DAILY

Daily repeatable quests (only flag that the core applies specific behavior for)

8192

QUEST_FLAGS_FLAGS_REPEATABLEUsed on repeatable questsPVP

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_SPECIALDISPLAY_ITEM

has something to do with RequiredItemId and SourceItemId

262144

QUEST_FLAGS_OBJ_TEXT

Use Objective text as Complete text

524288

QUEST_FLAGS_AUTO_ACCEPT

Quests in starting areas

1048576QUEST_FLAGS_AUTO_SUBMIT  Quests with this flag player submit automatically by special button in player GUI
2097152 QUEST_FLAGS_AUTO_TAKEAutomatically suggestion of accepting quest. Not from npc.

_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.

1048576QUEST_FLAGS_PLAYER_CAST_ON_ACCEPTQuests with this flag player submit automatically by special button in player GUI
2097152 QUEST_FLAGS_PLAYER_CAST_ON_COMPLETEAutomatically suggestion of accepting quest. Not from npc.
4194304QUEST_FLAGS_UPDATE_PHASE_SHIFT
8388608QUEST_FLAGS_SOR_WHITELIST
16777216QUEST_FLAGS_LAUNCH_GOSSIP_COMPLETE
33554432QUEST_FLAGS_REMOVE_EXTRA_GET_ITEMS
67108864QUEST_FLAGS_HIDE_UNTIL_DISCOVERED
134217728QUEST_FLAGS_PORTRAIT_IN_QUEST_LOG
268435456QUEST_FLAGS_SHOW_ITEM_WHEN_COMPLETED
536870912QUEST_FLAGS_LAUNCH_GOSSIP_ACCEPT
1073741824QUEST_FLAGS_ITEMS_GLOW_WHEN_DONE
2147483648QUEST_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.

SpecialFlags

This has been moved to quest_template_addon.SpecialFlags

This field is a bitmask and is for controlling server side quest functions. This data blizz keeps serverside, and is not sent to the client, so we have to populate the field manually.

...

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

...

This field is used to give reputation values not present in QuestFactionReward.dbc or to override them if RewardRepValueId 74218806 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).

...

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

ObjectiveText

...