vb.org Archive - How to find multiple account same email ?

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

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - How to find multiple account same email ? (https://vborg.vbsupport.ru/showthread.php?t=250144)

netcommander

09-08-2010 08:26 AM

How to find multiple account same email ?

Hello
how can I find to multiple accounts using to same email address.
BEst Regards

sulasno

09-08-2010 10:47 AM

I don't have a solution but I can offer a suggestion;

run a query for user and their email addresses

does your board allow mutilpe accounts with the same email addy?

netcommander

09-08-2010 11:02 AM

no we dont allow it but before a few time its open i've see same emails for different user.
what's a query ? do you have test any query ?
best regards

ctweb

09-08-2010 12:01 PM

Firstly,

Settings ? Options ? User Registration Options

Require Unique Email Addresses - Set to YES!

And then, if you want users who have registered with the same email..

Code:

SELECT userid, username, email, count(email) FROM user GROUP BY username HAVING count(email) > 1

Execute that in phpMyAdmin, and you should get your results..

netcommander

09-08-2010 12:30 PM

Hello
thanks for help
i've run this query but it's not find any user ?
Best Regards

ctweb

09-08-2010 12:34 PM

Quote:

Originally Posted by netcommander (Post 2095402)

Hello
thanks for help
i've run this query but it's not find any user ?
Best Regards

Are you sure, try this then..

Code:

SELECT email, COUNT(email) AS Duplicates FROM user GROUP BY email HAVING ( COUNT(email) > 1 )

netcommander

09-08-2010 01:25 PM

Hello
its give a this error message
error desc: Table 'xxxx_xxx.users' doesn't exist.
thanks

sulasno

09-08-2010 03:57 PM

what's your version of vBulletin ?

ACP> Maintenance >Execute SQL Query >Manual Query

select username,email from user;

netcommander

09-08-2010 04:50 PM

my version is 4.06
select username,email from user
its not good for me i've got a lot user they give me 20.000 page :D

akademikper

11-05-2013 07:47 PM

Quote:

Originally Posted by ctweb (Post 2095404)

Are you sure, try this then..

Code:

SELECT email, COUNT(email) AS Duplicates FROM user GROUP BY email HAVING ( COUNT(email) > 1 )

This is worked for me, but i want to delete all multiple mail users. Any solution?

All times are GMT. The time now is 11:06 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01237 seconds Memory Usage 1,726KB 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 (3)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)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: