From bef55b91eca91034c3f7c7828fe47d4fddecb110 Mon Sep 17 00:00:00 2001 From: click Date: Mon, 30 May 2011 20:41:01 +0200 Subject: Scripts/World: Emerald Dragon AI - summon dreamfog properly. Thanks to Kaelima, Shauren and others for assisting in finding this idiotic bug. --- sql/updates/world/2011_05_30_04_world_creature_template.sql | 1 + sql/updates/world/2011_05_30_04_world_creature_template_addon.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 sql/updates/world/2011_05_30_04_world_creature_template.sql create mode 100644 sql/updates/world/2011_05_30_04_world_creature_template_addon.sql (limited to 'sql') diff --git a/sql/updates/world/2011_05_30_04_world_creature_template.sql b/sql/updates/world/2011_05_30_04_world_creature_template.sql new file mode 100644 index 00000000000..140a7f2d7be --- /dev/null +++ b/sql/updates/world/2011_05_30_04_world_creature_template.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|0x02000000|0x00000002,`dynamicflags`=0,`faction_A`=50,`faction_H`=50 WHERE `entry`=15224; diff --git a/sql/updates/world/2011_05_30_04_world_creature_template_addon.sql b/sql/updates/world/2011_05_30_04_world_creature_template_addon.sql new file mode 100644 index 00000000000..1caf62bae15 --- /dev/null +++ b/sql/updates/world/2011_05_30_04_world_creature_template_addon.sql @@ -0,0 +1 @@ +INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES (15224, '24777'); -- cgit v1.2.3