From c5f30751ef74e2aad8b776ff0341ec5c0965ecb9 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 17 Jan 2016 03:38:05 +0100 Subject: DB/Creature: Add Stealth Detection for Steamvaults Creatures By @Saben65 Closes #16185 (cherry picked from commit bf71f51fba8902abb0588ccc6bf0f425c3604460) --- sql/updates/world/2016_01_16_04_world.sql | 3 --- sql/updates/world/2016_01_17_01_world.sql | 9 +++++++++ sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql | 3 +++ 3 files changed, 12 insertions(+), 3 deletions(-) delete mode 100644 sql/updates/world/2016_01_16_04_world.sql create mode 100644 sql/updates/world/2016_01_17_01_world.sql create mode 100644 sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/2016_01_16_04_world.sql b/sql/updates/world/2016_01_16_04_world.sql deleted file mode 100644 index a6bb7ae185c..00000000000 --- a/sql/updates/world/2016_01_16_04_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=53651; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(53651, 'spell_pal_light_s_beacon'); diff --git a/sql/updates/world/2016_01_17_01_world.sql b/sql/updates/world/2016_01_17_01_world.sql new file mode 100644 index 00000000000..8e5bcd22a07 --- /dev/null +++ b/sql/updates/world/2016_01_17_01_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `creature_template_addon` WHERE `entry` IN (21694,21914,17796,17797,20629,20630); +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(21694,0,0x0,0x1,'18950'), -- 21694 - 18950 +(21914,0,0x0,0x1,'18950'), -- 21914 - 18950 +(17796,0,0x0,0x1,'18950'), -- 17796 - 18950 +(17797,0,0x0,0x1,'18950'), -- 17797 - 18950 +(20629,0,0x0,0x1,'18950'), -- 20629 - 18950 +(20630,0,0x0,0x1,'18950'); -- 20630 - 18950 diff --git a/sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql b/sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql new file mode 100644 index 00000000000..a6bb7ae185c --- /dev/null +++ b/sql/updates/world/2016_03_22_13_world_2016_01_16_04_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=53651; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(53651, 'spell_pal_light_s_beacon'); -- cgit v1.2.3