[svn] Fix blink. Bug: can blink through door. Author: GodsdoG.

Fix blessed recovery and martyrdom. Patch provided by Gomez.
setActive for Akama shade to see if this can fix the bug that it cannot find channeler.

--HG--
branch : trunk

3 files changed, 8 insertions, 37 deletions

diff --git a/sql/updates/195_world_serpent_shrine.sql b/sql/updates/195_world_serpent_shrine.sql
deleted file mode 100644
index 0d805778a4a..00000000000
--- a/sql/updates/195_world_serpent_shrine.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-UPDATE creature_template SET ScriptName = 'boss_leotheras_the_blind' WHERE entry = '21215';

-UPDATE creature_template SET ScriptName = 'boss_leotheras_the_blind_demonform' WHERE entry = '21875';

-UPDATE creature_template SET ScriptName = 'mob_greyheart_spellbinder' WHERE entry = '21806';

-UPDATE creature_template SET ScriptName = 'mob_inner_demon' WHERE entry = '21857';

-

-UPDATE creature_template SET ScriptName = 'mob_toxic_sporebat', speed = '1' WHERE entry = '22140';

-UPDATE creature_template SET modelid_A = '11686', modelid_H = '11686', flags_extra = '128' WHERE entry = '22207';

-

--- lurker

-UPDATE creature_model_info SET bounding_radius = '13', combat_reach = '20' WHERE modelid = '20216';

-UPDATE creature_template SET InhabitType = '3', ScriptName = 'boss_the_lurker_below' WHERE entry = '21865';

-UPDATE creature_template SET ScriptName = 'mob_coilfang_ambusher' WHERE entry = '21865';

-UPDATE creature_template SET ScriptName = 'mob_coilfang_guardian' WHERE entry = '21873';

diff --git a/sql/updates/211_world_blacktemple.sql b/sql/updates/211_world_blacktemple.sql
deleted file mode 100644
index 27aa83b9e4e..00000000000
--- a/sql/updates/211_world_blacktemple.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, -41917, 41126, -41376, 39908);

--- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39992, 39835, 1, 'Needle Spine');

-INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39835, 39968, 1, 'Needle Spine');

-INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41376, 41377, 0, 'Spite');

-INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (41126, 41131, 1, 'Flame Crash');

-INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41914, 41915, 0, 'Summon Parasitic Shadowfiend');

-INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41917, 41915, 0, 'Summon Parasitic Shadowfiend');

-INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39908, 40017, 1, 'Eye Blast');

-

-

--- molten_flame

-UPDATE creature_template SET spell1 = 40980, flags_extra = 128, speed = 1.0, scriptname = 'molten_flame' WHERE entry = 23095;

--- volcano

-UPDATE creature_template SET spell1 = 40117, flags_extra = 128, scriptname = '' WHERE entry = 23085;

--- flame crash

-update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336;

--- blaze

-update creature_template set spell1 = 40610, flags_extra = 128, scriptname = '' where entry = 23259;

--- glaive

-update creature_template set scriptname = 'mob_blade_of_azzinoth' where entry = 22996;

--- parasitic shadowfiend

-update creature_template set scriptname = 'mob_parasitic_shadowfiend' where entry = 23498;

--- Maiev

-update creature_template set minlevel = 73, maxlevel = 73, minhealth = 500000, maxhealth = 500000, mindmg = 3000, maxdmg = 4000 where entry = 23197;
\ No newline at end of file
diff --git a/sql/updates/230_world.sql b/sql/updates/230_world.sql
new file mode 100644
index 00000000000..a74728f9a24
--- /dev/null
+++ b/sql/updates/230_world.sql
@@ -0,0 +1,8 @@
+-- Blessed Recovery

+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `Category`, `SkillID`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `ppmRate`) VALUES (27811, 0, 0, 0, 0, 0, 8396800, 0);

+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `Category`, `SkillID`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `ppmRate`) VALUES (27815, 0, 0, 0, 0, 0, 8396800, 0);

+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `Category`, `SkillID`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `ppmRate`) VALUES (27816, 0, 0, 0, 0, 0, 8396800, 0);

+

+-- Martyrdom

+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `Category`, `SkillID`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `ppmRate`) VALUES (14774, 0, 0, 0, 0, 0, 8396800, 0);

+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `Category`, `SkillID`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `ppmRate`) VALUES (14531, 0, 0, 0, 0, 0, 8396800, 0);
\ No newline at end of file