friend 254 Posted June 24, 2014 Registo: Diz que já existe. Login: Diz que não existe. Dá me o seguinte erro de SQL: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in inchead.inc.php on line 14 head.inc.php <?PHP if(isset($_POST['submit']) && ($_POST['submit']=="login" || $_POST['submit']=="LOGIN" || $_POST['submit']=="Login")) { if(!empty($_POST['userid']) && !empty($_POST['userpass']) && checkAnum($_POST['userid']) && checkAnum($_POST['userpass'])) { $sqlCmd = "SELECT id,login,web_admin,email FROM account.account WHERE login LIKE '".mysql_real_escape_string($_POST['userid'])."' AND password=PASSWORD('".mysql_real_escape_string($_POST['userpass'])."') LIMIT 1"; $sqlQry = mysql_query($sqlCmd,$sqlServ);L14 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_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); } } } if(empty($_SESSION['user_id'])) { unset($_SESSION['user_id']); unset($_SESSION['user_name']); unset($_SESSION['user_admin']); unset($_SESSION['user_email']); } else { $sqlCmd = "SELECT id,login,web_admin,email FROM account.account WHERE web_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' AND id='".mysql_real_escape_string($_SESSION['user_id'])."' 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_email'] = $getAdmin->email; }else{unset($_SESSION['user_id']);unset($_SESSION['user_name']);unset($_SESSION['user_admin']);unset($_SESSION['user_email']);} } ?> config.inc.php <?PHP DEFINE('SQL_HOST', '192.168.5.100'); DEFINE('SQL_USER', 'root'); DEFINE('SQL_PASS', '123456'); DEFINE('SQL_HP_HOST', '192.168.5.100'); DEFINE('SQL_HP_USER', 'root'); DEFINE('SQL_HP_PASS', '123456'); DEFINE('SQL_HP_DB', 'account'); $serverSettings['titel_page']="Webseiten-Titel"; $serverSettings['titel']="Servername"; $serverSettings['url']="http://www.Servername.org"; $serverSettings['server_ip']="192.168.5.1"; $serverSettings['register_on']=true; $serverSettings['mail_activation']=false; $serverSettings['page_entries']=30; $serverSettings['reg_mail']='[email protected]'; $serverSettings['pass_mail']='[email protected]'; require("daten.inc.php"); ?> "Já foste tenho a Password da tua BD Huhuhuhu...." Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 Resolvido. Não tinha visto o ficheiro Install.php Share this post Link to post Share on other sites
0 Lordas Lordas 5 Posted June 24, 2014 if($sqlQry == false) { var_dump(mysql_error());}else { 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_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); }} Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 if($sqlQry == false) { var_dump(mysql_error()); } else { 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_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); } } Que faço com isso? ._. Share this post Link to post Share on other sites
0 Lordas Lordas 5 Posted June 24, 2014 Que faço com isso? ._. coloca no sitio onde estava apenas: 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_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); } Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 Notice: Undefined variable: sqlQry in inchead.inc.php on line 13string(0) "" Share this post Link to post Share on other sites
0 Lordas Lordas 5 Posted June 24, 2014 Notice: Undefined variable: sqlQry in inchead.inc.php on line 13string(0) "" Como assim? metes-te no sitio certo? a variavel tem de existir pois esta criada e iniciada logo em cima Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 Parse error: syntax error, unexpected end of file in inchead.inc.php on line 60 <?PHP if(isset($_POST['submit']) && ($_POST['submit']=="login" || $_POST['submit']=="LOGIN" || $_POST['submit']=="Login")) { if(!empty($_POST['userid']) && !empty($_POST['userpass']) && checkAnum($_POST['userid']) && checkAnum($_POST['userpass'])) { $sqlCmd = "SELECT id,login,web_admin,email FROM account.account WHERE login LIKE '".mysql_real_escape_string($_POST['userid'])."' AND password=PASSWORD('".mysql_real_escape_string($_POST['userpass'])."') LIMIT 1"; $sqlQry = mysql_query($sqlCmd,$sqlServ); if($sqlQry == false) { var_dump(mysql_error()); } else { 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_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); } } } if(empty($_SESSION['user_id'])) { unset($_SESSION['user_id']); unset($_SESSION['user_name']); unset($_SESSION['user_admin']); unset($_SESSION['user_email']); } else { $sqlCmd = "SELECT id,login,web_admin,email FROM account.account WHERE web_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' AND id='".mysql_real_escape_string($_SESSION['user_id'])."' 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_email'] = $getAdmin->email; }else{unset($_SESSION['user_id']);unset($_SESSION['user_name']);unset($_SESSION['user_admin']);unset($_SESSION['user_email']);} } ?> Share this post Link to post Share on other sites
0 Lordas Lordas 5 Posted June 24, 2014 falta-te fechar um aqui: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_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); } } } } Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 string(42) "Unknown column 'web_admin' in 'field list' Aparece no Topo da página de login. Share this post Link to post Share on other sites
0 Lordas Lordas 5 Posted June 24, 2014 string(42) "Unknown column 'web_admin' in 'field list' Aparece no Topo da página de login. Se nao existe nenhuma coluna na tua tabela chamada web_admin, então não pode usar uma coluna que nao existe... Quando chegar a casa ajudo-te melhor, mas podes ir continuando a tentar Share this post Link to post Share on other sites
0 .тιαgσ 624 Posted June 24, 2014 Basta ires a base de dados account, tabela account e criares a coluna web_admin Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 Basta ires a base de dados account, tabela account e criares a coluna web_admin Criei a tabela: web_admin type: integer length: 1 not null Share this post Link to post Share on other sites
0 .тιαgσ 624 Posted June 24, 2014 Nao e uma tabela que tens de criar, na tabela account cria a coluna web_admin Share this post Link to post Share on other sites
0 friend 254 Posted June 24, 2014 Nao e uma tabela que tens de criar, na tabela account cria a coluna web_admin Sim, foi isso que fiz xD Tabela/Coluna acaba por ser a mesma coisa :D Share this post Link to post Share on other sites
Share this post
Link to post
Share on other sites