Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Changing notification email & email lists
edited February 2008 in Vanilla 1.0 Help
I couldn't find this discussed anywhere on the forum. Maybe it's a simple thing but I can't figure it out. 1. How do I change the message that is sent to people who are newly approved to the forum? I'd like to change what it sends them to encourage them to go to the forum and leave a comment on the "Introduce Yourself" thread. 2. How can I make a list of email addresses from the information entered on the forum? I'd like to have an email list to send everyone a message every so often. thanks
This discussion has been closed.
2. SELECT Email FROM LUM_User WHERE RoleID <> 2
Run that code in something like PHPMyAdmin for the list, it excludes members who have been banned. If you want only the members who have at least made a comment, add AND LastCommentPost IS NOT NULL to the end of it.