DELETE FROM scripted_areatrigger WHERE entry=4591;

INSERT INTO scripted_areatrigger VALUES (4591,'at_coilfang_waterfall');

DELETE FROM scripted_areatrigger WHERE entry=4560;

INSERT INTO scripted_areatrigger VALUES (4560,'at_legion_teleporter');

DELETE FROM scripted_areatrigger WHERE entry=3066;

INSERT INTO scripted_areatrigger VALUES (3066,'at_ravenholdt');

DELETE FROM scripted_areatrigger WHERE entry IN (4871,4872,4873);

INSERT INTO scripted_areatrigger VALUES

(4871,'at_warsong_farms'),

(4872,'at_warsong_farms'),

(4873,'at_warsong_farms');

DELETE FROM scripted_areatrigger WHERE entry IN (5046,5047);

INSERT INTO scripted_areatrigger VALUES

(5046,'at_waygate'),

(5047,'at_waygate');

DELETE FROM scripted_areatrigger WHERE entry BETWEEN 5284 AND 5287;

INSERT INTO scripted_areatrigger VALUES

(5284,'at_aldurthar_gate'),

(5285,'at_aldurthar_gate'),

(5286,'at_aldurthar_gate'),

(5287,'at_aldurthar_gate');

DELETE FROM scripted_areatrigger WHERE entry IN (4112,4113);

INSERT INTO scripted_areatrigger VALUES

(4112,'at_naxxramas'),

(4113,'at_naxxramas');

DELETE FROM scripted_areatrigger WHERE entry=5108;

INSERT INTO scripted_areatrigger VALUES (5108,'at_stormwright_shelf');

DELETE FROM scripted_areatrigger WHERE entry IN (3546,3547,3548,3549,3550,3552);

INSERT INTO scripted_areatrigger VALUES

(3546,'at_childrens_week_spot'), -- Darnassian bank

(3547,'at_childrens_week_spot'), -- Undercity - thone room

(3548,'at_childrens_week_spot'), -- Stonewrought Dam

(3549,'at_childrens_week_spot'), -- The Mor'shan Rampart

(3550,'at_childrens_week_spot'), -- Ratchet Docks

(3552,'at_childrens_week_spot'); -- Westfall Lighthouse

DELETE FROM scripted_areatrigger WHERE entry IN (2026,2046);

INSERT INTO scripted_areatrigger VALUES

(2026,'at_blackrock_spire'),

(2046,'at_blackrock_spire');

DELETE FROM scripted_areatrigger WHERE entry=5030;

INSERT INTO scripted_areatrigger VALUES (5030,'at_spearborn_encampment');

DELETE FROM scripted_areatrigger WHERE entry IN (3958,3960);

INSERT INTO scripted_areatrigger VALUES

(3958,'at_zulgurub'),

(3960,'at_zulgurub');

DELETE FROM scripted_areatrigger WHERE entry=3626;

INSERT INTO scripted_areatrigger VALUES (3626,'at_vaelastrasz');

DELETE FROM scripted_areatrigger WHERE entry=4937;

INSERT INTO scripted_areatrigger VALUES (4937,'at_sunwell_plateau');

DELETE FROM scripted_areatrigger WHERE entry=4524;

INSERT INTO scripted_areatrigger VALUES (4524,'at_shattered_halls');

DELETE FROM scripted_areatrigger WHERE entry BETWEEN 1726 AND 1740;

INSERT INTO scripted_areatrigger VALUES

(1726,'at_scent_larkorwi'),

(1727,'at_scent_larkorwi'),

(1728,'at_scent_larkorwi'),

(1729,'at_scent_larkorwi'),

(1730,'at_scent_larkorwi'),

(1731,'at_scent_larkorwi'),

(1732,'at_scent_larkorwi'),

(1733,'at_scent_larkorwi'),

(1734,'at_scent_larkorwi'),

(1735,'at_scent_larkorwi'),

(1736,'at_scent_larkorwi'),

(1737,'at_scent_larkorwi'),

(1738,'at_scent_larkorwi'),

(1739,'at_scent_larkorwi'),

(1740,'at_scent_larkorwi');

DELETE FROM scripted_areatrigger WHERE entry IN (5709,5732);

INSERT INTO scripted_areatrigger VALUES

(5709,'at_icecrown_citadel'),

(5732,'at_icecrown_citadel');

DELETE FROM scripted_areatrigger WHERE entry in (4288,4485);

INSERT INTO scripted_areatrigger VALUES

(4288,'at_dark_portal'),

(4485,'at_dark_portal');

DELETE FROM scripted_areatrigger WHERE entry=1966;

INSERT INTO scripted_areatrigger VALUES (1966,'at_murkdeep');

DELETE FROM scripted_areatrigger WHERE entry=4047;

INSERT INTO scripted_areatrigger VALUES (4047,'at_temple_ahnqiraj');

UPDATE creature_template SET ScriptName='npc_spirit_guide' WHERE entry IN (13116, 13117);

UPDATE creature_template SET ScriptName='boss_ysondre' WHERE entry=14887;

UPDATE creature_template SET ScriptName='boss_emeriss' WHERE entry=14889;

UPDATE creature_template SET ScriptName='boss_taerar' WHERE entry=14890;

UPDATE creature_template SET ScriptName='boss_shade_of_taerar' WHERE entry=15302;

UPDATE creature_template SET ScriptName='boss_kruul' WHERE entry=18338;

UPDATE creature_template SET ScriptName='boss_azuregos' WHERE entry=6109;

UPDATE creature_template SET ScriptName='mob_dementeddruids' WHERE entry=15260;

UPDATE creature_template SET ScriptName='boss_lethon' WHERE entry=14888;

UPDATE creature_template SET ScriptName='npc_spirit_shade' WHERE entry=15261;

UPDATE gameobject_template SET ScriptName='go_cat_figurine' WHERE entry=13873;

