How to find list of users from the domain name of their email?

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
User avatar
admirernepali
Registered User
Posts: 17
Joined: Sat Apr 04, 2015 7:04 am

How to find list of users from the domain name of their email?

Post by admirernepali »

I have to clear all my users.

I can see lots of spammers in my user list.

I know the domain of their email "xxx@sina.com"

Is there a way to find all the users from this domain?

I hope there is module.

Or else can I request this feature?

It's hard to got through each users and delete manually.

Please suggest.
Don't be pirate. Stolen software may steal your identity.
http://www.nepaliexpert.com/ | https://au.linkedin.com/pub/adarsh-khatri/53/a33/81
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51456
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to find list of users from the domain name of their email?

Post by stevemaury »

You can run this query - Executing SQL Queries in phpMyAdmin

Code: Select all

SELECT username FROM phpbb_users WHERE user_email LIKE '%sinas.com%';
If your table prefix is not phbb_, change accordingly.

You can export the query result as CSV and open it in Excel.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Lumpy Burgertushie
Registered User
Posts: 67985
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: How to find list of users from the domain name of their email?

Post by Lumpy Burgertushie »

just use the prune users feature in the admin panel.
put *@sina.com in the email box and check the appropriate boxes and click submit. you will get a list of all the users with that email domain and you can choose what to do with them .


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
Locked

Return to “[3.1.x] Support Forum”