I had a request to implement the ability for different dept signatures to be choosen and appended to the email response on a ticket.
So here it is:
First in staff/viewticket.inc.php:
Find the following
</select> <label><input type='checkbox' value='1' name=append checked="true" />Append</label>
<? } ?>
<br/>
Right below that add the php code to create the dept table driven dropdown.
<?php
$query = 'SELECT * FROM tableName';
$result = mysql_query($query);
$options = '';
while ($row = mysql_fetch_assoc($result)) {
$dept_id = $row;
$dept_name = $row;
$dept_signature = $row;
$options .= "<OPTION VALUE=\"$dept_signature\">" . $dept_name . '</option>';
}
$returned = '';
if (isset($_POST)) {
$returned = $_POST;
}
?>
Next find the line that has
<label><input type="radio" name="signature" value="dept" <?=$info == 'dept' ? 'checked' : '' ?> > Dept Signature</label>
...and add below it
<select name="choice">
<OPTION VALUE=0>Choose
<?=$options?>
</select>
....and thats it for the VIEW part of it