Список таблиц
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
(75 промежуточных версий не показаны.) | |||
Строка 5: | Строка 5: | ||
[M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы. | [M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы. | ||
+ | [S] - Таблицы библиотеки скриптов. Данные таблицы заполняются разработчиками скриптов(ScriptDev2). Команда разработчиков YTDB не заполняет данные таблицы. | ||
- | |||
- | * [[achievement_reward]] | + | * [[achievement_criteria_requirement]] [R] |
+ | |||
+ | * [[achievement_reward]] [R] | ||
* [[areatrigger_involvedrelation]] [R] | * [[areatrigger_involvedrelation]] [R] | ||
- | |||
- | |||
* [[areatrigger_tavern]] [R] | * [[areatrigger_tavern]] [R] | ||
* [[areatrigger_teleport]] [R] | * [[areatrigger_teleport]] [R] | ||
+ | |||
+ | * [[area_group_template]] | ||
* [[battleground_events]] | * [[battleground_events]] | ||
Строка 23: | Строка 25: | ||
* [[battlemaster_entry]] | * [[battlemaster_entry]] | ||
+ | |||
+ | * [[broadcast_text]] | ||
+ | |||
+ | * [[broadcast_text_locale]] | ||
* [[command]] [R] [M] | * [[command]] [R] [M] | ||
+ | |||
+ | * [[conditions]] [R] | ||
* [[creature]] | * [[creature]] | ||
+ | |||
+ | * [[creature_addon]] | ||
* [[Event_AI|creature_ai_scripts]] [R] | * [[Event_AI|creature_ai_scripts]] [R] | ||
Строка 34: | Строка 44: | ||
* [[Eventai_texts|creature_ai_texts]] [R] | * [[Eventai_texts|creature_ai_texts]] [R] | ||
- | * [[ | + | * [[creature_battleground]] [R] |
- | * [[ | + | * [[creature_conditional_spawn]] |
+ | |||
+ | * [[creature_cooldowns]] | ||
* [[creature_equip_template]] | * [[creature_equip_template]] | ||
* [[creature_involvedrelation]] [R] | * [[creature_involvedrelation]] [R] | ||
+ | |||
+ | * [[creature_linking]] | ||
+ | |||
+ | * [[creature_linking_template]] | ||
* [[creature_loot_template]] [R] | * [[creature_loot_template]] [R] | ||
* [[creature_model_info]] | * [[creature_model_info]] | ||
+ | |||
+ | * [[creature_model_race]] | ||
* [[creature_movement]] | * [[creature_movement]] | ||
- | * [[ | + | * [[creature_movement_template]] |
* [[creature_onkill_reputation]] | * [[creature_onkill_reputation]] | ||
Строка 54: | Строка 72: | ||
* [[creature_questrelation]] [R] | * [[creature_questrelation]] [R] | ||
- | * [[ | + | * [[creature_spawn_entry]] |
* [[creature_template]] | * [[creature_template]] | ||
Строка 60: | Строка 78: | ||
* [[creature_template_addon]] | * [[creature_template_addon]] | ||
- | * [[ | + | * [[creature_template_classlevelstats]] [R] |
- | * [[ | + | * [[creature_template_spells]] |
- | * [[ | + | * [[custom_texts]] [S] |
- | * [[ | + | * [[dbscripts_on_creature_death]] [R] |
- | * [[ | + | * [[dbscripts_on_creature_movement]] [R] |
- | * [[ | + | * [[dbscripts_on_event]] [R] |
- | * [[ | + | * [[dbscripts_on_gossip]] [R] |
- | * [[ | + | * [[dbscripts_on_go_template_use]] [R] |
- | * [[ | + | * [[dbscripts_on_go_use]] [R] |
- | * [[ | + | * [[dbscripts_on_quest_end]] [R] |
- | * [[ | + | * [[dbscripts_on_quest_start]] [R] |
- | * [[ | + | * [[dbscripts_on_relay]] [R] |
- | * [[ | + | * [[dbscripts_on_spell]] [R] |
- | * [[ | + | * [[dbscript_random_templates]] |
- | * [[ | + | * [[dbscript_string]] [R] |
+ | |||
+ | * [[db_version]] | ||
+ | |||
+ | * [[db_version_ytdb]] [для базы данных ytdb] | ||
+ | |||
+ | * [[disenchant_loot_template]] [R] | ||
+ | |||
+ | * [[exploration_basexp]] | ||
+ | |||
+ | * [[fishing_loot_template]] [R] | ||
* [[gameobject]] | * [[gameobject]] | ||
- | * [[gameobject_battleground]] | + | * [[gameobject_addon]] |
+ | |||
+ | * [[gameobject_battleground]] [R] | ||
* [[gameobject_involvedrelation]] [R] | * [[gameobject_involvedrelation]] [R] | ||
Строка 100: | Строка 130: | ||
* [[gameobject_questrelation]] [R] | * [[gameobject_questrelation]] [R] | ||
- | * [[ | + | * [[gameobject_template]] |
- | * [[ | + | * [[game_event]] |
- | * [[ | + | * [[game_event_creature]] |
+ | |||
+ | * [[game_event_creature_data]] | ||
+ | |||
+ | * [[game_event_gameobject]] | ||
+ | |||
+ | * [[game_event_mail]] | ||
+ | |||
+ | * [[game_event_quest]] | ||
+ | |||
+ | * [[game_event_time]] | ||
+ | |||
+ | * [[game_graveyard_zone]] [R] | ||
+ | |||
+ | * [[game_tele]] [R] | ||
+ | |||
+ | * [[game_weather]] | ||
* [[gossip_menu]] [R] | * [[gossip_menu]] [R] | ||
Строка 110: | Строка 156: | ||
* [[gossip_menu_option]] [R] | * [[gossip_menu_option]] [R] | ||
- | * [[ | + | * [[gossip_text]] [S] |
+ | |||
+ | * [[instance_dungeon_encounter]] | ||
+ | |||
+ | * [[instance_encounters]] [M] | ||
* [[instance_template]] | * [[instance_template]] | ||
- | * [[item_enchantment_template]] | + | * [[item_convert]] [R] |
+ | |||
+ | * [[item_enchantment_template]] [R] | ||
+ | |||
+ | * [[item_expire_convert]] | ||
* [[item_loot_template]] [R] | * [[item_loot_template]] [R] | ||
Строка 122: | Строка 176: | ||
* [[item_template]] | * [[item_template]] | ||
- | * [[locales_achievement_reward]] | + | * [[locales_achievement_reward]] [R] |
+ | |||
+ | * [[locales_areatrigger_teleport]] | ||
+ | |||
+ | * [[locales_creature]] [R] | ||
+ | |||
+ | * [[locales_gameobject]] [R] | ||
+ | |||
+ | * [[locales_gossip_menu_option]] [R] | ||
- | * [[ | + | * [[locales_item]] [R] |
- | * [[ | + | * [[locales_npc_text]] [R] |
- | * [[ | + | * [[locales_page_text]] [R] |
- | * [[ | + | * [[locales_points_of_interest]] [R] |
- | * [[ | + | * [[locales_quest]] [R] |
- | * [[ | + | * [[locales_questgiver_greeting]] [R] |
- | * [[ | + | * [[locales_trainer_greeting]] [R] |
- | * [[ | + | * [[mail_level_reward]] [R] |
- | * [[ | + | * [[mail_loot_template]] [R] |
- | * [[ | + | * [[mangos_string]] [R] |
- | * [[ | + | * [[milling_loot_template]] [R] |
- | * [[ | + | * [[npc_gossip]] [R] |
* [[npc_spellclick_spells]] [R] | * [[npc_spellclick_spells]] [R] | ||
- | * [[npc_text]] | + | * [[npc_text]] [R] |
- | * [[ | + | * [[npc_text_broadcast_text]] |
- | * [[ | + | * [[npc_trainer]] [R] |
- | * [[ | + | * [[npc_trainer_template]] [R] |
- | * [[ | + | * [[npc_vendor]] [R] |
- | * [[ | + | * [[npc_vendor_template]] [R] |
- | * [[ | + | * [[page_text]] [R] |
- | * [[ | + | * [[pet_levelstats]] |
- | * [[ | + | * [[pet_name_generation]] [M] |
+ | |||
+ | * [[pickpocketing_loot_template]] [R] | ||
* [[playercreateinfo]] [M] | * [[playercreateinfo]] [M] | ||
Строка 173: | Строка 237: | ||
* [[playercreateinfo_item]] [M] | * [[playercreateinfo_item]] [M] | ||
+ | |||
+ | * [[playercreateinfo_skills]] [M] | ||
* [[playercreateinfo_spell]] [M] | * [[playercreateinfo_spell]] [M] | ||
+ | |||
+ | * [[player_classlevelstats]] [M] | ||
+ | |||
+ | * [[player_levelstats]] [M] | ||
+ | |||
+ | * [[player_xp_for_level]] | ||
+ | |||
+ | * [[points_of_interest]] [R] | ||
* [[pool_creature]] | * [[pool_creature]] | ||
+ | |||
+ | * [[pool_creature_template]] | ||
* [[pool_gameobject]] | * [[pool_gameobject]] | ||
+ | |||
+ | * [[pool_gameobject_template]] | ||
* [[pool_pool]] | * [[pool_pool]] | ||
Строка 186: | Строка 264: | ||
* [[prospecting_loot_template]] [R] | * [[prospecting_loot_template]] [R] | ||
- | * [[ | + | * [[questgiver_greeting]] [R] |
- | * [[ | + | * [[quest_poi]] [R] |
- | * [[ | + | * [[quest_poi_points]] [R] |
* [[quest_template]] [R] | * [[quest_template]] [R] | ||
* [[reference_loot_template]] [R] | * [[reference_loot_template]] [R] | ||
+ | |||
+ | * [[reference_loot_template_names]] | ||
+ | |||
+ | * [[reputation_reward_rate]] [R] | ||
+ | |||
+ | * [[reputation_spillover_template]] [R] | ||
* [[reserved_name]] [R] | * [[reserved_name]] [R] | ||
+ | |||
+ | * [[scripted_areatrigger]] [S] | ||
+ | |||
+ | * [[scripted_event_id]] [S] | ||
+ | |||
+ | * [[script_texts]] [S] | ||
+ | |||
+ | * [[script_waypoint]] [S] | ||
* [[skill_discovery_template]] [R] | * [[skill_discovery_template]] [R] | ||
- | * [[skill_extra_item_template]] | + | * [[skill_extra_item_template]] [R] |
- | * [[skill_fishing_base_level]] | + | * [[skill_fishing_base_level]] [R] |
- | * [[skinning_loot_template]] | + | * [[skinning_loot_template]] [R] |
- | * [[ | + | * [[spam_records]] |
* [[spell_area]] [R] | * [[spell_area]] [R] | ||
- | * [[spell_bonus_data]] [M] | + | * [[spell_bonus_data]] [R] [M] |
* [[spell_chain]] [R] [M] | * [[spell_chain]] [R] [M] | ||
+ | |||
+ | * [[spell_cone]] [M] | ||
* [[spell_elixir]] [R] [M] | * [[spell_elixir]] [R] [M] | ||
Строка 219: | Строка 313: | ||
* [[spell_loot_template]] [R] | * [[spell_loot_template]] [R] | ||
+ | |||
+ | * [[spell_pet_auras]] [R] | ||
* [[spell_proc_event]] [R] [M] | * [[spell_proc_event]] [R] [M] | ||
+ | |||
+ | * [[spell_proc_item_enchant]] [R] [M] | ||
* [[spell_script_target]] [R] | * [[spell_script_target]] [R] | ||
- | |||
- | |||
* [[spell_target_position]] [R] | * [[spell_target_position]] [R] | ||
+ | |||
+ | * [[spell_template]] | ||
* [[spell_threat]] [R] [M] | * [[spell_threat]] [R] [M] | ||
+ | |||
+ | * [[taxi_shortcuts]] | ||
+ | |||
+ | * [[trainer_greeting]] [R] | ||
* [[transports]] | * [[transports]] | ||
+ | |||
+ | * [[vehicle_accessory]] | ||
+ | |||
+ | * [[world_safe_locs]] | ||
+ | |||
+ | * [[world_template]] [S] |
Текущая версия на 07:07, 5 февраля 2020
Описания структур таблиц базы данных 'mangos'
[R] - Таблицы можно перегружать из игры, введя в консоли команду .reload имя_таблицы
[M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы.
[S] - Таблицы библиотеки скриптов. Данные таблицы заполняются разработчиками скриптов(ScriptDev2). Команда разработчиков YTDB не заполняет данные таблицы.
- command [R] [M]
- conditions [R]
- custom_texts [S]
- dbscript_string [R]
- db_version_ytdb [для базы данных ytdb]
- game_tele [R]
- gossip_menu [R]
- gossip_text [S]
- item_convert [R]
- locales_creature [R]
- locales_item [R]
- locales_npc_text [R]
- locales_quest [R]
- mangos_string [R]
- npc_gossip [R]
- npc_text [R]
- npc_trainer [R]
- npc_vendor [R]
- page_text [R]
- playercreateinfo [M]
- quest_poi [R]
- quest_poi_points [R]
- quest_template [R]
- reserved_name [R]
- script_texts [S]
- script_waypoint [S]
- spell_area [R]
- spell_bonus_data [R] [M]
- spell_chain [R] [M]
- spell_cone [M]
- spell_elixir [R] [M]
- spell_learn_spell [R] [M]
- spell_pet_auras [R]
- spell_proc_event [R] [M]
- spell_proc_item_enchant [R] [M]
- spell_threat [R] [M]
- trainer_greeting [R]
- world_template [S]