Chill

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.

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

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:

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.

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?

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

No problem. You are welcome.

Loll Borbole! That was an easy one ;)

Tks mate and nominated :)

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

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.

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.

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.

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.

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/showthre...tra-feature%29

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

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

It works at a 3.8 as well.

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

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?

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.

i sucesfully restored the backup and work well

Is there an answer in our future? :)

This site/forum http://www.forumservices.eu/showthre...tra-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 :)

Now the forum is open again.

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

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?

tag

Down again. :(

I have this issue too - any thoughts?

It is not down but closed.

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/vbservic...tra-feature%29

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

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

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