| iblis |
05-16-2006 02:50 AM |
I got just about every error everyone here has described, but after i sat down and analyzed the code i found a few errors which i corrected.
The problem seems to be that deleted posts have not been substracted - just deleted threads!
Try this on for size, it works fine on my board
PHP Code:
// HACK : START : USER ACTIVENESS
$show[useractiveness] = 0 ;
if ($userinfo[posts]) {
$forumids = implode("', '", get_noaccess_forumids());
$tfarray = $DB_site->query_first(
"SELECT COUNT(*) AS aposts," . TABLE_PREFIX . "forum.title AS aftitle, " . TABLE_PREFIX . "thread.forumid AS aforumid
FROM " . TABLE_PREFIX . "thread
LEFT JOIN " . TABLE_PREFIX . "post ON " . TABLE_PREFIX . "post.threadid = " . TABLE_PREFIX . "thread.threadid
LEFT JOIN " . TABLE_PREFIX . "forum ON " . TABLE_PREFIX . "forum.forumid = " . TABLE_PREFIX . "thread.forumid
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS delpost ON(delpost.primaryid = post.postid AND delpost.type = 'post')
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
WHERE " . TABLE_PREFIX . "forum.forumid NOT IN ( '$forumids' )
AND " . TABLE_PREFIX . "thread.visible=1
AND delpost.primaryid IS NULL
AND delthread.primaryid IS NULL
AND " . TABLE_PREFIX . "post.userid = $userinfo[userid]
GROUP BY " . TABLE_PREFIX . "forum.forumid ORDER BY 1 DESC LIMIT 1");
$_activeposts = $tfarray['aposts'];
$_activeurl = "<a href=\"forumdisplay.php?$session[sessionurl]f=".$tfarray['aforumid']."\">".$tfarray['aftitle']."</a>";
$_activeperc = round(((implode('',explode('.',$_activeposts)) / implode('',explode('.',$userinfo['posts'])) ) * 100), 2)."%" ;
$show[useractiveness] = 1 ;
}
// HACK : END : USER ACTIVENESS
Also, for those of you who experience that the hack installs but only show a blank box in the memberinfo: Go to the admincp and edit (and save) the phrase you created on install. That should fix the problem. |
More Information