function Run_UserQuery($query) { global $DB_ResponderID, $DB_ResponderName, $DB_OwnerEmail; global $DB_OwnerName, $DB_ReplyToEmail, $DB_MsgList, $DB_LastActivity; global $DB_result, $DB_LinkID, $DB_ResponderDesc, $DB_RespEnabled; global $Responder_ID, $action, $SearchCount; global $Search_EmailAddress, $Subscriber_ID, $SubsPerPage; global $DB_FirstName, $DB_LastName, $DB_IPaddy, $DB_Real_TimeJoined; if ($SubsPerPage != 0) { $Limitedquery = $query . " LIMIT {$SearchCount}, {$SubsPerPage}"; } else { $Limitedquery = $query; } $DB_MaxList_result = mysql_query($query) or die("Invalid query: " . mysql_error()); $DB_search_result = mysql_query($Limitedquery) or die("Invalid query: " . mysql_error()); $Max_Results_Count = mysql_num_rows($DB_MaxList_result) - 1; # MOD display message if any if ($_SESSION['inf_resp'] != '') { inf_resp_message_box($_SESSION['inf_resp']); unset($_SESSION['inf_resp']); } if (mysql_num_rows($DB_search_result) > 0) { # User top template $alt = FALSE; include 'templates/listuser_top.admin.php'; # Display the rows while ($search_query_result = mysql_fetch_assoc($DB_search_result)) { $DB_SubscriberID = $search_query_result['SubscriberID']; $DB_ResponderID = $search_query_result['ResponderID']; $DB_SentMsgs = $search_query_result['SentMsgs']; $DB_EmailAddress = $search_query_result['EmailAddress']; $DB_TimeJoined = $search_query_result['TimeJoined']; $DB_Real_TimeJoined = $search_query_result['Real_TimeJoined']; $CanReceiveHTML = $search_query_result['CanReceiveHTML']; $DB_LastActivity = $search_query_result['LastActivity']; $DB_FirstName = $search_query_result['FirstName']; $DB_LastName = $search_query_result['LastName']; $DB_IPaddy = $search_query_result['IP_Addy']; $DB_ReferralSource = $search_query_result['ReferralSource']; $DB_UniqueCode = $search_query_result['UniqueCode']; $DB_Confirmed = $search_query_result['Confirmed']; $Responder_ID = $DB_ResponderID; if (!ResponderExists($Responder_ID)) { admin_redirect(); } $ResponderInfo = GetResponderInfo($Responder_ID); # User row template $alt = !$alt; include 'templates/listuser_row.admin.php'; } # List bottom template include 'templates/listuser_bottom.admin.php'; if ($SubsPerPage != 0) { $Search_Count_BackStr = $SearchCount - $SubsPerPage; $Search_Count_ForwardStr = $SearchCount + $SubsPerPage; if ($Search_Count_BackStr < 0) { $Search_Count_BackStr = 0; } if ($Search_Count_ForwardStr > $Max_Results_Count) { $Search_Count_ForwardStr = $Max_Results_Count; } # Back and forward buttons include 'templates/back_forward.admin.php'; } # Add new user button include 'templates/addnew_button.admin.php'; } else { if (!ResponderExists($Responder_ID)) { admin_redirect(); } $ResponderInfo = GetResponderInfo($Responder_ID); $DB_ResponderName = $ResponderInfo['Name']; print "<br><center><font size=\"3\" color=\"#330000\">No subscriber(s) found for Responder '" . $DB_ResponderName . "'.</font></center><br>\n"; print "<br>\n"; # Add new user button include 'templates/addnew_button.admin.php'; } # Back button // print "<br> \n"; // print "<font size=\"4\" color=\"#666666\">Back to Main:</font><br>\n"; $return_action = "list"; include 'templates/back_button.admin.php'; }
} else { $spam_filtered = 1; } } if (!UserIsSubscribed($Responder_ID, $Email_Address) && !isInBlacklist($Email_Address) && $spam_filtered == 0 && isEmail($Email_Address)) { if ($DB_HTML_YN == 1) { $Set_HTML = 1; } else { $Set_HTML = 0; } # Get responder info # MOD for updated GetResponder function if (!ResponderExists($Responder_ID)) { admin_redirect(); } $ResponderInfo = GetResponderInfo($Responder_ID); // $DB_OptMethod = $ResponderInfo['OptinMethod']; // if ($DB_OptMethod == "Double") {$DB_Confirm_Join = '1'} // else {$DB_Confirm_Join = '0';} # Setup the data $DB_ResponderID = $Responder_ID; $DB_SentMsgs = ''; $DB_EmailAddress = $Email_Address; $DB_TimeJoined = time(); $DB_Real_TimeJoined = time(); $CanReceiveHTML = $Set_HTML; $DB_LastActivity = time(); $DB_FirstName = $FirstName; $DB_LastName = $LastName; $DB_IPaddy = $IPaddy; $DB_ReferralSource = "email join";
function ProcessMessageTags($MessageInfo, $SubscriberInfo) { global $MySQL_server, $MySQL_user, $MySQL_password, $MySQL_database; global $DB_LinkID, $cop, $newline, $blahtest, $table_prefix, $siteURL; $Responder_ID = $MessageInfo['ResponderID']; $Send_Subject = $MessageInfo['Subject']; $DB_MsgBodyHTML = $MessageInfo['BodyHTML']; $DB_MsgBodyText = $MessageInfo['BodyText']; // print_r($MessageInfo); // echo "<br>"; $ResponderInfo = GetResponderInfo($Responder_ID); // print_r($ResponderInfo); // echo "<br>"; $DB_ResponderName = $ResponderInfo['Name']; $DB_RespEnabled = $ResponderInfo['Enabled']; $DB_ResponderDesc = $ResponderInfo['Description']; $DB_OwnerEmail = $ResponderInfo['FromEmail']; $DB_OwnerName = $ResponderInfo['FromName']; $DB_ReplyToEmail = $ResponderInfo['ReplyEmail']; $DB_ResponderDesc = $ResponderInfo['Description']; $DB_MsgList = $ResponderInfo['MessageList']; $DB_OptMethod = $ResponderInfo['OptMethod']; $DB_OptInRedir = $ResponderInfo['OptinRedir']; $DB_OptOutRedir = $ResponderInfo['OptoutRedir']; $DB_OptInDisplay = $ResponderInfo['OptinDisp']; $DB_OptOutDisplay = $ResponderInfo['OptinDisp']; $DB_NotifyOnSub = $ResponderInfo['NotifyOnSub']; $DB_EmailAddress = $SubscriberInfo['EmailAddress']; $DB_SubscriberID = $SubscriberInfo['SubscriberID']; $DB_SentMsgs = $SubscriberInfo['SentMsgs']; $CanReceiveHTML = $SubscriberInfo['CanReceiveHTML']; $DB_TimeJoined = $SubscriberInfo['TimeJoined']; $DB_Real_TimeJoined = $SubscriberInfo['Real_TimeJoined']; $DB_LastActivity = $SubscriberInfo['LastActivity']; $DB_FirstName = $SubscriberInfo['FirstName']; $DB_LastName = $SubscriberInfo['LastName']; $DB_IPaddy = $SubscriberInfo['IP_Addy']; $DB_ReferralSource = $SubscriberInfo['ReferralSource']; $DB_UniqueCode = $SubscriberInfo['UniqueCode']; $DB_Confirmed = $SubscriberInfo['Confirmed']; // print_r($SubscriberInfo); // echo "<br>"; # MOD New Address Field $infrespaddress = get_option('inf_resp_address'); $infrespaddresshtml = str_replace(PHP_EOL, '<br>', $infrespaddress); $Pattern = '/%address%/i'; $DB_MsgBodyText = preg_replace($Pattern, $infrespaddress, $DB_MsgBodyText); $DB_MsgBodyHTML = preg_replace($Pattern, $infrespaddresshtml, $DB_MsgBodyHTML); # MOD New Signature Field $infrespsignature = get_option('inf_resp_signature'); $infrespsignaturehtml = str_replace(PHP_EOL, '<br>', $infrespaddress); $Pattern = '/%signature%/i'; $DB_MsgBodyText = preg_replace($Pattern, $infrespsignature, $DB_MsgBodyText); $DB_MsgBodyHTML = preg_replace($Pattern, $infrespsignaturehtml, $DB_MsgBodyHTML); # Wednesday May 9, 2007 # $date_format = 'l \t\h\e jS \of F\, Y'; $date_format = 'F j\\, Y'; if (is_numeric($DB_Real_TimeJoined)) { $Joined_Month = date("F", $DB_Real_TimeJoined); $Joined_MonthNum = date("n", $DB_Real_TimeJoined); $Joined_Year = date("Y", $DB_Real_TimeJoined); $Joined_Day = date("d", $DB_Real_TimeJoined); } else { $Joined_Month = "-=-Joined Month-=-"; $Joined_MonthNum = "-=-Joined Month Num-=-"; $Joined_Year = "-=-Joined Year-=-"; $Joined_Day = "-=-Joined Day-=-"; } if (is_numeric($DB_LastActivity)) { $LastActive_Month = date("F", $DB_LastActivity); $LastActive_MonthNum = date("n", $DB_LastActivity); $LastActive_Year = date("Y", $DB_LastActivity); $LastActive_Day = date("d", $DB_LastActivity); } else { $LastActive_Month = "-=-Last Active Month-=-"; $LastActive_MonthNum = "-=-Last Active Month Num-=-"; $LastActive_Year = "-=-Last Active Year-=-"; $LastActive_Day = "-=-Last Active Day-=-"; } $Pattern = '/%msg_subject%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_MsgSub, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_MsgSub, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_MsgSub, $Send_Subject); $unsubcode = "u" . $DB_UniqueCode; $UnsubURL = $siteURL . "/?infresp=s&c=" . $unsubcode; // echo "Unsub URL: ".$UnsubURL."<br>\n"; $UnsubMSG_HTML = "{$newline}<br><br>------------------------------------------------<br>{$newline}"; $UnsubMSG_HTML .= "<A HREF=\"{$UnsubURL}\">Unsubscribe</A><br>{$newline}"; if ($cop != TRUE) { $UnsubMSG_HTML .= "Powered by <A HREF=\"http://pluginreview.net/wordpress-plugins/wp-infinity-responder\">WP Infinity Responder</A><br>{$newline}"; } $UnsubMSG_Text = "{$newline}------------------------------------------------{$newline}"; $UnsubMSG_Text .= "Unsubscribe: {$UnsubURL} {$newline}"; if ($cop != TRUE) { $UnsubMSG_Text .= "Powered by WP Infinity Responder. {$newline}"; } $Unsub_Pattern = '/%unsub_msg%/i'; $DB_MsgBodyHTML = preg_replace($Unsub_Pattern, $UnsubMSG_HTML, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Unsub_Pattern, $UnsubMSG_Text, $DB_MsgBodyText); # MOD New tag for unsub link only $Unsub_Link_Pattern = '/%unsub_link%/i'; $DB_MsgBodyHTML = preg_replace($Unsub_Link_Pattern, $UnsubURL, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Unsub_Link_Pattern, $UnsubURL, $DB_MsgBodyText); $Pattern = '/%RespDir%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $ResponderDirectory, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $ResponderDirectory, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $ResponderDirectory, $Send_Subject); $Pattern = '/%SiteURL%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, "<A HREF=\"{$siteURL}\">{$siteURL}</A>", $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $siteURL, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $siteURL, $Send_Subject); $Pattern = '/%subr_id%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_SubscriberID, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_SubscriberID, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_SubscriberID, $Send_Subject); $Pattern = '/%subr_emailaddy%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_EmailAddress, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_EmailAddress, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_EmailAddress, $Send_Subject); $Pattern = '/%subr_firstname%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_FirstName, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_FirstName, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_FirstName, $Send_Subject); $Pattern = '/%subr_lastname%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_LastName, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_LastName, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_LastName, $Send_Subject); $Pattern = '/%subr_firstname_fix%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, my_ucwords($DB_FirstName), $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, my_ucwords($DB_FirstName), $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, my_ucwords($DB_FirstName), $Send_Subject); # MOD %firstname% tag, copy of subr_firstname_fix for convenience $Pattern = '/%firstname%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, my_ucwords($DB_FirstName), $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, my_ucwords($DB_FirstName), $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, my_ucwords($DB_FirstName), $Send_Subject); $Pattern = '/%subr_lastname_fix%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, my_ucwords($DB_LastName), $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, my_ucwords($DB_LastName), $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, my_ucwords($DB_LastName), $Send_Subject); $Pattern = '/%subr_ipaddy%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_IPaddy, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_IPaddy, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_IPaddy, $Send_Subject); $Pattern = '/%subr_referralsource%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_ReferralSource, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_ReferralSource, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_ReferralSource, $Send_Subject); $Pattern = '/%resp_ownername%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_OwnerName, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_OwnerName, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_OwnerName, $Send_Subject); $Pattern = '/%resp_owneremail%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_OwnerEmail, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_OwnerEmail, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_OwnerEmail, $Send_Subject); $Pattern = '/%resp_replyto%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_ReplyToEmail, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_ReplyToEmail, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_ReplyToEmail, $Send_Subject); $Pattern = '/%resp_name%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_ResponderName, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_ResponderName, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_ResponderName, $Send_Subject); $Pattern = '/%resp_desc%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_ResponderDesc, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_ResponderDesc, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_ResponderDesc, $Send_Subject); $Pattern = '/%resp_optinredir%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_OptInRedir, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_OptInRedir, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_OptInRedir, $Send_Subject); $Pattern = '/%resp_optoutredir%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_OptOutRedir, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_OptOutRedir, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_OptOutRedir, $Send_Subject); $Pattern = '/%resp_optindisplay%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_OptInDisplay, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_OptInDisplay, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_OptInDisplay, $Send_Subject); $Pattern = '/%resp_optoutdisplay%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_OptOutDisplay, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_OptOutDisplay, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_OptOutDisplay, $Send_Subject); $Pattern = '/%Subr_UniqueCode%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $DB_UniqueCode, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $DB_UniqueCode, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $DB_UniqueCode, $Send_Subject); $Pattern = '/%Subr_JoinedMonthNum%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $Joined_MonthNum, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $Joined_MonthNum, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $Joined_MonthNum, $Send_Subject); $Pattern = '/%Subr_JoinedMonth%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $Joined_Month, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $Joined_Month, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $Joined_Month, $Send_Subject); $Pattern = '/%Subr_JoinedYear%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $Joined_Year, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $Joined_Year, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $Joined_Year, $Send_Subject); $Pattern = '/%Subr_JoinedDay%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $Joined_Day, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $Joined_Day, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $Joined_Day, $Send_Subject); $Pattern = '/%Subr_LastActiveMonthNum%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $LastActive_MonthNum, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $LastActive_MonthNum, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $LastActive_MonthNum, $Send_Subject); $Pattern = '/%Subr_LastActiveMonth%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $LastActive_Month, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $LastActive_Month, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $LastActive_Month, $Send_Subject); $Pattern = '/%Subr_LastActiveYear%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $LastActive_Year, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $LastActive_Year, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $LastActive_Year, $Send_Subject); $Pattern = '/%Subr_LastActiveDay%/i'; $DB_MsgBodyHTML = preg_replace($Pattern, $LastActive_Day, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $LastActive_Day, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $LastActive_Day, $Send_Subject); $Pattern = '/%date_today%/i'; $the_date = date($date_format, strtotime("today")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%date_yesterday%/i'; $the_date = date($date_format, strtotime("yesterday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%date_tomorrow%/i'; $the_date = date($date_format, strtotime("tomorrow")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_monday%/i'; $the_date = date($date_format, strtotime("next monday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_tuesday%/i'; $the_date = date($date_format, strtotime("next tuesday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_wednesday%/i'; $the_date = date($date_format, strtotime("next wednesday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_thursday%/i'; $the_date = date($date_format, strtotime("next thursday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_friday%/i'; $the_date = date($date_format, strtotime("next friday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_saturday%/i'; $the_date = date($date_format, strtotime("next saturday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); $Pattern = '/%next_sunday%/i'; $the_date = date($date_format, strtotime("next sunday")); $DB_MsgBodyHTML = preg_replace($Pattern, $the_date, $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $the_date, $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $the_date, $Send_Subject); # ------------------------- # Custom fields $infrespcustomfields = $table_prefix . 'InfResp_customfields'; $query = "SELECT * FROM " . $infrespcustomfields . " WHERE user_attached = '{$DB_SubscriberID}' LIMIT 1"; $result = mysql_query($query, $DB_LinkID) or die("Invalid query: " . mysql_error()); if (mysql_num_rows($result) > 0) { $data = mysql_fetch_assoc($result); foreach ($data as $name => $value) { $Pattern = "/%cf_{$name}%/i"; $DB_MsgBodyHTML = preg_replace($Pattern, $data[$name], $DB_MsgBodyHTML); $DB_MsgBodyText = preg_replace($Pattern, $data[$name], $DB_MsgBodyText); $Send_Subject = preg_replace($Pattern, $data[$name], $Send_Subject); } } $message['BodyText'] = $DB_MsgBodyText; $message['BodyHTML'] = $DB_MsgBodyHTML; $message['Subject'] = $Send_Subject; return $message; }