Page 7 of 11
Re: Email List of Users from a phpBB v 3 forum
Posted: 13 Mar 2013, 18:36
by makoto
howto separate name, email.. for cell???
Re: Email List of Users from a phpBB v 3 forum
Posted: 13 Mar 2013, 19:07
by 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
Re: Email List of Users from a phpBB v 3 forum
Posted: 13 Mar 2013, 20:56
by Oyabun1
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 17:14
by 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
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 17:35
by RMcGirr83
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 18:37
by Crazygar
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 18:42
by 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.
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 18:43
by Crazygar
ROFL, ok, let me check it out, thanks again. Say, where did you get those Smilies?
Gary
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 18:44
by 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()
Re: Email List of Users from a phpBB v 3 forum
Posted: 15 Mar 2013, 18:50
by RMcGirr83
Re: Email List of Users from a phpBB v 3 forum
Posted: 16 Mar 2013, 04:11
by Crazygar
Re: Email List of Users from a phpBB v 3 forum
Posted: 16 Mar 2013, 09:26
by RMcGirr83
Re: Email List of Users from a phpBB v 3 forum
Posted: 16 Mar 2013, 14:11
by Crazygar
Eureka! Thanks Rich!
Gary
Re: Email List of Users from a phpBB v 3 forum
Posted: 28 Mar 2013, 21:35
by robra_2
Re: Email List of Users from a phpBB - in ACP
Posted: 28 Mar 2013, 21:59
by 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 522 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]