Heya,

I've recently migrated my site from PHPNuke to XOOPS and spent some time writing hideous sql to migrate our forum across (ok, its not perfect, but it keeps all the history etc.)

Now I'd like to sync up the post counts for all the users. I'm aware of the Sync button in Edit User, but I don't really relish the idea of doing this for >300 users.

Any way I can automate this or is there some sort of sync-all that I've missed?

cheers!

is there a MySQL command to sync all users?
thats so hard to sync users one by one

and in this site i see users with <1100 posts but not display in top posters block. how this happened???

I did find code to sync all the users - but:
1) there is no place to call it from

and 2) when I worked out a GET url to call the code snippet it didn't work - just syncing uid 1.

I spent some time hacking it about, got it working and then put the old version back. Can't remember what I did. Sorry!