function addNewsletterToRepo($cfdata)
{
$formTitle = $cfdata->title;
if (strpos($formTitle, 'Newsletter Form') !== false) {
//LOCAL DB
/*$host = 'localhost';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'root';*/
//STAGING
/*$host = 'localhost:3306';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leasingLeads$$##';*/
//LIVE
$host = '205.186.138.226';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leads$$123%%';
$link = mysqli_connect($host, $user, $pwd);
$db_selected = mysqli_select_db($link, $db_name);
$date_subscribed = date('Y-m-d H:i:s');
$query = "INSERT INTO `contact_forms` (name, email, page_converted, date_added, type, optin_status) VALUES ('" . $_POST['name'] . "', '" . $_POST['email'] . "', '" . $_SERVER['HTTP_REFERER'] . "', '" . $date_subscribed . "', 'subscriber', '0')";
$sql = mysqli_query($link, $query);
$_SESSION['thank-you'] = 1;
} else {
if (strpos($formTitle, 'Commercial Property Form') !== false) {
//LOCAL DB
/*$host = 'localhost';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'root';*/
$ss = new SpreadsheetHandler();
//STAGING
/*$host = 'localhost:3306';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leasingLeads$$##';*/
//LIVE
$host = '205.186.138.226';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leads$$123%%';
$name = $_POST['fname'] . ' ' . $_POST['lname'];
$link = mysqli_connect($host, $user, $pwd);
$db_selected = mysqli_select_db($link, $db_name);
$date_subscribed = date('Y-m-d H:i:s');
$query = "INSERT INTO `contact_forms` (name, contact, email, page_converted, client_ip, date_added, status, message, type, property) VALUES ('" . $name . "', '" . $_POST['contact'] . "', '" . $_POST['email'] . "', '" . $_SERVER['HTTP_REFERER'] . "', '" . $_POST['clientIp'] . "' , '" . $date_subscribed . "', '', '" . $_POST['message'] . "', '" . $_POST['propertyType'] . "', '" . $_POST['property'] . "')";
$sql = mysqli_query($link, $query);
$data = array('name' => $name, 'contactnumber' => $_POST['contact'], 'email' => $_POST['email'], 'pageconverted' => $_SERVER['HTTP_REFERER'], 'propertytype' => $_POST['propertyType'], 'property' => $_POST['property'], 'message' => $_POST['message'], 'dateinquired' => $date_subscribed);
$ss->addContactLeadToDocs($data);
$_SESSION['thank-you'] = 1;
} else {
if (strpos($formTitle, 'Contact Us') !== false) {
//LOCAL DB
/*$host = 'localhost';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'root';*/
$ss = new SpreadsheetHandler();
//STAGING
/*$host = 'localhost:3306';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leasingLeads$$##';*/
//LIVE
$host = '205.186.138.226';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leads$$123%%';
$link = mysqli_connect($host, $user, $pwd);
$db_selected = mysqli_select_db($link, $db_name);
$date_subscribed = date('Y-m-d H:i:s');
$query = "INSERT INTO `contact_forms` (name, contact, email, page_converted, date_added, message, type) VALUES ('" . $_POST['name'] . "', '" . $_POST['contact'] . "', '" . $_POST['email'] . "', '" . $_SERVER['HTTP_REFERER'] . "', '" . $date_subscribed . "', '" . $_POST['message'] . "', 'inquiries')";
$sql = mysqli_query($link, $query);
$data = array('name' => $_POST['name'], 'contact' => $contact, 'email' => $_POST['email'], 'page_converted' => $_SERVER['HTTP_REFERER'], 'date' => $date_subscribed, 'message' => $_POST['message'], 'status' => 'inquiries');
$ss->addContactFormLead($data);
$_SESSION['thank-you'] = 1;
}
}
}
}
