<?


require_once('../connection/mlsMain.php');
session_start();


$grabShow = $_GET['show'];
$grabT = $_GET['t'];
$grabM = $_GET['m'];
$findUser = $_SESSION['MM_Username'];


if (isset($_SESSION['redirectPage'])) { 
    $redirectTo = $_SESSION['redirectPage']; 
} else {
    $redirectTo = "clients/welcome"; 
}


// Establish Form Actions
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}


// *** Validate request to login to this site.
if (isset($_POST['log_user'])) {
  $loginUsername=$_POST['log_user'];
  $password=$_POST['log_pass'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "$redirectTo";
  $MM_redirectLoginFailed = "features?show=fail";
  $MM_redirecttoReferrer = false;
      
  $LoginRS__query=sprintf("SELECT user_email, user_pass FROM user_data WHERE user_email='$loginUsername' AND user_pass=SHA2('$password', 512)");
   
  $LoginRS = mysqli_query($mlsMain, $LoginRS__query) or die(mysqli_error());
  $loginFoundUser = mysqli_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
	if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}


// Add A New User
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addForm")) {
    
    $grabFirst = $_POST['user_first'];
    $grabLast = $_POST['user_last'];
    $grabPhone = $_POST['user_phone'];
    $grabEmail = $_POST['user_email'];
    $grabPass = $_POST['user_pass'];
    $redirectSuccess = "features?show=success";
    $redirectExist = "features?show=noReg";
    $redirectFailed = "features?show=problem";
    
    
    // Run Check To Seee If User Exists
    $query_rsCheckUser = "SELECT user_id, user_email
	             FROM user_data
                 WHERE user_email = '".$grabEmail."'";
    $r_CheckUser = mysqli_query($mlsMain, $query_rsCheckUser);
    $row_rsCheckUser = mysqli_fetch_array($r_CheckUser, MYSQLI_ASSOC);
    $totalRows_rsCheckUser = mysqli_num_rows($r_CheckUser);
    
    
    if ($totalRows_rsCheckUser > '0') { // Email already exists
            header("Location: " . $redirectExist );
    } else {
    
      $insertSQL = "INSERT INTO user_data (user_first, user_last, user_phone, user_email, user_pass) VALUES ('$grabFirst', '$grabLast', '$grabPhone', '$grabEmail', SHA2('$grabPass', 512))";

      if (mysqli_query($mlsMain, $insertSQL)) {
                header("Location: " . $redirectTo );
            } else {
                header("Location: " . $redirectFailed );
            }
    }
}
    
    
$query_rsUser = "SELECT user_id, user_email
	             FROM user_data
                 WHERE user_email = '".$findUser."'";
$r_User = mysqli_query($mlsMain, $query_rsUser);
$row_rsUser = mysqli_fetch_array($r_User, MYSQLI_ASSOC);
$totalRows_rsUser = mysqli_num_rows($r_User);

$getUserId = $row_rsUser['user_id'];


$query_rsSave = "SELECT user_id, mls_id
	             FROM save_list
                 WHERE user_id = '".$getUserId."' AND mls_id > '0'";
$r_Save = mysqli_query($mlsMain, $query_rsSave);
$row_rsSave = mysqli_fetch_array($r_Save, MYSQLI_ASSOC);
$totalRows_rsSave = mysqli_num_rows($r_Save);
    

if ($totalRows_rsUser > '0') {
    
    $insertGoTo = "/clients/welcome";
    header(sprintf("Location: %s", $insertGoTo));
}


// send email if user forgot password
if ((isset($_POST["MM_insert2"])) && ($_POST["MM_insert2"] == "reqPassForm")) {
	
	$to = $_POST['req_user'];
	
	$query_rsUser = "SELECT user_id, user_email
	                 FROM user_data
                     WHERE user_email = '$to'";
	$r_User = mysqli_query($mlsMain, $query_rsUser);
    $row_rsUser = mysqli_fetch_array($r_User, MYSQLI_ASSOC);
    $totalRows_rsUser = mysqli_num_rows($r_User);
	
	
	$grabId = $row_rsUser['user_id'];
	$checkUser = $row_rsUser['user_email'];
	$grabUser = $row_rsUser['user_email'];
	$grabFrom = "info@solituderealty.com";
	$resetLink = "https://solituderealty.com/loginReset?uId=$grabId";

	
	$from = $grabFrom;
	$subject = "Password Request";
	$body = "
	<html>
    <head>
    <style>

    h2 {
        text-align: center;
        font-family: 'Exo 2', sans-serif;
        font-size: 16px;
        font-weight: bold;
        color: #000;
    }

    #header {
        background: url(http://solituderealty.com/graphics/SOL-IconLogo150px.png) no-repeat top center;
        height: 200px;
        padding-top: 50px;
        width: 100%;
    }

    #mainContent {
        width: 95%;
        padding: 10px 10px 10px 10px;	
    }

    .buttonStyle {
        width: 200px; 
        padding: 5px 5px 5px 5px;
        margin: 5px 5px 5px 5px;
        moz-border-radius: 5px;
        -webkit-border-radius: 5px;
        border: 1px solid #999;
        color: #000;
        background-color: #66CCFF;
    }

    .buttonStyle:hover {
        color: #FFF;
        background-color: #80ddff;
        box-shadow: #64686e 0px 0px 1px 1px;
        -moz-box-shadow: #64686e 0px 0px 1px 1px;
        -webkit-box-shadow: #64686e 0px 0px 1px 1px;
    }

    .buttonStyle a {
        text-decoration: none;
    }

    .buttonStyle a:hover {
        color: #FFF;
    }

    </style>
    </head>

    <body>

    <div id=\"header\"></div>
    <hr>
    <br>
    <h2>Please click on the link below to reset your password:</h2>
    <br />
    Username: $grabUser<br /><br /><br />
    <a href=$resetLink><span class=buttonStyle>Click Here To Reset Your Password</span></a><br />
    </p>

    ";

      $headers  = "MIME-Version: 1.0\r\n";
      $headers .= "Content-type: text/html; charset=utf-8\r\n";
      $headers .= "From: Solitude Realty <" . $from . ">\r\n";


     if ($checkUser) {
        mail($to, $subject, $body, $headers);
 

     $_SERVER['QUERY_STRING'] = "";
  	 $insertGoTo = "features?show=req";
          if (isset($_SERVER['QUERY_STRING'])) {
            $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
            $insertGoTo .= $_SERVER['QUERY_STRING'];
          }
  header(sprintf("Location: %s", $insertGoTo));
  
} else {

$_SERVER['QUERY_STRING'] = "";
  	$insertGoTo = "features?show=notFound";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

}
?>
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="subject" content="Lake Tahoe Real Estate" />
<meta name="category" content="Lake Tahoe Real Estate" />
<meta name="description" content="Lake Tahoe Real Estate Search Engine" />
<meta name="author" content="License Masters, Inc." />
<meta name="robots" content="follow" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="revisit-after" content="7 days" .h, />
<title>Solitude Lake Tahoe Real Estate Brokerage | Find Your Solitude</title>
<script src="http://www.solituderealty.com/scripts/rotatingChat.js"></script>
<link href="graphics/css/global.css" rel="stylesheet" type="text/css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<style> 
    
#loginForm {
    float: left;
    width: 40%;
    border: 1px solid #000;
    margin: 40px 10px 10px 5%;
}
    
#regForm {
    float: left;
    width: 40%;
    border: 1px solid #000;
    margin: 40px 10px 10px 5%;
}
    
.topBarForm {
    width: 95%;
    height: 30px;
    background-color: #98a3b2;
    padding: 40px 0px 0px 5%;
    color: #FFF;
}
    
.topBarFormTwo {
    width: 95%;
    height: 30px;
    background-color: #147b9d;
    padding: 40px 0px 0px 5%;
    color: #FFF;
}
    
#loginForm input[type=text], #regForm input[type=text],#loginForm input[type=email], #regForm input[type=email], #loginForm input[type=password], #regForm input[type=password] {
    width: 90%;
    transition: ease-in-out, width .35s ease-in-out;
	margin: 5px 2% 5px 2%;
	height: 20px;
}
    
#reqPassForm input[type=email] {
    width: 30%;
    transition: ease-in-out, width .35s ease-in-out;
	margin: 5px 2% 5px 5px;
	height: 20px;
}

#regForm input[name=user_first], #regForm input[name=user_last] {
	width: 42%;	
	transition: ease-in-out, width .35s ease-in-out;
	margin: 5px 5px;
	height: 20px;
}

#reqPassForm input[type=email]:focus, #loginForm input[type=text]:focus, #regForm input[type=text]:focus, #loginForm input[type=email]:focus, #regForm input[type=email]:focus, #loginForm input[type=password]:focus, #regForm input[type=password]:focus {
    background-color: #FFC;
}
    
@media screen and (max-width: 650px) { 

#loginForm {
    float: none;
    width: 90%;
    border: 1px solid #000;
    margin: 40px 10px 10px 5%;
}
    
#regForm {
    float: none;
    width: 90%;
    border: 1px solid #000;
    margin: 40px 10px 10px 5%;
}
  
#regForm input[name=user_first], #regForm input[name=user_last] {
	width: 90%;	
	transition: ease-in-out, width .35s ease-in-out;
	margin: 5px 5px;
	height: 20px;
}
    
}
    
</style>
</head>

