What SQL query should i use to get all the email id's of users as a backup file?

Any idea?

try this mod

http://www.phpbbhacks.com/download/704

at home i'll post u a mod that will help u more.

____________
? Zuker - EDDB - LPM - Sharefields

Zuker wrote: [View Post]

try this mod

http://www.phpbbhacks.com/download/704

at home i'll post u a mod that will help u more.

thanx for this...but this only lists the emails ....how can i get all of them in a text file or csv so tht i can import in gmail etc ?

The reason why im asking this is when i send email via the mass email thing...it goes in spam..

I want to make a list easily with the db so that i can send mass email with gmail etc.

So this maybe help you?

http://www.phpbb.com/community/viewtopic.php?t=315799

____________
? Zuker - EDDB - LPM - Sharefields

Zuker wrote: [View Post]

So this maybe help you?

http://www.phpbb.com/community/viewtopic.php?t=315799

Thanks a lot! next time i'll search phpbb site before i ask here....sorry!

works with IP!

You are welcome

____________
? Zuker - EDDB - LPM - Sharefields

You can do this in phpMyAdmin...



Than you can export it in csv...

Or you can export users table in CSV/XLS open the file in XLS (or any other spreadsheet capable program) and remove the columns you don't need.

There are tons of ways...

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

Mighty Gorgon wrote: [View Post]

You can do this in phpMyAdmin...

Code: [Download] [Hide] [Select]

Code: [Download] [Show]

SELECT user_email FROM phpbb_users

Than you can export it in csv...

Or you can export users table in CSV/XLS open the file in XLS (or any other spreadsheet capable program) and remove the columns you don't need.

There are tons of ways...

WOW! this is much cooler!!! thanx