<?
require("config.php");
// number of active topics to show
$num_active = 5;
// number of pagetext characters to show
$num_chars = 70;
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
// Remove the forums you don't want listed
$querylatest="select * from thread where forumid='58' order by lastpost desc limit $num_active";
$resultlatest = mysql_query($querylatest,$db);
print("<p align=\"right\"><table width=\"100%%\" cellspacing=\"0\" cellpadding=\"2\">");
while ($latest_array = mysql_fetch_array($resultlatest)) {
// Get Forum Infomation
$query_forum = "select * from forum where forumid='$latest_array[forumid]'";
$result_forum = mysql_query($query_forum,$db);
$forum_info_array = mysql_fetch_array($result_forum);
// split the date up a bit
$datestr1 = substr($latest_array["dateline"],0,10);
$datetime = substr($latest_array["dateline"],11,8);
printf("<tr><td align=\"right\"><b><font color=\"#FFFFCC\" size=\"1\" face=\"Arial\"><a href=\"http://www.soccergaming.tv/showthread.php?threadid=%s\" class=\"c\" target=\"_blank\">%s</a></font></b></td></tr>",$latest_array["threadid"],$latest_array["title"]);
$querythread="select * from post where threadid='$latest_array[threadid]' order by dateline asc limit 1";
$result_thread_text= mysql_query($querythread,$db);
$result_thread_array = mysql_fetch_array($result_thread_text);
printf ("<td align=\"right\" width=\"100%%\"><font color=\"#FFCC66\" face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><img src=\"http://www.soccergaming.tv/images/icons/icon%s.gif\"> Started By: %s <br>Last Post By: %s<hr color=\"#FEF8EB\" align=\"center\"></a></td></tr>",$result_thread_array["iconid"],$latest_array["postusername"],$latest_array["lastposter"]);
printf ("<tr><td width=\"100%%\"> </td></tr>");
}
printf ("</table>");
?>