aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/scripts/world_scripts_full.sql5
-rw-r--r--sql/updates/9246_world_scriptname.sql4
2 files changed, 4 insertions, 5 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index b395f798636..12cdba24a79 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -362,11 +362,6 @@ UPDATE `creature_template` SET `ScriptName`='mob_phalanx' WHERE `entry`=9502;
UPDATE `gameobject_template` SET `ScriptName`='go_shadowforge_brazier' WHERE `entry` IN (174744,174745);
/* BLACKROCK SPIRE */
-
-UPDATE `instance_template` SET `script`='instance_blackrock_spire' WHERE `map`=229;
-UPDATE `creature_template` SET `ScriptName`='npc_rookey_whelp' WHERE `entry`=10161;
-UPDATE `gameobject_template` SET `ScriptName`='go_rookey_egg' WHERE `entry`=175124;
-
/* BLACKROCK SPIRE Lower bosses */
UPDATE `creature_template` SET `ScriptName`='boss_highlord_omokk' WHERE `entry`=9196;
UPDATE `creature_template` SET `ScriptName`='boss_shadow_hunter_voshgajin' WHERE `entry`=9236;
diff --git a/sql/updates/9246_world_scriptname.sql b/sql/updates/9246_world_scriptname.sql
new file mode 100644
index 00000000000..0a1a18d015f
--- /dev/null
+++ b/sql/updates/9246_world_scriptname.sql
@@ -0,0 +1,4 @@
+-- Remove by script name in case someone ever applied these names to other stuff
+UPDATE `instance_template` SET `script`='' WHERE `script`='instance_blackrock_spire';
+UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName`='npc_rookey_whelp';
+UPDATE `gameobject_template` SET `ScriptName`='' WHERE `ScriptName`='go_rookey_egg';