[JJR512]

I can tell you how to do this by queries, but I haven't written a hack for it.

There are two queries you need to run if you want to merge two useraccounts into one:

UPDATE post SET userid='xxx',username='yyy' WHERE userid='zzz';

(Where xxx is the NEW userid number, username is the NEW username, and zzz is the OLD userid.)

UPDATE thread SET postusername='xxx',postuserid='yyy' WHERE postuserid='zzz';

(Where xxx is the NEW username, yyy is the NEW userid, and zzz is the OLD userid.)

After you do this, you should update the various counters. Then check both profiles; the older one should show no posts, while the newer one should now show all posts from both accounts. Look for the postcount number as the easy way to tell; obviously, it would be oldaccount+newaccount.

BTW, it's important to keep the single quotes around the values, at least for text values (I don't think it's necessary for numbers). Actually, text values might need full quotes, I forget.