gmail vs hotmail vs my stupidity

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
eyespark
Forum Commoner
Posts: 50
Joined: Tue Jan 24, 2006 7:36 am

gmail vs hotmail vs my stupidity

Post by eyespark »

Hi guys

I am loosing it!! Here is my problem:

When I send emails with attached script, url parameters from $mejl variable are displayed in gmail but not in hotmail and some other clients. I just don't know what the problem is. Anybody?

Thanks

Code: Select all

<?
include('config.inc.php'); 

if (isset($queue_size))
{
	$curr_unix_time = time();

	$connection = mysql_connect($db_server, $db_user, $db_password) or die("Could not connect : " . mysql_error());
	mysql_select_db($db_name) or die("Could not select database");

	$query = "SELECT * FROM nlqueue WHERE send_after <= '$curr_unix_time' ORDER BY message_id ASC LIMIT 0, $queue_size";
	$result = mysql_query($query) or die("Query failed : " . mysql_error());
	// gives us message_id and emailAddress

	while ($row = mysql_fetch_assoc($result))
	{
	$id = $row[ID_MEMBER];
	$key = $row[user_key];
	$mejl = "www.mydomain/cstest/index.php?action=odjava&id=".$id."&kljuc=".$key;

		
		// get message for selected message_id
		$message_query = "SELECT subject,message,format FROM nlmessages WHERE id = '$row[message_id]'";
		$message_result = mysql_query($message_query) or die("Query failed : " . mysql_error());
		$message_row = mysql_fetch_assoc($message_result);

		// send message to emailAddress and delete from queue
		$headers = '';
		$to      = $row[emailAddress];
		$subject = $message_row[subject];
		$message = $message_row[message];
		
		$message .= "\r\nTo* elektronsko pismo ste prejeli, ker ste prijavljeni na mydomain e-novice.\r\n";
		$message .= " ce* se zelite odjaviti, kliknite na sledeco povezavo: ".$mejl."\r\n"; 

		if ($message_row[format] == "html")
		{
			$boundary = md5(uniqid(time()));

			$headers = "MIME-Version: 1.0\r\n";
			$headers .= "Content-type: multipart/alternative;\r\n";
			$headers .= " boundary=\"$boundary\"\r\n";

			$message = "you shouldn't see this ever\r\n\r\n";

			$message .= "--$boundary\r\n";

			$message .= "Content-type: text/plain;\r\n";
			$message .= "Content-Transfer-Encoding: 7bit\r\n\r\n";
			$message .= strip_tags($message_row[message]) . "\r\n";

			$message .= "--$boundary\r\n";

			$message .= "Content-type: text/html;\r\n";
			$message .= "Content-Transfer-Encoding: 7bit\r\n\r\n";
			$message .= $message_row[message] . "<br>";
			$message .= "To elektronsko pismo ste prejeli, ker ste prijavljeni na mydomain e-novice.<br>";
			$message .= " ce se zelite odjaviti, kliknite na sledeco povezavo: $mejl \r\n"; 

			$message .= "--$boundary--\r\n";
			
		}

		$headers .= "From: $owner_email\r\nReply-To: $owner_email\r\nX-Mailer: mydomain";

		if(mail($to, $subject, $message, $headers))
		{
			// mail sent, remove from queue
			$delete_query = "DELETE FROM nlqueue WHERE message_id = '$row[message_id]' AND emailAddress = '$row[emailAddress]'";
			$delete_result = mysql_query($delete_query) or die("Query failed : " . mysql_error());
		}
	}
}
else
{
	echo "ERROR: queue_size not set in config.inc.php.";
}
?>
Post Reply