Restore Posts and Threads of Deleted User. (New Version)

[borbole]

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/showthread.php?9-Restore-Posts-and-Threads-of-Deleted-User

[NiTRoN]

woot first!

[princeedward]

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! (https://vborg.vbsupport.ru/showthread.php?t=200952)

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

thanks and best regards

:p:up:

[steve1966]

thanks will use that now hope it works ?

edit yes it worked for me voted nominated

[borbole]

woot first!

Thanks for marking it as installed.

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! (https://vborg.vbsupport.ru/showthread.php?t=200952)

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

thanks and best regards

:p:up:

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

thanks will use that now hope it works ?

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

[samiro]

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

[borbole]

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.

[steve1966]

looks like the same problem for me my db has increased

[borbole]

looks like the same problem for me my db has increased


How many posts were restored when you used this mod?

[steve1966]

How many posts were restored when you used this mod?
about 6000

[borbole]

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]

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]

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/showthread.php?828-%E8%C5%CB%D9-%D0%D1%CF%D4%C1%D3%C5%C9%D3/page2
Referrer : http://www......../forum/showthread.php?828-%E8%C5%CB%D9-%D0%D1%CF%D4%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.

[borbole]

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

[Mrquarter2]

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

[alessai]

technically how is this possible? could you please explain?

[borbole]

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

[SpaceStar]

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

I am getting this errror:

[borbole]

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?

[SpaceStar]

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 :)

[kall]

From the error you get it seems like the post table is missing.
You still don't appear to have table_prefix in your queries in the latest version.

[borbole]

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 :)

[borbole]

Updated.

[spillage]

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?

[pant]

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.

[borbole]

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

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.

[spillage]

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?

[mimocherry]

I used it before! worked beautifully!

[spillage]

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.

[pant]

Eh

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

[spillage]

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.

[pant]

oh

Still think you're mental.

[spillage]

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.

[pant]

Chill

[borbole]

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]

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]

... 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]

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]

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!

[borbole]

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!

You are welcome.

[Lovinmysailor]

Im just trying to see if I understand this right. After every name we add posts to we have to run the updates?

[borbole]

Im just trying to see if I understand this right. After every name we add posts to we have to run the updates?

Did you mean the Update Counters option? If so, then yes.

[Bob_R]

One quick question before I use this.

The instructions and a early post (post #33) say to use the same or different name of the deleted user.

A late post (post #50) in this thread says to use a different username.

Well, which one is it?

Thanks!

[borbole]

One quick question before I use this.

The instructions and a early post (post #33) say to use the same or different name of the deleted user.

A late post (post #50) in this thread says to use a different username.

Well, which one is it?

Thanks!

You can use whatever you want, either re-register the user with the same name or a different one.

[Bob_R]

OK, I did everything. But, the user shows zero posts. :confused:

[borbole]

OK, I did everything. But, the user shows zero posts. :confused:

After you ran it, did you update the counters as well as mentioned in bold at the bottom of the first post here?

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.

[Bob_R]

After you ran it, did you update the counters as well as mentioned in bold at the bottom of the first post here?

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.

Yes.

I put the xml file from the includes/xml file into the forum root already existing includes/xml directory.

Imported the other xml.

Filled in both screens to restore posts and threads. Answered Yes. Put in new userid. Put in deleted username (which is the sanme as the new username)

And, then did the steps you mentioned above.

[borbole]

Yes.

I put the xml file from the includes/xml file into the forum root already existing includes/xml directory.

Imported the other xml.

Filled in both screens to restore posts and threads. Answered Yes. Put in new userid. Put in deleted username (which is the sanme as the new username)

And, then did the steps you mentioned above.

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

http://www.forumservices.eu/showthread.php?64-Restore-Posts-and-Threads-of-Deleted-User.-%28Added-extra-feature%29

I support all my mods there. As here I rarely check them after submitting them.

[cirdok2]

This mod looks REALLY good, is there anyway I can use it for 3.8.. that is all I have?
did you manage to use it on 3.8?
Thanks :)

[borbole]

did you manage to use it on 3.8?
Thanks :)

It works at a 3.8 as well.

[guitartrash88]

I tried using his mod to associate old posts from a guest to a new user and it didn't work, can you give me a step by step on how I can get this to work?

[borbole]

I tried using his mod to associate old posts from a guest to a new user and it didn't work, can you give me a step by step on how I can get this to work?

Please read the instructions at the first post about that :)

[Bob_R]

How about a user that was banned and his posts deleted but the account was not deleted?

Can this mod be used to get the posts and thread back?

And, if not, is there a way to get back the posts and threads?

[nando.dominios]

Please help me, i use your hack to restore a deleted user in other acount (it have 2 post), but now have a very very slow mysql process, it have a 100% cpu load, this is the exact querry (identify with username):

| 653 | ******* | localhost | ******* | Query | 0 | Updating | UPDATE vb_post
SET userid = '******'
WHERE username = '*****' <-- This is the user and i have this querry alwais

I have a backup copy but now is 2 days old.

[nando.dominios]

i sucesfully restored the backup and work well

[Bob_R]

How about a user that was banned and his posts deleted but the account was not deleted?

Can this mod be used to get the posts and thread back?

And, if not, is there a way to get back the posts and threads?

Is there an answer in our future? :)

