Subversion-Projekte lars-tiefland.content-management

<?php
    require_once "Mail.php";
    require_once "Mail/mime.php";
    mysql_connect( "localhost", "content_managem", "k-dp-u" );
    mysql_query( "use content_management" );
    $handle = time();

    // alle faellingen Eintraege mit dem aktuellen Handle sichern
    // faellig = takeOff-Zeizpunkt ist verstrichen, Handle = 0
    $sql="UPDATE
            mailspool_out
        SET
            mailUserAgentHandle=$handle
        WHERE
            takeoff < NOW()
        AND
            mailUserAgentHandle = 0
        LIMIT 1000                        
    ";        
    $result = mysql_query( $sql );
    $sql="SELECT
            *
        FROM
            mailspool_out
        WHERE
            mailUserAgentHandle = $handle
    ";
    $result = mysql_query( $sql );

    while ( $zeile = mysql_fetch_assoc( $result ) )
    {
        if ( preg_match( "/[A-Za-z0-9-_.+]+\@[A-Za-z0-9-_.+]+\.[A-Za-z]+/",
            $zeile["to"] ) )
        {
            $from = $zeile['from'];
            $to = $zeile['to'];
            $subject = $zeile['subject'];
            $body = $zeile['text'];

            $host = $zeile['smtp_server']; // Your domain
            $username = $zeile['smtp_user']; // Your user / full email address
            $password = $zeile['smtp_pass']; // Password to your email address
            $authed = $zeile['smtp_authed'];

            $crlf = "\n";
            $mime = new Mail_mime( $crlf );
            $plain = strip_tags( $body, "<br><br />" );
            $plain = str_replace( array( "<br>", "<br />" ), "\n", $plain );
            $mime->setTXTBody( $plain );
            $mime->setHTMLBody( $body );

            $headers = array( 'From' => $from, 'Return-Path' => $from,
                'Subject' => $subject, "To" => $to, "Date" => date( "r" ), );

            //do not ever try to call these lines in reverse order
            $body = $mime->get();
            $headers = $mime->headers( $headers, true );


            if ( $zeile['smtp_server'] )
            {
                $smtp_opts = array( 'host' => $host, 'auth' => ( bool )$authed,
                    'username' => $username, 'password' => $password );
                $mail = Mail::factory( 'smtp', $smtp_opts );
            }
            else
            {
                $mail = Mail::factory( 'mail' );
            }
            if ( PEAR::isError( $mail ) )
            {
                echo ( "<p>" . $mail->getMessage() . "</p>" );
            }
            else
            {
                $res = $mail->send( $to, $headers, $body );
                if ( PEAR::isError( $res ) )
                {
                    echo ( "<p>" . $res->getMessage() . "</p>" );
                }
            }
        }
    }

    $sql="DELETE FROM
            mailspool_out
        WHERE
            mailUserAgentHandle = $handle
    ";
    $result = mysql_query( $sql );
?>