diff options
| author | Nay <dnpd.dd@gmail.com> | 2013-03-07 01:48:34 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2013-03-07 01:48:34 +0000 |
| commit | 8ef1bda36b72cb9d21ecef7d9b5554c0e7666e7d (patch) | |
| tree | bde13f5704f176199dec5016b64751ada16c65bf | |
| parent | f32fa5464c751282932d935b03d8aa4d538299ad (diff) | |
SQL: Update 2013_02_18_00_world_misc_equip.sql
Fix "column `id` in field list is ambiguous"
Thanks Guybrush
*Should* not have caused any issues but warnings are bad.
| -rw-r--r-- | sql/updates/world/2013_02_18_00_world_misc_equip.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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; |