Announcement

Collapse
No announcement yet.

Dump of List of Posts Count Per User Command?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dump of List of Posts Count Per User Command?

    Hi,

    Is there any way to dump a list of total post counts per username out of the database? The listing from the cpanel is too ungainly to do anything useful with a large site.

    Thanks for any help.

    Hamish

  • #2
    You can run the query of:

    select username, posts from user;

    Using phpMyAdmin, you can export the results of that query as a CSV file for use in a spreadsheet application.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X