View Full Version : NEED HELP...USER deleted
IRANCITY
02-26-2010, 02:20 PM
hi dear
my user acc deleted i need to restore here user
what am i doing?
i cant restore full site info.... i just need to restore this user ,,,,, it have 10000 post
help me
borbole
02-26-2010, 04:23 PM
hi dear
my user acc deleted i need to restore here user
what am i doing?
i cant restore full site info.... i just need to restore this user ,,,,, it have 10000 post
help me
Have the user to register again and then you can do that with my mod. It is for vb 4 but if you remove the version from depency at the xml file it will work on vb 3X as well.
https://vborg.vbsupport.ru/showthread.php?t=236861
Or you can do it manually by doing the following.
After the user is registered again, go to the phpmyadmin in the cp of your host, select the database name that your forum resides on and at the SQL tab run the following query:
UPDATE post SET userid='newusersid' WHERE username='exusername';
And replace the uid and username accordingly.
Then as last but not least, go to: Admin CP -> Maintenance -> Update Counters and run the Rebuild Thread Information, Rebuild Forum Information, Update User Names, Update Post Counts.
Note, before you run the last option ( Update Post Counts), read the description under the title.
Hope it helps.
IRANCITY
02-26-2010, 05:40 PM
tanx
i install ur product but i cant found it on admincp
my vbulletin ver is 3.8
borbole
02-26-2010, 05:56 PM
You can find the mod settings at: Settings-Options-Message Posting and Editing Options.
But if you will have any more questions related to the mod I think it is best to post them at the mod''s thread better.
Let me know how it will go.
IRANCITY
02-27-2010, 07:26 AM
Greats
Tank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Marco van Herwaarden
02-27-2010, 09:51 AM
Or you can do it manually by doing the following.
After the user is registered again, go to the phpmyadmin in the cp of your host, select the database name that your forum resides on and at the SQL tab run the following query:
UPDATE post SET userid='newusersid' WHERE username='exusername';
And replace the uid and username accordingly.
Then as last but not least, go to: Admin CP -> Maintenance -> Update Counters and run the Rebuild Thread Information, Rebuild Forum Information, Update User Names, Update Post Counts.
Note, before you run the last option ( Update Post Counts), read the description under the title.
Hope it helps.Updating posts is not enough. What about threads? PM's? etc..
The only secure way of doing this would really be to restore the database.
borbole
02-27-2010, 01:54 PM
Updating posts is not enough. What about threads? PM's? etc..
The only secure way of doing this would really be to restore the database.
Yes, that would update only posts as I stated above. But that is the fasted way in my opinon. Because if he would restore a previous backup, then he would loose all the other posts, topics, new members etc that were accuqired after that backup was made. At least that is how I see it. The OP can do as he sees fit :)
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.