From 29deb56877f57d1fecd24fe80647cc483ab805ed Mon Sep 17 00:00:00 2001
From: ZxBiohazardZx <zxbiohazardzx@gmail.com>
Date: Fri, 18 Jan 2013 23:31:35 +0100
Subject: DB/Creatures:  cleaning up creature_template_addon, removed auras
 that where also/already added by SAI, should reduce some runtime errors

---
 ...2013_01_18_01_world_creature_template_addon.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 sql/updates/world/2013_01_18_01_world_creature_template_addon.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2013_01_18_01_world_creature_template_addon.sql b/sql/updates/world/2013_01_18_01_world_creature_template_addon.sql
new file mode 100644
index 00000000000..e3d6feaeecd
--- /dev/null
+++ b/sql/updates/world/2013_01_18_01_world_creature_template_addon.sql
@@ -0,0 +1,22 @@
+-- remove auras that are already applied in SAI
+UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` IN (
+215, -- Defias Night Runner
+579, -- Shadowhide Assassin
+938, -- Kurzen Commando
+1040, -- Fen Creeper
+8550, -- Shadowmage
+9299, -- Gaeriyan
+10414, -- Patchwork Horror
+10426, -- Crimson Inquisitor
+10471, -- Scholomance Acolyte
+11885, -- Blighthound
+16017, -- Patchwork Golem
+16375, -- Sewage Slime
+21080, -- Dormant Infernal
+22853, -- Illidari Defiler
+24818, -- Anvilrage Taskmaster
+25596, -- Infected Kodo Beast
+25781, -- Oil Pool
+26624, -- Wretched Belcher
+26782, -- Crystalline Keeper
+28161); -- Chicken Escapee
-- 
cgit v1.2.3