Update ticket/flush cache prior to sending email?

[mjm]

I'm working on modifying some functionality with eSupport, I've added the $ticket[timeworked] variable into my email_staffreply template. This works great, most of the time. However, when replying to a ticket and adding values into "timeworked" the email is sent prior with old value of timeworked.

I've been working on the code in modules/tickets/functions_ticketmain.php and modules/tickets/staff_ticketactions.php. There appears to be some data caching and delayed queries that are causing this data to be "old".

I've moved functionality around staff_ticketactions.php to update the ticket prior to sending email, played around with processTicketQueries(), hacked the **** out of the caching functions in functions_ticketmain.php... all to no avail.

I'm obviously missing something here, anyone have any advise?

TIA.