From 8dbdd388c943eee6aa990dc6b337e34155b5bf1c Mon Sep 17 00:00:00 2001 From: Supabad Date: Fri, 8 Oct 2010 18:26:37 +0200 Subject: fix sql from previous commit --HG-- branch : trunk rename : sql/updates/10181_world_script_texts.sql => sql/updates/10182_world_script_texts.sql rename : sql/updates/10181_world_spell_script_names.sql => sql/updates/10182_world_spell_script_names.sql --- sql/updates/10181_world_script_texts.sql | 3 --- sql/updates/10181_world_spell_script_names.sql | 4 ---- sql/updates/10182_world_script_texts.sql | 3 +++ sql/updates/10182_world_spell_script_names.sql | 5 +++++ 4 files changed, 8 insertions(+), 7 deletions(-) delete mode 100644 sql/updates/10181_world_script_texts.sql delete mode 100644 sql/updates/10181_world_spell_script_names.sql create mode 100644 sql/updates/10182_world_script_texts.sql create mode 100644 sql/updates/10182_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/10181_world_script_texts.sql b/sql/updates/10181_world_script_texts.sql deleted file mode 100644 index e131affb749..00000000000 --- a/sql/updates/10181_world_script_texts.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `script_texts` WHERE `entry` IN (-1571043,-1571042); -INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES -(33118,-1603229,'Ignis the Furnace Master begins to cast Flame Jets!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'IGNIS EMOTE_JETS'); diff --git a/sql/updates/10181_world_spell_script_names.sql b/sql/updates/10181_world_spell_script_names.sql deleted file mode 100644 index 8fd8b74e431..00000000000 --- a/sql/updates/10181_world_spell_script_names.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=62717 AND `ScriptName`='spell_ignis_slag_pot'; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(62717, 'spell_ignis_slag_pot'); -- boss Ignis 10man -(62717, 'spell_ignis_slag_pot'); -- boss Ignis 25man diff --git a/sql/updates/10182_world_script_texts.sql b/sql/updates/10182_world_script_texts.sql new file mode 100644 index 00000000000..f43d12ed768 --- /dev/null +++ b/sql/updates/10182_world_script_texts.sql @@ -0,0 +1,3 @@ +DELETE FROM `script_texts` WHERE `entry` IN (-1603229); +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES +(33118,-1603229,'Ignis the Furnace Master begins to cast Flame Jets!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'IGNIS EMOTE_JETS'); diff --git a/sql/updates/10182_world_spell_script_names.sql b/sql/updates/10182_world_spell_script_names.sql new file mode 100644 index 00000000000..18c9b188d2d --- /dev/null +++ b/sql/updates/10182_world_spell_script_names.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=62717 AND `ScriptName`='spell_ignis_slag_pot'; +DELETE FROM `spell_script_names` WHERE `spell_id`=63477 AND `ScriptName`='spell_ignis_slag_pot'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(62717, 'spell_ignis_slag_pot'); -- boss Ignis 10man +(63477, 'spell_ignis_slag_pot'); -- boss Ignis 25man -- cgit v1.2.3