Merge Members
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26768
Printed Date: 03 April 2026 at 12:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Merge Members
Posted By: MortiOli
Subject: Merge Members
Date Posted: 02 January 2009 at 10:55am
|
Bruce, is there a piece of SQL query that I can run, to merge one member into another? We have a member who created a second account, for some reason, and now wants to merge the second into the first. Any help / info would be great! Cheers, Oli
|
Replies:
Posted By: MadDog
Date Posted: 03 January 2009 at 12:01am
|
You would have to just change Author_ID in all the tables like tblThread, tblPrivateMessage, and maybe a few more.. cant remember off the top of my head.
------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: diaperpin-jen
Date Posted: 03 January 2009 at 10:29pm
|
tblTopics too?
You'd also want to combine # of posts etc.
Personally - I don't let members merge accounts....but my forum is huge so if we did it once we'd have to do it for everyone who asks!
|