\n";
$content .= "\n";
$content .= "| "._WR_PROJECTNAME." | \n";
$content .= ""._WR_REQUESTS." | \n";
$content .= ""._WR_LASTSUBMISSION." | \n";
$content .= "
\n";
$projectresult = $db->sql_query("SELECT project_id FROM ".$prefix."_nsnwb_projects WHERE featured='1' ORDER BY project_name");
while (list($project_id) = $db->sql_fetchrow($projectresult)) {
$project = wrproject_info($project_id);
$wrimage = wrimage2("project.png", $modname);
$content .= "\n | \n".$project['project_name']." | \n";
$requestnumber = $db->sql_numrows($db->sql_query("SELECT request_id FROM ".$prefix."_nsnwr_requests WHERE project_id='$project_id'"));
$content .= "$requestnumber | \n";
$lastresult = $db->sql_query("SELECT date_submitted FROM ".$prefix."_nsnwr_requests WHERE project_id='$project_id' ORDER BY date_submitted DESC LIMIT 1");
if($db->sql_numrows($lastresult) == 0){
$date_submitted = _WR_NA;
} else {
list($date_submitted) = $db->sql_fetchrow($lastresult);
$date_submitted = date($wr_config['request_date_format'], $date_submitted);
}
$content .= "$date_submitted | \n
\n";
}
$content .= "\n";
?>