Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/oldang/public_html/fclub/enter.php on line 46
Помогите, че нужно сделать чтоб избавиться? см. далее сам код страницы:
<?php include "connect.php"; $data = mysql_fetch_array(mysql_query("SELECT * FROM .users. WHERE .login. = '{$_POST['login']}' AND .pass. = '".md5($_POST['psw'])."' LIMIT 1;")); if ($data[0] == null) { echo "<html><head><META http-equiv=Content-type content='text/html; charset=windows-1251'><title>Онлайн игра Ардания</title></head><body><BR>Неверный пароль, войдите с <a href=index.php>главной страницы</a>.<BR><BR><BR><hr><table width=100%><tr><td align=left><b><a href='javascript:window.history.go(-1);'>Назад</a></b></td><td align=right></td></tr></table></body></html>"; } elseif($data['block']==1) { echo "<html><head><META http-equiv=Content-type content='text/html; charset=windows-1251'><title>Онлайн игра Ардания</title></head><body><BR>Онлайн игра Ардания<BR><BR><BR><hr><table width=100%><tr><td align=left><b><a href='javascript:window.history.go(-1);'>Назад</a></b></td><td align=right></td></tr></table></body></html>"; } else { include("functions.php"); session_start(); //delo_multi if($_COOKIE['battle']!= null && $data['id'] != $_COOKIE['battle']) { mysql_query("INSERT INTO .delo_multi. (.idperslater.,.idpersnow.) values ('".$_COOKIE['battle']."','".$data['id']."');"); } /// setcookie("battle", $data['id']); $_SESSION['uid'] = $data['id']; mysql_query("UPDATE .online. SET .date. = ".time()." WHERE .id. = {$data['id']};"); mysql_query("UPDATE .users. SET .sid. = '".session_id()."' WHERE .id. = {$data['id']};"); $_SESSION['sid'] = session_id(); //mysql_query("UPDATE .users. SET .ip. = '".$_SERVER['REMOTE_ADDR']."' WHERE .id. = {$data['id']};"); if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet { $ip=$_SERVER['HTTP_CLIENT_IP']; } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy { $ip=$_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip=$_SERVER['REMOTE_ADDR']; } $time_now=time(); mysql_query("INSERT INTO .iplog. (owner,ip,date) values ('".$data['id']."','$ip','$time_now');"); addch ("Вас приветствует <a href=javascript:top.AddTo(\"".$data['login']."\")><span oncontextmenu=\"OpenMenu()\">".$data['login']."</span></a>! ",$data['room']); $rs=mysql_query("SELECT * FROM .telegraph. WHERE .owner. = '".$data['id']."';"); mysql_query("DELETE FROM .telegraph. WHERE .owner. = '".$data['id']."';"); while($r = mysql_fetch_array($rs)) { addchp ($r['text'],'{[]}'.$data['login'].'{[]}'); } ##header("Location:fight.php"); $getLastID = mysql_fetch_row(mysql_query("SELECT max(id) FROM .chat. ")) or die(mysql_error()); mysql_query("UPDATE person SET chat_last_id = {$getLastID[0]} WHERE user = '{$inf['user']}' "); } ?>