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

[n9com]

i get this problem:

Total Posts: 999 (2.30 posts per day)
Find all posts by n9com
Find all threads started by n9com
Forum Activeness Statisticsn9com is most active in the forum The Lounge with a total of 262 posts contributing to 0.03% of their total posts.

But it works fine for another member in the US (i am in the UK) - dont know if this makes a difference:

PostsTotal Posts: 2,145 (13.07 posts per day)
Find all posts by ice
Find all threads started by ice
Forum Activeness Statisticsice is most active in the forum The Lounge with a total of 1159 posts contributing to 57.95% of their total posts.

[Zelda-King]

I've had this hack installed a while now and I've noticed that it doesn't appear for me when using Mozilla Firebird. I've tested it with Internet Explorer and Opera and it shows OK on those.

[achtungbaby]

Nice.

*install*

[gmarik]

Fatal error: Call to undefined function: log_admin_action() in /pub/home/install_ufactive.php on line 200

[g-force2k2]

Originally Posted by gmarik

Fatal error: Call to undefined function: log_admin_action() in /pub/home/install_ufactive.php on line 200

Did you by chance upload to a different directory on accident?

Originally Posted by Zelda-King

I've had this hack installed a while now and I've noticed that it doesn't appear for me when using Mozilla Firebird. I've tested it with Internet Explorer and Opera and it shows OK on those.

Very interesting, any ideas on what the cause could be?

Regards,
g-force2k2

[g-force2k2]

Updated the hack to v1.3

Basically all the update does is optimize the query for performance issues especially advised for larger boards so that the number of records that the database has to scan is decreased drastically.

Download the attached txt and make the changes to the member.php. It's just one file modification, but it'll with it's increased performance it's worth it.

Cheers,
g-force2k2

[Natch]

Two things:

One:

Originally Posted by Zelda-King

I've had this hack installed a while now and I've noticed that it doesn't appear for me when using Mozilla Firebird. I've tested it with Internet Explorer and Opera and it shows OK on those.

[high]* Natch clicked install, then debugged the Firebird issue ...
[/high]

I have found out why this is:

<!-- vb3 User Forum Activeness Hack v1.0 -- Copyright g-force2k2 2004 //-->

Firebird takes these double-dashes (bold and underline above) as part of the comment - so you have commented out the the comment ... to a degree ...

Use:

<!-- vb3 User Forum Activeness Hack v1.0 : Copyright g-force2k2 2004 //-->

It will have no impact on any other browser, but it means the hack info will show up on Firebird ...

Two:

Natcher00 is most active in the forum General Chat with a total of 390 posts contributing to 39000% of their total posts.

EDITED QUOTE: Old problem no longer a problem after Upgrade3.txt, but now I have the numposts * 100." %" problem ...

[Natch]

I think the previous poster was right: the value of $userinfo['posts'] is not coming thru properly ... this is formatted using vb_number_format earlier in the member.ph file, so the value of $userinfo['posts'] is in fact a string now - not a number.

We're almost there: $userinfo gains it's values on (unedited) line 184 ... we just need to reverse the effect of vb_number_format on the value of $userinfo['posts'] ...

[Natch]

Just a FYI: I created a debugging var

	$_allposts = intval($userinfo['posts']);

and used this value as the replacement for $userinfo['posts'] ... I also outputted it in brackets for debuggin purposes ...

Natcher00 is most active in the forum General Chat with a total of 390 posts contributing to 39000% (1) of their total posts.

So $userinfo['posts'] is in fact taking the value "1" ...

Hmmmm .....



Ah - HAH!

I checked another user just for interest's sake

-=UMF=- Axi is most active in the forum Off-Topic! with a total of 157 posts contributing to 32.11% (489) of their total posts.

So it only applies (IMO) when testing your own account ... (maybe Admin accounts?) ...

Tigga is most active in the forum General Chat with a total of 12 posts contributing to 48% (25) of their total posts.

^^ My test account - therefore it's related to Admin users maybe ...

EDIT: Yup - Admin user-related ...

WalkerB is most active in the forum General Chat with a total of 255 posts contributing to 25500% (1) of their total posts.

One of my other site Admins ...

Found the bug ... dunno how to fix it ... :ninja:

[Baugh]

I received this error when trying to install:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: SELECT phrasetypeid FROM phrasetype WHERE fieldname='global'
mysql error: Table '......_forums.phrasetype' doesn't exist

mysql error number: 1146

Date: Wednesday 04th of February 2004 12:37:25 AM
Script: http://.......com/acpanel/install_ufactive.php?step=5
Referer: http://.......com/acpanel/install_ufactive.php?step=4
Username: Dave
IP Address: ..............


This is a clean install of vB, minus a couple of very minor template changes. Any clue what could be going wrong? I got this after it attempted to update the language phrases.