Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 Aug 2014, 19:22
tsptom tsptom is offline
 
Join Date: Jan 2006
How Post Count is Calculated

I have a question about how post counts are determined. I have one member who has 5042 posts, according to the database using this query:

SELECT count(*)
FROM post
WHERE username = 'xxx'

But that gets 42 more rows than what the post count in the forum is, which says 5000 even.

The "visible" field has 5039 1's and 3 2's, if that means anything.

What would cause the difference?

Thanks.
Reply With Quote
  #2  
Old 18 Aug 2014, 19:57
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Do any of your forums have "Count Posts Made in this Forum Towards User Post Counts" set to No?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 18 Aug 2014, 20:14
tsptom tsptom is offline
 
Join Date: Jan 2006
Interesting. Is there a way to check that in the database, as opposed to checking the individual forum settings?

--------------- Added 18 Aug 2014 at 20:23 ---------------

I'm not seeing any of the obvious forums set that way, like private forums and threads.

Could it have anything to do with deleted forums or threads? How about soft deleted posts?

Last edited by tsptom; 18 Aug 2014 at 20:24.
Reply With Quote
  #4  
Old 18 Aug 2014, 20:27
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Its possible it could be due to soft deleted posts, or posts that are in moderation.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #5  
Old 18 Aug 2014, 20:33
tsptom tsptom is offline
 
Join Date: Jan 2006
Thanks. Do you know how to eliminate soft deleted posts from this select statement?


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #6  
Old 18 Aug 2014, 20:44
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Try this:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #7  
Old 18 Aug 2014, 21:05
tsptom tsptom is offline
 
Join Date: Jan 2006
Adding visible took it down to the 5039. (there were three 2's in the visible column).

I think I will just have to go with the "posts" column in the user table. It matches the current forum's post count, but not what I count using the select. I was just curious why they didn't match.

Thank you!
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Post Count Modifier - Minimum Post Characters to Count towards Post Count Chris M vBulletin 2.x Full Releases 35 13 Oct 2003 20:29



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:06.

Layout Options | Width: Wide Color: