access_requirement achievement_criteria_data achievement_dbc achievement_reward achievement_reward_locale areatrigger_involvedrelation areatrigger_scripts areatrigger_tavern areatrigger_teleport battleground_template battlemaster_entry broadcast_text broadcast_text_locale command conditions creature creature_addon creature_classlevelstats creature_equip_template creature_formations creature_loot_template creature_model_info creature_onkill_reputation creature_questender creature_questitem creature_queststarter creature_summon_groups creature_template creature_template_locale creature_template_addon creature_text creature_text_locale disables disenchant_loot_template event_scripts exploration_basexp fishing_loot_template gameobject gameobject_addon gameobject_loot_template gameobject_questender gameobject_questitem gameobject_queststarter gameobject_template gameobject_template_locale game_event game_event_arena_seasons game_event_battleground_holiday game_event_condition game_event_creature game_event_creature_quest game_event_gameobject game_event_gameobject_quest game_event_model_equip game_event_npcflag game_event_npc_vendor game_event_pool game_event_prerequisite game_event_quest_condition game_event_seasonal_questrelation game_tele game_weather gossip_menu gossip_menu_option graveyard_zone instance_encounters instance_template item_enchantment_template item_loot_template item_set_names item_template lfg_dungeon_rewards lfg_dungeon_template linked_respawn locales_gossip_menu_option locales_item locales_item_set_names locales_npc_text locales_page_text locales_points_of_interest locales_quest mail_level_reward mail_loot_template milling_loot_template npc_spellclick_spells npc_text npc_trainer npc_vendor outdoorpvp_template page_text pet_levelstats pet_name_generation pickpocketing_loot_template playercreateinfo playercreateinfo_action playercreateinfo_item playercreateinfo_skills playercreateinfo_spell_custom player_classlevelstats player_factionchange_achievement player_factionchange_items player_factionchange_quests player_factionchange_reputations player_factionchange_spells player_factionchange_titles player_levelstats player_xp_for_level points_of_interest pool_creature pool_gameobject pool_pool pool_quest pool_template prospecting_loot_template quest_poi quest_offer_reward quest_poi_points quest_request_items quest_template quest_template_addon reference_loot_template reputation_reward_rate reputation_spillover_template script_waypoint skill_discovery_template skill_extra_item_template skill_fishing_base_level skill_perfect_item_template skinning_loot_template smart_scripts spelldifficulty_dbc spell_area spell_bonus_data spell_custom_attr spell_dbc spell_enchant_proc_data spell_group spell_group_stack_rules spell_learn_spell spell_linked_spell spell_loot_template spell_pet_auras spell_proc spell_proc_event spell_ranks spell_required spell_scripts spell_script_names spell_target_position spell_threat transports trinity_string updates updates_include vehicle_accessory vehicle_template_accessory version warden_checks waypoints waypoint_data waypoint_scripts |
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'world'
Tabelle: 'quest_template'Table: quest_templateContains all basic definitions of available quests. Structure
Description of the fieldsIdQuest Id. Quest ID is the Primary Key for the Table. Each Quest ID must be unique! MethodAccepted values: 0, 1 or 2. If value = 0 then Quest is autocompleted (skip objectives/details). If value = 1 then Quest is disabled (not yet implemented in the core) If value = 2 them Quest is enabled and not autocomplete. LevelLevel of quest. Player recieves 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.
MinLevelMinimum level required to get the quest. MaxLevelMaximum level at which a character can get the quest. ZoneOrSortThis 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 TypeThese values are ID taken from QuestInfo.dbc SuggestedPlayersRecommended number of players to do the quest together. LimitTimeTime in seconds that the player has to complete this quest. RequiredClassesClasses required to get the quest. 0 means the quest is available for all classes. RequiredRacesRaces required to get the quest. 0 means the is available for all races. Field's value is a decimal value that must be transform to a 8 bits binary in order to be understandable. In binary form, each different bit represent a different race. They're asvorzeichenbehaftet as follow: RaceThese values are 2^ID taken from ChrRaces.dbc Examples 0,1791 = All Races 690 (2 + 16 + 32 + 128 + 512) = Horde Quest 1101 (1 + 4 + 8 + 64 + 1024) = Alliance Quest RequiredSkillIdSkill required to know to accept the quest. See SkillIne.dbc RequiredSkillPointsSkill points required to have in order to accept the quest. RepObjectiveFactionFaction ID for an objective to achieve a certain reputation value with. See Faction.dbc RepObjectiveValueReputation value that the player must achieve with the faction in RepObjectiveFaction as part of the quest objectives. RequiredMinRepFactionFaction ID for reputation requirement. See Faction.dbc RequiredMinRepValuePlayers must have this reputation or higher in order to receive the quest. RequiredMaxRepFactionThe Faction ID for the faction that controls the maximum reputation value that the player can have and still get the quest. See Faction.dbc RequiredMaxRepValueThe maximum reputation value that the player can have with a faction and still get the quest. If the player has more reputation than the value in this field, the quest will not be able to be taken anymore. RewardNextQuestIst hier eine Quest-ID eingetragen, wird diese Quest bei Abschluss automatisch zur Annahme angeboten. 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. RewXPId
According to the Level, the basic experience with index RewXPId is taken from QuestXP.dbc.
RewardOrRequiredMoneyMoney earned by completing the quest (if value > 0). Money quest requirement (if value < 0). RewardMoneyMaxLevelThe money a character at level 80 would get when they complete this quest. RewardSpellSpell 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. RewardSpellCastSpell 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 will not. NOTE: This field comes straight from the WDB and should not be changed. RewardMailTemplateIdIf the quest gives as a reward an item from a possible list of items, the ID here corresponds to the proper loot template in quest_mail_loot_template. According to the rules in that loot template, items "looted" will be sent by mail at the completion of the quest. RewardMailDelayHow 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 RewardHonorNumber 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. RewardHonorMultiplierMultiplies RewardHonor, so if value is 2, it will give double. WARNING:If this field is 1 and RewardHonor is 0, the quest will reward default honor kill value (124 honor at level 80)SourceItemIdItem's ID given by the quest giver at beginning of the quest. Items will be deleted when quest is abandoned. SourceItemCountAmount of items given. SourceSpellIdSpell casted on player when quest is started. Can be a buff or a learning spell. FlagsThis 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.
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. SpecialFlagsThis 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.
RewardTitleIdThe title the character will receive upon completion of the quest. See CharTitles.dbc RequiredPlayerKillsDisplays how much players you need to kill betd class=td class=a class=/td data-linked-resource-default-alias=fore completing the quest. RewardTalentsWill give X bonus talents to the player completed the quest. Leave'"0"for No Bonus Talent Points.'' RewardArenaPoints
RewardChoiceItemIdId of item available for reward choice. RewardChoiceItemCountWill choose how many items will be added for reward. E.g "RewardChoiceItemId" is the reward item and "RewardChoiceItemCount" is the count of how many items will be added as a reward. RewardItemIditem Id given for reward (no choice). RewardItemCountfield-no-description|46 RewardFactionIdFaction Id (from Faction.dbc) for which the quest give reputation points. RewardFactionValueIdThis field is used for reputation lookup in QuestFactionReward.dbc if 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. RewardFactionValueIdOverrideThis field is used to give reputation values not present in QuestFactionReward.dbc or to override them if 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). PointMapIdMapId of a quest point of interest (POI - Point Of Interest). POI will be shown on the map when quest is active. PointXX coordinate of quest POI. PointYY coordinate of quest POI. PointOptfield-no-description|53 LogTitleTitle of the quest. LogDescriptionObjectives of the quest. If empty, quest is an auto-complete quest that can be immediately finished without accepting it first. QuestDescriptionThe 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) AreaDescriptionfield-no-description|57 QuestCompletionfield-no-description|59 RequiredNpcOrGoValue > 0:required creature_template ID the player needs to kill/cast on in order to complete the quest. RequiredNpcOrGoCountThe number of times the creature or gameobject must be killed or casted upon. RequiredSourceItemIdItem ID that is needed indirectly by the quest. For example, the quests asks for item X but the only way to get item X is by activating item Y; however, item Y is also a quest item. Therefore you set item Y's ID in this field. This requirement will not appear in the quest text, it is just for the core to know when to drop a quest item that isn't in the RequiredItemId field but is still needed by the quest. RequiredSourceItemCountThe maximum number of copies of the item in RequiredSourceItemId that can be picked up (and dropped by the core). RequiredItemId |
Datenbank 'world'
Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
Stimme zählen für Account: