$sql.='AND (open.staff_id=0 OR open.staff_id='.db_input($thisuser->getId()).' OR dept.manager_id='.db_input($thisuser->getId()).') '; // gerald
$sql.='LEFT J... 'AND (overdue.staff_id=0 OR overdue.staff_id='.db_input($thisuser->getId()).' OR dept.manager_id='.db_input($thisuser->getId()).') '; // gerald
$sql.='LEFT J... et_id=ticket.ticket_id AND assigned.staff_id='.db_input($thisuser->getId());
if(!$thisuser->isAdmin()){
... $thisuser->getDepts()).') OR ticket.staff_id='.db_input($thisuser->getId());
}
</code>
Wenn man schon da
