aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-10 15:30:33 +0200
committerGitHub <noreply@github.com>2016-09-10 15:30:33 +0200
commitadb2d8424bf4922f61f28a5a5ce69b6c4346a0b4 (patch)
treecd8c08ccf8fd23b0f27a9ca633e071dbc2c7749f
parent1b7eebc7ba211723fedcc38ac2adc9223ec2afad (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.
-rw-r--r--sql/updates/world/3.3.5/2016_09_10_04_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_09_10_04_world.sql b/sql/updates/world/3.3.5/2016_09_10_04_world.sql
new file mode 100644
index 00000000000..2ca196d5c42
--- /dev/null
+++ b/sql/updates/world/3.3.5/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;