aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authortobmaps <spambot42@yandex.ru>2011-07-16 00:46:58 +0700
committertobmaps <spambot42@yandex.ru>2011-07-16 00:46:58 +0700
commitf7737f56604259af83cb836ab61b5bc13211231f (patch)
treea8717a285032a92f8acd3feb8b4e54350d103565 /sql
parent99530dcde269cbc36e896447803913a8a81da6bf (diff)
Core/Spells: Moved part of improved presences code to spell scripts
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_07_15_03_world_creature_template.sql5
-rw-r--r--sql/updates/world/2011_07_15_04_world_spell_script_names.sql4
2 files changed, 6 insertions, 3 deletions
diff --git a/sql/updates/world/2011_07_15_03_world_creature_template.sql b/sql/updates/world/2011_07_15_03_world_creature_template.sql
index 353dab27424..610cc916cfd 100644
--- a/sql/updates/world/2011_07_15_03_world_creature_template.sql
+++ b/sql/updates/world/2011_07_15_03_world_creature_template.sql
@@ -1,7 +1,6 @@
-- TODO: this list of vehicles isn't complete, need to find more vehicles with missing immunities
UPDATE `creature_template` SET `mechanic_immune_mask` = `mechanic_immune_mask` |
0x00000002| -- MECHANIC_DISORIENTED (Blind)
-0x00000004| -- MECHANIC_DISARM (Disarm)
0x00000008| -- MECHANIC_DISTRACT (Distract)
0x00000010| -- MECHANIC_FEAR (Fear, Psychic Scream)
0x00000020| -- MECHANIC_GRIP (Death Grip)
@@ -14,10 +13,10 @@ UPDATE `creature_template` SET `mechanic_immune_mask` = `mechanic_immune_mask` |
0x00002000| -- MECHANIC_KNOUCKOUT (Gouge, Blast Wave)
-- 0x00004000| -- MECHANIC_BLEED (Rend, Deep Wounds) - requires confirmation
0x00010000| -- MECHANIC_POLYMORPH (Polymorph)
-0x00040000| -- MECHANIC_SHIELD (Power word: Shield)
+0x00040000| -- MECHANIC_SHIELD (Power word: Shield) -- maybe unnecessary, spells shouldn't be even casted on vehicles
-- 0x00200000| -- MECHANIC_INFECTED (Frost Fever, Blood Plague) - requires confirmation
0x00800000| -- MECHANIC_HORROR (warlock's Death Coil)
-0x10000000| -- MECHANIC_IMMUNE_SHIELD (Hand of Protection)
+0x10000000| -- MECHANIC_IMMUNE_SHIELD (Hand of Protection) -- maybe unnecessary, spells shouldn't be even casted on vehicles
0x02000000| -- MECHANIC_INTERRUPT (Kick, Counterspell)
0x04000000 -- MECHANIC_DAZE (Dazed)
where entry IN (
diff --git a/sql/updates/world/2011_07_15_04_world_spell_script_names.sql b/sql/updates/world/2011_07_15_04_world_spell_script_names.sql
new file mode 100644
index 00000000000..7fa8011ded5
--- /dev/null
+++ b/sql/updates/world/2011_07_15_04_world_spell_script_names.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (50365,50391);
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(50365,'spell_dk_improved_blood_presence'),
+(50391,'spell_dk_improved_unholy_presence');