UPDATE gameobject_template SET ScriptName='go_barov_journal' WHERE entry=180794;

UPDATE gameobject_template SET ScriptName='go_ethereum_prison' WHERE entry BETWEEN 184418 AND 184431;

UPDATE gameobject_template SET ScriptName='go_ethereum_stasis' WHERE entry BETWEEN 185465 AND 185467;

UPDATE gameobject_template SET ScriptName='go_ethereum_stasis' WHERE entry=184595;

UPDATE gameobject_template SET ScriptName='go_ethereum_stasis' WHERE entry BETWEEN 185461 AND 185464;

UPDATE gameobject_template SET ScriptName='go_gilded_brazier' WHERE entry=181956;

UPDATE gameobject_template SET ScriptName='go_jump_a_tron' WHERE entry=183146;

UPDATE gameobject_template SET ScriptName='go_mysterious_snow_mound' WHERE entry=195308;

UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145;

UPDATE gameobject_template SET ScriptName='go_sacred_fire_of_life' WHERE entry=175944;

UPDATE gameobject_template SET ScriptName='go_shrine_of_the_birds' WHERE entry IN (185547,185553,185551);

UPDATE gameobject_template SET ScriptName='go_tele_to_dalaran_crystal' WHERE entry=191230;

UPDATE gameobject_template SET ScriptName='go_tele_to_violet_stand' WHERE entry=191229;

UPDATE gameobject_template SET ScriptName='go_blood_filled_orb' WHERE entry=182024;

UPDATE gameobject_template SET ScriptName='go_andorhal_tower' WHERE entry IN (176094,176095,176096,176097);

UPDATE gameobject_template SET ScriptName='go_scourge_enclosure' WHERE entry=191548;

UPDATE gameobject_template SET ScriptName='go_veil_skith_cage' WHERE entry IN (185202,185203,185204,185205);

UPDATE gameobject_template SET ScriptName='go_lab_work_reagents' WHERE entry IN (190462, 190473, 190478, 190459);

UPDATE gameobject_template SET ScriptName='go_hand_of_iruxos_crystal' WHERE entry=176581;

UPDATE creature_template SET ScriptName='guard_azuremyst' WHERE entry=18038;

UPDATE creature_template SET ScriptName='guard_orgrimmar' WHERE entry=3296;

UPDATE creature_template SET ScriptName='guard_stormwind' WHERE entry IN (68,1976);

UPDATE creature_template SET ScriptName='guard_contested' WHERE entry IN (9460,4624,3502,11190,15184);

UPDATE creature_template SET ScriptName='guard_elwynnforest' WHERE entry=1423;

UPDATE creature_template SET ScriptName='guard_eversong' WHERE entry=16221;

UPDATE creature_template SET ScriptName='guard_darnassus' WHERE entry=4262;

UPDATE creature_template SET ScriptName='guard_teldrassil' WHERE entry=3571;

UPDATE creature_template SET ScriptName='guard_ironforge' WHERE entry=5595;

UPDATE creature_template SET ScriptName='guard_dunmorogh' WHERE entry IN (727,13076);

UPDATE creature_template SET ScriptName='guard_undercity' WHERE entry=5624;

UPDATE creature_template SET ScriptName='guard_bluffwatcher' WHERE entry=3084;

UPDATE creature_template SET ScriptName='guard_durotar' WHERE entry=5953;

UPDATE creature_template SET ScriptName='guard_mulgore' WHERE entry IN (3212,3215,3217,3218,3219,3220,3221,3222,3223,3224);

UPDATE creature_template SET ScriptName='guard_dunmorogh' WHERE entry IN (727,13076);

UPDATE creature_template SET ScriptName='guard_tirisfal' WHERE entry IN (1735,1738,2210,1744,1745,5725,1743,2209,1746,1742);

UPDATE creature_template SET ScriptName='guard_silvermoon' WHERE entry=16222;

UPDATE creature_template SET ScriptName='guard_exodar' WHERE entry=16733;

UPDATE creature_template SET ScriptName='guard_shattrath' WHERE entry=19687;

UPDATE creature_template SET ScriptName='guard_shattrath_aldor' WHERE entry=18549;

UPDATE creature_template SET ScriptName='guard_shattrath_scryer' WHERE entry=18568;

UPDATE item_template SET ScriptName='item_arcane_charges' WHERE entry=34475;

UPDATE item_template SET ScriptName='item_flying_machine' WHERE entry IN (34060,34061);

UPDATE item_template SET ScriptName='item_gor_dreks_ointment' WHERE entry=30175;

UPDATE item_template SET ScriptName='item_tainted_core' WHERE entry=31088;

UPDATE item_template SET ScriptName='item_petrov_cluster_bombs' WHERE entry=33098;

UPDATE creature_template SET ScriptName='npc_air_force_bots' WHERE entry IN (2614, 2615, 21974, 21993, 21996, 21997, 21999, 22001, 22002, 22003, 22063, 22065, 22066, 22068, 22069, 22070, 22071, 22078, 22079, 22080, 22086, 22087, 22088, 22090, 22124, 22125, 22126);

UPDATE creature_template SET ScriptName='npc_chicken_cluck' WHERE entry=620;

UPDATE creature_template SET ScriptName='npc_dancing_flames' WHERE entry=25305;

UPDATE creature_template SET ScriptName='npc_garments_of_quests' WHERE entry IN (12429,12423,12427,12430,12428);

UPDATE creature_template SET ScriptName='npc_guardian' WHERE entry=5764;

UPDATE creature_template SET ScriptName='npc_mount_vendor' WHERE entry IN (384,1261,1460,2357,3362,3685,4730,4731,4885,7952,7955,16264,17584);

UPDATE creature_template SET ScriptName='npc_doctor' WHERE entry IN (12939,12920);

UPDATE creature_template SET ScriptName='npc_injured_patient' WHERE entry IN (12936,12937,12938,12923,12924,12925);

