cfg:core|a:2:{s:9:"tz_offset";s:4:"-5.0";s:12:"db_tz_offset";s:7:"-5.0000";}csrf|a:2:{s:5:"token";s:40:"4835fde9b847eafeeb01156bf6a35ce935e996fc";s:4:"time";i:1502146344;}TZ_OFFSET|s:4:"-5.0";TZ_DST|b:0;_staff|a:2:{s:6:"userID";s:1:"1";s:5:"token";s:76:"c71d022dfb9dc31284abbba907297f73:1502146344:5ef4c77a112482a4c853300e642d50ea";}ost_upgrader|N;lastcroncall|i:1502146237;search_01ea20fc13c2edd95a380a8d14806cb1|s:1881:"SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,ticket.team_id  ,ticket.subject,ticket.name,ticket.email,dept_name  ,ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.*  ,count(attach.attach_id) as attachments  ,count(DISTINCT thread.id) as thread_count  ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate  ,IF(ticket.reopened is NULL,IF(ticket.lastmessage is NULL,ticket.created,ticket.lastmessage),ticket.reopened) as effective_date  ,CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team  ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned  ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic   FROM ost_ticket ticket  LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id  LEFT JOIN ost_ticket_priority pri ON (ticket.priority_id=pri.priority_id)  LEFT JOIN ost_ticket_lock tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() 
               AND tlock.staff_id!=1)  LEFT JOIN ost_ticket_attachment attach ON (ticket.ticket_id=attach.ticket_id)  LEFT JOIN ost_ticket_thread thread ON ( ticket.ticket_id=thread.ticket_id)  LEFT JOIN ost_staff staff ON (ticket.staff_id=staff.staff_id)  LEFT JOIN ost_team team ON (ticket.team_id=team.team_id)  LEFT JOIN ost_sla sla ON (ticket.sla_id=sla.id AND sla.isactive=1)  LEFT JOIN ost_help_topic topic ON (ticket.topic_id=topic.topic_id)  LEFT JOIN ost_help_topic ptopic ON (ptopic.topic_id=topic.topic_pid)   WHERE (   ( ticket.staff_id=1 AND ticket.status="open") OR ticket.dept_id IN (1) ) AND status='open' AND isanswered=0  AND ticket.staff_id=0   GROUP BY ticket.ticket_id ORDER BY priority_urgency ASC, effective_date DESC, ticket.created DESC LIMIT 0,25";search_f75f6d2906901918aaf35e5d06954003|s:1819:"SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,ticket.team_id  ,ticket.subject,ticket.name,ticket.email,dept_name  ,ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.*  ,count(attach.attach_id) as attachments  ,count(DISTINCT thread.id) as thread_count  ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate  ,IF(ticket.reopened is NULL,IF(ticket.lastmessage is NULL,ticket.created,ticket.lastmessage),ticket.reopened) as effective_date  ,CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team  ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned  ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic   FROM ost_ticket ticket  LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id  LEFT JOIN ost_ticket_priority pri ON (ticket.priority_id=pri.priority_id)  LEFT JOIN ost_ticket_lock tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() 
               AND tlock.staff_id!=1)  LEFT JOIN ost_ticket_attachment attach ON (ticket.ticket_id=attach.ticket_id)  LEFT JOIN ost_ticket_thread thread ON ( ticket.ticket_id=thread.ticket_id)  LEFT JOIN ost_staff staff ON (ticket.staff_id=staff.staff_id)  LEFT JOIN ost_team team ON (ticket.team_id=team.team_id)  LEFT JOIN ost_sla sla ON (ticket.sla_id=sla.id AND sla.isactive=1)  LEFT JOIN ost_help_topic topic ON (ticket.topic_id=topic.topic_id)  LEFT JOIN ost_help_topic ptopic ON (ptopic.topic_id=topic.topic_pid)   WHERE (   ( ticket.staff_id=1 AND ticket.status="open") OR ticket.dept_id IN (1) ) AND status='closed'  GROUP BY ticket.ticket_id ORDER BY ticket.closed DESC, ticket.created DESC LIMIT 0,25";search_ba9d1397e13569713040c6050678630c|s:1841:"SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,ticket.team_id  ,ticket.subject,ticket.name,ticket.email,dept_name  ,ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.*  ,count(attach.attach_id) as attachments  ,count(DISTINCT thread.id) as thread_count  ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate  ,IF(ticket.reopened is NULL,IF(ticket.lastmessage is NULL,ticket.created,ticket.lastmessage),ticket.reopened) as effective_date  ,CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team  ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned  ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic   FROM ost_ticket ticket  LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id  LEFT JOIN ost_ticket_priority pri ON (ticket.priority_id=pri.priority_id)  LEFT JOIN ost_ticket_lock tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() 
               AND tlock.staff_id!=1)  LEFT JOIN ost_ticket_attachment attach ON (ticket.ticket_id=attach.ticket_id)  LEFT JOIN ost_ticket_thread thread ON ( ticket.ticket_id=thread.ticket_id)  LEFT JOIN ost_staff staff ON (ticket.staff_id=staff.staff_id)  LEFT JOIN ost_team team ON (ticket.team_id=team.team_id)  LEFT JOIN ost_sla sla ON (ticket.sla_id=sla.id AND sla.isactive=1)  LEFT JOIN ost_help_topic topic ON (ticket.topic_id=topic.topic_id)  LEFT JOIN ost_help_topic ptopic ON (ptopic.topic_id=topic.topic_pid)   WHERE (   ( ticket.staff_id=1 AND ticket.status="open") OR ticket.dept_id IN (1) ) AND status='open' AND isanswered=1   GROUP BY ticket.ticket_id ORDER BY ticket.lastresponse DESC, ticket.created DESC LIMIT 0,25";