aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSupabad <none@none>2010-10-08 18:04:11 +0200
committerSupabad <none@none>2010-10-08 18:04:11 +0200
commitf6645ce6e8de6923219bf6f2c217e5a991f13ce5 (patch)
tree9f2ad5ae9e720a69ada628513d0a842bcfa5ad81 /sql/updates
parent04566e5be92eb4eb0d9b25b3f69d724a922dbbf6 (diff)
Scripts/Ulduar: Boss Ignis
- Update Boss Ignis thanks to snakeice for main patch - add support for spell slagpot thanks to Shauren and Linencloth - apply trinity coding standard to patch --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/10181_world_script_name.sql3
-rw-r--r--sql/updates/10181_world_script_texts.sql3
-rw-r--r--sql/updates/10181_world_spell_script_names.sql4
3 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/10181_world_script_name.sql b/sql/updates/10181_world_script_name.sql
new file mode 100644
index 00000000000..d654bdbecbf
--- /dev/null
+++ b/sql/updates/10181_world_script_name.sql
@@ -0,0 +1,3 @@
+-- Add script name to boss ignis adds
+UPDATE `creature_template` SET `ScriptName`='npc_iron_construct' WHERE `entry`=33121;
+UPDATE `creature_template` SET `ScriptName`='npc_scorch_ground' WHERE `entry`=33221;
diff --git a/sql/updates/10181_world_script_texts.sql b/sql/updates/10181_world_script_texts.sql
new file mode 100644
index 00000000000..e131affb749
--- /dev/null
+++ b/sql/updates/10181_world_script_texts.sql
@@ -0,0 +1,3 @@
+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
new file mode 100644
index 00000000000..8fd8b74e431
--- /dev/null
+++ b/sql/updates/10181_world_spell_script_names.sql
@@ -0,0 +1,4 @@
+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