
<!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>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>



<script language="JavaScript" type="text/javascript">

<!--

function getsupport ()

{

  document.loginErrorForm.submit();

}

-->

</script>



</head>



<body>



<?php

//First lets get the username and password from the user

$username = $_POST["loginName"];

$password = $_POST["loginPass"];



$password = md5($password);

$password = substr($password,0,8);



//echo $username;

//echo $password;







$connection = new PDO("pgsql:dbname=natesladder host=cs.georgefox.edu password=natepost00 user=ngeorgeson","ngeorgeson","natepost00");



//Second let's check if that username and password are correct and found in our database

$result = $connection->query("SELECT * FROM Player WHERE username='$username' AND password='$password' AND active=true");



$array = $result->fetchAll();





if ($array[0] == NULL)

{ 

    echo "<form id='loginErrorForm' name='loginErrorForm' method='post' action='ladder.php'>";

    echo "<input name='loginError' type='hidden' id='loginError' value='Username or Password Invalid!' />";

    echo "<script type='text/javascript'>";

    echo "getsupport()";

    echo "</script>";

    echo "</form>";

}



if ($array[0] != NULL)

{



    session_start();

    

    $_SESSION['currentUser'] = $username;

    

    //echo $_SESSION['currentUser'];



    header ("Location: userhub.php"); 

}



$connection = NULL;



?>



</body>

</html>