Hey David, thank you for the quick reply!

Using this aproach, how can i use the PHP engine (or Mantis functions) to read the informations from MySQL and send an e-mail?


On Tue, Sep 14, 2010 at 9:57 PM, David Hicks <hickseydr@optusnet.com.au> wrote:
On Tue, 2010-09-14 at 21:53 -0300, Fabio Manzano wrote:
> I need to send an e-mail (or do other things) when a user is handling
> an issue for a specific period (4 days, for example). Is it possible
> to program this behaviour in Mantis or a better aproach is to execute
> a job every night checking the mantis_bug_history_table?

It's easiest to just setup a small script/cron job that checks the last
handler change entry in mantis_bug_history_table (for each open bug with
a handler assigned) to see if it was 4-5 days ago.

I imagine you'll want to avoid sending duplicate emails (or only send
duplicates once a day) which is something that is very easy to do with a
nightly cron job.



Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
mantisbt-help mailing list

Fabio M. Manzano