Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Merge user account (dupes) Details »
Merge user account (dupes)
Mod Version: 1.00, by Sasq (Member) Sasq is offline
Developer Last Online: Jun 2013 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 18
Released: 21 Dec 2002 Last Update: Never Downloads: 7
Not Supported Is in Beta Stage  

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

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 21 Dec 2002, 17:46
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
This is quite a nice little hack...

- miSt
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #3  
Old 21 Dec 2002, 23:18
Herman Herman is offline
 
Join Date: Apr 2002
Indeed it is, I think I'll beta test it for you.

/me clicks install

Last edited by Herman; 21 Dec 2002 at 23:22.
Reply With Quote
  #4  
Old 22 Dec 2002, 03:20
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Hope it works as it does here

Dan
Reply With Quote
  #5  
Old 22 Dec 2002, 14:49
Herman Herman is offline
 
Join Date: Apr 2002
It works over here, nice work Sasq!

-Shift
Reply With Quote
  #6  
Old 22 Dec 2002, 19:16
EcpHosting's Avatar
EcpHosting EcpHosting is offline
 
Join Date: Dec 2002
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.
__________________
Regards, Erik Herrera
Ecp Hosting Operations Manager
Reply With Quote
  #7  
Old 23 Dec 2002, 00:22
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
I'm glad to hear that its useful
Reply With Quote
  #8  
Old 23 Dec 2002, 03:08
DrkFusion's Avatar
DrkFusion DrkFusion is offline
 
Join Date: Nov 2001
Looks neat, I may use it on my gc.

Thanks
__________________
ZunePoint.com
Reply With Quote
  #9  
Old 26 Dec 2002, 10:30
orozery's Avatar
orozery orozery is offline
 
Join Date: Nov 2001
Thank you very much! works great!
Reply With Quote
  #10  
Old 29 Dec 2002, 06:46
fury's Avatar
fury fury is offline
 
Join Date: Oct 2001
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
__________________
Rise of Tyrants... it won't cook your breakfast, but you'll wonder how you ever lived without it
Reply With Quote
  #11  
Old 29 Dec 2002, 13:40
fury's Avatar
fury fury is offline
 
Join Date: Oct 2001
Merged a couple of small user accounts together, appeared to be a success, so *clicks install*

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
__________________
Rise of Tyrants... it won't cook your breakfast, but you'll wonder how you ever lived without it
Reply With Quote
  #12  
Old 29 Dec 2002, 13:53
Sasq's Avatar
Sasq Sasq is offline
 
Join Date: Mar 2002
Danke

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
Reply With Quote
  #13  
Old 30 Dec 2002, 19:23
BetaMax BetaMax is offline
 
Join Date: Sep 2002
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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #14  
Old 01 May 2003, 02:11
blacknight blacknight is offline
 
Join Date: Jun 2002
Worked a treat!
Reply With Quote
  #15  
Old 01 May 2003, 02:16
GaleForce GaleForce is offline
 
Join Date: Sep 2002
Nice tool, will definitely use it when I need it
__________________
GaleForce
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 00:29.

Layout Options | Width: Wide Color: