<?php require_once('Connections/FitConnec.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_FitConnec, $FitConnec);
$query_Recordset2 = "SELECT fit.`Matrix number`, fit.Password FROM fit";
$Recordset2 = mysql_query($query_Recordset2, $FitConnec) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

mysql_select_db($database_FitConnec, $FitConnec);
$query_Recordset1 = "SELECT fit.`Matrix number`, fit.Password FROM fit";
$Recordset1 = mysql_query($query_Recordset1, $FitConnec) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['matricnumber'])) {
  $loginUsername=$_POST['matricnumber'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "Userlevel";
  $MM_redirectLoginSuccess = "home.php";
  $MM_redirectLoginFailed = "fail.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_FitConnec, $FitConnec);
  	
  $LoginRS__query=sprintf("SELECT `Matrix number`, Password, Userlevel FROM fit WHERE `Matrix number`=%s AND Password=%s",
  GetSQLValueString($loginUsername, "-1"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $FitConnec) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
    
    $loginStrGroup  = mysql_result($LoginRS,0,'Userlevel');
    
	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 );
  }
}
?>
<!DOCTYPE html>
<html>
  <head>
    <title>FIT Store</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- Bootstrap -->
    <link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" media="screen">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="viewport" content="width=device-width">
  <style type="text/css">

    #main
    {
    position:relative;
        width:200px;
		
    }

    .floatdiv
    {
    float:left;
        width=80px
    }
	
	  body {
	background-image: url(purple-galaxy.png);
	background-repeat: no-repeat;
}
    </style>
  <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css">
  <!-- Mobile -->
  <link href="css/mobile.min.css" rel="stylesheet" type="text/css" media="only screen and (max-width:800px)">
  <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
  </head>
<body>
     <script src="http://code.jquery.com/jquery.js"></script>
  <script src="js/bootstrap.min.js"></script>
  
  
  
<div class="navbar navbar-inverse">
  <div class="navbar-inner">
  <a class="brand divider" href="">FIT Store</a>
  <ul class="nav">
    <li class="active">
    <li ><a href="Sign up.php">Sign Up</a></li>
    <li class="active"><a href="Login.php">Login</a></li>
    <li><a href="admin.php">Admin</a></li>
  </ul>
  </div>
</div>



<p>&nbsp;</p>
<p>&nbsp;</p>
<fieldset>
  <legend>Please Log In</legend>
  <p>&nbsp;</p>
  <form name="form1" method="POST" action="<?php echo $loginFormAction; ?>">
    <p><span id="sprytextfield3">
    <label for="matricnumber">Matric No:
      <input name="matricnumber" type="text" id="matricnumber" value="99999">
      <br>
    </label>
    <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></p>
    <p><span id="sprytextfield1">
      <label for="password">Password:
        <input type="password" name="password" id="password">
      </label>
      <span class="textfieldRequiredMsg">A value is required.</span></span></p>
    <p><span id="sprytextfield2"><span class="textfieldRequiredMsg"> value is required.</span></span></p>
    <p>
      <input type="submit" value="Login" style="position:absolute;top:72%;left:375%;">
      <input type="submit" name="login" id="login" value="login">
    </p>
    <p>
      <input type="submit" value="Login" style="position:absolute;top:72%;left:375%;">
    </p>
    <p>
      <input type="submit" value="Login" style="position:absolute;top:72%;left:375%;">
    </p>
  </form>
  <p>If your are new member, please sign up first. Thank you.</p>
  <p>
    <a href="Sign up.php">
    <input type="submit" name="login2" id="login2" value="Sign up">
  </a></p>
</fieldset>
            
  </p>
</form>
<script type="text/javascript">
var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2");
var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "real");
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1");
</script>
</body>
    
  </body>

<?php
mysql_free_result($Recordset2);

mysql_free_result($Recordset1);
?>
