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 require_once('./global.php');
15 if (!can_perform('canviewbugs'))
21 // ###################################################################
23 // #*# pagination needs to be done here
25 $bugs = $DB_sql->query("
26 SELECT bug.*, user1.displayname AS firstreport, user2.displayname AS lastpost
27 FROM " . TABLE_PREFIX
. "bug AS bug
28 LEFT JOIN user AS user1
29 ON (bug.userid = user1.userid)
30 LEFT JOIN user AS user2
31 ON (bug.lastpostby = user2.userid)
32 ORDER BY bug.lastposttime DESC"
35 echo '<table border="1" cellspacing="2" cellpadding="4" width="100%"><tr style="background-color:#EEEEEE">';
36 echo '<td>Bug ID</td><td>Title</td><td>Reporter</td><td>Product/Version</td><td>Status/Resolution</td><td>Last Post</td></tr>';
39 while ($bug = $DB_sql->fetch_array($bugs))
42 echo "<td>$bug[bugid]</td>";
43 echo "<td><a href=\"showreport.php?bugid=$bug[bugid]\">$bug[summary]</a></td>";
44 echo "<td>$bug[firstreport]</td>";
45 echo "<td>" . $bugsys->datastore
['product']["$bug[productid]"]['title'] . '/' . $bugsys->datastore
['version']["$bug[versionid]"]['version'] . "</td>";
46 echo "<td>" . $bugsys->datastore
['status']["$bug[status]"]['status'] . '/' . $bugsys->datastore
['resolution']["$bug[resolution]"]['resolution'] . "</td>";
47 echo "<td>" . datelike('standard', $bug['lastposttime']) . ' by ' . $bug['lastpost'] . "</td>";
53 echo '[<a href="newreport.php?">New Report</a>]';
55 /*=====================================================================*\
56 || ###################################################################
59 || ###################################################################
60 \*=====================================================================*/