hi
PHP Code:
$topts=$DB_site->query("SELECT COUNT(threadid) AS threads, username, postuserid FROM thread LEFT JOIN user ON(user.userid=thread.postuserid) GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 10");
$toptsbits = "";
$level=0;
while($topt=$DB_site->fetch_array($topts)) {
$level++;
$threadcount=$topt['threads'];
$topusername=$topt['username'];
$userid=$topt['postuserid'];
eval("\$toptsbits .= \"".gettemplate('forumhome_topts')."\";");
}
$DB_site->free_result($topts);
eval("dooutput(\"".gettemplate("top_threadstarter")."\");");
could any one moditfy my script so that i can get the user register date, user email , user last seen date??