From e39e6da4fbdb880733fafdd3d41c4903379bfe1a Mon Sep 17 00:00:00 2001 From: Unknown Date: Sun, 11 Sep 2011 19:08:49 +0100 Subject: DB/NPC: Aura and template update for 28239 (in Oculus). Closes #454 --- sql/updates/world/2011_09_11_02_world_creature_template.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2011_09_11_02_world_creature_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_09_11_02_world_creature_template.sql b/sql/updates/world/2011_09_11_02_world_creature_template.sql new file mode 100644 index 00000000000..1784e983832 --- /dev/null +++ b/sql/updates/world/2011_09_11_02_world_creature_template.sql @@ -0,0 +1,4 @@ +UPDATE `creature_template` SET `exp`=0,`speed_run`=0.78571 WHERE `entry`=28239; -- Arcane Beam +DELETE FROM `creature_template_addon` WHERE `entry`=28239; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(28239,0,0,1,0, '51019'); -- Arcane Beam -- cgit v1.2.3