[Forum] Extract e-mail list from database

[Micke Andersson]

Hi,

I need to extract/generate a list of _all_ my users including username, e-mail address and first name where the user checked "I would like to receive email from the board's admins".

I have had a look into the db, but cannot find the table where first/last names and the checkbox "Admin emails" are.

Could anyone give me a hint, or the sql-query I have to use?

Thanks in advance,

[Ace]

That information should be in the (table_prefix)user table.

[Micke Andersson]

Just realized there are no fields for first and lastname in the database. My mistake... But what is the name of the "Receive email from admins" and its values for yes/no ?

Thanks!

[nakedanvil]

Why not just use the "generate mailing list" function in the AdminCP?

[Micke Andersson]

Why not just use the "generate mailing list" function in the AdminCP?

Does that function ignore users with the "Receive emails from admins" unchecked?

[nakedanvil]

Does that function ignore users with the "Receive emails from admins" unchecked?

Your choice. Has a good filter system. Generates a clean CSV to copy and paste as you wish.

[Micke Andersson]

Your choice. Has a good filter system. Generates a clean CSV to copy and paste as you wish.

Yepp, saw that earlier. The problem is that I've added two custom fields in my board, that I have to include in the e-mail list. So I need a query to fetch all content. However, I cannot find the table where the custom fields and their values are saved. Anyone that knows?

Thanks

[Mr.Tampax]

...