DELIMITER //
CREATE PROCEDURE ost_autoclose()
BEGIN
CREATE TEMPORARY TABLE IF NOT EXISTS ost_autoclose_id (ticket_id INT(11) UNSIGNED);
TRUNCATE ost_autoclose_id;

INSERT INTO ost_autoclose_id (ticket_id)
  SELECT ticket_id FROM ost_ticket
  WHERE status_id = '1'
  AND isanswered = '1'
  AND lastresponse <= DATE_SUB(NOW(), INTERVAL 7 day)
  AND lastmessage < lastresponse;

INSERT INTO ost_ticket_thread
  (pid, ticket_id, staff_id, user_id, thread_type, poster, title, body, format, created, updated)
  SELECT
   '0', ticket_id, '0', '0', 'N', 'SYSTEM', 'Ticket Automatically Resolved ',
   'Ticket automatically resolved due to no user response for 7 days.', 'html', NOW(), '0000-00-00 00:00:00'
  FROM ost_autoclose_id;

SET SQL_SAFE_UPDATES = 0;
UPDATE ost_ticket a
JOIN ost_autoclose_id b ON
  a.ticket_id=b.ticket_id
SET
  status_id='2'
WHERE
  status_id='1';
SET SQL_SAFE_UPDATES = 1;

DROP TEMPORARY TABLE IF EXISTS ost_autoclose_id;
END//

USE osticket;
SET GLOBAL event_scheduler = ON;
CREATE EVENT `ost_autoclose`
ON SCHEDULE EVERY 1 DAY STARTS '2016-02-09 00:00:00'
DO CALL ost_autoclose();