Jump to content


Photo

Can't login!


  • Please log in to reply
1 reply to this topic

#1 steelmanronald06

steelmanronald06
  • Staff Alumni
  • Advanced Member
  • 2,004 posts
  • LocationOk

Posted 19 September 2006 - 02:40 AM

Here are my lines. (note that you should not add the <?php and ?> to those lines..that is added for the sake of color :)

Lines 1 - 13
<?php

//Require the headers
require_once('../includes/headers.php');

//Require the db.php file
require_once('../includes/db.php');

//Require functions.php
require_once('../includes/functions.php');

//Require top layout
require_once('../includes/top.php');
?>

lines 44 - 98

<?php
	//Convert the password to md5
	$password = md5($password);
	
	//Run the validation query
	$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' AND activated='1'");
	
	//Get the result
	$login_check = mysql_num_rows($sql);
	
	//See if the login information was correct
	if($login_check > 0){
	while($row = mysql_fetch_array($sql)){
		foreach( $row AS $key => $val ){
			$$key = stripslashes( $val );
		}
		
		// Register some session variables!
        session_register('userid');
        $_SESSION['first_name'] = $userid;
		session_register('first_name');
		$_SESSION['first_name'] = $first_name;
		session_register('last_name');
		$_SESSION['last_name'] = $last_name;
        session_register('username');
        $_SESSION['username'] = $username;
		session_register('email_address');
		$_SESSION['email_address'] = $email_address;
		session_register('special_user');
		$_SESSION['user_level'] = $user_level;
		session_register('ban');
		$_SESSION['ban'] = $ban;
		
		//Update their last logon time
		mysql_query("UPDATE users SET last_login=now() WHERE userid='$userid'");
		
		//Show the bottom layout
		require_once('../includes/bot.php');
		
		//Output Buffering
		ob_start();
		
		//Reload to the success case
		header("Location: /lampgeekz/users/log.php?cmd=success");
		
		ob_flush();
		
		}
		
	}else{
		
		echo "You were not logged in! Your username and/or password were incorrect. Please try again!";
		echo $username;
		echo $password;
		
	}
?>

when I submit the form to it (this is all one switch which should work) i get this from the variables:

$username echos as: netgeek
$password echos as: 6a19bbb52d8327f9149be17eaf420c01


It matches the database, i checked it :), but I still get this:

You were not logged in! Your username and/or password were incorrect. Please try again!


now why would my custom error be thrown?  Is there something wrong with the mysql query that is making it where it does query the database right?  :'(

#2 steelmanronald06

steelmanronald06
  • Staff Alumni
  • Advanced Member
  • 2,004 posts
  • LocationOk

Posted 19 September 2006 - 02:40 AM

btw, headers.php contains session_start :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users