aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2012-01-13 13:25:09 -0800
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2012-01-13 13:25:09 -0800
commit4479c7285b1b5761a1bb827e14c5ece066342de9 (patch)
tree25ee82e895476e798f99a43f4bd1d1cfe42ff393 /sql
parentb878e68f8aea64ac5071aac1d319aa968994cd05 (diff)
parentfdef33ed66a3a281c4b002d9d54323e419e24cb0 (diff)
Merge pull request #4805 from Venugh/texts
Core/Scripts: convert script_text to creature_texts
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_01_13_04_world_creature_texts.sql18
-rw-r--r--sql/updates/world/2012_01_13_05_world_creature_texts.sql13
2 files changed, 31 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_13_04_world_creature_texts.sql b/sql/updates/world/2012_01_13_04_world_creature_texts.sql
new file mode 100644
index 00000000000..317f4c862b3
--- /dev/null
+++ b/sql/updates/world/2012_01_13_04_world_creature_texts.sql
@@ -0,0 +1,18 @@
+-- Remove old script text for npc_millhouse_manastorm
+DELETE FROM `script_texts` WHERE `entry` IN (-1552010, -1552022);
+
+-- Add new creature_text for Millhouse ManaStorm
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(20977, 0, 0, 'Where in Bonzo\'\'s brass buttons am I? And who are-- yaaghh, that\'\'s one mother of a headache!', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 1, 0, '"Lowly"? I don\'\'t care who you are friend, no one refers to the mighty Millhouse Manastorm as "Lowly"! I have no idea what goes on here, but I will gladly join your fight against this impudent imbecile! Prepare to defend yourself, cretin!', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 2, 0, 'I just need to get some things ready first. You guys go ahead and get started. I need to summon up some water...', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 3, 0, 'Fantastic! Next, some protective spells. Yes! Now we\'\'re cookin\'\'', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 4, 0, 'And of course i\'\'ll need some mana. You guys are gonna love this, just wait.', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 5, 0, 'Aaalllriiiight!! Who ordered up an extra large can of whoop-ass?', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 6, 0, 'I didn\'\'t even break a sweat on that one.', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 6, 1, 'You guys, feel free to jump in anytime.', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 7, 0, 'I\'\'m gonna light you up, sweet cheeks!', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 8, 0, 'Ice, ice, baby!', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 9, 0, 'Heal me! Oh, for the love of all that is holy, HEAL me! I\'\'m dying!', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 10, 0, 'You\'\'ll be hearing from my lawyer...', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm'),
+(20977, 11, 0, 'Who\'\'s bad? Who\'\'s bad? That\'\'s right: we bad!', 0, 0, 100, 0, 0, 0, 'Millhouse Manastorm');
diff --git a/sql/updates/world/2012_01_13_05_world_creature_texts.sql b/sql/updates/world/2012_01_13_05_world_creature_texts.sql
new file mode 100644
index 00000000000..584a81167a3
--- /dev/null
+++ b/sql/updates/world/2012_01_13_05_world_creature_texts.sql
@@ -0,0 +1,13 @@
+-- Remove old script text for npc_warden_mellichar
+DELETE FROM `script_texts` WHERE `entry` IN (-1552023, -1552030);
+
+-- Add new creature_text for Warden Mellichar
+(20904, 0, 0, 'I knew the prince would be angry but, I... I have not been myself. I had to let them out! The great one speaks to me, you see. Wait--outsiders. Kael\'\'thas did not send you! Good... I\'\'ll just tell the prince you released the prisoners!', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 1, 0, 'The naaru kept some of the most dangerous beings in existence here in these cells. Let me introduce you to another...', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 2, 0, 'Yes, yes... another! Your will is mine!', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 3, 0, 'Behold another terrifying creature of incomprehensible power!', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 4, 0, 'What is this? A lowly gnome? I will do better, O\'\'great one.', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 5, 0, 'Anarchy! Bedlam! Oh, you are so wise! Yes, I see it now, of course!', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 6, 0, 'One final cell remains. Yes, O\'\'great one, right away!', 0, 0, 100, 0, 0, 0, 'Warden Mellichar'),
+(20904, 7, 0, 'Welcome, O\'\'great one. I am your humble servant.', 0, 0, 100, 0, 0, 0, 'Warden Mellichar');
+