aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorQAston <none@none>2010-01-10 01:24:20 +0100
committerQAston <none@none>2010-01-10 01:24:20 +0100
commit8417a4fee32d0bedce1d33156c2337326b9b82ea (patch)
tree403ed16aa9f33e10e25ea6656d6f5a8fbfa0956e /sql/updates
parent8e9d2cdf01929f513e37eccbfdea952aa04e78f6 (diff)
parent10df64be8892c3089d50c313fc37b56876ce1327 (diff)
*Merge
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/6771_world_scriptnames.sql25
1 files changed, 13 insertions, 12 deletions
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);