Open new file.
<?PHP
include_once(\"header.php\");
include_once(\"config.php\");
$temp=file_get_contents(\"template-linksmain.html\");
$links=str_replace(\"%links%\",$all,$temp);
$links=str_replace(\"%pages%\",$pageshtml,$links);
print $links;
?>
<P/><center>
<B>25 Most Popular:</B>
<table><tr><td width=200 align=left valign=top>Gallery</td><td align=right valign=top>Clicks</td></tr></table>
<?
$result=mysql_query(\"select * from babeloggerv2 where approved = \'yes\' ORDER BY clicks DESC LIMIT 25\");
while($row=mysql_fetch_array($result)){
print\"<table><tr><td width=200 align=left valign=top><a href=\\\"/out/$row[id]\\\">$row[title]</a></td><td align=right valign=top>$row[clicks]</td>\";
}
?>
</table></center>
<br/><br/><center>
<B>25 Highest Rated:</B>
<table><tr><td width=200 align=left valign=top>Gallery</td><td align=right valign=top>Score</td></tr></table>
<?
$result=mysql_query(\"select id, title, (ratedtotal / ratedtally) AS rating FROM babeloggerv2 where approved = \'yes\' ORDER BY rating DESC LIMIT 25\");
while($row=mysql_fetch_array($result)){
print\"<table><tr><td width=200 align=left valign=top><a href=\\\"/out/$row[id]\\\">$row[title]</a></td><td align=right valign=top>$row[rating]</td>\";
}
echo \"</table></center>\";
include_once(\"footer.php\");
?>
Save as top.php or whatever filename you want. You can see it in action @ http://www.deviantbabes.com/top.php. Feel free to post tweaks to this mod as you see fit.
