aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-10-30 18:01:41 +0100
committerKillyana <morphone1@gmail.com>2015-10-30 18:01:41 +0100
commitca1581057554fda3d9cfa1149fc08a36ea566ac5 (patch)
tree1d12aed82501b450aea27f65c60c039ea21e0e20
parentd26bc41a3e4887df7abb21ff2133cf144b08df8b (diff)
DB/Creature: Fix Spell Click for Dead Mage Hunter
Replace ride spell for Flamebringer by the correct one
-rw-r--r--sql/updates/world/2015_10_30_32_world.sql8
1 files changed, 8 insertions, 0 deletions
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");