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 » Sat Oct 20, 2018 4:07 pm

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: 68385
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Encrypted user email address fields....

Post by KevC » Sat Oct 20, 2018 4:13 pm

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
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Exabot [Bot], johnnycashy, Lumpy Burgertushie, mainevette, stevemaury and 39 guests