UBB.Developers Forums UBB.threads 7 Development How Do I? Maintenence?

Hey guys.. Gotta quandary...

Either one of my tables is messed up, or my entire database is..

A week or so ago, I had my _Users table get majorly corrupted, so I had to do a MySQL "REPAIR TABLE" on it. Since around the same time period, some replies and posts have been found missing.

For example: On the main Index page, it will say that a post has 19 replies. Yet when you view it, it only shows 14 (threaded mode.) I just had a user get their "Post Count" past a new-title level, and their title did not automagically change.

Are there scripts that will go thru and fix counts/posts, etc? Any ideas?

Thanks!
Mike.

[Edit: This may have been brought up before.. I did a search, but I'm not sure what keywords to use, and the ones I chose came up with nothing. So if there are already threads that may help, please lemme know! Thanks!]