It worked, thanks. Just to verify, this is what the code should look like for me now, right?
PHP Code:
// +++++++ User Most Active Forum Hack [ g-force2k2 ] +++++++
// thanks to neo for the query fix :)
$t_post = $DB_site->query_first("
SELECT COUNT(postid) AS ppforum, thread.forumid AS forumid
FROM post
LEFT JOIN thread ON thread.threadid = post.threadid
WHERE userid = '$userinfo[userid]'
GROUP BY(forumid)
ORDER BY ppforum
DESC LIMIT 1");
if(empty($t_post[ppforum])) {
$forumactive = "";
} else {
$f_name = $DB_site->query_first("
SELECT title
FROM forum
WHERE forumid = '$t_post[forumid]'");
$f_posts = round(($t_post[ppforum] / $userinfo[posts]) * 100,2);
$p_type = iif($t_post[ppforum] == 1,'Post','Posts');
if($bbuserinfo[usergroupid] == 5 OR $bbuserinfo[usergroupid] == 6 OR $bbuserinfo[usergroupid] == 7) {
eval("\$forumactive = \"".gettemplate('getinfo_forumactive')."\";");
} else {
$forumactive = "";
}
}
// +++++++ User Most Active Forum Hack [ g-force2k2 ] +++++++
And what did you think of the change for the percentage?