diff options
| author | click <clickvd@gonnamakeyou.com> | 2011-05-30 04:12:07 +0200 |
|---|---|---|
| committer | click <clickvd@gonnamakeyou.com> | 2011-05-30 04:12:07 +0200 |
| commit | 7e49fa92f09eb04e60836f3688b43e9c71662dad (patch) | |
| tree | c9b92b20bbbddbbb2b8ddba0e4110fd18d09647a /sql | |
| parent | 76413ae661efc911a555ae6c6b15c988fb2bd9dd (diff) | |
Scripts/World: Update WorldBoss scripts for the Emerald Dragons (Ysondre, Emeriss, Taerar and Lethon) + create base "Emerald Dragon" AI
(They are still WIP, so do not consider them "workable" unless you are willing to report issues).
Diffstat (limited to 'sql')
3 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/2011_05_30_00_world_creature_template.sql b/sql/updates/world/2011_05_30_00_world_creature_template.sql new file mode 100644 index 00000000000..aecce0022e2 --- /dev/null +++ b/sql/updates/world/2011_05_30_00_world_creature_template.sql @@ -0,0 +1,8 @@ +UPDATE `creature_template` SET `ScriptName`='npc_dream_fog' WHERE `entry`=15224; +UPDATE `creature_template` SET `ScriptName`='boss_ysondre' WHERE `entry`=14887; +UPDATE `creature_template` SET `ScriptName`='npc_demented_druid' WHERE `entry`=15260; +UPDATE `creature_template` SET `ScriptName`='boss_ysondre' WHERE `entry`=14887; +UPDATE `creature_template` SET `ScriptName`='boss_lethon' WHERE `entry`=14888; +UPDATE `creature_template` SET `ScriptName`='boss_emeriss' WHERE `entry`=14889; +UPDATE `creature_template` SET `ScriptName`='boss_taerar' WHERE `entry`=14890; +UPDATE `creature_template` SET `ScriptName`='boss_shade_of_taerar' WHERE `entry`=15302; diff --git a/sql/updates/world/2011_05_30_00_world_creature_text.sql b/sql/updates/world/2011_05_30_00_world_creature_text.sql new file mode 100644 index 00000000000..b2ac3d63048 --- /dev/null +++ b/sql/updates/world/2011_05_30_00_world_creature_text.sql @@ -0,0 +1,10 @@ +DELETE FROM `creature_text` WHERE `entry` IN (14887, 14888, 14889, 14890); +INSERT INTO `creature_text`(`entry`,`groupid`,`text`,`type`,`comment`) VALUES +(14887,0,'The strands of LIFE have been severed! The Dreamers must be avenged!',14,'Ysondre - SAY_YSONDRE_AGGRO'), +(14887,1,'Come forth, ye Dreamers - and claim your vengeance!',14,'Ysondre - SAY_YSONDRE_SUMMON_DRUIDS'), +(14888,0,'I can sense the SHADOW on your hearts. There can be no rest for the wicked!',14,'Lethon - SAY_LETHON_AGGRO'), +(14888,1,'Your wicked souls shall feed my power!',14,'Lethon - SAY_LETHON_DRAW_SPIRIT'), +(14889,0,'Hope is a DISEASE of the soul! This land shall wither and die!',14,'Emeriss - SAY_EMERISS_AGGRO'), +(14889,1,'Taste your world\'s corruption!',14,'Emeriss - SAY_EMERISS_CAST_CORRUPTION'), +(14890,0,'Peace is but a fleeting dream! Let the NIGHTMARE reign!',14,'Taerar - SAY_TAERAR_AGGRO'), +(14890,1,'Children of Madness - I release you upon this world!',14,'Taerar - SAY_TAERAR_SUMMON_SHADE'); diff --git a/sql/updates/world/2011_05_30_00_world_script_texts.sql b/sql/updates/world/2011_05_30_00_world_script_texts.sql new file mode 100644 index 00000000000..9bb1f482737 --- /dev/null +++ b/sql/updates/world/2011_05_30_00_world_script_texts.sql @@ -0,0 +1,9 @@ +-- Delete old text-assignment for Ysondre +DELETE FROM `script_texts` WHERE `entry`='-1000360'; +DELETE FROM `script_texts` WHERE `entry`='-1000361'; +-- Delete old text-assignment for Taerar +DELETE FROM `script_texts` WHERE `entry`='-1000399'; +DELETE FROM `script_texts` WHERE `entry`='-1000400'; +-- Delete old text-assignment for Emeriss +DELETE FROM `script_texts` WHERE `entry`='-1000401'; +DELETE FROM `script_texts` WHERE `entry`='-1000402'; |