I have the following information in my pp-inc.php file. However, the numbers *never* change. The same people are always listed, and it just seems to stay static.
Quote:
// Lets get the Top Posters
$queryz = ppmysql_query("SELECT user,userid,COUNT(*) AS pcount FROM {$Globals['pp_db_prefix']}photos WHERE date < UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 1 MONTH) ) GROUP BY user ORDER BY pcount DESC LIMIT {$Globals['numtoppal']}", $link);
$numfound = 1;
while ( list($cache['top']['topposters'][$numfound], $uid, $cache['top']['topposts'][$numfound]) = mysql_fetch_row($queryz))
{
if ( $Globals['spider'] == "yes" )
{
$cache['top']['toplink'][$numfound] = "{$Globals['maindir']}/showgallery.php/ppuser/$uid/cat/500";
}
else
{
$cache['top']['toplink'][$numfound] = "{$Globals['maindir']}/showgallery.php?ppuser=$uid&cat=500";
}
$numfound++;
}
return;
}
|