Sla Change on status change
Counters count from when a ticket was create.
It does not reset if you change an SLA.
This is the way osTicket works.
9 days later
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));