translucent
09-22-2003, 08:32 PM
I imported all user accounts from a previous install into my new site. Some of the users stayed with the board while others chose not to transfer. The users who stayed want to keep their post count cumulative between the two boards. What I'd like to do is set the post count to zero for any member who posted on the previous board but not on the new one. I've tried standard SQL update statements joining the post and user tables only to encounter a syntax error. Do you guys have any ideas?