<?php
//session_start();
//session_unset();
//session_destroy();
	 
include_once "includes/dbConnNew.php"; 

if (isset($_REQUEST["emailLogin"]) ){ $skipit='1';}else{
if (  ( $_COOKIE['cookieEmail'] > " ") && ( $_COOKIE['cookiePassword'] > " ")  ){

  $SelectStr = "SELECT * from users where Verified = 'Y' and  (Email =  '" . $_COOKIE['cookieEmail'] . "' or Lower(FAMILY_USER_NAME) =  '" .strtolower($_COOKIE["cookieEmail"]). "' ) and Password = '" . $_COOKIE['cookiePassword'] . "' LIMIT 1";
  
}
}
///*********************************
//* verify email addess and password
//**********************************
 if( isset($_REQUEST["emailLogin"]) || ( $SelectStr > " ")  ){
 
 if( $SelectStr > " "){ $x=1;}else{
    $SelectStr = "SELECT * from users where Verified = 'Y' and  (Email =  '" . $_REQUEST["emailLogin"] . "' or Lower(FAMILY_USER_NAME) =  '" .strtolower($_REQUEST["emailLogin"]). "' ) and Password = '" . $_REQUEST["passwordLogin"] . "' LIMIT 1";
   }
   
   $result = mysql_query($SelectStr) or die(mysql_error());
   if($myrow=mysql_fetch_array($result)){
      
	  //set a cookie
if (  ( $_COOKIE['cookieEmail'] > " ") && ( $_COOKIE['cookiePassword'] > " ")  ){
  $skipit = 1;
}else{  
	  setcookie("cookieEmail", $_REQUEST["emailLogin"], time()+3600*24*360 );
	  setcookie("cookiePassword", $_REQUEST["passwordLogin"], time()+3600*24*360 );	  
}
	  
	  //$loggedIn = "Y" ; 
      //session_register("loggedIn");
	  $_SESSION["loggedIn"] = "Y";
      
	  //$sessionUserID = $myrow["ID"];
      //session_register("sessionUserID");
	  $_SESSION["sessionUserID"] = $myrow["ID"];
	  $_SESSION["meet_people"] = $myrow["meet_people"];
	  

	   if($myrow["show_invite_slider"] == "N"){
		 $_SESSION["stillShowInviteGlide "] = "n";
	   }else{
		 $_SESSION["stillShowInviteGlide "] = "y"; 
	   }

	  
	  //$_SESSION["sessionUserID"] = $myrow["ID"];

      //$sessionFname = $myrow["First_Name"];
      //session_register("sessionFname");	
	  $_SESSION["sessionFname"] = $myrow["First_Name"];
	  
      //$sessionLname = $myrow["Last_Name"];
      //session_register("sessionLname");	
	  $_SESSION["sessionLname"] = $myrow["Last_Name"];
	  	  
	  
      //$sessionAvitar = $myrow["Photo"];
      //session_register("sessionAvitar");
	  $_SESSION["sessionAvitar"] = 	$myrow["Photo"];	  	  

      //$sessionGender = $myrow["Gender"];
      //session_register("sessionGender");	
	   $_SESSION["sessionGender"] = $myrow["Gender"];
	  
      //$sessionEmail = $myrow["Email"];
      //session_register("sessionEmail");	
	  $_SESSION["sessionEmail"] =	$myrow["Email"]; 
	  $_SESSION["sessionState"] =	$myrow["State_Reside"];
	  
      // for prem
	  
	  //dont want anyone to act as a trial in the system
	  if($myrow["Prem_Ind"] == "T"){
	    $myrow["Prem_Ind"] = "xxx";
	  }
	  
	  
	  if($myrow["Prem_Ind"] == "T"){
		  
		list($thisYear,$thisMonth,$thisDay) = explode("-", $myrow[Trial_Date]);
		$d2=mktime(0,0,0,date(m),date(d),date(Y));
		$d1=mktime(0,0,0,$thisMonth,$thisDay,$thisYear);
		$daysLeft = floor(($d2-$d1)/86400);
		
		if($daysLeft < "15"){
		  $_SESSION["sessionPremAccount"] =	$myrow["Prem_Account"]; 
		  $_SESSION["sessionPremInd"] =	"T"; 
		} else {
		  $_SESSION["sessionPremAccount"] =	$myrow["Prem_Account"]; 
		  $_SESSION["sessionPremInd"] =	"N"; 
		}
	  } else {
		$_SESSION["sessionPremAccount"] =	$myrow["Prem_Account"]; 
		$_SESSION["sessionPremInd"] =	$myrow["Prem_Ind"]; 
	  }
	  //end prem
	  
      $value = $myrow["ID"];
	  $inSixMonths = 60 * 60 * 24 * 180 + time();
	  setcookie("idCookie", $value, time() - 3600);
      setcookie("idCookie", $value, $inSixMonths);
	  
	  // # login
	  $logins = $myrow["login_times"] + 1 ;
	  $_SESSION["sessionTimein"] =	date('G:i Y-m-d');
	  $_SESSION["sessionTimeSpent"] =	$myrow["Time_Spent"];  

	  $todaysDate = date("Y-m-d H:i:s");
	  $sql = "update users set login_times = '$logins' ,Last_Logon = '$todaysDate' where ID = '".$_SESSION["sessionUserID"]."' ";
	  $result = mysql_query($sql) or die(mysql_error());
	  
	  
	  if($_REQUEST[fromPage] > " "){
	    header("Location: $_REQUEST[fromPage]");
	    exit();
	  }
	  
	  if($_SESSION[thePage] > " "){
	  header("Location: $_SESSION[thePage]");
	  exit();
	  } else {
	  header("Location: dashBoard.php");
	  exit();
	  }
   }
   else{
     header("Location: logonFailed.php?failed");
	 exit ;
   }
}else{
  header("Location: logonFailed.php?norequest");
  exit ;	
}

?>