Uglymonkey Toplist Script Getting an error with this script, please help.

Chatz · August 2, 2006

I'm getting an error on the index page.Need help to fix it please.

There's the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chatz/public_html/top/index.php on line 10Failed: 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:

<?phpinclude("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://forums.xisto.com/no_longer_exists/ '<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

wappy · August 2, 2006

o look my stolen toplist script lol.. Should i help.. Mmm.
This server has a different mysql version than i was using before thats why it don't work he he.
Ok i really don't know why im helping you clone me but use the sql from the file toplist.zip in my scripts folder on http://forums.xisto.com/no_longer_exists/ instead of the original one lol

toddy · August 2, 2006

Didnt even bother to change the tiltles =o] You probably havent set a databses up, or your using the ugly_monkey original database setup

wappy · August 2, 2006

yes toddy he will be because when dj.dumb uploaded my script to gumslone's site he assumed i used the original sql.. So he posted the ugly monkey sql not my sql ho ho ho ho. :-) also that script is rubbish. I made a few mistakes and am working on a new toplist for my site which will be much better. Enjoy trying to fix my errors and GOOD LUCK ha ha :-)

Chatz · August 2, 2006

Fixing your erros shouldn't be a promblem since i'm one of the best coders on wap.I mean ravingwap probly had more erros than this script and i fixed ravingwap script 100% error free didn't I.The only thing i didn't get was this error but now it's clear that the server is different.Anyway thanx wappy.

wappy · August 2, 2006

you fixed raving script? Where? Best coder on wap? Sorry but your not? Lol where is this raving fixed and uploaded i want to see? An the errors are not fixable they are huge mistakes, so huge infact that i started again from scratch with a new top list.Whats your site url i wanna see?An if you really have fixed the raving script fully you wanna share? Just uploaded 26 new scripts to my folder.But you can't go round saying you the best coder with people like ahmet, gumslone etc pmpl your funny.---o and btw check the raving script with more phones. Mine works fully on my nokia6630 or any s60, but it don't work fully on my nokia6230 or any s40. It has some real strange file format unknown errors.

Edited August 2, 2006 by wappy (see edit history)

thehate · December 3, 2006

you fixed raving script? Where? Best coder on wap? Sorry but your not? Lol where is this raving fixed and uploaded i want to see? An the errors are not fixable they are huge mistakes, so huge infact that i started again from scratch with a new top list.Whats your site url i wanna see?
An if you really have fixed the raving script fully you wanna share? Just uploaded 26 new scripts to my folder.
But you can't go round saying you the best coder with people like ahmet, gumslone etc pmpl your funny.
---
o and btw check the raving script with more phones. Mine works fully on my nokia6630 or any s60, but it don't work fully on my nokia6230 or any s40. It has some real strange file format unknown errors.

fool

juice · January 4, 2007

Rather use the ravingwap toplist script. It supports unlimited categories, more than one site per registration, easy to administrate - no need to go into the database everytime and it was released so it is not illegal to use it. Search google for it since the site that had it closed down.

Sign In

Uglymonkey Toplist Script Getting an error with this script, please help.

Recommended Posts

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Important Information