https://www.icyphoenix.com/viewtopic.php?f=35&t=2060
-----------------------------------
toledo
Wed 23 May, 2007 13:58

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

Any idea?


-----------------------------------
Zuker
Wed 23 May, 2007 16:51

Re: Database Question...
-----------------------------------
try this mod

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

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


-----------------------------------
toledo
Wed 23 May, 2007 21:19

Re: Database Question...
-----------------------------------
[quote user="Zuker" post="14812"]try this mod

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

at home i'll post u a mod that will help u more.[/quote]

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.. :cry: 

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


-----------------------------------
Zuker
Wed 23 May, 2007 23:43

Re: Database Question...
-----------------------------------
So this maybe help you?

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


-----------------------------------
toledo
Fri 25 May, 2007 13:58

Re: Database Question...
-----------------------------------
[quote user="Zuker" post="14874"]So this maybe help you?

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

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

works with IP!


-----------------------------------
Zuker
Fri 25 May, 2007 14:35

Re: Database Question...
-----------------------------------
You are welcome ;)


-----------------------------------
Mighty Gorgon
Sat 26 May, 2007 02:23

Re: SOLVED - Database Question...
-----------------------------------
You can do this in phpMyAdmin...

[codeblock]SELECT user_email FROM phpbb_users[/codeblock]

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... :mri:


-----------------------------------
toledo
Sat 26 May, 2007 10:38

Re: SOLVED - Database Question...
-----------------------------------
[quote user="Mighty Gorgon" post="15201"]You can do this in phpMyAdmin...

[codeblock]SELECT user_email FROM phpbb_users[/codeblock]

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... :mri:[/quote]

WOW! this is much cooler!!! thanx


