Список таблиц

Материал из YTDB DataBase

(Различия между версиями)
Перейти к: навигация, поиск
 
(74 промежуточные версии не показаны)
Строка 5: Строка 5:
[M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы.  
[M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы.  
 +
[S] - Таблицы библиотеки скриптов. Данные таблицы заполняются разработчиками скриптов(ScriptDev2). Команда разработчиков YTDB не заполняет данные таблицы.
-
* [[achievement_criteria_data]]
 
-
* [[achievement_reward]]
+
* [[achievement_criteria_requirement]] [R]
 +
 
 +
* [[achievement_reward]] [R]
* [[areatrigger_involvedrelation]] [R]
* [[areatrigger_involvedrelation]] [R]
-
 
-
* [[areatrigger_scripts]]
 
* [[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_addon]]
+
* [[creature_battleground]] [R]
-
* [[creature_battleground]]
+
* [[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_scripts]]
+
* [[creature_movement_template]]
* [[creature_onkill_reputation]]
* [[creature_onkill_reputation]]
Строка 54: Строка 72:
* [[creature_questrelation]] [R]
* [[creature_questrelation]] [R]
-
* [[creature_respawn]] [M]
+
* [[creature_spawn_entry]]
* [[creature_template]]
* [[creature_template]]
Строка 60: Строка 78:
* [[creature_template_addon]]
* [[creature_template_addon]]
-
* [[db_script_string]]
+
* [[creature_template_classlevelstats]] [R]
-
* [[db_version]]
+
* [[creature_template_spells]]
-
* [[db_version_ytdb]] [для базы данных ytdb]
+
* [[custom_texts]] [S]
-
* [[disenchant_loot_template]] [R]
+
* [[dbscripts_on_creature_death]] [R]
-
* [[event_scripts]] [R]
+
* [[dbscripts_on_creature_movement]] [R]
-
* [[exploration_basexp]]
+
* [[dbscripts_on_event]] [R]
-
* [[fishing_loot_template]] [R]
+
* [[dbscripts_on_gossip]] [R]
-
* [[game_event]]
+
* [[dbscripts_on_go_template_use]] [R]
-
* [[game_event_creature]]
+
* [[dbscripts_on_go_use]] [R]
-
* [[game_event_creature_quest]]
+
* [[dbscripts_on_quest_end]] [R]
-
* [[game_event_gameobject]]
+
* [[dbscripts_on_quest_start]] [R]
-
* [[game_event_model_equip]]
+
* [[dbscripts_on_relay]] [R]
-
* [[game_graveyard_zone]] [R]
+
* [[dbscripts_on_spell]] [R]
-
* [[game_tele]]
+
* [[dbscript_random_templates]]
-
* [[game_weather]]
+
* [[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_respawn]] [M]
+
* [[gameobject_template]]
-
* [[gameobject_scripts]] [R]
+
* [[game_event]]
-
* [[gameobject_template]]
+
* [[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_scripts]] [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_creature]]
+
* [[locales_areatrigger_teleport]]
-
* [[locales_gameobject]]
+
* [[locales_creature]] [R]
-
* [[locales_gossip_menu_option]]
+
* [[locales_gameobject]] [R]
-
* [[locales_item]]
+
* [[locales_gossip_menu_option]] [R]
-
* [[locales_npc_text]]
+
* [[locales_item]] [R]
-
* [[locales_page_text]]
+
* [[locales_npc_text]] [R]
-
* [[locales_points_of_interest]]
+
* [[locales_page_text]] [R]
-
* [[locales_quest]]
+
* [[locales_points_of_interest]] [R]
-
* [[mail_level_reward]]
+
* [[locales_quest]] [R]
-
* [[mail_loot_template]] [R]
+
* [[locales_questgiver_greeting]] [R]
-
* [[mangos_string]]
+
* [[locales_trainer_greeting]] [R]
-
* [[milling_loot_template]]
+
* [[mail_level_reward]] [R]
-
* [[npc_gossip]]
+
* [[mail_loot_template]] [R]
-
* [[npc_option]]
+
* [[mangos_string]] [R]
 +
 
 +
* [[milling_loot_template]] [R]
 +
 
 +
* [[npc_gossip]] [R]
* [[npc_spellclick_spells]] [R]
* [[npc_spellclick_spells]] [R]
-
* [[npc_text]]
+
* [[npc_text]] [R]
-
* [[npc_trainer]]
+
* [[npc_text_broadcast_text]]
-
* [[npc_vendor]]
+
* [[npc_trainer]] [R]
-
* [[page_text]]
+
* [[npc_trainer_template]] [R]
-
* [[pet_levelstats]]
+
* [[npc_vendor]] [R]
-
* [[pet_name_generation]]
+
* [[npc_vendor_template]] [R]
-
* [[pickpocketing_loot_template]] [R]
+
* [[page_text]] [R]
-
* [[player_classlevelstats]] [M]
+
* [[pet_levelstats]]
-
* [[player_levelstats]] [M]
+
* [[pet_name_generation]] [M]
 +
 
 +
* [[pickpocketing_loot_template]] [R]
* [[playercreateinfo]] [M]
* [[playercreateinfo]] [M]
Строка 177: Строка 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]]
Строка 190: Строка 264:
* [[prospecting_loot_template]] [R]
* [[prospecting_loot_template]] [R]
-
* [[quest_end_scripts]] [R]
+
* [[questgiver_greeting]] [R]
-
* [[quest_start_scripts]] [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]
-
* [[spell_affect]] [R] [M]
+
* [[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]
Строка 221: Строка 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_scripts]] [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 не заполняет данные таблицы.


Источник — «http://wiki.ytdb.ru:89/index.php/%D0%A1%D0%BF%D0%B8%D1%81%D0%BE%D0%BA_%D1%82%D0%B0%D0%B1%D0%BB%D0%B8%D1%86»
Личные инструменты