Merging 2 Users?

Question

How would one do this? So one user's questions and answers and comments would be added to an other user's list.

Answer 1

You can manually change the userid values in the qa_posts table, then click the various recalculate buttons at the bottom of the 'Stats' section of the admin panel, to make sure all counts are consistent.

Comments

Thanks a lot for this!!! I did it, worked great! I had to edit the 'lastuserid' too, and I had to do it with a MySQL 'Update Set Where' query because there were a lot of posts.
Now I'm gonna test the avatar thing and report back.