Number of Posts in Current Forum Only

Hack: Number of Posts in Current Forum Only
Version of vB: 2.2.0, although may work on earlier versions but not tested
Current Version: 1.0.0
Description: This hack shows how many posts a user has in the forum that the post you are viewing is in

Requested by Bald Bouncer.

[MarkB]

Does this override the current post count display? Or is it displayed seperately?

[MarkB]

Ok, I tried it, and the following error came up when viewing a thread:

Fatal error: Call to a member function on a non-object in /home/ultimatm/public_html/forum/admin/functions.php on line 275

[apfeifer]

It is displayed below it, I'll attach a screenshot of it.

Screenshot:

[apfeifer]

Ahh! Thank you! I forgot to add a step:

Find:

PHP Code:

global $showdeficon,$displayemails,$enablepms,$allowsignatures,$wordwrap,$dateformat,$timeformat,$logip,$replacewords,$postsperday,$avatarenabled,$registereddateformat,$viewattachedimages; 


After that add:

PHP Code:

global $DB_site; 


Sorry about that! I'll add it into the documentation right away.

[Scott MacVicar]

could kinda be bad, if a user has made 300 posts in the forums then thats 300 extra queries per post, you should cache it.

PHP Code:

if (!isset($posttotal[$post[userid]])) {
    $grabthreadids=$DB_site->query("SELECT threadid FROM post WHERE post.userid='$post[userid]' AND post.visible=1");
    
    $post[thisforumonly] = "0";

    while ($getcount=$DB_site->fetch_array($grabthreadids)) {
        $checkforumid=$DB_site->query_first("SELECT forumid FROM thread WHERE threadid=$getcount[threadid] AND thread.visible=1");
        if ($checkforumid[forumid] == $forum[0]) {
            $post[thisforumonly]++;
        }
    }
             $posttotal[$post[userid]] = $post[thisforumonly];
}
else {
  $post[thisforumonly] = $posttotal[$post[userid]];
} 


[apfeifer]

Yeah, in the other thread (the request) I mentioned how this had a lot of queries in it. I actually had tried something almost identical to what you did, but it wasn't working so I decided to release it so people had something to use and play with that later. Is that chunk of code you posted 100% sure to work? If so I'll add it in, with your permission, of course.

[Scott MacVicar]

I never tested it, just off the top of my head. You should test it first and see if it works.

[apfeifer]

Will do, let me finish documenting this other hack and I will do it ASAP.

[MarkB]

The hack works for me now, and I await to see if this caching bizzo works too