post count

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
Registered User
Posts: 215
Joined: Mon Mar 19, 2007 6:02 pm
Location: phpbb3 newbie

post count

Post by steve8675537 »

is it possible to reset the all post counts in phpbb3, so even in the memberlist the post counts are reset?
User avatar
Support Team Member
Support Team Member
Posts: 51682
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

Re: post count

Post by stevemaury »

What do you want to reset them to? Zero? If so, run this SQL:

Code: Select all

UPDATE phpbb_users SET `user_posts` = ) Where user_id >1
That will set EVERY users post to zero.

If you want a particular user:

Code: Select all

UPDATE phpbb_users SET `user_posts` = ) Where user_id = N
where N is the user's user_id.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Return to “[3.0.x] Support Forum”