one_row('SELECT '.COL_AD_TITLE.',userid,feed_code,feed_prop_id,v_255_22,catid,v_255_23,v_255_21,v_255_2,v_255_3,v_255_4,lh_lake_on,gh_club,v_255_35 FROM '.
TBL_AD . ' WHERE link_id='.$id);
if (!$cid) {
echo('Wrong Ad ID - Request Information Message');
exit;
}
//if(!$subj) $err_msg = $A_LNG['err_subject'];
$IS_LHUB_ACC = ($feed_code == LHUB_FEED_ID && $uid == LHUB_UID);
$contact_phone = $IS_LHUB_ACC ? '888-933-5253' : $adContactPhone;
$mspot = (int)$_POST['mspot'];
$a_Agent = $IS_LHUB_ACC ? getMatchingBuyerAgent($mspot, $cid) : [];
if($feed_code=='FLEXMLS'){
if(strpos($company_name,FEATURED_COMPANY)===false){
$contact = FEATURED_COMPANY;
// TODO: agent's email
$adContactEmail = 'joseph@josephcarterrealty.com';
// TODO: Place agent's phone number as well ?
$contact_phone = $adContactPhone = '205-717-5253';
}
// is this request to a particular agent ?
if($_POST['agentId']){
$v = $db->one_assoc('SELECT email,v_255_1,v_255_2,v_255_3 FROM '.TBL_USER.' WHERE id='.(int)$_POST['agentId']);
if($v){
$adContactEmail = $v['email'];
$contact_phone = $adContactPhone = $v['v_255_2'];
$contact = $v['v_255_1'].' '.$v['v_255_3'];
}
}
}
if(!$err_msg && $phone){
if(strlen($phone)>16) $err_msg = 'Please use this phone format: 999-999-9999';
elseif(preg_match('@https?://@i', $phone) || preg_match('/\.(?:com|net|org|us)\b/i', $phone)) $err_msg = 'Not a valid phone number';
}
if(!$err_msg && ($fname || $lname)){
$name = "$fname $lname";
if(strlen($name)>50 || preg_match('@https?://@i', $name) || preg_match('/\.(?:com|net|org|us)\b/i', $name)) $err_msg = 'Website links are not allowed here. Please submit your full name.';
}
if(!$err_msg && $IS_LHUB_ACC && $mspot<=0){
if(!$fname) $err_msg = 'First Name is required';
elseif(!$lname) $err_msg = 'Last Name is required';
elseif(!$phone) $err_msg = 'Phone is required';
else{
require_once __DIR__ . '/libphonenumber/Autoloader.php';
if(!\libphonenumber\isPhoneValid($phone)){
$err_msg = 'Please enter correct phone number';
if($phone[0]!='+') $err_msg.='. Non-US numbers should start with "+" sign';
}
}
}
if(!$err_msg){
if(!$_POST['sms'] && !IsEmail($from)) $err_msg = $A_LNG['req_email'];
elseif(preg_match('/<[^>]+>/', $msg)) $err_msg = $A_LNG['err_html_msg'];
elseif(preg_match('/[a-zA-Z0-9\_\-]+(\.[a-zA-Z0-9\_\-]+)*\@[a-zA-Z0-9\_\-]+(\.[a-zA-Z0-9\_\-]+)*(\.[a-zA-Z]+)/', $msg)) $err_msg = $A_LNG['err_email_msg'];
//elseif(preg_match('@((https?://)?([-\\w]+\\.[-\\w\\.]+)+\\w(:\\d+)?(/([-\\w/_\\.]*(\\?\\S+)?)?)*)@', $msg)) $err_msg = $A_LNG['err_url_msg'];
elseif(preg_match('@https?://@i', $msg) || preg_match('/\.(?:com|net|org|us)\b/i', $msg)) $err_msg = $A_LNG['err_url_msg'];
elseif(preg_match('/\?{4,}/', $msg)) $err_msg = 'Unacceptable characters in your message. Please call 888-933-5253 for assistance.';
elseif($IS_LHUB_ACC && empty($a_Agent) && empty($_POST['xxTrustedFormCertUrl'])) $err_msg = 'Unknown error. Please try again';
else {
$secret = '6Le_wN4UAAAAAP8LfX3Axp2A3oDvW4coC4NdmV2Q';
if(empty($_POST['g-recaptcha-response'])) $err_msg = $A_LNG['err_img_code'];
else{
$v = reCaptchaVerify($secret, $_POST['g-recaptcha-response']);
if(!$v['success']) $err_msg = $A_LNG['err_img_code'];
}
//if (!ImageVerify::IsTextOK($_POST['img_text'])) $err_msg = $A_LNG['err_img_code'];
}
}
if (!$err_msg) {
if ($db->one_data("SELECT count(*) FROM " . TBL_SEND_MSG_LOG . " WHERE ip='$REMOTE_ADDR' AND date_added>DATE_SUB(NOW(),INTERVAL $SEND_MSG_PERIOD HOUR)") > 16) {
$err_msg = "You have reached the maximum number of emails allowed. Please try again later";
SendMail('csv@lakehouse.com,lee@anyprop.com',"DHN: MAX EMAILS ALERT! Attempt from $REMOTE_ADDR (Ad ID: $id, User ID: $uid)",$msg,$from,$fromname);
}
}
if (!$err_msg) {
incrementAdEmailHits($id);
if($feed_code=='HOMESANDLAND' || $IS_LHUB_ACC){
$email = $adContactEmail;
$phonenet = $phoneOwner = '';
}
else list($email,$phoneOwner,$phonenet) = $db->one_row('SELECT email,v_255_2,phonenet FROM ' . TBL_USER . ' WHERE id='.$uid);
$msg = iconv('utf-8', 'us-ascii//TRANSLIT',$msg);
if($_POST['sms']) $inquiry_source = 'Mobile-Text';
else $inquiry_source = DESKTOP_CLIENT ? 'Desktop' : 'Mobile';
$lead_id = insertLead($id, $fromname, $from, $phone, $msg, $_SERVER['REMOTE_ADDR'], $inquiry_source);
if ($feed_code == '') $feed_code_info = '';
else {
//$DEBUG_LHUB = ($feed_code == LHUB_FEED_ID && $_SERVER['REMOTE_ADDR']=='');
$feed_code_info = 'Property courtesy of ' . $feed_code;
} // ('
Property courtesy of '.$feed_code.'
')
$REMOTE_ADDR = $_SERVER['REMOTE_ADDR'];
$SITE_URL = SITE_URL;
$price = number_format($price);
$ad_url = hwGetAdURL($id);
ProcessSearchFriendlyURLs($ad_url);
$email_body = EvalAdvTpl(TPL_PATH . 'send_msg.mail', '$to,$subj,$id,$from,$fromname,$mls,$contact,$addr,$city,$state,$price,$lakename,$golfcourse'.
',$ad_url,$msg,$phone,$REMOTE_ADDR,$SITE_URL,$feed_code_info,$inquiry_source');
//$err_msg = 'A Request for Information e-mail has been sent to the contact for ad #' . $id . '. Thank You.';
if (DESKTOP_CLIENT) {
$err_msg = '
Success!
Your request has been sent by email to the contact for this ad #' . $id . '.
Thank You!
';
}
else {
$err_msg = '';
}
$state_id = (int)$db->one_data('SELECT pid FROM '.TBL_CAT.' WHERE id='.$cid);
$IS_USA = (0 == $db->one_data('SELECT pid FROM '.TBL_CAT.' WHERE id='.$state_id));
if($IS_LHUB_ACC){
if($IS_USA){
$email_subj = 'Claim This Lead from Your Listing on LakeHouse.com!';
$email_body2 = preg_replace('/.*?/s','',$email_body);
$email_body2 = preg_replace('~
