How can I collect all of my members' email addresses without copying them one-by-one? I want it since mailing using the ACP is not allowed in free host so I have to do it by manual means
Do you have phpmyadmin??
Run this query there:
SELECT `uid`,`username`,`email` from `mybb_users` WHERE `usergroup` != 5 AND `usergroup` != 7
Replace mybb_ with your own prefix if different
The above will get you the uid, username and emails of all the users who are not in awaiting activation or banned
I mean, all of them, not just those in specific usergroups
Just remove the WHERE clause...
(2011-01-05, 11:54 AM)E-Hero Kyle Wrote: [ -> ]I mean, all of them, not just those in specific usergroups
That query is for all of them, apart from the awaiting activation and banned group, you're probably not going to want to email people in these groups.