Post count hack?

[ludachris]

So, in the postbit template, we have the post count # displayed for each member (at least some of us do). I was wondering if there was a way to build a post count for a member for only specified forums...

Post Count (for forumID[10] AND forumID(12): 25

So if a user has a total of 25 posts in ForumID(10) and ForumID(12) combined, then their post count would show up as 25. The reason I'd want this is because these are my important forums, and I want people to see how much these users contribute in those forums as opposed to knowing their overall post count. Is this possible? And how much load would it put on the server since it would be displayed in postbit?


Edit:
Actually, just found basically what I'm looking for already done for vB2... anyone seen it for vB3 yet:
https://vborg.vbsupport.ru/showthread.php?t=48977
If not, can someone PLEASE rewrite it for vB3?!?!?!?!?!

[DRJ]

What I do is only count posts for certain forums.

Otherwise, somthing like this should work.

PHP Code:

$postcount = $DB_site->query("SELECT count( * ); 
FROM vb3_post As p, vb3_thread As t 
WHERE p.threadid = t.threadid
AND t.forumid = XX
AND p.userid = YY
"); 


[ludachris]

Originally Posted by DRJ

What I do is only count posts for certain forums.

Otherwise, somthing like this should work.

PHP Code:

$postcount = $DB_site->query("SELECT count( * ); 
FROM vb3_post As p, vb3_thread As t 
WHERE p.threadid = t.threadid
AND t.forumid = XX
AND p.userid = YY
"); 


What file would I find that in? I think I'd want to keep the overall post count and have a secondary post count. I'm assuming this would be the only post counter?

[DRJ]

There is a mistake, remove the ; from the first line.

You could add this code to your showthread.php

PHP Code:

$postcount= $DB_site->query("SELECT count( * )
FROM vb3_post As p, vb3_thread As t
WHERE p.threadid = t.threadid
AND t.forumid In(16,17,18)
AND p.userid = $post[userid] 


Then add $postcount to your postbit_legacy template whereever you want the number to appear.

I this example we are counting posts in forum 16, 17, 18.

Note that this would run a query for each post in the thread everytime anyone viewed any thread.

[Marco van Herwaarden]

Sorry guys, but no hack is needed for this in vB3.

Edit your Forum settings, you will find a setting called something like "Posts in this forum add to postcount". Set this to No for all forums, except the ones mentioned above.

[DRJ]

He said he wanted to keep the overall post count and also add a secondary count for each user shown on the posts.

[ludachris]

Originally Posted by MarcoH64

Sorry guys, but no hack is needed for this in vB3.

Edit your Forum settings, you will find a setting called something like "Posts in this forum add to postcount". Set this to No for all forums, except the ones mentioned above.

I'd like to keep an overall count plus a secondary count.

And I'm assuming that if I were to change it via the control panel, only counting posts from a few of my forums instead of most all, then recalculate post counts, that any Ranks I have set up would be based on the new smaller post count and not the true (much larger) overall post count?

If this is the case, I really don't want to do it via the forum settings. I'd like to see about doing it like the hack that I linked to above - adding a secondary post (special) counter. Can anyone port that hack to vB3?

[Marco van Herwaarden]

Sorry overlooked the part where you said you also wanted to keep the full postcount.

[ludachris]

Originally Posted by MarcoH64

Sorry overlooked the part where you said you also wanted to keep the full postcount.

So I think I figured out how to do it... I duplicated the 'posts' field in table 'user' and named it 'posts_new'. Then, in "functions_newpost.php" I added code that should update the user's post count AND their post_new count at the same time. So now, going forward, I believe it will count all new posts (only for the specificed forums) in the new field.

However, how would I write a script that updates that count for all posts in those forums prior?

[ludachris]

It's too bad that people don't get the same amount of help here in the "free" forum now that there's a "payed service request" forum. This place used to be full of helpful people who didn't mind lending a hand with questions like this. Looks like there isn't much help available at all unless you want to pay to have your question answered... or maybe there just aren't as many people on here who know what they're doing with VB3. I guess people are still figuring out VB3.