From 87b5f99b8118b5d3eaf9271d5a4a81e8d8016c21 Mon Sep 17 00:00:00 2001 From: Nevan Date: Mon, 5 Sep 2011 01:59:17 +0200 Subject: Twins Valk - Cleanup / Remove Hardcoded Bullet Spawn (Need DB Support - Stalkers Spawns) Acidmaw - Use Correct Submerge Spell Trial Of Crusader - Correct Coordinate Spawn Trial Of Crusader - Correct Open/Close Main Door Timer Trial Of Crusader - Open/Close On Boss EnterEvadeMode --- sql/updates/world/2011_09_05_world_misc.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2011_09_05_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2011_09_05_world_misc.sql b/sql/updates/world/2011_09_05_world_misc.sql new file mode 100644 index 00000000000..730e27fb2b2 --- /dev/null +++ b/sql/updates/world/2011_09_05_world_misc.sql @@ -0,0 +1,6 @@ +UPDATE `creature_template` SET `scriptname`='mob_bullet_controller' WHERE `entry` = 34743; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `ConditionTypeOrReference` = 18 AND `SourceEntry` IN (66152,66153); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 0, 66152, 0, 18, 1, 34720, 1, 0, '', 'Light Bullets Stalker - Light Orb Spawn'), +(13, 0, 66153, 0, 18, 1, 34704, 1, 0, '', 'Dark Bullets Stalker - Dark Orb Spawn'); -- cgit v1.2.3