aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKingPin <none@none>2008-10-27 09:57:53 -0500
committerKingPin <none@none>2008-10-27 09:57:53 -0500
commit1bb16035923b0675b0c239379cd5d64c8310f28b (patch)
treea4484c1d97545373f5e4033c3f23052b938d14d8
parente72a13c3dd10922a18d9ee59a7f62fbfb6b69c03 (diff)
[svn] * Moved scripts sqls updates to main sql updates folder.
* Fixed makefile to use proper foldername. * rXXX_world_scripts.sql will be the format for script sql updates, execute these into your world DB. --HG-- branch : trunk
-rw-r--r--sql/Makefile.am8
-rw-r--r--sql/tools/Makefile.am4
-rw-r--r--sql/updates/r112_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r112_trinity.sql)0
-rw-r--r--sql/updates/r125_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r125_trinity.sql)2
-rw-r--r--sql/updates/r57_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r57_trinity.sql)0
-rw-r--r--sql/updates/r66_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r66_trinity.sql)0
-rw-r--r--sql/updates/r70_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r70_trinity.sql)0
-rw-r--r--sql/updates/r82_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r82_trinity.sql)0
-rw-r--r--sql/updates/r86_world_scripts.sql (renamed from src/bindings/scripts/sql/Updates/r86_trinity.sql)0
-rw-r--r--sql/world_scripts_full.sql (renamed from src/bindings/scripts/sql/full_scripts.sql)1742
-rw-r--r--sql/world_scripts_structure.sql (renamed from src/bindings/scripts/sql/scripts_structure.sql)202
-rw-r--r--src/bindings/scripts/sql/Makefile.am33
-rw-r--r--src/bindings/scripts/sql/Makefile.in542
-rw-r--r--src/bindings/scripts/sql/create_database.sql3
14 files changed, 981 insertions, 1555 deletions
diff --git a/sql/Makefile.am b/sql/Makefile.am
index 8f48c41d2c0..93cc1474b1c 100644
--- a/sql/Makefile.am
+++ b/sql/Makefile.am
@@ -22,8 +22,8 @@
SUBDIRS = updates tools
## Change installation location
-# datadir = mangos/sql
-pkgdatadir = $(datadir)/mangos/sql
+# datadir = trinity/sql
+pkgdatadir = $(datadir)/trinity/sql
## Files to be installed
# Install basic SQL files to datadir
@@ -32,6 +32,8 @@ pkgdata_DATA = \
realmd.sql \
characters.sql \
create_mysql.sql \
+ world_scripts_full.sql \
+ world_scripts_structure.sql \
drop_mysql.sql
## Additional files to include when running 'make dist'
@@ -41,4 +43,6 @@ EXTRA_DIST = \
drop_mysql.sql \
characters.sql \
world.sql \
+ world_scripts_full.sql \
+ world_scripts_structure.sql \
realmd.sql
diff --git a/sql/tools/Makefile.am b/sql/tools/Makefile.am
index 6ff72726a57..301aafceedb 100644
--- a/sql/tools/Makefile.am
+++ b/sql/tools/Makefile.am
@@ -21,8 +21,8 @@
## Sub-directories to parse
## Change installation location
-# datadir = mangos/sql/tools
-pkgdatadir = $(datadir)/mangos/sql/tools
+# datadir = trinity/sql/tools
+pkgdatadir = $(datadir)/trinity/sql/tools
## Files to be installed
# Install basic SQL files to datadir
diff --git a/src/bindings/scripts/sql/Updates/r112_trinity.sql b/sql/updates/r112_world_scripts.sql
index 2d2412c395b..2d2412c395b 100644
--- a/src/bindings/scripts/sql/Updates/r112_trinity.sql
+++ b/sql/updates/r112_world_scripts.sql
diff --git a/src/bindings/scripts/sql/Updates/r125_trinity.sql b/sql/updates/r125_world_scripts.sql
index 946d50f3939..2d250a538f9 100644
--- a/src/bindings/scripts/sql/Updates/r125_trinity.sql
+++ b/sql/updates/r125_world_scripts.sql
@@ -1,4 +1,4 @@
-update creature_template set speed='0.01',scriptname='mob_toxic_sporebat' WHERE entry=22140;
+update creature_template set speed='0.01', scriptname='mob_toxic_sporebat' WHERE entry=22140;
update creature_template SET scriptname='npc_overlord_morghor' WHERE entry=23139;
update creature_template SET scriptname='npc_lord_illidan_stormrage' WHERE entry=22083;
update creature_template SET scriptname='npc_yarzill_the_merc' WHERE entry=23141;
diff --git a/src/bindings/scripts/sql/Updates/r57_trinity.sql b/sql/updates/r57_world_scripts.sql
index b7f61b9edae..b7f61b9edae 100644
--- a/src/bindings/scripts/sql/Updates/r57_trinity.sql
+++ b/sql/updates/r57_world_scripts.sql
diff --git a/src/bindings/scripts/sql/Updates/r66_trinity.sql b/sql/updates/r66_world_scripts.sql
index c19fbe65b0a..c19fbe65b0a 100644
--- a/src/bindings/scripts/sql/Updates/r66_trinity.sql
+++ b/sql/updates/r66_world_scripts.sql
diff --git a/src/bindings/scripts/sql/Updates/r70_trinity.sql b/sql/updates/r70_world_scripts.sql
index 1bbf737c59c..1bbf737c59c 100644
--- a/src/bindings/scripts/sql/Updates/r70_trinity.sql
+++ b/sql/updates/r70_world_scripts.sql
diff --git a/src/bindings/scripts/sql/Updates/r82_trinity.sql b/sql/updates/r82_world_scripts.sql
index acdfdd06a6f..acdfdd06a6f 100644
--- a/src/bindings/scripts/sql/Updates/r82_trinity.sql
+++ b/sql/updates/r82_world_scripts.sql
diff --git a/src/bindings/scripts/sql/Updates/r86_trinity.sql b/sql/updates/r86_world_scripts.sql
index 8b1f96c1564..8b1f96c1564 100644
--- a/src/bindings/scripts/sql/Updates/r86_trinity.sql
+++ b/sql/updates/r86_world_scripts.sql
diff --git a/src/bindings/scripts/sql/full_scripts.sql b/sql/world_scripts_full.sql
index d63662a5866..fe1efabbc0c 100644
--- a/src/bindings/scripts/sql/full_scripts.sql
+++ b/sql/world_scripts_full.sql
@@ -1,871 +1,871 @@
-/* */
-
-/* WORLD BOSS */
-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;
-
-/* GO */
-UPDATE `gameobject_template` SET `ScriptName`='go_northern_crystal_pylon' WHERE `entry`=164955;
-UPDATE `gameobject_template` SET `ScriptName`='go_western_crystal_pylon' WHERE `entry`=164956;
-UPDATE `gameobject_template` SET `ScriptName`='go_eastern_crystal_pylon' WHERE `entry`=164957;
-UPDATE `gameobject_template` SET `ScriptName`='go_barov_journal' WHERE `entry`=180794;
-UPDATE `gameobject_template` SET `ScriptName`='go_field_repair_bot_74A' where `entry`= 179552;
-UPDATE `gameobject_template` SET `ScriptName`='go_orb_of_command' WHERE `entry`=179879;
-UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_madness' WHERE `entry`=180368;
-UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_the_seven' WHERE `entry`=169294;
-
-/* GUARD */
-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;
-
-/* ITEM */
-UPDATE `item_template` SET `ScriptName`='item_area_52_special' WHERE `entry`=28132;
-UPDATE `item_template` SET `ScriptName`='item_attuned_crystal_cores' WHERE `entry`=34368;
-UPDATE `item_template` SET `ScriptName`='item_blackwhelp_net' WHERE `entry`=31129;
-UPDATE `item_template` SET `ScriptName`='item_disciplinary_rod' WHERE `entry`=22473;
-UPDATE `item_template` SET `ScriptName`='item_draenei_fishing_net' WHERE `entry`=23654;
-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_muiseks_vessel' WHERE `entry` IN (9606,9618,9619,9620,9621);
-UPDATE `item_template` SET `ScriptName`='item_nether_wraith_beacon' WHERE `entry`=31742;
-UPDATE `item_template` SET `ScriptName`='item_protovoltaic_magneto_collector' WHERE `entry`=30656;
-UPDATE `item_template` SET `ScriptName`='item_razorthorn_flayer_gland' WHERE `entry`=34255;
-UPDATE `item_template` SET `ScriptName`='item_soul_cannon' WHERE `entry`=32825;
-UPDATE `item_template` SET `ScriptName`='item_sparrowhawk_net' WHERE `entry`=32321;
-UPDATE `item_template` SET `ScriptName`='item_tainted_core' WHERE `entry`=31088;
-UPDATE `item_template` SET `ScriptName`='item_tame_beast_rods' WHERE `entry` IN (15908,15911,15913,15914,15915,15916,15917,15919,15920,15921,15922,15923,23697,23702,23703,23896,23897,23898);
-UPDATE `item_template` SET `ScriptName`='item_voodoo_charm' WHERE `entry`=8149;
-UPDATE `item_template` SET `ScriptName`='item_vorenthals_presence' WHERE `entry`=30259;
-UPDATE `item_template` SET `ScriptName`='item_yehkinyas_bramble' WHERE `entry`=10699;
-UPDATE `item_template` SET `ScriptName`='item_zezzaks_shard' WHERE `entry`=31463;
-
-/* NPC (usually creatures to be found in more than one specific zone) */
-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_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_rogue_trainer' WHERE `entry` IN (918,4163,3328,4583,5165,5167,13283,16684);
-UPDATE `creature_template` SET `ScriptName`='npc_sayge' WHERE `entry`=14822;
-
-
-/* */
-/* ZONE */
-/* */
-
-/* ALTERAC MOUNTAINS */
-UPDATE `creature_template` SET `ScriptName`='npc_ravenholdt' WHERE `entry`=13936;
-
-/* ALTERAC VALLEY */
-
-
-/* ARATHI HIGHLANDS */
-
-
-/* ASHENVALE */
-
-
-/* */
-/* AUCHINDOUN */
-/* */
-
-/* MANA TOMBS */
-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;
-
-/* AUCHENAI CRYPTS */
-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;
-
-/* SETHEKK HALLS */
-UPDATE `instance_template` SET `script`='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;
-
-/* SHADOW LABYRINTH */
-UPDATE `instance_template` SET `script`='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;
-
-/* AZSHARA */
-UPDATE `creature_template` SET `ScriptName`='mobs_spitelashes' WHERE `entry` IN (6190,6193,6194,6195,6196,7885,7886,12204,12205);
-UPDATE `creature_template` SET `ScriptName`='npc_loramus_thalipedes' WHERE `entry`=7783;
-
-/* AZUREMYST ISLE */
-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_susurrus' WHERE `entry`=17435;
-
-/* BADLANDS */
-
-
-/* BARRENS */
-UPDATE `creature_template` SET `ScriptName`='npc_beaten_corpse' WHERE `entry`=10668;
-UPDATE `creature_template` SET `ScriptName`='npc_sputtervalve' WHERE `entry`=3442;
-UPDATE `creature_template` SET `ScriptName`='npc_taskmaster_fizzule' WHERE `entry`=7233;
-
-/* BLACK TEMPLE */
-UPDATE `instance_template` SET `script`='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 `creature_template` SET `ScriptName`='mob_shadowy_construct' WHERE `entry`=23111; -- Shadowy Construct in Teron Gorefiend's encounter. Commented until Mind Control is implemented.
-
-/* BLACKFATHOM DEPTHS */
-
-
-/* BLACKROCK DEPTHS */
-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_angerrel' WHERE `entry`=9035;
-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_doperel' WHERE `entry`=9040;
-UPDATE `creature_template` SET `ScriptName`='boss_general_angerforge' WHERE `entry`=9033;
-UPDATE `creature_template` SET `ScriptName`='boss_gloomrel' WHERE `entry`=9037;
-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_haterel' WHERE `entry`=9034;
-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`='boss_seethrel' WHERE `entry`=9038;
-UPDATE `creature_template` SET `ScriptName`='boss_vilerel' WHERE `entry`=9036;
-UPDATE `creature_template` SET `ScriptName`='phalanx' WHERE `entry`=9502;
-UPDATE `creature_template` SET `ScriptName`='npc_lokhtos_darkbargainer' WHERE `entry`=12944;
-UPDATE `creature_template` SET `ScriptName`='npc_kharan_mighthammer' WHERE `entry`=9021;
-
-/* BLACKROCK SPIRE */
-/* 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;
-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;
-/* BLACKROCK SPIRE Upper bosses */
-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;
-
-/* BLACKWING LAIR */
-UPDATE `instance_template` SET `script`='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;
-
-/* BLADE'S EDGE MOUNTAINS */
-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_overseer_nuaar' WHERE `entry`=21981;
-UPDATE `creature_template` SET `ScriptName`='npc_saikkal_the_elder' WHERE `entry`=22932;
-UPDATE `creature_template` SET `ScriptName`='npc_skyguard_handler_deesak' WHERE `entry`=23415;
-
-/* BLASTED LANDS */
-UPDATE `creature_template` SET `ScriptName`='npc_deathly_usher' WHERE `entry`=8816;
-UPDATE `creature_template` SET `ScriptName`='npc_fallen_hero_of_horde' WHERE `entry`=7572;
-
-/* BLOODMYST ISLE */
-UPDATE `creature_template` SET `ScriptName`='mob_webbed_creature' WHERE `entry`=17680;
-UPDATE `creature_template` SET `ScriptName`='npc_captured_sunhawk_agent' WHERE `entry`=17824;
-
-/* BURNING STEPPES */
-UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563;
-
-/* */
-/* CAVERNS OF TIME */
-/* */
-
-/* MT. HYJAL */
-UPDATE `instance_template` SET `script`='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;
-
-/* OLD HILLSBRAD */
-UPDATE `instance_template` SET `script`='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 `creature_template` SET `ScriptName`='npc_brazen' WHERE `entry`=18725;
-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;
-
-/* THE DARK PORTAL */
-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;
-
-
-/* */
-/* COILFANG RESERVOIR */
-/* */
-
-/* THE SLAVE PENS */
-
-/* THE UNDERBOG */
-UPDATE `creature_template` SET `ScriptName`='mob_underbog_mushroom' WHERE `entry`=17990;
-UPDATE `creature_template` SET `ScriptName`='boss_hungarfen' WHERE `entry`=17770;
-
-/* THE STEAMVAULT */
-UPDATE `instance_template` SET `script`='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 `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;
-
-/* SERPENTSHRINE CAVERN */
-UPDATE `instance_template` SET `script`='instance_serpent_shrine' WHERE `map`=548;
-UPDATE `creature_template` SET `ScriptName`='boss_hydross_the_unstable' WHERE `entry`=21216;
-/* Leotheras the Blind event */
-UPDATE `creature_template` SET `ScriptName`='boss_leotheras_the_blind' WHERE `entry`=21215;
-UPDATE `creature_template` SET `ScriptName`='boss_leotheras_the_blind_demonform' WHERE `entry`=21845;
-/* Fathom-lord Karathress event */
-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;
-/* Morogrim Tidewalker event */
-UPDATE `creature_template` SET `ScriptName`='boss_morogrim_tidewalker' WHERE `entry`=21213;
-UPDATE `creature_template` SET `ScriptName`='mob_water_globule' WHERE `entry`=21913;
-/* Lady Vashj event */
-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_coilfang_elite' WHERE `entry`=22055;
-UPDATE `creature_template` SET `ScriptName`='mob_coilfang_strider' WHERE `entry`=22056;
-UPDATE `creature_template` SET `ScriptName`='mob_fathom_sporebat' WHERE `entry`=22140;
-UPDATE `creature_template` SET `ScriptName`='mob_shield_generator_channel' WHERE `entry`=19870;
-
-
-/* DARKSHORE */
-
-
-/* DEADMINES */
-
-
-/* DEADWIND PASS */
-
-
-/* DESOLACE */
-
-
-/* DIRE MAUL */
-
-
-/* DUN MOROGH */
-UPDATE `creature_template` SET `ScriptName`='npc_narm_faulk' WHERE `entry`=6177;
-
-
-/* DUROTAR */
-
-
-/* DUSKWOOD */
-
-
-/* DUSTWALLOW MARSH */
-UPDATE `creature_template` SET `ScriptName`='mobs_risen_husk_spirit' WHERE `entry` IN (23554,23555);
-UPDATE `creature_template` SET `ScriptName`='npc_deserter_agitator' WHERE `entry`=23602;
-UPDATE `creature_template` SET `ScriptName`='npc_lady_jaina_proudmoore' WHERE `entry`=4968;
-UPDATE `creature_template` SET `ScriptName`='npc_nat_pagle' WHERE `entry`=12919;
-UPDATE `creature_template` SET `ScriptName`='npc_restless_apparition' WHERE `entry`=23861;
-
-/* EASTERN PLAGUELANDS */
-UPDATE `creature_template` SET `ScriptName`='mobs_ghoul_flayer' WHERE `entry` IN (8530,8531,8532);
-UPDATE `creature_template` SET `ScriptName`='npc_augustus_the_touched' WHERE `entry`=12384;
-UPDATE `creature_template` SET `ScriptName`='npc_darrowshire_spirit' WHERE `entry`=11064;
-UPDATE `creature_template` SET `ScriptName`='npc_tirion_fordring' WHERE `entry`=1855;
-
-/* ELWYNN FOREST */
-UPDATE `creature_template` SET `ScriptName`='npc_henze_faulk' WHERE `entry`=6172;
-
-/* EVERSONG WOODS */
-UPDATE `creature_template` SET `ScriptName`='mobs_mana_tapped' WHERE `entry` IN (15273,15274,15294,15298,15367);
-UPDATE `creature_template` SET `ScriptName`='npc_prospector_anvilward' WHERE `entry`=15420;
-
-/* FELWOOD */
-UPDATE `creature_template` SET `ScriptName`='npcs_riverbreeze_and_silversky' WHERE `entry` IN (9528,9529);
-
-/* FERALAS */
-UPDATE `creature_template` SET `ScriptName`='npc_gregan_brewspewer' WHERE `entry`=7775;
-UPDATE `creature_template` SET `ScriptName`='npc_screecher_spirit' WHERE `entry`=8612;
-
-/* GHOSTLANDS */
-UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_dawnstar' WHERE `entry`=17832;
-UPDATE `creature_template` SET `ScriptName`='npc_budd_nedreck' WHERE `entry`=23559;
-UPDATE `creature_template` SET `ScriptName`='npc_rathis_tomber' WHERE `entry`=16224;
-
-/* GNOMEREGAN */
-
-
-/* GRUUL'S LAIR */
-UPDATE `instance_template` SET `script`='instance_gruuls_lair' WHERE `map` =565;
-UPDATE `creature_template` SET `ScriptName`='boss_gruul' WHERE `entry`=19044;
-/* Maulgar and Event */
-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;
-
-/* */
-/* HELLFIRE CITADEL */
-/* */
-
-/* BLOOD FURNACE */
-/* The Maker,Broggok,Kelidan,Broggok's cloud */
-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;
-
-/* HELLFIRE RAMPARTS */
-/* Vazruden,Omor the Unscarred,Watchkeeper Gargolmar */
-UPDATE `creature_template` SET `ScriptName`='boss_omor_the_unscarred' WHERE `entry`=17308;
-UPDATE `creature_template` SET `ScriptName`='boss_watchkeeper_gargolmar' WHERE `entry`=17306;
-
-/* SHATTERED HALLS */
-/* Nethekurse and his spawned shadowfissure */
-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 `instance_template` SET `script`='instance_shattered_halls' WHERE `map`=540;
-
-/* MAGTHERIDON'S LAIR */
-UPDATE `instance_template` SET `script`='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_hellfire_channeler' WHERE `entry`=17256;
-
-/* HELLFIRE PENINSULA */
-UPDATE `creature_template` SET `ScriptName`='boss_doomlord_kazzak' WHERE `entry`=18728;
-UPDATE `creature_template` SET `ScriptName`='npc_wing_commander_brack' WHERE `entry`=19401;
-UPDATE `creature_template` SET `ScriptName`='npc_wing_commander_dabiree' WHERE `entry`=19409;
-UPDATE `creature_template` SET `ScriptName`='npc_gryphoneer_windbellow' WHERE `entry`=20235;
-
-/* HILLSBRAD FOOTHILLS */
-
-
-/* HINTERLANDS */
-
-
-/* IRONFORGE */
-UPDATE `creature_template` SET `ScriptName`='npc_royal_historian_archesonus' WHERE `entry`=8879;
-
-/* ISLE OF QUEL'DANAS */
-UPDATE `creature_template` SET `ScriptName`='npc_ayren_cloudbreaker' WHERE `entry`=25059;
-UPDATE `creature_template` SET `ScriptName`='npc_converted_sentry' WHERE `entry`=24981;
-UPDATE `creature_template` SET `ScriptName`='npc_unrestrained_dragonhawk' WHERE `entry`=25236;
-
-/* KARAZHAN */
-UPDATE `instance_template` SET `script`='instance_karazhan' WHERE `map`=532;
-UPDATE `creature_template` SET `ScriptName`='boss_midnight' WHERE `entry`=16151;
-UPDATE `creature_template` SET `ScriptName`='boss_attumen' WHERE `entry`=15550;
-UPDATE `creature_template` SET `ScriptName`='boss_moroes' WHERE `entry`=15687;
-UPDATE `creature_template` SET `ScriptName`='boss_maiden_of_virtue' WHERE `entry`=16457;
-UPDATE `creature_template` SET `ScriptName`='boss_curator' WHERE `entry`=15691;
-UPDATE `creature_template` SET `ScriptName`='boss_julianne' WHERE `entry`=17534;
-UPDATE `creature_template` SET `ScriptName`='boss_romulo' WHERE `entry`=17533;
-UPDATE `creature_template` SET `ScriptName`='boss_dorothee' WHERE `entry`=17535;
-UPDATE `creature_template` SET `ScriptName`='boss_strawman' WHERE `entry`=17543;
-UPDATE `creature_template` SET `ScriptName`='boss_tinhead' WHERE `entry`=17547;
-UPDATE `creature_template` SET `ScriptName`='boss_tito' WHERE `entry`=17548;
-UPDATE `creature_template` SET `ScriptName`='boss_roar' WHERE `entry`=17546;
-UPDATE `creature_template` SET `ScriptName`='boss_crone' WHERE `entry`=18168;
-UPDATE `creature_template` SET `ScriptName`='boss_terestian_illhoof' WHERE `entry`=15688;
-UPDATE `creature_template` SET `ScriptName`='boss_shade_of_aran' WHERE `entry`=16524;
-UPDATE `creature_template` SET `ScriptName`='boss_netherspite' WHERE `entry`=15689;
-UPDATE `creature_template` SET `ScriptName`='boss_malchezaar' WHERE `entry`=15690;
-UPDATE `creature_template` SET `ScriptName`='boss_nightbane' WHERE `entry`=17225;
-UPDATE `creature_template` SET `ScriptName`='boss_baroness_dorothea_millstipe' WHERE `entry`=19875;
-UPDATE `creature_template` SET `ScriptName`='boss_baron_rafe_dreuger' WHERE `entry`=19874;
-UPDATE `creature_template` SET `ScriptName`='boss_lady_catriona_von_indi' WHERE `entry`=19872;
-UPDATE `creature_template` SET `ScriptName`='boss_lady_keira_berrybuck' WHERE `entry`=17007;
-UPDATE `creature_template` SET `ScriptName`='boss_lord_robin_daris' WHERE `entry`=19876;
-UPDATE `creature_template` SET `ScriptName`='boss_lord_crispin_ference' WHERE `entry`=19873;
-UPDATE `creature_template` SET `ScriptName`='boss_bigbadwolf' WHERE `entry`=17521;
-UPDATE `creature_template` SET `ScriptName`='mob_shadow_of_aran' WHERE `entry`=18254;
-UPDATE `creature_template` SET `ScriptName`='mob_aran_elemental' WHERE `entry`=17167;
-UPDATE `creature_template` SET `ScriptName`='mob_aran_blizzard' WHERE `entry`=17161;
-UPDATE `creature_template` SET `ScriptName`='mob_homunculus' WHERE `entry`=16539;
-UPDATE `creature_template` SET `ScriptName`='mob_kilrek' WHERE `entry`=17229;
-UPDATE `creature_template` SET `ScriptName`='mob_demon_chain' WHERE `entry`=17248;
-UPDATE `creature_template` SET `ScriptName`='mob_cyclone' WHERE `entry`=18412;
-UPDATE `creature_template` SET `ScriptName`='netherspite_infernal' WHERE `entry`=17646;
-UPDATE `creature_template` SET `ScriptName`='npc_berthold' WHERE `entry`=16153;
-UPDATE `creature_template` SET `ScriptName`='npc_barnes' WHERE `entry`=16812;
-UPDATE `creature_template` SET `ScriptName`='npc_grandmother' WHERE `entry`=17603;
-
-
-/* LOCH MODAN */
-UPDATE `creature_template` SET `ScriptName`='npc_mountaineer_pebblebitty' WHERE `entry`=3836;
-
-/* Magister's Terrace */
-UPDATE `instance_template` SET `script`='instance_magisters_terrace' WHERE `map`=585;
-UPDATE `creature_template` SET `ScriptName`='boss_selin_fireheart' WHERE `entry`=24723;
-UPDATE `creature_template` SET `ScriptName`='mob_fel_crystal' WHERE `entry`=24722;
-UPDATE `creature_template` SET `ScriptName`='boss_vexallus' WHERE `entry`=24744;
-UPDATE `creature_template` SET `ScriptName`='mob_pure_energy' WHERE `entry`=24745;
-UPDATE `creature_template` SET `ScriptName`='boss_priestess_delrissa' WHERE `entry`=24560;
-UPDATE `creature_template` SET `ScriptName`='boss_kagani_nightstrike' WHERE `entry`=24557;
-UPDATE `creature_template` SET `ScriptName`='boss_ellris_duskhallow' WHERE `entry`=24558;
-UPDATE `creature_template` SET `ScriptName`='boss_eramas_brightblaze' WHERE `entry`=24554;
-UPDATE `creature_template` SET `ScriptName`='boss_yazzai' WHERE `entry`=24561;
-UPDATE `creature_template` SET `ScriptName`='boss_warlord_salaris' WHERE `entry`=24559;
-UPDATE `creature_template` SET `ScriptName`='boss_garaxxas' WHERE `entry`=24555;
-UPDATE `creature_template` SET `ScriptName`='mob_sliver' WHERE `entry`=24552;
-UPDATE `creature_template` SET `ScriptName`='boss_apoko' WHERE `entry`=24553;
-UPDATE `creature_template` SET `ScriptName`='boss_zelfan' WHERE `entry`=24556;
-UPDATE `creature_template` SET `ScriptName`='boss_felblood_kaelthas' WHERE `entry`=24664;
-UPDATE `creature_template` SET `ScriptName`='mob_arcane_sphere' WHERE `entry`=24708;
-UPDATE `creature_template` SET `ScriptName`='mob_felkael_phoenix' WHERE `entry`=24674;
-UPDATE `creature_template` SET `ScriptName`='mob_felkael_phoenix_egg' WHERE `entry`=24675;
-UPDATE `creature_template` SET `ScriptName`='mob_felkael_flamestrike' WHERE `entry`=24666;
-
-/* MARAUDON */
-UPDATE `creature_template` SET `ScriptName`='boss_princess_theradras' WHERE `entry`=12201;
-UPDATE `creature_template` SET `ScriptName`='boss_noxxion' WHERE `entry`=13282;
-UPDATE `creature_template` SET `ScriptName`='boss_landslide' WHERE `entry`=12203;
-UPDATE `creature_template` SET `ScriptName`='celebras_the_cursed' WHERE `entry`=12225;
-
-/* MOLTEN CORE */
-UPDATE `instance_template` SET `script`='instance_molten_core' WHERE `map`=409;
-UPDATE `creature_template` SET `ScriptName`='boss_lucifron' WHERE `entry`=12118;
-UPDATE `creature_template` SET `ScriptName`='boss_magmadar' WHERE `entry`=11982;
-UPDATE `creature_template` SET `ScriptName`='boss_gehennas' WHERE `entry`=12259;
-UPDATE `creature_template` SET `ScriptName`='boss_garr' WHERE `entry`=12057;
-UPDATE `creature_template` SET `ScriptName`='boss_baron_geddon' WHERE `entry`=12056;
-UPDATE `creature_template` SET `ScriptName`='boss_shazzrah' WHERE `entry`=12264;
-UPDATE `creature_template` SET `ScriptName`='boss_golemagg' WHERE `entry`=11988;
-UPDATE `creature_template` SET `ScriptName`='boss_sulfuron' WHERE `entry`=12098;
-UPDATE `creature_template` SET `ScriptName`='boss_majordomo' WHERE `entry`=12018;
-UPDATE `creature_template` SET `ScriptName`='boss_ragnaros' WHERE `entry`=11502;
-UPDATE `creature_template` SET `ScriptName`='mob_ancient_core_hound' WHERE `entry`=11673;
-UPDATE `creature_template` SET `ScriptName`='mob_firesworn' WHERE `entry`=12099;
-UPDATE `creature_template` SET `ScriptName`='mob_core_rager' WHERE `entry`=11672;
-UPDATE `creature_template` SET `ScriptName`='mob_flamewaker_priest' WHERE `entry`=11662;
-
-/* MOONGLADE */
-UPDATE `creature_template` SET `ScriptName`='npc_bunthen_plainswind' WHERE `entry`=11798;
-UPDATE `creature_template` SET `ScriptName`='npc_great_bear_spirit' WHERE `entry`=11956;
-UPDATE `creature_template` SET `ScriptName`='npc_silva_filnaveth' WHERE `entry`=11800;
-
-/* MULGORE */
-UPDATE `creature_template` SET `ScriptName`='npc_skorn_whitecloud' WHERE `entry`=3052;
-
-/* NAGRAND */
-UPDATE `creature_template` SET `ScriptName`='mob_lump' WHERE `entry`=18351;
-UPDATE `creature_template` SET `ScriptName`='mob_shattered_rumbler' WHERE `entry`=17157;
-UPDATE `creature_template` SET `ScriptName`='mob_sunspring_villager' WHERE `entry`=18240;
-UPDATE `creature_template` SET `ScriptName`='npc_altruis_the_sufferer' WHERE `entry`=18417;
-UPDATE `creature_template` SET `ScriptName`='npc_greatmother_geyah' WHERE `entry`=18141;
-UPDATE `creature_template` SET `ScriptName`='npc_lantresor_of_the_blade' WHERE `entry`=18261;
-UPDATE `creature_template` SET `ScriptName`='npc_creditmarker_visit_with_ancestors' WHERE `entry` IN (18840,18841,18842,18843);
-
-/* NAXXRAMAS */
-UPDATE `instance_template` SET `script`='instance_naxxramas' WHERE `map`=533;
-UPDATE `creature_template` SET `ScriptName`='boss_anubrekhan' WHERE `entry`=15956;
-UPDATE `creature_template` SET `ScriptName`='boss_faerlina' WHERE `entry`=15953;
-UPDATE `creature_template` SET `ScriptName`='boss_maexxna' WHERE `entry`=15952;
-UPDATE `creature_template` SET `ScriptName`='boss_noth' WHERE `entry`=15954;
-UPDATE `creature_template` SET `ScriptName`='boss_heigan' WHERE `entry`=15936;
-UPDATE `creature_template` SET `ScriptName`='boss_loatheb' WHERE `entry`=16011;
-UPDATE `creature_template` SET `ScriptName`='boss_razuvious' WHERE `entry`=16061;
-UPDATE `creature_template` SET `ScriptName`='boss_gothik' WHERE `entry`=16060;
-UPDATE `creature_template` SET `ScriptName`='boss_highlord_mograine' WHERE `entry`=16062;
-UPDATE `creature_template` SET `ScriptName`='boss_thane_korthazz' WHERE `entry`=16064;
-UPDATE `creature_template` SET `ScriptName`='boss_sir_zeliek' WHERE `entry`=16063;
-UPDATE `creature_template` SET `ScriptName`='boss_lady_blaumeux' WHERE `entry`=16065;
-UPDATE `creature_template` SET `ScriptName`='boss_patchwerk' WHERE `entry`=16028;
-UPDATE `creature_template` SET `ScriptName`='boss_grobbulus' WHERE `entry`=15931;
-UPDATE `creature_template` SET `ScriptName`='boss_gluth' WHERE `entry`=15932;
-UPDATE `creature_template` SET `ScriptName`='boss_thaddius' WHERE `entry`=15928;
-UPDATE `creature_template` SET `ScriptName`='boss_stalagg' WHERE `entry`=15929;
-UPDATE `creature_template` SET `ScriptName`='boss_fugen' WHERE `entry`=15930;
-UPDATE `creature_template` SET `ScriptName`='boss_sapphiron' WHERE `entry`=15989;
-UPDATE `creature_template` SET `ScriptName`='boss_kelthuzad' WHERE `entry`=15990;
-
-/* NETHERSTORM */
-UPDATE `gameobject_template` SET `ScriptName`='go_manaforge_control_console' WHERE `entry` IN (183770,183956,184311,184312);
-UPDATE `creature_template` SET `ScriptName`='npc_manaforge_control_console' WHERE `entry` IN (20209,20417,20418,20440);
-UPDATE `creature_template` SET `ScriptName`='npc_protectorate_nether_drake' WHERE `entry`=20903;
-UPDATE `creature_template` SET `ScriptName`='npc_veronia' WHERE `entry`=20162;
-
-/* ONYXIA'S LAIR */
-UPDATE `creature_template` SET `ScriptName`='boss_onyxia' WHERE `entry`=10184;
-
-/* ORGRIMMAR */
-UPDATE `creature_template` SET `ScriptName`='npc_neeru_fireblade' WHERE `entry`=3216;
-UPDATE `creature_template` SET `ScriptName`='npc_shenthul' WHERE `entry`=3401;
-UPDATE `creature_template` SET `ScriptName`='npc_thrall_warchief' WHERE `entry`=4949;
-
-/* RAGEFIRE CHASM */
-
-
-/* RAZORFEN DOWNS */
-UPDATE `creature_template` SET `ScriptName`='boss_amnennar_the_coldbringer' WHERE `entry`=7358;
-
-/* REDRIDGE MOUNTAINS */
-
-
-/* RUINS OF AHN'QIRAJ */
-UPDATE `instance_template` SET `script`='instance_ruins_of_ahnqiraj' WHERE `map`=509;
-
-/* SCARLET MONASTERY */
-UPDATE `creature_template` SET `ScriptName`='boss_arcanist_doan' WHERE `entry`=6487;
-UPDATE `creature_template` SET `ScriptName`='boss_azshir_the_sleepless' WHERE `entry`=6490;
-UPDATE `creature_template` SET `ScriptName`='boss_bloodmage_thalnos' WHERE `entry`=4543;
-UPDATE `creature_template` SET `ScriptName`='boss_herod' WHERE `entry`=3975;
-UPDATE `creature_template` SET `ScriptName`='boss_high_inquisitor_fairbanks' WHERE `entry`=4542;
-UPDATE `creature_template` SET `ScriptName`='boss_high_inquisitor_whitemane' WHERE `entry`=3977;
-UPDATE `creature_template` SET `ScriptName`='boss_houndmaster_loksey' WHERE `entry`=3974;
-UPDATE `creature_template` SET `ScriptName`='boss_interrogator_vishas' WHERE `entry`=3983;
-UPDATE `creature_template` SET `ScriptName`='boss_scarlet_commander_mograine' WHERE `entry`=3976;
-UPDATE `creature_template` SET `ScriptName`='boss_scorn' WHERE `entry`=14693;
-
-/* SCHOLOMANCE */
-UPDATE `instance_template` SET `script`='instance_scholomance' WHERE `map`=289;
-UPDATE `creature_template` SET `ScriptName`='boss_darkmaster_gandling' WHERE `entry`=1853;
-UPDATE `creature_template` SET `ScriptName`='boss_death_knight_darkreaver' WHERE `entry`=14516;
-UPDATE `creature_template` SET `ScriptName`='boss_lord_alexei_barov' WHERE `entry`=10504;
-UPDATE `creature_template` SET `ScriptName`='boss_instructor_malicia' WHERE `entry`=10505;
-UPDATE `creature_template` SET `ScriptName`='boss_boss_ras_frostwhisper' WHERE `entry`=10508;
-UPDATE `creature_template` SET `ScriptName`='boss_the_ravenian' WHERE `entry`=10507;
-UPDATE `creature_template` SET `ScriptName`='boss_vectus' WHERE `entry`=10432;
-UPDATE `creature_template` SET `ScriptName`='boss_illucia_barov' WHERE `entry`=10502;
-UPDATE `creature_template` SET `ScriptName`='boss_doctor_theolen_krastinov' WHERE `entry`=11261;
-UPDATE `creature_template` SET `ScriptName`='boss_jandice_barov' WHERE `entry`=10503;
-UPDATE `creature_template` SET `ScriptName`='boss_lorekeeper_polkelt' WHERE `entry`=10901;
-UPDATE `creature_template` SET `ScriptName`='boss_kormok' WHERE `entry`=16118;
-UPDATE `creature_template` SET `ScriptName`='mob_illusionofjandicebarov' WHERE `entry`=11439;
-
-/* SEARING GORGE */
-UPDATE `creature_template` SET `ScriptName`='npc_kalaran_windblade' WHERE `entry`=8479;
-UPDATE `creature_template` SET `ScriptName`='npc_lothos_riftwaker' WHERE `entry`=14387;
-UPDATE `creature_template` SET `ScriptName`='npc_zamael_lunthistle' WHERE `entry`=8436;
-
-/* SHADOWFANG KEEP */
-UPDATE `instance_template` SET `script`='instance_shadowfang_keep' WHERE `map`=33;
-UPDATE `creature_template` SET `ScriptName`='npc_shadowfang_prisoner' WHERE `entry` IN (3849,3850);
-
-/* SHADOWMOON VALLEY */
-UPDATE `creature_template` SET `ScriptName`='boss_doomwalker' WHERE `entry`=17711;
-UPDATE `creature_template` SET `ScriptName`='npc_drake_dealer_hurlunk' WHERE `entry`=23489;
-UPDATE `creature_template` SET `ScriptName`='npc_invis_legion_teleporter' WHERE `entry`=21807;
-UPDATE `creature_template` SET `ScriptName`='npcs_flanis_swiftwing_and_kagrosh' WHERE `entry` IN (21725,21727);
-UPDATE `creature_template` SET `ScriptName`='npc_murkblood_overseer' WHERE `entry`=23309;
-UPDATE `creature_template` SET `ScriptName`='npc_neltharaku' WHERE `entry`=21657;
-UPDATE `creature_template` SET `ScriptName`='npc_oronok_tornheart' WHERE `entry`=21183;
-UPDATE `creature_template` SET `ScriptName`='mob_mature_netherwing_drake' WHERE `entry`=21648;
-UPDATE `creature_template` SET `ScriptName`='mob_enslaved_netherwing_drake' WHERE `entry`=21722;
-
-/* SHATTRATH */
-UPDATE `creature_template` SET `ScriptName`='npc_raliq_the_drunk' WHERE `entry`=18585;
-UPDATE `creature_template` SET `ScriptName`='npc_salsalabim' WHERE `entry`=18584;
-UPDATE `creature_template` SET `ScriptName`='npc_shattrathflaskvendors' WHERE `entry` IN (23483,23484);
-UPDATE `creature_template` SET `ScriptName`='npc_zephyr' WHERE `entry`=25967;
-
-/* SILITHUS */
-UPDATE `creature_template` SET `ScriptName`='npcs_rutgar_and_frankal' WHERE `entry` IN (15170,15171);
-
-/* SILVERMOON */
-UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_stillblade' WHERE `entry`=17768;
-
-/* SILVERPINE FOREST */
-UPDATE `creature_template` SET `ScriptName`='npc_astor_hadren' WHERE `entry`=6497;
-
-/* STOCKADES */
-
-/* STONETALON MOUNTAINS */
-UPDATE `creature_template` SET `ScriptName`='npc_braug_dimspirit' WHERE `entry`=4489;
-
-/* STORMWIND CITY */
-UPDATE `creature_template` SET `ScriptName`='npc_archmage_malin' WHERE `entry`=2708;
-UPDATE `creature_template` SET `ScriptName`='npc_bartleby' WHERE `entry`=6090;
-UPDATE `creature_template` SET `ScriptName`='npc_dashel_stonefist' WHERE `entry`=4961;
-UPDATE `creature_template` SET `ScriptName`='npc_general_marcus_jonathan' WHERE `entry`=466;
-UPDATE `creature_template` SET `ScriptName`='npc_lady_katrana_prestor' WHERE `entry`=1749;
-
-/* STRANGLETHORN VALE */
-UPDATE `creature_template` SET `ScriptName`='mob_yenniku' WHERE `entry`=2530;
-
-/* STRATHOLME */
-UPDATE `instance_template` SET `script`='instance_stratholme' WHERE `map`=329;
-UPDATE `creature_template` SET `ScriptName`='boss_dathrohan_balnazzar' WHERE `entry`=10812;
-UPDATE `creature_template` SET `ScriptName`='boss_magistrate_barthilas' WHERE `entry`=10435;
-UPDATE `creature_template` SET `ScriptName`='boss_maleki_the_pallid' WHERE `entry`=10438;
-UPDATE `creature_template` SET `ScriptName`='boss_nerubenkan' WHERE `entry`=10437;
-UPDATE `creature_template` SET `ScriptName`='boss_cannon_master_willey' WHERE `entry`=10997;
-UPDATE `creature_template` SET `ScriptName`='boss_baroness_anastari' WHERE `entry`=10436;
-UPDATE `creature_template` SET `ScriptName`='boss_ramstein_the_gorger' WHERE `entry`=10439;
-UPDATE `creature_template` SET `ScriptName`='boss_timmy_the_cruel' WHERE `entry`=10808;
-UPDATE `creature_template` SET `ScriptName`='boss_silver_hand_bosses' WHERE `entry` IN (17910,17911,17912,17913,17914);
-UPDATE `creature_template` SET `ScriptName`='boss_postmaster_malown' WHERE `entry`=11143;
-UPDATE `creature_template` SET `ScriptName`='boss_baron_rivendare' WHERE `entry`=10440;
-UPDATE `creature_template` SET `ScriptName`='mob_mindless_skeleton' WHERE `entry`=11197;
-UPDATE `creature_template` SET `ScriptName`='mob_thuzadin_acolyte' WHERE `entry`=10399;
-UPDATE `creature_template` SET `ScriptName`='mobs_spectral_ghostly_citizen' WHERE `entry` IN (10384,10385);
-UPDATE `creature_template` SET `ScriptName`='mob_restless_soul' WHERE `entry`=11122;
-UPDATE `creature_template` SET `ScriptName`='mob_freed_soul' WHERE `entry`=11136;
-
-/* SUNKEN TEMPLE */
-
-
-/* SWAMP OF SORROWS */
-
-
-/* TANARIS */
-UPDATE `creature_template` SET `ScriptName`='mob_aquementas' WHERE `entry`=9453;
-UPDATE `creature_template` SET `ScriptName`='npc_custodian_of_time' WHERE `entry`=20129;
-UPDATE `creature_template` SET `ScriptName`='npc_marin_noggenfogger' WHERE `entry`=7564;
-UPDATE `creature_template` SET `ScriptName`='npc_steward_of_time' WHERE `entry`=20142;
-UPDATE `creature_template` SET `ScriptName`='npc_stone_watcher_of_norgannon' WHERE `entry`=7918;
-
-/* TELDRASSIL */
-
-
-/* */
-/* TEMPEST KEEP */
-/* */
-
-/* THE MECHANAR */
-UPDATE `creature_template` SET `ScriptName`='boss_gatewatcher_iron_hand' WHERE `entry`=19710;
-UPDATE `creature_template` SET `ScriptName`='boss_nethermancer_sepethrea' WHERE `entry`=19221;
-UPDATE `creature_template` SET `ScriptName`='mob_ragin_flames' WHERE `entry`=20481;
-
-/* THE BOTANICA */
-UPDATE `creature_template` SET `ScriptName`='boss_high_botanist_freywinn' WHERE `entry`=17975;
-UPDATE `creature_template` SET `ScriptName`='boss_laj' WHERE `entry`=17980;
-UPDATE `creature_template` SET `ScriptName`='boss_warp_splinter' WHERE `entry`=17977;
-UPDATE `creature_template` SET `ScriptName`='mob_warp_splinter_treant' WHERE `entry`=19949;
-
-/* THE ARCATRAZ */
-UPDATE `instance_template` SET `script`='instance_arcatraz' WHERE `map`=552;
-UPDATE `creature_template` SET `ScriptName`='mob_zerekethvoidzone' WHERE `entry`=21101;
-UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss' WHERE `entry`=20912;
-UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss_illusion' WHERE `entry` IN (21466,21467);
-UPDATE `creature_template` SET `ScriptName`='npc_warden_mellichar' WHERE `entry`=20904;
-UPDATE `creature_template` SET `ScriptName`='npc_millhouse_manastorm' WHERE `entry`=20977;
-
-/* THE EYE */
-UPDATE `instance_template` SET `script`='instance_the_eye' WHERE `map`=550;
-/* The Eye Trash Mobs */
-UPDATE `creature_template` SET `ScriptName`='mob_crystalcore_devastator' WHERE `entry`=20040;
-/* Void Reaver event */
-UPDATE `creature_template` SET `ScriptName`='boss_void_reaver' WHERE `entry`=19516;
-/* Astromancer event */
-UPDATE `creature_template` SET `ScriptName`='boss_high_astromancer_solarian' WHERE `entry`=18805;
-UPDATE `creature_template` SET `ScriptName`='mob_solarium_priest' WHERE `entry`=18806;
-/* Kael'thas event */
-UPDATE `creature_template` SET `ScriptName`='boss_kaelthas' WHERE `entry`=19622;
-UPDATE `creature_template` SET `ScriptName`='boss_thaladred_the_darkener' WHERE `entry`=20064;
-UPDATE `creature_template` SET `ScriptName`='boss_lord_sanguinar' WHERE `entry`=20060;
-UPDATE `creature_template` SET `ScriptName`='boss_grand_astromancer_capernian' WHERE `entry`=20062;
-UPDATE `creature_template` SET `ScriptName`='boss_master_engineer_telonicus' WHERE `entry`=20063;
-UPDATE `creature_template` SET `ScriptName`='mob_phoenix' WHERE `entry`=21362;
-UPDATE `creature_template` SET `ScriptName`='mob_nether_vapor' WHERE `entry`=21002;
-UPDATE `creature_template` SET `ScriptName`='mob_kael_flamestrike' WHERE `entry`=21369;
-
-/* TEMPLE OF AHN'QIRAJ */
-UPDATE `instance_template` SET `script`='instance_temple_of_ahnqiraj' WHERE `map`=531;
-UPDATE `creature_template` SET `ScriptName`='boss_cthun' WHERE `entry`=15727;
-UPDATE `creature_template` SET `ScriptName`='boss_skeram' WHERE `entry`=15263;
-UPDATE `creature_template` SET `ScriptName`='boss_vem' WHERE `entry`=15544;
-UPDATE `creature_template` SET `ScriptName`='boss_yauj' WHERE `entry`=15543;
-UPDATE `creature_template` SET `ScriptName`='boss_kri' WHERE `entry`=15511;
-UPDATE `creature_template` SET `ScriptName`='boss_sartura' WHERE `entry`=15516;
-UPDATE `creature_template` SET `ScriptName`='boss_fankriss' WHERE `entry`=15510;
-UPDATE `creature_template` SET `ScriptName`='boss_viscidus' WHERE `entry`=15299;
-UPDATE `creature_template` SET `ScriptName`='boss_glob_of_viscidus' WHERE `entry`=15667;
-UPDATE `creature_template` SET `ScriptName`='boss_huhuran' WHERE `entry`=15509;
-UPDATE `creature_template` SET `ScriptName`='boss_veklor' WHERE `entry`=15276;
-UPDATE `creature_template` SET `ScriptName`='boss_veknilash' WHERE `entry`=15275;
-UPDATE `creature_template` SET `ScriptName`='boss_ouro' WHERE `entry`=15517;
-UPDATE `creature_template` SET `ScriptName`='boss_eye_of_cthun' WHERE `entry`=15589;
-UPDATE `creature_template` SET `ScriptName`='mob_sartura_royal_guard' WHERE `entry`=15984;
-UPDATE `creature_template` SET `ScriptName`='mob_yauj_brood' WHERE `entry`=15621;
-UPDATE `creature_template` SET `ScriptName`='mob_claw_tentacle' WHERE `entry`=15725;
-UPDATE `creature_template` SET `ScriptName`='mob_eye_tentacle' WHERE `entry`=15726;
-UPDATE `creature_template` SET `ScriptName`='mob_giant_claw_tentacle' WHERE `entry`=15728;
-UPDATE `creature_template` SET `ScriptName`='mob_giant_eye_tentacle' WHERE `entry`=15334;
-UPDATE `creature_template` SET `ScriptName`='mob_giant_flesh_tentacle' WHERE `entry`=15802;
-UPDATE `creature_template` SET `ScriptName`='mob_anubisath_sentinel' WHERE `entry`=15264;
-
-/* TEROKKAR FOREST */
-UPDATE `creature_template` SET `ScriptName`='mob_infested_root_walker' WHERE `entry`=22095;
-UPDATE `creature_template` SET `ScriptName`='mob_netherweb_victim' WHERE `entry`=22355;
-UPDATE `creature_template` SET `ScriptName`='mob_rotting_forest_rager' WHERE `entry`=22307;
-UPDATE `creature_template` SET `ScriptName`='npc_floon' WHERE `entry`=18588;
-UPDATE `creature_template` SET `ScriptName`='npc_skyguard_handler_irena' WHERE `entry`=23413;
-
-/* THOUSAND NEEDLES */
-
-
-/* THUNDER BLUFF */
-UPDATE `creature_template` SET `ScriptName`='npc_cairne_bloodhoof' WHERE `entry`=3057;
-
-/* TIRISFAL GLADES */
-UPDATE `creature_template` SET `ScriptName`='npc_calvin_montague' WHERE `entry`=6784;
-
-/* ULDAMAN */
-UPDATE `creature_template` SET `ScriptName`='boss_ironaya' WHERE `entry`=7228;
-UPDATE `creature_template` SET `ScriptName`='mob_jadespine_basilisk' WHERE `entry`=4863;
-UPDATE `creature_template` SET `ScriptName`='npc_lore_keeper_of_norgannon' WHERE `entry`=7172;
-
-/* UN'GORO CRATER */
-
-
-/* UNDERCITY */
-UPDATE `creature_template` SET `ScriptName`='npc_lady_sylvanas_windrunner' WHERE `entry`=10181;
-UPDATE `creature_template` SET `ScriptName`='npc_highborne_lamenter' WHERE `entry`=21628;
-UPDATE `creature_template` SET `ScriptName`='npc_parqual_fintallas' WHERE `entry`=4488;
-
-/* WAILING CAVERNS */
-
-
-/* WESTERN PLAGUELANDS */
-UPDATE `creature_template` SET `ScriptName`='npcs_dithers_and_arbington' WHERE `entry` IN (11056,11057);
-UPDATE `creature_template` SET `ScriptName`='npc_the_scourge_cauldron' WHERE `entry`=11152;
-
-/* WESTFALL */
-
-
-/* WETLANDS */
-
-
-/* WINTERSPRING */
-UPDATE `creature_template` SET `ScriptName`='npc_lorax' WHERE `entry`=10918;
-UPDATE `creature_template` SET `ScriptName`='npc_rivern_frostwind' WHERE `entry`=10618;
-UPDATE `creature_template` SET `ScriptName`='npc_witch_doctor_mauari' WHERE `entry`=10307;
-
-/* ZANGARMARSH */
-UPDATE `creature_template` SET `ScriptName`='npcs_ashyen_and_keleth' WHERE `entry` IN (17900,17901);
-UPDATE `creature_template` SET `ScriptName`='npc_cooshcoosh' WHERE `entry`=18586;
-UPDATE `creature_template` SET `ScriptName`='npc_elder_kuruti' WHERE `entry`=18197;
-UPDATE `creature_template` SET `ScriptName`='npc_mortog_steamhead' WHERE `entry`=23373;
-
-/* ZUL'AMAN */
-UPDATE `instance_template` SET `script`='instance_zulaman' WHERE `map`=568;
-UPDATE `creature_template` SET `ScriptName`='boss_janalai' WHERE `entry`=23578;
-UPDATE `creature_template` SET `ScriptName`='boss_nalorakk' WHERE `entry`=23576;
-UPDATE `creature_template` SET `ScriptName`='mob_jandalai_firebomb' WHERE `entry`=23920;
-UPDATE `creature_template` SET `ScriptName`='mob_amanishi_hatcher' WHERE `entry`=23818;
-UPDATE `creature_template` SET `ScriptName`='mob_hatchling' WHERE `entry`=23598;
-UPDATE `creature_template` SET `ScriptName`='npc_forest_frog' WHERE `entry`=24396;
-
-/* ZUL'FARRAK */
-UPDATE `creature_template` SET `ScriptName`='npc_sergeant_bly' WHERE `entry`=7604;
-UPDATE `creature_template` SET `ScriptName`='npc_weegli_blastfuse' WHERE `entry`=7607;
-
-/* ZUL'GURUB */
-UPDATE `instance_template` SET `script`='instance_zulgurub' WHERE `map`=309;
-UPDATE `creature_template` SET `ScriptName`='boss_jeklik' WHERE `entry`=14517;
-UPDATE `creature_template` SET `ScriptName`='boss_venoxis' WHERE `entry`=14507;
-UPDATE `creature_template` SET `ScriptName`='boss_marli' WHERE `entry`=14510;
-UPDATE `creature_template` SET `ScriptName`='boss_mandokir' WHERE `entry`=11382;
-UPDATE `creature_template` SET `ScriptName`='boss_gahzranka' WHERE `entry`=15114;
-UPDATE `creature_template` SET `ScriptName`='boss_jindo' WHERE `entry`=11380;
-UPDATE `creature_template` SET `ScriptName`='boss_hakkar' WHERE `entry`=14834;
-UPDATE `creature_template` SET `ScriptName`='boss_thekal' WHERE `entry`=14509;
-UPDATE `creature_template` SET `ScriptName`='boss_arlokk' WHERE `entry`=14515;
-UPDATE `creature_template` SET `ScriptName`='boss_grilek' WHERE `entry`=15082;
-UPDATE `creature_template` SET `ScriptName`='boss_hazzarah' WHERE `entry`=15083;
-UPDATE `creature_template` SET `ScriptName`='boss_renataki' WHERE `entry`=15084;
-UPDATE `creature_template` SET `ScriptName`='boss_wushoolay' WHERE `entry`=15085;
-UPDATE `creature_template` SET `ScriptName`='mob_zealot_lorkhan' WHERE `entry`=11347;
-UPDATE `creature_template` SET `ScriptName`='mob_zealot_zath' WHERE `entry`=11348;
-UPDATE `creature_template` SET `ScriptName`='mob_healing_ward' WHERE `entry`=14987;
-UPDATE `creature_template` SET `ScriptName`='mob_spawn_of_marli' WHERE `entry`=15041;
-UPDATE `creature_template` SET `ScriptName`='mob_batrider' WHERE `entry`=14965;
-UPDATE `creature_template` SET `ScriptName`='mob_shade_of_jindo' WHERE `entry`=14986;
-
-/* EOF */
+/* */
+
+/* WORLD BOSS */
+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;
+
+/* GO */
+UPDATE `gameobject_template` SET `ScriptName`='go_northern_crystal_pylon' WHERE `entry`=164955;
+UPDATE `gameobject_template` SET `ScriptName`='go_western_crystal_pylon' WHERE `entry`=164956;
+UPDATE `gameobject_template` SET `ScriptName`='go_eastern_crystal_pylon' WHERE `entry`=164957;
+UPDATE `gameobject_template` SET `ScriptName`='go_barov_journal' WHERE `entry`=180794;
+UPDATE `gameobject_template` SET `ScriptName`='go_field_repair_bot_74A' where `entry`= 179552;
+UPDATE `gameobject_template` SET `ScriptName`='go_orb_of_command' WHERE `entry`=179879;
+UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_madness' WHERE `entry`=180368;
+UPDATE `gameobject_template` SET `ScriptName`='go_tablet_of_the_seven' WHERE `entry`=169294;
+
+/* GUARD */
+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;
+
+/* ITEM */
+UPDATE `item_template` SET `ScriptName`='item_area_52_special' WHERE `entry`=28132;
+UPDATE `item_template` SET `ScriptName`='item_attuned_crystal_cores' WHERE `entry`=34368;
+UPDATE `item_template` SET `ScriptName`='item_blackwhelp_net' WHERE `entry`=31129;
+UPDATE `item_template` SET `ScriptName`='item_disciplinary_rod' WHERE `entry`=22473;
+UPDATE `item_template` SET `ScriptName`='item_draenei_fishing_net' WHERE `entry`=23654;
+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_muiseks_vessel' WHERE `entry` IN (9606,9618,9619,9620,9621);
+UPDATE `item_template` SET `ScriptName`='item_nether_wraith_beacon' WHERE `entry`=31742;
+UPDATE `item_template` SET `ScriptName`='item_protovoltaic_magneto_collector' WHERE `entry`=30656;
+UPDATE `item_template` SET `ScriptName`='item_razorthorn_flayer_gland' WHERE `entry`=34255;
+UPDATE `item_template` SET `ScriptName`='item_soul_cannon' WHERE `entry`=32825;
+UPDATE `item_template` SET `ScriptName`='item_sparrowhawk_net' WHERE `entry`=32321;
+UPDATE `item_template` SET `ScriptName`='item_tainted_core' WHERE `entry`=31088;
+UPDATE `item_template` SET `ScriptName`='item_tame_beast_rods' WHERE `entry` IN (15908,15911,15913,15914,15915,15916,15917,15919,15920,15921,15922,15923,23697,23702,23703,23896,23897,23898);
+UPDATE `item_template` SET `ScriptName`='item_voodoo_charm' WHERE `entry`=8149;
+UPDATE `item_template` SET `ScriptName`='item_vorenthals_presence' WHERE `entry`=30259;
+UPDATE `item_template` SET `ScriptName`='item_yehkinyas_bramble' WHERE `entry`=10699;
+UPDATE `item_template` SET `ScriptName`='item_zezzaks_shard' WHERE `entry`=31463;
+
+/* NPC (usually creatures to be found in more than one specific zone) */
+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_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_rogue_trainer' WHERE `entry` IN (918,4163,3328,4583,5165,5167,13283,16684);
+UPDATE `creature_template` SET `ScriptName`='npc_sayge' WHERE `entry`=14822;
+
+
+/* */
+/* ZONE */
+/* */
+
+/* ALTERAC MOUNTAINS */
+UPDATE `creature_template` SET `ScriptName`='npc_ravenholdt' WHERE `entry`=13936;
+
+/* ALTERAC VALLEY */
+
+
+/* ARATHI HIGHLANDS */
+
+
+/* ASHENVALE */
+
+
+/* */
+/* AUCHINDOUN */
+/* */
+
+/* MANA TOMBS */
+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;
+
+/* AUCHENAI CRYPTS */
+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;
+
+/* SETHEKK HALLS */
+UPDATE `instance_template` SET `script`='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;
+
+/* SHADOW LABYRINTH */
+UPDATE `instance_template` SET `script`='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;
+
+/* AZSHARA */
+UPDATE `creature_template` SET `ScriptName`='mobs_spitelashes' WHERE `entry` IN (6190,6193,6194,6195,6196,7885,7886,12204,12205);
+UPDATE `creature_template` SET `ScriptName`='npc_loramus_thalipedes' WHERE `entry`=7783;
+
+/* AZUREMYST ISLE */
+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_susurrus' WHERE `entry`=17435;
+
+/* BADLANDS */
+
+
+/* BARRENS */
+UPDATE `creature_template` SET `ScriptName`='npc_beaten_corpse' WHERE `entry`=10668;
+UPDATE `creature_template` SET `ScriptName`='npc_sputtervalve' WHERE `entry`=3442;
+UPDATE `creature_template` SET `ScriptName`='npc_taskmaster_fizzule' WHERE `entry`=7233;
+
+/* BLACK TEMPLE */
+UPDATE `instance_template` SET `script`='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 `creature_template` SET `ScriptName`='mob_shadowy_construct' WHERE `entry`=23111; -- Shadowy Construct in Teron Gorefiend's encounter. Commented until Mind Control is implemented.
+
+/* BLACKFATHOM DEPTHS */
+
+
+/* BLACKROCK DEPTHS */
+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_angerrel' WHERE `entry`=9035;
+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_doperel' WHERE `entry`=9040;
+UPDATE `creature_template` SET `ScriptName`='boss_general_angerforge' WHERE `entry`=9033;
+UPDATE `creature_template` SET `ScriptName`='boss_gloomrel' WHERE `entry`=9037;
+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_haterel' WHERE `entry`=9034;
+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`='boss_seethrel' WHERE `entry`=9038;
+UPDATE `creature_template` SET `ScriptName`='boss_vilerel' WHERE `entry`=9036;
+UPDATE `creature_template` SET `ScriptName`='phalanx' WHERE `entry`=9502;
+UPDATE `creature_template` SET `ScriptName`='npc_lokhtos_darkbargainer' WHERE `entry`=12944;
+UPDATE `creature_template` SET `ScriptName`='npc_kharan_mighthammer' WHERE `entry`=9021;
+
+/* BLACKROCK SPIRE */
+/* 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;
+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;
+/* BLACKROCK SPIRE Upper bosses */
+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;
+
+/* BLACKWING LAIR */
+UPDATE `instance_template` SET `script`='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;
+
+/* BLADE'S EDGE MOUNTAINS */
+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_overseer_nuaar' WHERE `entry`=21981;
+UPDATE `creature_template` SET `ScriptName`='npc_saikkal_the_elder' WHERE `entry`=22932;
+UPDATE `creature_template` SET `ScriptName`='npc_skyguard_handler_deesak' WHERE `entry`=23415;
+
+/* BLASTED LANDS */
+UPDATE `creature_template` SET `ScriptName`='npc_deathly_usher' WHERE `entry`=8816;
+UPDATE `creature_template` SET `ScriptName`='npc_fallen_hero_of_horde' WHERE `entry`=7572;
+
+/* BLOODMYST ISLE */
+UPDATE `creature_template` SET `ScriptName`='mob_webbed_creature' WHERE `entry`=17680;
+UPDATE `creature_template` SET `ScriptName`='npc_captured_sunhawk_agent' WHERE `entry`=17824;
+
+/* BURNING STEPPES */
+UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563;
+
+/* */
+/* CAVERNS OF TIME */
+/* */
+
+/* MT. HYJAL */
+UPDATE `instance_template` SET `script`='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;
+
+/* OLD HILLSBRAD */
+UPDATE `instance_template` SET `script`='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 `creature_template` SET `ScriptName`='npc_brazen' WHERE `entry`=18725;
+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;
+
+/* THE DARK PORTAL */
+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;
+
+
+/* */
+/* COILFANG RESERVOIR */
+/* */
+
+/* THE SLAVE PENS */
+
+/* THE UNDERBOG */
+UPDATE `creature_template` SET `ScriptName`='mob_underbog_mushroom' WHERE `entry`=17990;
+UPDATE `creature_template` SET `ScriptName`='boss_hungarfen' WHERE `entry`=17770;
+
+/* THE STEAMVAULT */
+UPDATE `instance_template` SET `script`='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 `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;
+
+/* SERPENTSHRINE CAVERN */
+UPDATE `instance_template` SET `script`='instance_serpent_shrine' WHERE `map`=548;
+UPDATE `creature_template` SET `ScriptName`='boss_hydross_the_unstable' WHERE `entry`=21216;
+/* Leotheras the Blind event */
+UPDATE `creature_template` SET `ScriptName`='boss_leotheras_the_blind' WHERE `entry`=21215;
+UPDATE `creature_template` SET `ScriptName`='boss_leotheras_the_blind_demonform' WHERE `entry`=21845;
+/* Fathom-lord Karathress event */
+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;
+/* Morogrim Tidewalker event */
+UPDATE `creature_template` SET `ScriptName`='boss_morogrim_tidewalker' WHERE `entry`=21213;
+UPDATE `creature_template` SET `ScriptName`='mob_water_globule' WHERE `entry`=21913;
+/* Lady Vashj event */
+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_coilfang_elite' WHERE `entry`=22055;
+UPDATE `creature_template` SET `ScriptName`='mob_coilfang_strider' WHERE `entry`=22056;
+UPDATE `creature_template` SET `ScriptName`='mob_fathom_sporebat' WHERE `entry`=22140;
+UPDATE `creature_template` SET `ScriptName`='mob_shield_generator_channel' WHERE `entry`=19870;
+
+
+/* DARKSHORE */
+
+
+/* DEADMINES */
+
+
+/* DEADWIND PASS */
+
+
+/* DESOLACE */
+
+
+/* DIRE MAUL */
+
+
+/* DUN MOROGH */
+UPDATE `creature_template` SET `ScriptName`='npc_narm_faulk' WHERE `entry`=6177;
+
+
+/* DUROTAR */
+
+
+/* DUSKWOOD */
+
+
+/* DUSTWALLOW MARSH */
+UPDATE `creature_template` SET `ScriptName`='mobs_risen_husk_spirit' WHERE `entry` IN (23554,23555);
+UPDATE `creature_template` SET `ScriptName`='npc_deserter_agitator' WHERE `entry`=23602;
+UPDATE `creature_template` SET `ScriptName`='npc_lady_jaina_proudmoore' WHERE `entry`=4968;
+UPDATE `creature_template` SET `ScriptName`='npc_nat_pagle' WHERE `entry`=12919;
+UPDATE `creature_template` SET `ScriptName`='npc_restless_apparition' WHERE `entry`=23861;
+
+/* EASTERN PLAGUELANDS */
+UPDATE `creature_template` SET `ScriptName`='mobs_ghoul_flayer' WHERE `entry` IN (8530,8531,8532);
+UPDATE `creature_template` SET `ScriptName`='npc_augustus_the_touched' WHERE `entry`=12384;
+UPDATE `creature_template` SET `ScriptName`='npc_darrowshire_spirit' WHERE `entry`=11064;
+UPDATE `creature_template` SET `ScriptName`='npc_tirion_fordring' WHERE `entry`=1855;
+
+/* ELWYNN FOREST */
+UPDATE `creature_template` SET `ScriptName`='npc_henze_faulk' WHERE `entry`=6172;
+
+/* EVERSONG WOODS */
+UPDATE `creature_template` SET `ScriptName`='mobs_mana_tapped' WHERE `entry` IN (15273,15274,15294,15298,15367);
+UPDATE `creature_template` SET `ScriptName`='npc_prospector_anvilward' WHERE `entry`=15420;
+
+/* FELWOOD */
+UPDATE `creature_template` SET `ScriptName`='npcs_riverbreeze_and_silversky' WHERE `entry` IN (9528,9529);
+
+/* FERALAS */
+UPDATE `creature_template` SET `ScriptName`='npc_gregan_brewspewer' WHERE `entry`=7775;
+UPDATE `creature_template` SET `ScriptName`='npc_screecher_spirit' WHERE `entry`=8612;
+
+/* GHOSTLANDS */
+UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_dawnstar' WHERE `entry`=17832;
+UPDATE `creature_template` SET `ScriptName`='npc_budd_nedreck' WHERE `entry`=23559;
+UPDATE `creature_template` SET `ScriptName`='npc_rathis_tomber' WHERE `entry`=16224;
+
+/* GNOMEREGAN */
+
+
+/* GRUUL'S LAIR */
+UPDATE `instance_template` SET `script`='instance_gruuls_lair' WHERE `map` =565;
+UPDATE `creature_template` SET `ScriptName`='boss_gruul' WHERE `entry`=19044;
+/* Maulgar and Event */
+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;
+
+/* */
+/* HELLFIRE CITADEL */
+/* */
+
+/* BLOOD FURNACE */
+/* The Maker,Broggok,Kelidan,Broggok's cloud */
+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;
+
+/* HELLFIRE RAMPARTS */
+/* Vazruden,Omor the Unscarred,Watchkeeper Gargolmar */
+UPDATE `creature_template` SET `ScriptName`='boss_omor_the_unscarred' WHERE `entry`=17308;
+UPDATE `creature_template` SET `ScriptName`='boss_watchkeeper_gargolmar' WHERE `entry`=17306;
+
+/* SHATTERED HALLS */
+/* Nethekurse and his spawned shadowfissure */
+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 `instance_template` SET `script`='instance_shattered_halls' WHERE `map`=540;
+
+/* MAGTHERIDON'S LAIR */
+UPDATE `instance_template` SET `script`='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_hellfire_channeler' WHERE `entry`=17256;
+
+/* HELLFIRE PENINSULA */
+UPDATE `creature_template` SET `ScriptName`='boss_doomlord_kazzak' WHERE `entry`=18728;
+UPDATE `creature_template` SET `ScriptName`='npc_wing_commander_brack' WHERE `entry`=19401;
+UPDATE `creature_template` SET `ScriptName`='npc_wing_commander_dabiree' WHERE `entry`=19409;
+UPDATE `creature_template` SET `ScriptName`='npc_gryphoneer_windbellow' WHERE `entry`=20235;
+
+/* HILLSBRAD FOOTHILLS */
+
+
+/* HINTERLANDS */
+
+
+/* IRONFORGE */
+UPDATE `creature_template` SET `ScriptName`='npc_royal_historian_archesonus' WHERE `entry`=8879;
+
+/* ISLE OF QUEL'DANAS */
+UPDATE `creature_template` SET `ScriptName`='npc_ayren_cloudbreaker' WHERE `entry`=25059;
+UPDATE `creature_template` SET `ScriptName`='npc_converted_sentry' WHERE `entry`=24981;
+UPDATE `creature_template` SET `ScriptName`='npc_unrestrained_dragonhawk' WHERE `entry`=25236;
+
+/* KARAZHAN */
+UPDATE `instance_template` SET `script`='instance_karazhan' WHERE `map`=532;
+UPDATE `creature_template` SET `ScriptName`='boss_midnight' WHERE `entry`=16151;
+UPDATE `creature_template` SET `ScriptName`='boss_attumen' WHERE `entry`=15550;
+UPDATE `creature_template` SET `ScriptName`='boss_moroes' WHERE `entry`=15687;
+UPDATE `creature_template` SET `ScriptName`='boss_maiden_of_virtue' WHERE `entry`=16457;
+UPDATE `creature_template` SET `ScriptName`='boss_curator' WHERE `entry`=15691;
+UPDATE `creature_template` SET `ScriptName`='boss_julianne' WHERE `entry`=17534;
+UPDATE `creature_template` SET `ScriptName`='boss_romulo' WHERE `entry`=17533;
+UPDATE `creature_template` SET `ScriptName`='boss_dorothee' WHERE `entry`=17535;
+UPDATE `creature_template` SET `ScriptName`='boss_strawman' WHERE `entry`=17543;
+UPDATE `creature_template` SET `ScriptName`='boss_tinhead' WHERE `entry`=17547;
+UPDATE `creature_template` SET `ScriptName`='boss_tito' WHERE `entry`=17548;
+UPDATE `creature_template` SET `ScriptName`='boss_roar' WHERE `entry`=17546;
+UPDATE `creature_template` SET `ScriptName`='boss_crone' WHERE `entry`=18168;
+UPDATE `creature_template` SET `ScriptName`='boss_terestian_illhoof' WHERE `entry`=15688;
+UPDATE `creature_template` SET `ScriptName`='boss_shade_of_aran' WHERE `entry`=16524;
+UPDATE `creature_template` SET `ScriptName`='boss_netherspite' WHERE `entry`=15689;
+UPDATE `creature_template` SET `ScriptName`='boss_malchezaar' WHERE `entry`=15690;
+UPDATE `creature_template` SET `ScriptName`='boss_nightbane' WHERE `entry`=17225;
+UPDATE `creature_template` SET `ScriptName`='boss_baroness_dorothea_millstipe' WHERE `entry`=19875;
+UPDATE `creature_template` SET `ScriptName`='boss_baron_rafe_dreuger' WHERE `entry`=19874;
+UPDATE `creature_template` SET `ScriptName`='boss_lady_catriona_von_indi' WHERE `entry`=19872;
+UPDATE `creature_template` SET `ScriptName`='boss_lady_keira_berrybuck' WHERE `entry`=17007;
+UPDATE `creature_template` SET `ScriptName`='boss_lord_robin_daris' WHERE `entry`=19876;
+UPDATE `creature_template` SET `ScriptName`='boss_lord_crispin_ference' WHERE `entry`=19873;
+UPDATE `creature_template` SET `ScriptName`='boss_bigbadwolf' WHERE `entry`=17521;
+UPDATE `creature_template` SET `ScriptName`='mob_shadow_of_aran' WHERE `entry`=18254;
+UPDATE `creature_template` SET `ScriptName`='mob_aran_elemental' WHERE `entry`=17167;
+UPDATE `creature_template` SET `ScriptName`='mob_aran_blizzard' WHERE `entry`=17161;
+UPDATE `creature_template` SET `ScriptName`='mob_homunculus' WHERE `entry`=16539;
+UPDATE `creature_template` SET `ScriptName`='mob_kilrek' WHERE `entry`=17229;
+UPDATE `creature_template` SET `ScriptName`='mob_demon_chain' WHERE `entry`=17248;
+UPDATE `creature_template` SET `ScriptName`='mob_cyclone' WHERE `entry`=18412;
+UPDATE `creature_template` SET `ScriptName`='netherspite_infernal' WHERE `entry`=17646;
+UPDATE `creature_template` SET `ScriptName`='npc_berthold' WHERE `entry`=16153;
+UPDATE `creature_template` SET `ScriptName`='npc_barnes' WHERE `entry`=16812;
+UPDATE `creature_template` SET `ScriptName`='npc_grandmother' WHERE `entry`=17603;
+
+
+/* LOCH MODAN */
+UPDATE `creature_template` SET `ScriptName`='npc_mountaineer_pebblebitty' WHERE `entry`=3836;
+
+/* Magister's Terrace */
+UPDATE `instance_template` SET `script`='instance_magisters_terrace' WHERE `map`=585;
+UPDATE `creature_template` SET `ScriptName`='boss_selin_fireheart' WHERE `entry`=24723;
+UPDATE `creature_template` SET `ScriptName`='mob_fel_crystal' WHERE `entry`=24722;
+UPDATE `creature_template` SET `ScriptName`='boss_vexallus' WHERE `entry`=24744;
+UPDATE `creature_template` SET `ScriptName`='mob_pure_energy' WHERE `entry`=24745;
+UPDATE `creature_template` SET `ScriptName`='boss_priestess_delrissa' WHERE `entry`=24560;
+UPDATE `creature_template` SET `ScriptName`='boss_kagani_nightstrike' WHERE `entry`=24557;
+UPDATE `creature_template` SET `ScriptName`='boss_ellris_duskhallow' WHERE `entry`=24558;
+UPDATE `creature_template` SET `ScriptName`='boss_eramas_brightblaze' WHERE `entry`=24554;
+UPDATE `creature_template` SET `ScriptName`='boss_yazzai' WHERE `entry`=24561;
+UPDATE `creature_template` SET `ScriptName`='boss_warlord_salaris' WHERE `entry`=24559;
+UPDATE `creature_template` SET `ScriptName`='boss_garaxxas' WHERE `entry`=24555;
+UPDATE `creature_template` SET `ScriptName`='mob_sliver' WHERE `entry`=24552;
+UPDATE `creature_template` SET `ScriptName`='boss_apoko' WHERE `entry`=24553;
+UPDATE `creature_template` SET `ScriptName`='boss_zelfan' WHERE `entry`=24556;
+UPDATE `creature_template` SET `ScriptName`='boss_felblood_kaelthas' WHERE `entry`=24664;
+UPDATE `creature_template` SET `ScriptName`='mob_arcane_sphere' WHERE `entry`=24708;
+UPDATE `creature_template` SET `ScriptName`='mob_felkael_phoenix' WHERE `entry`=24674;
+UPDATE `creature_template` SET `ScriptName`='mob_felkael_phoenix_egg' WHERE `entry`=24675;
+UPDATE `creature_template` SET `ScriptName`='mob_felkael_flamestrike' WHERE `entry`=24666;
+
+/* MARAUDON */
+UPDATE `creature_template` SET `ScriptName`='boss_princess_theradras' WHERE `entry`=12201;
+UPDATE `creature_template` SET `ScriptName`='boss_noxxion' WHERE `entry`=13282;
+UPDATE `creature_template` SET `ScriptName`='boss_landslide' WHERE `entry`=12203;
+UPDATE `creature_template` SET `ScriptName`='celebras_the_cursed' WHERE `entry`=12225;
+
+/* MOLTEN CORE */
+UPDATE `instance_template` SET `script`='instance_molten_core' WHERE `map`=409;
+UPDATE `creature_template` SET `ScriptName`='boss_lucifron' WHERE `entry`=12118;
+UPDATE `creature_template` SET `ScriptName`='boss_magmadar' WHERE `entry`=11982;
+UPDATE `creature_template` SET `ScriptName`='boss_gehennas' WHERE `entry`=12259;
+UPDATE `creature_template` SET `ScriptName`='boss_garr' WHERE `entry`=12057;
+UPDATE `creature_template` SET `ScriptName`='boss_baron_geddon' WHERE `entry`=12056;
+UPDATE `creature_template` SET `ScriptName`='boss_shazzrah' WHERE `entry`=12264;
+UPDATE `creature_template` SET `ScriptName`='boss_golemagg' WHERE `entry`=11988;
+UPDATE `creature_template` SET `ScriptName`='boss_sulfuron' WHERE `entry`=12098;
+UPDATE `creature_template` SET `ScriptName`='boss_majordomo' WHERE `entry`=12018;
+UPDATE `creature_template` SET `ScriptName`='boss_ragnaros' WHERE `entry`=11502;
+UPDATE `creature_template` SET `ScriptName`='mob_ancient_core_hound' WHERE `entry`=11673;
+UPDATE `creature_template` SET `ScriptName`='mob_firesworn' WHERE `entry`=12099;
+UPDATE `creature_template` SET `ScriptName`='mob_core_rager' WHERE `entry`=11672;
+UPDATE `creature_template` SET `ScriptName`='mob_flamewaker_priest' WHERE `entry`=11662;
+
+/* MOONGLADE */
+UPDATE `creature_template` SET `ScriptName`='npc_bunthen_plainswind' WHERE `entry`=11798;
+UPDATE `creature_template` SET `ScriptName`='npc_great_bear_spirit' WHERE `entry`=11956;
+UPDATE `creature_template` SET `ScriptName`='npc_silva_filnaveth' WHERE `entry`=11800;
+
+/* MULGORE */
+UPDATE `creature_template` SET `ScriptName`='npc_skorn_whitecloud' WHERE `entry`=3052;
+
+/* NAGRAND */
+UPDATE `creature_template` SET `ScriptName`='mob_lump' WHERE `entry`=18351;
+UPDATE `creature_template` SET `ScriptName`='mob_shattered_rumbler' WHERE `entry`=17157;
+UPDATE `creature_template` SET `ScriptName`='mob_sunspring_villager' WHERE `entry`=18240;
+UPDATE `creature_template` SET `ScriptName`='npc_altruis_the_sufferer' WHERE `entry`=18417;
+UPDATE `creature_template` SET `ScriptName`='npc_greatmother_geyah' WHERE `entry`=18141;
+UPDATE `creature_template` SET `ScriptName`='npc_lantresor_of_the_blade' WHERE `entry`=18261;
+UPDATE `creature_template` SET `ScriptName`='npc_creditmarker_visit_with_ancestors' WHERE `entry` IN (18840,18841,18842,18843);
+
+/* NAXXRAMAS */
+UPDATE `instance_template` SET `script`='instance_naxxramas' WHERE `map`=533;
+UPDATE `creature_template` SET `ScriptName`='boss_anubrekhan' WHERE `entry`=15956;
+UPDATE `creature_template` SET `ScriptName`='boss_faerlina' WHERE `entry`=15953;
+UPDATE `creature_template` SET `ScriptName`='boss_maexxna' WHERE `entry`=15952;
+UPDATE `creature_template` SET `ScriptName`='boss_noth' WHERE `entry`=15954;
+UPDATE `creature_template` SET `ScriptName`='boss_heigan' WHERE `entry`=15936;
+UPDATE `creature_template` SET `ScriptName`='boss_loatheb' WHERE `entry`=16011;
+UPDATE `creature_template` SET `ScriptName`='boss_razuvious' WHERE `entry`=16061;
+UPDATE `creature_template` SET `ScriptName`='boss_gothik' WHERE `entry`=16060;
+UPDATE `creature_template` SET `ScriptName`='boss_highlord_mograine' WHERE `entry`=16062;
+UPDATE `creature_template` SET `ScriptName`='boss_thane_korthazz' WHERE `entry`=16064;
+UPDATE `creature_template` SET `ScriptName`='boss_sir_zeliek' WHERE `entry`=16063;
+UPDATE `creature_template` SET `ScriptName`='boss_lady_blaumeux' WHERE `entry`=16065;
+UPDATE `creature_template` SET `ScriptName`='boss_patchwerk' WHERE `entry`=16028;
+UPDATE `creature_template` SET `ScriptName`='boss_grobbulus' WHERE `entry`=15931;
+UPDATE `creature_template` SET `ScriptName`='boss_gluth' WHERE `entry`=15932;
+UPDATE `creature_template` SET `ScriptName`='boss_thaddius' WHERE `entry`=15928;
+UPDATE `creature_template` SET `ScriptName`='boss_stalagg' WHERE `entry`=15929;
+UPDATE `creature_template` SET `ScriptName`='boss_fugen' WHERE `entry`=15930;
+UPDATE `creature_template` SET `ScriptName`='boss_sapphiron' WHERE `entry`=15989;
+UPDATE `creature_template` SET `ScriptName`='boss_kelthuzad' WHERE `entry`=15990;
+
+/* NETHERSTORM */
+UPDATE `gameobject_template` SET `ScriptName`='go_manaforge_control_console' WHERE `entry` IN (183770,183956,184311,184312);
+UPDATE `creature_template` SET `ScriptName`='npc_manaforge_control_console' WHERE `entry` IN (20209,20417,20418,20440);
+UPDATE `creature_template` SET `ScriptName`='npc_protectorate_nether_drake' WHERE `entry`=20903;
+UPDATE `creature_template` SET `ScriptName`='npc_veronia' WHERE `entry`=20162;
+
+/* ONYXIA'S LAIR */
+UPDATE `creature_template` SET `ScriptName`='boss_onyxia' WHERE `entry`=10184;
+
+/* ORGRIMMAR */
+UPDATE `creature_template` SET `ScriptName`='npc_neeru_fireblade' WHERE `entry`=3216;
+UPDATE `creature_template` SET `ScriptName`='npc_shenthul' WHERE `entry`=3401;
+UPDATE `creature_template` SET `ScriptName`='npc_thrall_warchief' WHERE `entry`=4949;
+
+/* RAGEFIRE CHASM */
+
+
+/* RAZORFEN DOWNS */
+UPDATE `creature_template` SET `ScriptName`='boss_amnennar_the_coldbringer' WHERE `entry`=7358;
+
+/* REDRIDGE MOUNTAINS */
+
+
+/* RUINS OF AHN'QIRAJ */
+UPDATE `instance_template` SET `script`='instance_ruins_of_ahnqiraj' WHERE `map`=509;
+
+/* SCARLET MONASTERY */
+UPDATE `creature_template` SET `ScriptName`='boss_arcanist_doan' WHERE `entry`=6487;
+UPDATE `creature_template` SET `ScriptName`='boss_azshir_the_sleepless' WHERE `entry`=6490;
+UPDATE `creature_template` SET `ScriptName`='boss_bloodmage_thalnos' WHERE `entry`=4543;
+UPDATE `creature_template` SET `ScriptName`='boss_herod' WHERE `entry`=3975;
+UPDATE `creature_template` SET `ScriptName`='boss_high_inquisitor_fairbanks' WHERE `entry`=4542;
+UPDATE `creature_template` SET `ScriptName`='boss_high_inquisitor_whitemane' WHERE `entry`=3977;
+UPDATE `creature_template` SET `ScriptName`='boss_houndmaster_loksey' WHERE `entry`=3974;
+UPDATE `creature_template` SET `ScriptName`='boss_interrogator_vishas' WHERE `entry`=3983;
+UPDATE `creature_template` SET `ScriptName`='boss_scarlet_commander_mograine' WHERE `entry`=3976;
+UPDATE `creature_template` SET `ScriptName`='boss_scorn' WHERE `entry`=14693;
+
+/* SCHOLOMANCE */
+UPDATE `instance_template` SET `script`='instance_scholomance' WHERE `map`=289;
+UPDATE `creature_template` SET `ScriptName`='boss_darkmaster_gandling' WHERE `entry`=1853;
+UPDATE `creature_template` SET `ScriptName`='boss_death_knight_darkreaver' WHERE `entry`=14516;
+UPDATE `creature_template` SET `ScriptName`='boss_lord_alexei_barov' WHERE `entry`=10504;
+UPDATE `creature_template` SET `ScriptName`='boss_instructor_malicia' WHERE `entry`=10505;
+UPDATE `creature_template` SET `ScriptName`='boss_boss_ras_frostwhisper' WHERE `entry`=10508;
+UPDATE `creature_template` SET `ScriptName`='boss_the_ravenian' WHERE `entry`=10507;
+UPDATE `creature_template` SET `ScriptName`='boss_vectus' WHERE `entry`=10432;
+UPDATE `creature_template` SET `ScriptName`='boss_illucia_barov' WHERE `entry`=10502;
+UPDATE `creature_template` SET `ScriptName`='boss_doctor_theolen_krastinov' WHERE `entry`=11261;
+UPDATE `creature_template` SET `ScriptName`='boss_jandice_barov' WHERE `entry`=10503;
+UPDATE `creature_template` SET `ScriptName`='boss_lorekeeper_polkelt' WHERE `entry`=10901;
+UPDATE `creature_template` SET `ScriptName`='boss_kormok' WHERE `entry`=16118;
+UPDATE `creature_template` SET `ScriptName`='mob_illusionofjandicebarov' WHERE `entry`=11439;
+
+/* SEARING GORGE */
+UPDATE `creature_template` SET `ScriptName`='npc_kalaran_windblade' WHERE `entry`=8479;
+UPDATE `creature_template` SET `ScriptName`='npc_lothos_riftwaker' WHERE `entry`=14387;
+UPDATE `creature_template` SET `ScriptName`='npc_zamael_lunthistle' WHERE `entry`=8436;
+
+/* SHADOWFANG KEEP */
+UPDATE `instance_template` SET `script`='instance_shadowfang_keep' WHERE `map`=33;
+UPDATE `creature_template` SET `ScriptName`='npc_shadowfang_prisoner' WHERE `entry` IN (3849,3850);
+
+/* SHADOWMOON VALLEY */
+UPDATE `creature_template` SET `ScriptName`='boss_doomwalker' WHERE `entry`=17711;
+UPDATE `creature_template` SET `ScriptName`='npc_drake_dealer_hurlunk' WHERE `entry`=23489;
+UPDATE `creature_template` SET `ScriptName`='npc_invis_legion_teleporter' WHERE `entry`=21807;
+UPDATE `creature_template` SET `ScriptName`='npcs_flanis_swiftwing_and_kagrosh' WHERE `entry` IN (21725,21727);
+UPDATE `creature_template` SET `ScriptName`='npc_murkblood_overseer' WHERE `entry`=23309;
+UPDATE `creature_template` SET `ScriptName`='npc_neltharaku' WHERE `entry`=21657;
+UPDATE `creature_template` SET `ScriptName`='npc_oronok_tornheart' WHERE `entry`=21183;
+UPDATE `creature_template` SET `ScriptName`='mob_mature_netherwing_drake' WHERE `entry`=21648;
+UPDATE `creature_template` SET `ScriptName`='mob_enslaved_netherwing_drake' WHERE `entry`=21722;
+
+/* SHATTRATH */
+UPDATE `creature_template` SET `ScriptName`='npc_raliq_the_drunk' WHERE `entry`=18585;
+UPDATE `creature_template` SET `ScriptName`='npc_salsalabim' WHERE `entry`=18584;
+UPDATE `creature_template` SET `ScriptName`='npc_shattrathflaskvendors' WHERE `entry` IN (23483,23484);
+UPDATE `creature_template` SET `ScriptName`='npc_zephyr' WHERE `entry`=25967;
+
+/* SILITHUS */
+UPDATE `creature_template` SET `ScriptName`='npcs_rutgar_and_frankal' WHERE `entry` IN (15170,15171);
+
+/* SILVERMOON */
+UPDATE `creature_template` SET `ScriptName`='npc_blood_knight_stillblade' WHERE `entry`=17768;
+
+/* SILVERPINE FOREST */
+UPDATE `creature_template` SET `ScriptName`='npc_astor_hadren' WHERE `entry`=6497;
+
+/* STOCKADES */
+
+/* STONETALON MOUNTAINS */
+UPDATE `creature_template` SET `ScriptName`='npc_braug_dimspirit' WHERE `entry`=4489;
+
+/* STORMWIND CITY */
+UPDATE `creature_template` SET `ScriptName`='npc_archmage_malin' WHERE `entry`=2708;
+UPDATE `creature_template` SET `ScriptName`='npc_bartleby' WHERE `entry`=6090;
+UPDATE `creature_template` SET `ScriptName`='npc_dashel_stonefist' WHERE `entry`=4961;
+UPDATE `creature_template` SET `ScriptName`='npc_general_marcus_jonathan' WHERE `entry`=466;
+UPDATE `creature_template` SET `ScriptName`='npc_lady_katrana_prestor' WHERE `entry`=1749;
+
+/* STRANGLETHORN VALE */
+UPDATE `creature_template` SET `ScriptName`='mob_yenniku' WHERE `entry`=2530;
+
+/* STRATHOLME */
+UPDATE `instance_template` SET `script`='instance_stratholme' WHERE `map`=329;
+UPDATE `creature_template` SET `ScriptName`='boss_dathrohan_balnazzar' WHERE `entry`=10812;
+UPDATE `creature_template` SET `ScriptName`='boss_magistrate_barthilas' WHERE `entry`=10435;
+UPDATE `creature_template` SET `ScriptName`='boss_maleki_the_pallid' WHERE `entry`=10438;
+UPDATE `creature_template` SET `ScriptName`='boss_nerubenkan' WHERE `entry`=10437;
+UPDATE `creature_template` SET `ScriptName`='boss_cannon_master_willey' WHERE `entry`=10997;
+UPDATE `creature_template` SET `ScriptName`='boss_baroness_anastari' WHERE `entry`=10436;
+UPDATE `creature_template` SET `ScriptName`='boss_ramstein_the_gorger' WHERE `entry`=10439;
+UPDATE `creature_template` SET `ScriptName`='boss_timmy_the_cruel' WHERE `entry`=10808;
+UPDATE `creature_template` SET `ScriptName`='boss_silver_hand_bosses' WHERE `entry` IN (17910,17911,17912,17913,17914);
+UPDATE `creature_template` SET `ScriptName`='boss_postmaster_malown' WHERE `entry`=11143;
+UPDATE `creature_template` SET `ScriptName`='boss_baron_rivendare' WHERE `entry`=10440;
+UPDATE `creature_template` SET `ScriptName`='mob_mindless_skeleton' WHERE `entry`=11197;
+UPDATE `creature_template` SET `ScriptName`='mob_thuzadin_acolyte' WHERE `entry`=10399;
+UPDATE `creature_template` SET `ScriptName`='mobs_spectral_ghostly_citizen' WHERE `entry` IN (10384,10385);
+UPDATE `creature_template` SET `ScriptName`='mob_restless_soul' WHERE `entry`=11122;
+UPDATE `creature_template` SET `ScriptName`='mob_freed_soul' WHERE `entry`=11136;
+
+/* SUNKEN TEMPLE */
+
+
+/* SWAMP OF SORROWS */
+
+
+/* TANARIS */
+UPDATE `creature_template` SET `ScriptName`='mob_aquementas' WHERE `entry`=9453;
+UPDATE `creature_template` SET `ScriptName`='npc_custodian_of_time' WHERE `entry`=20129;
+UPDATE `creature_template` SET `ScriptName`='npc_marin_noggenfogger' WHERE `entry`=7564;
+UPDATE `creature_template` SET `ScriptName`='npc_steward_of_time' WHERE `entry`=20142;
+UPDATE `creature_template` SET `ScriptName`='npc_stone_watcher_of_norgannon' WHERE `entry`=7918;
+
+/* TELDRASSIL */
+
+
+/* */
+/* TEMPEST KEEP */
+/* */
+
+/* THE MECHANAR */
+UPDATE `creature_template` SET `ScriptName`='boss_gatewatcher_iron_hand' WHERE `entry`=19710;
+UPDATE `creature_template` SET `ScriptName`='boss_nethermancer_sepethrea' WHERE `entry`=19221;
+UPDATE `creature_template` SET `ScriptName`='mob_ragin_flames' WHERE `entry`=20481;
+
+/* THE BOTANICA */
+UPDATE `creature_template` SET `ScriptName`='boss_high_botanist_freywinn' WHERE `entry`=17975;
+UPDATE `creature_template` SET `ScriptName`='boss_laj' WHERE `entry`=17980;
+UPDATE `creature_template` SET `ScriptName`='boss_warp_splinter' WHERE `entry`=17977;
+UPDATE `creature_template` SET `ScriptName`='mob_warp_splinter_treant' WHERE `entry`=19949;
+
+/* THE ARCATRAZ */
+UPDATE `instance_template` SET `script`='instance_arcatraz' WHERE `map`=552;
+UPDATE `creature_template` SET `ScriptName`='mob_zerekethvoidzone' WHERE `entry`=21101;
+UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss' WHERE `entry`=20912;
+UPDATE `creature_template` SET `ScriptName`='boss_harbinger_skyriss_illusion' WHERE `entry` IN (21466,21467);
+UPDATE `creature_template` SET `ScriptName`='npc_warden_mellichar' WHERE `entry`=20904;
+UPDATE `creature_template` SET `ScriptName`='npc_millhouse_manastorm' WHERE `entry`=20977;
+
+/* THE EYE */
+UPDATE `instance_template` SET `script`='instance_the_eye' WHERE `map`=550;
+/* The Eye Trash Mobs */
+UPDATE `creature_template` SET `ScriptName`='mob_crystalcore_devastator' WHERE `entry`=20040;
+/* Void Reaver event */
+UPDATE `creature_template` SET `ScriptName`='boss_void_reaver' WHERE `entry`=19516;
+/* Astromancer event */
+UPDATE `creature_template` SET `ScriptName`='boss_high_astromancer_solarian' WHERE `entry`=18805;
+UPDATE `creature_template` SET `ScriptName`='mob_solarium_priest' WHERE `entry`=18806;
+/* Kael'thas event */
+UPDATE `creature_template` SET `ScriptName`='boss_kaelthas' WHERE `entry`=19622;
+UPDATE `creature_template` SET `ScriptName`='boss_thaladred_the_darkener' WHERE `entry`=20064;
+UPDATE `creature_template` SET `ScriptName`='boss_lord_sanguinar' WHERE `entry`=20060;
+UPDATE `creature_template` SET `ScriptName`='boss_grand_astromancer_capernian' WHERE `entry`=20062;
+UPDATE `creature_template` SET `ScriptName`='boss_master_engineer_telonicus' WHERE `entry`=20063;
+UPDATE `creature_template` SET `ScriptName`='mob_phoenix' WHERE `entry`=21362;
+UPDATE `creature_template` SET `ScriptName`='mob_nether_vapor' WHERE `entry`=21002;
+UPDATE `creature_template` SET `ScriptName`='mob_kael_flamestrike' WHERE `entry`=21369;
+
+/* TEMPLE OF AHN'QIRAJ */
+UPDATE `instance_template` SET `script`='instance_temple_of_ahnqiraj' WHERE `map`=531;
+UPDATE `creature_template` SET `ScriptName`='boss_cthun' WHERE `entry`=15727;
+UPDATE `creature_template` SET `ScriptName`='boss_skeram' WHERE `entry`=15263;
+UPDATE `creature_template` SET `ScriptName`='boss_vem' WHERE `entry`=15544;
+UPDATE `creature_template` SET `ScriptName`='boss_yauj' WHERE `entry`=15543;
+UPDATE `creature_template` SET `ScriptName`='boss_kri' WHERE `entry`=15511;
+UPDATE `creature_template` SET `ScriptName`='boss_sartura' WHERE `entry`=15516;
+UPDATE `creature_template` SET `ScriptName`='boss_fankriss' WHERE `entry`=15510;
+UPDATE `creature_template` SET `ScriptName`='boss_viscidus' WHERE `entry`=15299;
+UPDATE `creature_template` SET `ScriptName`='boss_glob_of_viscidus' WHERE `entry`=15667;
+UPDATE `creature_template` SET `ScriptName`='boss_huhuran' WHERE `entry`=15509;
+UPDATE `creature_template` SET `ScriptName`='boss_veklor' WHERE `entry`=15276;
+UPDATE `creature_template` SET `ScriptName`='boss_veknilash' WHERE `entry`=15275;
+UPDATE `creature_template` SET `ScriptName`='boss_ouro' WHERE `entry`=15517;
+UPDATE `creature_template` SET `ScriptName`='boss_eye_of_cthun' WHERE `entry`=15589;
+UPDATE `creature_template` SET `ScriptName`='mob_sartura_royal_guard' WHERE `entry`=15984;
+UPDATE `creature_template` SET `ScriptName`='mob_yauj_brood' WHERE `entry`=15621;
+UPDATE `creature_template` SET `ScriptName`='mob_claw_tentacle' WHERE `entry`=15725;
+UPDATE `creature_template` SET `ScriptName`='mob_eye_tentacle' WHERE `entry`=15726;
+UPDATE `creature_template` SET `ScriptName`='mob_giant_claw_tentacle' WHERE `entry`=15728;
+UPDATE `creature_template` SET `ScriptName`='mob_giant_eye_tentacle' WHERE `entry`=15334;
+UPDATE `creature_template` SET `ScriptName`='mob_giant_flesh_tentacle' WHERE `entry`=15802;
+UPDATE `creature_template` SET `ScriptName`='mob_anubisath_sentinel' WHERE `entry`=15264;
+
+/* TEROKKAR FOREST */
+UPDATE `creature_template` SET `ScriptName`='mob_infested_root_walker' WHERE `entry`=22095;
+UPDATE `creature_template` SET `ScriptName`='mob_netherweb_victim' WHERE `entry`=22355;
+UPDATE `creature_template` SET `ScriptName`='mob_rotting_forest_rager' WHERE `entry`=22307;
+UPDATE `creature_template` SET `ScriptName`='npc_floon' WHERE `entry`=18588;
+UPDATE `creature_template` SET `ScriptName`='npc_skyguard_handler_irena' WHERE `entry`=23413;
+
+/* THOUSAND NEEDLES */
+
+
+/* THUNDER BLUFF */
+UPDATE `creature_template` SET `ScriptName`='npc_cairne_bloodhoof' WHERE `entry`=3057;
+
+/* TIRISFAL GLADES */
+UPDATE `creature_template` SET `ScriptName`='npc_calvin_montague' WHERE `entry`=6784;
+
+/* ULDAMAN */
+UPDATE `creature_template` SET `ScriptName`='boss_ironaya' WHERE `entry`=7228;
+UPDATE `creature_template` SET `ScriptName`='mob_jadespine_basilisk' WHERE `entry`=4863;
+UPDATE `creature_template` SET `ScriptName`='npc_lore_keeper_of_norgannon' WHERE `entry`=7172;
+
+/* UN'GORO CRATER */
+
+
+/* UNDERCITY */
+UPDATE `creature_template` SET `ScriptName`='npc_lady_sylvanas_windrunner' WHERE `entry`=10181;
+UPDATE `creature_template` SET `ScriptName`='npc_highborne_lamenter' WHERE `entry`=21628;
+UPDATE `creature_template` SET `ScriptName`='npc_parqual_fintallas' WHERE `entry`=4488;
+
+/* WAILING CAVERNS */
+
+
+/* WESTERN PLAGUELANDS */
+UPDATE `creature_template` SET `ScriptName`='npcs_dithers_and_arbington' WHERE `entry` IN (11056,11057);
+UPDATE `creature_template` SET `ScriptName`='npc_the_scourge_cauldron' WHERE `entry`=11152;
+
+/* WESTFALL */
+
+
+/* WETLANDS */
+
+
+/* WINTERSPRING */
+UPDATE `creature_template` SET `ScriptName`='npc_lorax' WHERE `entry`=10918;
+UPDATE `creature_template` SET `ScriptName`='npc_rivern_frostwind' WHERE `entry`=10618;
+UPDATE `creature_template` SET `ScriptName`='npc_witch_doctor_mauari' WHERE `entry`=10307;
+
+/* ZANGARMARSH */
+UPDATE `creature_template` SET `ScriptName`='npcs_ashyen_and_keleth' WHERE `entry` IN (17900,17901);
+UPDATE `creature_template` SET `ScriptName`='npc_cooshcoosh' WHERE `entry`=18586;
+UPDATE `creature_template` SET `ScriptName`='npc_elder_kuruti' WHERE `entry`=18197;
+UPDATE `creature_template` SET `ScriptName`='npc_mortog_steamhead' WHERE `entry`=23373;
+
+/* ZUL'AMAN */
+UPDATE `instance_template` SET `script`='instance_zulaman' WHERE `map`=568;
+UPDATE `creature_template` SET `ScriptName`='boss_janalai' WHERE `entry`=23578;
+UPDATE `creature_template` SET `ScriptName`='boss_nalorakk' WHERE `entry`=23576;
+UPDATE `creature_template` SET `ScriptName`='mob_jandalai_firebomb' WHERE `entry`=23920;
+UPDATE `creature_template` SET `ScriptName`='mob_amanishi_hatcher' WHERE `entry`=23818;
+UPDATE `creature_template` SET `ScriptName`='mob_hatchling' WHERE `entry`=23598;
+UPDATE `creature_template` SET `ScriptName`='npc_forest_frog' WHERE `entry`=24396;
+
+/* ZUL'FARRAK */
+UPDATE `creature_template` SET `ScriptName`='npc_sergeant_bly' WHERE `entry`=7604;
+UPDATE `creature_template` SET `ScriptName`='npc_weegli_blastfuse' WHERE `entry`=7607;
+
+/* ZUL'GURUB */
+UPDATE `instance_template` SET `script`='instance_zulgurub' WHERE `map`=309;
+UPDATE `creature_template` SET `ScriptName`='boss_jeklik' WHERE `entry`=14517;
+UPDATE `creature_template` SET `ScriptName`='boss_venoxis' WHERE `entry`=14507;
+UPDATE `creature_template` SET `ScriptName`='boss_marli' WHERE `entry`=14510;
+UPDATE `creature_template` SET `ScriptName`='boss_mandokir' WHERE `entry`=11382;
+UPDATE `creature_template` SET `ScriptName`='boss_gahzranka' WHERE `entry`=15114;
+UPDATE `creature_template` SET `ScriptName`='boss_jindo' WHERE `entry`=11380;
+UPDATE `creature_template` SET `ScriptName`='boss_hakkar' WHERE `entry`=14834;
+UPDATE `creature_template` SET `ScriptName`='boss_thekal' WHERE `entry`=14509;
+UPDATE `creature_template` SET `ScriptName`='boss_arlokk' WHERE `entry`=14515;
+UPDATE `creature_template` SET `ScriptName`='boss_grilek' WHERE `entry`=15082;
+UPDATE `creature_template` SET `ScriptName`='boss_hazzarah' WHERE `entry`=15083;
+UPDATE `creature_template` SET `ScriptName`='boss_renataki' WHERE `entry`=15084;
+UPDATE `creature_template` SET `ScriptName`='boss_wushoolay' WHERE `entry`=15085;
+UPDATE `creature_template` SET `ScriptName`='mob_zealot_lorkhan' WHERE `entry`=11347;
+UPDATE `creature_template` SET `ScriptName`='mob_zealot_zath' WHERE `entry`=11348;
+UPDATE `creature_template` SET `ScriptName`='mob_healing_ward' WHERE `entry`=14987;
+UPDATE `creature_template` SET `ScriptName`='mob_spawn_of_marli' WHERE `entry`=15041;
+UPDATE `creature_template` SET `ScriptName`='mob_batrider' WHERE `entry`=14965;
+UPDATE `creature_template` SET `ScriptName`='mob_shade_of_jindo' WHERE `entry`=14986;
+
+/* EOF */
diff --git a/src/bindings/scripts/sql/scripts_structure.sql b/sql/world_scripts_structure.sql
index dff8a54a806..eb305d2e40d 100644
--- a/src/bindings/scripts/sql/scripts_structure.sql
+++ b/sql/world_scripts_structure.sql
@@ -1,101 +1,101 @@
-DROP TABLE IF EXISTS `custom_texts`;
-CREATE TABLE `custom_texts` (
- `entry` mediumint(8) NOT NULL,
- `content_default` text NOT NULL,
- `content_loc1` text,
- `content_loc2` text,
- `content_loc3` text,
- `content_loc4` text,
- `content_loc5` text,
- `content_loc6` text,
- `content_loc7` text,
- `content_loc8` text,
- `sound` mediumint(8) unsigned NOT NULL default '0',
- `type` tinyint unsigned NOT NULL default '0',
- `language` tinyint unsigned NOT NULL default '0',
- `comment` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts';
-
-DROP TABLE IF EXISTS `eventai_scripts`;
-CREATE TABLE `eventai_scripts` (
- `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT,
- `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier',
- `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type',
- `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
- `event_chance` int(3) unsigned NOT NULL default '100',
- `event_flags` int(3) unsigned NOT NULL default '0',
- `event_param1` int(11) signed NOT NULL default '0',
- `event_param2` int(11) signed NOT NULL default '0',
- `event_param3` int(11) signed NOT NULL default '0',
- `event_param4` int(11) signed NOT NULL default '0',
- `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
- `action1_param1` int(11) signed NOT NULL default '0',
- `action1_param2` int(11) signed NOT NULL default '0',
- `action1_param3` int(11) signed NOT NULL default '0',
- `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
- `action2_param1` int(11) signed NOT NULL default '0',
- `action2_param2` int(11) signed NOT NULL default '0',
- `action2_param3` int(11) signed NOT NULL default '0',
- `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
- `action3_param1` int(11) signed NOT NULL default '0',
- `action3_param2` int(11) signed NOT NULL default '0',
- `action3_param3` int(11) signed NOT NULL default '0',
- `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts';
-
-DROP TABLE IF EXISTS `eventai_summons`;
-CREATE TABLE `eventai_summons` (
- `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
- `position_x` float NOT NULL default '0',
- `position_y` float NOT NULL default '0',
- `position_z` float NOT NULL default '0',
- `orientation` float NOT NULL default '0',
- `spawntimesecs` int(11) unsigned NOT NULL default '120',
- `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';
-
-DROP TABLE IF EXISTS `eventai_texts`;
-CREATE TABLE `eventai_texts` (
- `entry` mediumint(8) NOT NULL,
- `content_default` text NOT NULL,
- `content_loc1` text,
- `content_loc2` text,
- `content_loc3` text,
- `content_loc4` text,
- `content_loc5` text,
- `content_loc6` text,
- `content_loc7` text,
- `content_loc8` text,
- `sound` mediumint(8) unsigned NOT NULL default '0',
- `type` tinyint unsigned NOT NULL default '0',
- `language` tinyint unsigned NOT NULL default '0',
- `comment` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
-
-DROP TABLE IF EXISTS `script_texts`;
-CREATE TABLE `script_texts` (
- `entry` mediumint(8) NOT NULL,
- `content_default` text NOT NULL,
- `content_loc1` text,
- `content_loc2` text,
- `content_loc3` text,
- `content_loc4` text,
- `content_loc5` text,
- `content_loc6` text,
- `content_loc7` text,
- `content_loc8` text,
- `sound` mediumint(8) unsigned NOT NULL default '0',
- `type` tinyint unsigned NOT NULL default '0',
- `language` tinyint unsigned NOT NULL default '0',
- `comment` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
-
-DROP TABLE IF EXISTS `script_db_version`;
-CREATE TABLE `script_db_version` (
- `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+DROP TABLE IF EXISTS `custom_texts`;
+CREATE TABLE `custom_texts` (
+ `entry` mediumint(8) NOT NULL,
+ `content_default` text NOT NULL,
+ `content_loc1` text,
+ `content_loc2` text,
+ `content_loc3` text,
+ `content_loc4` text,
+ `content_loc5` text,
+ `content_loc6` text,
+ `content_loc7` text,
+ `content_loc8` text,
+ `sound` mediumint(8) unsigned NOT NULL default '0',
+ `type` tinyint unsigned NOT NULL default '0',
+ `language` tinyint unsigned NOT NULL default '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts';
+
+DROP TABLE IF EXISTS `eventai_scripts`;
+CREATE TABLE `eventai_scripts` (
+ `id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT,
+ `creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier',
+ `event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type',
+ `event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
+ `event_chance` int(3) unsigned NOT NULL default '100',
+ `event_flags` int(3) unsigned NOT NULL default '0',
+ `event_param1` int(11) signed NOT NULL default '0',
+ `event_param2` int(11) signed NOT NULL default '0',
+ `event_param3` int(11) signed NOT NULL default '0',
+ `event_param4` int(11) signed NOT NULL default '0',
+ `action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action1_param1` int(11) signed NOT NULL default '0',
+ `action1_param2` int(11) signed NOT NULL default '0',
+ `action1_param3` int(11) signed NOT NULL default '0',
+ `action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action2_param1` int(11) signed NOT NULL default '0',
+ `action2_param2` int(11) signed NOT NULL default '0',
+ `action2_param3` int(11) signed NOT NULL default '0',
+ `action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
+ `action3_param1` int(11) signed NOT NULL default '0',
+ `action3_param2` int(11) signed NOT NULL default '0',
+ `action3_param3` int(11) signed NOT NULL default '0',
+ `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts';
+
+DROP TABLE IF EXISTS `eventai_summons`;
+CREATE TABLE `eventai_summons` (
+ `id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ `orientation` float NOT NULL default '0',
+ `spawntimesecs` int(11) unsigned NOT NULL default '120',
+ `comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';
+
+DROP TABLE IF EXISTS `eventai_texts`;
+CREATE TABLE `eventai_texts` (
+ `entry` mediumint(8) NOT NULL,
+ `content_default` text NOT NULL,
+ `content_loc1` text,
+ `content_loc2` text,
+ `content_loc3` text,
+ `content_loc4` text,
+ `content_loc5` text,
+ `content_loc6` text,
+ `content_loc7` text,
+ `content_loc8` text,
+ `sound` mediumint(8) unsigned NOT NULL default '0',
+ `type` tinyint unsigned NOT NULL default '0',
+ `language` tinyint unsigned NOT NULL default '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
+
+DROP TABLE IF EXISTS `script_texts`;
+CREATE TABLE `script_texts` (
+ `entry` mediumint(8) NOT NULL,
+ `content_default` text NOT NULL,
+ `content_loc1` text,
+ `content_loc2` text,
+ `content_loc3` text,
+ `content_loc4` text,
+ `content_loc5` text,
+ `content_loc6` text,
+ `content_loc7` text,
+ `content_loc8` text,
+ `sound` mediumint(8) unsigned NOT NULL default '0',
+ `type` tinyint unsigned NOT NULL default '0',
+ `language` tinyint unsigned NOT NULL default '0',
+ `comment` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
+
+DROP TABLE IF EXISTS `script_db_version`;
+CREATE TABLE `script_db_version` (
+ `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/src/bindings/scripts/sql/Makefile.am b/src/bindings/scripts/sql/Makefile.am
deleted file mode 100644
index 27a1f3f0fbd..00000000000
--- a/src/bindings/scripts/sql/Makefile.am
+++ /dev/null
@@ -1,33 +0,0 @@
-# Copyright (C) 2005-2008 MaNGOS <http://www.mangosproject.org/>
-#
-# Copyright (C) 2008 Trinity <http://www.trinitycore.org/>
-#
-# This program is free software; you can redistribute it and/or modify
-# it under the terms of the GNU General Public License as published by
-# the Free Software Foundation; either version 2 of the License, or
-# (at your option) any later version.
-#
-# This program is distributed in the hope that it will be useful,
-# but WITHOUT ANY WARRANTY; without even the implied warranty of
-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-# GNU General Public License for more details.
-#
-# You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-
-## Process this file with automake to produce Makefile.in
-
-## Sub-directories to parse
-SUBDIRS = Updates
-
-## Change installation location
-# datadir = scriptdev2/sql
-pkgdatadir = $(datadir)/scripts/sql
-
-## Files to be installed
-# Install basic SQL files to datadir
-pkgdata_DATA = \
- create_database.sql \
- full_scripts.sql \
- scripts_structure.sql
diff --git a/src/bindings/scripts/sql/Makefile.in b/src/bindings/scripts/sql/Makefile.in
deleted file mode 100644
index 2b4eaca2d8f..00000000000
--- a/src/bindings/scripts/sql/Makefile.in
+++ /dev/null
@@ -1,542 +0,0 @@
-# Makefile.in generated by automake 1.9.6 from Makefile.am.
-# @configure_input@
-
-# Copyright (C) 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002,
-# 2003, 2004, 2005 Free Software Foundation, Inc.
-# This Makefile.in is free software; the Free Software Foundation
-# gives unlimited permission to copy and/or distribute it,
-# with or without modifications, as long as this notice is preserved.
-
-# This program is distributed in the hope that it will be useful,
-# but WITHOUT ANY WARRANTY, to the extent permitted by law; without
-# even the implied warranty of MERCHANTABILITY or FITNESS FOR A
-# PARTICULAR PURPOSE.
-
-@SET_MAKE@
-
-# Copyright (C) 2005-2008 MaNGOS <http://www.mangosproject.org/>
-#
-# Copyright (C) 2008 Trinity <http://www.trinitycore.org/>
-#
-# This program is free software; you can redistribute it and/or modify
-# it under the terms of the GNU General Public License as published by
-# the Free Software Foundation; either version 2 of the License, or
-# (at your option) any later version.
-#
-# This program is distributed in the hope that it will be useful,
-# but WITHOUT ANY WARRANTY; without even the implied warranty of
-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-# GNU General Public License for more details.
-#
-# You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-
-srcdir = @srcdir@
-top_srcdir = @top_srcdir@
-VPATH = @srcdir@
-pkglibdir = $(libdir)/@PACKAGE@
-pkgincludedir = $(includedir)/@PACKAGE@
-top_builddir = ../../../..
-am__cd = CDPATH="$${ZSH_VERSION+.}$(PATH_SEPARATOR)" && cd
-INSTALL = @INSTALL@
-install_sh_DATA = $(install_sh) -c -m 644
-install_sh_PROGRAM = $(install_sh) -c
-install_sh_SCRIPT = $(install_sh) -c
-INSTALL_HEADER = $(INSTALL_DATA)
-transform = $(program_transform_name)
-NORMAL_INSTALL = :
-PRE_INSTALL = :
-POST_INSTALL = :
-NORMAL_UNINSTALL = :
-PRE_UNINSTALL = :
-POST_UNINSTALL = :
-build_triplet = @build@
-host_triplet = @host@
-subdir = src/bindings/ScriptDev2/sql
-DIST_COMMON = $(srcdir)/Makefile.am $(srcdir)/Makefile.in
-ACLOCAL_M4 = $(top_srcdir)/aclocal.m4
-am__aclocal_m4_deps = $(top_srcdir)/configure.ac
-am__configure_deps = $(am__aclocal_m4_deps) $(CONFIGURE_DEPENDENCIES) \
- $(ACLOCAL_M4)
-mkinstalldirs = $(install_sh) -d
-CONFIG_HEADER = $(top_builddir)/config.h
-CONFIG_CLEAN_FILES =
-SOURCES =
-DIST_SOURCES =
-RECURSIVE_TARGETS = all-recursive check-recursive dvi-recursive \
- html-recursive info-recursive install-data-recursive \
- install-exec-recursive install-info-recursive \
- install-recursive installcheck-recursive installdirs-recursive \
- pdf-recursive ps-recursive uninstall-info-recursive \
- uninstall-recursive
-am__vpath_adj_setup = srcdirstrip=`echo "$(srcdir)" | sed 's|.|.|g'`;
-am__vpath_adj = case $$p in \
- $(srcdir)/*) f=`echo "$$p" | sed "s|^$$srcdirstrip/||"`;; \
- *) f=$$p;; \
- esac;
-am__strip_dir = `echo $$p | sed -e 's|^.*/||'`;
-am__installdirs = "$(DESTDIR)$(pkgdatadir)"
-pkgdataDATA_INSTALL = $(INSTALL_DATA)
-DATA = $(pkgdata_DATA)
-ETAGS = etags
-CTAGS = ctags
-DIST_SUBDIRS = $(SUBDIRS)
-DISTFILES = $(DIST_COMMON) $(DIST_SOURCES) $(TEXINFOS) $(EXTRA_DIST)
-
-# datadir = scriptdev2/sql
-pkgdatadir = $(datadir)/scriptdev2/sql
-ACLOCAL = @ACLOCAL@
-AMDEP_FALSE = @AMDEP_FALSE@
-AMDEP_TRUE = @AMDEP_TRUE@
-AMTAR = @AMTAR@
-AR = @AR@
-AUTOCONF = @AUTOCONF@
-AUTOHEADER = @AUTOHEADER@
-AUTOMAKE = @AUTOMAKE@
-AWK = @AWK@
-CC = @CC@
-CCDEPMODE = @CCDEPMODE@
-CFLAGS = @CFLAGS@
-COMPATLIB = @COMPATLIB@
-CPP = @CPP@
-CPPFLAGS = @CPPFLAGS@
-CXX = @CXX@
-CXXCPP = @CXXCPP@
-CXXDEPMODE = @CXXDEPMODE@
-CXXFLAGS = @CXXFLAGS@
-CYGPATH_W = @CYGPATH_W@
-DEFS = @DEFS@
-DEPDIR = @DEPDIR@
-DOXYGENPATH = @DOXYGENPATH@
-ECHO = @ECHO@
-ECHO_C = @ECHO_C@
-ECHO_N = @ECHO_N@
-ECHO_T = @ECHO_T@
-EGREP = @EGREP@
-EXEEXT = @EXEEXT@
-F77 = @F77@
-FFLAGS = @FFLAGS@
-GREP = @GREP@
-INSTALL_DATA = @INSTALL_DATA@
-INSTALL_PROGRAM = @INSTALL_PROGRAM@
-INSTALL_SCRIPT = @INSTALL_SCRIPT@
-INSTALL_STRIP_PROGRAM = @INSTALL_STRIP_PROGRAM@
-LDFLAGS = @LDFLAGS@
-LIBOBJS = @LIBOBJS@
-LIBS = @LIBS@
-LIBTOOL = @LIBTOOL@
-LN_S = @LN_S@
-LTLIBOBJS = @LTLIBOBJS@
-MAINT = @MAINT@
-MAINTAINER_MODE_FALSE = @MAINTAINER_MODE_FALSE@
-MAINTAINER_MODE_TRUE = @MAINTAINER_MODE_TRUE@
-MAKEINFO = @MAKEINFO@
-MANGOSD_DEBUG_INFO = @MANGOSD_DEBUG_INFO@
-MANGOSD_ENABLE_CLI = @MANGOSD_ENABLE_CLI@
-MANGOSD_ENABLE_RA = @MANGOSD_ENABLE_RA@
-MYSQL_CONFIG = @MYSQL_CONFIG@
-MYSQL_INCLUDES = @MYSQL_INCLUDES@
-MYSQL_LIBS = @MYSQL_LIBS@
-OBJEXT = @OBJEXT@
-PACKAGE = @PACKAGE@
-PACKAGE_BUGREPORT = @PACKAGE_BUGREPORT@
-PACKAGE_NAME = @PACKAGE_NAME@
-PACKAGE_STRING = @PACKAGE_STRING@
-PACKAGE_TARNAME = @PACKAGE_TARNAME@
-PACKAGE_VERSION = @PACKAGE_VERSION@
-PATH_SEPARATOR = @PATH_SEPARATOR@
-RANLIB = @RANLIB@
-SET_MAKE = @SET_MAKE@
-SHELL = @SHELL@
-SSLLIB = @SSLLIB@
-STRIP = @STRIP@
-USE_DOXYGEN_FALSE = @USE_DOXYGEN_FALSE@
-USE_DOXYGEN_TRUE = @USE_DOXYGEN_TRUE@
-VERSION = @VERSION@
-ZLIB = @ZLIB@
-ac_ct_CC = @ac_ct_CC@
-ac_ct_CXX = @ac_ct_CXX@
-ac_ct_F77 = @ac_ct_F77@
-am__fastdepCC_FALSE = @am__fastdepCC_FALSE@
-am__fastdepCC_TRUE = @am__fastdepCC_TRUE@
-am__fastdepCXX_FALSE = @am__fastdepCXX_FALSE@
-am__fastdepCXX_TRUE = @am__fastdepCXX_TRUE@
-am__include = @am__include@
-am__leading_dot = @am__leading_dot@
-am__quote = @am__quote@
-am__tar = @am__tar@
-am__untar = @am__untar@
-bindir = @bindir@
-build = @build@
-build_alias = @build_alias@
-build_cpu = @build_cpu@
-build_os = @build_os@
-build_vendor = @build_vendor@
-datadir = @datadir@
-datarootdir = @datarootdir@
-docdir = @docdir@
-dvidir = @dvidir@
-exec_prefix = @exec_prefix@
-host = @host@
-host_alias = @host_alias@
-host_cpu = @host_cpu@
-host_os = @host_os@
-host_vendor = @host_vendor@
-htmldir = @htmldir@
-includedir = @includedir@
-infodir = @infodir@
-install_sh = @install_sh@
-libdir = @libdir@
-libexecdir = @libexecdir@
-localedir = @localedir@
-localstatedir = @localstatedir@
-mandir = @mandir@
-mkdir_p = @mkdir_p@
-oldincludedir = @oldincludedir@
-pdfdir = @pdfdir@
-prefix = @prefix@
-program_transform_name = @program_transform_name@
-psdir = @psdir@
-sbindir = @sbindir@
-sharedstatedir = @sharedstatedir@
-sysconfdir = @sysconfdir@
-target_alias = @target_alias@
-SUBDIRS = Updates
-
-# Install basic SQL files to datadir
-pkgdata_DATA = \
- scripts.sql
-
-all: all-recursive
-
-.SUFFIXES:
-$(srcdir)/Makefile.in: @MAINTAINER_MODE_TRUE@ $(srcdir)/Makefile.am $(am__configure_deps)
- @for dep in $?; do \
- case '$(am__configure_deps)' in \
- *$$dep*) \
- cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh \
- && exit 0; \
- exit 1;; \
- esac; \
- done; \
- echo ' cd $(top_srcdir) && $(AUTOMAKE) --gnu src/bindings/ScriptDev2/sql/Makefile'; \
- cd $(top_srcdir) && \
- $(AUTOMAKE) --gnu src/bindings/ScriptDev2/sql/Makefile
-.PRECIOUS: Makefile
-Makefile: $(srcdir)/Makefile.in $(top_builddir)/config.status
- @case '$?' in \
- *config.status*) \
- cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh;; \
- *) \
- echo ' cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe)'; \
- cd $(top_builddir) && $(SHELL) ./config.status $(subdir)/$@ $(am__depfiles_maybe);; \
- esac;
-
-$(top_builddir)/config.status: $(top_srcdir)/configure $(CONFIG_STATUS_DEPENDENCIES)
- cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
-
-$(top_srcdir)/configure: @MAINTAINER_MODE_TRUE@ $(am__configure_deps)
- cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
-$(ACLOCAL_M4): @MAINTAINER_MODE_TRUE@ $(am__aclocal_m4_deps)
- cd $(top_builddir) && $(MAKE) $(AM_MAKEFLAGS) am--refresh
-
-mostlyclean-libtool:
- -rm -f *.lo
-
-clean-libtool:
- -rm -rf .libs _libs
-
-distclean-libtool:
- -rm -f libtool
-uninstall-info-am:
-install-pkgdataDATA: $(pkgdata_DATA)
- @$(NORMAL_INSTALL)
- test -z "$(pkgdatadir)" || $(mkdir_p) "$(DESTDIR)$(pkgdatadir)"
- @list='$(pkgdata_DATA)'; for p in $$list; do \
- if test -f "$$p"; then d=; else d="$(srcdir)/"; fi; \
- f=$(am__strip_dir) \
- echo " $(pkgdataDATA_INSTALL) '$$d$$p' '$(DESTDIR)$(pkgdatadir)/$$f'"; \
- $(pkgdataDATA_INSTALL) "$$d$$p" "$(DESTDIR)$(pkgdatadir)/$$f"; \
- done
-
-uninstall-pkgdataDATA:
- @$(NORMAL_UNINSTALL)
- @list='$(pkgdata_DATA)'; for p in $$list; do \
- f=$(am__strip_dir) \
- echo " rm -f '$(DESTDIR)$(pkgdatadir)/$$f'"; \
- rm -f "$(DESTDIR)$(pkgdatadir)/$$f"; \
- done
-
-# This directory's subdirectories are mostly independent; you can cd
-# into them and run `make' without going through this Makefile.
-# To change the values of `make' variables: instead of editing Makefiles,
-# (1) if the variable is set in `config.status', edit `config.status'
-# (which will cause the Makefiles to be regenerated when you run `make');
-# (2) otherwise, pass the desired values on the `make' command line.
-$(RECURSIVE_TARGETS):
- @failcom='exit 1'; \
- for f in x $$MAKEFLAGS; do \
- case $$f in \
- *=* | --[!k]*);; \
- *k*) failcom='fail=yes';; \
- esac; \
- done; \
- dot_seen=no; \
- target=`echo $@ | sed s/-recursive//`; \
- list='$(SUBDIRS)'; for subdir in $$list; do \
- echo "Making $$target in $$subdir"; \
- if test "$$subdir" = "."; then \
- dot_seen=yes; \
- local_target="$$target-am"; \
- else \
- local_target="$$target"; \
- fi; \
- (cd $$subdir && $(MAKE) $(AM_MAKEFLAGS) $$local_target) \
- || eval $$failcom; \
- done; \
- if test "$$dot_seen" = "no"; then \
- $(MAKE) $(AM_MAKEFLAGS) "$$target-am" || exit 1; \
- fi; test -z "$$fail"
-
-mostlyclean-recursive clean-recursive distclean-recursive \
-maintainer-clean-recursive:
- @failcom='exit 1'; \
- for f in x $$MAKEFLAGS; do \
- case $$f in \
- *=* | --[!k]*);; \
- *k*) failcom='fail=yes';; \
- esac; \
- done; \
- dot_seen=no; \
- case "$@" in \
- distclean-* | maintainer-clean-*) list='$(DIST_SUBDIRS)' ;; \
- *) list='$(SUBDIRS)' ;; \
- esac; \
- rev=''; for subdir in $$list; do \
- if test "$$subdir" = "."; then :; else \
- rev="$$subdir $$rev"; \
- fi; \
- done; \
- rev="$$rev ."; \
- target=`echo $@ | sed s/-recursive//`; \
- for subdir in $$rev; do \
- echo "Making $$target in $$subdir"; \
- if test "$$subdir" = "."; then \
- local_target="$$target-am"; \
- else \
- local_target="$$target"; \
- fi; \
- (cd $$subdir && $(MAKE) $(AM_MAKEFLAGS) $$local_target) \
- || eval $$failcom; \
- done && test -z "$$fail"
-tags-recursive:
- list='$(SUBDIRS)'; for subdir in $$list; do \
- test "$$subdir" = . || (cd $$subdir && $(MAKE) $(AM_MAKEFLAGS) tags); \
- done
-ctags-recursive:
- list='$(SUBDIRS)'; for subdir in $$list; do \
- test "$$subdir" = . || (cd $$subdir && $(MAKE) $(AM_MAKEFLAGS) ctags); \
- done
-
-ID: $(HEADERS) $(SOURCES) $(LISP) $(TAGS_FILES)
- list='$(SOURCES) $(HEADERS) $(LISP) $(TAGS_FILES)'; \
- unique=`for i in $$list; do \
- if test -f "$$i"; then echo $$i; else echo $(srcdir)/$$i; fi; \
- done | \
- $(AWK) ' { files[$$0] = 1; } \
- END { for (i in files) print i; }'`; \
- mkid -fID $$unique
-tags: TAGS
-
-TAGS: tags-recursive $(HEADERS) $(SOURCES) $(TAGS_DEPENDENCIES) \
- $(TAGS_FILES) $(LISP)
- tags=; \
- here=`pwd`; \
- if ($(ETAGS) --etags-include --version) >/dev/null 2>&1; then \
- include_option=--etags-include; \
- empty_fix=.; \
- else \
- include_option=--include; \
- empty_fix=; \
- fi; \
- list='$(SUBDIRS)'; for subdir in $$list; do \
- if test "$$subdir" = .; then :; else \
- test ! -f $$subdir/TAGS || \
- tags="$$tags $$include_option=$$here/$$subdir/TAGS"; \
- fi; \
- done; \
- list='$(SOURCES) $(HEADERS) $(LISP) $(TAGS_FILES)'; \
- unique=`for i in $$list; do \
- if test -f "$$i"; then echo $$i; else echo $(srcdir)/$$i; fi; \
- done | \
- $(AWK) ' { files[$$0] = 1; } \
- END { for (i in files) print i; }'`; \
- if test -z "$(ETAGS_ARGS)$$tags$$unique"; then :; else \
- test -n "$$unique" || unique=$$empty_fix; \
- $(ETAGS) $(ETAGSFLAGS) $(AM_ETAGSFLAGS) $(ETAGS_ARGS) \
- $$tags $$unique; \
- fi
-ctags: CTAGS
-CTAGS: ctags-recursive $(HEADERS) $(SOURCES) $(TAGS_DEPENDENCIES) \
- $(TAGS_FILES) $(LISP)
- tags=; \
- here=`pwd`; \
- list='$(SOURCES) $(HEADERS) $(LISP) $(TAGS_FILES)'; \
- unique=`for i in $$list; do \
- if test -f "$$i"; then echo $$i; else echo $(srcdir)/$$i; fi; \
- done | \
- $(AWK) ' { files[$$0] = 1; } \
- END { for (i in files) print i; }'`; \
- test -z "$(CTAGS_ARGS)$$tags$$unique" \
- || $(CTAGS) $(CTAGSFLAGS) $(AM_CTAGSFLAGS) $(CTAGS_ARGS) \
- $$tags $$unique
-
-GTAGS:
- here=`$(am__cd) $(top_builddir) && pwd` \
- && cd $(top_srcdir) \
- && gtags -i $(GTAGS_ARGS) $$here
-
-distclean-tags:
- -rm -f TAGS ID GTAGS GRTAGS GSYMS GPATH tags
-
-distdir: $(DISTFILES)
- @srcdirstrip=`echo "$(srcdir)" | sed 's|.|.|g'`; \
- topsrcdirstrip=`echo "$(top_srcdir)" | sed 's|.|.|g'`; \
- list='$(DISTFILES)'; for file in $$list; do \
- case $$file in \
- $(srcdir)/*) file=`echo "$$file" | sed "s|^$$srcdirstrip/||"`;; \
- $(top_srcdir)/*) file=`echo "$$file" | sed "s|^$$topsrcdirstrip/|$(top_builddir)/|"`;; \
- esac; \
- if test -f $$file || test -d $$file; then d=.; else d=$(srcdir); fi; \
- dir=`echo "$$file" | sed -e 's,/[^/]*$$,,'`; \
- if test "$$dir" != "$$file" && test "$$dir" != "."; then \
- dir="/$$dir"; \
- $(mkdir_p) "$(distdir)$$dir"; \
- else \
- dir=''; \
- fi; \
- if test -d $$d/$$file; then \
- if test -d $(srcdir)/$$file && test $$d != $(srcdir); then \
- cp -pR $(srcdir)/$$file $(distdir)$$dir || exit 1; \
- fi; \
- cp -pR $$d/$$file $(distdir)$$dir || exit 1; \
- else \
- test -f $(distdir)/$$file \
- || cp -p $$d/$$file $(distdir)/$$file \
- || exit 1; \
- fi; \
- done
- list='$(DIST_SUBDIRS)'; for subdir in $$list; do \
- if test "$$subdir" = .; then :; else \
- test -d "$(distdir)/$$subdir" \
- || $(mkdir_p) "$(distdir)/$$subdir" \
- || exit 1; \
- distdir=`$(am__cd) $(distdir) && pwd`; \
- top_distdir=`$(am__cd) $(top_distdir) && pwd`; \
- (cd $$subdir && \
- $(MAKE) $(AM_MAKEFLAGS) \
- top_distdir="$$top_distdir" \
- distdir="$$distdir/$$subdir" \
- distdir) \
- || exit 1; \
- fi; \
- done
-check-am: all-am
-check: check-recursive
-all-am: Makefile $(DATA)
-installdirs: installdirs-recursive
-installdirs-am:
- for dir in "$(DESTDIR)$(pkgdatadir)"; do \
- test -z "$$dir" || $(mkdir_p) "$$dir"; \
- done
-install: install-recursive
-install-exec: install-exec-recursive
-install-data: install-data-recursive
-uninstall: uninstall-recursive
-
-install-am: all-am
- @$(MAKE) $(AM_MAKEFLAGS) install-exec-am install-data-am
-
-installcheck: installcheck-recursive
-install-strip:
- $(MAKE) $(AM_MAKEFLAGS) INSTALL_PROGRAM="$(INSTALL_STRIP_PROGRAM)" \
- install_sh_PROGRAM="$(INSTALL_STRIP_PROGRAM)" INSTALL_STRIP_FLAG=-s \
- `test -z '$(STRIP)' || \
- echo "INSTALL_PROGRAM_ENV=STRIPPROG='$(STRIP)'"` install
-mostlyclean-generic:
-
-clean-generic:
-
-distclean-generic:
- -test -z "$(CONFIG_CLEAN_FILES)" || rm -f $(CONFIG_CLEAN_FILES)
-
-maintainer-clean-generic:
- @echo "This command is intended for maintainers to use"
- @echo "it deletes files that may require special tools to rebuild."
-clean: clean-recursive
-
-clean-am: clean-generic clean-libtool mostlyclean-am
-
-distclean: distclean-recursive
- -rm -f Makefile
-distclean-am: clean-am distclean-generic distclean-libtool \
- distclean-tags
-
-dvi: dvi-recursive
-
-dvi-am:
-
-html: html-recursive
-
-info: info-recursive
-
-info-am:
-
-install-data-am: install-pkgdataDATA
-
-install-exec-am:
-
-install-info: install-info-recursive
-
-install-man:
-
-installcheck-am:
-
-maintainer-clean: maintainer-clean-recursive
- -rm -f Makefile
-maintainer-clean-am: distclean-am maintainer-clean-generic
-
-mostlyclean: mostlyclean-recursive
-
-mostlyclean-am: mostlyclean-generic mostlyclean-libtool
-
-pdf: pdf-recursive
-
-pdf-am:
-
-ps: ps-recursive
-
-ps-am:
-
-uninstall-am: uninstall-info-am uninstall-pkgdataDATA
-
-uninstall-info: uninstall-info-recursive
-
-.PHONY: $(RECURSIVE_TARGETS) CTAGS GTAGS all all-am check check-am \
- clean clean-generic clean-libtool clean-recursive ctags \
- ctags-recursive distclean distclean-generic distclean-libtool \
- distclean-recursive distclean-tags distdir dvi dvi-am html \
- html-am info info-am install install-am install-data \
- install-data-am install-exec install-exec-am install-info \
- install-info-am install-man install-pkgdataDATA install-strip \
- installcheck installcheck-am installdirs installdirs-am \
- maintainer-clean maintainer-clean-generic \
- maintainer-clean-recursive mostlyclean mostlyclean-generic \
- mostlyclean-libtool mostlyclean-recursive pdf pdf-am ps ps-am \
- tags tags-recursive uninstall uninstall-am uninstall-info-am \
- uninstall-pkgdataDATA
-
-# Tell versions [3.59,3.63) of GNU make to not export all variables.
-# Otherwise a system limit (for SysV at least) may be exceeded.
-.NOEXPORT:
diff --git a/src/bindings/scripts/sql/create_database.sql b/src/bindings/scripts/sql/create_database.sql
deleted file mode 100644
index 2673b90555a..00000000000
--- a/src/bindings/scripts/sql/create_database.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-CREATE DATABASE `trinityscript` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-
-GRANT ALL PRIVILEGES ON `trinityscript` . * TO 'trinity'@'localhost' WITH GRANT OPTION;