Code: Select all
SELECT user_email FROM phpbb_users WHERE user_allow_massemail=1
Does anyone have a new snippet that works or know why this isn´t working anymore?
Code: Select all
SELECT user_email FROM phpbb_users WHERE user_allow_massemail=1
Code: Select all
SELECT user_email FROM phpbb32_users
Code: Select all
FROM phpbb_users
Code: Select all
FROM phpbb32_users
Code: Select all
SELECT user_email FROM phpbb_users WHERE user_type <> 2
Thanks I will look into this one.david63 wrote: ↑Thu Nov 15, 2018 9:22 am Another option is to use this extension - viewtopic.php?f=456&t=2401101
It needs to have the structureSvensktgolfforum wrote: ↑Thu Nov 15, 2018 10:48 am One question, the downloaded file was named this, david63-userdetails-3.2 3
Can I upload that entire folder in to root/ext/????
ext/david63/userdetails/
The way I understand your post is that you want to export a list with username and user_email. What's preventing you from exporting that data from the users_table (and even exporting other data from other tables in order to perform queries).Svensktgolfforum wrote: ↑Thu Nov 15, 2018 8:02 am I have been able to use this snippet for the last four years, to export my users e-mails. The reason behind it is because I add them to Mailchimp and send them newsletters about the forum.
But yesterday I realized that the users that had registered after june/july wasn´t int the exported csv file from when I ran the script above.Code: Select all
SELECT user_email FROM phpbb_users WHERE user_allow_massemail=1
Does anyone have a new snippet that works or know why this isn´t working anymore?
I managed to install it now and THANK YOU MISTER! What a masterpiece of extension. Love it. It will be extremely helpful to me.david63 wrote: ↑Thu Nov 15, 2018 10:54 amIt needs to have the structureSvensktgolfforum wrote: ↑Thu Nov 15, 2018 10:48 am One question, the downloaded file was named this, david63-userdetails-3.2 3
Can I upload that entire folder in to root/ext/????ext/david63/userdetails/