Merging two user accounts?

[Surgical Aplomb]

Hello everyone,

I'm currently trying to merge two of my forum's user accounts with each other. One is a deleted member and the other isn't. I'm currently on SMF version 1.1.13.

My plan is to merge the two accounts together so that the posts from the deleted account will become the posts of the active account. I ran this query in PhpMyadmin:

UPDATE smf_messages SET ID_MEMBER = 'ID', posterName = 'NAME' WHERE posterName = 'NAME';

But rather than merging the two accounts into one, it has changed the deleted account's username to the active one's name but has remained deleted.

Does anyone know how I can merge them into one account?

Thanks.

[JimM]

This topic should help you:

http://www.simplemachines.org/community/index.php?topic=212588.0