aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_12_25_00_world_misc.sql8
1 files changed, 6 insertions, 2 deletions
diff --git a/sql/updates/world/2011_12_25_00_world_misc.sql b/sql/updates/world/2011_12_25_00_world_misc.sql
index 4096bbf35c7..22effda3d04 100644
--- a/sql/updates/world/2011_12_25_00_world_misc.sql
+++ b/sql/updates/world/2011_12_25_00_world_misc.sql
@@ -1,5 +1,9 @@
UPDATE `gameobject_template` SET `ScriptName`='go_captain_tyralius_prison' WHERE `entry`=184588;
-UPDATE `quest_template` SET `ReqSpellCast1`=0 WHERE `entry`=10422;
+UPDATE `quest_template` SET `RequiredSpellCast1`=0 WHERE `id`=10422;
DELETE FROM `creature_text` WHERE `entry`=20787;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
-(20787,0,0,"You've saved me, fleshling! Ameer will hear of this noble act.",12,0,100,0,0,0,"Captain Tyralius"); \ No newline at end of file
+(20787,0,0,"You've saved me, fleshling! Ameer will hear of this noble act.",12,0,100,0,0,0,"Captain Tyralius");
+
+-- Heroes of Old
+UPDATE `quest_template` SET `StartScript`=0,`CompleteScript`=0 WHERE `entry`=2702;
+DELETE FROM `quest_start_scripts` WHERE `id`=2702;