2 /*=====================================================================*\
3 || ################################################################### ||
4 || # Renapsus [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # All parts of this file are ©2003-[#]year[#] Iris Studios, Inc. No # ||
7 || # part of this file may be reproduced in any way: part or whole. # ||
8 || # --------------------------------------------------------------- # ||
9 || # ©2003 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 $fetchtemplates = array(
18 require_once('./global.php');
20 if (!can_perform('canviewbugs'))
26 // ###################################################################
28 // #*# pagination needs to be done here
30 $bugs_fetch = $DB_sql->query("
31 SELECT bug.*, user1.displayname AS firstreport, user2.displayname AS lastpost
32 FROM " . TABLE_PREFIX
. "bug AS bug
33 LEFT JOIN user AS user1
34 ON (bug.userid = user1.userid)
35 LEFT JOIN user AS user2
36 ON (bug.lastpostby = user2.userid)
37 ORDER BY bug.lastposttime DESC"
40 while ($bug = $DB_sql->fetch_array($bugs_fetch))
42 $bug['product'] = $bugsys->datastore
['product']["$bug[productid]"]['title'];
43 $bug['version'] = $bugsys->datastore
['version']["$bug[versionid]"]['version'];
44 $bug['status'] = $bugsys->datastore
['status']["$bug[status]"]['status'];
45 $bug['resolution'] = $bugsys->datastore
['resolution']["$bug[resolution]"]['resolution'];
46 $bug['lastpostinfo'] = datelike('standard', $bug['lastposttime']) . ' by ' . $bug['lastpost'];
47 eval('$bugs .= "' . $tpl->fetch('trackerhome_bits') . '";');
50 $DB_sql->free_result($bugs_fetch);
52 $show['newreport'] = iff(can_perform('cansubmitbugs'), true
, false
);
54 eval('$tpl->flush("' . $tpl->fetch('TRACKERHOME') . '");');
56 /*=====================================================================*\
57 || ###################################################################
60 || ###################################################################
61 \*=====================================================================*/