Topsites

Topsites

[Navigation]
[Featured Video]
skateboard videos View the Video
David Spence
Archive
skateboardcity
Hosted by MediaCatch
[Plugs]
- 'Evolution of Skate' DVD Give away!
- Initial's got a new deck design!
[Topsites]
Join '$maxdate' GROUP BY $Members.siteid ORDER BY hits DESC, avrating DESC"); } else if ($p == 1) { $site_info = mysql_query("SELECT $Members.title AS title, $Members.url AS url, count(*) AS hits, avg($IPLogg.vote) AS avrating, $Members.siteid AS id FROM $IPLogg,$Members WHERE $Members.siteid = $IPLogg.siteid AND $IPLogg.time > '$maxdate' GROUP BY $Members.siteid ORDER BY avrating DESC, hits DESC"); } $site_num = mysql_numrows($site_info); if ($f == "") $f = 0; $maxsites = $f + $TopListSize; if ($site_num > $maxsites) $site_num = $maxsites; $i = $f; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while ($i < $site_num) { $i2=$i+1; echo ""; echo ""; echo ""; echo ""; echo ""; $i++; } while ($i < $maxsites) { $i2=$i+1; echo ""; echo ""; echo ""; echo ""; echo ""; $i++; } echo ""; echo "
"; if ($f == 0) { echo " "; } else { $f2 = $f-$TopListSize; echo "PREV"; } echo ""; echo "Only votes from the latest $MaxDays are counted!"; echo "NEXT
RankSiteVotesHits 
$i2". mysql_result($site_info,$i,"title"). "". mysql_result($site_info,$i,"hits"). "VOTE
$i2Join $TopListName   
"; if ($f == 0) { echo " "; } else { $f2 = $f-$TopListSize; echo "PREV"; } echo ""; echo "NEXT
"; ?>
Script from Xavier Media Group