<body>
    <header>
        <? include("includes/header.php"); ?>
    </header>
    <main>
        <br>
        <h2>
            Register or Login To Proceed
        </h2>
        <br>
        <? if ($grabShow == "loginNeeded") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    In Order To Save Listings You Must First Login / Register With Our Website
                </strong>
            </p>
        <div class="clear"></div>
        <? } else if ($grabShow == "fail") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    Sorry, That Information Is Not Listed With Our Site
                </strong>
                <br><br>
                Please Click Here To Request Your Password Or Try To Login Again
            </p>
        <div class="clear"></div>
        <? } else if ($grabShow == "noReg") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    Sorry, That Information Is Already Listed With Our Site
                </strong>
                <br><br>
                <a href="features.php?show=fail">
                    Please Click Here To Request Your Password Or Try To Login
                </a>
            </p>
        <div class="clear"></div>
        <? } else if ($grabShow == "problem") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    Sorry, We Had An Error With Your Registration
                </strong>
                <br><br>
                Please Try To Login Or Call Us At 530-318-0411 To Register
            </p>
        <div class="clear"></div>
        <? } else if ($grabShow == "req") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    Please Check Your Email. This May Take A Few Minites
                </strong>
                <br><br>
                Use The Link In Your Email To Reset Your Password
            </p>
        <div class="clear"></div>
        <? } else if ($grabShow == "success") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    PASSWORD RESET! Please Login To Continue
                </strong>
                <br><br>
            </p>
        <div class="clear"></div>
        <? } else if ($grabShow == "notFound") { ?>
            <br><br><br>
            <p align="center">
                <strong>
                    Sorry, We Do Not Have That Email Address Listed With Our Website
                </strong>
                <br><br>
                Please Register Using The Form Below
            </p>
        <div class="clear"></div>
        <? } ?>
        <? if ($grabShow == "fail")  { ?>
            <p align="center">
                <span class=redText>
                    Use the form below to request your password.
                </span>
            </p>             
            <p>
                <form action="" method="POST" name="reqPassForm" id="reqPassForm">
                    <br>
                    <p align="center">
                          Email Address:<br />
                          <input type="email" name="req_user" value="" size="30" required />
                    </p>
                    <br>
                    <p align="center">
                        <input type="submit" value="Request Password"  />
                    </p>
                    <input type="hidden" name="MM_insert2" value="reqPassForm" />
              </form>
            </p>
            <br><br><br>
            <p align="center">
                <span class="buttonStyle">
                    <a href="features.php">
                        Try To Login Again
                    </a>
                </span>
            </p>
            <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
        <? } else { ?>
            <div id="loginForm">
                <form action="" method="POST" name="logForm" id="logForm">
                   <p class="topBarFormTwo">
                        <strong>
                            <i>
                                Login to Solitude
                            </i>
                        </strong>
                    </p>
                    <br>
                    <p align="center">
                        <input type="email" name="log_user" value="" size="30" placeholder="Email Address"  required />
                    </p>
                    <br>
                    <p align="center">
                        <input type="password" name="log_pass" value="" size="30" placeholder="Password" required />
                    </p>
                    <br>
                    <p align="center">
                        <input type="submit" value="login" class="buttonStyle" />
                    </p>
                    <input type="hidden" name="MM_insert" value="logForm" />
                </form>
            </div>
            <div id="regForm">
                <form action="" method="POST" name="addForm" id="addForm">
                    <p class="topBarForm">
                        <strong>
                            <i>
                                Register for Solitdue
                            </i>
                        </strong>
                    </p>
                    <br>
                    <p align="center">
                        <input type="text" name="user_first" value="" size="30" placeholder="First Name"  required />
                        &nbsp;
                        <input type="Text" name="user_last" value="" size="30" placeholder="Last Name"  required />
                    </p>
                    <br>
                    <br>
                    <p align="center">
                        <input type="text" name="user_phone" value="" size="30" placeholder="Phone Number"  required />
                    </p>
                    <br>
                    <br>
                    <p align="center">
                        <input type="email" name="user_email" value="" size="30" placeholder="Email Address"  required />
                    </p>
                    <br>
                    <p align="center">
                        <input type="password" name="user_pass" value="" size="30" placeholder="Password" required />
                    </p>
                    <br>
                    <p align="center">
                        <input type="submit" value="Register" class="buttonStyle" />
                    </p>
                    <input type="hidden" name="MM_insert" value="addForm" />
                </form>
            </div>
        <? } ?>
        <div class="clear"></div>
    </main>
    <aside>
        <br><br><br><br><br><br><br><br><br><br><br>
    </aside>
    <section>
        
    </section> 
    <footer>
        <? include("includes/footer.php"); ?>
    </footer>
    <script src="http://www.solituderealty.com/scripts/headerJS.js"></script>
</body>
</html>
<? 
/* free result set & close connection */
mysqli_free_result($result);
mysqli_close($mlsMain);

?>