Seperate Post Count for Selected Forum

[Bald Bouncer]

is there a way to have a post count to the left that will only count posts made in a certain forum?

thanks

[JamesUS]

You can set it so that it doesn't count certain forums, so in theory you could set it so it only counts the forum you want. That would affect all post count displays though..if you want a seperate one if needs to be a code hack.

[Bald Bouncer]

yeah I noticed that mate, I was kinda looking to have both a count for ALL and a count for a chosen Section, anyway if its too hard to do I guess i can live without it....

cheers for the help

[Bald Bouncer]

bump

[webhost]

Try this Firefly wrote this for me and it works great, you might have to modify it a little.

http://161.58.84.213/forum/showthrea...threadid=26988

[Bald Bouncer]

cheers mate, fron the info Ive been given I think I need something along these lines,

$invposts=$DB_site->query_first("SELECT COUNT(postid) AS posts FROM post LEFT JOIN thread USING (threadid) WHERE forumid=11 OR forumid=23 OR forumid=13 OR forumid=14 OR forumid=15 OR forumid=16 OR forumid=17 OR forumid=18 AND post.userid=$post['userid']");

can anyone fix this please?

[webhost]

Here is how I did it, I have post and thread counts go to my forum in my signature and look torwards the bottom forum on the page.

PHP Code:

$invposts=$DB_site->query_first("SELECT replycount FROM forum WHERE forumid=29");
$invthreads=$DB_site->query_first("SELECT count(*) AS threadcount FROM thread WHERE forumid=66 OR forumid=23 OR forumid=36 OR forumid=27 OR forumid=25 OR forumid=21 OR forumid=24 OR forumid=87"); 


Then used this in forumhome template.

PHP Code:

Total Posts: <B>$invposts[replycount]</B><br>Total Thread: <B>$invthreads[threadcount]</B> 


[Bald Bouncer]

I see what you have mate, this counts all replys made in a certain forum and displays the total, I just want to display the amount each user has made in a certain forum and display it in their postbit

[Stasik]

in showthread.php find:

  $postbits .= getpostbit($post);

and place BEFORE it:

$user[forumposts]=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE forumid=$forumid AND userid=$post[userid]");

then you can use "$user[forumposts]" in postbit templates

[Admin]

Not recommended for performance issues.
You are basically running a query inside a loop, so for every post in a thread that query will be executed.

(trust me, I learned the very hard way)