<?php
// Set this to the max number of threads you want to display
$maxthreads = 100;

require("/full/path/to/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM thread WHERE to_days(now())=to_days(from_unixtime(lastpost)) AND forumid <> 34 AND forumid <> 33 ORDER BY dateline DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<img src=\"images/smalldoc.gif\" width=\"12\" height=\"12\" alt=\">\" border=\"0\" align=\"absmiddle\"><FONT SIZE=\"2\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">
<A HREF=\"http://www.extremeforums.com/forums/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</A></FONT><BR>";
}
 
?>