how to restore user?

[BBF]

hello,
someone find my password and remove some users...
i want to restore the user.

it is possible?

thank you very much.

[Wayne Luke]

You cannot restore a user without restoring a complete database backup. Any information entered into the database since the time of the backup will be lost.

[DelphiVillage]

if you have a backup then yes if not eeeeuh why didn't you make one ?

[BBF]

i'm just need the same id and replace a/n in the post with the new user...
if it possible let me know how to do it...

btw, i do a backup once a week...and i load the backup i lose a lot of information.

[Wayne Luke]

You can create a new user but they would have a new ID. There is no way to reuse an old ID.

[BBF]

maybe i can create a new user and replace the id?

[r3darab.net]

thx

[omar Almukhtar]

i guess there is way to restore deleted users

i warn you that deleting users have posts have negative influence on the database

i'll check the ways how to restore users from the mysql and tell you

[BBF]

i guess there is way to restore deleted users

i warn you that deleting users have posts have negative influence on the database

i'll check the ways how to restore users from the mysql and tell you

ok.
thank you very much!

[omar Almukhtar]

go to phpmyadmin

then click the query buttum

put these queries and change this info to your deleted user info but do not change the password.

in our case the deleted user information described by red color below

username is: MGHOOL user password is: 123456 user id Number is 9

INSERT INTO `user` ( `userid` , `usergroupid` , `membergroupids` , `displaygroupid` , `username` , `password` , `passworddate` , `email` , `styleid` , `parentemail` , `homepage` , `icq` , `aim` , `yahoo` , `showvbcode` , `usertitle` , `customtitle` , `joindate` , `daysprune` , `lastvisit` , `lastactivity` , `lastpost` , `posts` , `reputation` , `reputationlevelid` , `timezoneoffset` , `pmpopup` , `avatarid` , `avatarrevision` , `options` , `birthday` , `birthday_search` , `maxposts` , `startofweek` , `ipaddress` , `referrerid` , `languageid` , `msn` , `emailstamp` , `threadedmode` , `autosubscribe` , `pmtotal` , `pmunread` , `salt` , `profilepicrevision` , `showbirthday` , `skype` , `spmoption` , `spmugroup` ) 
VALUES (
'9', '2', '', '0', 'MGHOOL', '54a77197e6da0c037ef1e7530e3934c7', '2006-04-15', '', '0', '', '', '', '', '', '0', '', '0', '0', '0', '0', '0', '0', '0', '10', '1', '', '0', '0', '0', '15', '', '0000-00-00', '-1', '1', '', '0', '0', '', '0', '0', '-1', '0', '0', '', '0', '2', '', '0', ''
); 

second query making new profile for the deleted user
change the user id Number to your deleted user info

INSERT INTO `userfield` ( `userid` , `temp` , `field1` , `field2` , `field3` , `field4` ) 
VALUES (
'9', '', '', '', '', ''
); 

third step , making the personal information
change the user id Number to your deleted user info

INSERT INTO `usertextfield` ( `userid` , `subfolders` , `pmfolders` , `buddylist` , `ignorelist` , `signature` , `searchprefs` , `rank` ) 
VALUES (
'9', '', '', '', '', '', '', NULL 
); 

untill this step we restored the deleted user without his posts and threads!!


good luck