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: 'spell_area'The `spell_area` tableThis table is used to apply a specific spell aura to the player within an area in the game. When any player enters this area or somehow interacts with a quest, this aura will be handled accordingly. Some examples:
Structure
Description of the fieldsspellThe spell ID of the spell to be casted on the player. See Spell.dbc. areaThe area ID. Type ".gps" in-game and find the "Area:" number to use for this cell. Also see AreaTable.dbc. quest_startThe entry of the quest which the player must have in the state defined byquest_start_status. See quest_template.id. quest_endThe entry of the quest which the player must not have in the state defined by quest_end_status. See quest_template.id. Setting both quest_start and quest_end to the same value is useless. aura_spellIf set, this value (plus or minus aura spell ID from Spell.dbc) imposes additional condition. The value has the following effect:
racemaskThis ID is automatically called fromChrRaces.dbc. The bitmask is entered here. 0, 1791 = All Races 690 (2 + 16 + 32 + 128 + 512) = Horde Only 1101 (1 + 4 + 8 + 64 + 1024) = Alliance Only genderThe gender type this entry applies to. 0 = Male, 1 = Female, 2 = Any. autocastIf the spell should be automatically applied when the character enters the area. Also prevents the user from removing it. 0 = is not autocasted, 1 = is autocasted quest_start_status, quest_end_statusWithin quest_start_status, you can define the mask of quest status required for quest_start. Within quest_end_status, you can define the mask of quest status requiredfor quest_end. Example: Area257 is a cavern on Teldrassil. What we want is simple : When the player take the28725 quest, he have the aura in the cavern. When he finish the28727 quest, the aura disappear. You should have the spell92237 when entering the cavern IF : The start quest28725 is incomplete, complete or rewarded (2 | 8 | 64 =74) The end quest28727 is not taked (none), incomplete or complete BUT not rewarded (1| 2| 8 = 11) Here is the SQL for this example : INSERT INTO spell_area (spell, area, quest_start, quest_end, autocast, quest_start_status, quest_end_status) VALUES(92237,257,28725,28727, 1, 74, 11);
|
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: