From ca1581057554fda3d9cfa1149fc08a36ea566ac5 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Fri, 30 Oct 2015 18:01:41 +0100
Subject: DB/Creature: Fix Spell Click for Dead Mage Hunter

Replace ride spell for Flamebringer by the correct one
---
 sql/updates/world/2015_10_30_32_world.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/updates/world/2015_10_30_32_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/2015_10_30_32_world.sql b/sql/updates/world/2015_10_30_32_world.sql
new file mode 100644
index 00000000000..208b482c33d
--- /dev/null
+++ b/sql/updates/world/2015_10_30_32_world.sql
@@ -0,0 +1,8 @@
+--
+UPDATE `npc_spellclick_spells` SET `cast_flags`=1 WHERE `npc_entry`=26477 AND `spell_id`=61832;
+
+UPDATE `smart_scripts` SET `action_param1`=48600 WHERE `entryorguid`=27292 AND `source_type`=0 AND `id`=3;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=48600;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES
+(13, 1, 48600, 31, 0, 3, 27292, "Ride Flamebringer effect only on Flamebringer");
-- 
cgit v1.2.3