Smart Mailer PHP Support Product Page
This topic was archived
Dynamic File
Asked 11 May 2005 20:12:24
1
has this question
11 May 2005 20:12:24 Jeff Montgomery posted:
I am not sure how I can add a HTML to the body of the email dynamically. I have a category table, newslettermember table and a file table.Category
----------
CategoryKey
category
NewsletterMembers
---------------------
NewletterKey
CategoryKey
Name
NewsletterHTML
-----------------
NesletterHTMLKey
CategoryKey
HTMLfile
* the HTMLfile is the name of the file but the actual file is located on the server ../HTMLfile/
I can use this SQL to get the info I need:
SELECT
`category`.`Category`,
`newslettermembers`.`Name`,
`newslettermembers`.`Email`,
`newsletterhtml`.`HTMLFile`
FROM
`category`
INNER JOIN `newslettermembers` ON (`category`.`CategoryKey` = `newslettermembers`.`CategoryKey`)
INNER JOIN `newsletterhtml` ON (`newslettermembers`.`CategoryKey` = `newsletterhtml`.`CategoryKey`)
WHERE
(`category`.`CategoryKey` = colname)
colname = categorykey
This gives me
Category Name of person emailaddress of person and the file name
Thanks for the help
Replies
Replied 13 May 2005 17:54:42
13 May 2005 17:54:42 Jeff Montgomery replied:
ok no response. Is there another way to do this?
Replied 24 Feb 2007 03:35:15
24 Feb 2007 03:35:15 Mat p replied:
I to are having the same trouble. is there a solution. after spending good money you would think there would be someone from design team answering questions. Please help.
Replied 26 Feb 2007 17:48:44
26 Feb 2007 17:48:44 Georgi Kralev replied:
Hi Jeff,
1. Select Template option from the Content page of Smart Mailer dialog window.
2. Browse one of your HTML files.
3. Check the following line: $sm1->setBody_Template_html
As parameter of the method should be send the string containing the file that you have browsed.
4. Delete from the string the filename (leave only the path) And concatenate to it the value for the HTMLFile from your database:
For example the resulting line could look like this:
$sm1->setBody_Template_html("../HTMLfile/".$row_Recordset1['HTMLFile']);
I hope this help you.
Regards,
Georgi Kralev
----------------------------------
Support - www.DMXzone.com
1. Select Template option from the Content page of Smart Mailer dialog window.
2. Browse one of your HTML files.
3. Check the following line: $sm1->setBody_Template_html
As parameter of the method should be send the string containing the file that you have browsed.
4. Delete from the string the filename (leave only the path) And concatenate to it the value for the HTMLFile from your database:
For example the resulting line could look like this:
$sm1->setBody_Template_html("../HTMLfile/".$row_Recordset1['HTMLFile']);
I hope this help you.
Regards,
Georgi Kralev
----------------------------------
Support - www.DMXzone.com
Replied 20 Mar 2007 13:21:55
20 Mar 2007 13:21:55 Mat p replied:
i to have a problem with this. i have already created a newsletter with this and worked. i am now creating one that emails only on person at a time. my problem is i get there name email from 1 recordset and the data entered in another, it emails but no content show.
i have tried the following
SELECT `form`.userID, `form`.added_by, `form`.email, price.ID, price.added_by, price.price_from, price.price_to, price.comments
FROM `form`
INNER JOIN price
ON `form`.userID = price.ID
i have tried the following
SELECT `form`.userID, `form`.added_by, `form`.email, price.ID, price.added_by, price.price_from, price.price_to, price.comments
FROM `form`
INNER JOIN price
ON `form`.userID = price.ID
Replied 20 Mar 2007 16:07:24
20 Mar 2007 16:07:24 Georgi Kralev replied:
Hi Mat p,
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>my problem is i get there name email from 1 recordset and the data entered in another, it emails but no content show <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
It looks like the problem is with your sql statement. Which column from the select statement contains the emails content?
Before using Smart Mailer PHP make sure that your select statement is correct and emails content column contains the required value.
Regards,
Georgi Kralev
----------------------------------
Support - www.DMXzone.com
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>my problem is i get there name email from 1 recordset and the data entered in another, it emails but no content show <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
It looks like the problem is with your sql statement. Which column from the select statement contains the emails content?
Before using Smart Mailer PHP make sure that your select statement is correct and emails content column contains the required value.
Regards,
Georgi Kralev
----------------------------------
Support - www.DMXzone.com
Replied 21 Mar 2007 01:13:55
21 Mar 2007 01:13:55 Mat p replied:
These are the details i want to show on each reply by single email "price.added_by, price.price_from, price.price_to, price.comments", but i want to then have the results match and be displayed for each user ID, at the moment all it is doing is sending the last data entered into the database. SELECT * FROM price ORDER BY ID DESC
Replied 21 Mar 2007 12:15:02
21 Mar 2007 12:15:02 Georgi Kralev replied:
If I understand you right you want to include the following values in your emails: "price.added_by, price.price_from, price.price_to, price.comments".
How this will be done depend on the type of Body that you use:
1. For example if you use Template:
Your template should be php and you will have to pass the values from your record as URL parameters.
And in your template you will have to _GET the values and generate the email text.
2. The other option is to be used Static text/html and in the body string to be added dynamically your values.
I hope this helps you.
Regards,
Georgi Kralev
----------------------------------
Support - www.DMXzone.com
How this will be done depend on the type of Body that you use:
1. For example if you use Template:
Your template should be php and you will have to pass the values from your record as URL parameters.
And in your template you will have to _GET the values and generate the email text.
2. The other option is to be used Static text/html and in the body string to be added dynamically your values.
I hope this helps you.
Regards,
Georgi Kralev
----------------------------------
Support - www.DMXzone.com
Replied 22 Mar 2007 01:27:22
22 Mar 2007 01:27:22 Mat p replied:
here is the 3 forms im using to process and to send the email, i have the info entering the database but no emails is sent
<pre id=code><font face=courier size=2 id=code>
-----------------page 1 start-----------------
if (!function_exists("GetSQLValueString"
) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string" ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "" ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "" ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset2 = "SELECT * FROM price ORDER BY ID DESC";
$Recordset2 = mysql_query($query_Recordset2, $conn_fra) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$colname_Recordset1 = "-1";
if (isset($_GET['userID'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['userID'] : addslashes($_GET['userID']);
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset1 = sprintf("SELECT * FROM `form` WHERE userID = %s", GetSQLValueString($colname_Recordset1, "int");
$Recordset1 = mysql_query($query_Recordset1, $conn_fra) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
// Buzz inet PHPLS03 - Check User Session is set
session_start();
if(!isset($HTTP_SESSION_VARS['usersession'])){
header("Location: ../login.php";
////// Logout Section. Delete all session variable.
session_destroy();
$message="";
}
?><?php
$cust_name = htmlentities($_POST['userID']);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administration</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<link href="../css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="20" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="91"><img src="images/logo.gif" width="600" height="127" /></td>
<td width="22"> </td>
</tr>
<tr>
<td colspan="2"><table width="781" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="right" class="BlueWhiteHeader">AGENT ADMINISTRATION </div></td>
</tr>
<tr>
<td colspan="2"> </td>
<td width="668" class="text">Hello <strong><? echo $_SESSION['usersession']; ?>! </strong>You are now Logged in. </td>
<td class="text"><div align="right"><a href="../default.php" class="textLink">Logout</a></div></td>
<td width="22"> </td>
</tr>
<tr>
<td width="81" valign="top"><a href="default.php" class="textLink">Home</a></td>
<td width="10"> </td>
<td colspan="2"><!-- InstanceBeginEditable name="body" -->
<p class="text"> </p>
<form name="form1" id="form1" method="get" action="reply_2.php">
<p><span class="text"><strong>Lead response - Step 1 of 1 to Lead ID:<?php echo $row_Recordset1['userID']; ?> / <?php echo $row_Recordset1['added_by']; ?> </strong></span></p>
<table align="center" bgcolor="#C6DBF2" class="text">
<tr valign="baseline">
<td nowrap align="right"><strong>Price from:</strong></td>
<td><input type="text" name="price_from" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><strong>Price to:</strong></td>
<td><input type="text" name="price_to" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top"><strong>Comments:</strong></td>
<td><textarea name="comments" cols="50" rows="5" id="comomments"></textarea> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Send E-mail -->"></td>
</tr>
</table>
<p>
<input type="hidden" name="userID" value="">
<input name="added_by" type="hidden" id="added_by" value="<?php echo $row_Recordset1['added_by']; ?>" />
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</form>
----------------------page 1 end---------------------
---------------------page 2 start----------------------
<?php
// Buzz inet PHPLS03 - Check User Session is set
session_start();
if(!isset($HTTP_SESSION_VARS['usersession'])){
header("Location: ../login.php";
////// Logout Section. Delete all session variable.
session_destroy();
$message="";
}
?>
<?php require_once('../Connections/conn_fra.php'); ?>
<?php require_once('../ScriptLibrary/incSmartMailer.php'); ?>
<?php
if (!function_exists("GetSQLValueString") {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string" ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "" ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "" ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") {
$insertSQL = sprintf("INSERT INTO price (added_by, price_from, price_to, comments, `datetime`) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['added_by'], "text",
GetSQLValueString($_POST['price_from'], "text",
GetSQLValueString($_POST['price_to'], "text",
GetSQLValueString($_POST['comments'], "text",
GetSQLValueString($_POST['datetime'], "text");
mysql_select_db($database_conn_fra, $conn_fra);
$Result1 = mysql_query($insertSQL, $conn_fra) or die(mysql_error());
$insertGoTo = "reply_3.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
$colname_Recordset1 = "-1";
if (isset($_GET['userID'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['userID'] : addslashes($_GET['userID']);
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset1 = sprintf("SELECT * FROM `form` WHERE userID = %s", GetSQLValueString($colname_Recordset1, "int");
$Recordset1 = mysql_query($query_Recordset1, $conn_fra) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset2 = "SELECT * FROM price ORDER BY ID DESC";
$Recordset2 = mysql_query($query_Recordset2, $conn_fra) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<?php
// Smart Mailer 1.0.3
// Send on submit of form form1
if (count($HTTP_POST_VARS) > 0) {
@set_time_limit(300);
$sm1 = new SmartMailer();
$sm1->checkVersion("1.03";
$sm1->smtpSetup("localhost", "21", "user", "pw";
$sm1->component = "Sendmail";
$sm1->tmpFolder = "../temp";
$sm1->embedImages = true;
$sm1->progressBar = "";
$sm1->ignore_errors = true;
$sm1->setFrom("Topic", " );
$sm1->setTo($row_Recordset1['added_by'], $row_Recordset1['email']);
$sm1->setCc("", "";
$sm1->setBcc("", "";
$sm1->setSubject("".$row_Recordset1['added_by'].", Your Free Real Estate Appraisal";
// using template for body
$sm1->setBody_Template_html("../response/appraisal.php";
// Attachments none
$sm1->sendMail("one";
$GoTo = "reply_3.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$GoTo .= (strpos($GoTo, '?')) ? "&" : "?";
$GoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $GoTo));
}
$SM_mailAction = getMailAction();
?>
<?php
$cust_name = htmlentities($_POST['ID']);
$cust_name = htmlentities($_POST['added_by']);
$cust_name = htmlentities($_POST['price_from']);
$cust_name = htmlentities($_POST['price_to']);
$cust_name = htmlentities($_POST['comments']);
$cust_name = htmlentities($_POST['datetime']);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administration</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<!-- InstanceEndEditable -->
<link href="../css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="20" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="91"><img src="images/logo.gif" width="600" height="127" /></td>
<td width="22"> </td>
</tr>
<tr>
<td colspan="2"><table width="781" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="right" class="BlueWhiteHeader">AGENT ADMINISTRATION </div></td>
</tr>
<tr>
<td colspan="2"> </td>
<td width="668" class="text">Hello <strong><? echo $_SESSION['usersession']; ?>! </strong>You are now Logged in. </td>
<td class="text"><div align="right"><a href="../default.php" class="textLink">Logout</a></div></td>
<td width="22"> </td>
</tr>
<tr>
<td width="81" valign="top"><a href="default.php" class="textLink">Home</a></td>
<td width="10"> </td>
<td colspan="2"><!-- InstanceBeginEditable name="body" -->
<p class="text"><strong>Lead response - Step 2 of 2 </strong></p>
<form action="<?php echo $SM_mailAction?>" name="form1" method="post">
<span class="text"> </span>
<p class="text">Price From: <?php echo $price_from ?><br />
Price To: <?php echo $price_to ?></p>
<p class="text">Comments: <?php echo $comments ?></p>
<p>
<input type="hidden" name="added_by" value="<?php echo $added_by ?>" />
<input type="hidden" name="comments" value="<?php echo $comments ?>" />
<input type="hidden" name="price_from" value="<?php echo $price_from ?>" />
<input type="hidden" name="price_to" value="<?php echo $price_to ?>" />
<input type="hidden" name="datetime" value="<?php echo $datetime ?>" />
<input type="submit" name="Submit" value="Send Email -->" />
<input type="hidden" name="MM_insert" value="form1">
</p>
<p> </p>
<p class="textLink" onclick="MM_openBrWindow('view_reply.php?&added_by=<?php echo $added_by ?>&price_from=<?php echo $price_from ?>&price_to=<?php echo $price_from ?>&comments=<?php echo $comments ?>"','','scrollbars=yes,width=565,height=650')"><a href="#">View Email </a></p>
<p> </p>
<p> </p>
</form>
<!-- InstanceEndEditable --></td>
<td> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" bgcolor="#EEEEEE"><div align="center" class="text">© Free Realestate Appraisals 2007 </div></td>
</tr>
</table></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
---------------page 2 end--------------------
---------------page 3 start ----------------
</font id=code></pre id=code><?php
// Buzz inet PHPLS03 - Check User Session is set
session_start();
if(!isset($HTTP_SESSION_VARS['usersession'])){
header("Location: ../login.php";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administration</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<link href="../css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="20" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="91"><img src="images/logo.gif" width="600" height="127" /></td>
<td width="22"> </td>
</tr>
<tr>
<td colspan="2"><table width="781" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="right" class="BlueWhiteHeader">AGENT ADMINISTRATION </div></td>
</tr>
<tr>
<td colspan="2"> </td>
<td width="668" class="text">Hello <strong><? echo $_SESSION['usersession']; ?>! </strong>You are now Logged in. </td>
<td class="text"><div align="right"><a href="../default.php" class="textLink">Logout</a></div></td>
<td width="22"> </td>
</tr>
<tr>
<td width="81" valign="top"><a href="default.php" class="textLink">Home</a></td>
<td width="10"> </td>
<td colspan="2"><!-- InstanceBeginEditable name="body" -->
<p> </p>
<p class="text"><strong>Your response has been sent . </strong></p>
<p><span class="text"><a href="default.php"><span class="textLink">Click here</span></a> when complete. </span></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
---------------page 3 end ------------------------
---------------email template start -----------
<?php require_once('../Connections/conn_fra.php'); ?>
<?php
if (!function_exists("GetSQLValueString") {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string" ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "" ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "" ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset1 = "SELECT * FROM price ORDER BY ID DESC";
$Recordset1 = mysql_query($query_Recordset1, $conn_fra) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
</head>
<body>
<table width="789" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td colspan="3"><img src="../images/banner_img.jpg" width="800" height="335" /></td>
</tr>
<tr>
<td colspan="3"><p align="left" class="style1">Dear <?php echo $row_Recordset1['added_by']; ?><br />
<br />
My job is to provide you with information specifically for your property from the information you have provided to me. I have researched the area and the market conditions, comparable sales and combined this with my local knowledge of the area. In my opinion I believe your property is worth approximately $<?php echo $row_Recordset1['price_from']; ?> to $<?php echo $row_Recordset1['price_to']; ?>.</p>
<p align="left" class="style1">Thank you for the opportunity to provide this free service to you.</p>
<? if ($row_Recordset1['comments'] != "" { ?>
<p align="left" class="style1">Comments: <?php echo $row_Recordset1['comments']; ?></p>
<? } ?>
>
<p class="style1"><br />
**Print off a copy for your records**</p>
<p class="style1"> </p>
<p class="style1">DISCLAIMER<br />
T
<p> </p></td>
</tr>
<tr>
<td> </td>
<td><div align="center">------Do not reply to this email------</div></td>
<td> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
---------------end----------------------
[/code]
Edited by - snarzom on 25 Mar 2007 05:48:51
<pre id=code><font face=courier size=2 id=code>
-----------------page 1 start-----------------
if (!function_exists("GetSQLValueString"
) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string"
? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);switch ($theType) {
case "text":
$theValue = ($theValue != ""
? "'" . $theValue . "'" : "NULL";break;
case "long":
case "int":
$theValue = ($theValue != ""
? intval($theValue) : "NULL";break;
case "double":
$theValue = ($theValue != ""
? "'" . doubleval($theValue) . "'" : "NULL";break;
case "date":
$theValue = ($theValue != ""
? "'" . $theValue . "'" : "NULL";break;
case "defined":
$theValue = ($theValue != ""
? $theDefinedValue : $theNotDefinedValue;break;
}
return $theValue;
}
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset2 = "SELECT * FROM price ORDER BY ID DESC";
$Recordset2 = mysql_query($query_Recordset2, $conn_fra) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$colname_Recordset1 = "-1";
if (isset($_GET['userID'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['userID'] : addslashes($_GET['userID']);
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset1 = sprintf("SELECT * FROM `form` WHERE userID = %s", GetSQLValueString($colname_Recordset1, "int"
);$Recordset1 = mysql_query($query_Recordset1, $conn_fra) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
// Buzz inet PHPLS03 - Check User Session is set
session_start();
if(!isset($HTTP_SESSION_VARS['usersession'])){
header("Location: ../login.php"
;////// Logout Section. Delete all session variable.
session_destroy();
$message="";
}
?><?php
$cust_name = htmlentities($_POST['userID']);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administration</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<link href="../css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="20" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="91"><img src="images/logo.gif" width="600" height="127" /></td>
<td width="22"> </td>
</tr>
<tr>
<td colspan="2"><table width="781" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="right" class="BlueWhiteHeader">AGENT ADMINISTRATION </div></td>
</tr>
<tr>
<td colspan="2"> </td>
<td width="668" class="text">Hello <strong><? echo $_SESSION['usersession']; ?>! </strong>You are now Logged in. </td>
<td class="text"><div align="right"><a href="../default.php" class="textLink">Logout</a></div></td>
<td width="22"> </td>
</tr>
<tr>
<td width="81" valign="top"><a href="default.php" class="textLink">Home</a></td>
<td width="10"> </td>
<td colspan="2"><!-- InstanceBeginEditable name="body" -->
<p class="text"> </p>
<form name="form1" id="form1" method="get" action="reply_2.php">
<p><span class="text"><strong>Lead response - Step 1 of 1 to Lead ID:<?php echo $row_Recordset1['userID']; ?> / <?php echo $row_Recordset1['added_by']; ?> </strong></span></p>
<table align="center" bgcolor="#C6DBF2" class="text">
<tr valign="baseline">
<td nowrap align="right"><strong>Price from:</strong></td>
<td><input type="text" name="price_from" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><strong>Price to:</strong></td>
<td><input type="text" name="price_to" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top"><strong>Comments:</strong></td>
<td><textarea name="comments" cols="50" rows="5" id="comomments"></textarea> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Send E-mail -->"></td>
</tr>
</table>
<p>
<input type="hidden" name="userID" value="">
<input name="added_by" type="hidden" id="added_by" value="<?php echo $row_Recordset1['added_by']; ?>" />
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</form>
----------------------page 1 end---------------------
---------------------page 2 start----------------------
<?php
// Buzz inet PHPLS03 - Check User Session is set
session_start();
if(!isset($HTTP_SESSION_VARS['usersession'])){
header("Location: ../login.php"
;////// Logout Section. Delete all session variable.
session_destroy();
$message="";
}
?>
<?php require_once('../Connections/conn_fra.php'); ?>
<?php require_once('../ScriptLibrary/incSmartMailer.php'); ?>
<?php
if (!function_exists("GetSQLValueString"
) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string"
? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);switch ($theType) {
case "text":
$theValue = ($theValue != ""
? "'" . $theValue . "'" : "NULL";break;
case "long":
case "int":
$theValue = ($theValue != ""
? intval($theValue) : "NULL";break;
case "double":
$theValue = ($theValue != ""
? "'" . doubleval($theValue) . "'" : "NULL";break;
case "date":
$theValue = ($theValue != ""
? "'" . $theValue . "'" : "NULL";break;
case "defined":
$theValue = ($theValue != ""
? $theDefinedValue : $theNotDefinedValue;break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1"
) {$insertSQL = sprintf("INSERT INTO price (added_by, price_from, price_to, comments, `datetime`) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['added_by'], "text"
,GetSQLValueString($_POST['price_from'], "text"
,GetSQLValueString($_POST['price_to'], "text"
,GetSQLValueString($_POST['comments'], "text"
,GetSQLValueString($_POST['datetime'], "text"
);mysql_select_db($database_conn_fra, $conn_fra);
$Result1 = mysql_query($insertSQL, $conn_fra) or die(mysql_error());
$insertGoTo = "reply_3.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
$colname_Recordset1 = "-1";
if (isset($_GET['userID'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['userID'] : addslashes($_GET['userID']);
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset1 = sprintf("SELECT * FROM `form` WHERE userID = %s", GetSQLValueString($colname_Recordset1, "int"
);$Recordset1 = mysql_query($query_Recordset1, $conn_fra) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset2 = "SELECT * FROM price ORDER BY ID DESC";
$Recordset2 = mysql_query($query_Recordset2, $conn_fra) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<?php
// Smart Mailer 1.0.3
// Send on submit of form form1
if (count($HTTP_POST_VARS) > 0) {
@set_time_limit(300);
$sm1 = new SmartMailer();
$sm1->checkVersion("1.03"
;$sm1->smtpSetup("localhost", "21", "user", "pw"
;$sm1->component = "Sendmail";
$sm1->tmpFolder = "../temp";
$sm1->embedImages = true;
$sm1->progressBar = "";
$sm1->ignore_errors = true;
$sm1->setFrom("Topic", " );
$sm1->setTo($row_Recordset1['added_by'], $row_Recordset1['email']);
$sm1->setCc("", ""
;$sm1->setBcc("", ""
;$sm1->setSubject("".$row_Recordset1['added_by'].", Your Free Real Estate Appraisal"
;// using template for body
$sm1->setBody_Template_html("../response/appraisal.php"
;// Attachments none
$sm1->sendMail("one"
;$GoTo = "reply_3.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$GoTo .= (strpos($GoTo, '?')) ? "&" : "?";
$GoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $GoTo));
}
$SM_mailAction = getMailAction();
?>
<?php
$cust_name = htmlentities($_POST['ID']);
$cust_name = htmlentities($_POST['added_by']);
$cust_name = htmlentities($_POST['price_from']);
$cust_name = htmlentities($_POST['price_to']);
$cust_name = htmlentities($_POST['comments']);
$cust_name = htmlentities($_POST['datetime']);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administration</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<!-- InstanceEndEditable -->
<link href="../css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="20" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="91"><img src="images/logo.gif" width="600" height="127" /></td>
<td width="22"> </td>
</tr>
<tr>
<td colspan="2"><table width="781" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="right" class="BlueWhiteHeader">AGENT ADMINISTRATION </div></td>
</tr>
<tr>
<td colspan="2"> </td>
<td width="668" class="text">Hello <strong><? echo $_SESSION['usersession']; ?>! </strong>You are now Logged in. </td>
<td class="text"><div align="right"><a href="../default.php" class="textLink">Logout</a></div></td>
<td width="22"> </td>
</tr>
<tr>
<td width="81" valign="top"><a href="default.php" class="textLink">Home</a></td>
<td width="10"> </td>
<td colspan="2"><!-- InstanceBeginEditable name="body" -->
<p class="text"><strong>Lead response - Step 2 of 2 </strong></p>
<form action="<?php echo $SM_mailAction?>" name="form1" method="post">
<span class="text"> </span>
<p class="text">Price From: <?php echo $price_from ?><br />
Price To: <?php echo $price_to ?></p>
<p class="text">Comments: <?php echo $comments ?></p>
<p>
<input type="hidden" name="added_by" value="<?php echo $added_by ?>" />
<input type="hidden" name="comments" value="<?php echo $comments ?>" />
<input type="hidden" name="price_from" value="<?php echo $price_from ?>" />
<input type="hidden" name="price_to" value="<?php echo $price_to ?>" />
<input type="hidden" name="datetime" value="<?php echo $datetime ?>" />
<input type="submit" name="Submit" value="Send Email -->" />
<input type="hidden" name="MM_insert" value="form1">
</p>
<p> </p>
<p class="textLink" onclick="MM_openBrWindow('view_reply.php?&added_by=<?php echo $added_by ?>&price_from=<?php echo $price_from ?>&price_to=<?php echo $price_from ?>&comments=<?php echo $comments ?>"','','scrollbars=yes,width=565,height=650')"><a href="#">View Email </a></p>
<p> </p>
<p> </p>
</form>
<!-- InstanceEndEditable --></td>
<td> </td>
</tr>
<tr>
<td colspan="2"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" bgcolor="#EEEEEE"><div align="center" class="text">© Free Realestate Appraisals 2007 </div></td>
</tr>
</table></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
---------------page 2 end--------------------
---------------page 3 start ----------------
</font id=code></pre id=code><?php
// Buzz inet PHPLS03 - Check User Session is set
session_start();
if(!isset($HTTP_SESSION_VARS['usersession'])){
header("Location: ../login.php"
;}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administration</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<link href="../css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="20" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="91"><img src="images/logo.gif" width="600" height="127" /></td>
<td width="22"> </td>
</tr>
<tr>
<td colspan="2"><table width="781" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="right" class="BlueWhiteHeader">AGENT ADMINISTRATION </div></td>
</tr>
<tr>
<td colspan="2"> </td>
<td width="668" class="text">Hello <strong><? echo $_SESSION['usersession']; ?>! </strong>You are now Logged in. </td>
<td class="text"><div align="right"><a href="../default.php" class="textLink">Logout</a></div></td>
<td width="22"> </td>
</tr>
<tr>
<td width="81" valign="top"><a href="default.php" class="textLink">Home</a></td>
<td width="10"> </td>
<td colspan="2"><!-- InstanceBeginEditable name="body" -->
<p> </p>
<p class="text"><strong>Your response has been sent . </strong></p>
<p><span class="text"><a href="default.php"><span class="textLink">Click here</span></a> when complete. </span></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
---------------page 3 end ------------------------
---------------email template start -----------
<?php require_once('../Connections/conn_fra.php'); ?>
<?php
if (!function_exists("GetSQLValueString"
) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string"
? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);switch ($theType) {
case "text":
$theValue = ($theValue != ""
? "'" . $theValue . "'" : "NULL";break;
case "long":
case "int":
$theValue = ($theValue != ""
? intval($theValue) : "NULL";break;
case "double":
$theValue = ($theValue != ""
? "'" . doubleval($theValue) . "'" : "NULL";break;
case "date":
$theValue = ($theValue != ""
? "'" . $theValue . "'" : "NULL";break;
case "defined":
$theValue = ($theValue != ""
? $theDefinedValue : $theNotDefinedValue;break;
}
return $theValue;
}
}
mysql_select_db($database_conn_fra, $conn_fra);
$query_Recordset1 = "SELECT * FROM price ORDER BY ID DESC";
$Recordset1 = mysql_query($query_Recordset1, $conn_fra) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
</head>
<body>
<table width="789" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td colspan="3"><img src="../images/banner_img.jpg" width="800" height="335" /></td>
</tr>
<tr>
<td colspan="3"><p align="left" class="style1">Dear <?php echo $row_Recordset1['added_by']; ?><br />
<br />
My job is to provide you with information specifically for your property from the information you have provided to me. I have researched the area and the market conditions, comparable sales and combined this with my local knowledge of the area. In my opinion I believe your property is worth approximately $<?php echo $row_Recordset1['price_from']; ?> to $<?php echo $row_Recordset1['price_to']; ?>.</p>
<p align="left" class="style1">Thank you for the opportunity to provide this free service to you.</p>
<? if ($row_Recordset1['comments'] != ""
{ ?><p align="left" class="style1">Comments: <?php echo $row_Recordset1['comments']; ?></p>
<? } ?>
>
<p class="style1"><br />
**Print off a copy for your records**</p>
<p class="style1"> </p>
<p class="style1">DISCLAIMER<br />
T
<p> </p></td>
</tr>
<tr>
<td> </td>
<td><div align="center">------Do not reply to this email------</div></td>
<td> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
---------------end----------------------
[/code]
Edited by - snarzom on 25 Mar 2007 05:48:51