diff options
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 11 | ||||
| -rw-r--r-- | sql/updates/6771_world_scriptnames.sql | 25 |
2 files changed, 23 insertions, 13 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index cb3695125ec..b2fa876567d 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -1,4 +1,4 @@ --- Up to TC2 6873 +-- Up to TC2 6928 -- Cleanup first UPDATE `creature_template` SET `ScriptName`=''; @@ -11,6 +11,7 @@ UPDATE `creature_template` SET `ScriptName`='boss_shade_of_taerar' WHERE `entry` UPDATE `creature_template` SET `ScriptName`='boss_kruul' WHERE `entry`=18338; UPDATE `creature_template` SET `ScriptName`='boss_azuregos' WHERE `entry`=6109; UPDATE `creature_template` SET `ScriptName`='mob_dementeddruids' WHERE `entry`=15260; +UPDATE `creature_template` SET `ScriptName`='boss_mr_smite' WHERE `entry`=646; /* GO */ UPDATE `gameobject_template` SET `ScriptName`='go_cat_figurine' WHERE `entry`=13873; @@ -1206,6 +1207,14 @@ UPDATE `gameobject_template` SET `ScriptName`='go_panther_cage' WHERE `entry`=17 UPDATE `creature_template` SET `ScriptName`='npc_cairne_bloodhoof' WHERE `entry`=3057; /* TRIAL OF THE CHAMPION */ +UPDATE `instance_template` SET `script`='instance_trial_of_the_champion' WHERE `map`=650; +UPDATE `creature_template` SET `Scriptname`='npc_toc5_announcer',`npcflag`=1 WHERE entry IN (35004, 35005); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_warrior' WHERE entry IN (34705, 35572); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_mage' WHERE entry IN (34702, 35569); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_shaman' WHERE entry IN (34701, 35571); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_hunter' WHERE entry IN (34657, 35570); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_rogue' WHERE entry IN (34703, 35617); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_risen_ghoul' WHERE entry IN (35545, 35564); UPDATE `creature_template` SET `ScriptName`='npc_risen_ghoul' WHERE `entry` IN (35545,35564); UPDATE `creature_template` SET `ScriptName`='boss_black_knight' WHERE `entry`=35451; UPDATE `creature_template` SET `ScriptName`='boss_eadric' WHERE `entry`=35119; diff --git a/sql/updates/6771_world_scriptnames.sql b/sql/updates/6771_world_scriptnames.sql index e11fc598052..5f617ed3738 100644 --- a/sql/updates/6771_world_scriptnames.sql +++ b/sql/updates/6771_world_scriptnames.sql @@ -1,13 +1,14 @@ -- Trial of the Champion -UPDATE instance_template SET script='instance_trial_of_the_champion' WHERE map=650; -UPDATE creature_template SET npcflag=1, scriptname='npc_toc5_announcer' WHERE entry IN (35004, 35005); -UPDATE creature_template SET scriptname='mob_toc5_warrior' WHERE entry IN (34705, 35572); -UPDATE creature_template SET scriptname='mob_toc5_mage' WHERE entry IN (34702, 35569); -UPDATE creature_template SET scriptname='mob_toc5_shaman' WHERE entry IN (34701, 35571); -UPDATE creature_template SET scriptname='mob_toc5_hunter' WHERE entry IN (34657, 35570); -UPDATE creature_template SET scriptname='mob_toc5_rogue' WHERE entry IN (34703, 35617); -UPDATE creature_template SET scriptname='boss_eadric' WHERE entry=35119; -UPDATE creature_template SET scriptname='boss_paletress' WHERE entry=34928; -UPDATE creature_template SET scriptname='mob_toc5_memory' WHERE entry IN (35052, 35041, 35033, 35046, 35043, 35047, 35044, 35039, 35034, 35049, 35030, 34942, 35050, 35042, 35045, 35037, 35031, 35038, 35029, 35048, 35032, 35028, 35040, 35036, 35051); -UPDATE creature_template SET scriptname='mob_toc5_risen_ghoul' WHERE entry IN (35545, 35564); -UPDATE creature_template SET scriptname='boss_black_knight' WHERE entry=35451;
\ No newline at end of file +UPDATE `instance_template` SET `script`='instance_trial_of_the_champion' WHERE `map`=650; +UPDATE `creature_template` SET `Scriptname`='npc_toc5_announcer',`npcflag`=1 WHERE entry IN (35004, 35005); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_warrior' WHERE entry IN (34705, 35572); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_mage' WHERE entry IN (34702, 35569); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_shaman' WHERE entry IN (34701, 35571); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_hunter' WHERE entry IN (34657, 35570); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_rogue' WHERE entry IN (34703, 35617); +UPDATE `creature_template` SET `ScriptName`='mob_toc5_risen_ghoul' WHERE entry IN (35545, 35564); +UPDATE `creature_template` SET `ScriptName`='npc_risen_ghoul' WHERE `entry` IN (35545,35564); +UPDATE `creature_template` SET `ScriptName`='boss_black_knight' WHERE `entry`=35451; +UPDATE `creature_template` SET `ScriptName`='boss_eadric' WHERE `entry`=35119; +UPDATE `creature_template` SET `ScriptName`='boss_paletress' WHERE `entry`=34928; +UPDATE `creature_template` SET `ScriptName`='npc_memory' WHERE `entry` IN (35052,35041,35033,35046,35043,35047,35044,35039, 35034, 35049, 35030, 34942, 35050, 35042, 35045, 35037, 35031, 35038, 35029,35048,35032,35028,35040,35036,35051); |