Merge user account (dupes)
 

I am not offering support for this hack

This is a quick little script to be installed only into your admin dir (and best removed when its not needed)

most of the info came from this thread thanks to nightrider72 .

install and use instructions are ...

install into your admin dir,
to use it...
make sure your logged in....
you will need the user id of both accounts, the primary account is the one you wish to keep.

the secondary id number is the account that you wish to make go away....

submit, it will check the db for the user names and display both names and id, if yes, click, if its wrong back out of there.

when you click yes, it updates the posts, threads, pm's subscribed forums etc... it also updates the post count for both users... (ie the primary user inherets all of the posts, and the secondary user should have nothing)

there is very little error checking in this script, and use at your own risk.

It is working fine here - even if it is a little brutal, but saves the need to shell in and access the db that way (or use phpmyadmin)

AGAIN, USE THIS AT YOUR OWN RISK

This is quite a nice little hack...

- miSt

Indeed it is, I think I'll beta test it for you. :)

[high]* Herman clicks install[/high]

Hope it works as it does here :)

Dan

It works over here, nice work Sasq!

-Shift

Excellent hack! We had the old nasty phpBB and upgraded to a VB and accidently created a dupe user (admin). Erg. BUT THIS HACK SOLVED IT! Thank you kindly. :D

I'm glad to hear that its useful :D

Looks neat, I may use it on my gc.

Thanks

Thank you very much! works great!

Nice idea! I'll take a look at it tomorrow.

It's something I've been considering doing myself for a while, thanks for doing the work :D

Merged a couple of small user accounts together, appeared to be a success, so *clicks install* :D

If I get in the mood today I may modify it to be able to search for username or email and add a quick link to delete the secondary user after the merge

Danke :D

Yeah I thought about adding the ability to search for user id by user name, but 1) I was too lazy 2) in my case we only have/had about 5 users to merge so it wasn't worth my grief.

I'm interested in seeing what you come up with if you get in the mood.

now onto my next hack, something you all would really like ;)

How about adding 2 more replace querys, such as changing the lastposter info if any of the old account to the new account on the main forum display and in the thread listing.

Although, it is required to have the actual username and not the userid.

ie, adding the following 2 sql commands
and

Worked a treat!

Nice tool, will definitely use it when I need it :)

So all is well for this hack everything works on it

worked for me.

Can this recover posts from a deleted account? Like if someone deletes their account, and creates another one, all of the old posts that stayed behind from the previous, can they be merged?

Excellent little script you have here.. :)
Worked perfectly with no problems (or at least none that are apparant).

Thankyou for sharing!

hi

does it work for 2.3???

Seems to work fine on vB2.3.3

:squareeyed:

Worked like a charm! tu!!