UPDATE creature_template SET ScriptName='npc_prof_alchemy' WHERE entry IN (17909,19052,22427);

UPDATE creature_template SET ScriptName='npc_prof_blacksmith' WHERE entry IN (5164,11145,11146,11176,11177,11178,11191,11192,11193);

UPDATE creature_template SET ScriptName='npc_prof_leather' WHERE entry IN (7866,7867,7868,7869,7870,7871);

UPDATE creature_template SET ScriptName='npc_prof_tailor' WHERE entry IN (22208,22212,22213);

UPDATE creature_template SET ScriptName='npc_sayge' WHERE entry=14822;

UPDATE creature_template SET ScriptName='npc_tabard_vendor' WHERE entry=28776;

UPDATE creature_template SET ScriptName='npc_spring_rabbit' WHERE entry=32791;

UPDATE creature_template SET ScriptName='npc_redemption_target' WHERE entry IN (6172,6177,17542,17768);

UPDATE creature_template SET ScriptName='spell_dummy_npc' WHERE entry IN (

1200,8888,

9299,12296,12298,

16880,16518,16847,17157,17326,17654,18879,22105,24918,25084,25085,

23678,25752,25753,25758,25792,25793,26268,26270,26421,26616,26643,26841,26924,27122,27263,27264,27265,27808,28053,28054,28068,28093,28465,28600,29319,29327,29329,29330,29338,30146,32149);

UPDATE gameobject_template SET ScriptName='spell_dummy_go' WHERE entry IN (181616,186949);

DELETE FROM world_template WHERE map IN (0, 1, 530, 571);

INSERT INTO world_template VALUES

(0, 'world_map_eastern_kingdoms'),

(1, 'world_map_kalimdor'),

(530, 'world_map_outland'),

(571, 'world_map_northrend');

UPDATE creature_template SET ScriptName='npc_professor_phizzlethorpe' WHERE entry=2768;

UPDATE creature_template SET ScriptName='npc_muglash' WHERE entry=12717;

UPDATE gameobject_template SET ScriptName='go_naga_brazier' WHERE entry=178247;

UPDATE creature_template SET ScriptName='npc_ruul_snowhoof' WHERE entry=12818;

UPDATE creature_template SET ScriptName='npc_torek' WHERE entry=12858;

UPDATE creature_template SET ScriptName='npc_feero_ironhand' WHERE entry=4484;

UPDATE creature_template SET ScriptName='boss_pandemonius' WHERE entry=18341;

UPDATE creature_template SET ScriptName='boss_nexusprince_shaffar' WHERE entry=18344;

UPDATE creature_template SET ScriptName='mob_ethereal_beacon' WHERE entry=18431;

UPDATE creature_template SET ScriptName='boss_exarch_maladaar' WHERE entry=18373;

UPDATE creature_template SET ScriptName='mob_avatar_of_martyred' WHERE entry=18478;

UPDATE creature_template SET ScriptName='mob_stolen_soul' WHERE entry=18441;

UPDATE creature_template SET ScriptName='boss_shirrak' WHERE entry=18371;

UPDATE instance_template SET ScriptName='instance_sethekk_halls' WHERE map=556;

UPDATE creature_template SET ScriptName='mob_syth_fire' WHERE entry=19203;

UPDATE creature_template SET ScriptName='mob_syth_arcane' WHERE entry=19205;

UPDATE creature_template SET ScriptName='mob_syth_frost' WHERE entry=19204;

UPDATE creature_template SET ScriptName='mob_syth_shadow' WHERE entry=19206;

UPDATE creature_template SET ScriptName='boss_talon_king_ikiss' WHERE entry=18473;

UPDATE creature_template SET ScriptName='boss_darkweaver_syth' WHERE entry=18472;

UPDATE creature_template SET ScriptName='boss_anzu' WHERE entry=23035;

DELETE FROM scripted_event_id WHERE id=14797;

INSERT INTO scripted_event_id VALUES

(14797,'event_spell_summon_raven_god');

UPDATE instance_template SET ScriptName='instance_shadow_labyrinth' WHERE map=555;

UPDATE creature_template SET ScriptName='boss_murmur' WHERE entry=18708;

UPDATE creature_template SET ScriptName='boss_grandmaster_vorpil' WHERE entry=18732;

UPDATE creature_template SET ScriptName='boss_blackheart_the_inciter' WHERE entry=18667;

UPDATE creature_template SET ScriptName='boss_ambassador_hellmaw' WHERE entry=18731;

UPDATE creature_template SET ScriptName='npc_void_traveler' WHERE entry=19226;

UPDATE creature_template SET ScriptName='boss_amanitar' WHERE entry=30258;

UPDATE creature_template SET ScriptName='npc_amanitar_mushroom' WHERE entry IN (30391,30435);

UPDATE creature_template SET ScriptName='boss_jedoga' WHERE entry=29310;

UPDATE creature_template SET ScriptName='npc_twilight_volunteer' WHERE entry=30385;

UPDATE creature_template SET ScriptName='boss_nadox' WHERE entry=29309;

UPDATE creature_template SET ScriptName='mob_ahnkahar_egg' WHERE entry IN (30172,30173);

UPDATE creature_template SET ScriptName='boss_taldaram' WHERE entry=29308;

UPDATE gameobject_template SET ScriptName='go_nerubian_device' WHERE entry IN (193093,193094);

UPDATE creature_template SET ScriptName='boss_volazj' WHERE entry=29311;

UPDATE instance_template SET ScriptName='instance_ahnkahet' WHERE map=619;

UPDATE creature_template SET ScriptName='boss_anubarak' WHERE entry=29120;

UPDATE creature_template SET ScriptName='boss_hadronox' WHERE entry=28921;

UPDATE creature_template SET ScriptName='boss_krikthir' WHERE entry=28684;

UPDATE instance_template SET ScriptName='instance_azjol-nerub' WHERE map=601;

