<?php

session_start ( ) ;
$host = "127.0.0.1";
$usr = "root";
$pswd = "";
$db = "lvrlcdb";
$table = "playerdata";

$username = "Bruno Bandidez";
$password = "acb";
// Tens que meter o de baixo so meti assim para testar..
//$username = $_POST['username'];
//$password = $_POST['password'];

if ( $username && $password )
{
	$connect = mysql_connect ( "$host" , "$usr" , "$pswd" ) or die ( "Não é possivel connectar a base de dados!" ) ;
	mysql_select_db ( "$db" ) or die ( "Não foi encontrado a base de dados" ) ;

	$query = mysql_query ( "SELECT * FROM `$table` WHERE name='$username'" ) ;

	if ( !empty ( $query ) )
	{
		$numrows = mysql_num_rows ( $query ) ;

		if( $numrows != 0 )
		{
			while ( $row = mysql_fetch_assoc ( $query ) )
			{
				$dbusername = $row['username'];
				$dbpassword = $row['password'];
			}
			if ( ( $username == $dbusername ) && ( password == $dbpassword ) )
			{
				echo "Login successful - <a herf='membersarea.php'>Click here to enter the members area</a>";
				$_SESSION['username'] = $dbusername;
			}
			else
			{
				echo "Error: Password Incorreta!";
			}
		}
		else
		{
	        die ( "Este usuario não existe!" ) ;
		}
	}
	else
	{
		echo mysql_error ( );
		die ( ) ;
	}
}
else
{
	die ( "Ensira um username e password!" ) ;
}
?>