aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-10 15:30:33 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-26 15:58:05 +0100
commitf29dd0794be2165a2115ebce9eef54a8d81884ff (patch)
treeec616847b9cc205905d97b199e1d04e6ee8ef102
parente9b931e29770189bafb9e6c062f478f3c47c8a48 (diff)
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)
-rw-r--r--sql/updates/world/master/2017_02_26_08_world_2016_09_10_04_world.sql4
1 files changed, 4 insertions, 0 deletions
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;