vb.org Archive - Users total posts (even in no postcount areas)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Users total posts (even in no postcount areas) (https://vborg.vbsupport.ru/showthread.php?t=90837)

KaiSan

06-22-2005 08:49 PM

Users total posts (even in no postcount areas)

How do I go about finding this?

I was to find out a members postcount, but we have no post count in the spam section...

I was just wondering if there was a way to find out how to count all those up as well.

Thanks. :)

Tony G

06-23-2005 06:32 AM

It depends, do you want to find the count for yourself or begin adding post counts from a forum which didn't allow them before?

KaiSan

06-23-2005 04:22 PM

No, I want to know how many posts a member has, counting the ones in the no postcount areas.

Thanks. :)

Tony G

06-24-2005 02:15 AM

I know of no other way besides turning post counts in that forum on and rebuilding the member stats, but that will update it on the forum as well as you knowing.

Kingster

07-06-2005 05:19 PM

Quote:

Originally Posted by KaiSan

If it's really only for your knowledge, you can do it through MySQL...

Code:

SELECT username, COUNT(  *  )  AS realpostcount

FROM post

GROUP  BY username

ORDER  BY username DESC;

I'm trying to figure out a way to add this info onto the user, so I can build a dynamic "bar" that indicates how many "useful" posts a user has versus posts in our spammy area.

Andreas

07-06-2005 06:49 PM

grouping by userid would be better IMHO as this column is indexed - and integer operations should always be faster then string operations.

All times are GMT. The time now is 05:09 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00958 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: