Administrative and Maintenance Tools - Restore Posts and Threads of Deleted User. (New Version)

Has it ever happen to you when a user in a moment of angry deletes his/her account and later comes back? Or his/her account was deleted by the evil admin and all his/her posts appear as guests? If it has happen, then this mod is for you.

With this mod you can assign back his/her posts and threads. All the user has to do is to register again, be that with the same username as before or a new one. Then you can reassign back all their posts.

I know that this can be also done with a query at phpmyadmin, but this mod is meant to make it easier for those that are not so tech swavy and are not familiar with phpmyadmin and are afraid of messing things up.

Installation:

To install the mod, upload the admincp and includes folders to your forum root folder maintenaning the structure intact and then import the Restore Posts And Threads.xml file inside the mod package to Plugins&Products in the acp of your forum.

To make use of the mod go to the Maintenance area at your acp, click the drop down list and you will see a new option added called: Restore Deleted User. Click on it and configure it accordinly.

Note: After assigning the posts and/or threads, 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.



If you will need support with this mod, then please post at the mod thread at my forum. Thanks

http://www.forumservices.eu/vb/showt...f-Deleted-User

[borbole]

Originally Posted by steve1966

about 6000

Maybe that is why. When you ran the update counter it increaed the db size. I just tried it with 1000 posts right now and the db size remained intact.

[steve1966]

Can this cause a problem for my forum

[borbole]

Not at all. All it does is run a query that reassigns back the posts of deleted user. Don''t worry.

[steve1966]

Hi ok thanks

[IRANCITY]

greats work

[Manoel J?nior]

Great mod!!

Thx man

[borbole]

Originally Posted by Manoel J?nior

Great mod!!

Thx man

You are welcome. Thank you for your feedbackback/comment and for clicking the install button

The mod has been updated. Now I added the option to restore the threads as well of the deleted user next to the posts.

[borbole]

Originally Posted by IRANCITY

greats work

Did you manage to reassign back the posts of the deleted user that you asked about at your other thread?

[dimthan]

Hi to all , when i install the product and run the script , and i go to see any page of my domain i m getting this ...error



UPDATE post
SET userid = '59274'
WHERE username = '*Apollwnas*';

MySQL Error : Table 'fundb6.post' doesn't exist
Error Number : 1146
Request Date : Sunday, February 28th 2010 @ 05:46:30 PM
Error Date : Sunday, February 28th 2010 @ 05:46:30 PM
Script : http://www........com/forum/showthre...C5%C9%D3/page2
Referrer : http://www......../forum/showthread....C1%D3%C5%C9%D3
IP Address : 193.92.84.24
Username : .....
Classname : vB_Database
MySQL Version : 5.1.43-log


If i disable the merge of users everything is ok .....

il lost the user after a impex of a 3.8.4 db to 4.0.1 db .it was the only user from the 30000 tha he never comes back .
i dont know why...but i have the new and the old database in 3.8.4
Does anyone knows how i ll get back the user ?

[borbole]

From the error you get it seems like the post table is missing.