How to export members emails ?

For teh spam? :D

You can export it to the txt file.

Create any temporary file where maincore.php is located, say export.php

Put the below code in that :

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php

require_once "maincore.php";

$result = dbquery("SELECT user_email FROM ".DB_USERS." WHERE user_status='0'";

while($data=dbarray($result))
{
echo $data['user_email'];
}

?>[/syntaxhighlighter]

Call it through your Browser.

I hope that this is What you want to have...

In case you want to Show each E-Mail on a Next Line, Add after the

And then You can Copy the Text of the Page and can Save in any File, say .TXT

Thanks ankurthakur, its good :)
One more thing, is it possible to separate email adress by commas ?

Not a Big Job !!! Its just like HTML that you can add yourself...

Just Put a Comma (,) before <br /> and you are done !!!

You just need to put HTML Code...

The Syntax is echo "Your HTML Code Here";

Great man. Thank you very much.

2)
In phpMyAdmin export needed cell

3)
add e-mail cell in user's list in admin area

More and more I think you are a SPAMER!

@V veb: I think that he asked to export it into a single file..... which is solved... ;)