vb3 User Forum Activeness Hack v1.4

Alright I decided to port this hack over from vb2 since it was one of my favorite hacks, but this time I did a bit more tweaking to improve its preformance and accuracy. Hack comes with auto-installer / un-installer / uses bitwise permissions / fully vbphrased.

What does this hack do?
In the user profile it displays the forum that that user is most active in, the number of posts they have made and the percentage of total posts.
It does require one extra query in the member.php when viewing profiles
Also uses bitwise permissions to check to see if users have access to that forum, which I used a cache for to prevent this hack from using two queries as it did in the past.

What to do?
Queries to run: 2
File Modifications: 2
Template Modifications: 1

Just simply upload the install_ufactive.php to the admincp directory and run the installer for the rest of the steps and information.

Comments, suggestions, etc. are always welcomed. Enjoy my 3rd vb3 hack as I've had just as much fun making it, and trying to make my hacks the best possiblem, from feature wise to performance.

See attachments for screenshots below, first one shows a user that doesn't have the right permissions to view the user's most active forum so it takes from the next most active forum, but the second screenshot shows with regular permissions as the user has permission to the forum.

Please respect my work and I would appreciate if you clicked install.

Note all upgrades are included in the new install_ufactive.php only needed if you installed before February 5th 2004 else the auto-installer has been updated.

Upgrade To 1.1 - Changes
--
MEMBERINFO template ( 1 )
member.php file ( 1 )

You can view information and the attachment on this [ HERE ] AND the information [ HERE ]

Upgrade To 1.2 - Changes
--
member.php file ( 1 )

You can view information adn the attachment on this [ HERE ] AND the information [ HERE ]

Upgrade To 1.3 - Changes
--
member.php file ( 1 )

You can view the information and the attachment by viewing this [ POST ].

Upgrade To 1.4 - Changes
--
install_ufactive.php ( 1 )
member.php ( 1 )
MEMBERINFO template ( 1 )

You can view the attachment [ HERE ] and the post information [ HERE ].

It is advised that you updated changes if you use the Firebird Browser or if you use TABLE_PREFIX on your forum. I will update the install file to include these changes shortly. Big thumbs up to Natch and buro9 for helping me sort out the issues

Cheers,
g-force2k2

[g-force2k2]

Originally Posted by Darkwolf

Now is like too much

Total Posts: 1,473 (2.93 posts per day)

Darkwolf is most active in the forum Talking Point with a total of 566 posts contributing to 56600% of their total posts.

I don't know why the calculation doesn't exactly work, but see the information on this [ POST ] for a possible fix. I don't know why it's creating this error, if someone could help me in any way I would appreciate it.

Regards,
g-force2k2

[buro9]

Originally Posted by g-force2k2

I don't know why the calculation doesn't exactly work, but see the information on this [ POST ] for a possible fix. I don't know why it's creating this error, if someone could help me in any way I would appreciate it.

Regards,
g-force2k2

Well, in the install you might want to update your code to include the table prefixes:

function update_phrasegroups ( $phrasegroup, $languageid=1 )
{
  global $DB_site ;

  $getid = $DB_site->query_first ( "SELECT phrasetypeid FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname='$phrasegroup'" ) ;
  $phrasetypeid = $getid['phrasetypeid'] ;

  $phrases = $DB_site->query ( "SELECT varname AS v, text AS t FROM " . TABLE_PREFIX . "phrase WHERE phrasetypeid=" . $phrasetypeid . " ORDER BY varname" ) ;
  while ( $phrase = $DB_site->fetch_array ( $phrases ) ) :
    $parray[$phrase['v']] = preg_replace( '/\{([0-9])+\}/siU', '%\\1$s', $phrase['t'] ) ;
  endwhile ;
  $DB_site->query ( "UPDATE " . TABLE_PREFIX . "language SET phrasegroup_$phrasegroup='" . addslashes ( serialize ( $parray ) ) . "' WHERE languageid=$languageid" ) ;
}

As I got an install error as I'm using table prefixes.

I also had to adjust the member.php bit to include table prefixes, and performed the same addition of an ORDER BY to set the right one at the top:

  $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 ON ( " . TABLE_PREFIX . "deletionlog.primaryid = " . TABLE_PREFIX . "thread.threadid AND type = 'thread' )
    WHERE " . TABLE_PREFIX . "forum.forumid NOT IN ( '$forumids' )
      AND " . TABLE_PREFIX . "thread.visible=1
      AND " . TABLE_PREFIX . "deletionlog.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 ( ( ( $_activeposts / $userinfo['posts'] ) * 100 ), 2 ) . "%" ;
  $show[useractiveness] = 1 ;
  endif ;

As regards the math for the percentile... it's fine
For the sum shown in the earlier post, it did correctly return 38.42%
But it looks like that user has lost a value for the $userinfo['posts'] var... because that value is a direct $_activeposts * 100 rounded sum. So either put in or remove the quotes around 'posts' to see what happens

That should see you fine.

[Darkwolf]

I update to your coding and it got this

Fatal error: Call to undefined function: get_noaccess_forumids() in /home/lifex/public_html/forums/member.php on line 367

[trinitym]

Originally Posted by Darkwolf

I update to your coding and it got this

Fatal error: Call to undefined function: get_noaccess_forumids() in /home/lifex/public_html/forums/member.php on line 367

I got the same error earlier because I pasted the wrong bit of code into the includes/functions_user.php - maybe something similar happened?

On another note, it seems my "regular" registered users can't see this in any of the profiles? Did I do something wrong somewhere, or is this a mod only view option?

[buro9]

Originally Posted by trinitym

I got the same error earlier because I pasted the wrong bit of code into the includes/functions_user.php - maybe something similar happened?

Yup... the function should exist in functions_user.php and is part of this hack... i.e. you should have run the installer file provided by g-force2k2 in the first post of this thread... followed the instructions and already made the update to functions_user.php.

It sounds daft... but make sure you've uploaded it

[Darkwolf]

I have done that but it doesn't seems to be working for me.

[mharmon]

I tried this in RC3 with no luck. Installed great -- but didn't show. Any suggestions?

[poetic]

Mine shows.. BUT I get the division of 0 error. ?

[g-force2k2]

Originally Posted by mharmon

I tried this in RC3 with no luck. Installed great -- but didn't show. Any suggestions?

Did you try to view a profile with more than zero posts?

Originally Posted by poetic

Mine shows.. BUT I get the division of 0 error. ?

poetic did you redownload the 1.2 version? because it does have the fix for the division by zero.

Regards,
g-force2k2

[poetic]

I'll 'check' the versions on this.. thanks