The Arcive of Official vBulletin Modifications Site.

vb3 User Forum Activeness Hack v1.4 · **Released**: 01-11-2004

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

Zelda-King · #72 02-28-2004, 08:52 AM

Quote:

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.

I can confirm this. I have one guy with nearly 2000 posts and in his profile it says he has only 1.

I can also confirm the fix fixes the post count leaving just the percentage iffy.

ChuanSE · #73 03-01-2004, 05:45 AM

are those thousand posts also posted in hidden or restricted area's?

This hack works fine on my board tho...

RapCheck · #74 03-27-2004, 04:45 PM

alright I just installed this and everything went fine

though I'm having similar problems to other people

for most users, it seems those with 1000s+ posts their post count is cut off it seems to the first number for those with 1000s and the second number for those with 10000s (user with 13,000 is shown with post count of 13, user with 6,000 is shown with 6 posts) which in turn shows an insane % such as 60000% and so on. also seems users with 100s of posts everything shows up fine.

I've gone through this thread and not sure on what fixes if any work to solve these problems. Would be a great hack if this was cleared up...

RapCheck · #75 04-04-2004, 10:32 PM

up...

are the problems with this hack not going to be fixed?

Kevorkian · #76 04-05-2004, 07:22 AM

Quote:

Originally Posted by RapCheck

up...

are the problems with this hack not going to be fixed?

with a total of 1929 posts contributing to 64300% of their total posts. lol ^^ i think there are some bugs
i have this problem not only on administrator but also smod and normal user

buro9 · #77 04-05-2004, 10:08 AM

Quote:

Originally Posted by Kevorkian

with a total of 1929 posts contributing to 64300% of their total posts. lol ^^ i think there are some bugs
i have this problem not only on administrator but also smod and normal user

Yes, I wish all the fixes would be rolled up into the installer too... come on hacker! Do your stuff.

Anyhow, your numbers are being formatted with commas... strip them out and it'll be fine

It only happens with users who have more than 1,000 posts yeah?

Kevorkian · #78 04-06-2004, 06:51 PM

yeah the problem is this but i can't find the error ;___;

buro9 · #79 04-06-2004, 07:21 PM

Ah well, break vbulletin.org procedures to publish someone's code when he should be supporting, sigh.

Here is the solution

You've got some code in member.php that is part of this hack... just below:

PHP Code:


			
{

  $show['lastpost'] = true;

  $userinfo['lastposttitle'] = '';

  $userinfo['lastposturl'] = '#';

  $userinfo['lastpostdate'] = $vbphrase['never'];

  $userinfo['lastposttime'] = '';

}

And just above:

PHP Code:


			
// reputation

fetch_reputation_image($userinfo);

Well, that code should ideally look like this:

PHP Code:


			
// HACK : START : USER ACTIVENESS

  $show[useractiveness] = 0 ;

  if ($userinfo[posts]) {

    $forumids = implode("', '", get_noaccess_forumids());

    $tfarray = $DB_site->query_first(

     "SELECT COUNT(*) AS aposts," . TABLE_PREFIX . "forum.title AS aftitle, " . TABLE_PREFIX . "thread.forumid AS aforumid

      FROM " . TABLE_PREFIX . "thread

      LEFT JOIN " . TABLE_PREFIX . "post ON " . TABLE_PREFIX . "post.threadid = " . TABLE_PREFIX . "thread.threadid

      LEFT JOIN " . TABLE_PREFIX . "forum ON " . TABLE_PREFIX . "forum.forumid = " . TABLE_PREFIX . "thread.forumid

      LEFT JOIN " . TABLE_PREFIX . "deletionlog ON ( " . TABLE_PREFIX . "deletionlog.primaryid = " . TABLE_PREFIX . "thread.threadid AND type = 'thread' )

      WHERE " . TABLE_PREFIX . "forum.forumid NOT IN ( '$forumids' )

        AND " . TABLE_PREFIX . "thread.visible=1

        AND " . TABLE_PREFIX . "deletionlog.primaryid IS NULL

        AND " . TABLE_PREFIX . "post.userid = $userinfo[userid]

      GROUP BY " . TABLE_PREFIX . "forum.forumid ORDER BY 1 DESC LIMIT 1");

    $_activeposts = $tfarray['aposts'];

    $_activeurl = "<a href=\"forumdisplay.php?$session[sessionurl]f=".$tfarray['aforumid']."\">".$tfarray['aftitle']."</a>";

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

    $show[useractiveness] = 1 ;

  }

// HACK : END : USER ACTIVENESS

As that does the math properly and also explodes and implodes the number in the math to get round any formatting

It's a great hack, and all of the solutions are in this thread... the author just hasn't kept track of it and rolled the bug fixes back into the installer to help everyone who has recently installed it.

Anyhow, that should solve it.

RapCheck · #80 04-06-2004, 07:44 PM

great! that fixed it. thanks

Natch · #81 04-11-2004, 08:59 AM

Thank you thank you thank you!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09313 seconds Memory Usage 2,342KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!