From f29dd0794be2165a2115ebce9eef54a8d81884ff Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Sat, 10 Sep 2016 15:30:33 +0200 Subject: DB/Creature: remove wrong spell from NPC "Venture Co. Saboteur" and add correct one. They have aura "Torch Burn", they don't cast "Thorns". From sniffs. (cherry picked from commit adb2d8424bf4922f61f28a5a5ce69b6c4346a0b4) --- sql/updates/world/master/2017_02_26_08_world_2016_09_10_04_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2017_02_26_08_world_2016_09_10_04_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2017_02_26_08_world_2016_09_10_04_world.sql b/sql/updates/world/master/2017_02_26_08_world_2016_09_10_04_world.sql new file mode 100644 index 00000000000..2ca196d5c42 --- /dev/null +++ b/sql/updates/world/master/2017_02_26_08_world_2016_09_10_04_world.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template_addon` SET `auras`="5680" WHERE `entry`=17278; +UPDATE `creature_template` SET `AIName`="" WHERE `entry`=17278; +DELETE FROM `smart_scripts` WHERE `entryorguid`=17278; -- cgit v1.2.3