export emailing address

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
jhansle1
Registered User
Posts: 25
Joined: Sun Jul 30, 2006 4:53 pm

export emailing address

Post by jhansle1 »

Hi all,

I was wondering if there is functionality to export all members email address (& names/logins) via the administrative control panel?

I want to do this so if my website is ever "crashed" and I can't access the ACP to mass email my members to notify them of the situation then I can send an email manually since I have their emails.

Thanks
User avatar
Dog Cow
Registered User
Posts: 2500
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: export emailing address

Post by Dog Cow »

Yes, if you use a tool called phpMyAdmin, you can export that data in CSV and other useful formats.
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51893
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: export emailing address

Post by stevemaury »

To amplify, you cannot do it through the ACP, but in phpMyAdmin, run this and export the output as CSV (or Excel if you prefer):

Code: Select all

SELECT `username`, `user_email` FROM phpbb_users WHERE `user_type` != 2;
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)
Locked

Return to “[3.0.x] Support Forum”