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

[pant]

Chill

[borbole]

Originally Posted by spillage

Since the old usernames are unknown, and I want to move all guest posts to a single usermane, it would appear you're now saying this mod will not do the job.

Am I correct?

The old usernames of the deleted users can be seen under their posts they made or you can see them at the database as well. Anyway, to do what you want, to assign posts of all guests to someone, run this query at your phpmyadmin or from Maintenance->Execute SQL Query in your Acp.

UPDATE post 
        SET username = 'posterusername'
        WHERE  userid = 0;

But first make a backup of your posts table. Also, change posterusername with the actual username to whom you want to attribute the posts of all guests and if your db tables have a prefix, include it in the query as well.

Let me know if you want to do the same with threads as well.

P.s. At vb.com you asked how to get back posts of deleted users that appear as guests btw and that is exactly what this mod does. Also, before you download and use a mod, it would be best if first you had a good look at the description

[spillage]

borbole, the query you just provided is exactly what I asked for over at vB.com

If you would be so kind as to provide the thread query also, that would be appreciated.

Thanks for taking the time to help.
Regards,

[borbole]

Originally Posted by spillage

borbole, the query you just provided is exactly what I asked for over at vB.com

If you would be so kind as to provide the thread query also, that would be appreciated.

Thanks for taking the time to help.
Regards,

For the threads use this query:

UPDATE thread 
        SET postusername = 'posterusername'
        WHERE  postuserid = 0;

At vb.com from what I could understand at your post it was that you wanted to achive what my mod does. I am sorry for the misunderstanding. Anyway, the above queries will achive what you want. Hope it helps.

[pant]

Couple more questions sorry.

Say someone has deleted, does that mean all the log information for that person is also gone? I can see that someone has been deleted but going through the admin logs all I get is userid's, how do I compare the userID to name so I can figure out who deleted who?

Is their something else I could be looking for that's easier to look out for?

[spillage]

Originally Posted by borbole

... I am sorry for the misunderstanding. Anyway, the above queries will achive what you want. Hope it helps.

Thank you again for your time... it is appreciated.

[borbole]

Originally Posted by spillage

Thank you again for your time... it is appreciated.

No problem. You are welcome.

[fxwoody]

Loll Borbole! That was an easy one

Tks mate and nominated

[borbole]

Originally Posted by fxwoody

Loll Borbole! That was an easy one

Tks mate and nominated

You are welcome. Glad to see that it came in handy to you

[mattpist]

thanks man, this worked perfectly. much easier than messing around with the database. i just wanted to add a note to everyone though, make sure your new user doesn't have the same user name as your old deleted user or this won't work.

great work, thank you!