Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: DarkTexas on December 30, 2016, 03:12:15 PM

Title: Exporting E-Mails of the Members
Post by: DarkTexas on December 30, 2016, 03:12:15 PM
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?
Title: Re: Exporting E-Mails of the Members
Post by: vbgamer45 on December 30, 2016, 03:16:15 PM
Check out the smf_memgbers table in phpmyadmin
Then set id_Group to the group number you want
Then choose email_address when exporting.
Title: Re: Exporting E-Mails of the Members
Post by: Kindred on December 30, 2016, 03:19:17 PM
Assuming the group is the primary group for all of those users
Title: Re: Exporting E-Mails of the Members
Post by: DarkTexas on December 30, 2016, 03:22:02 PM
Quote from: vbgamer45 on December 30, 2016, 03:16:15 PM
Then set id_Group to the group number you want

How to do that/Where?
Title: Re: Exporting E-Mails of the Members
Post by: Kindred on December 30, 2016, 03:28:08 PM
in your SQL query...

SELECT email FROM smf_members where id_Group = ##

(change that ## to the group ID)