aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-03-24 00:58:37 +0100
committerShauren <shauren.trinity@gmail.com>2014-03-24 00:58:37 +0100
commitcd20be2cc90ae9b4da1b2af1af4f1a226a6c2e25 (patch)
tree1927378b1d663ec5a8cfac5bca26520806fd0c54 /sql/updates
parentc3d2236d14f77f105e33bf541c3c79c3a9bbeff4 (diff)
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
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2014_03_24_00_world_misc.sql4
1 files changed, 4 insertions, 0 deletions
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;