Encrypted user email address fields....

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
kimtieuphuong
Registered User
Posts: 1
Joined: Sat Oct 20, 2018 4:06 pm

Encrypted user email address fields....

Post by kimtieuphuong »

Hi All,
Already know the answer but no harm asking anyway!

I'd like to export all the user email addresses so I can plug them into MailChimp or equivalent but they're all encrypted. Just wondering is there
anyway of exporting them in ascii text format?

Thanks
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72329
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Encrypted user email address fields....

Post by KevC »

The email addresses are not encrypted at all.

You can export them from the database with this query (change the prefix if yours is different)

Code: Select all

SELECT user_email FROM phpbb_users WHERE user_type <> 2
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
Post Reply

Return to “[3.2.x] Support Forum”