[HELP] Website Login Problem.

[Bituse]

Hello Folks
i need your help !!!
I have some error in logininc.php
PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home4/bitusealokin/public_html/inc/loginbar.inc.php on line 30

 Spoiler

<?PHP
  if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {
    ?>
					<table style="margin:20px auto;" id="loginnav">
						<tr> <td><?PHP echo ''.$_SESSION['user_coins'].''; ?> Coins</td>	</tr>						
						<tr><td><a href="?s=itemshop">Itemshop</a></td></tr>							
						<tr><td><a href="?s=voten">Vote 4 Us</a></td></tr>						
						<tr><td><a href="?s=spenden">Spenden</a></td></tr>	
						<tr><td><a href="?s=passwort">Daten</a></td></tr>											
						<tr><td><a href="?s=charaktere">Charaktere</a></td></tr>						
						<tr><td> <a href="?s=logout">Ausloggen</a></td></tr>	
					</table>
    <?PHP
  }
  else {
  
  
  if((isset($_POST['loginbtn']) && ($_POST['loginbtn']=="Login" || $_POST['loginbtn']=="login") )) 
  {
    if(!empty($_POST['userid']) && !empty($_POST['userpass']) && checkAnum($_POST['userid']) && checkAnum($_POST['userpass'])) 
    {
			$password = mysql_real_escape_string($_POST['userpass'])."fdmaklehg2l34";
		  $sqlCmd = "SELECT id,login,coins,web_admin,email
		  FROM account.account 
		  WHERE login 
		  LIKE '".mysql_real_escape_string($_POST['userid'])."' 
		  AND password=PASSWORD('".$password."') 
		  LIMIT 1";
		  $sqlQry = mysql_query($sqlCmd,$sqlServ);
		  if(mysql_num_rows($sqlQry)>0) 
			  {
			$getAdmin = mysql_fetch_object($sqlQry);
			$_SESSION['user_id'] = $getAdmin->id;
			$_SESSION['user_name'] = $getAdmin->login;
			$_SESSION['user_admin'] = $getAdmin->web_admin;
			$_SESSION['user_coins'] = $getAdmin->coins;
			$_SESSION['user_email'] = $getAdmin->email;
			$updateIP = mysql_query("UPDATE account.account SET web_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' WHERE id='".mysql_real_escape_string($getAdmin->id)."'",$sqlServ);
			//echo SuccessMessage("Sie haben sich erfolgreich eingeloggt und werden nun weitergeleitet.");
			echo'<meta http-equiv="refresh" content="0; URL=index.php?s=login"> ';
		  }

    }
  }  
  
  ?>
			<form action="?s=login" method="POST">
				<input placeholder="Benutzername" class="input" name="userid" type="text" size="30" maxlength="30" />
				<input placeholder="Passwort" class="input" name="userpass" type="password" size="30" maxlength="40" />
				<input type="submit" value="Login" class="button" name="loginbtn">
				<input value="Reset" type="reset"/>
				<br/><br/>
				<a href="?s=lostpw">Passwort vergessen?</a><br/>
				<a href="?s=register">Du hast noch keinen Account?</a>
			</form>  			
  <?PHP
  }
?>

#Push

[#-Abuse]

Its a English Homepage or Germany?

[Bituse]

Why does the language methers ?
the loginbar.inc.php show me error...

[He3o Crysis]

The mysql query was unsucessful. --> If an SQL query is unsucessful the mysql driver will set $sqlQry to false.

Try to check if the query was sucessful before by checking of $sqlQry is false.
Change "$sqlQry = mysql_query($sqlCmd,$sqlServ);" (line 29) to the following:

$sqlQry = mysql_query($sqlCmd,$sqlServ) or die(mysql_error());

DON'T DO THAT IF YOUR WEBSITE IS LIVE AND USED BY YOUR PLAYERS!

Come back with the error message you get then and I'll be pleased to help you!

- Crysis