Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2008
Posts: 65
A
journeyman
journeyman
A Offline
Joined: Jun 2008
Posts: 65
I have set my forum registration screen to show and require receive emails from admin. But I cant search or filter the members that have agreed to receive admin emails, even using advanced search. If I look in a members profile, that option doesnt show either.

How can I access this list?


Auckland, New Zealand

http://www2.everybody.co.nz/forum/
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
I believe it is the default for any query you make.
Meaning if you send a batch email from the control panel. Only members that have agreed to accept email from the admin will be sent.
If you are looking for who has opted out of admin emails. There was a post here a few weeks back asking this very same question.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2008
Posts: 65
A
journeyman
journeyman
A Offline
Joined: Jun 2008
Posts: 65
Thanks, its a pity there isn't a better way of filtering to access a list. Ive looked around but the search option on the forums isn't very good, cant find that post or any, on email opt in or out or anything much.


Auckland, New Zealand

http://www2.everybody.co.nz/forum/
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Well I did try this in Control Panel ยป Database Tools+SQL Command:
Quote
SELECT * FROM `ubbt_USER_PROFILE` WHERE `USER_ACCEPT_ADMIN_EMAILS` = "on"
But I found that the field is populated with on,off,yes, and null.
I don't quite understand why I would have four values for a field that should be just on or off
So Rick will need to respond on what the values should be.

But I believe the email tool was designed to just send email to members that have accepted admin emails.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2008
Posts: 65
A
journeyman
journeyman
A Offline
Joined: Jun 2008
Posts: 65
Thanks Ruben, I am wanting to use it to contact new members to welcome them aboard etc.


Auckland, New Zealand

http://www2.everybody.co.nz/forum/

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)