From 78c7767cbddd9adf3d9114d3001df7cc50648511 Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Sun, 16 Dec 2012 01:04:54 +0100 Subject: DB/Creatures: Add corrects hover for Vyragosa and Chillmaw --- sql/updates/world/2012_12_16_00_world_creature_addon.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2012_12_16_00_world_creature_addon.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_16_00_world_creature_addon.sql b/sql/updates/world/2012_12_16_00_world_creature_addon.sql new file mode 100644 index 00000000000..a79bb407321 --- /dev/null +++ b/sql/updates/world/2012_12_16_00_world_creature_addon.sql @@ -0,0 +1,5 @@ +-- Vyragosa +UPDATE `creature_addon` SET `bytes1`=0x3000000 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=32630); +-- Chillmaw +UPDATE `creature_addon` SET `bytes1`=0x3000000,`bytes2`=0x1 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=33687); +DELETE FROM `creature_template_addon` WHERE `entry`=33687; -- cgit v1.2.3