[iblis]

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.