UPDATE creature_template SET ScriptName='npc_rizzle_sprysprocket' WHERE entry=23002;

UPDATE creature_template SET ScriptName='npc_depth_charge' WHERE entry=23025;

UPDATE gameobject_template SET ScriptName='go_southfury_moonstone' WHERE entry=185566;

UPDATE creature_template SET ScriptName='mobs_spitelashes' WHERE entry IN (6190,6193,6194,6195,6196);

UPDATE creature_template SET ScriptName='npc_loramus_thalipedes' WHERE entry=7783;

UPDATE creature_template SET ScriptName='npc_draenei_survivor' WHERE entry=16483;

UPDATE creature_template SET ScriptName='npc_engineer_spark_overgrind' WHERE entry=17243;

UPDATE creature_template SET ScriptName='npc_injured_draenei' WHERE entry=16971;

UPDATE creature_template SET ScriptName='npc_magwin' WHERE entry=17312;

UPDATE creature_template SET ScriptName='npc_beaten_corpse' WHERE entry=10668;

UPDATE creature_template SET ScriptName='npc_gilthares' WHERE entry=3465;

UPDATE creature_template SET ScriptName='npc_sputtervalve' WHERE entry=3442;

UPDATE creature_template SET ScriptName='npc_taskmaster_fizzule' WHERE entry=7233;

UPDATE creature_template SET ScriptName='npc_twiggy_flathead' WHERE entry=6248;

DELETE FROM scripted_areatrigger WHERE entry=522;

INSERT INTO scripted_areatrigger VALUES (522,'at_twiggy_flathead');

UPDATE creature_template SET ScriptName='npc_wizzlecranks_shredder' WHERE entry=3439;

UPDATE instance_template SET ScriptName='instance_black_temple' WHERE map=564;

UPDATE creature_template SET ScriptName='npc_akama_shade' WHERE entry=22990; -- Akama at Shade of Akama

UPDATE creature_template SET ScriptName='npc_akama_illidan' WHERE entry=23089; -- Akama at Illidan

UPDATE creature_template SET ScriptName='mob_illidari_council' WHERE entry=23426; -- Illidari Council controller mob

UPDATE creature_template SET ScriptName='mob_blood_elf_council_voice_trigger' WHERE entry=23499; -- Voice Trigger Mob (Controls Aggro + Enrage yells)

UPDATE creature_template SET ScriptName='boss_veras_darkshadow' WHERE entry=22952; -- Rogue of Illidari Council

UPDATE creature_template SET ScriptName='boss_teron_gorefiend' WHERE entry=22871; -- Teron Gorefiend

UPDATE creature_template SET ScriptName='boss_supremus' WHERE entry=22898; -- Supremus

UPDATE creature_template SET ScriptName='boss_shade_of_akama' WHERE entry=22841; -- Shade of Akama

UPDATE creature_template SET ScriptName='boss_reliquary_of_souls' WHERE entry=22856; -- Reliquary Controller Mob

UPDATE creature_template SET ScriptName='boss_essence_of_suffering' WHERE entry=23418; -- Essence Of Suffering

UPDATE creature_template SET ScriptName='boss_essence_of_desire' WHERE entry=23419; -- Essence of Desire

UPDATE creature_template SET ScriptName='boss_essence_of_anger' WHERE entry=23420; -- Essence of Anger

UPDATE creature_template SET ScriptName='boss_najentus' WHERE entry=22887; -- High Warlord Naj'entus

UPDATE creature_template SET ScriptName='boss_gurtogg_bloodboil' WHERE entry=22948; -- Gurtogg Bloodboil

UPDATE creature_template SET ScriptName='boss_mother_shahraz' WHERE entry=22947; -- Mother Shahraz

UPDATE creature_template SET ScriptName='boss_lady_malande' WHERE entry=22951; -- Priest <3 at Illidari Council

UPDATE creature_template SET ScriptName='boss_illidan_stormrage' WHERE entry=22917; -- Illidan The Betrayer!

UPDATE creature_template SET ScriptName='boss_high_nethermancer_zerevor' WHERE entry=22950; -- Mage at Illidari Council

UPDATE creature_template SET ScriptName='boss_gathios_the_shatterer' WHERE entry=22949; -- Paladin at Illidari Council

UPDATE creature_template SET ScriptName='boss_maiev_shadowsong' WHERE entry=23197; -- Maiev Shadowsong

UPDATE gameobject_template SET ScriptName='gameobject_cage_trap' WHERE entry=185916; -- Cage Trap GO in Illidan Encounter

UPDATE creature_template SET ScriptName='mob_blaze' WHERE entry=23259; -- Blaze mob in Illidan Phase 2

UPDATE creature_template SET ScriptName='mob_flame_of_azzinoth' WHERE entry=22997; -- Flame of Azzinoth (Illidan Phase 2)

UPDATE creature_template SET ScriptName='mob_blade_of_azzinoth' WHERE entry=22996; -- Blade of Azzinoth (Illidan Phase 2)

UPDATE creature_template SET ScriptName='mob_demon_fire' WHERE entry=23069; -- Demon Fire in Illidan Phase 2

UPDATE creature_template SET ScriptName='mob_flame_crash' WHERE entry=23336; -- Flame Crash in Illidan Normal Form

UPDATE creature_template SET ScriptName='mob_cage_trap_trigger' WHERE entry=23304; -- Cage Trap mob in Illidan Phase 3/4 Normal

UPDATE creature_template SET ScriptName='mob_shadow_demon' WHERE entry=23375; -- Shadow Demon in Illidan Demon Form

UPDATE creature_template SET ScriptName='npc_volcano' WHERE entry=23085; -- Supremus Volcano

UPDATE creature_template SET ScriptName='molten_flame' WHERE entry=23095; -- Molten Flame in SUpremus

UPDATE creature_template SET ScriptName='mob_ashtongue_channeler' WHERE entry=23421; -- Ashtongue CHanneler in Shade of AKama

