Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Restore Posts and Threads of Deleted User. (New Version) Details »
Restore Posts and Threads of Deleted User. (New Version)
Mod Version: 1.00, by borbole (Coder/Designer) borbole is offline
Developer Last Online: Oct 2015 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 4.1.x Rating: (7 votes - 4.29 average) Installs: 87
Released: 25 Feb 2010 Last Update: 23 Apr 2012 Downloads: 463
Not Supported DB Changes Uses Plugins Additional Files  

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

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	acp.png
Views:	21
Size:	55.3 KB
ID:	137976   Click image for larger version

Name:	acp2.png
Views:	23
Size:	55.2 KB
ID:	137977  

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
End-User Options Restore A Deleted Member ra7al vBulletin 3.6 Add-ons 30 08 Oct 2012 00:35

  #31  
Old 01 Jul 2010, 23:43
spillage spillage is offline
 
Join Date: Mar 2009
Real name: Bryan
OK, this mod restores/reassigns posts from deleted users to a new user ID.
What if you don't kow the old username?
All the posts from deleted users are attributed to "Guest", but Guest is not a username.
I believe "Guest" is User ID 0 (?)... Can we have a from User ID option?
Reply With Quote
  #32  
Old 02 Jul 2010, 07:53
pant pant is offline
 
Join Date: Mar 2010
I deleted a user by accident about a year ago before we upgraded to 4.0, the user set up his account again and I just gave him a big post count as he was quite active. Will this still work in restoring back his original posts because he is set as guest.
Reply With Quote
  #33  
Old 02 Jul 2010, 11:40
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by spillage View Post
OK, this mod restores/reassigns posts from deleted users to a new user ID.
What if you don't kow the old username?
All the posts from deleted users are attributed to "Guest", but Guest is not a username.
I believe "Guest" is User ID 0 (?)... Can we have a from User ID option?
Yes, the uid option is for the user under whom the deleted posts and threads of the deleted user will go. For the guest part, no uid can be assigned as that covers all the guests. That is why the old username for the deleted user is required. So it affects only that particluar "guest".

Originally Posted by pant View Post
I deleted a user by accident about a year ago before we upgraded to 4.0, the user set up his account again and I just gave him a big post count as he was quite active. Will this still work in restoring back his original posts because he is set as guest.
Yes, it will. Simply follow the instructions at the mod settings and you should be all set.
__________________
My mods.
Reply With Quote
  #34  
Old 02 Jul 2010, 22:00
spillage spillage is offline
 
Join Date: Mar 2009
Real name: Bryan
Originally Posted by borbole View Post
Yes, the uid option is for the user under whom the deleted posts and threads of the deleted user will go. For the guest part, no uid can be assigned as that covers all the guests. That is why the old username for the deleted user is required. So it affects only that particluar "guest".
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?
Reply With Quote
  #35  
Old 02 Jul 2010, 22:11
mimocherry mimocherry is offline
 
Join Date: Jun 2010
I used it before! worked beautifully!
Reply With Quote
  #36  
Old 02 Jul 2010, 22:29
spillage spillage is offline
 
Join Date: Mar 2009
Real name: Bryan
Originally Posted by mimocherry View Post
I used it before! worked beautifully!
I've tried it, and it does work for known deleted usernames... but that is not what my request was for when I was directed here... I want unknown usernames.
Reply With Quote
  #37  
Old 02 Jul 2010, 22:46
pant pant is offline
 
Join Date: Mar 2010
Eh

Is there something wrong with you, how are you meant to restore someone that you don't know?
Reply With Quote
  #38  
Old 02 Jul 2010, 23:11
spillage spillage is offline
 
Join Date: Mar 2009
Real name: Bryan
The original "Username"(s) is/are unknown... all posts are attributed to "Guest", which is not a username... I don't care what the original usernames are, I want all "Guest" posts (at this point) to be associated with a new username.
Reply With Quote
  #39  
Old 02 Jul 2010, 23:25
pant pant is offline
 
Join Date: Mar 2010
oh

Still think you're mental.
Reply With Quote
  #40  
Old 03 Jul 2010, 01:07
spillage spillage is offline
 
Join Date: Mar 2009
Real name: Bryan
Originally Posted by pant View Post
oh

Still think you're mental.
Do you remember the usernames of all the users you deleted 7 years ago?

I thought not.

And my mental state is not the question here... What I'm trying to achieve has always been the question... I was directed to this mod from the vB forums by borbole... it turns out that this mod will not do what I want.

Last edited by spillage; 03 Jul 2010 at 01:16.
Reply With Quote
  #41  
Old 03 Jul 2010, 09:11
pant pant is offline
 
Join Date: Mar 2010
Chill
Reply With Quote
  #42  
Old 03 Jul 2010, 11:32
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by spillage View Post
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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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
__________________
My mods.
Reply With Quote
  #43  
Old 03 Jul 2010, 12:44
spillage spillage is offline
 
Join Date: Mar 2009
Real name: Bryan
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,
Reply With Quote
  #44  
Old 03 Jul 2010, 12:51
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by spillage View Post
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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
__________________
My mods.
Reply With Quote
  #45  
Old 03 Jul 2010, 14:35
pant pant is offline
 
Join Date: Mar 2010
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?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:15.

Layout Options | Width: Wide Color: