Help with double users

[Chris Gwynne]

Hey all :)

I need a a script that will show me any users with duplicate email addresses in the database, some of my members cannot login because of this very issue.

It needs to list them as a member search in vB3 would do so I'm able to see it all easily.

Any help is appreciated!

Regards,
Chris

[g-force2k2]

a-drive,

Perhaps this query will show you the users with duplicate emails?

SELECT COUNT(*) AS dups, userid, username
FROM user
GROUP BY email

Also in vb settings you might want to enable the unique email option.

Cheers,
g-force2k2