There's the error:
CODE
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chatz/public_html/top/index.php on line 10
Failed: delete from uglymonkey_toplist where lastin < '2006-07-28 18:23:19' and total='0'
Failed: delete from uglymonkey_toplist where lastin < '2006-07-28 18:23:19' and total='0'
Here's the index page that I'm getting the error on:
CODE
<?php
include("config.php");
if ($purgedays>0){
$purgeseconds = $purgedays * 86400;
$olddate = strftime("%Y-%m-%d %H:%M:%S", time() - $purgeseconds);
$getid = mysql_query("SELECT * FROM uglymonkey_toplist where lastin < '$olddate' and total='0'");
while($get = mysql_fetch_array($getid)){
$lastin = $get['lastin'];
$total = $get['total'];
$name = $get['name'];
$id = $get['id'];
$sendto = $get['mail'];
$subject = "cult.toddywap.com toplist\n";
$message = "cult.toddywap.com, \n\nAs you did not send us any hits for the last $purgedays days, \nyour site, '$name', has been removed from the cult.toddywap.com top list.\nYou may register your site details again if you wish.\nYou need to send at least 1 hit every $purgedays days to keep your site active.";
mail($sendto, $subject, $message);
}
$sql = "delete from uglymonkey_toplist where lastin < '$olddate' and total='0'";
$result = mysql_query($sql) or die("Failed: $sql");
}
////////////////RESET COUNTERS////////////////
header("Content-type: text/vnd.wap.wml; charset=ISO-8859-1");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\"
\"http://www.wapforum.org/DTD/wml_1.1.xml\">\n";
echo '<wml>
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>';
echo "<card id=\"toplist\" title=\"cult.toddywap.com\"><p align=\"center\">";
$total = mysql_num_rows(mysql_query("select * from uglymonkey_toplist"));
$active = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2"));
$count1 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '1'"));
$count2 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '2'"));
$count3 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '3'"));
$count4 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '4'"));
$count5 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '5'"));
echo "<small><a href=\"top20.php\">+ Top 20 Sites +</a><br/><a href=\"http://wap.mmplatform.com/?s=6779\">+ Top Downloads +</a></small><br/>";
$sql = mysql_query("SELECT * FROM uglymonkey_toplist WHERE incoming>=2 ORDER BY incoming desc LIMIT 1");
while($row = mysql_fetch_array($sql)){
$go = $row['name'];
$id = $row['id'];
echo "<small><b><a href=\"viewsite.php?id=".$id."\"><img src=\"top.gif\" alt=\"\"/>".$row['name']."</a></b></small>";}
echo "</p><p align=\"left\">";
echo "<small><b>Categories:</b><br/><a href=\"viewcat.php?cat=1\"><img src=\"folder.gif\" alt=\"*\"/>Adult ($count1)</a><br/><a href=\"viewcat.php?cat=2\"><img src=\"folder.gif\" alt=\"*\"/>Downloads ($count2)</a><br/><a href=\"viewcat.php?cat=3\"><img src=\"folder.gif\" alt=\"*\"/>Portal ($count3)</a><br /><a href=\"viewcat.php?cat=4\"><img src=\"folder.gif\" alt=\"*\"/>Chat/Forum ($count4)</a><br /><a href=\"viewcat.php?cat=5\"><img src=\"folder.gif\" alt=\"*\"/>Other ($count5)</a><br/><a href=\"allsites.php\"><img src=\"dir.gif\" alt=\"*\"/>All Sites ($active)</a><br/>---<br/>
<a href=\"rules.wml\"><img src=\"wenload.gif\" alt=\"*\"/>Add Your Site</a><br/><a href=\"searchbox.php\"><img src=\"off.gif\" alt=\"*\"/>Search Engine</a><br/>---<br/>
<a href=\"edit.php\">-Login/Edit</a><br /><a href=\"newest.php\">-Newest sites</a><br /><a href=\"worst20.php\">-Worst sites</a><br /><a href=\"popular.php\">-Popular sites</a><br /><a href=\"about.wml\">-Information</a><br/>---<br /></small><small>registered sites: <b>$total</b></small><br/><small>active sites: <b>$active</b><br/>---<br/>sites sending no hits will be deleted after: <b>$purgedays days</b></small><small>
<br/>---<br/><a href=\"http://cult.toddywap.com\">wappyCULT</a>";
echo "<br/>---<br/>© wappyCULT 2006-2007";
echo "
</small></p></card></wml>";
?>
include("config.php");
if ($purgedays>0){
$purgeseconds = $purgedays * 86400;
$olddate = strftime("%Y-%m-%d %H:%M:%S", time() - $purgeseconds);
$getid = mysql_query("SELECT * FROM uglymonkey_toplist where lastin < '$olddate' and total='0'");
while($get = mysql_fetch_array($getid)){
$lastin = $get['lastin'];
$total = $get['total'];
$name = $get['name'];
$id = $get['id'];
$sendto = $get['mail'];
$subject = "cult.toddywap.com toplist\n";
$message = "cult.toddywap.com, \n\nAs you did not send us any hits for the last $purgedays days, \nyour site, '$name', has been removed from the cult.toddywap.com top list.\nYou may register your site details again if you wish.\nYou need to send at least 1 hit every $purgedays days to keep your site active.";
mail($sendto, $subject, $message);
}
$sql = "delete from uglymonkey_toplist where lastin < '$olddate' and total='0'";
$result = mysql_query($sql) or die("Failed: $sql");
}
////////////////RESET COUNTERS////////////////
header("Content-type: text/vnd.wap.wml; charset=ISO-8859-1");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\"
\"http://www.wapforum.org/DTD/wml_1.1.xml\">\n";
echo '<wml>
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>';
echo "<card id=\"toplist\" title=\"cult.toddywap.com\"><p align=\"center\">";
$total = mysql_num_rows(mysql_query("select * from uglymonkey_toplist"));
$active = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2"));
$count1 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '1'"));
$count2 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '2'"));
$count3 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '3'"));
$count4 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '4'"));
$count5 = mysql_num_rows(mysql_query("select * from uglymonkey_toplist WHERE incoming>=2 AND cat = '5'"));
echo "<small><a href=\"top20.php\">+ Top 20 Sites +</a><br/><a href=\"http://wap.mmplatform.com/?s=6779\">+ Top Downloads +</a></small><br/>";
$sql = mysql_query("SELECT * FROM uglymonkey_toplist WHERE incoming>=2 ORDER BY incoming desc LIMIT 1");
while($row = mysql_fetch_array($sql)){
$go = $row['name'];
$id = $row['id'];
echo "<small><b><a href=\"viewsite.php?id=".$id."\"><img src=\"top.gif\" alt=\"\"/>".$row['name']."</a></b></small>";}
echo "</p><p align=\"left\">";
echo "<small><b>Categories:</b><br/><a href=\"viewcat.php?cat=1\"><img src=\"folder.gif\" alt=\"*\"/>Adult ($count1)</a><br/><a href=\"viewcat.php?cat=2\"><img src=\"folder.gif\" alt=\"*\"/>Downloads ($count2)</a><br/><a href=\"viewcat.php?cat=3\"><img src=\"folder.gif\" alt=\"*\"/>Portal ($count3)</a><br /><a href=\"viewcat.php?cat=4\"><img src=\"folder.gif\" alt=\"*\"/>Chat/Forum ($count4)</a><br /><a href=\"viewcat.php?cat=5\"><img src=\"folder.gif\" alt=\"*\"/>Other ($count5)</a><br/><a href=\"allsites.php\"><img src=\"dir.gif\" alt=\"*\"/>All Sites ($active)</a><br/>---<br/>
<a href=\"rules.wml\"><img src=\"wenload.gif\" alt=\"*\"/>Add Your Site</a><br/><a href=\"searchbox.php\"><img src=\"off.gif\" alt=\"*\"/>Search Engine</a><br/>---<br/>
<a href=\"edit.php\">-Login/Edit</a><br /><a href=\"newest.php\">-Newest sites</a><br /><a href=\"worst20.php\">-Worst sites</a><br /><a href=\"popular.php\">-Popular sites</a><br /><a href=\"about.wml\">-Information</a><br/>---<br /></small><small>registered sites: <b>$total</b></small><br/><small>active sites: <b>$active</b><br/>---<br/>sites sending no hits will be deleted after: <b>$purgedays days</b></small><small>
<br/>---<br/><a href=\"http://cult.toddywap.com\">wappyCULT</a>";
echo "<br/>---<br/>© wappyCULT 2006-2007";
echo "
</small></p></card></wml>";
?>
Please help I need to get this up and running as soon as possible.Thanx
