insertFields("users", "username, salutation, fname, lname, password, email, phone", array($username, $salutation, $fname, $lname, md5($userpass), $email, $phone));
$header = email_GetHeaderBasic();
$email_content = $header."
Welcome!
Your Riviera Home Finders Account was created.
";
$email_content .= "Your username is: ".$username." and your password is: ".$userpass;
$email_content .= 'Click My Account to go to your account page.
';
email_send(MAIL_SENDER, $email, "Your Riviera Home Finders Account", "".$email_content."", TRUE);
html_redirect("property_notification.html");
}
$page_code = "buying";
$sql = "SELECT title,
left_content
FROM app_site_pages
WHERE page_code = '".$page_code."' AND site_code = '".SITE_CODE."'";
$rs = $db->createRecordSet($sql);
$page = $db->fetchArray($rs);
#title
switch($page_code)
{
case 'buying': $nav = "Buying"; break;
case 'contact': $nav = "contact"; break;
case 'about': $nav = "about"; break;
}
$smarty->assign("nav", $nav);
# Meta
$header = seo_GetPageHeader($page_code);
$smarty->assign("page_header", $header);
$smarty->assign("page_name", "buying");
#main content
if ($page["left_content"]){
$smarty->assign("center_content", $page["left_content"]);
$smarty->assign("contents_c", array("page_center.tpl"));
}
$smarty->assign("search", array("search2.tpl"));
$smarty->assign("callouts", array("search_form_two.tpl"));
$smarty->display("main2_content.tpl");
?>