ahh i see
then use instead of this code:
PHP Code:
$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");
this:
PHP Code:
$r1=$DB_site->query("SELECT user.userid, user.username, user.joindate, user.posts, user.lastvisit,
post.postid, post.threadid, thread.title as ptitle,
usergroup.title, thread.title as ptitle
FROM user
LEFT JOIN usergroup USING (usergroupid)
LEFT JOIN post ON (post.userid=user.userid AND dateline>=user.lastpost-30)
LEFT JOIN thread ON (thread.threadid=post.threadid)
ORDER BY usergroup.title,user.username");
the referrals would mean extra queries again... (same procedure as threads counter

)