The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Anyway to merge all users which have the same email account?
I recently converted to SimpleMachines to Vbulletin, and during the Impex changeover made sure to associate users by email address. Nevertheless, I'm looking through my vbulletin user list and noticing that many emails can be found on more than one account (as on the SMF forum this was allowed).
Is there any easy method in VBulletin to "consolidate" accounts to ensure that there is only one account associated with each email address? |
#2
|
|||
|
|||
For anyone finding this thread via search, the following SQL command will find all users who have the same email address:
Code:
SELECT username, user.email FROM user INNER JOIN ( SELECT email FROM user GROUP BY email HAVING COUNT( userid ) >1 )dup ON user.email = dup.email |
#3
|
||||
|
||||
A slightly simpler way would be this
[sql] SELECT username, email FROM user GROUP BY email HAVING COUNT(email) > 1 [/sql] |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|