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

[Cassidy]

THANK YOU! I loved this hack and was hoping someone would port it! I was requesting it all over the place XD

*Installs straight away*

[dede1]

Thanks, I then times continue to look for find I that much

[Cassidy]

Uh i've come across a problem. Over 100 of this users posts are in a different forum but it's saying there's 4 in another forum as thier most.

[g-force2k2]

Originally Posted by Cassidy

Uh i've come across a problem. Over 100 of this users posts are in a different forum but it's saying there's 4 in another forum as thier most.

Alright I'll try and figure things out soon, sorry for the problems.

You can try to see if this fixes anything.

open member.php

find:

PHP Code:

        GROUP BY forum.forumid 


Above it add:

PHP Code:

        ORDER BY aposts 


Don't know if that will have any effect though.

Regards,
g-force2k2

[dede1]

Thanks the % is correct. The forum only always indicates
XX, it would have nevertheless also forum XY or XS to show

[dede1]

0 Poster Profil :

PHP Code:

[b]Warning[/b]: Division by zero in [b]/var/www/html/Board/member.php[/b] on line [b]379[/b]
function showSpoiler(block) {   // by The Small One   block.nextSibling.nextSibling.style.display ="block";   block.parentNode.removeChild(block);} 


[SnowBot]

nice job g-force2k2

keep the hard work up

INSTALLS

[SnowBot]

Little problem, install went well but

Forum Activeness StatisticsAidie is most active in the forum Aliens And UFO's
with a total of 2 posts contributing to 0.22% of their total posts.


Does the hack only calculate from date of install ?

BTW Aidie is an admin with Total Posts: 909 (5.59 posts per day

thanks

[g-force2k2]

Originally Posted by dede1

0 Poster Profil :

PHP Code:

[b]Warning[/b]: Division by zero in [b]/var/www/html/Board/member.php[/b] on line [b]379[/b]
function showSpoiler(block) {   // by The Small One   block.nextSibling.nextSibling.style.display ="block";   block.parentNode.removeChild(block);} 


I will have to updated my install to prevent the division by zero, I forgot about users with no posts, but I will update as soon as possible

Originally Posted by dede1

Thanks the % is correct. The forum only always indicates
XX, it would have nevertheless also forum XY or XS to show

I don't quite follow what you mean, could you explain it in more depth?

Snowbot did you try adding the ORDER BY to the query? I will have to investigate this because I saw that it was incorrect too, sorry for the setbacks.

Regards,
g-force2k2

[dede1]

Mmmm it shows always the same forum in the forum statistics on all the
same where one thus always looks

User-Forum-Statistik
Dede1 hat in dem Forum C 4 Beitr?ge geschrieben, da? sind 0% aller seiner Beitr?ge.

Always forum C with me