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

[Curzon564]

I also had the % problem. It seems that this happens always if your board uses . instead of , (e.g. 1.500 posts instead of 1,500 posts).

To fix this problem do the following:

Replace the original code with this modified version of buro9's 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 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(((implode('',explode('.',$_activeposts)) / implode('',explode('.',$userinfo['posts'])) ) * 100), 2)."%" ; 
    $show[useractiveness] = 1 ; 
  } 
// HACK : END : USER ACTIVENESS

The only thing replaced in this modified version are 2 . instead of , in the $_activeperc line.

As this isn't my code, credits belong to buro9 for his work.

@buro9
I hope you don't mind me modifying your code.

[Zachariah]

@buro9 - post 78 -

Great fix. But, last post changed to never vs. were the member posted (all users)

PostsTotal Posts: 1,881 (1.43 posts per day)
Last Post:

Never

Find all posts by Zack
Find all threads started by Zack

Forum Activeness Statistics
Zack is most active in the forum General with a total of 813 posts contributing to 43.22% of their total posts.

[Zachariah]

I killed:

// reputation 
fetch_reputation_image($userinfo);

From: buro9 - post 78 -

doing this got back Last Post
:rambo:

[themovieinsider]

works great

[Impulse]

Hmm, I've installed this hack and run into a problem. The hack works perfectly fine on IE, I think... but I myself use firefox and don't see the changes made by the hack.

I've deleted my cookies and such, but still nothing...

help?

[MajorFm.com]

Hack worked perfectly, i had to do the percentage fix aswell... might be a idea to change the original zip...

Thanks...!

[MajorFm.com]

Is there a problem somewhere, i have just noticed...



According to that, i got 4.1%

But explain this...

The total posts in the forum is 6608 and the total i have posted there according to your hack is 410

6608 Divide 410 = 16.12

Shouldn't it be 16.1%

Please advise...

[MajorFm.com]

Oh my bad, i get it, doh...

The percentage is not the contribution to the forum, its the percentage of the users total posts... am i right?

[MajorFm.com]

Im confused again... the percentages just don't seem right!

PostsTotal Posts: 856 (8.29 posts per day)
Find all posts by Martina
Find all threads started by Martina
Forum Activeness StatisticsMartina is most active in the forum You what... with a total of 543 posts contributing to 0.01% of their total posts.

[MajorFm.com]

I still get a unreal percentage...

ElecTriK ShocKs is most active in the forum You what... with a total of 784 posts contributing to 78400% of their total posts.