From a4c223a3005a7057621c098aedc90e73b15b2b4d Mon Sep 17 00:00:00 2001 From: Kittnz Date: Mon, 28 Mar 2016 12:30:36 +0200 Subject: Pet/Misc: Implement Baby Blizzard Bear (cherry picked from commit 8d992a888c6618737e5324b4c424f0a5e324b531) --- sql/updates/world/2016_04_09_13_world_2016_03_27_00_world.sql | 3 --- sql/updates/world/2016_04_09_13_world_2016_03_28_00_world.sql | 2 -- sql/updates/world/2016_04_09_14_world_2016_03_27_00_world.sql | 3 +++ sql/updates/world/2016_04_09_15_world_2016_03_28_00_world.sql | 2 ++ sql/updates/world/2016_04_09_16_world_2016_03_28_01_world.sql | 1 + 5 files changed, 6 insertions(+), 5 deletions(-) delete mode 100644 sql/updates/world/2016_04_09_13_world_2016_03_27_00_world.sql delete mode 100644 sql/updates/world/2016_04_09_13_world_2016_03_28_00_world.sql create mode 100644 sql/updates/world/2016_04_09_14_world_2016_03_27_00_world.sql create mode 100644 sql/updates/world/2016_04_09_15_world_2016_03_28_00_world.sql create mode 100644 sql/updates/world/2016_04_09_16_world_2016_03_28_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2016_04_09_13_world_2016_03_27_00_world.sql b/sql/updates/world/2016_04_09_13_world_2016_03_27_00_world.sql deleted file mode 100644 index 9421881c88a..00000000000 --- a/sql/updates/world/2016_04_09_13_world_2016_03_27_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_clear_debuffs'; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(34098, 'spell_gen_clear_debuffs'); diff --git a/sql/updates/world/2016_04_09_13_world_2016_03_28_00_world.sql b/sql/updates/world/2016_04_09_13_world_2016_03_28_00_world.sql deleted file mode 100644 index b4a7e2d5a36..00000000000 --- a/sql/updates/world/2016_04_09_13_world_2016_03_28_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature` SET `spawndist`=0 WHERE `guid`=135230; diff --git a/sql/updates/world/2016_04_09_14_world_2016_03_27_00_world.sql b/sql/updates/world/2016_04_09_14_world_2016_03_27_00_world.sql new file mode 100644 index 00000000000..9421881c88a --- /dev/null +++ b/sql/updates/world/2016_04_09_14_world_2016_03_27_00_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_clear_debuffs'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(34098, 'spell_gen_clear_debuffs'); diff --git a/sql/updates/world/2016_04_09_15_world_2016_03_28_00_world.sql b/sql/updates/world/2016_04_09_15_world_2016_03_28_00_world.sql new file mode 100644 index 00000000000..b4a7e2d5a36 --- /dev/null +++ b/sql/updates/world/2016_04_09_15_world_2016_03_28_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature` SET `spawndist`=0 WHERE `guid`=135230; diff --git a/sql/updates/world/2016_04_09_16_world_2016_03_28_01_world.sql b/sql/updates/world/2016_04_09_16_world_2016_03_28_01_world.sql new file mode 100644 index 00000000000..b4a24b011b3 --- /dev/null +++ b/sql/updates/world/2016_04_09_16_world_2016_03_28_01_world.sql @@ -0,0 +1 @@ +UPDATE creature_template SET ScriptName = "npc_pet_gen_baby_blizzard_bear" WHERE entry = 32841; -- cgit v1.2.3