<?php
/*=====================================================================*\
|| ################################################################### ||
|| # BugStrike [#]version[#]
|| # --------------------------------------------------------------- # ||
|| # Copyright Š2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
|| # This file may not be reproduced in any way without permission.  # ||
|| # --------------------------------------------------------------- # ||
|| # User License Agreement at http://www.iris-studios.com/license/  # ||
|| ################################################################### ||
\*=====================================================================*/

$fetchtemplates = array(
	'TRACKERHOME',
	'trackerhome_bits'
);

require_once('./global.php');

if (!can_perform('canviewbugs'))
{
	$message->error_permission();
}

// ###################################################################

// #*# pagination needs to be done here

$bugs_fetch = $db->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)" . ((!can_perform('canviewhidden')) ? "
	WHERE !hidden" : "") . "
	ORDER BY bug.lastposttime DESC"
);

while ($bug = $db->fetch_array($bugs_fetch))
{
	$bug['bgcolour'] = $bugsys->datastore['status']["$bug[status]"]['color'];
	$bug['product'] = $bugsys->datastore['product']["$bug[productid]"]['title'];
	$bug['version'] = $bugsys->datastore['version']["$bug[versionid]"]['version'];
	$bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
	$bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
	$bug['lastpostinfo'] = datelike('standard', $bug['lastposttime']) . ' by ' . $bug['lastpost'];
	eval('$bugs .= "' . $template->fetch('trackerhome_bits') . '";');
}

$db->free_result($bugs_fetch);

$show['newreport'] = ((can_perform('cansubmitbugs')) ? true : false);

eval('$template->flush("' . $template->fetch('TRACKERHOME') . '");');

/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>