need user details from thread table

[khaleejy]

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??

[curley]

PHP Code:

$threadcount=$topt['threads'];
    $topusername=$topt['username'];
    $userid=$topt['postuserid']; 


i couldnt swear to it but i would say do this instead

PHP Code:

$threadcount=$topt[threads];
    $topusername=$topt[username];
    $userid=$topt[postuserid]; 


[khaleejy]

theres nothing wronge with it.. its working fine

[Xenon]

change this:

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"); 


into

PHP Code:

$topts=$DB_site->query("SELECT COUNT(threadid) AS threads, user.username, user.lastvistit, user.lastactivity, user.joindate, postuserid FROM thread LEFT JOIN user ON(user.userid=thread.postuserid) GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 10"); 


then you can use $topt[joindate] and so on

[khaleejy]

thanks alot