News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Exporting E-Mails of the Members

Started by DarkTexas, December 30, 2016, 03:12:15 PM

Previous topic - Next topic

DarkTexas

Greetings,

we'd like to save all E-Mail Addresses of our Member's of ONE Group into a file via phpmyadmin.

How to do that?

vbgamer45

Check out the smf_memgbers table in phpmyadmin
Then set id_Group to the group number you want
Then choose email_address when exporting.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Kindred

Assuming the group is the primary group for all of those users
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

DarkTexas


Kindred

in your SQL query...

SELECT email FROM smf_members where id_Group = ##

(change that ## to the group ID)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: