I now get " NO tickets found. "
Heres my Tickets.inc
<?php
if(!defined('OSTCLIENTINC') || !is_object($thisclient) || !$thisclient->isValid()) die('Kwaheri');
//Get ready for some deep shit.
$qstr='&'; //Query string collector
$status=null;
if($_REQUEST) { //Query string status has nothing to do with the real status used below.
$qstr.='status='.urlencode($_REQUEST);
//Status we are actually going to use on the query...making sure it is clean!
switch(strtolower($_REQUEST)) {
case 'open':
case 'closed':
$status=$_REQUEST;
break;
default:
$status=''; //ignore
}
}
//Restrict based on email of the user...STRICT!
$qwhere =' WHERE email='.db_input($thisclient->getEmail());
//STATUS
if($status){
$qwhere.=' AND status='.db_input($status);
}
//Admit this crap sucks...but who cares??
$sortOptions=array('date'=>'ticket.created','ID'=>'ticketID','pri'=>'priority_id','dept'=>'dept_name','users_name'=>'users_name','subject'=>'subject', 'status'=>'status');
$orderWays=array('DESC'=>'DESC','ASC'=>'ASC');
//Sorting options...
if($_REQUEST) {
$order_by =$sortOptions[$_REQUEST;
}
if($_REQUEST) {
$order=$orderWays[$_REQUEST;
}
if($_GET){
$qstr.='&limit='.urlencode($_GET);
}
$order_by =$order_by?$order_by:'ticket.created';
$order=$order?$order:'DESC';
$pagelimit=$_GET?$_GET;
$page=($_GET && is_numeric($_GET))?$_GET;
$qselect = 'SELECT ticket.users_name,ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name,email '.
',dept_name,status, users_name,source,priority_id, priority_desc ,ticket.created ';
$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id ';
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
$total=db_count('SELECT count(*) '.$qfrom.' '.$qwhere);
$pageNav=new Pagenate($total,$page,$pagelimit);
$pageNav->setURL('view.php',$qstr.'&sort='.urlencode($_REQUEST).'&order='.urlencode($_REQUEST));
//Ok..lets roll...create the actual query
$qselect.=' ,count(attach_id) as attachments ';
$qfrom.='LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id';
' LEFT JOIN '.TICKET_ATTACHMENT_TABLE.' attach ON ticket.ticket_id=attach.ticket_id ';
$qgroup=' GROUP BY ticket.ticket_id';
$query="$qselect $qfrom $qwhere $qgroup ORDER BY $order_by $order LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
//echo $query;
$tickets_res = db_query($query);
$showing=db_num_rows($tickets_res)?$pageNav->showing():"";
$results_type=($status)?ucfirst($status).' Tickets':' All Tickets';
$negorder=$order=='DESC'?'ASC':'DESC'; //Negate the sorting..
?>
<div>
<?if($errors) {?>
<p align="center" id="errormessage"><?=$errors?></p>
<?}elseif($msg) {?>
<p align="center" id="infomessage"><?=$msg?></p>
<?}elseif($warn) {?>
<p id="warnmessage"><?=$warn?></p>
<?}?>
</div>
<div style="margin: 10px 0 20px 0;">
<table width="100%" border="0" cellspacing=0 cellpadding=0 align="center">
<tr>
<td width="60%" class="msg"><?=$showing?> <?=$results_type?></td>
<td nowrap >
<a href="view.php?status=open"><img src="images/view_open_btn.gif" alt="View Open" border=0></a>
<a href="view.php?status=closed"><img src="images/view_closed_btn.gif" alt="View Closed" border=0></a>
<a href=""><img src="images/refresh_btn.gif" alt="Refresh" border=0></a>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing=0 cellpadding=2>
<tr><td>
<table width="100%" border="0" cellspacing=0 cellpadding=2 class="tgrid" align="center">
<tr>
<th width="60px" nowrap>
<a href="view.php?sort=ID&order=<?=$negorder?><?=$qstr?>" title="Sort By Ticket ID <?=$negorder?>">Ticket ID #</a></th>
<th width="90px">
<a href="view.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Ticket Created</a></th>
<th width="50px">
<a href="view.php?sort=status&order=<?=$negorder?><?=$qstr?>" title="Sort By Status <?=$negorder?>">Status</a></th>
<th><a href="tickets.php?sort=subject&order=<?=$negorder?><?=$qstr?>" title="Sort By Subject <?=$negorder?>">Subject</a></th>
<th width="115px">
<a href="view.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Department <?=$negorder?>">Department</a></th>
<th width="115px"><a href="view.php?sort=users_name&order=<?=$negorder?><?=$qstr?>" title="Sort By Users Name <?=$negorder?>">Users Name</a></th>
<th width="115px"><a href="view.php?sort=pri&order=<?=$negorder?><?=$qstr?>" title="Sort By Priority <?=$negorder?>">Priority</a></th>
</tr>
<?
$class = "row1";
$total=0;
if($tickets_res && ($num=db_num_rows($tickets_res))):
$defaultDept=Dept:();
while ($row = db_fetch_array($tickets_res)) {
$dept=$row?$row:$defaultDept; //Don't show hidden/non-public depts.
$subject=Format:(Format:($row,40));
$ticketID=$row;
if($row && !strcasecmp($row,'open')) {
$subject="<b>$subject</b>";
$ticketID="<b>$ticketID</b>";
}
?>
<tr class="<?=$class?> " id="<?=$row?>">
<td align="center" title="<?=$row?>" nowrap>
<a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?>" href="view.php?id=<?=$row?>">
<?=$ticketID?></a></td>
<td nowrap> <?=Format:($row)?></td>
<td> <?=ucfirst($row)?></td>
<td> <a href="view.php?id=<?=$row?>"><?=$subject?></a>
<?=$row?"<span class='Icon file'> </span>":''?></td>
<td nowrap> <?=Format:($dept,30)?></td>
<td> <?=Format:($row,40)?></td>
<td> <?=$row;?></td>
</tr>
<?
$class = ($class =='row2') ?'row1':'row2';
} //end of while.
else: //not tickets found!! ?>
<tr class="<?=$class?>"><td colspan=7><b>NO tickets found.</b></td></tr>
<?
endif; ?>
</table>
</td></tr>
<tr><td>
<?
if($num>0 && $pageNav->getNumPages()>1){ //if we actually had any tickets returned?>
<tr><td style="text-align;padding-left">page:<?=$pageNav->getPageLinks()?> </td></tr>
<?}?>
</table>
</div>
<?
