[borbole]

Originally Posted by Gnappy

Hello guys,
I need to improve my newsletter system due the vb default one is very painful...
So the first step is obtain and collect all the users email addresses from my DB. I thought there was a "simply hack" to do this but after many googling and searching here on vb.org I found NOTHING.

I know I could get them from the DB but for particular reasons I cannot connect to the sql server by remote and, of course, I am not skilled enough to make a query that does a simple list(ehh lol )..

Can someone help me? Any kind of help will be very appreciated!

Do you want only the email addresses or the usernames associated with those email addresses as well?

Anyway, to get only the emails run this query at the SQL tab at your phpmyadmin:

SELECT email FROM `user`;

To get the email addresses and the usernames associated with those email addresses, run this query instead:

SELECT email, username FROM `user`;

If your db tables have prefix, include that as in well in the query.