Create a new account with the old name. Make a note of the new Userid.
Now run the following queries with the correct names and new userid:
[sql]UPDATE post SET userid = <New UserId> WHERE username = 'OLD USERNAME' AND userid = 0;
UPDATE thread SET postuserid = <New UserId> WHERE postusername = 'OLD USERNAME' AND postuserid = 0;[/sql]Not tested, make a backup before running manual queries.
|