Other Issue: Newsletter Subscribers - How To Know Who ?

Posted: Sat Oct 27, 2007 3:44 pm

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

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.

Posted: Sat Oct 27, 2007 9:40 pm

Thanks for jogging the memory ...

SELECT * FROM `nuke_users` WHERE 1 = newsletter

That did exactly what I wanted.

Thanks, Jay

Posted: Tue Oct 30, 2007 5:59 am