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

woot first!

NICE ONE! ...or can you please create too the same mod as to transfer thread/post to another users...meaning

Change Threads/Posts Owner

LIKE THIS ONE!

well gonna try this might useful or need it later.....

thanks and best regards

:p:up:

thanks will use that now hope it works ?

edit yes it worked for me voted nominated

Thanks for marking it as installed.

That seems like it will require some work and I don''t have so much free time now to spend into creating bigger mods.

It will work. I have tested it thoroughly multiple times before submitting it.

Be careful when you install this script
my DB was 300 MB
now it increased to 900 MB

The support of my hosting are trying to help me and nothing worked.
For some reason this script increased the DB
My site is slow now.

Suddenly need a lot of RAM

How many posts were restored when you used this mod? The mod itself doesn''t affect the db in that way. It simply runs the query needed to assign back the posts of the deleted user.

looks like the same problem for me my db has increased

How many posts were restored when you used this mod?

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.

Can this cause a problem for my forum

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

Hi ok thanks

greats work

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.

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

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 ?

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

The mod is updated again. For more info please have a look at the very first post and the attached screenshot.

This mod looks REALLY good, is there anyway I can use it for 3.8.. that is all I have?

technically how is this possible? could you please explain?

Try to remove the version at <dependencies> and give it a go. But test it first at your test forum.

Hi, Unfortunately this mod has damaged my DB :( :( :(

I am getting this errror:

It is not possible. This mod has been tested thoroughly numerous times and it doesn''t cause any damage what so ever.

That said, the error that you are having is because of a missing table. (helpfulpost) Can I see a screenshot of your db tables in your phpmyadmin?

Yes I created that table and it's columns and it worked - so it might have been other things - but quite weird it comes after installation of this mod :(

But certainly nothing to do wiht that hack... working fine :)

You still don't appear to have table_prefix in your queries in the latest version.

I had forgotten to include in the query the possibility of other db prefixes. But now I did. Thank you very much for bringing it to my attention :)

Updated.

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?

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, 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".

Yes, it will. Simply follow the instructions at the mod settings and you should be all set.

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?

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.

Eh

Is there something wrong with you, how are you meant to restore someone that you don't know?

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.

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.