Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Sep 2010, 09:26
netcommander netcommander is offline
 
Join Date: Dec 2004
How to find multiple account same email ?

Hello
how can I find to multiple accounts using to same email address.
BEst Regards
Reply With Quote
  #2  
Old 08 Sep 2010, 11:47
sulasno sulasno is offline
 
Join Date: Feb 2010
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?
Reply With Quote
  #3  
Old 08 Sep 2010, 12:02
netcommander netcommander is offline
 
Join Date: Dec 2004
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
Reply With Quote
  #4  
Old 08 Sep 2010, 13:01
ctweb's Avatar
ctweb ctweb is offline
 
Join Date: Apr 2006
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..


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Execute that in phpMyAdmin, and you should get your results..
__________________
vBulletin Designing / Coding Services - C3 - meetc3.com
Reply With Quote
  #5  
Old 08 Sep 2010, 13:30
netcommander netcommander is offline
 
Join Date: Dec 2004
Hello
thanks for help
i've run this query but it's not find any user ?
Best Regards
Reply With Quote
  #6  
Old 08 Sep 2010, 13:34
ctweb's Avatar
ctweb ctweb is offline
 
Join Date: Apr 2006
Originally Posted by netcommander View Post
Hello
thanks for help
i've run this query but it's not find any user ?
Best Regards
Are you sure, try this then..


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
vBulletin Designing / Coding Services - C3 - meetc3.com
Reply With Quote
  #7  
Old 08 Sep 2010, 14:25
netcommander netcommander is offline
 
Join Date: Dec 2004
Hello
its give a this error message
error desc: Table 'xxxx_xxx.users' doesn't exist.
thanks
Reply With Quote
  #8  
Old 08 Sep 2010, 16:57
sulasno sulasno is offline
 
Join Date: Feb 2010
what's your version of vBulletin ?

ACP> Maintenance >Execute SQL Query >Manual Query

select username,email from user;
Reply With Quote
  #9  
Old 08 Sep 2010, 17:50
netcommander netcommander is offline
 
Join Date: Dec 2004
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
Reply With Quote
  #10  
Old 05 Nov 2013, 19:47
akademikper akademikper is offline
 
Join Date: Aug 2011
Originally Posted by ctweb View Post
Are you sure, try this then..


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
This is worked for me, but i want to delete all multiple mail users. Any solution?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:33.

Layout Options | Width: Wide Color: