diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2012-06-23 10:45:36 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2012-06-23 10:45:36 +0200 |
| commit | fce385e5bc1212d9c3233b7a1ae2212eb1626e9b (patch) | |
| tree | 14f31f36c467bb44c78e5bdc40e1af76afaf0a33 /phpBB/includes | |
| parent | 9c2930178f37ed881055da3e65286704a3a8220e (diff) | |
| download | forums-fce385e5bc1212d9c3233b7a1ae2212eb1626e9b.tar forums-fce385e5bc1212d9c3233b7a1ae2212eb1626e9b.tar.gz forums-fce385e5bc1212d9c3233b7a1ae2212eb1626e9b.tar.bz2 forums-fce385e5bc1212d9c3233b7a1ae2212eb1626e9b.tar.xz forums-fce385e5bc1212d9c3233b7a1ae2212eb1626e9b.zip | |
[ticket/10950] Select the correct columns in SQL queries.
PHPBB3-10950
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/functions_privmsgs.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/includes/functions_privmsgs.php b/phpBB/includes/functions_privmsgs.php index d77d46d46d..1800242b71 100644 --- a/phpBB/includes/functions_privmsgs.php +++ b/phpBB/includes/functions_privmsgs.php @@ -1106,7 +1106,7 @@ function phpbb_delete_user_pms($user_id) $undelivered_msg = $undelivered_user = $delete_ids = array(); // Part 1: get PMs the user received - $sql = 'SELECT msg_id, author_id, folder_id, pm_unread, pm_new + $sql = 'SELECT msg_id, user_id, author_id, folder_id FROM ' . PRIVMSGS_TO_TABLE . ' WHERE user_id = ' . $user_id; $result = $db->sql_query($sql); @@ -1134,7 +1134,7 @@ function phpbb_delete_user_pms($user_id) $db->sql_freeresult($result); // Part 2: get PMs the user sent - $sql = 'SELECT msg_id, author_id, folder_id, pm_unread, pm_new + $sql = 'SELECT msg_id, user_id FROM ' . PRIVMSGS_TO_TABLE . ' WHERE author_id = ' . $user_id . ' AND folder_id = ' . PRIVMSGS_NO_BOX; |