NEED HELP...USER deleted

[IRANCITY]

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]

Originally Posted by IRANCITY

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]

tanx
i install ur product but i cant found it on admincp
my vbulletin ver is 3.8

[borbole]

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]

Greats
Tank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

[Marco van Herwaarden]

Originally Posted by borbole

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]

Originally Posted by Marco van Herwaarden

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