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