Email List of Users from a phpBB v 3 forum

[makoto]

howto separate name, email.. for cell???

[Crazygar]

That part I know quite easy, it's accessing the "Custom Fields" database for Profile and separating those whom are opting in for a Newletter (YES = 1) as opposed to those whom are not (NO = 0).

All I wish to do is take those whom are wanting the newsletter to appear on the output.

Gary

[Oyabun1]

[Crazygar]

It seems my current efforts to figure out a method is going to be in vain. I would have assumed that someone on the 'Net and within the realm of phpbb3 would have done something similar in regards to this, but it seems alas, I might be the first to ask for such a creature.

Having limited experience with SQL is there no one that can point me in the right direction to resolve this little bump in the road?

Gary

[RMcGirr83]

[Crazygar]

[RMcGirr83]

What happened when you clicked on the download csv file from the page? You should have gotten another column stating "Newsletter" with the choices shown of whatever the user selected (Yes or No in this case or something like that). You can then use that to sort within excel.

The code I gave you has nothing to do with the display you see when you browse to the PHP file.

[Crazygar]

ROFL, ok, let me check it out, thanks again. Say, where did you get those Smilies?

Gary

[Crazygar]

Trying to export I get this error:

General Error
SQL ERROR [ mysqli ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 432
CALL: dbal->sql_error()

FILE: [ROOT]/list.php
LINE: 45
CALL: dbal->sql_in_set()

[RMcGirr83]

[Crazygar]

[RMcGirr83]

[Crazygar]

Eureka! Thanks Rich!

Gary

[robra_2]

[robra_2]

Since my last message http://www.rmcgirr83.org/viewtopic.php?f=5&t=597&start=60#p18469, the new attached file has:
[img]http://www.suportephpbb.com.br/forum/images/smilies/icon_arrow.gif[/img] English and Brazilian Portuguese language.
[img]http://www.suportephpbb.com.br/forum/images/smilies/icon_arrow.gif[/img] Replacing the text "CSV Export list" of html file to php file language.
[img]http://www.suportephpbb.com.br/forum/images/smilies/icon_arrow.gif[/img] Pagination.
[img]http://www.suportephpbb.com.br/forum/images/smilies/icon_arrow.gif[/img] Export the list to CSV file with each information on table cell of MS-Excel(contribution of murilo_ns user) and with the UTF-8 encoding.

acp_emails_users_list.zip

(15.37 KiB) Downloaded 491 times

The install instructions: http://www.rmcgirr83.org/viewtopic.php?f=5&t=597&start=60#p18451.
The prinstscreen: http://www.rmcgirr83.org/viewtopic.php?f=5&t=597&start=60#p18445.

[ ]. [img]http://www.gsmfans.com.br/Smileys/GSMFans/cool.gif[/img]