UPDATE creature_template SET ScriptName='mob_ashtongue_sorcerer' WHERE entry=23215; -- Ashtongue Sorcerer in Shade of Akama

UPDATE creature_template SET ScriptName='npc_enslaved_soul' WHERE entry=23469; -- Enslaved Soul in Reliquary Event

UPDATE creature_template SET ScriptName='mob_doom_blossom' WHERE entry=23123; -- Doom Blossoms in Teron Gorefiend's encounter

UPDATE creature_template SET ScriptName='npc_spirit_of_olum' WHERE entry=23411;

UPDATE instance_template SET ScriptName='instance_blackfathom_deeps' WHERE map=48;

UPDATE gameobject_template SET ScriptName='go_fire_of_akumai' WHERE entry IN (21118,21119,21120,21121);

DELETE FROM scripted_areatrigger WHERE entry=1526;

INSERT INTO scripted_areatrigger VALUES (1526,'at_ring_of_law');

UPDATE instance_template SET ScriptName='instance_blackrock_depths' WHERE map =230;

UPDATE creature_template SET ScriptName='boss_emperor_dagran_thaurissan' WHERE entry=9019;

UPDATE creature_template SET ScriptName='boss_moira_bronzebeard' WHERE entry=8929;

UPDATE creature_template SET ScriptName='boss_ambassador_flamelash' WHERE entry=9156;

UPDATE creature_template SET ScriptName='boss_anubshiah' WHERE entry=9031;

UPDATE creature_template SET ScriptName='boss_doomrel' WHERE entry=9039;

UPDATE creature_template SET ScriptName='boss_gloomrel' WHERE entry=9037;

UPDATE creature_template SET ScriptName='boss_general_angerforge' WHERE entry=9033;

UPDATE creature_template SET ScriptName='boss_gorosh_the_dervish' WHERE entry=9027;

UPDATE creature_template SET ScriptName='boss_grizzle' WHERE entry=9028;

UPDATE creature_template SET ScriptName='boss_high_interrogator_gerstahn' WHERE entry=9018;

UPDATE creature_template SET ScriptName='boss_magmus' WHERE entry=9938;

UPDATE creature_template SET ScriptName='mob_phalanx' WHERE entry=9502;

UPDATE creature_template SET ScriptName='npc_grimstone' WHERE entry=10096;

UPDATE creature_template SET ScriptName='npc_theldren_trigger' WHERE entry=16079;

UPDATE creature_template SET ScriptName='npc_lokhtos_darkbargainer' WHERE entry=12944;

UPDATE creature_template SET ScriptName='npc_kharan_mighthammer' WHERE entry=9021;

UPDATE creature_template SET ScriptName='npc_rocknot' WHERE entry=9503;

UPDATE gameobject_template SET ScriptName='go_shadowforge_brazier' WHERE entry IN (174744, 174745);

UPDATE gameobject_template SET ScriptName='go_relic_coffer_door' WHERE entry IN (174554, 174555, 174556, 174557, 174558, 174559, 174560, 174561, 174562, 174563, 174564, 174566);

UPDATE instance_template SET ScriptName='instance_blackrock_spire' WHERE map=229;

UPDATE creature_template SET ScriptName='boss_highlord_omokk' WHERE entry=9196;

UPDATE creature_template SET ScriptName='boss_shadow_hunter_voshgajin' WHERE entry=9236;

UPDATE creature_template SET ScriptName='boss_warmaster_voone' WHERE entry=9237;

UPDATE creature_template SET ScriptName='boss_mother_smolderweb' WHERE entry=10596;

UPDATE creature_template SET ScriptName='quartermaster_zigris' WHERE entry=9736;

UPDATE creature_template SET ScriptName='boss_halycon' WHERE entry=10220;

UPDATE creature_template SET ScriptName='boss_overlord_wyrmthalak' WHERE entry=9568;

UPDATE creature_template SET ScriptName='boss_the_beast' WHERE entry=10430;

UPDATE creature_template SET ScriptName='boss_drakkisath' WHERE entry=10363;

UPDATE creature_template SET ScriptName='boss_gyth' WHERE entry=10339;

UPDATE creature_template SET ScriptName='boss_rend_blackhand' WHERE entry=10429;

UPDATE creature_template SET ScriptName='boss_pyroguard_emberseer' WHERE entry=9816;

DELETE FROM scripted_event_id WHERE id=4884;

INSERT INTO scripted_event_id VALUES

(4884,'event_spell_altar_emberseer');

UPDATE instance_template SET ScriptName='instance_blackwing_lair' WHERE map=469;

UPDATE creature_template SET ScriptName='boss_razorgore' WHERE entry=12435;

UPDATE creature_template SET ScriptName='boss_vaelastrasz' WHERE entry=13020;

UPDATE creature_template SET ScriptName='boss_broodlord' WHERE entry=12017;

UPDATE creature_template SET ScriptName='boss_firemaw' WHERE entry=11983;

UPDATE creature_template SET ScriptName='boss_ebonroc' WHERE entry=14601;

UPDATE creature_template SET ScriptName='boss_flamegor' WHERE entry=11981;

UPDATE creature_template SET ScriptName='boss_chromaggus' WHERE entry=14020;

UPDATE creature_template SET ScriptName='boss_victor_nefarius' WHERE entry=10162;

UPDATE creature_template SET ScriptName='boss_nefarian' WHERE entry=11583;

UPDATE creature_template SET ScriptName='mobs_bladespire_ogre' WHERE entry IN (19998,20334,21296,21975);

UPDATE creature_template SET ScriptName='mobs_nether_drake' WHERE entry IN (20021,21817,21820,21821,21823);

UPDATE creature_template SET ScriptName='npc_daranelle' WHERE entry=21469;

UPDATE creature_template SET ScriptName='npc_fallen_hero_of_horde' WHERE entry=7572;

UPDATE creature_template SET ScriptName='mob_webbed_creature' WHERE entry=17680;

