Scripts/Some: Cleanup for old scripts, not exist Quest and etc. in Cata.

1 files changed, 59 insertions, 0 deletions

diff --git a/sql/updates/world/2012_08_12_00_world_misc_434.sql b/sql/updates/world/2012_08_12_00_world_misc_434.sql
new file mode 100644
index 00000000000..740b9c3582c
--- /dev/null
+++ b/sql/updates/world/2012_08_12_00_world_misc_434.sql
@@ -0,0 +1,59 @@
+UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName` IN (
+'mobs_spitelashes',
+'npc_loramus_thalipedes',
+'mob_rizzle_sprysprocket',
+'mob_depth_charge',
+'npc_geezle',
+'boss_azuregos',
+'npc_kerlonian',
+'npc_prospector_remtravel',
+'npc_threshwackonator',
+'go_iruxos',
+'npc_dalinda',
+'npc_tiger_matriarch_credit',
+'npc_tiger_matriarch',
+'npc_troll_volunteer',
+'mobs_risen_husk_spirit',
+'npc_lady_jaina_proudmoore',
+'npc_nat_pagle',
+'npc_private_hendel',
+'npc_zelfrax',
+'npc_theramore_guard',
+'npcs_riverbreeze_and_silversky',
+'npc_gregan_brewspewer',
+'npc_oox22fe',
+'npc_screecher_spirit',
+'npc_bunthen_plainswind',
+'npc_great_bear_spirit',
+'npc_silva_filnaveth',
+'npc_clintar_dreamwalker',
+'npc_clintar_spirit',
+'npc_plains_vision',
+'npc_shenthul',
+'npc_thrall_warchief',
+'go_crystalline_tear',
+'npc_anachronos_quest_trigger',
+'npc_anachronos_the_ancient',
+'mob_qiraj_war_spawn',
+'npc_braug_dimspirit',
+'npc_kaya_flathoof',
+'mob_aquementas',
+'npc_marin_noggenfogger',
+'npc_stone_watcher_of_norgannon',
+'npc_tooga',
+'npc_beaten_corpse',
+'npc_gilthares',
+'npc_sputtervalve',
+'npc_taskmaster_fizzule',
+'npc_twiggy_flathead',
+'npc_kanati',
+'npc_lakota_windsong',
+'npc_paoka_swiftmountain',
+'npc_plucky',
+'npc_enraged_panther',
+'go_panther_cage',
+'npc_ame',
+'npc_ringo'
+);
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_mount_check','spell_voljin_war_drums');