aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorkrofna <krofnica996@gmail.com>2012-11-19 00:37:43 +0000
committerNay <dnpd.dd@gmail.com>2012-11-19 00:37:43 +0000
commitaea5fec30dd2b2f5d1709e11949913764dcdae35 (patch)
tree1cf3b8a83feb8700092d4c3ebcd1a1b94434fb3c /sql
parent45b07f09311b2ab1a4cfad67db0c050d2270af66 (diff)
Scripts/AQ: Implement Ossirian the Unscarred
Fix yell on kurinaxx death Warning fix Closes #8254 Signed-off-by: Nay <dnpd.dd@gmail.com>
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_11_18_01_world_creature_text.sql15
-rw-r--r--sql/updates/world/2012_11_18_01_world_gameobject.sql3
2 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/2012_11_18_01_world_creature_text.sql b/sql/updates/world/2012_11_18_01_world_creature_text.sql
new file mode 100644
index 00000000000..5d8da97f1f0
--- /dev/null
+++ b/sql/updates/world/2012_11_18_01_world_creature_text.sql
@@ -0,0 +1,15 @@
+-- Ossirian the Unscarred
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1509027 AND -1509018;
+DELETE FROM `creature_text` WHERE `entry`=15339;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(15339, 0, 0, 'I am rejuvinated!', 14, 0, 100, 0, 0, 8593, 'SAY_SUPREME_1'),
+(15339, 0, 1, 'My powers are renewed!', 14, 0, 100, 0, 0, 8595, 'SAY_SUPREME_2'),
+(15339, 0, 2, 'My powers return!', 14, 0, 100, 0, 0, 8596, 'SAY_SUPREME_3'),
+(15339, 1, 0, 'Protect the city at all costs!', 14, 0, 100, 0, 0, 8597, 'SAY_INTRO_1'),
+(15339, 1, 1, 'To your posts. Defend the city.', 14, 0, 100, 0, 0, 8600, 'SAY_INTRO_2'),
+(15339, 1, 2, 'Tresspassers will be terminated.', 14, 0, 100, 0, 0, 8601, 'SAY_INTRO_3'),
+(15339, 2, 0, 'Sands of the desert rise and block out the sun!', 14, 0, 100, 0, 0, 8598, 'SAY_AGGRO'),
+(15339, 3, 0, 'You are terminated.', 14, 0, 100, 0, 0, 8602, 'SAY_SLAY'),
+(15339, 4, 0, 'I...have...failed.', 14, 0, 100, 0, 0, 8594, 'SAY_DEATH'),
+(15339, 5, 0, 'The walls have been breached!', 14, 0, 100, 0, 0, 8599, 'SAY_KURINAXX_DEATH');
+
diff --git a/sql/updates/world/2012_11_18_01_world_gameobject.sql b/sql/updates/world/2012_11_18_01_world_gameobject.sql
new file mode 100644
index 00000000000..d82f9a07e7e
--- /dev/null
+++ b/sql/updates/world/2012_11_18_01_world_gameobject.sql
@@ -0,0 +1,3 @@
+-- Ossirian Crystal
+UPDATE `gameobject_template` SET `ScriptName`='go_ossirian_crystal' WHERE `entry`=180619;
+