Merhaba arkadaslar sitemde bugun kendilinden bi hata olustu hata söyle sitenin tam üstünde gözüküyor
<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home/sohbetnl/domains/sohbetnl.com/public_html/includes/updateonline.php</b> on line <b>11</b><br />
<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home/sohbetnl/domains/sohbetnl.com/public_html/includes/updateonline.php</b> on line <b>39</b><br />
<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home/sohbetnl/domains/sohbetnl.com/public_html/includes/updateonline.php</b> on line <b>42</b><br />
-------------
Böyle bi Hata Alıyorum
Upgradeonline.php dosyasıda bu sekil
<?php
$timestamp = time();
$expiration = $timestamp - 900;
$current_day = date('j');
$delete_results = mysql_query("DELETE FROM online WHERE online_date != '$current_day'");
if($userStatus != '1'){
$guest_result = mysql_query("SELECT * FROM online WHERE ip = '$ipaddress' && status = '0'");
$guest_count = mysql_num_rows($guest_result);
$update_results = mysql_query("UPDATE online SET isonline='0' WHERE ip='$ipaddress' && status = '1'");
if($guest_count != '0'){
$online_result = mysql_query("UPDATE online SET timestamp = '$timestamp', online_date = '$current_day', isonline = '1' WHERE ip = '$ipaddress' && status = '0'");
} else {
$online_result = mysql_query("INSERT INTO online (timestamp,online_date,isonline,status,played,ip)" .
"VALUES ('". $timestamp ."', '".$current_day."', '1', '0', '0', '". $ipaddress ."')");
}
} else {
$user_result = mysql_query("SELECT * FROM online WHERE uid = '$userId' && status = '1'");
$user_count = mysql_num_rows($user_result);
$update_results = mysql_query("UPDATE online SET isonline='0' WHERE ip='$ipaddress' && status = '0'");
if($user_count != '0'){
$online_result = mysql_query("UPDATE online SET timestamp = '$timestamp', online_date = '$current_day', isonline='1', ip='$ipaddress' WHERE uid = '$userId' && status = '1'");
} else {
$uuserName = escape_string($userName);
$online_result = mysql_query("INSERT INTO online (timestamp,online_date,isonline,status,played,ip,u id,username)".
"VALUES ('". $timestamp ."', '".$current_day."', '1', '1', '0', '". $ipaddress ."', '". $userId ."', '". $uuserName ."')");
}
}
$update_results = mysql_query("UPDATE online SET isonline = '0' WHERE timestamp < '$expiration'");
// Get online stats
$guests_online = mysql_query("SELECT * FROM online WHERE status = '0' && isonline = '1'");
$guests_online_number = mysql_num_rows($guests_online);
if ($memberlogin == '1') {
$members_online = mysql_query("SELECT * FROM online WHERE status = '1' && isonline = '1'");
$members_online_number = mysql_num_rows($members_online);
$total_online = $guests_online_number + $members_online_number;
$members_online_list = "";
if ($members_online_number > '0') {
$member_nr = "1";
while($members_row = mysql_fetch_array($members_online)) {
$mouserId = $members_row['uid'];
$mouserName = htmlentities($members_row['username']);
$members_online_list .= "<a href=\"".profileurl($mouserId,$mouserName)."\" target=\"_self\">".$mouserName."</a>";
if ($member_nr < $members_online_number) {
$members_online_list .= ", ";
$member_nr++;
}
}
}
} else {
$total_online = $guests_online_number;
}
?>
neden böyle bi hata verdi acaba yardımcı olurmusunuz..
Onarcade Updateonline.php hatası
1
●498
- 02-05-2009, 22:40:16Üyeliği durduruldutablonuz bozulmuş olabilir.
tablo ile ilgili sorgulalari phpmyadmin yada mysql in konsol uygulamasindan denerseniz asil sorunu görebilirsiniz