View Full Version : Administrative and Maintenance Tools - Restore Posts and Threads of Deleted User.
borbole
05-09-2010, 10:00 PM
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 includes folder to your forum root folder and then import the Restore Posts And Threads.xml file inside the mod package to Plugins&Products in the acp of your forum. Then go to the mod setting option: Restore Deleted User. It can be found on the left side of the Admin Panel, right above the Maintenace section. And enter the information accordingly.
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.
laztrix
05-17-2010, 12:23 AM
I was just looking for something like that and tested it so far so good.
Great job.
borbole
05-17-2010, 10:39 AM
Thank you for your feedback :)
Dj Smuggla
06-01-2010, 01:36 PM
Thanks m8, this looks like a great mod...
Installed
funmasti
06-02-2010, 05:20 AM
its a great mod. now we can tens- free while deleting any thread
borbole
06-02-2010, 01:50 PM
Glad that you guys like it :)
Peter_AUS
06-05-2010, 05:56 AM
Thanks have wanted something like this for a while, and now will be able to test it out as well. Will report back any issues.
Floris
06-05-2010, 06:03 AM
its a great mod. now we can tens- free while deleting any thread
You can not "delete" a user when deleting a thread/post. It's a separate function from the admincp to prune an account.
Sweeks
06-08-2010, 01:22 PM
Is it 100% necessary to run the last option, if you dont would that mean the reassigned user wont have a post count for all their posts? If so, couldnt we just view all posts by the user and stick in their post count from there?
Thanks.
borbole
06-08-2010, 02:34 PM
I guess you can do it like that as well by entering the post count manually at their profile when editing the user in your Acp.
Sweeks
06-08-2010, 03:13 PM
Thank you Borbole, is it expected to cause high server loads when assigning them back? :) I mean with users with around 3k posts.
Sweeks
06-08-2010, 03:56 PM
Tried this on a user with over 3k posts and the server had very high loads and eventually I had to just suspend the account and unsuspend it and then disable the product to stop the query. It doesnt appear to have affected the users posts at all though after updating the ones mentioned other but without running the last one, I dont think it was assigning them successfully. I will have to try on a much smaller post count to verify.
Sweeks
06-08-2010, 04:04 PM
Okay, I have tried on a deleted user that had only two posts, the query sends the server wild no matter how many posts needing reassigned and it doesnt appear to work at all and this is after testing using all instructions including the post counts update. Hope this can be fixed as its nice and simple to use :)
borbole
06-08-2010, 04:19 PM
I haven''t reproduced this when I have tested/uses the mod. It has worked fine. I can'' t fix something that I can''t reproduce.
Sweeks
06-08-2010, 05:23 PM
True, can anyone else confirm the same issues I am having? Are all of the files within the zip? I would love for this to work for me. On the smaller post count deleted user I tried again without the server issue but it isnt reassigning the posts at all.
Sweeks
06-08-2010, 05:37 PM
Oh now I know why it was messing up, just done a search here and found someone else doing the same as me. I had been using the usernames in both damn fields, I can confirm it works a treat :)
There is 1 bug that I now know of, if the new user has 0 posts they do not assign and will only assign once they have made one post.
borbole
06-08-2010, 06:40 PM
Oh now I know why it was messing up, just done a search here and found someone else doing the same as me. I had been using the usernames in both damn fields, I can confirm it works a treat :)
There is 1 bug that I now know of, if the new user has 0 posts they do not assign and will only assign once they have made one post.
Glad to hear that you got it sorted out.
About that bug, it is not a bug. If the deelted user has 0 post then there is nothing to re-assign. Or did you mean the newly registered user? It works even if it has no posts at all.
Sweeks
06-08-2010, 07:40 PM
It seems to only work for me if the new user has at least 1 post, ive tried it on the same two boards and it seems to be a pattern for me, aside from that slight issue though I am content with it :)
Naan-Kadavul
06-08-2010, 09:37 PM
One doubt..
Will it restore the attachments (torrents) in the thread ?
Or just threads & posts only ?
Sweeks
06-19-2010, 07:00 PM
Threads and posts only with this mod.
Black Tiger
09-26-2010, 02:32 PM
I was looking for something like this already, thank you very much!
borbole
09-26-2010, 02:47 PM
I was looking for something like this already, thank you very much!
You are welcome :)
KrisP
09-28-2010, 09:06 PM
After I restored a user with 1000 posts (which took 5 sec), mysql is running 120% and server is brought down to its knees. Restarting mysql didnt help, any ideas?
Eduardo Leon
10-04-2010, 05:08 PM
hey !
ths look a great hack ..
downloaded and installed ..
thnx (y)
Nelson58
10-08-2012, 03:48 PM
Someone please make this for VB 4.2PL.
Thanks!
Nelson
btedition
01-06-2014, 05:14 AM
Is it supporting 4.2.0 ?
New Joe
04-15-2014, 04:09 PM
Would this work on vB 4?
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.