Deleted wrong user

[lasto]

ok by mistake i have deleted a user when it should of been another member.Tiredness makes people do bad things :(

anyway on the board all his posts are now set to guest - is there anyway at all by way of a query or soemthing i can restore his account or is it gone for good.

Also relised its in wrong section as well sorry

[Jolten]

A backup of the db user table and restore his account.

Then you can run an update query to alter the post users to his name, assuming that's the only "Guest" posting.

[lasto]

dont want to restore to a backup m8 as that defeats the problem.If i go to a backup (his account will be fine)but i lose 2 days posts.Guests are not allowed to post on the board and no one is posting as guest as well.
I see his posts and threads still on the board but under his name he is now set to guests.So was hoping was someway of getting his posts threads back under a new ID.
Edit

Misread your post soz

so what tables do i need to backup m8 as i have backups - is it just the usertable i need to restore and if so i can do that but what do i do from there ?

[Jolten]

Restore just his account. Restoring from a backup doesn't mean you have to restore everything. Open the .sql file in a text editor, find the user table and his account and run a query to insert the values. All the code you need will be right there with the user table all you need is the following and run it in the sql query window.


INSERT INTO user VALUES('X', 'X', '', 'X', 'XXXX', 'XXXX', 'XX', ... etc....);

[organik81]

this is my deleted account's information in backup.sql :
INSERT INTO user VALUES('4', '9', '', '0', 'organik81', '11282228e7345f3b2987cdf888ff605a', '2005-01-24', 'organik81@cennetforum.com', '1', '', 'http://www.cennetforum.com/', '', '', '', '1', '<span style=\"color: brown;\">Development</span>', '1', '1106301600', '0', '1110928451', '1110929509', '1110406320', '278', '30', '6', '1', '0', '0', '0', '3543', '07-24-1981', '1981-07-24', '30', '2', '81.213.99.81', '0', '2', 'xorganik81x@hotmail.com', '0', '0', '-1', '26', '0', 'oh8');

I run it in phpMyAdmin ; and this is the result : #1136 - Column count doesn't match value count at row 1 ?????