aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorclick <clickvd@gonnamakeyou.com>2011-06-19 16:17:41 +0200
committerclick <clickvd@gonnamakeyou.com>2011-06-19 16:17:41 +0200
commit11865b81348bc36bbde0cc4c804aabd59669e01f (patch)
tree09de5748a67f60f02510bad2f60e4edbd8be78fa
parent85b714e5776c0c987843850e8d1dddc3315df389 (diff)
DB: Make the pink elekks around the world only visible when drunk... *HIC!*
-rw-r--r--sql/updates/world/2011_06_19_03_world_creature_template_addon.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_19_03_world_creature_template_addon.sql b/sql/updates/world/2011_06_19_03_world_creature_template_addon.sql
new file mode 100644
index 00000000000..2e6291cf7ee
--- /dev/null
+++ b/sql/updates/world/2011_06_19_03_world_creature_template_addon.sql
@@ -0,0 +1,9 @@
+DELETE FROM `creature_template_addon` WHERE `entry` IN (21250,23507,23527,23528,23529,23530,23531,27958);
+INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES
+(21250,36440), -- Pink Elekk, Terokkar Forest
+(23507,36440), -- Elwynn Pink Elekk
+(23527,36440), -- Teldrassil Pink Elekk
+(23528,36440), -- Azuremyst Pink Elekk
+(23529,36440), -- Mulgore Pink Elekk
+(23530,36440), -- Tirisfal Pink Elekk
+(23531,36440); -- Eversong Pink Elekk