Yet another error

[Rob]

Well, I log in to the mmorpg yet it always says its the wrong username or password even if its right.

Code: Select all

<?php
include_once 'connect.php';
session_start();

if (isset($_POST['submit']))
{
	$player=$_POST['player'];
	$password=$_POST['password'];
	$player=strip_tags($player);
	$password=strip_tags($password);
	$password=md5($password);
	
	$query = "select name,password from players where name='$player' and 'password'";
	$result = mysql_query($query) or die("Could not query players");
	$result2 = mysql_fetch_array($result);
	if ($result2)
	{
		$_SESSION['player']=$player;
		
		echo "<big>Logged in successfully<br>";
		echo "<a href='battle.php'>Continue</a></big>";
	}
	else
	{
		echo "<big>Wrong username or password. <a href='login.php'>Try again.</a></big>";
	}
}
?>

[Torniquet]

my guess would be the following line..


$query = "select name,password from players where name='$player' and 'password'";



try

$query = "select name,password from players where name='$player' and password='$password'";

[Noctrine]

You guys' queries always look so nasty ><

[Rob]

Its still not logging in.

Code: Select all

<?php
include_once 'connect.php';
session_start();

if (isset($_POST['submit']))
{
	$player=$_POST['player'];
	$password=$_POST['password'];
	$player=strip_tags($player);
	$password=strip_tags($password);
	$password=md5($password);
	
	$query = "select name,password from players where name='$player' and password='$password'";
	$result = mysql_query($query) or die("Could not query players");
	$result2 = mysql_fetch_array($result);
	if ($result2)
	{
		$_SESSION['player']=$player;
		
		echo "<big>Logged in successfully<br>";
		echo "<a href='battle.php'>Continue</a></big>";
	}
	else
	{
		echo "<big>Wrong username or password. <a href='login.php'>Try again.</a></big>";
	}
}
?>

[hallsofvallhalla]

is it actually saying "wrong username or password"?

check you database and make sure all feilds in the players table are exactly the same, no capitals, ect... This has been 95% of the erros we have seen so far from users. take a screen shot of your players table in your database.

[Rob]

as you can see, i even put player one's email the same as the tutorial, but I dont use him to login I use the others

http://img16.imageshack.us/img16/5238/l ... tmmorp.png

[hallsofvallhalla]

what happens if you just put player1 as username and nothing for the password?

also post your register.php here

[Rob]

Code: Select all

<?php
include 'connect.php';

?>

<form method="post" action="reguser.php">
Type Username Here: <input type="text" name="player" size="21"><br>
Type Password Here: <input type="text" name="password" size="15"><br>
ReType Password Here: <input type="text" name="pass2" size="15"><br>
Type Email Address: <input type="text" name="email" size="55"><br>

<input type="submit" value="Submit">

[hallsofvallhalla]

very strange indeed, what happens when you try to use player1 login?

[Rob]

the same, Wrong username and password...

do you want my ip so you can try it out?