# HG changeset patch
# User Dan
# Date 1183734278 14400
# Node ID d6361ccbd2bd1dbab1559c189f5f2e2261cda977
# Parent  6ddaa9bd7977b8bea4c888a9c8e96f7a7de1002d
OK, that last commit only made things worse...it's fixed now.

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 '<tr><th class="subhead">' . htmlspecialchars($target_username) . '\'s latest comments</th></tr>';
-    $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();