2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
22 $fetchtemplates = array(
29 define('SVN', '$Id$');
31 $focus['index'] = 'focus';
33 require_once('./global.php');
34 require_once('./includes/class_pagination.php');
36 if (!can_perform('canviewbugs'))
38 $message->error_permission();
41 // ###################################################################
43 $pagination = new Pagination('p', 'pp');
44 $count = $db->query_first("
45 SELECT COUNT(*) AS count
46 FROM " . TABLE_PREFIX
. "bug
47 WHERE (!hidden OR (hidden AND productid IN (" . fetch_on_bits('canviewhidden') . ")))
48 AND productid IN (" . fetch_on_bits('canviewbugs') . ")"
51 $pagination->total
= $count['count'];
52 $pagination->split_pages();
54 $bugs_fetch = $db->query("
55 SELECT * FROM " . TABLE_PREFIX
. "bug
56 WHERE productid IN (" . fetch_on_bits('canviewbugs') . ")
57 AND (!hidden OR (hidden AND productid IN (" . fetch_on_bits('canviewhidden') . ")))
58 ORDER BY " . (can_perform('canviewhidden') ?
"lastposttime" : "hiddenlastposttime") . " DESC
59 LIMIT " . $pagination->fetch_limit($pagination->page
- 1) . ", " . $pagination->perpage
62 while ($bug = $db->fetch_array($bugs_fetch))
64 $funct->exec_swap_bg($stylevar['alt_colour'], '');
65 $bug['bgcolour'] = ($bugsys->userinfo
['showcolours'] ?
$bugsys->datastore
['status']["$bug[status]"]['color'] : $funct->bgcolour
);
66 $bug['product'] = $bugsys->datastore
['product']["$bug[productid]"]['title'];
67 $bug['version'] = $bugsys->datastore
['version']["$bug[versionid]"]['version'];
68 $bug['status'] = $bugsys->datastore
['status']["$bug[status]"]['status'];
69 $bug['resolution'] = $bugsys->datastore
['resolution']["$bug[resolution]"]['resolution'];
70 $bug['priority'] = $bugsys->datastore
['priority']["$bug[priority]"]['priority'];
71 $bug['severity'] = $bugsys->datastore
['severity']["$bug[severity]"]['severity'];
73 $bug['hiddendisplay'] = ((!can_perform('canviewhidden', $bug['productid']) AND $bug['hiddenlastposttime']) ? true
: false
);
75 $bug['lastposttime'] = ($bug['hiddendisplay'] ?
$bug['hiddenlastposttime'] : $bug['lastposttime']);
76 $bug['lastpost'] = ($bug['hiddendisplay'] ?
$bug['hiddenlastpostbyname'] : $bug['lastpostbyname']);
78 $bug['lastposttime'] = $datef->format($bugsys->options
['dateformat'], $bug['lastposttime']);
80 eval('$bugs .= "' . $template->fetch('trackerhome_bits') . '";');
83 $db->free_result($bugs_fetch);
85 $show['pagenav'] = (($pagination->pagecount
> 1) ? true
: false
);
86 $pagenav = $pagination->construct_page_nav('index.php');
88 eval('$template->flush("' . $template->fetch('trackerhome') . '");');
90 /*=====================================================================*\
91 || ###################################################################
94 || ###################################################################
95 \*=====================================================================*/