diff options
author | KingPin <none@none> | 2008-10-27 09:57:53 -0500 |
---|---|---|
committer | KingPin <none@none> | 2008-10-27 09:57:53 -0500 |
commit | 1bb16035923b0675b0c239379cd5d64c8310f28b (patch) | |
tree | a4484c1d97545373f5e4033c3f23052b938d14d8 | |
parent | e72a13c3dd10922a18d9ee59a7f62fbfb6b69c03 (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.am | 8 | ||||
-rw-r--r-- | sql/tools/Makefile.am | 4 | ||||
-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.am | 33 | ||||
-rw-r--r-- | src/bindings/scripts/sql/Makefile.in | 542 | ||||
-rw-r--r-- | src/bindings/scripts/sql/create_database.sql | 3 |
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; |