You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 troubleshooting → Reseting post count
So on a PunBB install... I reset a user's post count as a joke. He was at about 70ish and I set him to 10001 via the user profile (as seen when logged in as an Admin). Now how to do I set him back to his actual count? He should be around 80 or 90 now, but I accidentally reset him back to 0, so he's only listed as having a couple of posts. 
Any way to do this easily?
Go to his profile and change it 
So basically, if I want to be accurate, I have to count up his posts and just put that as the starting number?
D'oh! 
(I was hoping there was a "switch back to actual count" option somewhere)
Just put in 80 or something
Ah, got it! I did a search by author, listed results as posts, and just counted 'em up.
Cool.
Now I just hope it continues to count up from the 101 he has when he makes new posts. 
Yeah it will 
I actually wrote a plugin to do this a little while back (for everyone in the forums though), lets see if it is somewhere...
Aha, yes, I have a copy I can get to (I don't know why I didn't release it)
I actually wrote a plugin to do this a little while back (for everyone in the forums though), lets see if it is somewhere...
Aha, yes, I have a copy I can get to (I don't know why I didn't release it)
eww, sry for pulling up this old thread, but i wonder where i can find your plugin for post count reseting 
Just run the following SQL query:
update prefix users set num_posts=(select count(id) from prefixposts where poster_id=prefixusers.id) where id > 1where prefix is your database prefix
Providing you're using MySQL 5.
Are you sure? I think that would work in 4.1 as well
Possibly, depends on when subqueries where introduced, but I think it was MySQL 5.
Ah, all the better
i replaced user_id with poster_id (because there was no user_id column in the posts table) and now all users have 0 posts -.-
it's MySQL 4.1.22
(i run the sql query directly in the phpmyadmin)
I modified the query, try it now
works
ill write an admin plugin for this maybe
would be my first
thx
ok, here it is:
PunBB Forums → PunBB 1.2 troubleshooting → Reseting post count
Powered by PunBB, supported by Informer Technologies, Inc.