UPDATE creature_template SET ScriptName='npc_nesingwary_trapper' WHERE entry=25835;

UPDATE creature_template SET ScriptName='npc_oil_stained_wolf' WHERE entry=25791;

UPDATE gameobject_template SET ScriptName='go_caribou_trap' WHERE entry IN (187982,187995,187996,187997,187998,187999,188000,188001,188002,188003,188004,188005,188006,188007,188008);

UPDATE creature_template SET ScriptName='npc_sinkhole_kill_credit' WHERE entry IN (26248,26249);

UPDATE creature_template SET ScriptName='npc_lurgglbr' WHERE entry=25208;

UPDATE creature_template SET ScriptName='npc_ragged_john' WHERE entry=9563;

UPDATE instance_template SET ScriptName='instance_hyjal' WHERE map=534;

UPDATE creature_template SET ScriptName='npc_tyrande_whisperwind' WHERE entry=17948;

UPDATE creature_template SET ScriptName='npc_thrall' WHERE entry=17852;

UPDATE creature_template SET ScriptName='npc_jaina_proudmoore' WHERE entry=17772;

UPDATE creature_template SET ScriptName='boss_archimonde' WHERE entry=17968;

UPDATE creature_template SET ScriptName='mob_doomfire' WHERE entry=18095;

UPDATE creature_template SET ScriptName='mob_doomfire_targetting' WHERE entry=18104;

UPDATE creature_template SET ScriptName='mob_ancient_wisp' WHERE entry=17946;

UPDATE instance_template SET ScriptName='instance_old_hillsbrad' WHERE map=560;

UPDATE creature_template SET ScriptName='boss_lieutenant_drake' WHERE entry=17848;

UPDATE creature_template SET ScriptName='boss_epoch_hunter' WHERE entry=18096;

UPDATE creature_template SET ScriptName='boss_captain_skarloc' WHERE entry=17862;

UPDATE gameobject_template SET ScriptName='go_barrel_old_hillsbrad' WHERE entry=182589;

UPDATE creature_template SET ScriptName='npc_erozion' WHERE entry=18723;

UPDATE creature_template SET ScriptName='npc_taretha' WHERE entry=18887;

UPDATE creature_template SET ScriptName='npc_thrall_old_hillsbrad' WHERE entry=17876;

UPDATE instance_template SET ScriptName='instance_culling_of_stratholme' WHERE map=595;

UPDATE creature_template SET ScriptName='npc_chromie' WHERE entry IN (26527, 27915);

UPDATE creature_template SET ScriptName='spell_dummy_npc_crates_bunny' WHERE entry=30996;

UPDATE creature_template SET ScriptName='boss_chrono_lord_deja' WHERE entry=17879;

UPDATE creature_template SET ScriptName='boss_aeonus' WHERE entry=17881;

UPDATE creature_template SET ScriptName='boss_temporus' WHERE entry=17880;

UPDATE instance_template SET ScriptName='instance_dark_portal' WHERE map=269;

UPDATE creature_template SET ScriptName='npc_medivh_black_morass' WHERE entry=15608;

UPDATE creature_template SET ScriptName='npc_time_rift' WHERE entry=17838;

UPDATE creature_template SET ScriptName='mob_underbog_mushroom' WHERE entry=17990;

UPDATE creature_template SET ScriptName='boss_hungarfen' WHERE entry=17770;

UPDATE instance_template SET ScriptName='instance_steam_vault' WHERE map=545;

UPDATE creature_template SET ScriptName='boss_hydromancer_thespia' WHERE entry=17797;

UPDATE creature_template SET ScriptName='boss_mekgineer_steamrigger' WHERE entry=17796;

UPDATE creature_template SET ScriptName='boss_warlord_kalithresh' WHERE entry=17798;

UPDATE gameobject_template SET ScriptName='go_main_chambers_access_panel' WHERE entry IN (184125,184126);

UPDATE creature_template SET ScriptName='mob_coilfang_waterelemental' WHERE entry=17917;

UPDATE creature_template SET ScriptName='mob_naga_distiller' WHERE entry=17954;

UPDATE creature_template SET ScriptName='mob_steamrigger_mechanic' WHERE entry=17951;

UPDATE instance_template SET ScriptName='instance_serpent_shrine' WHERE map=548;

UPDATE creature_template SET ScriptName='boss_hydross_the_unstable' WHERE entry=21216;

UPDATE creature_template SET ScriptName='boss_leotheras_the_blind' WHERE entry=21215;

UPDATE creature_template SET ScriptName='boss_leotheras_the_blind_demonform' WHERE entry=21875;

UPDATE creature_template SET ScriptName='boss_fathomlord_karathress' WHERE entry=21214;

UPDATE creature_template SET ScriptName='boss_fathomguard_sharkkis' WHERE entry=21966;

UPDATE creature_template SET ScriptName='boss_fathomguard_tidalvess' WHERE entry=21965;

UPDATE creature_template SET ScriptName='boss_fathomguard_caribdis' WHERE entry=21964;

UPDATE creature_template SET ScriptName='boss_morogrim_tidewalker' WHERE entry=21213;

UPDATE creature_template SET ScriptName='mob_water_globule' WHERE entry=21913;

UPDATE creature_template SET ScriptName='boss_lady_vashj' WHERE entry=21212;

UPDATE creature_template SET ScriptName='mob_enchanted_elemental' WHERE entry=21958;

UPDATE creature_template SET ScriptName='mob_tainted_elemental' WHERE entry=22009;

UPDATE creature_template SET ScriptName='mob_toxic_sporebat' WHERE entry=22140;

UPDATE creature_template SET ScriptName='mob_shield_generator_channel' WHERE entry=19870;

UPDATE gameobject_template SET ScriptName='go_strange_pool' WHERE entry=184956;

UPDATE creature_template SET ScriptName='boss_the_lurker_below' WHERE entry=21217;

