diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_11_18_01_world_creature_text.sql | 15 | ||||
| -rw-r--r-- | sql/updates/world/2012_11_18_01_world_gameobject.sql | 3 |
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; + |