Announcement

Collapse
No announcement yet.

How to set every members post count to 0

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

  • How to set every members post count to 0

    Hello,
    What query would I run to set everyones post count to 0 ?

    Thanks,

    Greg

  • #2
    Code:
    UPDATE user
    SET posts = 0
    The post counts will be reset to their true values if you ever rebuild post counts:

    Admin CP -> Maintenance -> Update Counters -> Update Post Counts

    Comment


    • #3
      Code:
      UPDATE civilwaruser
      SET posts = 0

      Comment

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