I'm trying to add a new view that only shows new and unaswered tickets. By looking in MySQL I noted that the ost_tickets.updated has a zero value. Withion MySQL I was able to isolate the new ticket from the others by using "where updated=date('0000-00-00 00')".
Unfortunately when I added
case 'newticket':
$status='newticket';
$results_type='New Tickets';
break;
and
if ($status=='newticket')
{
$qwhere.= ' AND updated=date(\'0000-00-00 00\') ';
}
in tickets.inc.php, the new tickets do not display on the web page. Any help would be appreciated.