This site/forum http://www.forumservices.eu/showthread.php?64-Restore-Posts-and-Threads-of-Deleted-User.-%28Added-extra-feature%29 for questions about this hack doesn't even exist anymore.

[borbole]

Is there an answer in our future? :)

This site/forum http://www.forumservices.eu/showthread.php?64-Restore-Posts-and-Threads-of-Deleted-User.-%28Added-extra-feature%29 for questions about this hack doesn't even exist anymore.

At the moment I am very busy and don't have much free time. Thank you for your patience and understanding :)

[borbole]

Is there an answer in our future? :)

This site/forum http://www.forumservices.eu/showthread.php?64-Restore-Posts-and-Threads-of-Deleted-User.-%28Added-extra-feature%29 for questions about this hack doesn't even exist anymore.

Now the forum is open again.

[TheLastSuperman]

Just had someone ask me about this, I referred them here and not sure if they will Mark as Installed so I will ;).

TY Borbole, yet another useful contribution to the community imo! :cool:

[borbole]

Just had someone ask me about this, I referred them here and not sure if they will Mark as Installed so I will ;).

TY Borbole, yet another useful contribution to the community imo! :cool:

Thanks TheLastSuperman :)

[Stefan118]

Downloaded, installed en installed clicked.!

It works nearly perfect...
But.
When I assign the posts from the deleted user to the new user, the posts cannot be found by searching all posts of user .....

Second: the post count of the new user is not increasing.
Maybe this is also the reason why the posts can't be found?

I manualy have increased the post counter of the new user, but still no posts found.
I also updated the post counts on the admincp.

Is there a solution?

[JDT]

tag

[Bob_R]

Now the forum is open again.

