diff options
| author | megamage <none@none> | 2008-10-30 09:25:38 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2008-10-30 09:25:38 -0500 |
| commit | f2f73ff19f0a3eba028cf1b0a615988ef3218b3b (patch) | |
| tree | ecbfe2c07ff0da0efbbbb6d687690d1135b2cf73 /sql/updates | |
| parent | a1131cdb21370baaaa5212707e78af5834874395 (diff) | |
[svn] Update magisters terrace script. Patch provided by streetrat.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/145_world_scripts.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/145_world_scripts.sql b/sql/updates/145_world_scripts.sql new file mode 100644 index 00000000000..17704a3daa9 --- /dev/null +++ b/sql/updates/145_world_scripts.sql @@ -0,0 +1,27 @@ +DELETE FROM gameobject_template WHERE `entry` IN (187578, 188173);
+INSERT INTO gameobject_template () VALUES (187578, 10, 4891, 'Scrying Orb', '', 0, 0, 2.16851, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'go_movie_orb');
+INSERT INTO gameobject_template () VALUES (188173, 10, 7161, 'Escape to the Isle of Quel\'Danas', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'go_kael_orb');
+
+DELETE FROM spell_script_target WHERE `entry` IN (44320, 44321);
+INSERT INTO spell_script_target () VALUES (44320, 1, 24723);
+INSERT INTO spell_script_target () VALUES (44321, 1, 24723);
+
+UPDATE creature_template SET modelid_A = '17612' WHERE entry = '24745';
+UPDATE creature_template SET modelid_H = '17612' WHERE entry = '24745';
+
+UPDATE `creature_template` SET `minhealth` = '6900' WHERE `entry` = 24675;
+UPDATE `creature_template` SET `maxhealth` = '6900' WHERE `entry` = 24675;
+
+UPDATE `creature_template` SET `minlevel` = '70' WHERE `entry` = 24708;
+UPDATE `creature_template` SET `maxlevel` = '70' WHERE `entry` = 24708;
+
+UPDATE `creature_template` SET `minlevel` = '70' WHERE `entry` = 24666;
+UPDATE `creature_template` SET `maxlevel` = '70' WHERE `entry` = 24666;
+
+UPDATE `creature_template` SET `scale` = '0.5' WHERE `entry` = 24708;
+
+UPDATE `gameobject_template` SET `ScriptName` = 'go_kael_orb' WHERE `entry` = 188173;
+UPDATE `gameobject_template` SET `ScriptName` = 'go_movie_orb' WHERE `entry` = 187578;
+
+update creature_template SET spell1=6474 WHERE entry=22487;
+update creature_template SET spell1=3600 WHERE entry=22486;
\ No newline at end of file |