Login Script

[konigwolf]

Hey I Wrote I Login Script For My RPG And Need Help WIth The Cookies.

[chads2k2]

Throw up some code and let's see what you have going on.

Chad

[konigwolf]

<?
setcookie ("one", $pass, time()+3600);  

setcookie ("two", $user, time()+3600);  

setcookie ("three", $status, time()+3600); 

$pass = $_COOKIE['one'];
$user = $_COOKIE['two'];
$status = $_COOKIE['three'];
?>

<?

$result1 = mysql_query("SELECT * FROM `accounts` WHERE `rpg_user` = '$user' LIMIT 1");
while($info=mysql_fetch_array($result1))
{	
	$id=$info["rpg_id"];
	$username=$info["rpg_user"];
	$password=$info["rpg_pass"];
	$email=$info["rpg_email"];
	$energy=$info["rpg_energy"];
	$rpgd_x=$info["rpg_x"];
	$rpgd_y=$info["rpg_y"];
	$rank=$info["rpg_rank"];
	$char=$info["rpg_char"];
	$os=$info["rpg_os"];
	$maxhp=$info["rpg_maxhp"];
	$hits=$info["rpg_hits"];
	$hp=$info["rpg_hp"];
	$maxe=$info["rpg_maxenergy"];			
}
//Change To Multi-User Later Using Database.
if(($user == $username)  &&  (md5($pass) == $password))
{
   $status = "loggedin";
   $result5 = mysql_query("UPDATE `accounts` SET `rpg_os` = 'online' WHERE `rpg_id` = '$id' LIMIT 1 ");
}
else
{
$status = "loggedout";
}
if ($status == "loggedout") 
{
   echo "<form name=\"login\" method=\"post\" action=\"\" >
          <strong><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">Username:</strong></font>&nbsp;&nbsp;<input name=\"user\" type=\"text\" class=\"form\">&nbsp;&nbsp;

      <strong><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">Password:</strong></font>&nbsp;&nbsp;<input name=\"pass\" type=\"password\" class=\"form\">&nbsp;&nbsp;

      <input type=\"submit\" name=\"submit\" value=\"Submit\" class=\"submit\">
    </form>";
}
?>

[konigwolf]

Should I Post The Movement Script.

[konigwolf]

Would SID Help And How Does It Work.

[konigwolf]

Anyone Know How To Help.

[okuto1973]

The first step is to write correctly the string query.......

$result1 = mysql_query("SELECT * FROM accounts WHERE rpg_user= '$user' LIMIT 1");

and not....

$result1 = mysql_query("SELECT * FROM accounts WHERE rpg_user = '$user' LIMIT 1");

[konigwolf]

You Sure It Comes Up With Resource Errors Thats Why I Changed It And I Can Actually Log In Just Can't Stay Logged In.

[konigwolf]

didn't work.

[konigwolf]

Any Other Advice Can Someone Tell Me How To Use SID.

[konigwolf]

Hey If You Can't Help Cause You Need To See The Script Instant Message Me.

[konigwolf]

bump