Down again. :(

[lurch_cr]

Downloaded, installed en installed clicked.!

It works nearly perfect...
But.
When I assign the posts from the deleted user to the new user, the posts cannot be found by searching all posts of user .....


I have this issue too - any thoughts?

[borbole]

Down again. :(

It is not down but closed.

[borbole]

I have this issue too - any thoughts?

Down again. :(

Downloaded, installed en installed clicked.!

It works nearly perfect...
But.
When I assign the posts from the deleted user to the new user, the posts cannot be found by searching all posts of user .....

Second: the post count of the new user is not increasing.
Maybe this is also the reason why the posts can't be found?

I manualy have increased the post counter of the new user, but still no posts found.
I also updated the post counts on the admincp.

Is there a solution?


If you guys still need support with this then please post at its thread at my forum as I support my mods only there.

http://www.forumservices.eu/vbservices/showthread.php?64-Restore-Posts-and-Threads-of-Deleted-User.-%28Added-extra-feature%29

[fevredsuk]

When I assign the posts from the deleted user to the new user, the posts cannot be found by searching all posts of user
I get the same, you can do an advanced search for the members posts and it lists them all, and all posts seem to be assigned to that member, but members dont do advanced searches they click view all posts in the members profile. how do we sort this

[archet1337]

Just installed this on my 4.1.4 board without any problems at all. Awesome mod!

Did not experience any of the problems mentioned above. The restored user's posts show up on search with the name of the deleted one. Post count is working as it should as well.

Thanks for sharing. This will save me a ton of time :)

[Successfulsteps]

Awesome! Installed on 4.1.4 Needed this due a previous crazy admin!

[mavherzog]

Interesting behavior I observed with this tool.

Installed and it worked as advertised...but post-installation, threads loaded ridiculously slow. In fact, it effectively shutdown the site. I have no idea why, but when I removed the product, this was resolved.

I can recreate this issue at will. Has anyone else seen this?

[MediaHound]

Do not leave this mod installed, it will cripple your site.
It constantly runs queries to set userids against usernames as has been mentioned already on the thread.
This mod needs to be removed from here.

[borbole]

Do not leave this mod installed, it will cripple your site.
It constantly runs queries to set userids against usernames as has been mentioned already on the thread.
This mod needs to be removed from here.

I do not know how your eyesight is pal, but before you download and use a mod, read the description first. It says right there with bolded and capital text as well:

Then after you are done restoring the deleted user/s, DISABLE it.

It can''t be clearer than that.

[Videx]

Then after you are done restoring the deleted user/s, DISABLE it.Ouch! I saw that, but wasn't sure why you would want to disable a user after you just restored it. It didn't matter to me since I didn't actually need to restore anyone at the time.

So I vote YES it can definitely be made clearer. e.g. A line at the beginning of the installation instructions: "This mod should normally be disabled. Only enable it long enough to restore a member." Then at the end another line: "Now disable the mod and only enable it long enough to restore a member."

[MediaHound]

lol @ editing the knee-jerk reaction post:
"I will be blunt here. I do not know how your eyesight is pal, but before you download and use a mod, read the description first before throwing tantrums like a drama queen. It says right there with bolded and capital text as well: *Then after you are done, DISABLE it. *
"
You might want to clarify your instructions and explain to people why they should disable it. Like Videx said I am not the only one and there are plenty of other people who have complained in the thread.
I'm personally throwing a tantrum because your horrible modification left my board sucking resources for quite some time before I narrowed it down to you. You should go as far as to putting a warning into the header, visible to admins, that the mod needs to be disabled, and a link to easily do that. I stand by my position that this modification should be pulled from vbulletin.org until you patch it.

You also wrote:
"I do not know how your eyesight is pal, but before you download and use a mod, read the description first. It says right there with bolded and capital text as well:

Then after you are done restoring the deleted user/s, DISABLE it.

It can''t be clearer than that."

Of course it can be made clearer. Stop clowning around.

[lovevn]

Does anyone use this mod with vbulletin 4.1 ? I installed and tried to restore the threads and posts it said everything ok but after update counter the new user's post& thread is still 0 post.

[zelnik]

Hi borbole,

I'm hoping you can help me, I've installed this on my test site running 4.1.10 or whatever the new version is :)

I can restore old posts/threads to a new users, that seems to work.

However when I get their user info profile and search for threads and posts by that user nothing comes up?

I've reset all the counters as described.

PS: I should say the post count display on the postbit seems to be correct for the user, but nothing when you search for new posts or threads

[steveinid]

I installed and ran this. It worked, but I had to go and delete all users entries in the blog portion of the cms. When I went to the blogs it gave me a fatal error. I went in phpmyadmin and saw that the users old userid was still assigned to the blog entry. I changed the old id to the new id. That didn't work... still got a fatal error. I deleted the blog entries for the user and all is back to normal... I HOPE.

[14DH01]

mod very best
i love you :D:D

[Altari]

Don't use this mod on a big forum.
Mine is about 1 000 000 posts and there was 300 online users : i enabled it and forums came out of control, with only server errors because this mod execute an ugly sql request each time postbit_display_complete is called --> SQL crash alone, can't disable it.

[yamahapaul]

This works on 3.8.5 :)

[doraj]

Hello,

the Mod works also with vB 4.1.9?

Thank you,
Regards

[Skyrider]

:-\ I uninstalled this. Attempting to recover a user crashed the entire database. uninstalling (disabling all plugins) fixed the issue.

[RRCamellini]

someone already tested in version 4.1.11?

[Skyrider]

someone already tested in version 4.1.11?
Last time when I tried, it crashed the entire database. I was forced to disable/uninstall to prevent further huge database loads.

[Stefan118]

If you guys still need support with this then please post at its thread at my forum as I support my mods only there.

http://www.forumservices.eu/vbservices/showthread.php?64-Restore-Posts-and-Threads-of-Deleted-User.-%28Added-extra-feature%29

Would be nice though if this link was working.
Searched the forum manualy, but i cant find the mod at all!

[New Joe]

Would be nice though if this link was working.
Searched the forum manualy, but i cant find the mod at all!

This is his Forum: http://www.forumservices.eu/

He no longer supports or uses vb, he's been converted to the xenforo software;).

[borbole]

The mod is updated. All the issues are fixed. Now the queries do not run at the postbit hook anymore. For more info, please check the new screenshot and info added at the OP.

[Hippy]

sounds interesting ..
I might give this show..

thanks

[borbole]

Would be nice though if this link was working.
Searched the forum manualy, but i cant find the mod at all!

Now the mod is fully supported at my forum:

http://www.forumservices.eu/vb/showthread.php?9-Restore-Posts-and-Threads-of-Deleted-User

[fragov]

I suggest to delete or turn off this mod right after use. It runs each second "UPDATE" command in MySQL for last restored user!