<?php 
error_reporting(E_ALL ^ E_NOTICE); // hide all basic notices from PHP
//If the form is submitted
if(isset($_POST['submitted'])) {
	// need valid email
	if(trim($_POST['email']) === '')  {
		$emailError = 'Forgot to enter in your e-mail address.';
		$hasError = true;
	} else if (!preg_match("/^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,4}$/i", trim($_POST['email']))) {
		$emailError = 'You entered an invalid email address.';
		$hasError = true;
	} else {
		$email = trim($_POST['email']);
	}
		
	// upon no failure errors let's email now!
	if(!isset($hasError)) {
		$spam = (trim($_POST['tel'])=="") ? 0 : 1;
		if(!$spam) {			
			include("/var/www/sfprojects/multiannunci/web/utils/dbconfig.php");
			include("/var/www/sfprojects/multiannunci/lib/vendor/PHPMailer/class.phpmailer.php");
			$insert="INSERT INTO `multiannunci2`.`alert_ricerche` (`id`, `sito_id`, `created_at`, `parametri`, `email`, `nome`, `ip`,`expires_at`) ";
			$insert.="VALUES (NULL,'".servername ($conn)."' ,CURRENT_TIMESTAMP, '".mysql_real_escape_string($_REQUEST['parametri'],$conn)."', '".mysql_real_escape_string($email,$conn)."', '".mysql_real_escape_string($_REQUEST['nome'],$conn)."', '".$_POST['ip']."','".date('Y-m-d', time() + 31536000) ."');";
			mysql_query($insert, $conn);	
		}        
	}
}
function servername ($conn) { 
	$sito=$_SERVER['HTTP_HOST'] ?  $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'];
	$result = mysql_query("select id from siti where ".$sito." LIKE descrizione LIMIT 1;", $conn);
	if ($result) {
		$item = mysql_fetch_array ($result);
		return $item['id'];
	}
	return ;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head> 
<title>Alert Email: Salva la ricerca e ricevi gli annunci via email</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<link href="stylesform.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <!-- @begin contact -->
	<div id="contact" class="section">
		<div class="container content">		
	        <?php if(isset($emailSent) && $emailSent == true) { ?>
                <p class="info">Richiesta inviata!</p>
            <?php } else { ?>
				<div id="contact-form">
				<h2>Salva la tua ricerca e ricevi gli annunci via Email </h2>
					<?php if(isset($hasError) || isset($captchaError) ) { ?>
                        <p class="alert">Errore, form non inviato</p>
                    <?php } ?>				
					<form id="contact-us" action="alert.php" method="post">
						<input type="text" name="tel" id="txtn" value="" class="" placeholder="tel:" />
						<div class="formblock">
							<label id="label_email" class="screen-reader-text">Email</label>&nbsp;
							<?php if($emailError != '') { ?>
								 <span class="error"><?php echo $emailError;?></span>
							<?php } ?>							
							<input type="text" name="email" id="email" value="<?php if(isset($_POST['email']))  echo $_POST['email'];?>" class="txt requiredField email" placeholder="Email:" />&nbsp;
						</div>
						<div class="formblock">
							<label class="screen-reader-text">Nome ricerca</label>&nbsp;
							<input type="text" name="nome" id="nome" value="<?php if(isset($_POST['nome']))  echo $_POST['nome'];?>" class="txt nome" placeholder="Nome ricerca:" />&nbsp;
						</div>						
						<button name="submit" type="submit" class="subbutton">Attiva gratis!!!</button>&nbsp;&nbsp;<img src="/images/alert2.gif" width="80" height="80" align="absmiddle" />	
						<input type="hidden" name="submitted" id="submitted" value="true" />
						<input type="hidden" name="sito" id="sito" value="<?php echo servername($conn); ?>" />		
						<input type="hidden" name="ip" id="ip" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>" />						
					</form>									
				</div>				
			<?php } ?>
		</div>
    </div><!-- End #contact -->
<script type="text/javascript">
	<!--//--><![CDATA[//><!--
	$(document).ready(function() {
		$('form#contact-us').submit(function() {
			$('form#contact-us .error').remove();
			var hasError = false;
			$('.requiredField').each(function() {
				if($.trim($(this).val()) == '') {
					var labelText = $(this).prev('label').text();
					$(this).prev('label').text('Specificare una email.');
					$(this).addClass('inputError');
					hasError = true;
				} else if($(this).hasClass('email')) {
					var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
					if(!emailReg.test($.trim($(this).val()))) {
						var labelText = $(this).prev('label').text();
						$(this).prev().append('<span class="error">email non valida</span>');
						$(this).addClass('inputError');
						hasError = true;
					}
				}
			});
			if(!hasError) {
				var formInput = $(this).serialize();
				$.post($(this).attr('action'),formInput, function(data){
					$('form#contact-us').slideUp("fast", function() {				   
						$(this).before('<p class="tick"><strong>Grazie!</strong> Richiesta inviata.</p>');
					});
				});
			}
			
			return false;	
		});
	});
	//-->!]]>
</script>

</body>
</html>