From fd7a40ca97ccb642080bfb35edf4ac95e9fdab8e Mon Sep 17 00:00:00 2001
From: Aokromes <Aokromes@users.noreply.github.com>
Date: Sun, 4 May 2014 14:55:06 +0200
Subject: DB/Creature: Remove more incorrect trigger flags

By dr-j, closes #11995
Closes #7744
---
 sql/updates/world/2014_05_04_03_world_creature_text.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/2014_05_04_03_world_creature_text.sql

(limited to 'sql')

diff --git a/sql/updates/world/2014_05_04_03_world_creature_text.sql b/sql/updates/world/2014_05_04_03_world_creature_text.sql
new file mode 100644
index 00000000000..68375879d8e
--- /dev/null
+++ b/sql/updates/world/2014_05_04_03_world_creature_text.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `flags_extra`=0 WHERE  `entry`IN(28455,28299,28459,28300,28456,28457,28458,28462,28454,28460,26468,26469,26470,34735);
+UPDATE `creature_template` SET `mechanic_immune_mask`=2048 WHERE `entry` IN (29307,29573)
-- 
cgit v1.2.3