I have tried with triger it does change sla but it does not reset counter. Can some one help me with this . @ntozier
Counters count from when a ticket was create. It does not reset if you change an SLA. This is the way osTicket works.
so i did manage to trigger for every combination i need before update
IF new.status_id = 6 then SET new.sla_id = 1, new.est_duedate = (SELECT DATE_ADD(now(),interval 24 hour)), new.duedate = (SELECT DATE_ADD(now(),interval 24 hour));