<?php
	If(isset($_POST['name']))
	{
		$name = $_POST["name"];
		$email = $_POST["email"];
		$phone = $_POST['phone'];
		$mobile = $_POST['mobile'];
		$isMobile = ($mobile ? "כן" : "לא");
		$ref = $_POST['ref'];
		
		$visitorFrom = $_POST['leedSrc'];
		if($_POST['confirm']=="true")
		{
			$allowMailing = "כן";
		}
		else
		{
			$allowMailing = "לא";
		}
		$leedText = "";
		if($visitorFrom != "")
		{
			$leedText = "index.php?src=" . $visitorFrom;
		}

		$msg = "שם: " . $name . "<br />טלפון: " . $phone . "<br />מייל: " . $email . "<br />מובייל: " .  $isMobile . "<br />כתובת דף הנחיתה: http://beitarbeersheva.com/campaign/" . $leedText;

		$headers  = "MIME-Version: 1.0\r\n";
		$headers .= "Content-type: text/html; charset=UTF-8\r\n";

		mail('simtob@gmail.com' ,'לייד חדש מטניס שולחן' , $msg, $headers);
		
		/////////////////////////////////////////   SMS   ///////////////////////////////////////////
		
		$url = 'http://www.smsapi.co.il/Web_API/SendSMS.asmx/SUBMITSMS';
		$data = array('XMLString' => '<SMS>
										<USERNAME>039229927</USERNAME>
										<PASSWORD>ahrv7583</PASSWORD>
										<SENDER_PREFIX>ALFA</SENDER_PREFIX>
										<SENDER_SUFFIX>PingPong</SENDER_SUFFIX>
										<MSGLNG>HEB</MSGLNG>
										<MSG>שם:' . $name . ' טלפון:' . $phone . '</MSG>
										<MOBILE_LIST>
											<MOBILE_NUMBER>0543341104</MOBILE_NUMBER>
										</MOBILE_LIST>
										<UNICODE>False</UNICODE>
										<USE_PERSONAL>False</USE_PERSONAL>
									</SMS>');

		// use key 'http' even if you send the request to https://...
		$options = array(
			'http' => array(
				'header'  => "Content-type: application/x-www-form-urlencoded\r\n",
				'method'  => 'POST',
				'content' => http_build_query($data)
			)
		);
		$context  = stream_context_create($options);
		$result = file_get_contents($url, false, $context);
		if ($result === FALSE) { /* Handle error */ }

		var_dump($result);
		
		////////////////////////////////////////////////////////////////////////////////////
		
		date_default_timezone_set('Asia/Jerusalem');
		$date = date("Y-m-d H:i:s");
		
		if (!empty($_SERVER['HTTP_CLIENT_IP'])) 
		{
			$ip = $_SERVER['HTTP_CLIENT_IP'];
		} 
		elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) 
		{
			$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
		} 
		else 
		{
			$ip = $_SERVER['REMOTE_ADDR'];
		}
		
		$moreDetails = $_SERVER['HTTP_USER_AGENT'];

		$servername = "mysql.beitarbeersheva.com";
		$username = "beitarbeershevac";
		$password = "-j93pzZ6";
		$dbname = "beitarbeersheva_com";

		
		// Create connection
		$conn = mysqli_connect($servername, $username, $password, $dbname);
		// Check connection
		if ($conn->connect_error) {
			die("Connection failed: " . $conn->connect_error);
		}
		// Change character set to utf8
		mysqli_set_charset($conn,"utf8");
		
		$sql = "INSERT INTO leeds (ip, dateTime, leadName, leadPhone, leadEmail, isMobile, visitorFrom, ServerReference, moreDetails) VALUES ('$ip', '$date', '$name', '$phone', '$email', '$isMobile', '$visitorFrom', '$ref', '$moreDetails');";
		
		/*	//sql to file
		$date=date_create(date(c));
		$file = "Log/" . date_format($date,"d-m-Y-H_i_s") . "Registr.txt"; // File name
		$myfile = fopen($file, "w") or die("Unable to open file!");
		$txt = $sql;
		fwrite($myfile, $txt);
		fclose($myfile);*/
			
		$conn->query($sql);
		$conn->close();
	}
	
?>