From cd20be2cc90ae9b4da1b2af1af4f1a226a6c2e25 Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 24 Mar 2014 00:58:37 +0100 Subject: Scripts/Icecrown Citadel * Deathbringer Saurfang will now evade if any player stands on the gunship * Fixed players being stuck in combat after defeating gunship * Fixed players not sticking to gunships --- sql/updates/world/2014_03_24_00_world_misc.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2014_03_24_00_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_03_24_00_world_misc.sql b/sql/updates/world/2014_03_24_00_world_misc.sql new file mode 100644 index 00000000000..a69810f0e99 --- /dev/null +++ b/sql/updates/world/2014_03_24_00_world_misc.sql @@ -0,0 +1,4 @@ +UPDATE `creature_template` SET `faction_A`=83,`faction_H`=83 WHERE `entry`=37833; -- Sky-Reaver Korm Blackscar +UPDATE `gameobject_template` SET `flags`=40 WHERE `entry` IN (201812,201811,201581,201580); +UPDATE `achievement_criteria_data` SET `value1`=1 WHERE `criteria_id`=12947 AND `type`=12;-- Storming the Citadel (25 player) +DELETE FROM `gameobject` WHERE `id`=201880; -- cgit v1.2.3