UPDATE instance_template SET ScriptName='instance_trial_of_the_crusader' WHERE map=649;

UPDATE creature_template SET ScriptName='npc_barrett_ramsey' WHERE entry IN (34816, 35035, 35766, 35770, 35771);

UPDATE creature_template SET ScriptName='npc_beast_combat_stalker' WHERE entry=36549;

UPDATE creature_template SET ScriptName='boss_gormok' WHERE entry=34796;

UPDATE creature_template SET ScriptName='boss_acidmaw' WHERE entry=35144;

UPDATE creature_template SET ScriptName='boss_dreadscale' WHERE entry=34799;

UPDATE creature_template SET ScriptName='boss_icehowl' WHERE entry=34797;

UPDATE creature_template SET ScriptName='boss_jaraxxus' WHERE entry=34780;

UPDATE creature_template SET ScriptName='boss_anubarak_trial' WHERE entry=34564;

UPDATE creature_template SET ScriptName='boss_fjola' WHERE entry=34497;

UPDATE creature_template SET ScriptName='boss_eydis' WHERE entry=34496;

UPDATE creature_template SET ScriptName='npc_dalaran_guardian_mage' WHERE entry IN (29255, 29254);

UPDATE creature_template SET ScriptName='npc_kerlonian' WHERE entry=11218;

UPDATE creature_template SET ScriptName='npc_prospector_remtravel' WHERE entry=2917;

UPDATE creature_template SET ScriptName='npc_threshwackonator' WHERE entry=6669;

UPDATE creature_template SET ScriptName='npc_volcor' WHERE entry=3692;

UPDATE creature_template SET ScriptName='boss_mr_smite' WHERE entry=646;

UPDATE instance_template SET ScriptName='instance_deadmines' WHERE map=36;

UPDATE gameobject_template SET ScriptName='go_defias_cannon' WHERE entry=16398;

UPDATE creature_template SET ScriptName='npc_aged_dying_ancient_kodo' WHERE entry IN (4700, 4701, 4702, 11627);

UPDATE creature_template SET ScriptName='npc_dalinda_malem' WHERE entry=5644;

UPDATE creature_template SET ScriptName='npc_melizza_brimbuzzle' WHERE entry=12277;

UPDATE instance_template SET ScriptName='instance_dire_maul' WHERE map=429;

UPDATE creature_template SET ScriptName='npc_destructive_ward' WHERE entry=27430;

UPDATE creature_template SET ScriptName='boss_novos' WHERE entry=26631;

UPDATE creature_template SET ScriptName='npc_crystal_channel_target' WHERE entry=26712;

UPDATE creature_template SET ScriptName='boss_tharonja' WHERE entry=26632;

UPDATE creature_template SET ScriptName='boss_trollgore' WHERE entry=26630;

UPDATE instance_template SET ScriptName='instance_draktharon_keep' WHERE map=600;

UPDATE creature_template SET ScriptName='npc_lazy_peon' WHERE entry=10556;

UPDATE creature_template SET ScriptName='mobs_risen_husk_spirit' WHERE entry IN (23554,23555);

UPDATE creature_template SET ScriptName='npc_ogron' WHERE entry=4983;

UPDATE creature_template SET ScriptName='npc_morokk' WHERE entry=4500;

UPDATE creature_template SET ScriptName='npc_restless_apparition' WHERE entry=23861;

UPDATE creature_template SET ScriptName='npc_private_hendel' WHERE entry=4966;

DELETE FROM scripted_areatrigger WHERE entry=4752;

INSERT INTO scripted_areatrigger VALUES

(4752,'at_nats_landing');

UPDATE creature_template SET ScriptName='mobs_ghoul_flayer' WHERE entry IN (8530,8531,8532);

UPDATE creature_template SET ScriptName='npc_darrowshire_spirit' WHERE entry=11064;

UPDATE creature_template SET ScriptName='npc_eris_havenfire' WHERE entry=14494;

UPDATE creature_template SET ScriptName='npc_death_knight_initiate' WHERE entry=28406;

UPDATE creature_template SET ScriptName='npc_unworthy_initiate_anchor' WHERE entry=29521;

UPDATE creature_template SET ScriptName='npc_unworthy_initiate' WHERE entry IN (29519,29520,29565,29566,29567);

UPDATE gameobject_template SET ScriptName='go_acherus_soul_prison' WHERE entry IN (191577,191580,191581,191582,191583,191584,191585,191586,191587,191588,191589,191590);

UPDATE creature_template SET ScriptName='npc_a_special_surprise' WHERE entry IN (29032,29061,29065,29067,29068,29070,29074,29072,29073,29071);

UPDATE creature_template SET ScriptName='npc_koltira_deathweaver' WHERE entry=28912;

UPDATE creature_template SET ScriptName='npc_kelerun_bloodmourn' WHERE entry=17807;

UPDATE gameobject_template SET ScriptName='go_harbinger_second_trial' WHERE entry=182052;

UPDATE creature_template SET ScriptName='npc_prospector_anvilward' WHERE entry=15420;

UPDATE creature_template SET ScriptName='npc_apprentice_mirveda' WHERE entry=15402;

UPDATE creature_template SET ScriptName='npc_infused_crystal' WHERE entry=16364;

DELETE FROM scripted_event_id WHERE id=8328;

INSERT INTO scripted_event_id VALUES

(8328, 'npc_kroshius');

UPDATE creature_template SET ScriptName='npc_kitten' WHERE entry=9937;

UPDATE creature_template SET ScriptName='npc_corrupt_saber' WHERE entry=10042;

UPDATE creature_template SET ScriptName='npcs_riverbreeze_and_silversky' WHERE entry IN (9528,9529);

UPDATE creature_template SET ScriptName='npc_niby_the_almighty' WHERE entry=14469;

UPDATE creature_template SET ScriptName='npc_kroshius' WHERE entry=14467;

UPDATE creature_template SET ScriptName='npc_oox22fe' WHERE entry=7807;

