PHP - All users email list

[Creativity]

This php web page will show all of your users registered accounts email addresses in the format:

email1, email2, email3, email, email5

This can be really useful if you wanted to create a email list to email every player registered on your server with important information etc...

You can download it here:

http://randomthingsihost.co.uk/download/email_script.rar

Remember please press the thanks button if this was helpful, or just if you feel like it =]

Ciao for nao eace:

EDIT: Cheers alfredao for the neater code, changed that part of the page

 

[Phoenix]

Thanks, this seems useful. I'll check it out and hit thanks from my computer. Keep it up!

 

[alfredao]

Nice try but this don't work.

 

[Creativity]

Nice try but this don't work.

Did work fine for me, what error is it giving you?

 

[alfredao]

I didn't test, but don't work.

$result = mssql_query("SELECT * FROM Account Email");

Account Email?

 

[heartbeat]

I didn't test, but don't work.

$result = mssql_query("SELECT * FROM Account Email");

Account Email?

*facepalm*
i'm pretty sure you're suppose to edit it and place in the name of the email field in there...

 

[Creativity]

I didn't test, but don't work.

$result = mssql_query("SELECT * FROM Account Email");

Account Email?

Account being the table name, and Email being the section in the column in the table, the database name is already defined

Though I like the script you put on my other thread, so ima upload one using that too, it's a little more neat

randomthingsihost.co.uk/download/email_script.rar

Btw if you could test my attempt because it worked for me so it should for others I bet you it does! =] (Unless you have a diff table name for email)

*facepalm*
i'm pretty sure you're suppose to edit it and place in the name of the email field in there...

I thought the email field was called Email, it is for me! What is yours called?

 

[Joe9099]

But

$result = mssql_query("SELECT * FROM Account Email");

Would be selecting from a column named Account Email ....
Correct me if im wrong.

 

[Arcelor]

$result = mssql_query("SELECT Email FROM Account");

?

 

[Joe9099]

$result = mssql_query("SELECT Email FROM Account");

?

Exactly.

 

[Creativity]

Well that does work due to the formatting that is available, it takes the first thing after from as the table name , and if there is a space the column, though I do prefer your way it seems more logical

 

[Linear88]

Seems useful, but thanks.

 

[Forean]

thanks, its alright but now the text needs to be white, instead of black.

 

[sayuta]

$mssql_user = "username";
$mssql_password = "password";
$mssql_host = "HOST";
$mssql_db = "GunzDB";

if(!@mssql_connect($mssql_host,$mssql_user,$mssql_password)){
echo "Cannot connect the Server";
die();
}
if(!@mssql_select_db($mssql_db)){
echo "Cannot connect to the Database";
die();
}


$headers = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: DomainName <[email protected]>\r\n"; 
$headers .= "X-Priority: 1\r\n"; 
$headers .= "X-MSmail-Priority: High\r\n";
$subject = "Test";
$text = "Hi."; // HTML Allowed.

$query = mssql_query("SELECT * FROM Account WHERE Email != NULL");
$emails = "";
while($row = mssql_fetch_array($query)){
$emails .= $row['Email'];
$emails .= ", ";
}
$mail_sent = @mail($emails, $subject, $text, $headers );

if($mail_sent == true){
echo "Mail has been sent";
} elseif($mail_sent == false){
echo "Error occured.";
} else {
echo "This error wouldn't even show up.";
}

Email Pl0x.

For the main part of collecting the emails :

$query = mssql_query("SELECT * FROM Account WHERE Email != NULL");
$emails = "";
while($row = mssql_fetch_array($query)){
$emails .= $row['Email'];
$emails .= ", ";
}
echo $emails;

Just mind, if u allow duplicate Emails to register with.. to check them ><. If some guy registered 5 accounts with the same email, he would get 5x the email ><..

 

[scrip]

nice but eh what is the point at it who add without he will be added guys from his own server just time wasting of spam newbs

 

[Nova]

echo "Cannot connect the Server";
die();

Could be this :

die("Cannot connect the Server");

Just pointing out. Other than that, nice release.

 

[Guy]

Just mind, if u allow duplicate Emails to register with.. to check them ><. If some guy registered 5 accounts with the same email, he would get 5x the email ><..

Which is why you could just use the DISTINCT keyword.

Anyways:

$ask = mssql_query("SELECT Email FROM Account ORDER BY AID ASC");

Any reason why you have an ORDER BY clause?

 

[sayuta]

Which is why you could just use the DISTINCT keyword.[/code]

Or restrict Emails from duplication in the beginning u start ur server.
Or use a while() and a double select query, but thats just odd. blows ur mind out if u are going to think about it.


@ Nova.

People like to script their ways, just copy/pasted mine. But got a whole function for the emailing, which i would like to keep private >< so i just copy/pasted working parts for it.


@ Topic. Make sure you actually triple checked ur stuff.
@ My Code, It's up to you whichever you use it or not.

 

[maxteam]

u can make use of PHPmailer too if u wud like too

To view the content, you need to sign in or register

 

[Creativity]

$ask = mssql_query("SELECT Email FROM Account ORDER BY AID ASC");

Any reason why you have an ORDER BY clause?

Not sure I'm new to this, but it was just to give it somewhere to start I guess