From 0e4cebf9c6da88f8f00e97133168d47e2415ce00 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Sat, 29 Jun 2013 18:51:48 +0200 Subject: DB/creature: another c_t_a to c_a convert --- sql/updates/world/2013_06_29_02_world_creature_addon.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2013_06_29_02_world_creature_addon.sql (limited to 'sql') diff --git a/sql/updates/world/2013_06_29_02_world_creature_addon.sql b/sql/updates/world/2013_06_29_02_world_creature_addon.sql new file mode 100644 index 00000000000..c8ee431909b --- /dev/null +++ b/sql/updates/world/2013_06_29_02_world_creature_addon.sql @@ -0,0 +1,4 @@ +DELETE FROM `creature_template_addon` WHERE `entry`=17976; +DELETE FROM `creature_addon` WHERE `guid`=82986; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(82986,829860,0,0,1,0,'19818'); -- Converted from c_t_a, works on both normal and heroic entry -- cgit v1.2.3