[Xenon]

indeed that could be the problem, but we'll find a way

PHP Code:

<?php

require('./global.php');

$r1=$DB_site->query("SELECT user.userid, user.username, user.joindate, user.posts, user.lastactivity, 

post.dateline, 

post.threadid,
usergroup.title, thread.title as ptitle
FROM user,post,usergroup,thread
WHERE user.lastpost=post.dateline AND user.usergroupid=usergroup.usergroupid AND 

post.threadid=thread.threadid
ORDER BY usergroup.title,user.username");

$threadstarters=$DB_site->query("SELECT COUNT(*) AS count, postuserid FROM thread GROUP BY postuserid");
while($threadstarter=$DB_site->fetch_array($threadstarters)) {
 $threadcount[$threadstarter['postuserid']] = $threadstarter['count'];
}

    while($bob=$DB_site->fetch_array($r1))
{


    $threads=$threadcount[$bob['userid']];
    $ld=$bob[dateline];
    $ld2=date("d/m/y (G:i)",$ld);
    $lv=$bob[lastactivity];
    $lv2=date("d/m/y (G:i)",$lv);
    $jd=$bob[joindate];
    $jd2=date("d/m/y (G:i)",$jd);

    eval("\$memberdeets .= \"".gettemplate("memberdeets")."\";");    



}

eval("dooutput(\"".gettemplate("memberdeetspage")."\");");

?>

a restriction to 30 users per page isn't needed, but wouldn't hurt