Extracting user email info.

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Registered User
Posts: 10
Joined: Tue May 19, 2015 11:51 am

Extracting user email info.

Post by krawfo » Sat Sep 17, 2016 11:34 pm

We would like to extract a list of all users email addresses. Is there a way to do this in vers. 3.0.12?

User avatar
Support Team Member
Support Team Member
Posts: 50510
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

Re: Extracting user email info.

Post by stevemaury » Sun Sep 18, 2016 1:30 am

Run the following SQL ( Executing SQL Queries in phpMyAdmin )

Code: Select all

SELECT username, user_email FROM phpbb_users WHERE user_type <>2
Export the output of the query as CSV.
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)


Return to “[3.0.x] Support Forum”