Editing Post Count on phpBB3 Forum

[Joe 2]

Hey everyone.

Does anyone know how to edit the post counts of users on a phpBB3 forum? I had an issue were post counts wouldn't increase when you posted. I got that resolved by now need to edit the profiles of my member to switch there posts counts to what they really should be.

Can someone help me out? Thanks.

 

[StripesAndFins]

what's your host? i think on some hosts you have a "resynchronize posts" button that can do that.

 

[Joe 2]

I'm using We Host Your Info.

http://www.wehostyour.info

 

[StripesAndFins]

Well I've never used that host. Have you tried looking for the "re-sync" button in the ACP?

 

[Joe 2]

Well I've never used that host. Have you tried looking for the "re-sync" button in the ACP?

Yes. I can't locate one.

 

[Deleted member 1609]

Go into the MySQL database. Go to the "users" table. There should be a column that says "user_posts." You then just have to scroll down until you see the member whose post count you wish to change. Then, just edit and save.

 

[Joe 2]

Thanks Snobo. I got it working thanks you your help. +rep.

 

[CyberFreak]

You shouldn't really edit the db manually as it can cause problems if you don't know what you are doing. Deleting or editing 1 thing can cause errors elsewhere as something else will need to be edited or deleted. Some things can be undone while some things can not be.

What you really wanted to do was use this option on the home page of the ACP

Resynchronise post counts
Only existing posts will be taken into consideration. Pruned posts will not be counted.