Merge user account (dupes)

[Sasq]

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 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=44346) 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

[Dean C]

This is quite a nice little hack...

- miSt

[Herman]

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

* Herman clicks install

[Sasq]

Hope it works as it does here :)

Dan

[Herman]

It works over here, nice work Sasq!

-Shift

[EcpHosting]

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

[Sasq]

I'm glad to hear that its useful :D

[DrkFusion]

Looks neat, I may use it on my gc.

Thanks

[orozery]

Thank you very much! works great!

[fury]

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

[fury]

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

[Sasq]

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

[BetaMax]

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
update forum set lastposter='NewName' where lastposter='OldName'

and

update thread set lastposter='NewName' where lastposter='OldName'

[blacknight]

Worked a treat!

[GaleForce]

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

[WCW Fan]

So all is well for this hack everything works on it

[Smoothie]

Yesterday at 11:33 PM WCW Fan said this in Post #16 (https://vborg.vbsupport.ru/showthread.php?postid=417819#post417819)
So all is well for this hack everything works on it
worked for me.

[ttb]

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?

[Oblivion Knight]

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

Thankyou for sharing!

[firas]

hi

does it work for 2.3???

[xlguy]

Seems to work fine on vB2.3.3

:squareeyed:

[Areku]

Worked like a charm! tu!!