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

[g-force2k2]

Actually Neo all you did was do an order by... the actually query itself already selected both the posts in that forum that they replied in most as well as the forumid... so i fail to see what your code change did? regards...

g-force2k2

[Webmasta XT]

awesome hack..

[Neo]

Originally posted by g-force2k2
Actually Neo all you did was do an order by... the actually query itself already selected both the posts in that forum that they replied in most as well as the forumid... so i fail to see what your code change did? regards...

g-force2k2

well try the queries in in your MySQL of choise and you will see what I mean... I can give you a example...

using it without the ORDER BY I get for user number 81

PHP Code:

ppforum  |  forumid
------------------------
   9              2 


adding the ORDER BY I get for user number 81

PHP Code:

ppforum  |  forumid
------------------------
   756              7 


now what do you think would be more correct?

[g-force2k2]

yes thank you neo for visual i see what you mean now regards and thanks a bunch... file updated

g-force2k2

[Boofo]

I also changed this line:

PHP Code:

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


To this:

PHP Code:

$f_posts = round(($t_post[ppforum] / $userinfo[posts]) * 100,2); 


for a more accurate count.

I am still having problems with the code for the Admins and Mods being the only ones able to see it.

[g-force2k2]

Boofo try this then... open member.php

find:

PHP Code:

    eval("\$forumactive = \"".gettemplate('getinfo_forumactive')."\";"); 


replace with:

PHP Code:

    if($bbuserinfo[usergroupid] == 5 OR $bbuserinfo[usergroupid] == 6 OR $bbuserinfo[usergroupid] == 7) {
      eval("\$forumactive = \"".gettemplate('getinfo_forumactive')."\";");
      } else {
        $forumactive = "";
      } 


that should do the trick regards...

g-force2k2

[Boofo]

It worked, thanks. Just to verify, this is what the code should look like for me now, right?

PHP Code:

// +++++++ User Most Active Forum Hack [ g-force2k2 ] +++++++
  // thanks to neo for the query fix :)
  $t_post = $DB_site->query_first("
    SELECT COUNT(postid) AS ppforum, thread.forumid AS forumid
    FROM post
    LEFT JOIN thread ON thread.threadid = post.threadid
    WHERE userid = '$userinfo[userid]'
    GROUP BY(forumid)
    ORDER BY ppforum 
    DESC LIMIT 1");

    if(empty($t_post[ppforum])) {
      $forumactive = "";
    } else {
      $f_name = $DB_site->query_first("
        SELECT title
        FROM forum
        WHERE forumid = '$t_post[forumid]'");
    $f_posts = round(($t_post[ppforum] / $userinfo[posts]) * 100,2);
    $p_type = iif($t_post[ppforum] == 1,'Post','Posts');

    if($bbuserinfo[usergroupid] == 5 OR $bbuserinfo[usergroupid] == 6 OR $bbuserinfo[usergroupid] == 7) {
      eval("\$forumactive = \"".gettemplate('getinfo_forumactive')."\";");
      } else {
        $forumactive = "";
      }
    }
// +++++++ User Most Active Forum Hack [ g-force2k2 ] +++++++ 


And what did you think of the change for the percentage?

[g-force2k2]

yes... and the percentage is nice too regards...

question is does it work correctly though how you wanted it to?

g-force2k2

[Boofo]

Yes, now the private forum shows up like it is supposed to and the percentage will be more noticeable on boards with more messages.

[Boofo]

I do have one more question, though, is there a way to exclude certain forums (like with forumid)?