User Forum Activeness Hack v1.0

Yet another hack by g-force2k2 (yeah i know aren't we all gettign sick of it by now )

Edit: Download the latest attachment [ Here ]

Thanks bunches to Neo for the fix

well this one wasn't requested but i myself was trying to plain around with mysql and all and i came up with a new hack

What does this hack do?
// +++++++++++++++++++++
Simply shows what forum the user is most active in and the percentage of his posts in that forum compared to overall

What to do?
// +++++++++++++++++++++
File Modifications (2)
Template Modifications (1)
Templates to Add (1)

It's a fairly easy hack to install maybe 1-2 minutes max but i like how it looks shows on the getinfo template when viewing another member's profile... simple yet wicked

Instructions in the .php file attached below just open in a text editor

Notice i didn't include this on the postbit template because it would up the query count by a fair amount so i figured the getinfo would be suffice... If you like this hack i'd be greatful if you clicked install... regards and enjoy

g-force2k2

[wolfe]

not working properly not showing in Getinfo template

[wolfe]

i mean it is now showing anything to do with activity in the getinfo template below Posts

[PsYc]

i found an error according to your hack

if a member has 0 Posts, but he or she posts in a forum which doesn't count any posts you get a division by zero

Warning: Division by zero in /is/htdocs/62144/www.yourdomain.com/board/vb/member.php on line 1620

on that line i got this:

$f_posts = floor(($t_post[ppforum] / $userinfo[posts]) * 100);

but i think it has to do with the full code in there

hope you'll find a clue for this

[g-force2k2]

wolfe make sure you have the $forumactive variable in the getinfo template...

PsYc open the getinfo template find:

PHP Code:

    $f_posts = floor(($t_post[ppforum] / $userinfo[posts]) * 100); 


replace it with:

PHP Code:

    if($t_posts[ppforum] > 0) {
             $f_posts = floor(($t_post[ppforum] / $userinfo[posts]) * 100);
            } else {
               $f_posts = 0;
            } 


that should do the trick... regards...

g-force2k2

[dong]

nice hack

maybe it would be nice if it would also calculate most active forum of thread starts of a user

[g-force2k2]

dong haven't tested it yet... but give it a shot regards...

g-force2k2

[dong]

nice

but some typo ORDER BY ppforum should be ORDER BY tforum


and the procentage stays on 0
cos (($t_thread[tforum] / $userinfo[posts]) * 100) is not right i think
maybe (($t_thread[tforum] / $userinfo[threads]) * 100) is better

[g-force2k2]

oh yea whoops

the first change is correct.. but you have to add in this query too

PHP Code:

$threads = $DB_site->query_first("
  SELECT COUNT(threadid) AS total
  FROM thread
  WHERE postuserid='$bbuserinfo[userid]'");
$userinfo[threads] = $threads[total]; 


regards just add this query above the others...

g-force2k2

[dong]

jup
and this line:

PHP Code:

if(!$t_post[tforum]) { 


should be:

PHP Code:

if(!$t_thread[tforum]) { 


nice addon
thx

[dong]

Originally posted by g-force2k2

PHP Code:

$threads = $DB_site->query_first("
  SELECT COUNT(threadid) AS total
  FROM thread
  WHERE postuserid='$bbuserinfo[userid]'");
$userinfo[threads] = $threads[total]; 


it should be:

PHP Code:

$threads = $DB_site->query_first("
  SELECT COUNT(threadid) AS total
  FROM thread
  WHERE postuserid='$userinfo[userid]'");
$userinfo[threads] = $threads[total]; 


otherwise it uses the total threads of the user that is checking the profile