From 379bc3682cd3c5635bac2f30165539d89102c0c4 Mon Sep 17 00:00:00 2001 From: megamage Date: Wed, 12 Nov 2008 16:21:08 -0600 Subject: [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 --- sql/updates/230_world_blacktemple.sql | 25 +++++++++++++++++++++++++ sql/updates/230_world_scripts.sql | 1 + sql/updates/230_world_serpent_shrine.sql | 13 +++++++++++++ 3 files changed, 39 insertions(+) create mode 100644 sql/updates/230_world_blacktemple.sql create mode 100644 sql/updates/230_world_scripts.sql create mode 100644 sql/updates/230_world_serpent_shrine.sql (limited to 'sql') 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'; -- cgit v1.2.3