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.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Registered User
Posts: 12
Joined: Tue May 19, 2015 11:51 am

Extracting user email info.

Post by krawfo »

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: 51674
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

Re: Extracting user email info.

Post by stevemaury »

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”