query(" SELECT bug.*, user1.displayname AS firstreport, user2.displayname AS lastpost FROM " . TABLE_PREFIX . "bug AS bug LEFT JOIN user AS user1 ON (bug.userid = user1.userid) LEFT JOIN user AS user2 ON (bug.lastpostby = user2.userid) ORDER BY bug.lastposttime DESC" ); echo ''; echo ''; while ($bug = $DB_sql->fetch_array($bugs)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo '

Bug ID	Title	Reporter	Product/Version	Status/Resolution	Last Post
$bug[bugid]	$bug[summary]	$bug[firstreport]	" . $bugsys->datastore['product']["$bug[productid]"]['title'] . '/' . $bugsys->datastore['version']["$bug[versionid]"]['version'] . "	" . $bugsys->datastore['status']["$bug[status]"]['status'] . '/' . $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'] . "	" . datelike('standard', $bug['lastposttime']) . ' by ' . $bug['lastpost'] . "

'; echo '[New Report]'; /*=====================================================================*\ || ################################################################### || # $HeadURL$ || # $Id$ || ################################################################### \*=====================================================================*/ ?>