RE: [PHP] Auto escalation

2003-04-01 Thread Dan Joseph
Hi,

Actually, it sounds to me like he wants to escalate trouble
tickets.  I've done this before.  Simply:

1. Make a cron that monitors the time, and when a ticket was
last touched.
2. Base it on seconds, set it to automatically set the status to
a certain level after so many seconds.
3. When some levels are hit, and you want more features, just
simply code them.  I had it e-mail the Ops Manager when it hit level 4
(48 hours of no touches).

Lemme know if that doesn't help.

-Dan Joseph

-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 01, 2003 11:30 PM
To: 'Praveen Kumar'; [EMAIL PROTECTED]
Subject: RE: [PHP] Auto escalation

> Dear All,
>  I'm new to the list. I'm intended to use the auto escalation
> functionality in my current project which is related to helpdesk. Can
> you please give me some suggestions about how to develop this. I'm
using
> PHP, MySQL

If I'm guessing correctly, you mean auto_increment. There are plenty of
examples in the manual (it's a mysql feature, not PHP). Please start
reading there and come back if you have a specific question about your
project. You'll probably want to make use of the mysql_insert_id()
function in PHP. 

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] Auto escalation

2003-04-01 Thread John W. Holmes
> Dear All,
>  I'm new to the list. I'm intended to use the auto escalation
> functionality in my current project which is related to helpdesk. Can
> you please give me some suggestions about how to develop this. I'm
using
> PHP, MySQL

If I'm guessing correctly, you mean auto_increment. There are plenty of
examples in the manual (it's a mysql feature, not PHP). Please start
reading there and come back if you have a specific question about your
project. You'll probably want to make use of the mysql_insert_id()
function in PHP. 

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php