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

[reteep]

Noone knows what to do? :/

[Megareus Rex]

Ok, here's my problem:

Not only does it incorrectly display the % of posts in a forum

Lancet Jades is most active in the forum Role Playing Games with a total of 631 posts contributing to 10516.67% of their total posts.

But also, it messes up the post count of users! (Not the actual post count, just the post count shown in member.php)

Total Posts: 6 (22.76 posts per day)

As you can see, the posts per day is still correct, but the actual number is messed up somehow. How can I fix these problems?

EDIT: Apparently, this only happens with some of my staff. Does this mean it's a usergroup thing? Or is it messing up because we have posts in private forums?

[father]

i think thats poor, no support it looks:/
we(my team members and me) are really fans of stats, but we dont lie, the hack doesnt work, why nobody can say us why?

[Oblivion Knight]

Everything seems to be working fine for me..

Thanks for a great hack

[HarryBO]

Hi!

I tried to install this Hack a few times, but there is one Problem! I have installed the "Users Threads in Profile" Hack, too. Now I become an error message (misc.php)

Can someone help me?

Sorry about my english (I came from Germany)

Greetz
BO

[Lethal]

yup same here

Fatal error: Cannot redeclare get_noaccess_forumids() (previously declared in /htdocs/www/forums/includes/functions_user.php:518) in /htdocs/www/forums/includes/functions_misc.php on line 18

[Natch]

try replacing your include() with include_once() and require() with require_once() ...

[Psybadek]

I have a problem with it...

The new stats work fine, but total posts have really messed up.

It only shows the first number e.g. a member with 8,345 posts shows as only 8.

Whats the problem? Thanks.

[PheReFuLL]

/* vb3 User Forum Activeness Hack -- Copyright g-force2k2 2004 */
	$show[useractiveness] = 0 ;
	if ( $userinfo[posts] ) :
		$tfarray = $DB_site->query_first ( "
			SELECT COUNT(*) AS aposts,f.title AS aftitle,
				t.forumid AS aforumid
			FROM " . TABLE_PREFIX . "post p
			LEFT JOIN " . TABLE_PREFIX . "thread t USING ( threadid )
			LEFT JOIN " . TABLE_PREFIX . "forum f ON f.forumid = t.forumid
			LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON ( deletionlog.primaryid = t.threadid AND type = 'thread' )
			WHERE t.forumid NOT IN ( " . implode ( ",", get_noaccess_forumids (  ) ) . " )
				AND t.visible=1
				AND deletionlog.primaryid IS NULL
				AND p.userid = $userinfo[userid]
			GROUP BY f.forumid ORDER BY aposts DESC LIMIT 1" ) ;
		$_activeposts = $tfarray['aposts'] ;
		$_activeurl = "<a href=\"forumdisplay.php?$session[sessionurl]f=" . $tfarray['aforumid'] . "\">" . $tfarray['aftitle'] . "</a>" ;
		$userinfo['posts'] = ( $userinfo['posts'] ) ;
		$_activeperc = round  ( ( ( $_activeposts / $userinfo['posts'] ) * 100 ), 2 ) . "%" ;
		$show[useractiveness] = 1 ;
	endif ;
/* vb3 User Forum Activeness Hack -- Copyright g-force2k2 2004 */

That should fix the problem.

Er... I realized that the percent is still screwed up if the post count is over 1,000. I only fixed the problem with the post count not displaying correctly when it reaches 1,001. <<;; I'll try and fix the percent thing later.

[Lethal]

I just put

require_once('./includes/functions_misc.php');

in member.php about the code you insert into member.php for this hack and it worked since the the code you have to put in function_user.php I already have in functions_misc.php.