how to restore a deleted member ?

[winky8300]

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 (https://vborg.vbsupport.ru/showthread.php?t=236861&page=7) but it is not usable, help please
I do not want to do a restore of the database
thank you

[Dave]

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.

[SaN-DeeP]

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..

[ozzy47]

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:

UPDATE post SET userid='xxx' WHERE username='Old Name';

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

Then update the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[winky8300]

hello

thank you for your answers my friends

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:

Code:

UPDATE post SET userid='xxx' WHERE username='Old Name';

....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 ozzy47


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

[ozzy47]

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.

[winky8300]

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:

[ozzy47]

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

[winky8300]

ok, thank you for your patience

[ozzy47]

Not a problem. :)

[Marv]

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:

UPDATE post SET userid='xxx' WHERE username='Old Name';
....with 'xxx' being the userid of the new account.

Then update the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

Extremly helpful as always, Ozzy. Thanks man :up: