Other Issue: Newsletter Subscribers - How To Know Who ?

dad7732 · Worker Joined: Mar 18, 2007 Posts: 228

With several thousand users, I need to know who has subscribed to the newsletter. Is there an addon that will do that, I don't see that feature natively. The Members List doesn't do that.

Thanks, Jay

montego · Posted: Sat Oct 27, 2007 8:58 pm

No, I cannot think of an add-on either that does this. However, you could use phpMyAdmin to query that field. I believe it is field "newsletter", 1 being they are subscribed, on the nuke_users table.

dad7732 · Worker Joined: Mar 18, 2007 Posts: 228

Thanks for jogging the memory ...

SELECT * FROM `nuke_users` WHERE 1 = newsletter

That did exactly what I wanted.

Thanks, Jay

montego · Posted: Tue Oct 30, 2007 5:59 am