coppermine-gallery.com/forum

hey , i have created a top 50 users page. but i have members in there that i have changed there user group but in the top 50 its still saying registerd can any one help

http://www.y-idols.com/justttt/gall/top50.php (http://www.y-idols.com/justttt/gall/top50.php)

<?
define('IN_COPPERMINE', true);
require('include/init.inc.php');
pageheader('Top 50 !');

// (at your option) any later version.                                       //
// ------------------------------------------------------------------------- //
// CVS version: $Id: anycontent.php,v 1.5 2004/07/24 15:03:52 gaugau Exp $
// ------------------------------------------------------------------------- //

echo '<table width="100%"><tr><td width="50%">';
starttable("100%", "Top posters",2);

$result = cpg_db_query("SELECT user_name, user_id, group_name, COUNT(*) AS numcom FROM {$CONFIG['TABLE_COMMENTS']}, {$CONFIG['TABLE_USERS']}, {$CONFIG['TABLE_USERGROUPS']} WHERE user_id = author_id AND user_group = group_id GROUP BY author_id ORDER BY numcom DESC LIMIT 20");

$i = 1;
while ($row = mysql_fetch_assoc($result)){
echo "<tr><td class=\"tableb\" >" . $i++ . ") <a href=\"profile.php?uid={$row['user_id']}\">{$row['user_name']}</a> - {$row['group_name']}</td><td class=\"tableb\"><a href=\"thumbnails.php?album=lastcomby&uid={$row['user_id']}\">{$row['numcom']} comments</a></td></tr>";
}

endtable();
echo '</td><td width="50%">';

starttable("100%", "Top uploaders",2);

$result = cpg_db_query("SELECT user_name, user_id, group_name, COUNT(*) AS numpics FROM {$CONFIG['TABLE_PICTURES']}, {$CONFIG['TABLE_USERS']}, {$CONFIG['TABLE_USERGROUPS']} WHERE user_id = owner_id AND user_group = group_id GROUP BY owner_id ORDER BY numpics DESC LIMIT 20");

$i = 1;
while ($row = mysql_fetch_assoc($result)){
echo "<tr><td class=\"tableb\" >" . $i++ . ") <a href=\"profile.php?uid={$row['user_id']}\">{$row['user_name']} - {$row['group_name']}</a></td><td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">{$row['numpics']} uploads</a></td></tr>";
}

endtable();
echo '</td></tr>';
endtable();

echo '<table width="100%"><tr><td width="50%">';
starttable("100%", "Top Users",2);

$result = cpg_db_query("SELECT user_name, user_id, group_name, SUM(hits) AS numhits FROM {$CONFIG['TABLE_USERS']}, {$CONFIG['TABLE_USERGROUPS']}, {$CONFIG['TABLE_PICTURES']} WHERE user_id = owner_id AND user_group = group_id GROUP BY owner_id ORDER BY numhits DESC LIMIT 20");

$i = 1;
while ($row = mysql_fetch_assoc($result)){
echo "<tr><td class=\"tableb\" >" . $i++ . ") <a href=\"profile.php?uid={$row['user_id']}\">{$row['user_name']}</a> - {$row['group_name']}</td><td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">{$row['numhits']} points</a></td></tr>";
}

endtable();
echo '</td><td width="50%">';
starttable("100%", "Top Users Of The Month",2);




echo "<tr>
  <td class=\"tableb\" >1) <a href=\"profile.php?uid={$row['user_id']}\">No User Selected Yet </a> - Group Non </td>
  <td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">NO points</a></td></tr>
  <tr>
  <td class=\"tableb\" >2) <a href=\"profile.php?uid={$row['user_id']}\">No User Selected Yet </a> - Group Non </td>
  <td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">NO points</a></td></tr>
  <tr>
  <td class=\"tableb\" >3) <a href=\"profile.php?uid={$row['user_id']}\">No User Selected Yet </a> - Group Non </td>
  <td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">NO points</a></td></tr>
  <tr>
  <td class=\"tableb\" >4) <a href=\"profile.php?uid={$row['user_id']}\">No User Selected Yet </a> - Group Non </td>
  <td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">NO points</a></td></tr>
  <tr>
  <td class=\"tableb\" >5) <a href=\"profile.php?uid={$row['user_id']}\">No User Selected Yet </a> - Group Non </td>
  <td class=\"tableb\"><a href=\"thumbnails.php?album=lastupby&uid={$row['user_id']}\">NO points</a></td></tr>
  ";


endtable();
echo '</td></tr>';
endtable();

pagefooter();
?>

hmmm acctuly its not working on my online stats either . its only working in the user manger  :o please helppppp  :'(
#

thanks justtttt

The code only tells you the primary group, not any additional groups.

what do you mean nibbler , and could i have some help please.


thanks , justttt