From 862502aacd36918ba9c9d5524e625c02a3830897 Mon Sep 17 00:00:00 2001 From: Andreas Fischer Date: Tue, 7 Aug 2012 00:31:18 +0200 Subject: [feature/attach-dl] Use table aliases in all three cases. PHPBB3-11042 --- phpBB/download/file.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'phpBB/download/file.php') diff --git a/phpBB/download/file.php b/phpBB/download/file.php index f540869a1e..bd96ad02f7 100644 --- a/phpBB/download/file.php +++ b/phpBB/download/file.php @@ -164,18 +164,18 @@ $attachments = ($topic_id || $post_id) ? array() : false; // $download_id, $post_id, $topic_id if ($download_id) { - $sql = 'SELECT attach_id, in_message, post_msg_id, extension, is_orphan, poster_id, filetime - FROM ' . ATTACHMENTS_TABLE . " - WHERE attach_id = $download_id"; + $sql = 'SELECT a.attach_id, a.in_message, a.post_msg_id, a.extension, a.is_orphan, a.poster_id, a.filetime + FROM ' . ATTACHMENTS_TABLE . " a + WHERE a.attach_id = $download_id"; $result = $db->sql_query($sql); $attachment = $db->sql_fetchrow($result); $db->sql_freeresult($result); } else if ($post_id) { - $sql = 'SELECT attach_id, in_message, post_msg_id, extension, is_orphan, poster_id, filetime - FROM ' . ATTACHMENTS_TABLE . " - WHERE post_msg_id = $post_id"; + $sql = 'SELECT a.attach_id, a.in_message, a.post_msg_id, a.extension, a.is_orphan, a.poster_id, a.filetime + FROM ' . ATTACHMENTS_TABLE . " a + WHERE a.post_msg_id = $post_id"; $result = $db->sql_query($sql); $attachments = $db->sql_fetchrowset($result); -- cgit v1.2.1