I love try&error ;)
include/staff/tickets.inc.php line ~114
" OR topic.topic LIKE '%$queryterm%'".
include/staff/tickets.inc.php line ~175
$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,ticket.email,dept_name,responses.response,staff.username '.
',status,ticket.source,isoverdue,ticket.created,topic,topic.topic,pri.*'.
include/staff/tickets.inc.php line ~188
' LEFT JOIN '.TOPIC_TABLE.' topic ON ticket.topic_id=topic.topic_id '.
Full version with all my MODs:
//This sucks..mass scan! search anything that moves!
$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".
" OR ticket.name LIKE '%$queryterm%'".
" OR responses.response LIKE '%$queryterm%'".
" OR messages.message LIKE '%$queryterm%'".
" OR ticket.subject LIKE '%$queryterm%'".
" OR ticket.topic_id LIKE '%$queryterm%'".
" OR note.note LIKE '%$queryterm%'".
" OR note.title LIKE '%$queryterm%'".
" OR topic.topic LIKE '%$queryterm%'".
' ) ';
}
$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,ticket.email,dept_name,responses.response,staff.username '.
',status,ticket.source,isoverdue,ticket.created,topic,topic.topic,pri.*'.
',GREATEST(ticket.created,IFNULL(ticket.updated,0),MAX(messages.created),MAX(IFNULL(messages.updated,0)),MAX(IFNULL(responses.created,0)),MAX(IFNULL(responses.updated,0))) AS lastupdated'.
',COUNT(attach_id) AS attachments'.
',messages.message';
$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '.
' LEFT JOIN '.TICKET_RESPONSE_TABLE.' responses ON ticket.ticket_id=responses.ticket_id '.
' LEFT JOIN '.TICKET_MESSAGE_TABLE.' messages ON ticket.ticket_id=messages.ticket_id '.
' LEFT JOIN '.TICKET_ATTACHMENT_TABLE.' attach ON ticket.ticket_id=attach.ticket_id '.
' LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id '.
' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() '.
' LEFT JOIN '.TICKET_NOTE_TABLE.' note ON ticket.ticket_id=note.ticket_id '.
' LEFT JOIN '.TOPIC_TABLE.' topic ON ticket.topic_id=topic.topic_id '.
' LEFT JOIN '.STAFF_TABLE.' staff ON ticket.staff_id=staff.staff_id';
time for lunch
cheers
slashdot