From 990bef2bfff22cafd223141dae8b407bb9a6b48d Mon Sep 17 00:00:00 2001 From: Nay Date: Sun, 30 Sep 2012 16:34:06 +0100 Subject: SQL: Rename SQL merged in PR --- sql/updates/world/2012_09_30_02_world_creature_text.sql | 12 ++++++++++++ sql/updates/world/2012_XX_XX_XXX_world_creature_text.sql | 13 ------------- 2 files changed, 12 insertions(+), 13 deletions(-) create mode 100644 sql/updates/world/2012_09_30_02_world_creature_text.sql delete mode 100644 sql/updates/world/2012_XX_XX_XXX_world_creature_text.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_09_30_02_world_creature_text.sql b/sql/updates/world/2012_09_30_02_world_creature_text.sql new file mode 100644 index 00000000000..08f27772c0d --- /dev/null +++ b/sql/updates/world/2012_09_30_02_world_creature_text.sql @@ -0,0 +1,12 @@ +-- AzjolNerub/Ahnkahet/Herald Volazj +DELETE FROM `script_texts` WHERE `entry` BETWEEN -1619036 AND -1619030; +DELETE FROM `creature_text` WHERE `entry`=29311; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(29311,0,0, 'Shgla''yos plahf mh''naus.', 14,0,100,0,0,14043, 'SAY_AGGRO_1'), +(29311,0,1, 'They who dine on lost souls know only hunger.', 15, 0, 100, 0, 0, 14043, 'SAY_AGGRO_2'), +(29311,1,0, 'Ywaq puul skshgn: on''ma yeh''glu zuq.', 14,0,100,0,0,SOUND, 'SAY_SLAY_1'), +(29311,1,1, 'Ywaq ma phgwa''cul hnakf.',14,0,100,0,0,SOUND, 'SAY_SLAY_2'), +(29311,1,2, 'Ywaq maq oou; ywaq maq ssaggh. Ywaq ma shg''fhn.',14,0,100,0,0,SOUND, 'SAY_SLAY_3'), +(29311,2,0, 'Iilth vwah, uhn''agth fhssh za.', 14, 0, 100, 0, 0, 14048, 'SAY_DEATH_1'), +(29311,2,1, 'Where one falls, many shall take its place.', 15, 0, 100, 0, 0, 14048, 'SAY_DEATH_2'), +(29311,3,0, 'Gul''kafh an''shel. Yoq''al shn ky ywaq nuul.', 14, 0, 100, 0, 0, 14044, 'SAY_PHASE'); diff --git a/sql/updates/world/2012_XX_XX_XXX_world_creature_text.sql b/sql/updates/world/2012_XX_XX_XXX_world_creature_text.sql deleted file mode 100644 index f748696ab33..00000000000 --- a/sql/updates/world/2012_XX_XX_XXX_world_creature_text.sql +++ /dev/null @@ -1,13 +0,0 @@ --- AzjolNerub/Ahnkahet/Herald Volazj -DELETE FROM `script_texts` WHERE `entry` BETWEEN -1619036 AND -1619030; -DELETE FROM `creature_text` WHERE `entry`=29311; -INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES -(29311,0,0, 'Shgla''yos plahf mh''naus.', 14,0,100,0,0,14043, 'SAY_AGGRO_1'), -(29311,0,1, 'They who dine on lost souls know only hunger.', 15, 0, 100, 0, 0, 14043, 'SAY_AGGRO_2'), -(29311,1,0, 'Ywaq puul skshgn: on''ma yeh''glu zuq.', 14,0,100,0,0,SOUND, 'SAY_SLAY_1'), -(29311,1,1, 'Ywaq ma phgwa''cul hnakf.',14,0,100,0,0,SOUND, 'SAY_SLAY_2'), -(29311,1,2, 'Ywaq maq oou; ywaq maq ssaggh. Ywaq ma shg''fhn.',14,0,100,0,0,SOUND, 'SAY_SLAY_3'), -(29311,2,0, 'Iilth vwah, uhn''agth fhssh za.', 14, 0, 100, 0, 0, 14048, 'SAY_DEATH_1'), -(29311,2,1, 'Where one falls, many shall take its place.', 15, 0, 100, 0, 0, 14048, 'SAY_DEATH_2'), -(29311,3,0, 'Gul''kafh an''shel. Yoq''al shn ky ywaq nuul.', 14, 0, 100, 0, 0, 14044, 'SAY_PHASE'); - -- cgit v1.2.3