UPDATE creature_template SET ScriptName='npc_ranger_lilatha' WHERE entry=16295;

UPDATE creature_template SET ScriptName='boss_thermaplugg' WHERE entry=7800;

UPDATE gameobject_template SET ScriptName='go_gnomeface_button' WHERE entry BETWEEN 142214 AND 142219;

UPDATE creature_template SET ScriptName='npc_blastmaster_emi_shortfuse' WHERE entry=7998;

UPDATE instance_template SET ScriptName='instance_gnomeregan' WHERE map=90;

UPDATE creature_template SET ScriptName='npc_depleted_war_golem' WHERE entry=27017;

UPDATE instance_template SET ScriptName='instance_gruuls_lair' WHERE map =565;

UPDATE creature_template SET ScriptName='boss_gruul' WHERE entry=19044;

UPDATE creature_template SET ScriptName='boss_high_king_maulgar' WHERE entry=18831;

UPDATE creature_template SET ScriptName='boss_kiggler_the_crazed' WHERE entry=18835;

UPDATE creature_template SET ScriptName='boss_blindeye_the_seer' WHERE entry=18836;

UPDATE creature_template SET ScriptName='boss_olm_the_summoner' WHERE entry=18834;

UPDATE creature_template SET ScriptName='boss_krosh_firehand' WHERE entry=18832;

UPDATE creature_template SET ScriptName='boss_drakkari_colossus' WHERE entry=29307;

UPDATE creature_template SET ScriptName='boss_drakkari_elemental' WHERE entry=29573;

UPDATE creature_template SET ScriptName='npc_living_mojo' WHERE entry=29830;

UPDATE creature_template SET ScriptName='boss_eck' WHERE entry=29932;

UPDATE creature_template SET ScriptName='boss_galdarah' WHERE entry=29306;

UPDATE creature_template SET ScriptName='boss_moorabi' WHERE entry=29305;

UPDATE creature_template SET ScriptName='boss_sladran' WHERE entry=29304;

UPDATE creature_template SET ScriptName='mob_sladran_summon_target' WHERE entry=29682;

UPDATE gameobject_template SET ScriptName='go_gundrak_altar' WHERE entry IN (192518, 192519, 192520);

UPDATE instance_template SET ScriptName='instance_gundrak' WHERE map=604;

UPDATE creature_template SET ScriptName='boss_the_maker' WHERE entry=17381;

UPDATE creature_template SET ScriptName='boss_broggok' WHERE entry=17380;

UPDATE creature_template SET ScriptName='boss_kelidan_the_breaker' WHERE entry=17377;

UPDATE creature_template SET ScriptName='mob_broggok_poisoncloud' WHERE entry=17662;

UPDATE creature_template SET ScriptName='mob_shadowmoon_channeler' WHERE entry=17653;

UPDATE gameobject_template SET ScriptName='go_prison_cell_lever' WHERE entry=181982;

UPDATE instance_template SET ScriptName='instance_blood_furnace' WHERE map=542;

UPDATE creature_template SET ScriptName='boss_omor_the_unscarred' WHERE entry=17308;

UPDATE creature_template SET ScriptName='boss_watchkeeper_gargolmar' WHERE entry=17306;

UPDATE creature_template SET ScriptName='boss_vazruden_herald' WHERE entry=17307;

UPDATE creature_template SET ScriptName='boss_vazruden' WHERE entry=17537;

UPDATE instance_template SET ScriptName='instance_ramparts' WHERE map=543;

UPDATE creature_template SET ScriptName='boss_grand_warlock_nethekurse' WHERE entry=16807;

UPDATE creature_template SET ScriptName='boss_warbringer_omrogg' WHERE entry=16809;

UPDATE creature_template SET ScriptName='mob_fel_orc_convert' WHERE entry=17083;

UPDATE creature_template SET ScriptName='mob_lesser_shadow_fissure' WHERE entry=17471;

UPDATE creature_template SET ScriptName='mob_omrogg_heads' WHERE entry IN (19523,19524);

UPDATE creature_template SET ScriptName='boss_warchief_kargath_bladefist' WHERE entry=16808;

UPDATE instance_template SET ScriptName='instance_shattered_halls' WHERE map=540;

UPDATE instance_template SET ScriptName='instance_magtheridons_lair' WHERE map=544;

UPDATE gameobject_template SET ScriptName='go_manticron_cube' WHERE entry=181713;

UPDATE creature_template SET ScriptName='boss_magtheridon' WHERE entry=17257;

UPDATE creature_template SET ScriptName='mob_abyssal' WHERE entry=17454;

UPDATE creature_template SET ScriptName='mob_hellfire_channeler' WHERE entry=17256;

UPDATE creature_template SET ScriptName='boss_doomlord_kazzak' WHERE entry=18728;

UPDATE creature_template SET ScriptName='npc_aeranas' WHERE entry=17085;

UPDATE creature_template SET ScriptName='npc_ancestral_wolf' WHERE entry=17077;

UPDATE creature_template SET ScriptName='npc_demoniac_scryer' WHERE entry=22258;

UPDATE creature_template SET ScriptName='npc_wounded_blood_elf' WHERE entry=16993;

UPDATE creature_template SET ScriptName='npc_00x09hl' WHERE entry=7806;

UPDATE creature_template SET ScriptName='npc_rinji' WHERE entry=7780;

DELETE FROM scripted_areatrigger WHERE entry=4778;

INSERT INTO scripted_areatrigger VALUES (4778,'at_ancient_male_vrykul');

UPDATE creature_template SET ScriptName='npc_ancient_male_vrykul' WHERE entry=24314;

UPDATE creature_template SET ScriptName='npc_daegarn' WHERE entry=24151;

UPDATE creature_template SET ScriptName='npc_silvermoon_harry' WHERE entry=24539;

UPDATE instance_template SET ScriptName='instance_icecrown_citadel' WHERE map=631;