I have added SMS notification on ticket creation, assignment and overdue, sent along with the e-mail. Additionally I've added SMS notification priority variable to the staff profile, so there is a control which notifications are sent out. There is a switch (drop down list) in staff member form accessible form the Admin panel, so None, Low, Normal, High or Emergency priority tickets are subject to SMS notification.

Step by step instruction:

1. Add column to staff table in the database (I used myPHP to do it).

Column inserted after mobile, name SMS_priority, INT (10) unsigned, default value 4

2. Modify file: class.staff.php

Add function

function getMobile() {

return $this->ht;

}

function getSMSPriority () {

return $this->ht;

}

Alter function

function updateProfile($vars, &$errors)

Add SQL field:

$sql='UPDATE '.STAFF_TABLE.' SET updated=NOW() '

.' ,firstname='.db_input($vars)

.' ,lastname='.db_input($vars)

.' ,email='.db_input($vars)

.' ,phone="'.db_input(Format:($vars),false).'"'

.' ,phone_ext='.db_input($vars)

.' ,mobile="'.db_input(Format:($vars),false).'"'

.' ,SMS_priority='.db_input($vars) //MOD

.' ,signature='.db_input($vars)

.' ,timezone_id='.db_input($vars)

.' ,daylight_saving='.db_input(isset($vars)?1)

.' ,show_assigned_tickets='.db_input(isset($vars)?1)

.' ,max_page_size='.db_input($vars)

.' ,auto_refresh_rate='.db_input($vars)

.' ,default_signature_type='.db_input($vars)

.' ,default_paper_size='.db_input($vars);

Alter function

function save

$sql='SET updated=NOW() '

.' ,isadmin='.db_input($vars)

.' ,isactive='.db_input($vars)

.' ,isvisible='.db_input(isset($vars)?1)

.' ,onvacation='.db_input(isset($vars)?1)

.' ,assigned_only='.db_input(isset($vars)?1)

.' ,dept_id='.db_input($vars)

.' ,group_id='.db_input($vars)

.' ,timezone_id='.db_input($vars)

.' ,daylight_saving='.db_input(isset($vars)?1)

.' ,username='.db_input($vars)

.' ,firstname='.db_input($vars)

.' ,lastname='.db_input($vars)

.' ,email='.db_input($vars)

.' ,phone="'.db_input(Format:($vars),false).'"'

.' ,phone_ext='.db_input($vars)

.' ,mobile="'.db_input(Format:($vars),false).'"'

.' ,SMS_priority='.db_input($vars) //MOD

.' ,signature='.db_input($vars)

.' ,notes='.db_input($vars);

Modify file staff.inc.php by adding drop box to control SMS notification

<td width="180">

Mobile Number:

</td>

<td>

<input type="text" size="18" name="mobile" value="<?php echo $info; ?>">

 <span class="error"> <?php echo $errors; ?></span>

SMS notification from ticket priority <select name="SMS_priority">

<?php

$priorities= db_query('SELECT priority_id,priority_desc FROM '.TICKET_PRIORITY_TABLE);

$id=5; // Higher than the highest used by the system

$tag='None';

do { ?>

<option value="<?php echo $id; ?>"<?php echo ($info==$id)?'selected':''; ?>><?php echo $tag; ?></option>

<?php

} while (list($id,$tag) = db_fetch_row($priorities))?>

</select>

 <span class="error">* <?php echo $errors;?></span>

</td>

to be continued....