The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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.. |
#4
|
||||
|
||||
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'; Then update the thread and forum counters in that order: Admin CP -> Maintenance -> Update Counters |
2 благодарности(ей) от: | ||
Kane@airrifle, Marv |
#5
|
|||
|
|||
hello
thank you for your answers my friends Quote:
I run the query with phpmyadmin? because I do my backup with mysqldumper |
#6
|
||||
|
||||
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. |
#7
|
|||
|
|||
Quote:
when I try to run a sql query via my acp, he says I'm not allowed to do so:erm: |
#8
|
||||
|
||||
You need to add your userid to the can run queries in the includes/config.php file.
|
#9
|
|||
|
|||
ok, thank you for your patience
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|