how to restore a deleted member ?
 

hello
I accidentally deleted a very important member, but his subjects are here , Can someone help me so that his subjects may not be "guest"?
I found this mod but it is not usable, help please
I do not want to do a restore of the database
thank you

You can't restore a deleted user, when you delete a user using the admincp it's physically deleting the user from the database.

However, I believe the username of the user is still present in the post table? Need someone to confirm this to me, if I'm right then your option would be this: create a new user and write down the userid. Execute an UPDATE query in the post table to set the userid of the entries with the new userid where the userid is 0 and the username is the old username.

winky8300,
You want a restore a specific member ID or membername ?

Dave,
I have tried requesting about this in past..
But according to many X developers.. restoring a user id will be problematic as references for same are stored in many places..

But I will wait to hear, if this works..

First take another backup, but make sure not to overwrite your old one.

You can register a new account for that user, then run this query to associate the old posts with the new account:

....with 'xxx' being the userid of the new account.

Then update the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

hello

thank you for your answers my friends

hello ozzy47


I run the query with phpmyadmin? because I do my backup with mysqldumper

phpmyadmin or right in the ACP.

I have never had the need to do this, so make sure everything works, if not, restore your backup.

do not worry:p

when I try to run a sql query via my acp, he says I'm not allowed to do so:erm:

You need to add your userid to the can run queries in the includes/config.php file.

ok, thank you for your patience

Not a problem. :)