From daec9868d96501b69cdcc6d37e4900874ae96cd7 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Thu, 30 Oct 2008 11:32:10 -0500
Subject: [svn] Enable linked spells: cast spells/remove auras when spells
 casted/spells hitting/auras removed. Add new table "spell_linked_spell". Some
 illustrations provided in sql. Let trigger creature cast AOE spells when
 summoned. Illustration provided in sql. Let active creatures always visible
 if possible. (seems does not work for now, need to find out why)

--HG--
branch : trunk
---
 sql/updates/146_world.sql | 120 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 120 insertions(+)
 create mode 100644 sql/updates/146_world.sql

(limited to 'sql/updates/146_world.sql')

diff --git a/sql/updates/146_world.sql b/sql/updates/146_world.sql
new file mode 100644
index 00000000000..adb426336d6
--- /dev/null
+++ b/sql/updates/146_world.sql
@@ -0,0 +1,120 @@
+update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336;
+
+DROP TABLE IF EXISTS `spell_linked_spell`;
+CREATE TABLE `spell_linked_spell` (
+  `spell_trigger` int(10) NOT NULL,
+  `spell_effect` int(10) NOT NULL default '0',
+  `type` smallint(3) unsigned NOT NULL default '0',
+  `comment` text NOT NULL default '',
+  PRIMARY KEY (`spell_trigger`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (44008, 45265, 1, 'Static Disruption Visual');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (42052, 40118, 0, 'Volcanic Geyser Visual');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (-41914, 41915, 0, 'Summon Parasitic Shadowfiend\r\n');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (46021, 44852, 1, 'Spectral Realm Aura');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (-46021, 44867, 0, 'Spectral Exhaustion');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (-30410, 44032, 0, 'Manticron Cube Mind Exhaustion');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (-45934, 7, 0, 'Dark Fiend Suicide');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45661, 45665, 1, 'Encapsulate\r\n');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (40604, 40616, 1, 'Fel Rage Aura');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (40616, 41625, 1, 'Fel Rage Aura');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (41292, 42017, 1, 'Aura of Suffering');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (-41292, -42017, 0, 'Aura of Suffering');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45347, -45348, 1, 'Remove Flame Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45348, -45347, 1, 'Remove Dark Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45248, 45347, 1, 'Apply Dark Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45329, 45347, 1, 'Apply Dark Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45256, 45347, 1, 'Apply Dark Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45270, 45347, 1, 'Apply Dark Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45342, 45348, 1, 'Apply Flame Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (46771, 45348, 1, 'Apply Flame Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45271, 45347, 1, 'Apply Dark Touched');
+
+INSERT INTO spell_linked_spell
+   (`spell_trigger`, `spell_effect`, `type`, `comment`)
+VALUES
+   (45246, 45348, 1, 'Apply Flame Touched');
\ No newline at end of file
-- 
cgit v1.2.3

