View Single Post
Old January 19th, 2008, 05:35 PM   #19 (permalink)
stmpspaz
Member
 
Join Date: Jun 2003
Posts: 117
Top Poster

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&amp;cat=500";
}
$numfound++;
}

return;
}
stmpspaz is offline   Reply With Quote