[svn] Fix a bug that players cannot hear others talking.

Provide script support for type 10 gameobject.
Add some missing script sql.

--HG--
branch : trunk

3 files changed, 39 insertions, 0 deletions

diff --git a/sql/updates/230_world_blacktemple.sql b/sql/updates/230_world_blacktemple.sql
new file mode 100644
index 00000000000..951c1f4180d
--- /dev/null
+++ b/sql/updates/230_world_blacktemple.sql
@@ -0,0 +1,25 @@
+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');

+

+-- spine

+update gameobject_template set scriptname = 'go_najentus_spine' where entry = 185584;

+-- 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_scripts.sql b/sql/updates/230_world_scripts.sql
new file mode 100644
index 00000000000..34d3ee5707f
--- /dev/null
+++ b/sql/updates/230_world_scripts.sql
@@ -0,0 +1 @@
+update gameobject_template set scriptname = 'go_gilded_brazier' where entry = 181956;
\ No newline at end of file
diff --git a/sql/updates/230_world_serpent_shrine.sql b/sql/updates/230_world_serpent_shrine.sql
new file mode 100644
index 00000000000..2472dfa1724
--- /dev/null
+++ b/sql/updates/230_world_serpent_shrine.sql
@@ -0,0 +1,13 @@
+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 = '21217';

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

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