Esempio n. 1
0
    function runtest()
    {
        $placeholderTests = array('Basic 1' => array('values' => array('NAME' => 'First Name', 'LASTNAME' => 'Last Name'), 'template' => ' [NAME] [LASTNAME] ', 'result' => ' First Name Last Name '), 'Basic with fallback' => array('values' => array('SALUTATION' => '', 'LASTNAME' => 'Last Name'), 'template' => ' Dear [SALUTATION%%Mr/Ms] [LASTNAME] ', 'result' => ' Dear Mr/Ms Last Name '), 'Basic Case' => array('values' => array('saluTaTION' => '', 'LastName' => 'Last Name'), 'template' => ' Dear [SALuTation%%Mr/Ms] [lASTnAme] ', 'result' => ' Dear Mr/Ms Last Name '), 'Foreign Char' => array('values' => array('Företag' => 'XXX'), 'template' => ' [Företag] [F&ouml;retag] [F&ouml;RETAG] ', 'result' => ' XXX XXX XXX '), 'Foreign Char2' => array('values' => array('Företag' => 'XXX'), 'template' => ' [F&ouml;RETAG%%Company name] ', 'result' => ' XXX '), 'Empty value' => array('values' => array('Empty' => ''), 'template' => ' [EMPTY%%Fallback value] ', 'result' => ' Fallback value '), 'Foreign Char3' => array('values' => array('PAíS COUNTRY' => 'São Paulo'), 'template' => ' [PA&iacute;S COUNTRY%%Fallback value] [PAíS COUNTRY%%Fallback value] ', 'result' => ' São Paulo São Paulo '), 'Foreign Char Fallback' => array('values' => array('PAíS COUNTRY' => ''), 'template' => ' [PA&iacute;S COUNTRY%%Fallback value] [PAíS COUNTRY%%Fallback value] ', 'result' => ' Fallback value Fallback value '), 'Multiple' => array('values' => array('Name' => '', 'PAíS COUNTRY' => 'São Paulo', 'Nome' => 'Your real name', 'GRUPO BAND' => 'Loahded dipers'), 'template' => '<p>Dear [NAME%%Friend]</p>
<p>&nbsp;</p>
<p>Your band name is [GRUPO BAND%%Unknown band name]</p>
<p>and you live in [PA&iacute;S COUNTRY%%No idea actually]</p>
<p>[PA&iacute;S COUNTRY]</p>
<p>Your real name is [NOME]</p>
<p>&nbsp;</p>', 'result' => '<p>Dear Friend</p>
<p>&nbsp;</p>
<p>Your band name is Loahded dipers</p>
<p>and you live in São Paulo</p>
<p>São Paulo</p>
<p>Your real name is Your real name</p>
<p>&nbsp;</p>'));
        print "<P>PHP " . PHP_VERSION . " running on " . PHP_OS . " - Testing placeholder parsing</P>";
        $resultString = "";
        $nFoundWrong = 0;
        $boolean = array("FALSE", "TRUE");
        foreach ($placeholderTests as $placeholder => $test) {
            $testresult = parsePlaceHolders($test['template'], $test['values']);
            if ($testresult != $test['result']) {
                $resultString .= "{$placeholder} parses incorrectly <BR/> <pre>" . htmlspecialchars($testresult) . "</pre> instead of <pre>" . htmlspecialchars($test['result']) . '</pre>';
                $nFoundWrong++;
            }
        }
        if ($nFoundWrong > 0) {
            print "<P>The following {$nFoundWrong} placeholders were evaluated wrong:<BR/>{$resultString}</P>";
            return false;
        } else {
            print "<P>All placeholders evaluated correctly.</P>";
            return true;
        }
    }
Esempio n. 2
0
function sendEmail($messageid, $email, $hash, $htmlpref = 0, $rssitems = array(), $forwardedby = array())
{
    $getspeedstats = VERBOSE && !empty($GLOBALS['getspeedstats']) && isset($GLOBALS['processqueue_timer']);
    $sqlCountStart = $GLOBALS["pagestats"]["number_of_queries"];
    $isTestMail = isset($_GET['page']) && $_GET['page'] == 'send';
    ## for testing concurrency, put in a delay to check if multiple send processes cause duplicates
    #usleep(rand(0,10) * 1000000);
    global $strThisLink, $strUnsubscribe, $PoweredByImage, $PoweredByText, $cached, $website, $counters;
    if ($email == "") {
        return 0;
    }
    if ($getspeedstats) {
        output('sendEmail start ' . $GLOBALS['processqueue_timer']->interval(1));
    }
    #0013076: different content when forwarding 'to a friend'
    if (FORWARD_ALTERNATIVE_CONTENT) {
        $forwardContent = sizeof($forwardedby) > 0;
    } else {
        $forwardContent = 0;
    }
    if (empty($cached[$messageid])) {
        if (!precacheMessage($messageid, $forwardContent)) {
            unset($cached[$messageid]);
            logEvent('Error loading message ' . $messageid . '  in cache');
            return 0;
        }
    } else {
        #  dbg("Using cached {$cached[$messageid]["fromemail"]}");
        if (VERBOSE) {
            output('Using cached message');
        }
    }
    if (VERBOSE) {
        output(s('Sending message %d with subject %s to %s', $messageid, $cached[$messageid]["subject"], $email));
    }
    ## at this stage we don't know whether the content is HTML or text, it's just content
    $content = $cached[$messageid]['content'];
    if (VERBOSE && $getspeedstats) {
        output('Load user start');
    }
    $userdata = array();
    $user_att_values = array();
    #0011857: forward to friend, retain attributes
    if ($hash == 'forwarded' && defined('KEEPFORWARDERATTRIBUTES') && KEEPFORWARDERATTRIBUTES) {
        $user_att_values = getUserAttributeValues($forwardedby['email']);
    } elseif ($hash != 'forwarded') {
        $user_att_values = getUserAttributeValues($email);
    }
    if (!is_array($user_att_values)) {
        $user_att_values = array();
    }
    foreach ($user_att_values as $key => $val) {
        $newkey = cleanAttributeName($key);
        ## in the help, we only list attributes with "strlen < 20"
        unset($user_att_values[$key]);
        if (strlen($key) < 20) {
            $user_att_values[$newkey] = $val;
        }
    }
    # print '<pre>';var_dump($user_att_values);print '</pre>';exit;
    $query = sprintf('select * from %s where email = ?', $GLOBALS["tables"]["user"]);
    $rs = Sql_Query_Params($query, array($email));
    $userdata = Sql_Fetch_Assoc($rs);
    if (empty($userdata['id'])) {
        $userdata = array();
    }
    #var_dump($userdata);
    if (stripos($content, "[LISTS]") !== false) {
        $listsarr = array();
        $req = Sql_Query(sprintf('select list.name from %s as list,%s as listuser where list.id = listuser.listid and listuser.userid = %d', $GLOBALS["tables"]["list"], $GLOBALS["tables"]["listuser"], $userdata["id"]));
        while ($row = Sql_Fetch_Row($req)) {
            array_push($listsarr, $row[0]);
        }
        if (!empty($listsarr)) {
            $html['lists'] = join('<br/>', $listsarr);
            $text['lists'] = join("\n", $listsarr);
        } else {
            $html['lists'] = $GLOBALS['strNoListsFound'];
            $text['lists'] = $GLOBALS['strNoListsFound'];
        }
        unset($listsarr);
    }
    if (VERBOSE && $getspeedstats) {
        output('Load user end');
    }
    if ($cached[$messageid]['userspecific_url']) {
        if (VERBOSE && $getspeedstats) {
            output('fetch personal URL start');
        }
        ## Fetch external content, only if the URL has placeholders
        if ($GLOBALS["can_fetchUrl"] && preg_match("/\\[URL:([^\\s]+)\\]/i", $content, $regs)) {
            while (isset($regs[1]) && strlen($regs[1])) {
                $url = $regs[1];
                if (!preg_match('/^http/i', $url)) {
                    $url = 'http://' . $url;
                }
                $remote_content = fetchUrl($url, $userdata);
                # @@ don't use this
                #      $remote_content = includeStyles($remote_content);
                if ($remote_content) {
                    ## @TODO, work out a nice way to do this: ##17197
                    ## collecting different remote URLS only works if they do not have html and body tags.
                    ## but if we strip them here, that might affect specially crafted ones, eg <body class="xx">
                    if (0) {
                        $remote_content = preg_replace('/<html[^>]*>/', '', $remote_content);
                        $remote_content = preg_replace('/<body[^>]*>/', '', $remote_content);
                        $remote_content = preg_replace('/<\\/html[^>]*>/', '', $remote_content);
                        $remote_content = preg_replace('/<\\/body[^>]*>/', '', $remote_content);
                    }
                    $content = str_replace($regs[0], '<!--' . $url . '-->' . $remote_content, $content);
                    $cached[$messageid]["htmlformatted"] = strip_tags($content) != $content;
                } else {
                    logEvent("Error fetching URL: {$regs['1']} to send to {$email}");
                    return 0;
                }
                preg_match("/\\[URL:([^\\s]+)\\]/i", $content, $regs);
            }
        }
        if (VERBOSE && $getspeedstats) {
            output('fetch personal URL end');
        }
    }
    if (VERBOSE && $getspeedstats) {
        output('define placeholders start');
    }
    $url = getConfig("unsubscribeurl");
    ## https://mantis.phplist.com/view.php?id=16680 -> the "sep" should be & for the text links
    $sep = strpos($url, '?') === false ? '?' : '&';
    $html["unsubscribe"] = sprintf('<a href="%s%suid=%s">%s</a>', $url, htmlspecialchars($sep), $hash, $strUnsubscribe);
    $text["unsubscribe"] = sprintf('%s%suid=%s', $url, $sep, $hash);
    $text["jumpoff"] = sprintf('%s%suid=%s&jo=1', $url, $sep, $hash);
    $html["unsubscribeurl"] = sprintf('%s%suid=%s', $url, htmlspecialchars($sep), $hash);
    $text["unsubscribeurl"] = sprintf('%s%suid=%s', $url, $sep, $hash);
    $text["jumpoffurl"] = sprintf('%s%suid=%s&jo=1', $url, $sep, $hash);
    #0013076: Blacklisting posibility for unknown users
    $url = getConfig("blacklisturl");
    $sep = strpos($url, '?') === false ? '?' : '&';
    $html["blacklist"] = sprintf('<a href="%s%semail=%s">%s</a>', $url, htmlspecialchars($sep), $email, $strUnsubscribe);
    $text["blacklist"] = sprintf('%s%semail=%s', $url, $sep, $email);
    $html["blacklisturl"] = sprintf('%s%semail=%s', $url, htmlspecialchars($sep), $email);
    $text["blacklisturl"] = sprintf('%s%semail=%s', $url, $sep, $email);
    #0013076: Problem found during testing: message part must be parsed correctly as well.
    if (sizeof($forwardedby) && isset($forwardedby['email'])) {
        $html["unsubscribe"] = $html["blacklist"];
        $text["unsubscribe"] = $text["blacklist"];
        $html["forwardedby"] = $forwardedby["email"];
        $text["forwardedby"] = $forwardedby["email"];
    }
    $url = getConfig("subscribeurl");
    $sep = strpos($url, '?') === false ? '?' : '&';
    $html["subscribe"] = sprintf('<a href="%s">%s</a>', $url, $strThisLink);
    $text["subscribe"] = sprintf('%s', $url);
    $html["subscribeurl"] = sprintf('%s', $url);
    $text["subscribeurl"] = sprintf('%s', $url);
    $url = getConfig("forwardurl");
    $sep = strpos($url, '?') === false ? '?' : '&';
    $html["forward"] = sprintf('<a href="%s%suid=%s&amp;mid=%d">%s</a>', $url, htmlspecialchars($sep), $hash, $messageid, $strThisLink);
    $text["forward"] = sprintf('%s%suid=%s&mid=%d', $url, $sep, $hash, $messageid);
    $html["forwardurl"] = sprintf('%s%suid=%s&amp;mid=%d', $url, htmlspecialchars($sep), $hash, $messageid);
    $text["forwardurl"] = $text["forward"];
    $html["messageid"] = sprintf('%d', $messageid);
    $text["messageid"] = sprintf('%d', $messageid);
    $url = getConfig("forwardurl");
    # make sure there are no newlines, otherwise they get turned into <br/>s
    $html["forwardform"] = sprintf('<form method="get" action="%s" name="forwardform" class="forwardform"><input type="hidden" name="uid" value="%s" /><input type="hidden" name="mid" value="%d" /><input type="hidden" name="p" value="forward" /><input type=text name="email" value="" class="forwardinput" /><input name="Send" type="submit" value="%s" class="forwardsubmit"/></form>', $url, $hash, $messageid, $GLOBALS['strForward']);
    $text["signature"] = "\n\n-- powered by phpList, www.phplist.com --\n\n";
    $url = getConfig("preferencesurl");
    $sep = strpos($url, '?') === false ? '?' : '&';
    $html["preferences"] = sprintf('<a href="%s%suid=%s">%s</a>', $url, htmlspecialchars($sep), $hash, $strThisLink);
    $text["preferences"] = sprintf('%s%suid=%s', $url, $sep, $hash);
    $html["preferencesurl"] = sprintf('%s%suid=%s', $url, htmlspecialchars($sep), $hash);
    $text["preferencesurl"] = sprintf('%s%suid=%s', $url, $sep, $hash);
    $url = getConfig("confirmationurl");
    $sep = strpos($url, '?') === false ? '?' : '&';
    $html["confirmationurl"] = sprintf('%s%suid=%s', $url, htmlspecialchars($sep), $hash);
    $text["confirmationurl"] = sprintf('%s%suid=%s', $url, $sep, $hash);
    #historical, not sure it's still used
    $html["userid"] = $hash;
    $text["userid"] = $hash;
    $html['website'] = $GLOBALS['website'];
    # Your website's address, e.g. www.yourdomain.com
    $text['website'] = $GLOBALS['website'];
    $html['domain'] = $GLOBALS['domain'];
    # Your domain, e.g. yourdomain.com
    $text['domain'] = $GLOBALS['domain'];
    if ($hash != 'forwarded') {
        $text['footer'] = $cached[$messageid]["textfooter"];
        $html['footer'] = $cached[$messageid]["htmlfooter"];
    } else {
        #0013076: different content when forwarding 'to a friend'
        if (FORWARD_ALTERNATIVE_CONTENT) {
            $text['footer'] = stripslashes($messagedata["forwardfooter"]);
        } else {
            $text['footer'] = getConfig('forwardfooter');
        }
        $html['footer'] = $text['footer'];
    }
    /*
      We request you retain the signature below in your emails including the links.
      This not only gives respect to the large amount of time given freely
      by the developers  but also helps build interest, traffic and use of
      phpList, which is beneficial to it's future development.
    
      You can configure how the credits are added to your pages and emails in your
      config file.
    
      Michiel Dethmers, phpList Ltd 2003 - 2013
    */
    if (!EMAILTEXTCREDITS) {
        $html["signature"] = $PoweredByImage;
        #'<div align="center" id="signature"><a href="http://www.phplist.com"><img src="powerphplist.png" width=88 height=31 title="Powered by PHPlist" alt="Powered by PHPlist" border="0" /></a></div>';
        # oops, accidentally became spyware, never intended that, so take it out again :-)
        $html["signature"] = preg_replace('/src=".*power-phplist.png"/', 'src="powerphplist.png"', $html["signature"]);
    } else {
        $html["signature"] = $PoweredByText;
    }
    #  $content = $cached[$messageid]["htmlcontent"];
    if (VERBOSE && $getspeedstats) {
        output('define placeholders end');
    }
    ## Fill text and html versions depending on given versions.
    if (VERBOSE && $getspeedstats) {
        output('parse text to html or html to text start');
    }
    if ($cached[$messageid]["htmlformatted"]) {
        if (empty($cached[$messageid]["textcontent"])) {
            $textcontent = HTML2Text($content);
        } else {
            $textcontent = $cached[$messageid]["textcontent"];
        }
        $htmlcontent = $content;
    } else {
        if (empty($cached[$messageid]["textcontent"])) {
            $textcontent = $content;
        } else {
            $textcontent = $cached[$messageid]["textcontent"];
        }
        $htmlcontent = parseText($content);
    }
    if (VERBOSE && $getspeedstats) {
        output('parse text to html or html to text end');
    }
    $defaultstyle = getConfig("html_email_style");
    $adddefaultstyle = 0;
    if (VERBOSE && $getspeedstats) {
        output('merge into template start');
    }
    if ($cached[$messageid]["template"]) {
        # template used
        $htmlmessage = str_replace("[CONTENT]", $htmlcontent, $cached[$messageid]["template"]);
    } else {
        # no template used
        $htmlmessage = $htmlcontent;
        $adddefaultstyle = 1;
    }
    $textmessage = $textcontent;
    if (VERBOSE && $getspeedstats) {
        output('merge into template end');
    }
    ## Parse placeholders
    if (VERBOSE && $getspeedstats) {
        output('parse placeholders start');
    }
    /*
      var_dump($html);
      var_dump($userdata);
      var_dump($user_att_values);
      exit;
    */
    #  print htmlspecialchars($htmlmessage);exit;
    ### @@@TODO don't use forward and forward form in a forwarded message as it'll fail
    if (strpos($htmlmessage, "[FOOTER]") !== false) {
        $htmlmessage = str_ireplace("[FOOTER]", $html["footer"], $htmlmessage);
    } elseif ($html["footer"]) {
        $htmlmessage = addHTMLFooter($htmlmessage, '<br />' . $html["footer"]);
    }
    if (strpos($htmlmessage, "[SIGNATURE]") !== false) {
        $htmlmessage = str_ireplace("[SIGNATURE]", $html["signature"], $htmlmessage);
    } else {
        # BUGFIX 0015303, 2/2
        //    $htmlmessage .= '<br />'.$html["signature"];
        $htmlmessage = addHTMLFooter($htmlmessage, '
' . $html["signature"]);
    }
    # END BUGFIX 0015303, 2/2
    if (strpos($textmessage, "[FOOTER]")) {
        $textmessage = str_ireplace("[FOOTER]", $text["footer"], $textmessage);
    } else {
        $textmessage .= "\n\n" . $text["footer"];
    }
    if (strpos($textmessage, '[SIGNATURE]')) {
        $textmessage = str_ireplace("[SIGNATURE]", $text["signature"], $textmessage);
    } else {
        $textmessage .= "\n" . $text["signature"];
    }
    ### addition to handle [FORWARDURL:Message ID:Link Text] (link text optional)
    while (preg_match('/\\[FORWARD:([^\\]]+)\\]/Uxm', $htmlmessage, $regs)) {
        $newforward = $regs[1];
        $matchtext = $regs[0];
        if (strpos($newforward, ':')) {
            ## using FORWARDURL:messageid:linktext
            list($forwardmessage, $forwardtext) = explode(':', $newforward);
        } else {
            $forwardmessage = sprintf('%d', $newforward);
            $forwardtext = 'this link';
        }
        if (!empty($forwardmessage)) {
            $url = getConfig("forwardurl");
            $sep = strpos($url, '?') === false ? '?' : '&';
            $forwardurl = sprintf('%s%suid=%s&mid=%d', $url, $sep, $hash, $forwardmessage);
            $htmlmessage = str_replace($matchtext, '<a href="' . htmlspecialchars($forwardurl) . '">' . $forwardtext . '</a>', $htmlmessage);
        } else {
            ## make sure to remove the match, otherwise, it'll be an eternal loop
            $htmlmessage = str_replace($matchtext, '', $htmlmessage);
        }
    }
    ## the text message has to be parsed seperately, because the line might wrap if the text for the link is long, so the match text is different
    while (preg_match('/\\[FORWARD:([^\\]]+)\\]/Uxm', $textmessage, $regs)) {
        $newforward = $regs[1];
        $matchtext = $regs[0];
        if (strpos($newforward, ':')) {
            ## using FORWARDURL:messageid:linktext
            list($forwardmessage, $forwardtext) = explode(':', $newforward);
        } else {
            $forwardmessage = sprintf('%d', $newforward);
            $forwardtext = 'this link';
        }
        if (!empty($forwardmessage)) {
            $url = getConfig("forwardurl");
            $sep = strpos($url, '?') === false ? '?' : '&';
            $forwardurl = sprintf('%s%suid=%s&mid=%d', $url, $sep, $hash, $forwardmessage);
            $textmessage = str_replace($matchtext, $forwardtext . ' ' . $forwardurl, $textmessage);
        } else {
            ## make sure to remove the match, otherwise, it'll be an eternal loop
            $textmessage = str_replace($matchtext, '', $textmessage);
        }
    }
    #  $req = Sql_Query(sprintf('select filename,data from %s where template = %d',
    #    $GLOBALS["tables"]["templateimage"],$cached[$messageid]["templateid"]));
    if (ALWAYS_ADD_USERTRACK) {
        if (stripos($htmlmessage, '</body>')) {
            $htmlmessage = str_replace('</body>', '<img src="' . $GLOBALS['public_scheme'] . '://' . $website . $GLOBALS["pageroot"] . '/ut.php?u=' . $hash . '&amp;m=' . $messageid . '" width="1" height="1" border="0" /></body>', $htmlmessage);
        } else {
            $htmlmessage .= '<img src="' . $GLOBALS['public_scheme'] . '://' . $website . $GLOBALS["pageroot"] . '/ut.php?u=' . $hash . '&amp;m=' . $messageid . '" width="1" height="1" border="0" />';
        }
    } else {
        ## can't use str_replace or str_ireplace, because those replace all, and we only want to replace one
        $htmlmessage = preg_replace('/\\[USERTRACK\\]/i', '<img src="' . $GLOBALS['public_scheme'] . '://' . $website . $GLOBALS["pageroot"] . '/ut.php?u=' . $hash . '&amp;m=' . $messageid . '" width="1" height="1" border="0" />', $htmlmessage, 1);
    }
    # make sure to only include usertrack once, otherwise the stats would go silly
    $htmlmessage = str_ireplace('[USERTRACK]', '', $htmlmessage);
    $html['subject'] = $cached[$messageid]["subject"];
    $text['subject'] = $cached[$messageid]["subject"];
    $htmlmessage = parsePlaceHolders($htmlmessage, $html);
    $textmessage = parsePlaceHolders($textmessage, $text);
    if (VERBOSE && $getspeedstats) {
        output('parse placeholders end');
    }
    if (VERBOSE && $getspeedstats) {
        output('parse userdata start');
    }
    $htmlmessage = parsePlaceHolders($htmlmessage, $userdata);
    $textmessage = parsePlaceHolders($textmessage, $userdata);
    //CUT 2
    $destinationemail = '';
    if (is_array($user_att_values)) {
        // CUT 3
        $htmlmessage = parsePlaceHolders($htmlmessage, $user_att_values);
        $textmessage = parsePlaceHolders($textmessage, $user_att_values);
    }
    if (VERBOSE && $getspeedstats) {
        output('parse userdata end');
    }
    if (!$destinationemail) {
        $destinationemail = $email;
    }
    # this should move into a plugin
    if (strpos($destinationemail, '@') === false && isset($GLOBALS["expand_unqualifiedemail"])) {
        $destinationemail .= $GLOBALS["expand_unqualifiedemail"];
    }
    if (VERBOSE && $getspeedstats) {
        output('pass to plugins for destination email start');
    }
    foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
        #    print "Checking Destination for ".$plugin->name."<br/>";
        $destinationemail = $plugin->setFinalDestinationEmail($messageid, $user_att_values, $destinationemail);
    }
    if (VERBOSE && $getspeedstats) {
        output('pass to plugins for destination email end');
    }
    foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
        $textmessage = $plugin->parseOutgoingTextMessage($messageid, $textmessage, $destinationemail, $userdata);
        $htmlmessage = $plugin->parseOutgoingHTMLMessage($messageid, $htmlmessage, $destinationemail, $userdata);
    }
    ## click tracking
    # for now we won't click track forwards, as they are not necessarily users, so everything would fail
    if (VERBOSE && $getspeedstats) {
        output('click track start');
    }
    if (CLICKTRACK && $hash != 'forwarded' && !empty($userdata['id'])) {
        $urlbase = '';
        # let's leave this for now
        /*
        if (preg_match('/<base href="(.*)"([^>]*)>/Umis',$htmlmessage,$regs)) {
          $urlbase = $regs[1];
        } else {
          $urlbase = '';
        }
        #    print "URLBASE: $urlbase<br/>";
        */
        # convert html message
        #    preg_match_all('/<a href="?([^> "]*)"?([^>]*)>(.*)<\/a>/Umis',$htmlmessage,$links);
        preg_match_all('/<a (.*)href=["\'](.*)["\']([^>]*)>(.*)<\\/a>/Umis', $htmlmessage, $links);
        # to process the Yahoo webpage with base href and link like <a href=link> we'd need this one
        #    preg_match_all('/<a href=([^> ]*)([^>]*)>(.*)<\/a>/Umis',$htmlmessage,$links);
        $clicktrack_root = sprintf('%s://%s/lt.php', $GLOBALS["public_scheme"], $website . $GLOBALS["pageroot"]);
        for ($i = 0; $i < count($links[2]); $i++) {
            $link = cleanUrl($links[2][$i]);
            $link = str_replace('"', '', $link);
            if (preg_match('/\\.$/', $link)) {
                $link = substr($link, 0, -1);
            }
            $linkid = 0;
            $linktext = $links[4][$i];
            ## if the link is text containing a "protocol" eg http:// then do not track it, otherwise
            ## it will look like Phishing
            ## it's ok when the link is an image
            $linktext = strip_tags($linktext);
            $looksLikePhishing = stripos($linktext, 'https://') !== false || stripos($linktext, 'http://') !== false;
            if (!$looksLikePhishing && (preg_match('/^http|ftp/', $link) || preg_match('/^http|ftp/', $urlbase)) && stripos($link, 'www.phplist.com') === false && !strpos($link, $clicktrack_root)) {
                # take off personal uids
                $url = cleanUrl($link, array('PHPSESSID', 'uid'));
                #        $url = preg_replace('/&uid=[^\s&]+/','',$link);
                #        if (!strpos('http:',$link)) {
                #          $link = $urlbase . $link;
                #        }
                $linkid = clickTrackLinkId($messageid, $userdata['id'], $url, $link);
                $masked = "H|{$linkid}|{$messageid}|" . $userdata['id'] ^ XORmask;
                $masked = base64_encode($masked);
                ## 15254- the encoding adds one or two extraneous = signs, take them off
                $masked = preg_replace('/=$/', '', $masked);
                $masked = preg_replace('/=$/', '', $masked);
                $masked = urlencode($masked);
                if (!CLICKTRACK_LINKMAP) {
                    $newlink = sprintf('<a %shref="%s://%s/lt.php?id=%s" %s>%s</a>', $links[1][$i], $GLOBALS["public_scheme"], $website . $GLOBALS["pageroot"], $masked, $links[3][$i], $links[4][$i]);
                } else {
                    $newlink = sprintf('<a %shref="%s://%s%s" %s>%s</a>', $links[1][$i], $GLOBALS["public_scheme"], $website . CLICKTRACK_LINKMAP, $masked, $links[3][$i], $links[4][$i]);
                }
                $htmlmessage = str_replace($links[0][$i], $newlink, $htmlmessage);
            }
        }
        # convert Text message
        # first find occurances of our top domain, to avoid replacing them later
        # hmm, this is no point, it's not just *our* topdomain, but any
        if (0) {
            preg_match_all('#(https?://' . $GLOBALS['website'] . '/?)\\s+#mis', $textmessage, $links);
            #    preg_match_all('#(https?://[a-z0-9\./\#\?&:@=%\-]+)#ims',$textmessage,$links);
            #    preg_match_all('!(https?:\/\/www\.[a-zA-Z0-9\.\/#~\?+=&%@-_]+)!mis',$textmessage,$links);
            for ($i = 0; $i < count($links[1]); $i++) {
                # not entirely sure why strtolower was used, but it seems to break things http://mantis.phplist.com/view.php?id=4406
                #      $link = strtolower(cleanUrl($links[1][$i]));
                $link = cleanUrl($links[1][$i]);
                if (preg_match('/\\.$/', $link)) {
                    $link = substr($link, 0, -1);
                }
                $linkid = 0;
                if (preg_match('/^http|ftp/', $link) && stripos($link, 'www.phplist.com') === false && !strpos($link, $clicktrack_root)) {
                    $url = cleanUrl($link, array('PHPSESSID', 'uid'));
                    $req = Sql_Query(sprintf('insert ignore into %s (messageid,userid,url,forward)
          values(%d,%d,"%s","%s")', $GLOBALS['tables']['linktrack'], $messageid, $userdata['id'], $url, $link));
                    $req = Sql_Fetch_Row_Query(sprintf('select linkid from %s where messageid = %s and userid = %d and forward = "%s"
        ', $GLOBALS['tables']['linktrack'], $messageid, $userdata['id'], $link));
                    $linkid = $req[0];
                    $masked = "T|{$linkid}|{$messageid}|" . $userdata['id'] ^ XORmask;
                    $masked = urlencode(base64_encode($masked));
                    $newlink = sprintf('%s://%s/lt.php?id=%s', $GLOBALS["public_scheme"], $website . $GLOBALS["pageroot"], $masked);
                    $textmessage = str_replace($links[0][$i], '<' . $newlink . '>', $textmessage);
                }
            }
        }
        #now find the rest
        # @@@ needs to expand to find complete urls like:
        #http://user:password@www.web-site.com:1234/document.php?parameter=something&otherpar=somethingelse#anchor
        # or secure
        #https://user:password@www.website.com:2345/document.php?parameter=something%20&otherpar=somethingelse#anchor
        preg_match_all('#(https?://[^\\s\\>\\}\\,]+)#mis', $textmessage, $links);
        #    preg_match_all('#(https?://[a-z0-9\./\#\?&:@=%\-]+)#ims',$textmessage,$links);
        #    preg_match_all('!(https?:\/\/www\.[a-zA-Z0-9\.\/#~\?+=&%@-_]+)!mis',$textmessage,$links);
        ## sort the results in reverse order, so that they are replaced correctly
        rsort($links[1]);
        $newlinks = array();
        for ($i = 0; $i < count($links[1]); $i++) {
            $link = cleanUrl($links[1][$i]);
            if (preg_match('/\\.$/', $link)) {
                $link = substr($link, 0, -1);
            }
            $linkid = 0;
            if (preg_match('/^http|ftp/', $link) && stripos($link, 'www.phplist.com') === false) {
                # && !strpos($link,$clicktrack_root)) {
                $url = cleanUrl($link, array('PHPSESSID', 'uid'));
                $linkid = clickTrackLinkId($messageid, $userdata['id'], $url, $link);
                $masked = "T|{$linkid}|{$messageid}|" . $userdata['id'] ^ XORmask;
                $masked = base64_encode($masked);
                ## 15254- the encoding adds one or two extraneous = signs, take them off
                $masked = preg_replace('/=$/', '', $masked);
                $masked = preg_replace('/=$/', '', $masked);
                $masked = urlencode($masked);
                if (!CLICKTRACK_LINKMAP) {
                    $newlinks[$linkid] = sprintf('%s://%s/lt.php?id=%s', $GLOBALS["public_scheme"], $website . $GLOBALS["pageroot"], $masked);
                } else {
                    $newlinks[$linkid] = sprintf('%s://%s%s', $GLOBALS["public_scheme"], $website . CLICKTRACK_LINKMAP, $masked);
                }
                #        print $links[0][$i] .' -> '.$newlink.'<br/>';
                $textmessage = str_replace($links[1][$i], '[%%%' . $linkid . '%%%]', $textmessage);
            }
        }
        foreach ($newlinks as $linkid => $newlink) {
            $textmessage = str_replace('[%%%' . $linkid . '%%%]', $newlink, $textmessage);
        }
    }
    if (VERBOSE && $getspeedstats) {
        output('click track end');
    }
    ## if we're not tracking clicks, we should add Google tracking here
    ## otherwise, we can add it when redirecting on the click
    if (!CLICKTRACK && !empty($cached[$messageid]['google_track'])) {
        preg_match_all('/<a (.*)href=["\'](.*)["\']([^>]*)>(.*)<\\/a>/Umis', $htmlmessage, $links);
        for ($i = 0; $i < count($links[2]); $i++) {
            $link = cleanUrl($links[2][$i]);
            $link = str_replace('"', '', $link);
            ## http://www.google.com/support/analytics/bin/answer.py?hl=en&answer=55578
            $trackingcode = 'utm_source=emailcampaign' . $messageid . '&utm_medium=phpList&utm_content=HTML&utm_campaign=' . urlencode($cached[$messageid]["subject"]);
            ## take off existing tracking code, if found
            if (strpos($link, 'utm_medium') !== false) {
                $link = preg_replace('/utm_(\\w+)\\=[^&]+&/U', '', $link);
            }
            ## 16894 make sure to keep the fragment value at the end of the URL
            if (strpos($link, '#')) {
                list($tmplink, $fragment) = explode('#', $link);
                $link = $tmplink;
                unset($tmplink);
                $fragment = '#' . $fragment;
            } else {
                $fragment = '';
            }
            if (strpos($link, '?')) {
                $newurl = $link . '&' . $trackingcode . $fragment;
            } else {
                $newurl = $link . '?' . $trackingcode . $fragment;
            }
            #   print $link. ' '.$newurl.' <br/>';
            $newlink = sprintf('<a %shref="%s" %s>%s</a>', $links[1][$i], $newurl, $links[3][$i], $links[4][$i]);
            $htmlmessage = str_replace($links[0][$i], $newlink, $htmlmessage);
        }
        preg_match_all('#(https?://[^\\s\\>\\}\\,]+)#mis', $textmessage, $links);
        rsort($links[1]);
        $newlinks = array();
        for ($i = 0; $i < count($links[1]); $i++) {
            $link = cleanUrl($links[1][$i]);
            if (preg_match('/\\.$/', $link)) {
                $link = substr($link, 0, -1);
            }
            if (preg_match('/^http|ftp/', $link) && stripos($link, 'www.phplist.com') !== 0) {
                # && !strpos($link,$clicktrack_root)) {
                $url = cleanUrl($link, array('PHPSESSID', 'uid'));
                $trackingcode = 'utm_source=emailcampaign' . $messageid . '&utm_medium=phpList&utm_content=text&utm_campaign=' . urlencode($cached[$messageid]["subject"]);
                ## take off existing tracking code, if found
                if (strpos($link, 'utm_medium') !== false) {
                    $link = preg_replace('/utm_(\\w+)\\=[^&]+/', '', $link);
                }
                ## 16894 make sure to keep the fragment value at the end of the URL
                if (strpos($link, '#')) {
                    list($tmplink, $fragment) = explode('#', $link);
                    $link = $tmplink;
                    unset($tmplink);
                    $fragment = '#' . $fragment;
                } else {
                    $fragment = '';
                }
                if (strpos($link, '?')) {
                    $newurl = $link . '&' . $trackingcode . $fragment;
                } else {
                    $newurl = $link . '?' . $trackingcode . $fragment;
                }
                $newlinks[$i] = $newurl;
                $textmessage = str_replace($links[1][$i], '[%%%' . $i . '%%%]', $textmessage);
            }
        }
        foreach ($newlinks as $linkid => $newlink) {
            $textmessage = str_replace('[%%%' . $linkid . '%%%]', $newlink, $textmessage);
        }
        unset($newlinks);
    }
    #  print htmlspecialchars($htmlmessage);exit;
    #0011996: forward to friend - personal message
    if (FORWARD_PERSONAL_NOTE_SIZE && $hash == 'forwarded' && !empty($forwardedby['personalNote'])) {
        $htmlmessage = nl2br($forwardedby['personalNote']) . '<br/>' . $htmlmessage;
        $textmessage = $forwardedby['personalNote'] . "\n" . $textmessage;
    }
    if (VERBOSE && $getspeedstats) {
        output('cleanup start');
    }
    ## allow fallback to default value for the ones that do not have a value
    ## delimiter is %% to avoid interfering with markup
    preg_match_all('/\\[.*\\%\\%([^\\]]+)\\]/Ui', $htmlmessage, $matches);
    for ($i = 0; $i < count($matches[0]); $i++) {
        $htmlmessage = str_ireplace($matches[0][$i], $matches[1][$i], $htmlmessage);
    }
    preg_match_all('/\\[.*\\%\\%([^\\]]+)\\]/Ui', $textmessage, $matches);
    for ($i = 0; $i < count($matches[0]); $i++) {
        $textmessage = str_ireplace($matches[0][$i], $matches[1][$i], $textmessage);
    }
    ## remove any remaining placeholders
    ## 16671 - do not do this, as it'll remove conditional CSS and other stuff
    ## that we'd like to keep
    //$htmlmessage = preg_replace("/\[[A-Z\. ]+\]/i","",$htmlmessage);
    //$textmessage = preg_replace("/\[[A-Z\. ]+\]/i","",$textmessage);
    #  print htmlspecialchars($htmlmessage);exit;
    # check that the HTML message as proper <head> </head> and <body> </body> tags
    # some readers fail when it doesn't
    if (!preg_match("#<body.*</body>#ims", $htmlmessage)) {
        $htmlmessage = '<body>' . $htmlmessage . '</body>';
    }
    if (!preg_match("#<head.*</head>#ims", $htmlmessage)) {
        if (!$adddefaultstyle) {
            $defaultstyle = "";
        }
        $htmlmessage = '<head>
        <meta content="text/html;charset=' . $cached[$messageid]["html_charset"] . '" http-equiv="Content-Type">
        <title></title>' . $defaultstyle . '</head>' . $htmlmessage;
    }
    if (!preg_match("#<html.*</html>#ims", $htmlmessage)) {
        $htmlmessage = '<html>' . $htmlmessage . '</html>';
    }
    ## remove trailing code after </html>
    $htmlmessage = preg_replace('#</html>.*#msi', '</html>', $htmlmessage);
    ## the editor sometimes places <p> and </p> around the URL
    $htmlmessage = str_ireplace('<p><!DOCTYPE', '<!DOCTYPE', $htmlmessage);
    $htmlmessage = str_ireplace('</html></p>', '</html>', $htmlmessage);
    if (VERBOSE && $getspeedstats) {
        output('cleanup end');
    }
    #  $htmlmessage = compressContent($htmlmessage);
    # print htmlspecialchars($htmlmessage);exit;
    if ($getspeedstats) {
        output('build Start ' . $GLOBALS['processqueue_timer']->interval(1));
    }
    # build the email
    $mail = new PHPlistMailer($messageid, $destinationemail);
    if ($forwardedby) {
        $mail->add_timestamp();
    }
    $mail->addCustomHeader("List-Help: <" . $text["preferences"] . ">");
    $mail->addCustomHeader("List-Unsubscribe: <" . $text["jumpoffurl"] . ">");
    $mail->addCustomHeader("List-Subscribe: <" . getConfig("subscribeurl") . ">");
    $mail->addCustomHeader("List-Owner: <mailto:" . getConfig("admin_address") . ">");
    list($dummy, $domaincheck) = explode('@', $destinationemail);
    $text_domains = explode("\n", trim(getConfig("alwayssendtextto")));
    if (in_array($domaincheck, $text_domains)) {
        $htmlpref = 0;
        if (VERBOSE) {
            output($GLOBALS['I18N']->get('sendingtextonlyto') . " {$domaincheck}");
        }
    }
    foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
        #    $textmessage = $plugin->parseOutgoingTextMessage($messageid,$textmessage,$destinationemail, $userdata);
        #    $htmlmessage = $plugin->parseOutgoingHTMLMessage($messageid,$htmlmessage,$destinationemail, $userdata);
        $plugin_attachments = $plugin->getMessageAttachment($messageid, $mail->Body);
        if (!empty($plugin_attachments[0]['content'])) {
            foreach ($plugins_attachments as $plugin_attachment) {
                $mail->add_attachment($plugin_attachment['content'], basename($plugin_attachment["filename"]), $plugin_attachment["mimetype"]);
            }
        }
    }
    # so what do we actually send?
    switch ($cached[$messageid]["sendformat"]) {
        case "PDF":
            # send a PDF file to users who want html and text to everyone else
            foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                $plugin->processSuccesFailure($messageid, 'astext', $userdata);
            }
            if ($htmlpref) {
                if (!$isTestMail) {
                    Sql_Query("update {$GLOBALS["tables"]["message"]} set aspdf = aspdf + 1 where id = {$messageid}");
                }
                $pdffile = createPdf($textmessage);
                if (is_file($pdffile) && filesize($pdffile)) {
                    $fp = fopen($pdffile, "r");
                    if ($fp) {
                        $contents = fread($fp, filesize($pdffile));
                        fclose($fp);
                        unlink($pdffile);
                        $html = '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
              <html>
              <head>
                <title></title>
              </head>
              <body>
              <embed src="message.pdf" width="450" height="450" href="message.pdf"></embed>
              </body>
              </html>';
                        #            $mail->add_html($html,$textmessage);
                        #            $mail->add_text($textmessage);
                        $mail->add_attachment($contents, "message.pdf", "application/pdf");
                    }
                }
                if (!addAttachments($messageid, $mail, "HTML")) {
                    return 0;
                }
            } else {
                if (!$isTestMail) {
                    Sql_Query("update {$GLOBALS["tables"]["message"]} set astext = astext + 1 where id = {$messageid}");
                }
                $mail->add_text($textmessage);
                if (!addAttachments($messageid, $mail, "text")) {
                    return 0;
                }
            }
            break;
        case "text and PDF":
            foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                $plugin->processSuccesFailure($messageid, 'astext', $userdata);
            }
            # send a PDF file to users who want html and text to everyone else
            if ($htmlpref) {
                if (!$isTestMail) {
                    Sql_Query("update {$GLOBALS["tables"]["message"]} set astextandpdf = astextandpdf + 1 where id = {$messageid}");
                }
                $pdffile = createPdf($textmessage);
                if (is_file($pdffile) && filesize($pdffile)) {
                    $fp = fopen($pdffile, "r");
                    if ($fp) {
                        $contents = fread($fp, filesize($pdffile));
                        fclose($fp);
                        unlink($pdffile);
                        $html = '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
              <html>
              <head>
                <title></title>
              </head>
              <body>
              <embed src="message.pdf" width="450" height="450" href="message.pdf"></embed>
              </body>
              </html>';
                        #           $mail->add_html($html,$textmessage);
                        $mail->add_text($textmessage);
                        $mail->add_attachment($contents, "message.pdf", "application/pdf");
                    }
                }
                if (!addAttachments($messageid, $mail, "HTML")) {
                    return 0;
                }
            } else {
                if (!$isTestMail) {
                    Sql_Query("update {$GLOBALS["tables"]["message"]} set astext = astext + 1 where id = {$messageid}");
                }
                $mail->add_text($textmessage);
                if (!addAttachments($messageid, $mail, "text")) {
                    return 0;
                }
            }
            break;
        case "text":
            # send as text
            foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                $plugin->processSuccesFailure($messageid, 'astext', $userdata);
            }
            if (!$isTestMail) {
                Sql_Query("update {$GLOBALS["tables"]["message"]} set astext = astext + 1 where id = {$messageid}");
            }
            $mail->add_text($textmessage);
            if (!addAttachments($messageid, $mail, "text")) {
                return 0;
            }
            break;
        case "both":
        case "text and HTML":
        case "HTML":
        default:
            $handled_by_plugin = 0;
            if (!empty($GLOBALS['pluginsendformats'][$cached[$messageid]["sendformat"]])) {
                # possibly handled by plugin
                $pl = $GLOBALS['plugins'][$GLOBALS['pluginsendformats'][$cached[$messageid]["sendformat"]]];
                if (is_object($pl) && method_exists($pl, 'parseFinalMessage')) {
                    $handled_by_plugin = $pl->parseFinalMessage($cached[$messageid]["sendformat"], $htmlmessage, $textmessage, $mail, $messageid);
                }
            }
            if (!$handled_by_plugin) {
                # send one big file to users who want html and text to everyone else
                if ($htmlpref) {
                    if (!$isTestMail) {
                        Sql_Query("update {$GLOBALS["tables"]["message"]} set astextandhtml = astextandhtml + 1 where id = {$messageid}");
                    }
                    foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                        $plugin->processSuccesFailure($messageid, 'ashtml', $userdata);
                    }
                    #  dbg("Adding HTML ".$cached[$messageid]["templateid"]);
                    if (WORDWRAP_HTML) {
                        ## wrap it: http://mantis.phplist.com/view.php?id=15528
                        ## some reports say, this fixes things and others say it breaks things https://mantis.phplist.com/view.php?id=15617
                        ## so for now, only switch on if requested.
                        ## it probably has to do with the MTA used
                        $htmlmessage = wordwrap($htmlmessage, WORDWRAP_HTML, "\r\n");
                    }
                    $mail->add_html($htmlmessage, $textmessage, $cached[$messageid]["templateid"]);
                    if (!addAttachments($messageid, $mail, "HTML")) {
                        return 0;
                    }
                } else {
                    if (!$isTestMail) {
                        Sql_Query("update {$GLOBALS["tables"]["message"]} set astext = astext + 1 where id = {$messageid}");
                    }
                    foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                        $plugin->processSuccesFailure($messageid, 'astext', $userdata);
                    }
                    $mail->add_text($textmessage);
                    #          $mail->setText($textmessage);
                    #          $mail->Encoding = TEXTEMAIL_ENCODING;
                    if (!addAttachments($messageid, $mail, "text")) {
                        return 0;
                    }
                }
            }
            break;
    }
    #  print htmlspecialchars($htmlmessage);exit;
    if (!TEST) {
        if ($hash != 'forwarded' || !sizeof($forwardedby)) {
            $fromname = $cached[$messageid]["fromname"];
            $fromemail = $cached[$messageid]["fromemail"];
            $subject = $cached[$messageid]["subject"];
        } else {
            $fromname = '';
            $fromemail = $forwardedby['email'];
            $subject = $GLOBALS['strFwd'] . ': ' . $cached[$messageid]["subject"];
        }
        if (!empty($cached[$messageid]["replytoemail"])) {
            $mail->AddReplyTo($cached[$messageid]["replytoemail"], $cached[$messageid]["replytoname"]);
        }
        if ($getspeedstats) {
            output('build End ' . $GLOBALS['processqueue_timer']->interval(1));
        }
        if ($getspeedstats) {
            output('send Start ' . $GLOBALS['processqueue_timer']->interval(1));
        }
        if (!empty($GLOBALS['developer_email'])) {
            $destinationemail = $GLOBALS['developer_email'];
        }
        $sendOK = false;
        if (!$mail->compatSend("", $destinationemail, $fromname, $fromemail, $subject)) {
            foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                $plugin->processSendFailed($messageid, $userdata, $isTestMail);
            }
            output(sprintf(s('Error sending message %d (%d/%d) to %s (%s) '), $messageid, $counters['batch_count'], $counters['batch_total'], $email, $destinationemail), 0);
        } else {
            $sendOK = true;
            foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                $plugin->processSendSuccess($messageid, $userdata, $isTestMail);
            }
        }
        if ($getspeedstats) {
            output('send End ' . $GLOBALS['processqueue_timer']->interval(1));
        }
        if (!empty($mail->mailsize)) {
            $sizename = $htmlpref ? 'htmlsize' : 'textsize';
            if (empty($cached[$messageid][$sizename])) {
                Sql_Replace($GLOBALS['tables']['messagedata'], array('id' => $messageid, 'name' => $sizename, 'data' => $mail->mailsize), array('name', 'id'));
                $cached[$messageid][$sizename] = $mail->mailsize;
                if (isset($cached[$messageid]['htmlsize'])) {
                    output(sprintf(s('Size of HTML email: %s ', formatBytes($cached[$messageid]['htmlsize']))), 0, 'progress');
                }
                if (isset($cached[$messageid]['textsize'])) {
                    output(sprintf(s('Size of Text email: %s ', formatBytes($cached[$messageid]['textsize']))), 0, 'progress');
                }
            }
        }
        if (defined('MAX_MAILSIZE') && isset($cached[$messageid]['htmlsize']) && $cached[$messageid]['htmlsize'] > MAX_MAILSIZE) {
            logEvent(s('Message too large (%s is over %s), suspending', $cached[$messageid]['htmlsize'], MAX_MAILSIZE));
            if ($isTestMail) {
                $_SESSION['action_result'] = s('Warning: the final message exceeds the sending limit, this campaign will fail sending. Reduce the size by removing attachments or images');
            } else {
                Sql_Query(sprintf('update %s set status = "suspended" where id = %d', $GLOBALS['tables']['message'], $messageid));
                logEvent(s('Campaign %d suspended. Message too large', $messageid));
                foreach ($GLOBALS['plugins'] as $pluginname => $plugin) {
                    $plugin->processError(s('Campaign %d suspended, message too large', $messageid));
                }
            }
        }
        $sqlCount = $GLOBALS["pagestats"]["number_of_queries"] - $sqlCountStart;
        if ($getspeedstats) {
            output('It took ' . $sqlCount . '  queries to send this message');
        }
        return $sendOK;
    }
    return 0;
}
Esempio n. 3
0
function getUserConfig($item, $userid = 0)
{
    global $default_config, $tables, $domain, $website;
    $hasconf = Sql_Table_Exists($tables["config"]);
    $value = '';
    if ($hasconf) {
        $query = 'select value,editable from ' . $tables['config'] . ' where item = ?';
        $req = Sql_Query_Params($query, array($item));
        if (!Sql_Num_Rows($req)) {
            if (array_key_exists($item, $default_config)) {
                $value = $default_config[$item]['value'];
            }
        } else {
            $row = Sql_fetch_Row($req);
            $value = $row[0];
            if ($row[1] == 0) {
                $GLOBALS['noteditableconfig'][] = $item;
            }
        }
    }
    # if this is a subpage item, and no value was found get the global one
    if (!$value && strpos($item, ":") !== false) {
        list($a, $b) = explode(":", $item);
        $value = getUserConfig($a, $userid);
    }
    if ($userid) {
        $query = 'select uniqid, email from ' . $tables['user'] . ' where id = ?';
        $rs = Sql_Query_Params($query, array($userid));
        $user_req = Sql_Fetch_Row($rs);
        $uniqid = $user_req[0];
        $email = $user_req[1];
        # parse for placeholders
        # do some backwards compatibility:
        # hmm, reverted back to old system
        $url = getConfig("unsubscribeurl");
        $sep = strpos($url, '?') !== false ? '&' : '?';
        $value = str_ireplace('[UNSUBSCRIBEURL]', $url . $sep . 'uid=' . $uniqid, $value);
        $url = getConfig("confirmationurl");
        $sep = strpos($url, '?') !== false ? '&' : '?';
        $value = str_ireplace('[CONFIRMATIONURL]', $url . $sep . 'uid=' . $uniqid, $value);
        $url = getConfig("preferencesurl");
        $sep = strpos($url, '?') !== false ? '&' : '?';
        $value = str_ireplace('[PREFERENCESURL]', $url . $sep . 'uid=' . $uniqid, $value);
        $value = str_ireplace('[EMAIL]', $email, $value);
        $value = parsePlaceHolders($value, getUserAttributeValues($email));
    }
    $value = str_ireplace('[SUBSCRIBEURL]', getConfig("subscribeurl"), $value);
    $value = preg_replace('/\\[DOMAIN\\]/i', $domain, $value);
    #@ID Should be done only in one place. Combine getConfig and this one?
    $value = preg_replace('/\\[WEBSITE\\]/i', $website, $value);
    if ($value == "0") {
        $value = "false";
    } elseif ($value == "1") {
        $value = "true";
    }
    return $value;
}
Esempio n. 4
0
     Warn("Record has more values than header indicated (" . sizeof($values) . "!=" . (sizeof($_SESSION["import_attribute"]) + sizeof($system_attributes) - sizeof($unused_systemattr)) . "), this may cause trouble: {$index}");
 }
 if (!$invalid || $invalid && $_SESSION["omit_invalid"] != "yes") {
     $user["systemvalues"] = $system_values;
     reset($_SESSION["import_attribute"]);
     $replace = array();
     while (list($key, $val) = each($_SESSION["import_attribute"])) {
         if (!empty($values[$val["index"]])) {
             $user[$val["index"]] = addslashes($values[$val["index"]]);
             $replace[$key] = addslashes($values[$val["index"]]);
         }
     }
 } else {
     # Warn("Omitting invalid one: $email");
 }
 $user["systemvalues"]["email"] = parsePlaceHolders($system_values["email"], array_merge($replace, $system_values, array("number" => $c)));
 $user["systemvalues"]["email"] = cleanEmail($user["systemvalues"]["email"]);
 $c++;
 if (!isset($user["systemvalues"]["htmlemail"])) {
     $user["systemvalues"]["htmlemail"] = 1;
 }
 if ($_SESSION["test_import"]) {
     #      var_dump($user["systemvalues"]);exit;
     $html = '';
     foreach ($user["systemvalues"] as $column => $value) {
         if (strpos($column, 'grouptype_') === 0) {
             if (isset($system_attributes[$column])) {
                 $column = $system_attributes[$column];
             }
         }
         if (!empty($column)) {
 /**
  * Generate the html content of the email customised for the user.
  *
  * @param int     $mid             the message id
  * @param int     $uid             the user unique id
  * @param Closure $contentProvider function to provide the message content
  *
  * @return string the generated html
  */
 public function createContent($mid, $uid, \Closure $contentProvider = null)
 {
     global $PoweredByText, $PoweredByImage, $MD;
     $row = $this->dao->message($mid);
     if (!$row) {
         return s('Message with id %d does not exist', $mid);
     }
     $personalise = $uid !== '';
     if ($personalise) {
         $user = $this->dao->userByUniqid($uid);
         if (!$user) {
             return s('User with uid %s does not exist', $uid);
         }
         $attributeValues = $this->dao->getUserAttributeValues($user['email']);
     } else {
         $user = array('email' => '', 'uniqid' => '');
         $attributeValues = array();
         foreach ($this->daoAttr->attributes() as $k => $v) {
             $attributeValues[$v['name']] = '';
         }
     }
     $callPlugins = $this->pluginsToCall();
     $message = $this->dao->loadMessageData($mid);
     $styles = '';
     $templateBody = $row['template'];
     if ($templateBody) {
         $templateBody = stripslashes($templateBody);
     }
     if ($message['sendmethod'] == 'remoteurl') {
         $content = $this->dao->fetchUrl($message['sendurl'], $user);
         if (!$content) {
             return s('Unable to retrieve URL %s', $message['sendurl']);
         }
     } else {
         foreach ($callPlugins as $plugin) {
             if (method_exists($plugin, 'viewBrowserHook')) {
                 $plugin->viewBrowserHook($templateBody, $message);
             }
         }
         $content = $message['message'];
         if ($templateBody) {
             $content = str_ireplace('[CONTENT]', $content, $templateBody);
         } else {
             $styles = trim(getConfig('html_email_style'));
         }
     }
     $content = $this->replaceFooter($content, $message['footer']);
     $content = $this->replaceSignature($content, EMAILTEXTCREDITS ? $PoweredByText : $PoweredByImage);
     $content = parsePlaceHolders($content, $user);
     $content = parsePlaceHolders($content, $attributeValues);
     $content = parsePlaceHolders($content, $this->systemPlaceholders($uid, $user['email'], $message));
     $content = $this->replaceUserTrack($content, $mid, $uid);
     if (count($attachments = $this->dao->attachments($mid)) > 0) {
         $content = addHTMLFooter($content, $this->addAttachments($attachments));
     }
     $destinationEmail = $user['email'];
     foreach ($callPlugins as $plugin) {
         $destinationEmail = $plugin->setFinalDestinationEmail($mid, $attributeValues, $destinationEmail);
     }
     foreach ($callPlugins as $plugin) {
         $content = $plugin->parseOutgoingHTMLMessage($mid, $content, $destinationEmail, $user);
     }
     $doc = new ContentDocument($content, $this->dao, $this->rootUrl);
     if ($message['template'] != 0) {
         $doc->addTemplateImages($mid, $message['template']);
     }
     if (CLICKTRACK && $personalise) {
         $doc->addLinkTrack($mid, $user);
     }
     $doc->addTitle($message['subject'], $styles);
     return $doc->toHtml();
 }
Esempio n. 6
0
     Warn('Record has more values than header indicated (' . count($values) . '!=' . (count($_SESSION['import_attribute']) + count($system_attributes) - count($unused_systemattr)) . "), this may cause trouble: {$index}");
 }
 if (!$invalid || $invalid && $_SESSION['omit_invalid'] != 'yes') {
     $user['systemvalues'] = $system_values;
     reset($_SESSION['import_attribute']);
     $replace = array();
     while (list($key, $val) = each($_SESSION['import_attribute'])) {
         if (!empty($values[$val['index']])) {
             $user[$val['index']] = addslashes($values[$val['index']]);
             $replace[$key] = addslashes($values[$val['index']]);
         }
     }
 } else {
     # Warn("Omitting invalid one: $email");
 }
 $user['systemvalues']['email'] = parsePlaceHolders($system_values['email'], array_merge($replace, $system_values, array('number' => $c)));
 $user['systemvalues']['email'] = cleanEmail($user['systemvalues']['email']);
 ++$c;
 if (!isset($user['systemvalues']['htmlemail'])) {
     $user['systemvalues']['htmlemail'] = 1;
 }
 if ($_SESSION['test_import']) {
     #      var_dump($user["systemvalues"]);exit;
     $html = '';
     foreach ($user['systemvalues'] as $column => $value) {
         if (strpos($column, 'grouptype_') === 0) {
             if (isset($system_attributes[$column])) {
                 $column = $system_attributes[$column];
             }
         }
         if (!empty($column)) {