vb.org Archive - Help with double users

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Help with double users (https://vborg.vbsupport.ru/showthread.php?t=61046)

Chris Gwynne

02-01-2004 04:45 PM

Help with double users

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

02-01-2004 06:22 PM

a-drive,

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

[sql]SELECT COUNT(*) AS dups, userid, username
FROM user
GROUP BY email[/sql]

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

Cheers,
g-force2k2

All times are GMT. The time now is 04:43 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01695 seconds Memory Usage 1,699KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: