diff -r 6ddaa9bd7977 -r d6361ccbd2bd includes/pageprocess.php --- a/includes/pageprocess.php Fri Jul 06 10:59:46 2007 -0400 +++ b/includes/pageprocess.php Fri Jul 06 11:04:38 2007 -0400 @@ -525,7 +525,7 @@ LEFT JOIN '.table_prefix.'users_extra AS x ON ( u.user_id = x.user_id OR x.user_id IS NULL ) LEFT JOIN '.table_prefix.'comments AS c - ON ( ( c.user_id=authoritative_uid AND c.approved=1 ) OR ( c.comment_id IS NULL AND c.approved IS NULL ) ) + ON ( ( c.user_id=u.user_id AND c.name=u.username AND c.approved=1 ) OR ( c.comment_id IS NULL AND c.approved IS NULL ) ) WHERE u.username=\'' . $db->escape($target_username) . '\' GROUP BY u.user_id;'); if ( !$q ) @@ -583,7 +583,7 @@ // Comments echo '' . htmlspecialchars($target_username) . '\'s latest comments'; - $q = $db->sql_query('SELECT page_id, namespace, subject, time FROM '.table_prefix.'comments WHERE name=\'' . $db->escape($target_username) . '\' AND approved=1 ORDER BY time DESC LIMIT 5;'); + $q = $db->sql_query('SELECT page_id, namespace, subject, time FROM '.table_prefix.'comments WHERE name=\'' . $db->escape($target_username) . '\' AND user_id=' . $userdata['authoritative_uid'] . ' AND approved=1 ORDER BY time DESC LIMIT 5;'); if ( !$q ) $db->_die();