REDAXO Forum

Code: Alles auswählen

X-Mailer: PHPMailer (phpmailer.sourceforge.net) [version 2.0.0 rc3]

Code: Alles auswählen

// ----- eMails auslesen und versenden
		$nl = new sql;
		// $nl->debugsql = 1;
		$nl->setQuery("select * from rex_com_user where last_newsletterid<>'$mail_nlid' and sendemail_newletter=1");
		$nl_array = $nl->get_array();

		$up = new sql;
		foreach($nl_array as $user)
		{

			// echo "<br />".$user["email"];

			// ----- daten auslesen
			$to_email = $user["email"];

			// ----- email miz mail_nlid aktualisieren
			$up->query("update rex_com_user set last_newsletterid='$mail_nlid' where id='".$user["id"]."'");

			// ----- email versenden
			$mail = new rex_mailer();
			$mail->AddAddress($to_email);
			$mail->From = $mail_reply;
			$mail->FromName = $mail_reply;
	
			// Subject		
			$subject = $mail_subject;
			$html_body = $content;

			foreach($user as $k => $v)
			{
				// echo "<br />-- $k => $v";
				$html_body = str_replace( "###".$k."###","$v",$html_body);
				$subject = str_replace( "###".$k."###","$v",$subject);
			}
			
			// text
			$text_body = $html_body;
			$text_body = preg_replace("#(\<)(.*)(\>)#imsU", "",  $text_body);
			$text_body = html_entity_decode($text_body);
	
			// echo "<pre>$text_body</pre>";
			
			$mail->Subject = $subject;
			$mail->AltBody = $text_body;
			$mail->Body = $html_body;
			$mail->Send();

		}