PHPJunkyard support forum

/*************************************
Title: Auto-reminder email
Version: 0.94.1
Short description: Time-based auto-reminder email to staff


*************************************/

Anyone have any suggestions for a mod that would do the following:

1) Once a ticket is created, email staff in 24 hours (or whatever threshold) if ticket remains in "NEW" status without replies

This would basically serve as a reminder, in case someone missed the original email....a reminder would be sent out to staff indicating there is an untouched ticket in the queue.

ANY IDEAS???

I was actually thinking of writing a cron to check the hesk_tickets table with two conditions:

1) Current time must be minimum Time created + 24 hours (24hr is the threshold)
2) status must be "NEW" ( or whatever numerical digit that status equates to in the table)

Then email staff.

Cron would run every 5 min..........

Something like that, but open to suggestions to do internally? What do you guys think. True this method would plaque staff every 5 min until someone updated the ticket, but that's ok in our environment!