From 8ef1bda36b72cb9d21ecef7d9b5554c0e7666e7d Mon Sep 17 00:00:00 2001 From: Nay Date: Thu, 7 Mar 2013 01:48:34 +0000 Subject: SQL: Update 2013_02_18_00_world_misc_equip.sql MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Fix "column `id` in field list is ambiguous" Thanks Guybrush *Should* not have caused any issues but warnings are bad. --- sql/updates/world/2013_02_18_00_world_misc_equip.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/2013_02_18_00_world_misc_equip.sql b/sql/updates/world/2013_02_18_00_world_misc_equip.sql index a5964cd883b..d591481fc76 100644 --- a/sql/updates/world/2013_02_18_00_world_misc_equip.sql +++ b/sql/updates/world/2013_02_18_00_world_misc_equip.sql @@ -37,7 +37,7 @@ INSERT INTO `creature_equip_template2` (`entry`, `id`, `itemEntry1`, `itemEntry2 WHERE `equipment_id` != 0; INSERT IGNORE INTO `creature_equip_template2` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) - SELECT `id`, 2, `itemEntry1`, `itemEntry2`, `itemEntry3` + SELECT `creature`.`id`, 2, `itemEntry1`, `itemEntry2`, `itemEntry3` FROM `creature` JOIN `creature_equip_template` ON `creature_equip_template`.`entry` = `equipment_id` WHERE `equipment_id` != 0; -- cgit v1.2.3