From beb713ec62ae6c23b5e81f404ed989f2935a7277 Mon Sep 17 00:00:00 2001 From: runningnak3d Date: Sat, 25 Dec 2010 05:28:50 -0700 Subject: SQL: Move old SQL updates in preperation for UP36 --HG-- branch : trunk rename : sql/updates/10383_world_version.sql => sql/updates/3.3.5a_old/10383_world_version.sql rename : sql/updates/10392_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/10392_world_spell_bonus_data.sql rename : sql/updates/10393_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10393_world_spell_proc_event.sql rename : sql/updates/10397_world_command.sql => sql/updates/3.3.5a_old/10397_world_command.sql rename : sql/updates/10402_world_spell_script_names.sql => sql/updates/3.3.5a_old/10402_world_spell_script_names.sql rename : sql/updates/10418_world_spell_script_names.sql => sql/updates/3.3.5a_old/10418_world_spell_script_names.sql rename : sql/updates/10419_world_spell_linked_spell.sql => sql/updates/3.3.5a_old/10419_world_spell_linked_spell.sql rename : sql/updates/10431_world_trinity_string.sql => sql/updates/3.3.5a_old/10431_world_trinity_string.sql rename : sql/updates/10436_world_script_texts.sql => sql/updates/3.3.5a_old/10436_world_script_texts.sql rename : sql/updates/10436_world_scriptname.sql => sql/updates/3.3.5a_old/10436_world_scriptname.sql rename : sql/updates/10453_world_creature_template.sql => sql/updates/3.3.5a_old/10453_world_creature_template.sql rename : sql/updates/10453_world_script_text.sql => sql/updates/3.3.5a_old/10453_world_script_text.sql rename : sql/updates/10460_world_command.sql => sql/updates/3.3.5a_old/10460_world_command.sql rename : sql/updates/10462_world_spell_script_names.sql => sql/updates/3.3.5a_old/10462_world_spell_script_names.sql rename : sql/updates/10468_world_script_texts.sql => sql/updates/3.3.5a_old/10468_world_script_texts.sql rename : sql/updates/10468_world_spell_script_names.sql => sql/updates/3.3.5a_old/10468_world_spell_script_names.sql rename : sql/updates/10470_world_command.sql => sql/updates/3.3.5a_old/10470_world_command.sql rename : sql/updates/10470_world_trinity_string.sql => sql/updates/3.3.5a_old/10470_world_trinity_string.sql rename : sql/updates/10475_characters_character_banned.sql => sql/updates/3.3.5a_old/10475_characters_character_banned.sql rename : sql/updates/10475_characters_creature_respawn.sql => sql/updates/3.3.5a_old/10475_characters_creature_respawn.sql rename : sql/updates/10475_characters_gameobject_respawn.sql => sql/updates/3.3.5a_old/10475_characters_gameobject_respawn.sql rename : sql/updates/10475_characters_reserved_name.sql => sql/updates/3.3.5a_old/10475_characters_reserved_name.sql rename : sql/updates/10490_world_scriptname.sql => sql/updates/3.3.5a_old/10490_world_scriptname.sql rename : sql/updates/10543_characters_group_member.sql => sql/updates/3.3.5a_old/10543_characters_group_member.sql rename : sql/updates/10545_world_script_texts.sql => sql/updates/3.3.5a_old/10545_world_script_texts.sql rename : sql/updates/10545_world_scriptname.sql => sql/updates/3.3.5a_old/10545_world_scriptname.sql rename : sql/updates/10548_characters_channel.sql => sql/updates/3.3.5a_old/10548_characters_channel.sql rename : sql/updates/10548_world_command.sql => sql/updates/3.3.5a_old/10548_world_command.sql rename : sql/updates/10548_world_trinity_string.sql => sql/updates/3.3.5a_old/10548_world_trinity_string.sql rename : sql/updates/10561_world_achievement_criteria_data.sql => sql/updates/3.3.5a_old/10561_world_achievement_criteria_data.sql rename : sql/updates/10561_world_scriptname.sql => sql/updates/3.3.5a_old/10561_world_scriptname.sql rename : sql/updates/10561_world_spell_linked_spell.sql => sql/updates/3.3.5a_old/10561_world_spell_linked_spell.sql rename : sql/updates/10561_world_spell_script_names.sql => sql/updates/3.3.5a_old/10561_world_spell_script_names.sql rename : sql/updates/10563_world_scriptname.sql => sql/updates/3.3.5a_old/10563_world_scriptname.sql rename : sql/updates/10570_world_disables.sql => sql/updates/3.3.5a_old/10570_world_disables.sql rename : sql/updates/10619_world_spell_script_names.sql => sql/updates/3.3.5a_old/10619_world_spell_script_names.sql rename : sql/updates/10623_world_spell_bonus_data.sql => sql/updates/3.3.5a_old/10623_world_spell_bonus_data.sql rename : sql/updates/10646_world_scriptname.sql => sql/updates/3.3.5a_old/10646_world_scriptname.sql rename : sql/updates/10654_characters_item_instance.sql => sql/updates/3.3.5a_old/10654_characters_item_instance.sql rename : sql/updates/10681_world_command.sql => sql/updates/3.3.5a_old/10681_world_command.sql rename : sql/updates/10733_world_spell_proc_event.sql => sql/updates/3.3.5a_old/10733_world_spell_proc_event.sql rename : sql/updates/10736_world_scriptname.sql => sql/updates/3.3.5a_old/10736_world_scriptname.sql rename : sql/updates/10741_characters_character_aura.sql => sql/updates/3.3.5a_old/10741_characters_character_aura.sql rename : sql/updates/10765_world_scriptname.sql => sql/updates/3.3.5a_old/10765_world_scriptname.sql rename : sql/updates/10765_world_spell_dbc.sql => sql/updates/3.3.5a_old/10765_world_spell_dbc.sql rename : sql/updates/10777_characters_creature_respawn.sql => sql/updates/3.3.5a_old/10777_characters_creature_respawn.sql rename : sql/updates/10777_characters_gameobject_respawn.sql => sql/updates/3.3.5a_old/10777_characters_gameobject_respawn.sql rename : sql/updates/10801_world_creature_linked_respawn.sql => sql/updates/3.3.5a_old/10801_world_creature_linked_respawn.sql rename : sql/updates/10806_world_scriptname.sql => sql/updates/3.3.5a_old/10806_world_scriptname.sql rename : sql/updates/10815_world_spell_script_names.sql => sql/updates/3.3.5a_old/10815_world_spell_script_names.sql --- sql/updates/10383_world_version.sql | 1 - sql/updates/10392_world_spell_bonus_data.sql | 3 -- sql/updates/10393_world_spell_proc_event.sql | 7 ---- sql/updates/10397_world_command.sql | 48 ---------------------- sql/updates/10402_world_spell_script_names.sql | 3 -- sql/updates/10418_world_spell_script_names.sql | 3 -- sql/updates/10419_world_spell_linked_spell.sql | 4 -- sql/updates/10431_world_trinity_string.sql | 4 -- sql/updates/10436_world_script_texts.sql | 14 ------- sql/updates/10436_world_scriptname.sql | 2 - sql/updates/10453_world_creature_template.sql | 6 --- sql/updates/10453_world_script_text.sql | 9 ---- sql/updates/10460_world_command.sql | 36 ---------------- sql/updates/10462_world_spell_script_names.sql | 2 - sql/updates/10468_world_script_texts.sql | 1 - sql/updates/10468_world_spell_script_names.sql | 15 ------- sql/updates/10470_world_command.sql | 3 -- sql/updates/10470_world_trinity_string.sql | 4 -- sql/updates/10475_characters_character_banned.sql | 1 - sql/updates/10475_characters_creature_respawn.sql | 9 ---- .../10475_characters_gameobject_respawn.sql | 9 ---- sql/updates/10475_characters_reserved_name.sql | 6 --- sql/updates/10490_world_scriptname.sql | 2 - sql/updates/10543_characters_group_member.sql | 6 --- sql/updates/10545_world_script_texts.sql | 6 --- sql/updates/10545_world_scriptname.sql | 1 - sql/updates/10548_characters_channel.sql | 9 ---- sql/updates/10548_world_command.sql | 5 --- sql/updates/10548_world_trinity_string.sql | 4 -- .../10561_world_achievement_criteria_data.sql | 6 --- sql/updates/10561_world_scriptname.sql | 1 - sql/updates/10561_world_spell_linked_spell.sql | 21 ---------- sql/updates/10561_world_spell_script_names.sql | 14 ------- sql/updates/10563_world_scriptname.sql | 1 - sql/updates/10570_world_disables.sql | 3 -- sql/updates/10619_world_spell_script_names.sql | 7 ---- sql/updates/10623_world_spell_bonus_data.sql | 3 -- sql/updates/10646_world_scriptname.sql | 1 - sql/updates/10654_characters_item_instance.sql | 28 ------------- sql/updates/10681_world_command.sql | 11 ----- sql/updates/10733_world_spell_proc_event.sql | 4 -- sql/updates/10736_world_scriptname.sql | 1 - sql/updates/10741_characters_character_aura.sql | 4 -- sql/updates/10765_world_scriptname.sql | 1 - sql/updates/10765_world_spell_dbc.sql | 2 - sql/updates/10777_characters_creature_respawn.sql | 1 - .../10777_characters_gameobject_respawn.sql | 1 - .../10801_world_creature_linked_respawn.sql | 5 --- sql/updates/10806_world_scriptname.sql | 1 - sql/updates/10815_world_spell_script_names.sql | 3 -- sql/updates/3.3.5a_old/10383_world_version.sql | 1 + .../3.3.5a_old/10392_world_spell_bonus_data.sql | 3 ++ .../3.3.5a_old/10393_world_spell_proc_event.sql | 7 ++++ sql/updates/3.3.5a_old/10397_world_command.sql | 48 ++++++++++++++++++++++ .../3.3.5a_old/10402_world_spell_script_names.sql | 3 ++ .../3.3.5a_old/10418_world_spell_script_names.sql | 3 ++ .../3.3.5a_old/10419_world_spell_linked_spell.sql | 4 ++ .../3.3.5a_old/10431_world_trinity_string.sql | 4 ++ .../3.3.5a_old/10436_world_script_texts.sql | 14 +++++++ sql/updates/3.3.5a_old/10436_world_scriptname.sql | 2 + .../3.3.5a_old/10453_world_creature_template.sql | 6 +++ sql/updates/3.3.5a_old/10453_world_script_text.sql | 9 ++++ sql/updates/3.3.5a_old/10460_world_command.sql | 36 ++++++++++++++++ .../3.3.5a_old/10462_world_spell_script_names.sql | 2 + .../3.3.5a_old/10468_world_script_texts.sql | 1 + .../3.3.5a_old/10468_world_spell_script_names.sql | 15 +++++++ sql/updates/3.3.5a_old/10470_world_command.sql | 3 ++ .../3.3.5a_old/10470_world_trinity_string.sql | 4 ++ .../10475_characters_character_banned.sql | 1 + .../10475_characters_creature_respawn.sql | 9 ++++ .../10475_characters_gameobject_respawn.sql | 9 ++++ .../3.3.5a_old/10475_characters_reserved_name.sql | 6 +++ sql/updates/3.3.5a_old/10490_world_scriptname.sql | 2 + .../3.3.5a_old/10543_characters_group_member.sql | 6 +++ .../3.3.5a_old/10545_world_script_texts.sql | 6 +++ sql/updates/3.3.5a_old/10545_world_scriptname.sql | 1 + .../3.3.5a_old/10548_characters_channel.sql | 9 ++++ sql/updates/3.3.5a_old/10548_world_command.sql | 5 +++ .../3.3.5a_old/10548_world_trinity_string.sql | 4 ++ .../10561_world_achievement_criteria_data.sql | 6 +++ sql/updates/3.3.5a_old/10561_world_scriptname.sql | 1 + .../3.3.5a_old/10561_world_spell_linked_spell.sql | 21 ++++++++++ .../3.3.5a_old/10561_world_spell_script_names.sql | 14 +++++++ sql/updates/3.3.5a_old/10563_world_scriptname.sql | 1 + sql/updates/3.3.5a_old/10570_world_disables.sql | 3 ++ .../3.3.5a_old/10619_world_spell_script_names.sql | 7 ++++ .../3.3.5a_old/10623_world_spell_bonus_data.sql | 3 ++ sql/updates/3.3.5a_old/10646_world_scriptname.sql | 1 + .../3.3.5a_old/10654_characters_item_instance.sql | 28 +++++++++++++ sql/updates/3.3.5a_old/10681_world_command.sql | 11 +++++ .../3.3.5a_old/10733_world_spell_proc_event.sql | 4 ++ sql/updates/3.3.5a_old/10736_world_scriptname.sql | 1 + .../3.3.5a_old/10741_characters_character_aura.sql | 4 ++ sql/updates/3.3.5a_old/10765_world_scriptname.sql | 1 + sql/updates/3.3.5a_old/10765_world_spell_dbc.sql | 2 + .../10777_characters_creature_respawn.sql | 1 + .../10777_characters_gameobject_respawn.sql | 1 + .../10801_world_creature_linked_respawn.sql | 5 +++ sql/updates/3.3.5a_old/10806_world_scriptname.sql | 1 + .../3.3.5a_old/10815_world_spell_script_names.sql | 3 ++ 100 files changed, 342 insertions(+), 342 deletions(-) delete mode 100644 sql/updates/10383_world_version.sql delete mode 100644 sql/updates/10392_world_spell_bonus_data.sql delete mode 100644 sql/updates/10393_world_spell_proc_event.sql delete mode 100644 sql/updates/10397_world_command.sql delete mode 100644 sql/updates/10402_world_spell_script_names.sql delete mode 100644 sql/updates/10418_world_spell_script_names.sql delete mode 100644 sql/updates/10419_world_spell_linked_spell.sql delete mode 100644 sql/updates/10431_world_trinity_string.sql delete mode 100644 sql/updates/10436_world_script_texts.sql delete mode 100644 sql/updates/10436_world_scriptname.sql delete mode 100644 sql/updates/10453_world_creature_template.sql delete mode 100644 sql/updates/10453_world_script_text.sql delete mode 100644 sql/updates/10460_world_command.sql delete mode 100644 sql/updates/10462_world_spell_script_names.sql delete mode 100644 sql/updates/10468_world_script_texts.sql delete mode 100644 sql/updates/10468_world_spell_script_names.sql delete mode 100644 sql/updates/10470_world_command.sql delete mode 100644 sql/updates/10470_world_trinity_string.sql delete mode 100644 sql/updates/10475_characters_character_banned.sql delete mode 100644 sql/updates/10475_characters_creature_respawn.sql delete mode 100644 sql/updates/10475_characters_gameobject_respawn.sql delete mode 100644 sql/updates/10475_characters_reserved_name.sql delete mode 100644 sql/updates/10490_world_scriptname.sql delete mode 100644 sql/updates/10543_characters_group_member.sql delete mode 100644 sql/updates/10545_world_script_texts.sql delete mode 100644 sql/updates/10545_world_scriptname.sql delete mode 100644 sql/updates/10548_characters_channel.sql delete mode 100644 sql/updates/10548_world_command.sql delete mode 100644 sql/updates/10548_world_trinity_string.sql delete mode 100644 sql/updates/10561_world_achievement_criteria_data.sql delete mode 100644 sql/updates/10561_world_scriptname.sql delete mode 100644 sql/updates/10561_world_spell_linked_spell.sql delete mode 100644 sql/updates/10561_world_spell_script_names.sql delete mode 100644 sql/updates/10563_world_scriptname.sql delete mode 100644 sql/updates/10570_world_disables.sql delete mode 100644 sql/updates/10619_world_spell_script_names.sql delete mode 100644 sql/updates/10623_world_spell_bonus_data.sql delete mode 100644 sql/updates/10646_world_scriptname.sql delete mode 100644 sql/updates/10654_characters_item_instance.sql delete mode 100644 sql/updates/10681_world_command.sql delete mode 100644 sql/updates/10733_world_spell_proc_event.sql delete mode 100644 sql/updates/10736_world_scriptname.sql delete mode 100644 sql/updates/10741_characters_character_aura.sql delete mode 100644 sql/updates/10765_world_scriptname.sql delete mode 100644 sql/updates/10765_world_spell_dbc.sql delete mode 100644 sql/updates/10777_characters_creature_respawn.sql delete mode 100644 sql/updates/10777_characters_gameobject_respawn.sql delete mode 100644 sql/updates/10801_world_creature_linked_respawn.sql delete mode 100644 sql/updates/10806_world_scriptname.sql delete mode 100644 sql/updates/10815_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10383_world_version.sql create mode 100644 sql/updates/3.3.5a_old/10392_world_spell_bonus_data.sql create mode 100644 sql/updates/3.3.5a_old/10393_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.5a_old/10397_world_command.sql create mode 100644 sql/updates/3.3.5a_old/10402_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10418_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10419_world_spell_linked_spell.sql create mode 100644 sql/updates/3.3.5a_old/10431_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/10436_world_script_texts.sql create mode 100644 sql/updates/3.3.5a_old/10436_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10453_world_creature_template.sql create mode 100644 sql/updates/3.3.5a_old/10453_world_script_text.sql create mode 100644 sql/updates/3.3.5a_old/10460_world_command.sql create mode 100644 sql/updates/3.3.5a_old/10462_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10468_world_script_texts.sql create mode 100644 sql/updates/3.3.5a_old/10468_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10470_world_command.sql create mode 100644 sql/updates/3.3.5a_old/10470_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/10475_characters_character_banned.sql create mode 100644 sql/updates/3.3.5a_old/10475_characters_creature_respawn.sql create mode 100644 sql/updates/3.3.5a_old/10475_characters_gameobject_respawn.sql create mode 100644 sql/updates/3.3.5a_old/10475_characters_reserved_name.sql create mode 100644 sql/updates/3.3.5a_old/10490_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10543_characters_group_member.sql create mode 100644 sql/updates/3.3.5a_old/10545_world_script_texts.sql create mode 100644 sql/updates/3.3.5a_old/10545_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10548_characters_channel.sql create mode 100644 sql/updates/3.3.5a_old/10548_world_command.sql create mode 100644 sql/updates/3.3.5a_old/10548_world_trinity_string.sql create mode 100644 sql/updates/3.3.5a_old/10561_world_achievement_criteria_data.sql create mode 100644 sql/updates/3.3.5a_old/10561_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10561_world_spell_linked_spell.sql create mode 100644 sql/updates/3.3.5a_old/10561_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10563_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10570_world_disables.sql create mode 100644 sql/updates/3.3.5a_old/10619_world_spell_script_names.sql create mode 100644 sql/updates/3.3.5a_old/10623_world_spell_bonus_data.sql create mode 100644 sql/updates/3.3.5a_old/10646_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10654_characters_item_instance.sql create mode 100644 sql/updates/3.3.5a_old/10681_world_command.sql create mode 100644 sql/updates/3.3.5a_old/10733_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.5a_old/10736_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10741_characters_character_aura.sql create mode 100644 sql/updates/3.3.5a_old/10765_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10765_world_spell_dbc.sql create mode 100644 sql/updates/3.3.5a_old/10777_characters_creature_respawn.sql create mode 100644 sql/updates/3.3.5a_old/10777_characters_gameobject_respawn.sql create mode 100644 sql/updates/3.3.5a_old/10801_world_creature_linked_respawn.sql create mode 100644 sql/updates/3.3.5a_old/10806_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/10815_world_spell_script_names.sql (limited to 'sql/updates') diff --git a/sql/updates/10383_world_version.sql b/sql/updates/10383_world_version.sql deleted file mode 100644 index 301480b3a2f..00000000000 --- a/sql/updates/10383_world_version.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `version` CHANGE `core_revision` `core_revision` varchar(120) DEFAULT NULL; diff --git a/sql/updates/10392_world_spell_bonus_data.sql b/sql/updates/10392_world_spell_bonus_data.sql deleted file mode 100644 index 3a808bddf13..00000000000 --- a/sql/updates/10392_world_spell_bonus_data.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_bonus_data` WHERE `entry` = 53600; -INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES -(53600, 0, 0, 0, 0 ,'Paladin - Shield of Righteousness'); \ No newline at end of file diff --git a/sql/updates/10393_world_spell_proc_event.sql b/sql/updates/10393_world_spell_proc_event.sql deleted file mode 100644 index 11e9f7a184b..00000000000 --- a/sql/updates/10393_world_spell_proc_event.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (12281, 12812, 12813, 12814, 12815); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -( 12281, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 1) -( 12812, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 2) -( 12813, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 3) -( 12814, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 4) -( 12815, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6); -- Sword Specialization (Rank 5) \ No newline at end of file diff --git a/sql/updates/10397_world_command.sql b/sql/updates/10397_world_command.sql deleted file mode 100644 index bc72fa2841d..00000000000 --- a/sql/updates/10397_world_command.sql +++ /dev/null @@ -1,48 +0,0 @@ --- Rename changed learn commands -DELETE FROM `command` WHERE `name` LIKE 'learn%'; -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('learn',3,'Syntax: .learn #spell [all]\r\n\r\nSelected character learn a spell of id #spell. If ''all'' provided then all ranks learned.'), -('learn all',3,'Syntax: .learn all\r\n\r\nLearn all big set different spell maybe useful for Administaror.'), -('learn all crafts',2,'Syntax: .learn crafts\r\n\r\nLearn all professions and recipes.'), -('learn all default',1,'Syntax: .learn all default [$playername]\r\n\r\nLearn for selected/$playername player all default spells for his race/class and spells rewarded by completed quests.'), -('learn all gm',2,'Syntax: .learn all gm\r\n\r\nLearn all default spells for Game Masters.'), -('learn all lang',1,'Syntax: .learn all lang\r\n\r\nLearn all languages'), -('learn all my class',3,'Syntax: .learn all my class\r\n\r\nLearn all spells and talents available for his class.'), -('learn all my pettalents',3,'Syntax: .learn all my pettalents\r\n\r\nLearn all talents for your pet available for his creature type (only for hunter pets).'), -('learn all my spells',3,'Syntax: .learn all my spells\r\n\r\nLearn all spells (except talents and spells with first rank learned as talent) available for his class.'), -('learn all my talents',3,'Syntax: .learn all my talents\r\n\r\nLearn all talents (and spells with first rank learned as talent) available for his class.'), -('learn all recipes',2,'Syntax: .learn all recipes [$profession]\r\rLearns all recipes of specified profession and sets skill level to max.\rExample: .learn all recipes enchanting'); - --- Rename changed npc commands -DELETE FROM `command` WHERE `name` LIKE 'npc%'; -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('npc',1,'Syntax: .npc $subcommand\nType .npc to see the list of possible subcommands or .help npc $subcommand to see info on subcommands'), -('npc add',2,'Syntax: .npc add #creatureid\r\n\r\nSpawn a creature by the given template id of #creatureid.'), -('npc add formation',1,'Syntax: .npc add formation $leader\nAdd selected creature to a leader''s formation.'), -('npc add item',2,'Syntax: .npc add item #itemId <#maxcount><#incrtime><#extendedcost>r\r\n\r\nAdd item #itemid to item list of selected vendor. Also optionally set max count item in vendor item list and time to item count restoring and items ExtendedCost.'), -('npc add move',2,'Syntax: .npc add move #creature_guid [#waittime]\r\n\r\nAdd your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.'), -('npc set allowmove',3,'Syntax: .npc set allowmove\r\n\r\nEnable or disable movement creatures in world. Not implemented.'), -('npc set entry',3,'Syntax: .npc set entry $entry\nSwitch selected creature with another entry from creature_template. - New creature.id value not saved to DB.'), -('npc set level',2,'Syntax: .npc set level #level\r\n\r\nChange the level of the selected creature to #level.\r\n\r\n#level may range from 1 to (CONFIG_MAX_PLAYER_LEVEL) + 3.'), -('npc delete',2,'Syntax: .npc delete [#guid]\r\n\r\nDelete creature with guid #guid (or the selected if no guid is provided)'), -('npc delete item',2,'Syntax: .npc delete item #itemId\r\n\r\nRemove item #itemid from item list of selected vendor.'), -('npc set factionid',2,'Syntax: .npc set factionid #factionid\r\n\r\nSet the faction of the selected creature to #factionid.'), -('npc set flag',2,'Syntax: .npc set flag #npcflag\r\n\r\nSet the NPC flags of creature template of the selected creature and selected creature to #npcflag. NPC flags will applied to all creatures of selected creature template after server restart or grid unload/load.'), -('npc follow',2,'Syntax: .npc follow start\r\n\r\nSelected creature start follow you until death/fight/etc.'), -('npc follow stop',2,'Syntax: .npc follow stop\r\n\r\nSelected creature (non pet) stop follow you.'), -('npc info',3,'Syntax: .npc info\r\n\r\nDisplay a list of details for the selected creature.\r\n\r\nThe list includes:\r\n- GUID, Faction, NPC flags, Entry ID, Model ID,\r\n- Level,\r\n- Health (current/maximum),\r\n\r\n- Field flags, dynamic flags, faction template, \r\n- Position information,\r\n- and the creature type, e.g. if the creature is a vendor.'), -('npc move',2,'Syntax: .npc move [#creature_guid]\r\n\r\nMove the targeted creature spawn point to your coordinates.'), -('npc playemote',3,'Syntax: .npc playemote #emoteid\r\n\r\nMake the selected creature emote with an emote of id #emoteid.'), -('npc say',1,'Syntax: .npc say $message\nMake selected creature say specified message.'), -('npc set deathstate',2,'Syntax: .npc set deathstate on/off\r\n\r\nSet default death state (dead/alive) for npc at spawn.'), -('npc set link',2,'Syntax: .npc set link $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'), -('npc set model',2,'Syntax: .npc set model #displayid\r\n\r\nChange the model id of the selected creature to #displayid.'), -('npc set movetype',2,'Syntax: .npc set movetype [#creature_guid] stay/random/way [NODEL]\r\n\r\nSet for creature pointed by #creature_guid (or selected if #creature_guid not provided) movement type and move it to respawn position (if creature alive). Any existing waypoints for creature will be removed from the database if you do not use NODEL. If the creature is dead then movement type will applied at creature respawn.\r\nMake sure you use NODEL, if you want to keep the waypoints.'), -('npc set phase',2,'Syntax: .npc set phase #phasemask\r\n\r\nSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB and persistent. In pet case change active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..'), -('npc set spawndist',2,'Syntax: .npc set spawndist #dist\r\n\r\nAdjust spawndistance of selected creature to dist.'), -('npc set spawntime',2,'Syntax: .npc set spawntime #time \r\n\r\nAdjust spawntime of selected creature to time.'), -('npc add temp',2,'Syntax: .npc add temp\r\n\r\nAdds temporary NPC, not saved to database.'), -('npc textemote',1,'Syntax: .npc textemote #emoteid\r\n\r\nMake the selected creature to do textemote with an emote of id #emoteid.'), -('npc whisper',1,'Syntax: .npc whisper #playerguid #text\r\nMake the selected npc whisper #text to #playerguid.'), -('npc yell',1,'Syntax: .npc yell $message\nMake selected creature yell specified message.'); - diff --git a/sql/updates/10402_world_spell_script_names.sql b/sql/updates/10402_world_spell_script_names.sql deleted file mode 100644 index 1f70a1d018f..00000000000 --- a/sql/updates/10402_world_spell_script_names.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=46221 AND `ScriptName`='spell_gen_animal_blood'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(46221,'spell_gen_animal_blood'); diff --git a/sql/updates/10418_world_spell_script_names.sql b/sql/updates/10418_world_spell_script_names.sql deleted file mode 100644 index 321fda46450..00000000000 --- a/sql/updates/10418_world_spell_script_names.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM spell_script_names WHERE spell_id = 10848 AND `ScriptName`='spell_gen_shroud_of_death'; -INSERT INTO spell_script_names (`spell_id`,`ScriptName`) VALUES -(10848, 'spell_gen_shroud_of_death'); diff --git a/sql/updates/10419_world_spell_linked_spell.sql b/sql/updates/10419_world_spell_linked_spell.sql deleted file mode 100644 index db29bbecde3..00000000000 --- a/sql/updates/10419_world_spell_linked_spell.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (58984); -INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES -(58984, 59646, 0, 'Shadowmeld: Sanctuary'), -(58984, 62196, 0, 'Shadowmeld: Force deselect'); diff --git a/sql/updates/10431_world_trinity_string.sql b/sql/updates/10431_world_trinity_string.sql deleted file mode 100644 index 227fb43fd4d..00000000000 --- a/sql/updates/10431_world_trinity_string.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `trinity_string` WHERE `entry` IN (1134, 1135); -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(1134, 'Sending tickets is allowed.'), -(1135, 'Sending tickets is not allowed.'); diff --git a/sql/updates/10436_world_script_texts.sql b/sql/updates/10436_world_script_texts.sql deleted file mode 100644 index 4bf12bb70b5..00000000000 --- a/sql/updates/10436_world_script_texts.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Quest Discrediting the Deserters (11133) --- Script Texts -DELETE FROM `script_texts` WHERE `entry` BETWEEN (-1603510) AND (-1603502); -INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) -VALUES -(4979,-1603502,'Hey, thanks.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0, 'Theramore Guard - SAY_QUEST1'), -(4979,-1603503,'...receive 50 percent off deserter undergarments? What is this garbage?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST2'), -(4979,-1603504,'...to establish a fund for the purchase of hair gel? I like my hair the way it is, thanks!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST3'), -(4979,-1603505,'...the deserters seek a Theramore where citizens will be free to juggle at all hours of the day? What is this nonsense?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST4'), -(4979,-1603506,'...to establish the chicken as the official symbol of Theramore?! These guys are nuts!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST5'), -(4979,-1603507,'...as a deserter, you\'ll enjoy activities like tethered swimming and dog grooming? How ridiculous!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST6'), -(4979,-1603508,'This... this is a joke, right?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST7'), -(4979,-1603509,'I\'d never join anything like this. Better keep this, though. It\'ll come in handy in the privy...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST8'), -(4979,-1603510,'What a bunch of lunatics! You actually believe this stuff?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST9'); diff --git a/sql/updates/10436_world_scriptname.sql b/sql/updates/10436_world_scriptname.sql deleted file mode 100644 index c824b206974..00000000000 --- a/sql/updates/10436_world_scriptname.sql +++ /dev/null @@ -1,2 +0,0 @@ --- ScriptName -UPDATE `creature_template` SET `ScriptName`='npc_theramore_guard' WHERE `entry`=4979; -- Theramore Guard diff --git a/sql/updates/10453_world_creature_template.sql b/sql/updates/10453_world_creature_template.sql deleted file mode 100644 index 1c869eb10ef..00000000000 --- a/sql/updates/10453_world_creature_template.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Quest ...Or Maybe We Don't (12138, 12198) -UPDATE `creature_template` SET `ScriptName`='npc_lightning_sentry' WHERE `entry`=26407; -- Lightning Sentry - --- Quest Smoke 'Em Out (12323, 12324) -UPDATE `creature_template` SET `ScriptName`='npc_venture_co_straggler',`AIName`='' WHERE `entry`=27570; - diff --git a/sql/updates/10453_world_script_text.sql b/sql/updates/10453_world_script_text.sql deleted file mode 100644 index f107787e051..00000000000 --- a/sql/updates/10453_world_script_text.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Quest Smoke Em Out -DELETE FROM `script_texts` WHERE `entry` BETWEEN (-1603539) AND (-1603535); -INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES - (27570,-1603535,'We\'re all gonna die!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say1'), - (27570,-1603536,'Gotta get out of here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say2'), - (27570,-1603537,'No way I\'m stickin\' around!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say3'), - (27570,-1603538,'Forget this! I\'m going home!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say4'), - (27570,-1603539,'I didn\'t sign up for this!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say5'); - diff --git a/sql/updates/10460_world_command.sql b/sql/updates/10460_world_command.sql deleted file mode 100644 index 83343f0fff0..00000000000 --- a/sql/updates/10460_world_command.sql +++ /dev/null @@ -1,36 +0,0 @@ --- Rename changed gobject commands -DELETE FROM `command` WHERE `name` IN ('gobject setphase','gobject tempadd','gobject set phase','gobject add temp'); -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('gobject set phase',2,'Syntax: .gobject set phase #guid #phasemask\r\n\r\nGameobject with DB guid #guid phasemask changed to #phasemask with related world vision update for players. Gameobject state saved to DB and persistent.'), -('gobject add temp',2,'Adds a temporary gameobject that is not saved to DB.'); - --- Rename changed honor commands -DELETE FROM `command` WHERE `name` IN ('honor addkill','honor add kill'); -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('honor add kill',2,'Syntax: .honor add kill\r\n\r\nAdd the targeted unit as one of your pvp kills today (you only get honor if it''s a racial leader or a player)'); - --- Add wp add command -DELETE FROM `command` WHERE `name` IN ('wp add','wp addwp'); -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('wp add',2,'Syntax: .wp add\r\n\r\nAdd a waypoint for the selected creature at your current position.'); - --- Rename changed loadpath command and move it to wp reload -DELETE FROM `command` WHERE `name` IN ('loadpath','wp reload'); -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('wp reload',3,'Syntax: .wp reload $pathid\nLoad path changes ingame - IMPORTANT: must be applied first for new paths before .wp load #pathid '); - -DELETE FROM `command` WHERE `name` LIKE 'reload all%'; -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.'), -('reload all gossips',3,'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, npc_gossip, points_of_interest tables.'), -('reload all item',3,'Syntax: .reload all item\nReload page_text, item_enchantment_table tables.'), -('reload all locales',3,'Syntax: .reload all locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'), -('reload all loot',3,'Syntax: .reload all loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.'), -('reload all npc',3,'Syntax: .reload all npc\nReload npc_gossip, npc_option, npc_trainer, npc vendor, points of interest tables.'), -('reload all quest',3,'Syntax: .reload all quest\r\n\r\nReload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.'), -('reload all scripts',3,'Syntax: .reload all scripts\nReload gameobject_scripts, event_scripts, quest_end_scripts, quest_start_scripts, spell_scripts, db_script_string, waypoint_scripts tables.'), -('reload all spell',3,'Syntax: .reload all spell\r\n\r\nReload all `spell_*` tables with reload support added and that can be _safe_ reloaded.'); - -DELETE FROM `command` WHERE `name` IN ('titles setmask','titles set mask'); -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('titles set mask',2,'Syntax: .titles set mask #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'); diff --git a/sql/updates/10462_world_spell_script_names.sql b/sql/updates/10462_world_spell_script_names.sql deleted file mode 100644 index c4439817178..00000000000 --- a/sql/updates/10462_world_spell_script_names.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=6474; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (6474, 'spell_sha_earthbind_totem'); diff --git a/sql/updates/10468_world_script_texts.sql b/sql/updates/10468_world_script_texts.sql deleted file mode 100644 index bb3ed4d7299..00000000000 --- a/sql/updates/10468_world_script_texts.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `script_texts` WHERE `entry` BETWEEN -1631139 AND -1631000; diff --git a/sql/updates/10468_world_spell_script_names.sql b/sql/updates/10468_world_spell_script_names.sql deleted file mode 100644 index 89f6b5b79e1..00000000000 --- a/sql/updates/10468_world_spell_script_names.sql +++ /dev/null @@ -1,15 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (69057,70826,72088,72089) AND `ScriptName`='spell_marrowgar_bone_spike_graveyard'; -DELETE FROM `spell_script_names` WHERE `spell_id` IN (70903,72498,72499,72500,71236,72495,72496,72497) AND `ScriptName`='spell_cultist_dark_martyrdrom'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(69057,'spell_marrowgar_bone_spike_graveyard'), -(70826,'spell_marrowgar_bone_spike_graveyard'), -(72088,'spell_marrowgar_bone_spike_graveyard'), -(72089,'spell_marrowgar_bone_spike_graveyard'), -(70903,'spell_cultist_dark_martyrdrom'), -(72498,'spell_cultist_dark_martyrdrom'), -(72499,'spell_cultist_dark_martyrdrom'), -(72500,'spell_cultist_dark_martyrdrom'), -(71236,'spell_cultist_dark_martyrdrom'), -(72495,'spell_cultist_dark_martyrdrom'), -(72496,'spell_cultist_dark_martyrdrom'), -(72497,'spell_cultist_dark_martyrdrom'); diff --git a/sql/updates/10470_world_command.sql b/sql/updates/10470_world_command.sql deleted file mode 100644 index 56f665e9104..00000000000 --- a/sql/updates/10470_world_command.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `command` WHERE `name` LIKE 'server togglequerylog'; -INSERT INTO `command` (`name`,`security`,`help`) VALUES -('server togglequerylog',4,'Toggle SQL driver query logging.'); diff --git a/sql/updates/10470_world_trinity_string.sql b/sql/updates/10470_world_trinity_string.sql deleted file mode 100644 index c6cac6daaa0..00000000000 --- a/sql/updates/10470_world_trinity_string.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `trinity_string` WHERE `entry` IN (1027, 1028); -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(1027, 'SQL driver query logging enabled.'), -(1028, 'SQL driver query logging disabled.'); \ No newline at end of file diff --git a/sql/updates/10475_characters_character_banned.sql b/sql/updates/10475_characters_character_banned.sql deleted file mode 100644 index 1d4789a4f33..00000000000 --- a/sql/updates/10475_characters_character_banned.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE character_banned ENGINE = InnoDB; diff --git a/sql/updates/10475_characters_creature_respawn.sql b/sql/updates/10475_characters_creature_respawn.sql deleted file mode 100644 index e6964910597..00000000000 --- a/sql/updates/10475_characters_creature_respawn.sql +++ /dev/null @@ -1,9 +0,0 @@ -DROP TABLE IF EXISTS `creature_respawn`; -CREATE TABLE `creature_respawn` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `respawntime` int(10) unsigned NOT NULL DEFAULT '0', - `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; - diff --git a/sql/updates/10475_characters_gameobject_respawn.sql b/sql/updates/10475_characters_gameobject_respawn.sql deleted file mode 100644 index 2a5f0c03de7..00000000000 --- a/sql/updates/10475_characters_gameobject_respawn.sql +++ /dev/null @@ -1,9 +0,0 @@ -DROP TABLE IF EXISTS `gameobject_respawn`; -CREATE TABLE `gameobject_respawn` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `respawntime` int(10) unsigned NOT NULL DEFAULT '0', - `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; - diff --git a/sql/updates/10475_characters_reserved_name.sql b/sql/updates/10475_characters_reserved_name.sql deleted file mode 100644 index dedab8b5911..00000000000 --- a/sql/updates/10475_characters_reserved_name.sql +++ /dev/null @@ -1,6 +0,0 @@ -DROP TABLE IF EXISTS `reserved_name`; -CREATE TABLE `reserved_name` ( - `name` varchar(12) NOT NULL DEFAULT '', - PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names'; - diff --git a/sql/updates/10490_world_scriptname.sql b/sql/updates/10490_world_scriptname.sql deleted file mode 100644 index ead063856bb..00000000000 --- a/sql/updates/10490_world_scriptname.sql +++ /dev/null @@ -1,2 +0,0 @@ --- ScriptName for Captured Frog -UPDATE `item_template` SET `ScriptName`= 'item_captured_frog' WHERE `entry`=53510; diff --git a/sql/updates/10543_characters_group_member.sql b/sql/updates/10543_characters_group_member.sql deleted file mode 100644 index 5c018bcad90..00000000000 --- a/sql/updates/10543_characters_group_member.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE `group_member` -CHANGE `guid` `guid` INT(11) UNSIGNED NOT NULL, -CHANGE `memberGuid` `memberGuid` INT(11) UNSIGNED NOT NULL DEFAULT '0', -CHANGE `memberFlags` `memberFlags` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', -CHANGE `subgroup` `subgroup` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', -CHANGE `roles` `roles` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'; diff --git a/sql/updates/10545_world_script_texts.sql b/sql/updates/10545_world_script_texts.sql deleted file mode 100644 index 15e4de0f148..00000000000 --- a/sql/updates/10545_world_script_texts.sql +++ /dev/null @@ -1,6 +0,0 @@ -DELETE FROM `script_texts` WHERE `npc_entry` IN (25828,25248,25827); -INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES -(25248,-1571044,'Well...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_1'), -(25828,-1571045,'Finally! This charade is over... Arthas give me strength!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_2'), -(25827,-1571046,'You don''t know who you''re messing with! Death beckons!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_3'), -(25248,-1571047,'I suppose this is it, then? I won''t go down quietly!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_4'); \ No newline at end of file diff --git a/sql/updates/10545_world_scriptname.sql b/sql/updates/10545_world_scriptname.sql deleted file mode 100644 index e5405faadf8..00000000000 --- a/sql/updates/10545_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_hidden_cultist' WHERE `entry` IN (25828,25248,25827); \ No newline at end of file diff --git a/sql/updates/10548_characters_channel.sql b/sql/updates/10548_characters_channel.sql deleted file mode 100644 index 126a51ca5bb..00000000000 --- a/sql/updates/10548_characters_channel.sql +++ /dev/null @@ -1,9 +0,0 @@ -ALTER TABLE `channels` -DROP COLUMN `m_moderate`, -CHANGE `m_name` `m_name` VARCHAR(128) NOT NULL, -CHANGE `m_announce` `m_announce` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, -CHANGE `m_public` `m_ownership` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, -CHANGE `m_password` `m_password` VARCHAR(32) NULL, -ADD COLUMN `last_used` INT(10) UNSIGNED NOT NULL AFTER `BannedList`; --- Set already existing/current channels to use current timestamp (saves them from being unneccesarily cleaned up) -UPDATE `channels` SET last_used = UNIX_TIMESTAMP(); diff --git a/sql/updates/10548_world_command.sql b/sql/updates/10548_world_command.sql deleted file mode 100644 index 8ea3ddbbc9e..00000000000 --- a/sql/updates/10548_world_command.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `command` WHERE `name` LIKE 'channel set public'; -DELETE FROM `command` WHERE `name` LIKE 'channel set ownership'; -INSERT INTO `command` (`name`,`security`,`help`) VALUES -('channel set ownership', 3, 'Syntax: .channel set ownership $channel [on/off]\n\n\Grant ownership to the first person that joins the channel.'); - diff --git a/sql/updates/10548_world_trinity_string.sql b/sql/updates/10548_world_trinity_string.sql deleted file mode 100644 index 2bc5147133b..00000000000 --- a/sql/updates/10548_world_trinity_string.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `trinity_string` WHERE `entry` IN (5022, 5023); -INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES -(5022, 'Granting ownership to first person that joins the channel \"%s\": Enabled.'), -(5023, 'Granting ownership to first person that joins the channel \"%s\": Disabled.'); diff --git a/sql/updates/10561_world_achievement_criteria_data.sql b/sql/updates/10561_world_achievement_criteria_data.sql deleted file mode 100644 index b64f14bcb85..00000000000 --- a/sql/updates/10561_world_achievement_criteria_data.sql +++ /dev/null @@ -1,6 +0,0 @@ -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (12780,13012,13011,13013) AND `type` IN (0,11); -INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES -(12780,11,0,0, 'achievement_once_bitten_twice_shy_n'), -(13012,11,0,0, 'achievement_once_bitten_twice_shy_n'), -(13011,11,0,0, 'achievement_once_bitten_twice_shy_v'), -(13013,11,0,0, 'achievement_once_bitten_twice_shy_v'); diff --git a/sql/updates/10561_world_scriptname.sql b/sql/updates/10561_world_scriptname.sql deleted file mode 100644 index faa92a98ae1..00000000000 --- a/sql/updates/10561_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_blood_queen_lana_thel' WHERE `entry`=37955; diff --git a/sql/updates/10561_world_spell_linked_spell.sql b/sql/updates/10561_world_spell_linked_spell.sql deleted file mode 100644 index 7a186fb3d97..00000000000 --- a/sql/updates/10561_world_spell_linked_spell.sql +++ /dev/null @@ -1,21 +0,0 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (70867,71473,71532,71533,70879,71525,71530,71531,70877,71474,70923,71446,71478,71479,71480,71952,71390); -INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES -(70867,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(71473,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(71532,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(71533,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(70879,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(71525,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(71530,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(71531,70871,2, 'Blood-Queen: Essence of the Blood Queen'), -(70877,72649,2, 'Blood-Queen: Frenzied Bloodthirst 10man'), -(70877,72151,2, 'Blood-Queen: Frenzied Bloodthirst 10man'), -(71474,72648,2, 'Blood-Queen: Frenzied Bloodthirst 25man'), -(71474,72650,2, 'Blood-Queen: Frenzied Bloodthirst 25man'), -(70923,70924,2, 'Blood-Queen: Uncontrollable Frenzy'), -(71446,71447,1, 'Blood-Queen: Bloodbolt Splash'), -(71478,71481,1, 'Blood-Queen: Bloodbolt Splash'), -(71479,71482,1, 'Blood-Queen: Bloodbolt Splash'), -(71480,71483,1, 'Blood-Queen: Bloodbolt Splash'), -(71952,70995,1, 'Blood-Queen: Presence of the Darkfallen'), -(71390,71341,0, 'Blood-Queen: Pact of the Darkfallen'); diff --git a/sql/updates/10561_world_spell_script_names.sql b/sql/updates/10561_world_spell_script_names.sql deleted file mode 100644 index e6f6ba6295c..00000000000 --- a/sql/updates/10561_world_spell_script_names.sql +++ /dev/null @@ -1,14 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id` IN (70877,71474) AND `ScriptName`='spell_blood_queen_frenzied_bloodthirst'; -DELETE FROM `spell_script_names` WHERE `spell_id` IN (70946,71475,71476,71477) AND `ScriptName`='spell_blood_queen_vampiric_bite'; -DELETE FROM `spell_script_names` WHERE `spell_id` IN (71899,71900,71901,71902) AND `ScriptName`='spell_blood_queen_bloodbolt'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(70877, 'spell_blood_queen_frenzied_bloodthirst'), -(71474, 'spell_blood_queen_frenzied_bloodthirst'), -(70946, 'spell_blood_queen_vampiric_bite'), -(71475, 'spell_blood_queen_vampiric_bite'), -(71476, 'spell_blood_queen_vampiric_bite'), -(71477, 'spell_blood_queen_vampiric_bite'), -(71899, 'spell_blood_queen_bloodbolt'), -(71900, 'spell_blood_queen_bloodbolt'), -(71901, 'spell_blood_queen_bloodbolt'), -(71902, 'spell_blood_queen_bloodbolt'); diff --git a/sql/updates/10563_world_scriptname.sql b/sql/updates/10563_world_scriptname.sql deleted file mode 100644 index 4184ee9f9f2..00000000000 --- a/sql/updates/10563_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_daegarn' WHERE `entry`=24151; \ No newline at end of file diff --git a/sql/updates/10570_world_disables.sql b/sql/updates/10570_world_disables.sql deleted file mode 100644 index a7e1a961d4a..00000000000 --- a/sql/updates/10570_world_disables.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `disables` -ADD COLUMN params_0 varchar (255) NOT NULL default '' AFTER flags, -ADD COLUMN params_1 VARCHAR (255) NOT NULL default '' AFTER params_0; diff --git a/sql/updates/10619_world_spell_script_names.sql b/sql/updates/10619_world_spell_script_names.sql deleted file mode 100644 index 23f06a72125..00000000000 --- a/sql/updates/10619_world_spell_script_names.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=43874 AND `ScriptName`='spell_q11396_11399_force_shield_arcane_purple_x3'; -DELETE FROM `spell_script_names` WHERE `spell_id`=50133 AND `ScriptName`='spell_q11396_11399_scourging_crystal_controller'; -DELETE FROM `spell_script_names` WHERE `spell_id`=43882 AND `ScriptName`='spell_q11396_11399_scourging_crystal_controller_dummy'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(43874, 'spell_q11396_11399_force_shield_arcane_purple_x3'), -(43882, 'spell_q11396_11399_scourging_crystal_controller_dummy'), -(50133, 'spell_q11396_11399_scourging_crystal_controller'); diff --git a/sql/updates/10623_world_spell_bonus_data.sql b/sql/updates/10623_world_spell_bonus_data.sql deleted file mode 100644 index 7db48d5bd92..00000000000 --- a/sql/updates/10623_world_spell_bonus_data.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_bonus_data` WHERE `entry` IN (66922); -INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES -(66922, 0, 0, 0, 0, 'Paladin - Flash of Light'); diff --git a/sql/updates/10646_world_scriptname.sql b/sql/updates/10646_world_scriptname.sql deleted file mode 100644 index f97cea87c6d..00000000000 --- a/sql/updates/10646_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_bone_spike' WHERE `entry` IN (36619,38711,38712); diff --git a/sql/updates/10654_characters_item_instance.sql b/sql/updates/10654_characters_item_instance.sql deleted file mode 100644 index 297250201cd..00000000000 --- a/sql/updates/10654_characters_item_instance.sql +++ /dev/null @@ -1,28 +0,0 @@ --- Add new column to item_instance table -ALTER TABLE `item_instance` ADD COLUMN `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `guid`; - --- Set values for new column from corresponding columns in other tables -UPDATE item_instance ii, auctionhouse ah -SET ii.itemEntry = ah.item_template -WHERE ii.guid = ah.itemguid; - -UPDATE item_instance ii, character_inventory ci -SET ii.itemEntry = ci.item_template -WHERE ii.guid = ci.item; - -UPDATE item_instance ii, guild_bank_item gbi -SET ii.itemEntry = gbi.item_entry -WHERE ii.guid = gbi.item_guid; - -UPDATE item_instance ii, mail_items mi -SET ii.itemEntry = mi.item_template -WHERE ii.guid = mi.item_guid; - --- Remove unnecessary columns -ALTER TABLE `auctionhouse` DROP COLUMN `item_template`; -ALTER TABLE `character_inventory` DROP COLUMN `item_template`; -ALTER TABLE `guild_bank_item` DROP COLUMN `item_entry`; -ALTER TABLE `mail_items` DROP COLUMN `item_template`; - --- Delete orphan records (use at your own risk) --- DELETE FROM item_instance WHERE itemEntry = 0; diff --git a/sql/updates/10681_world_command.sql b/sql/updates/10681_world_command.sql deleted file mode 100644 index b91b64ae152..00000000000 --- a/sql/updates/10681_world_command.sql +++ /dev/null @@ -1,11 +0,0 @@ -DELETE FROM `command` WHERE `name` IN ('reload access_requirement','reload achievement_criteria_data','reload achievement_reward','reload all achievement','reload all area','reload all eventai','reload auctions','reload mail_level_reward','reload smart_scripts'); -INSERT INTO `command` (`name`,`security`,`help`) VALUES -('reload access_requirement',3,'Syntax: .reload access_requirement\nReload access_requirement table.'), -('reload achievement_criteria_data',3,'Syntax: .reload achievement_criteria_data\nReload achievement_criteria_data table.'), -('reload achievement_reward',3,'Syntax: .reload achievement_reward\nReload achievement_reward table.'), -('reload all achievement',3,'Syntax: .reload all achievement\r\n\r\nReload achievement_reward, achievement_criteria_data tables.'), -('reload all area',3,'Syntax: .reload all area\r\n\r\nReload areatrigger_teleport, areatrigger_tavern, game_graveyard_zone tables.'), -('reload all eventai',3,'Syntax: .reload all eventai\r\n\r\nReload creature_ai_scripts, creature_ai_summons, creature_ai_texts tables.'), -('reload auctions',3,'Syntax: .reload auctions\nReload dynamic data tables from the database.'), -('reload mail_level_reward',3,'Syntax: .reload mail_level_reward\nReload mail_level_reward table.'), -('reload smart_scripts',3,'Syntax: .reload smart_scripts\nReload smart_scripts table.'); diff --git a/sql/updates/10733_world_spell_proc_event.sql b/sql/updates/10733_world_spell_proc_event.sql deleted file mode 100644 index ed30cb35d1d..00000000000 --- a/sql/updates/10733_world_spell_proc_event.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN ('15337','15338'); -INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES -('15337','0','6','8396800','2','0','0','2','0','0','0'), -- Improved Spirit Tap (Rank 1) -('15338','0','6','8396800','2','0','0','2','0','0','0'); -- Improved Spirit Tap (Rank 2) diff --git a/sql/updates/10736_world_scriptname.sql b/sql/updates/10736_world_scriptname.sql deleted file mode 100644 index 2aae66daeec..00000000000 --- a/sql/updates/10736_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=28823; diff --git a/sql/updates/10741_characters_character_aura.sql b/sql/updates/10741_characters_character_aura.sql deleted file mode 100644 index d9afb213a76..00000000000 --- a/sql/updates/10741_characters_character_aura.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `character_aura` - ADD COLUMN `item_guid` bigint(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `caster_guid`, - DROP PRIMARY KEY, - ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`,`effect_mask`); diff --git a/sql/updates/10765_world_scriptname.sql b/sql/updates/10765_world_scriptname.sql deleted file mode 100644 index 0c100dea663..00000000000 --- a/sql/updates/10765_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`= 'mob_rune_of_power' WHERE entry = 33705; diff --git a/sql/updates/10765_world_spell_dbc.sql b/sql/updates/10765_world_spell_dbc.sql deleted file mode 100644 index 8a5846b5eec..00000000000 --- a/sql/updates/10765_world_spell_dbc.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM spell_dbc WHERE `Id`=3617; -INSERT INTO spell_dbc (`Id`, `Effect1`, `Comment`) VALUES (3617, 1, 'NPC 32958 suicide spell'); diff --git a/sql/updates/10777_characters_creature_respawn.sql b/sql/updates/10777_characters_creature_respawn.sql deleted file mode 100644 index 2289f201ac6..00000000000 --- a/sql/updates/10777_characters_creature_respawn.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `creature_respawn` CHANGE COLUMN `respawntime` `respawntime` bigint(20) unsigned NOT NULL DEFAULT 0; diff --git a/sql/updates/10777_characters_gameobject_respawn.sql b/sql/updates/10777_characters_gameobject_respawn.sql deleted file mode 100644 index 065586d0739..00000000000 --- a/sql/updates/10777_characters_gameobject_respawn.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `gameobject_respawn` CHANGE COLUMN `respawntime` `respawntime` bigint(20) unsigned NOT NULL DEFAULT 0; diff --git a/sql/updates/10801_world_creature_linked_respawn.sql b/sql/updates/10801_world_creature_linked_respawn.sql deleted file mode 100644 index 4be48e58e84..00000000000 --- a/sql/updates/10801_world_creature_linked_respawn.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER table `creature_linked_respawn` -RENAME TO `linked_respawn`, -ADD COLUMN linkType tinyint(3) UNSIGNED NOT NULL DEFAULT '0', -DROP PRIMARY KEY, -ADD PRIMARY KEY(`guid`, `linkType`); diff --git a/sql/updates/10806_world_scriptname.sql b/sql/updates/10806_world_scriptname.sql deleted file mode 100644 index d2f02595e72..00000000000 --- a/sql/updates/10806_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=3216; -- Neeru Fireblade \ No newline at end of file diff --git a/sql/updates/10815_world_spell_script_names.sql b/sql/updates/10815_world_spell_script_names.sql deleted file mode 100644 index ee041b30e0a..00000000000 --- a/sql/updates/10815_world_spell_script_names.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=67533 AND `ScriptName`='spell_item_red_rider_air_rifle'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(67533, 'spell_item_red_rider_air_rifle'); diff --git a/sql/updates/3.3.5a_old/10383_world_version.sql b/sql/updates/3.3.5a_old/10383_world_version.sql new file mode 100644 index 00000000000..301480b3a2f --- /dev/null +++ b/sql/updates/3.3.5a_old/10383_world_version.sql @@ -0,0 +1 @@ +ALTER TABLE `version` CHANGE `core_revision` `core_revision` varchar(120) DEFAULT NULL; diff --git a/sql/updates/3.3.5a_old/10392_world_spell_bonus_data.sql b/sql/updates/3.3.5a_old/10392_world_spell_bonus_data.sql new file mode 100644 index 00000000000..3a808bddf13 --- /dev/null +++ b/sql/updates/3.3.5a_old/10392_world_spell_bonus_data.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_bonus_data` WHERE `entry` = 53600; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +(53600, 0, 0, 0, 0 ,'Paladin - Shield of Righteousness'); \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10393_world_spell_proc_event.sql b/sql/updates/3.3.5a_old/10393_world_spell_proc_event.sql new file mode 100644 index 00000000000..11e9f7a184b --- /dev/null +++ b/sql/updates/3.3.5a_old/10393_world_spell_proc_event.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (12281, 12812, 12813, 12814, 12815); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +( 12281, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 1) +( 12812, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 2) +( 12813, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 3) +( 12814, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6), -- Sword Specialization (Rank 4) +( 12815, 0x00, 4, 0xAA600444, 0x00400105, 0x00000000, 0x00000000, 0x00000000, 0, 0, 6); -- Sword Specialization (Rank 5) \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10397_world_command.sql b/sql/updates/3.3.5a_old/10397_world_command.sql new file mode 100644 index 00000000000..bc72fa2841d --- /dev/null +++ b/sql/updates/3.3.5a_old/10397_world_command.sql @@ -0,0 +1,48 @@ +-- Rename changed learn commands +DELETE FROM `command` WHERE `name` LIKE 'learn%'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('learn',3,'Syntax: .learn #spell [all]\r\n\r\nSelected character learn a spell of id #spell. If ''all'' provided then all ranks learned.'), +('learn all',3,'Syntax: .learn all\r\n\r\nLearn all big set different spell maybe useful for Administaror.'), +('learn all crafts',2,'Syntax: .learn crafts\r\n\r\nLearn all professions and recipes.'), +('learn all default',1,'Syntax: .learn all default [$playername]\r\n\r\nLearn for selected/$playername player all default spells for his race/class and spells rewarded by completed quests.'), +('learn all gm',2,'Syntax: .learn all gm\r\n\r\nLearn all default spells for Game Masters.'), +('learn all lang',1,'Syntax: .learn all lang\r\n\r\nLearn all languages'), +('learn all my class',3,'Syntax: .learn all my class\r\n\r\nLearn all spells and talents available for his class.'), +('learn all my pettalents',3,'Syntax: .learn all my pettalents\r\n\r\nLearn all talents for your pet available for his creature type (only for hunter pets).'), +('learn all my spells',3,'Syntax: .learn all my spells\r\n\r\nLearn all spells (except talents and spells with first rank learned as talent) available for his class.'), +('learn all my talents',3,'Syntax: .learn all my talents\r\n\r\nLearn all talents (and spells with first rank learned as talent) available for his class.'), +('learn all recipes',2,'Syntax: .learn all recipes [$profession]\r\rLearns all recipes of specified profession and sets skill level to max.\rExample: .learn all recipes enchanting'); + +-- Rename changed npc commands +DELETE FROM `command` WHERE `name` LIKE 'npc%'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('npc',1,'Syntax: .npc $subcommand\nType .npc to see the list of possible subcommands or .help npc $subcommand to see info on subcommands'), +('npc add',2,'Syntax: .npc add #creatureid\r\n\r\nSpawn a creature by the given template id of #creatureid.'), +('npc add formation',1,'Syntax: .npc add formation $leader\nAdd selected creature to a leader''s formation.'), +('npc add item',2,'Syntax: .npc add item #itemId <#maxcount><#incrtime><#extendedcost>r\r\n\r\nAdd item #itemid to item list of selected vendor. Also optionally set max count item in vendor item list and time to item count restoring and items ExtendedCost.'), +('npc add move',2,'Syntax: .npc add move #creature_guid [#waittime]\r\n\r\nAdd your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.'), +('npc set allowmove',3,'Syntax: .npc set allowmove\r\n\r\nEnable or disable movement creatures in world. Not implemented.'), +('npc set entry',3,'Syntax: .npc set entry $entry\nSwitch selected creature with another entry from creature_template. - New creature.id value not saved to DB.'), +('npc set level',2,'Syntax: .npc set level #level\r\n\r\nChange the level of the selected creature to #level.\r\n\r\n#level may range from 1 to (CONFIG_MAX_PLAYER_LEVEL) + 3.'), +('npc delete',2,'Syntax: .npc delete [#guid]\r\n\r\nDelete creature with guid #guid (or the selected if no guid is provided)'), +('npc delete item',2,'Syntax: .npc delete item #itemId\r\n\r\nRemove item #itemid from item list of selected vendor.'), +('npc set factionid',2,'Syntax: .npc set factionid #factionid\r\n\r\nSet the faction of the selected creature to #factionid.'), +('npc set flag',2,'Syntax: .npc set flag #npcflag\r\n\r\nSet the NPC flags of creature template of the selected creature and selected creature to #npcflag. NPC flags will applied to all creatures of selected creature template after server restart or grid unload/load.'), +('npc follow',2,'Syntax: .npc follow start\r\n\r\nSelected creature start follow you until death/fight/etc.'), +('npc follow stop',2,'Syntax: .npc follow stop\r\n\r\nSelected creature (non pet) stop follow you.'), +('npc info',3,'Syntax: .npc info\r\n\r\nDisplay a list of details for the selected creature.\r\n\r\nThe list includes:\r\n- GUID, Faction, NPC flags, Entry ID, Model ID,\r\n- Level,\r\n- Health (current/maximum),\r\n\r\n- Field flags, dynamic flags, faction template, \r\n- Position information,\r\n- and the creature type, e.g. if the creature is a vendor.'), +('npc move',2,'Syntax: .npc move [#creature_guid]\r\n\r\nMove the targeted creature spawn point to your coordinates.'), +('npc playemote',3,'Syntax: .npc playemote #emoteid\r\n\r\nMake the selected creature emote with an emote of id #emoteid.'), +('npc say',1,'Syntax: .npc say $message\nMake selected creature say specified message.'), +('npc set deathstate',2,'Syntax: .npc set deathstate on/off\r\n\r\nSet default death state (dead/alive) for npc at spawn.'), +('npc set link',2,'Syntax: .npc set link $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'), +('npc set model',2,'Syntax: .npc set model #displayid\r\n\r\nChange the model id of the selected creature to #displayid.'), +('npc set movetype',2,'Syntax: .npc set movetype [#creature_guid] stay/random/way [NODEL]\r\n\r\nSet for creature pointed by #creature_guid (or selected if #creature_guid not provided) movement type and move it to respawn position (if creature alive). Any existing waypoints for creature will be removed from the database if you do not use NODEL. If the creature is dead then movement type will applied at creature respawn.\r\nMake sure you use NODEL, if you want to keep the waypoints.'), +('npc set phase',2,'Syntax: .npc set phase #phasemask\r\n\r\nSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB and persistent. In pet case change active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..'), +('npc set spawndist',2,'Syntax: .npc set spawndist #dist\r\n\r\nAdjust spawndistance of selected creature to dist.'), +('npc set spawntime',2,'Syntax: .npc set spawntime #time \r\n\r\nAdjust spawntime of selected creature to time.'), +('npc add temp',2,'Syntax: .npc add temp\r\n\r\nAdds temporary NPC, not saved to database.'), +('npc textemote',1,'Syntax: .npc textemote #emoteid\r\n\r\nMake the selected creature to do textemote with an emote of id #emoteid.'), +('npc whisper',1,'Syntax: .npc whisper #playerguid #text\r\nMake the selected npc whisper #text to #playerguid.'), +('npc yell',1,'Syntax: .npc yell $message\nMake selected creature yell specified message.'); + diff --git a/sql/updates/3.3.5a_old/10402_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10402_world_spell_script_names.sql new file mode 100644 index 00000000000..1f70a1d018f --- /dev/null +++ b/sql/updates/3.3.5a_old/10402_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=46221 AND `ScriptName`='spell_gen_animal_blood'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(46221,'spell_gen_animal_blood'); diff --git a/sql/updates/3.3.5a_old/10418_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10418_world_spell_script_names.sql new file mode 100644 index 00000000000..321fda46450 --- /dev/null +++ b/sql/updates/3.3.5a_old/10418_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM spell_script_names WHERE spell_id = 10848 AND `ScriptName`='spell_gen_shroud_of_death'; +INSERT INTO spell_script_names (`spell_id`,`ScriptName`) VALUES +(10848, 'spell_gen_shroud_of_death'); diff --git a/sql/updates/3.3.5a_old/10419_world_spell_linked_spell.sql b/sql/updates/3.3.5a_old/10419_world_spell_linked_spell.sql new file mode 100644 index 00000000000..db29bbecde3 --- /dev/null +++ b/sql/updates/3.3.5a_old/10419_world_spell_linked_spell.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (58984); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(58984, 59646, 0, 'Shadowmeld: Sanctuary'), +(58984, 62196, 0, 'Shadowmeld: Force deselect'); diff --git a/sql/updates/3.3.5a_old/10431_world_trinity_string.sql b/sql/updates/3.3.5a_old/10431_world_trinity_string.sql new file mode 100644 index 00000000000..227fb43fd4d --- /dev/null +++ b/sql/updates/3.3.5a_old/10431_world_trinity_string.sql @@ -0,0 +1,4 @@ +DELETE FROM `trinity_string` WHERE `entry` IN (1134, 1135); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(1134, 'Sending tickets is allowed.'), +(1135, 'Sending tickets is not allowed.'); diff --git a/sql/updates/3.3.5a_old/10436_world_script_texts.sql b/sql/updates/3.3.5a_old/10436_world_script_texts.sql new file mode 100644 index 00000000000..4bf12bb70b5 --- /dev/null +++ b/sql/updates/3.3.5a_old/10436_world_script_texts.sql @@ -0,0 +1,14 @@ +-- Quest Discrediting the Deserters (11133) +-- Script Texts +DELETE FROM `script_texts` WHERE `entry` BETWEEN (-1603510) AND (-1603502); +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) +VALUES +(4979,-1603502,'Hey, thanks.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0, 'Theramore Guard - SAY_QUEST1'), +(4979,-1603503,'...receive 50 percent off deserter undergarments? What is this garbage?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST2'), +(4979,-1603504,'...to establish a fund for the purchase of hair gel? I like my hair the way it is, thanks!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST3'), +(4979,-1603505,'...the deserters seek a Theramore where citizens will be free to juggle at all hours of the day? What is this nonsense?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST4'), +(4979,-1603506,'...to establish the chicken as the official symbol of Theramore?! These guys are nuts!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST5'), +(4979,-1603507,'...as a deserter, you\'ll enjoy activities like tethered swimming and dog grooming? How ridiculous!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST6'), +(4979,-1603508,'This... this is a joke, right?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST7'), +(4979,-1603509,'I\'d never join anything like this. Better keep this, though. It\'ll come in handy in the privy...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST8'), +(4979,-1603510,'What a bunch of lunatics! You actually believe this stuff?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Theramore Guard - SAY_QUEST9'); diff --git a/sql/updates/3.3.5a_old/10436_world_scriptname.sql b/sql/updates/3.3.5a_old/10436_world_scriptname.sql new file mode 100644 index 00000000000..c824b206974 --- /dev/null +++ b/sql/updates/3.3.5a_old/10436_world_scriptname.sql @@ -0,0 +1,2 @@ +-- ScriptName +UPDATE `creature_template` SET `ScriptName`='npc_theramore_guard' WHERE `entry`=4979; -- Theramore Guard diff --git a/sql/updates/3.3.5a_old/10453_world_creature_template.sql b/sql/updates/3.3.5a_old/10453_world_creature_template.sql new file mode 100644 index 00000000000..1c869eb10ef --- /dev/null +++ b/sql/updates/3.3.5a_old/10453_world_creature_template.sql @@ -0,0 +1,6 @@ +-- Quest ...Or Maybe We Don't (12138, 12198) +UPDATE `creature_template` SET `ScriptName`='npc_lightning_sentry' WHERE `entry`=26407; -- Lightning Sentry + +-- Quest Smoke 'Em Out (12323, 12324) +UPDATE `creature_template` SET `ScriptName`='npc_venture_co_straggler',`AIName`='' WHERE `entry`=27570; + diff --git a/sql/updates/3.3.5a_old/10453_world_script_text.sql b/sql/updates/3.3.5a_old/10453_world_script_text.sql new file mode 100644 index 00000000000..f107787e051 --- /dev/null +++ b/sql/updates/3.3.5a_old/10453_world_script_text.sql @@ -0,0 +1,9 @@ +-- Quest Smoke Em Out +DELETE FROM `script_texts` WHERE `entry` BETWEEN (-1603539) AND (-1603535); +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES + (27570,-1603535,'We\'re all gonna die!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say1'), + (27570,-1603536,'Gotta get out of here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say2'), + (27570,-1603537,'No way I\'m stickin\' around!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say3'), + (27570,-1603538,'Forget this! I\'m going home!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say4'), + (27570,-1603539,'I didn\'t sign up for this!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say5'); + diff --git a/sql/updates/3.3.5a_old/10460_world_command.sql b/sql/updates/3.3.5a_old/10460_world_command.sql new file mode 100644 index 00000000000..83343f0fff0 --- /dev/null +++ b/sql/updates/3.3.5a_old/10460_world_command.sql @@ -0,0 +1,36 @@ +-- Rename changed gobject commands +DELETE FROM `command` WHERE `name` IN ('gobject setphase','gobject tempadd','gobject set phase','gobject add temp'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('gobject set phase',2,'Syntax: .gobject set phase #guid #phasemask\r\n\r\nGameobject with DB guid #guid phasemask changed to #phasemask with related world vision update for players. Gameobject state saved to DB and persistent.'), +('gobject add temp',2,'Adds a temporary gameobject that is not saved to DB.'); + +-- Rename changed honor commands +DELETE FROM `command` WHERE `name` IN ('honor addkill','honor add kill'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('honor add kill',2,'Syntax: .honor add kill\r\n\r\nAdd the targeted unit as one of your pvp kills today (you only get honor if it''s a racial leader or a player)'); + +-- Add wp add command +DELETE FROM `command` WHERE `name` IN ('wp add','wp addwp'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('wp add',2,'Syntax: .wp add\r\n\r\nAdd a waypoint for the selected creature at your current position.'); + +-- Rename changed loadpath command and move it to wp reload +DELETE FROM `command` WHERE `name` IN ('loadpath','wp reload'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('wp reload',3,'Syntax: .wp reload $pathid\nLoad path changes ingame - IMPORTANT: must be applied first for new paths before .wp load #pathid '); + +DELETE FROM `command` WHERE `name` LIKE 'reload all%'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.'), +('reload all gossips',3,'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, npc_gossip, points_of_interest tables.'), +('reload all item',3,'Syntax: .reload all item\nReload page_text, item_enchantment_table tables.'), +('reload all locales',3,'Syntax: .reload all locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'), +('reload all loot',3,'Syntax: .reload all loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.'), +('reload all npc',3,'Syntax: .reload all npc\nReload npc_gossip, npc_option, npc_trainer, npc vendor, points of interest tables.'), +('reload all quest',3,'Syntax: .reload all quest\r\n\r\nReload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.'), +('reload all scripts',3,'Syntax: .reload all scripts\nReload gameobject_scripts, event_scripts, quest_end_scripts, quest_start_scripts, spell_scripts, db_script_string, waypoint_scripts tables.'), +('reload all spell',3,'Syntax: .reload all spell\r\n\r\nReload all `spell_*` tables with reload support added and that can be _safe_ reloaded.'); + +DELETE FROM `command` WHERE `name` IN ('titles setmask','titles set mask'); +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('titles set mask',2,'Syntax: .titles set mask #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'); diff --git a/sql/updates/3.3.5a_old/10462_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10462_world_spell_script_names.sql new file mode 100644 index 00000000000..c4439817178 --- /dev/null +++ b/sql/updates/3.3.5a_old/10462_world_spell_script_names.sql @@ -0,0 +1,2 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=6474; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (6474, 'spell_sha_earthbind_totem'); diff --git a/sql/updates/3.3.5a_old/10468_world_script_texts.sql b/sql/updates/3.3.5a_old/10468_world_script_texts.sql new file mode 100644 index 00000000000..bb3ed4d7299 --- /dev/null +++ b/sql/updates/3.3.5a_old/10468_world_script_texts.sql @@ -0,0 +1 @@ +DELETE FROM `script_texts` WHERE `entry` BETWEEN -1631139 AND -1631000; diff --git a/sql/updates/3.3.5a_old/10468_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10468_world_spell_script_names.sql new file mode 100644 index 00000000000..89f6b5b79e1 --- /dev/null +++ b/sql/updates/3.3.5a_old/10468_world_spell_script_names.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (69057,70826,72088,72089) AND `ScriptName`='spell_marrowgar_bone_spike_graveyard'; +DELETE FROM `spell_script_names` WHERE `spell_id` IN (70903,72498,72499,72500,71236,72495,72496,72497) AND `ScriptName`='spell_cultist_dark_martyrdrom'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(69057,'spell_marrowgar_bone_spike_graveyard'), +(70826,'spell_marrowgar_bone_spike_graveyard'), +(72088,'spell_marrowgar_bone_spike_graveyard'), +(72089,'spell_marrowgar_bone_spike_graveyard'), +(70903,'spell_cultist_dark_martyrdrom'), +(72498,'spell_cultist_dark_martyrdrom'), +(72499,'spell_cultist_dark_martyrdrom'), +(72500,'spell_cultist_dark_martyrdrom'), +(71236,'spell_cultist_dark_martyrdrom'), +(72495,'spell_cultist_dark_martyrdrom'), +(72496,'spell_cultist_dark_martyrdrom'), +(72497,'spell_cultist_dark_martyrdrom'); diff --git a/sql/updates/3.3.5a_old/10470_world_command.sql b/sql/updates/3.3.5a_old/10470_world_command.sql new file mode 100644 index 00000000000..56f665e9104 --- /dev/null +++ b/sql/updates/3.3.5a_old/10470_world_command.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` LIKE 'server togglequerylog'; +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('server togglequerylog',4,'Toggle SQL driver query logging.'); diff --git a/sql/updates/3.3.5a_old/10470_world_trinity_string.sql b/sql/updates/3.3.5a_old/10470_world_trinity_string.sql new file mode 100644 index 00000000000..c6cac6daaa0 --- /dev/null +++ b/sql/updates/3.3.5a_old/10470_world_trinity_string.sql @@ -0,0 +1,4 @@ +DELETE FROM `trinity_string` WHERE `entry` IN (1027, 1028); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(1027, 'SQL driver query logging enabled.'), +(1028, 'SQL driver query logging disabled.'); \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10475_characters_character_banned.sql b/sql/updates/3.3.5a_old/10475_characters_character_banned.sql new file mode 100644 index 00000000000..1d4789a4f33 --- /dev/null +++ b/sql/updates/3.3.5a_old/10475_characters_character_banned.sql @@ -0,0 +1 @@ +ALTER TABLE character_banned ENGINE = InnoDB; diff --git a/sql/updates/3.3.5a_old/10475_characters_creature_respawn.sql b/sql/updates/3.3.5a_old/10475_characters_creature_respawn.sql new file mode 100644 index 00000000000..e6964910597 --- /dev/null +++ b/sql/updates/3.3.5a_old/10475_characters_creature_respawn.sql @@ -0,0 +1,9 @@ +DROP TABLE IF EXISTS `creature_respawn`; +CREATE TABLE `creature_respawn` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `respawntime` int(10) unsigned NOT NULL DEFAULT '0', + `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`instance`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; + diff --git a/sql/updates/3.3.5a_old/10475_characters_gameobject_respawn.sql b/sql/updates/3.3.5a_old/10475_characters_gameobject_respawn.sql new file mode 100644 index 00000000000..2a5f0c03de7 --- /dev/null +++ b/sql/updates/3.3.5a_old/10475_characters_gameobject_respawn.sql @@ -0,0 +1,9 @@ +DROP TABLE IF EXISTS `gameobject_respawn`; +CREATE TABLE `gameobject_respawn` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `respawntime` int(10) unsigned NOT NULL DEFAULT '0', + `instance` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`instance`), + KEY `instance` (`instance`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; + diff --git a/sql/updates/3.3.5a_old/10475_characters_reserved_name.sql b/sql/updates/3.3.5a_old/10475_characters_reserved_name.sql new file mode 100644 index 00000000000..dedab8b5911 --- /dev/null +++ b/sql/updates/3.3.5a_old/10475_characters_reserved_name.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `reserved_name`; +CREATE TABLE `reserved_name` ( + `name` varchar(12) NOT NULL DEFAULT '', + PRIMARY KEY (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names'; + diff --git a/sql/updates/3.3.5a_old/10490_world_scriptname.sql b/sql/updates/3.3.5a_old/10490_world_scriptname.sql new file mode 100644 index 00000000000..ead063856bb --- /dev/null +++ b/sql/updates/3.3.5a_old/10490_world_scriptname.sql @@ -0,0 +1,2 @@ +-- ScriptName for Captured Frog +UPDATE `item_template` SET `ScriptName`= 'item_captured_frog' WHERE `entry`=53510; diff --git a/sql/updates/3.3.5a_old/10543_characters_group_member.sql b/sql/updates/3.3.5a_old/10543_characters_group_member.sql new file mode 100644 index 00000000000..5c018bcad90 --- /dev/null +++ b/sql/updates/3.3.5a_old/10543_characters_group_member.sql @@ -0,0 +1,6 @@ +ALTER TABLE `group_member` +CHANGE `guid` `guid` INT(11) UNSIGNED NOT NULL, +CHANGE `memberGuid` `memberGuid` INT(11) UNSIGNED NOT NULL DEFAULT '0', +CHANGE `memberFlags` `memberFlags` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', +CHANGE `subgroup` `subgroup` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', +CHANGE `roles` `roles` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'; diff --git a/sql/updates/3.3.5a_old/10545_world_script_texts.sql b/sql/updates/3.3.5a_old/10545_world_script_texts.sql new file mode 100644 index 00000000000..15e4de0f148 --- /dev/null +++ b/sql/updates/3.3.5a_old/10545_world_script_texts.sql @@ -0,0 +1,6 @@ +DELETE FROM `script_texts` WHERE `npc_entry` IN (25828,25248,25827); +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES +(25248,-1571044,'Well...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_1'), +(25828,-1571045,'Finally! This charade is over... Arthas give me strength!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_2'), +(25827,-1571046,'You don''t know who you''re messing with! Death beckons!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_3'), +(25248,-1571047,'I suppose this is it, then? I won''t go down quietly!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_hidden_cultist SAY_HIDDEN_CULTIST_4'); \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10545_world_scriptname.sql b/sql/updates/3.3.5a_old/10545_world_scriptname.sql new file mode 100644 index 00000000000..e5405faadf8 --- /dev/null +++ b/sql/updates/3.3.5a_old/10545_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_hidden_cultist' WHERE `entry` IN (25828,25248,25827); \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10548_characters_channel.sql b/sql/updates/3.3.5a_old/10548_characters_channel.sql new file mode 100644 index 00000000000..126a51ca5bb --- /dev/null +++ b/sql/updates/3.3.5a_old/10548_characters_channel.sql @@ -0,0 +1,9 @@ +ALTER TABLE `channels` +DROP COLUMN `m_moderate`, +CHANGE `m_name` `m_name` VARCHAR(128) NOT NULL, +CHANGE `m_announce` `m_announce` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, +CHANGE `m_public` `m_ownership` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, +CHANGE `m_password` `m_password` VARCHAR(32) NULL, +ADD COLUMN `last_used` INT(10) UNSIGNED NOT NULL AFTER `BannedList`; +-- Set already existing/current channels to use current timestamp (saves them from being unneccesarily cleaned up) +UPDATE `channels` SET last_used = UNIX_TIMESTAMP(); diff --git a/sql/updates/3.3.5a_old/10548_world_command.sql b/sql/updates/3.3.5a_old/10548_world_command.sql new file mode 100644 index 00000000000..8ea3ddbbc9e --- /dev/null +++ b/sql/updates/3.3.5a_old/10548_world_command.sql @@ -0,0 +1,5 @@ +DELETE FROM `command` WHERE `name` LIKE 'channel set public'; +DELETE FROM `command` WHERE `name` LIKE 'channel set ownership'; +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('channel set ownership', 3, 'Syntax: .channel set ownership $channel [on/off]\n\n\Grant ownership to the first person that joins the channel.'); + diff --git a/sql/updates/3.3.5a_old/10548_world_trinity_string.sql b/sql/updates/3.3.5a_old/10548_world_trinity_string.sql new file mode 100644 index 00000000000..2bc5147133b --- /dev/null +++ b/sql/updates/3.3.5a_old/10548_world_trinity_string.sql @@ -0,0 +1,4 @@ +DELETE FROM `trinity_string` WHERE `entry` IN (5022, 5023); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(5022, 'Granting ownership to first person that joins the channel \"%s\": Enabled.'), +(5023, 'Granting ownership to first person that joins the channel \"%s\": Disabled.'); diff --git a/sql/updates/3.3.5a_old/10561_world_achievement_criteria_data.sql b/sql/updates/3.3.5a_old/10561_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..b64f14bcb85 --- /dev/null +++ b/sql/updates/3.3.5a_old/10561_world_achievement_criteria_data.sql @@ -0,0 +1,6 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (12780,13012,13011,13013) AND `type` IN (0,11); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(12780,11,0,0, 'achievement_once_bitten_twice_shy_n'), +(13012,11,0,0, 'achievement_once_bitten_twice_shy_n'), +(13011,11,0,0, 'achievement_once_bitten_twice_shy_v'), +(13013,11,0,0, 'achievement_once_bitten_twice_shy_v'); diff --git a/sql/updates/3.3.5a_old/10561_world_scriptname.sql b/sql/updates/3.3.5a_old/10561_world_scriptname.sql new file mode 100644 index 00000000000..faa92a98ae1 --- /dev/null +++ b/sql/updates/3.3.5a_old/10561_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='boss_blood_queen_lana_thel' WHERE `entry`=37955; diff --git a/sql/updates/3.3.5a_old/10561_world_spell_linked_spell.sql b/sql/updates/3.3.5a_old/10561_world_spell_linked_spell.sql new file mode 100644 index 00000000000..7a186fb3d97 --- /dev/null +++ b/sql/updates/3.3.5a_old/10561_world_spell_linked_spell.sql @@ -0,0 +1,21 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (70867,71473,71532,71533,70879,71525,71530,71531,70877,71474,70923,71446,71478,71479,71480,71952,71390); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(70867,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(71473,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(71532,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(71533,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(70879,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(71525,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(71530,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(71531,70871,2, 'Blood-Queen: Essence of the Blood Queen'), +(70877,72649,2, 'Blood-Queen: Frenzied Bloodthirst 10man'), +(70877,72151,2, 'Blood-Queen: Frenzied Bloodthirst 10man'), +(71474,72648,2, 'Blood-Queen: Frenzied Bloodthirst 25man'), +(71474,72650,2, 'Blood-Queen: Frenzied Bloodthirst 25man'), +(70923,70924,2, 'Blood-Queen: Uncontrollable Frenzy'), +(71446,71447,1, 'Blood-Queen: Bloodbolt Splash'), +(71478,71481,1, 'Blood-Queen: Bloodbolt Splash'), +(71479,71482,1, 'Blood-Queen: Bloodbolt Splash'), +(71480,71483,1, 'Blood-Queen: Bloodbolt Splash'), +(71952,70995,1, 'Blood-Queen: Presence of the Darkfallen'), +(71390,71341,0, 'Blood-Queen: Pact of the Darkfallen'); diff --git a/sql/updates/3.3.5a_old/10561_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10561_world_spell_script_names.sql new file mode 100644 index 00000000000..e6f6ba6295c --- /dev/null +++ b/sql/updates/3.3.5a_old/10561_world_spell_script_names.sql @@ -0,0 +1,14 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (70877,71474) AND `ScriptName`='spell_blood_queen_frenzied_bloodthirst'; +DELETE FROM `spell_script_names` WHERE `spell_id` IN (70946,71475,71476,71477) AND `ScriptName`='spell_blood_queen_vampiric_bite'; +DELETE FROM `spell_script_names` WHERE `spell_id` IN (71899,71900,71901,71902) AND `ScriptName`='spell_blood_queen_bloodbolt'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(70877, 'spell_blood_queen_frenzied_bloodthirst'), +(71474, 'spell_blood_queen_frenzied_bloodthirst'), +(70946, 'spell_blood_queen_vampiric_bite'), +(71475, 'spell_blood_queen_vampiric_bite'), +(71476, 'spell_blood_queen_vampiric_bite'), +(71477, 'spell_blood_queen_vampiric_bite'), +(71899, 'spell_blood_queen_bloodbolt'), +(71900, 'spell_blood_queen_bloodbolt'), +(71901, 'spell_blood_queen_bloodbolt'), +(71902, 'spell_blood_queen_bloodbolt'); diff --git a/sql/updates/3.3.5a_old/10563_world_scriptname.sql b/sql/updates/3.3.5a_old/10563_world_scriptname.sql new file mode 100644 index 00000000000..4184ee9f9f2 --- /dev/null +++ b/sql/updates/3.3.5a_old/10563_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_daegarn' WHERE `entry`=24151; \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10570_world_disables.sql b/sql/updates/3.3.5a_old/10570_world_disables.sql new file mode 100644 index 00000000000..a7e1a961d4a --- /dev/null +++ b/sql/updates/3.3.5a_old/10570_world_disables.sql @@ -0,0 +1,3 @@ +ALTER TABLE `disables` +ADD COLUMN params_0 varchar (255) NOT NULL default '' AFTER flags, +ADD COLUMN params_1 VARCHAR (255) NOT NULL default '' AFTER params_0; diff --git a/sql/updates/3.3.5a_old/10619_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10619_world_spell_script_names.sql new file mode 100644 index 00000000000..23f06a72125 --- /dev/null +++ b/sql/updates/3.3.5a_old/10619_world_spell_script_names.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=43874 AND `ScriptName`='spell_q11396_11399_force_shield_arcane_purple_x3'; +DELETE FROM `spell_script_names` WHERE `spell_id`=50133 AND `ScriptName`='spell_q11396_11399_scourging_crystal_controller'; +DELETE FROM `spell_script_names` WHERE `spell_id`=43882 AND `ScriptName`='spell_q11396_11399_scourging_crystal_controller_dummy'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(43874, 'spell_q11396_11399_force_shield_arcane_purple_x3'), +(43882, 'spell_q11396_11399_scourging_crystal_controller_dummy'), +(50133, 'spell_q11396_11399_scourging_crystal_controller'); diff --git a/sql/updates/3.3.5a_old/10623_world_spell_bonus_data.sql b/sql/updates/3.3.5a_old/10623_world_spell_bonus_data.sql new file mode 100644 index 00000000000..7db48d5bd92 --- /dev/null +++ b/sql/updates/3.3.5a_old/10623_world_spell_bonus_data.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_bonus_data` WHERE `entry` IN (66922); +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +(66922, 0, 0, 0, 0, 'Paladin - Flash of Light'); diff --git a/sql/updates/3.3.5a_old/10646_world_scriptname.sql b/sql/updates/3.3.5a_old/10646_world_scriptname.sql new file mode 100644 index 00000000000..f97cea87c6d --- /dev/null +++ b/sql/updates/3.3.5a_old/10646_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_bone_spike' WHERE `entry` IN (36619,38711,38712); diff --git a/sql/updates/3.3.5a_old/10654_characters_item_instance.sql b/sql/updates/3.3.5a_old/10654_characters_item_instance.sql new file mode 100644 index 00000000000..297250201cd --- /dev/null +++ b/sql/updates/3.3.5a_old/10654_characters_item_instance.sql @@ -0,0 +1,28 @@ +-- Add new column to item_instance table +ALTER TABLE `item_instance` ADD COLUMN `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `guid`; + +-- Set values for new column from corresponding columns in other tables +UPDATE item_instance ii, auctionhouse ah +SET ii.itemEntry = ah.item_template +WHERE ii.guid = ah.itemguid; + +UPDATE item_instance ii, character_inventory ci +SET ii.itemEntry = ci.item_template +WHERE ii.guid = ci.item; + +UPDATE item_instance ii, guild_bank_item gbi +SET ii.itemEntry = gbi.item_entry +WHERE ii.guid = gbi.item_guid; + +UPDATE item_instance ii, mail_items mi +SET ii.itemEntry = mi.item_template +WHERE ii.guid = mi.item_guid; + +-- Remove unnecessary columns +ALTER TABLE `auctionhouse` DROP COLUMN `item_template`; +ALTER TABLE `character_inventory` DROP COLUMN `item_template`; +ALTER TABLE `guild_bank_item` DROP COLUMN `item_entry`; +ALTER TABLE `mail_items` DROP COLUMN `item_template`; + +-- Delete orphan records (use at your own risk) +-- DELETE FROM item_instance WHERE itemEntry = 0; diff --git a/sql/updates/3.3.5a_old/10681_world_command.sql b/sql/updates/3.3.5a_old/10681_world_command.sql new file mode 100644 index 00000000000..b91b64ae152 --- /dev/null +++ b/sql/updates/3.3.5a_old/10681_world_command.sql @@ -0,0 +1,11 @@ +DELETE FROM `command` WHERE `name` IN ('reload access_requirement','reload achievement_criteria_data','reload achievement_reward','reload all achievement','reload all area','reload all eventai','reload auctions','reload mail_level_reward','reload smart_scripts'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('reload access_requirement',3,'Syntax: .reload access_requirement\nReload access_requirement table.'), +('reload achievement_criteria_data',3,'Syntax: .reload achievement_criteria_data\nReload achievement_criteria_data table.'), +('reload achievement_reward',3,'Syntax: .reload achievement_reward\nReload achievement_reward table.'), +('reload all achievement',3,'Syntax: .reload all achievement\r\n\r\nReload achievement_reward, achievement_criteria_data tables.'), +('reload all area',3,'Syntax: .reload all area\r\n\r\nReload areatrigger_teleport, areatrigger_tavern, game_graveyard_zone tables.'), +('reload all eventai',3,'Syntax: .reload all eventai\r\n\r\nReload creature_ai_scripts, creature_ai_summons, creature_ai_texts tables.'), +('reload auctions',3,'Syntax: .reload auctions\nReload dynamic data tables from the database.'), +('reload mail_level_reward',3,'Syntax: .reload mail_level_reward\nReload mail_level_reward table.'), +('reload smart_scripts',3,'Syntax: .reload smart_scripts\nReload smart_scripts table.'); diff --git a/sql/updates/3.3.5a_old/10733_world_spell_proc_event.sql b/sql/updates/3.3.5a_old/10733_world_spell_proc_event.sql new file mode 100644 index 00000000000..ed30cb35d1d --- /dev/null +++ b/sql/updates/3.3.5a_old/10733_world_spell_proc_event.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN ('15337','15338'); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +('15337','0','6','8396800','2','0','0','2','0','0','0'), -- Improved Spirit Tap (Rank 1) +('15338','0','6','8396800','2','0','0','2','0','0','0'); -- Improved Spirit Tap (Rank 2) diff --git a/sql/updates/3.3.5a_old/10736_world_scriptname.sql b/sql/updates/3.3.5a_old/10736_world_scriptname.sql new file mode 100644 index 00000000000..2aae66daeec --- /dev/null +++ b/sql/updates/3.3.5a_old/10736_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=28823; diff --git a/sql/updates/3.3.5a_old/10741_characters_character_aura.sql b/sql/updates/3.3.5a_old/10741_characters_character_aura.sql new file mode 100644 index 00000000000..d9afb213a76 --- /dev/null +++ b/sql/updates/3.3.5a_old/10741_characters_character_aura.sql @@ -0,0 +1,4 @@ +ALTER TABLE `character_aura` + ADD COLUMN `item_guid` bigint(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `caster_guid`, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`,`effect_mask`); diff --git a/sql/updates/3.3.5a_old/10765_world_scriptname.sql b/sql/updates/3.3.5a_old/10765_world_scriptname.sql new file mode 100644 index 00000000000..0c100dea663 --- /dev/null +++ b/sql/updates/3.3.5a_old/10765_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`= 'mob_rune_of_power' WHERE entry = 33705; diff --git a/sql/updates/3.3.5a_old/10765_world_spell_dbc.sql b/sql/updates/3.3.5a_old/10765_world_spell_dbc.sql new file mode 100644 index 00000000000..8a5846b5eec --- /dev/null +++ b/sql/updates/3.3.5a_old/10765_world_spell_dbc.sql @@ -0,0 +1,2 @@ +DELETE FROM spell_dbc WHERE `Id`=3617; +INSERT INTO spell_dbc (`Id`, `Effect1`, `Comment`) VALUES (3617, 1, 'NPC 32958 suicide spell'); diff --git a/sql/updates/3.3.5a_old/10777_characters_creature_respawn.sql b/sql/updates/3.3.5a_old/10777_characters_creature_respawn.sql new file mode 100644 index 00000000000..2289f201ac6 --- /dev/null +++ b/sql/updates/3.3.5a_old/10777_characters_creature_respawn.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_respawn` CHANGE COLUMN `respawntime` `respawntime` bigint(20) unsigned NOT NULL DEFAULT 0; diff --git a/sql/updates/3.3.5a_old/10777_characters_gameobject_respawn.sql b/sql/updates/3.3.5a_old/10777_characters_gameobject_respawn.sql new file mode 100644 index 00000000000..065586d0739 --- /dev/null +++ b/sql/updates/3.3.5a_old/10777_characters_gameobject_respawn.sql @@ -0,0 +1 @@ +ALTER TABLE `gameobject_respawn` CHANGE COLUMN `respawntime` `respawntime` bigint(20) unsigned NOT NULL DEFAULT 0; diff --git a/sql/updates/3.3.5a_old/10801_world_creature_linked_respawn.sql b/sql/updates/3.3.5a_old/10801_world_creature_linked_respawn.sql new file mode 100644 index 00000000000..4be48e58e84 --- /dev/null +++ b/sql/updates/3.3.5a_old/10801_world_creature_linked_respawn.sql @@ -0,0 +1,5 @@ +ALTER table `creature_linked_respawn` +RENAME TO `linked_respawn`, +ADD COLUMN linkType tinyint(3) UNSIGNED NOT NULL DEFAULT '0', +DROP PRIMARY KEY, +ADD PRIMARY KEY(`guid`, `linkType`); diff --git a/sql/updates/3.3.5a_old/10806_world_scriptname.sql b/sql/updates/3.3.5a_old/10806_world_scriptname.sql new file mode 100644 index 00000000000..d2f02595e72 --- /dev/null +++ b/sql/updates/3.3.5a_old/10806_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=3216; -- Neeru Fireblade \ No newline at end of file diff --git a/sql/updates/3.3.5a_old/10815_world_spell_script_names.sql b/sql/updates/3.3.5a_old/10815_world_spell_script_names.sql new file mode 100644 index 00000000000..ee041b30e0a --- /dev/null +++ b/sql/updates/3.3.5a_old/10815_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=67533 AND `ScriptName`='spell_item_red_rider_air_rifle'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(67533, 'spell_item_red_rider_air_rifle'); -- cgit v1.2.3