diff options
| author | megamage <none@none> | 2008-10-30 11:32:10 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2008-10-30 11:32:10 -0500 |
| commit | daec9868d96501b69cdcc6d37e4900874ae96cd7 (patch) | |
| tree | d3872ba78e27fdd078f78d9b96cc5ec0a6e8b92e /sql/updates/146_world.sql | |
| parent | f2f73ff19f0a3eba028cf1b0a615988ef3218b3b (diff) | |
[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
Diffstat (limited to 'sql/updates/146_world.sql')
| -rw-r--r-- | sql/updates/146_world.sql | 120 |
1 files changed, 120 insertions, 0 deletions
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 |