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

[buro9]

Originally Posted by 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.

Check the SQL in the install file... I've pointed this out before I think... it's just lacking the TABLE_PREFIX.

Once you fix the install file you can carry on from the place you were.

In fact, I outlined the correct code here:

https://vborg.vbsupport.ru/showpost....2&postcount=32

It's the first part that corrects the install.

[g-force2k2]

Update to version 1.4 Below.

Upgrade 1.4 Details.
--
Fixes Install and File Modification for forums that use the 'TABLE_PREFIX'
Fixes one of the issues with browser compatablity
Fixes another error with making $userinfo[posts] an number value again.
Great thanks to "Natch" and "buro9" for helping me debug some of the issues, still working on the last issue though.

Regards,
g-force2k2

[Baugh]

I must be an idiot. Thanks man. I've been modding on YaBB for a couple of years, but this was my first attempt to install a vB hack. Wouldn't you know I'd do something stupid.

[Zelda-King]

Applying Upgrade 4 gave me the following PHP error;

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/gamercr/public_html/bb/member.php on line 382

and the following SQL error;

Invalid SQL:
SELECT COUNT(*) AS aposts,f.title AS aftitle,
t.forumid AS aforumid
FROM thread t
LEFT JOIN post p ON post.threadid = thread.threadid
LEFT JOIN forum f ON forum.forumid = thread.forumid
LEFT JOIN deletionlog AS deletionlog ON ( deletionlog.primaryid = t.threadid AND type = 'thread' )
WHERE f.forumid NOT IN ( 0 )
AND t.visible=1
AND deletionlog.primaryid IS NULL
AND p.userid = 1
GROUP BY f.forumid ORDER BY aposts DESC LIMIT 1
mysql error: Unknown table 'post' in on clause

mysql error number: 1109

on the profile page.

I'll give it the benefit of the doubt for now though as I'll be reapplying the whole hack from scratch soon when RC4 is released (friday apparantly).

[g-force2k2]

Originally Posted by Zelda-King

Applying Upgrade 4 gave me the following PHP error;

and the following SQL error;
on the profile page.

I'll give it the benefit of the doubt for now though as I'll be reapplying the whole hack from scratch soon when RC4 is released (friday apparantly).

heh

I should learn to test my work before releasing updates, bad practice that I don't.

updated the attachment above going to test it now, and run the actual installer updates and if RC4 has some major changes I will probably update again

Cheers,
g-force2k2

[Allan]

idem

PHP Code:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: 
            SELECT COUNT(*) AS aposts,f.title AS aftitle,
                t.forumid AS aforumid
            FROM thread t
            LEFT JOIN post p ON post.threadid = thread.threadid
            LEFT JOIN forum f ON forum.forumid = thread.forumid
            LEFT JOIN deletionlog AS deletionlog ON ( deletionlog.primaryid = t.threadid AND type = 'thread' )
            WHERE f.forumid NOT IN ( 0 )
                AND t.visible=1
                AND deletionlog.primaryid IS NULL
                AND p.userid = 1
            GROUP BY f.forumid ORDER BY aposts DESC LIMIT 1
mysql error: Table inconnue 'post' dans on clause

mysql error number: 1109 


I have well do all the setting has days from 1 to 4

[g-force2k2]

Socrate try re-downloading the upgrade4.txt, because it was updated and those changes are included in your sql.

Cheers,
g-force2k2

[Allan]

Originally Posted by g-force2k2

Socrate try re-downloading the upgrade4.txt, because it was updated and those changes are included in your sql.

Cheers,
g-force2k2

veiled, that functions, thank you has you

[Zelda-King]

Yes that fix is much better, thankyou.

[Zelda-King]

OK, new problem on RC4: Nothing shows in the table. You just see a border with no text in it. I'm going to try it all again tomorrow but I've just spent hours readding my hacks to my just-upgraded board.

EDIT: It turns out the hack is fine. I just needed to drop and redo steps 1 & 2.