From 9a2d86f6ae1c5725bd3ffef6ccdf1116b614d106 Mon Sep 17 00:00:00 2001
From: Vincent-Michael <Vincent_Michael@gmx.de>
Date: Sat, 19 Jul 2014 02:43:15 +0200
Subject: Core/Spells: Fix Quest "The Emissary"

---
 sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql

(limited to 'sql')

diff --git a/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql b/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql
new file mode 100644
index 00000000000..181742b2497
--- /dev/null
+++ b/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_custom_attr` WHERE `entry`=49882
+INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES
+(49882, 32768);
-- 
cgit v1.2.3


From 8b48aad6ad5eaa99ac93ad8b512e01ffb01045df Mon Sep 17 00:00:00 2001
From: Aokromes <Aokromes@users.noreply.github.com>
Date: Sat, 19 Jul 2014 04:55:18 +0200
Subject: Update 2014_07_19_00_world_spell_custom_attr.sql

---
 sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql b/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql
index 181742b2497..fee4f9cc077 100644
--- a/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql
+++ b/sql/updates/world/2014_07_19_00_world_spell_custom_attr.sql
@@ -1,3 +1,3 @@
-DELETE FROM `spell_custom_attr` WHERE `entry`=49882
+DELETE FROM `spell_custom_attr` WHERE `entry`=49882;
 INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES
 (49882, 32768);
-- 
cgit v1.2.3


From 7f287b6d50b5dc01940e16e198498d8808562238 Mon Sep 17 00:00:00 2001
From: tyraela <>
Date: Sat, 19 Jul 2014 13:09:33 +0200
Subject: DB/Creature: Remove wrong aura on Monstrous Kaliri Close #12563

---
 .../world/2014_07_19_00_world_creature_misc.sql      | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 sql/updates/world/2014_07_19_00_world_creature_misc.sql

(limited to 'sql')

diff --git a/sql/updates/world/2014_07_19_00_world_creature_misc.sql b/sql/updates/world/2014_07_19_00_world_creature_misc.sql
new file mode 100644
index 00000000000..1f8eba3d33c
--- /dev/null
+++ b/sql/updates/world/2014_07_19_00_world_creature_misc.sql
@@ -0,0 +1,20 @@
+DELETE FROM `creature_addon` WHERE `guid` IN (
+132567,
+132568,
+132566,
+132564,
+132565,
+132553,
+132554,
+132555,
+132556,
+132557,
+132558,
+132559,
+132560,
+132561,
+132562,
+132563);
+DELETE FROM `creature_template_addon` WHERE `entry`=23051;
+INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
+(23051, 0, 0x0, 0x1, '');
-- 
cgit v1.2.3