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.
Suggested Hosts
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 "[email protected]"

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: 52767
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.
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: 69223
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
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Locked

Return to “[3.1.x] Support Forum”