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

[Sadie Frost]

Is this interacting with total posts on the profile for anyone else? If I comment out this hack's code in member.php, it works fine, otherwise I get like post counts of 5 for members with thousands.

[g-force2k2]

Originally Posted by Sadie Frost

Is this interacting with total posts on the profile for anyone else? If I comment out this hack's code in member.php, it works fine, otherwise I get like post counts of 5 for members with thousands.

Not quite sure of what the problem could be but try replacing:

PHP Code:

        $userinfo['posts'] = intval ( $userinfo['posts'] ) ;
        $_activeperc = round ( ( ( $_activeposts / $userinfo['posts'] ) * 100 ), 2 ) . "%" ; 


with:

PHP Code:

        $userinfo['rposts'] = intval ( $userinfo['posts'] ) ;
        $_activeperc = round ( ( ( $_activeposts / $userinfo['rposts'] ) * 100 ), 2 ) . "%" ; 


Regards,
g-force2k2

[Sadie Frost]

Great - thanks! That fixed the problem with post count. Still having a problem with the % though. (I get like 32600% even after the upgrades.)

Just another comment - would there be a way to exclude forums?

[g-force2k2]

Originally Posted by Sadie Frost

Great - thanks! That fixed the problem with post count. Still having a problem with the % though. (I get like 32600% even after the upgrades.)

Just another comment - would there be a way to exclude forums?

As for forum exclusions they are already built in based upon forum permissions, but not user access masks, if you wanted to add certain forums you can add to the array list, if you're not sure how I would be happy to help.

As for the high percentage that's the only bug that I am unsure of, but I will try and seek a fix, for some odd reason I never have gotten that percentage issue, but a few others addressed it and Natch tried to explain it on page four I believe.

Cheers,
g-force2k2

[Natch]

Yeah - it's only happening to my Administrators ...

[Natch]

Originally Posted by Natch

Yeah - it's only happening to my Administrators ...

G-force2k2: PM me for a sample account access if you wanna check in my forum for an example of this bug ...

The following links show three profiles ...

This one calculates ( (most active forum posts / 2 ) *100 ) and is an ex-moderator profile.

This is my profile, and is calculating ( (most active forum posts/1) * 100 ).

A regular user profile, calculating properly ( (most active forum posts/total user posts) * 100 ).

[Sadie Frost]

Originally Posted by g-force2k2

As for forum exclusions they are already built in based upon forum permissions, but not user access masks, if you wanted to add certain forums you can add to the array list, if you're not sure how I would be happy to help.

Thanks! I've been trying to do this but I don't really know anything lol. The problem is that we have an archive forum, so a lot of users come up with that as their most active forum lol.

Would it be something like:

WHERE t.forumid NOT IN ( " . implode ( ",", get_noaccess_forumids (  ) ) . " OR 'forumid==16' )

?

FYI - some (but not all) regular users are coming up with the weird percentages as well as admins.

[g-force2k2]

Originally Posted by Sadie Frost

WHERE t.forumid NOT IN ( " . implode ( ",", get_noaccess_forumids (  ) ) . " OR 'forumid==16' )

?

FYI - some (but not all) regular users are coming up with the weird percentages as well as admins.

Sadie Frost

PHP Code:

WHERE t.forumid NOT IN ( " . implode ( ",", get_noaccess_forumids (  ) ) . " )
      AND t.forumid != 16 


Thanks for the links Natch I will take a look.

Cheers,
g-force2k2

[Sadie Frost]

Ah that makes more sense lol - thanks hon!

[ChuanSE]

Great Hack m8