I was able to successfully add a new field to my ticket. I tested it in the client side and the staff side(w/o mod) and it works great!
/* Add New Fields Modification
* Author: James Williams
* osTicket v1.6 RC4
* Date: 07-22-08
* Ref: http://www.osticket.com/forums/showthread.php?t=873(http://www.osticket.com/forums/showthread.php?t=873)
*/
DB Table: ost_ticket
Field Type Collation Attributes Null
location text latin1_general_ci No
+ADD include\client\open.inc.php between subject and intersection
<tr>
<th valign="top">Location, Address, or Intersection:</th>
<td>
<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>
<textarea name="location" cols="35" rows="3" wrap="soft" style="width%"><?=$info?></textarea></td>
</tr>
+ADD include\class.ticket.php
var $location; // mod080722_new_ticket_field
+ADD include\class.ticket.php
$this->location =$row; // Mod080722_new_ticket_field
+ADD include\class.ticket.php
// mod080722_new_ticket_field
function getLocation() {
return $this->row;
}
+ADD include\class.ticket.php
$fields = array('type'=>'text', 'required'=>0, 'error'=>'Provide a location, address, or directions'); //mod080722_new_ticket_field
+ADD include\class.ticket.php
//We are ready son...hold on to the rails.
$extId=Ticket:();
$sql= 'INSERT INTO '.TICKET_TABLE.' SET created=NOW() '.
',ticketID='.db_input($extId).
',dept_id='.db_input($deptId).
',priority_id='.db_input($priorityId).
',email='.db_input($var).
',name='.db_input(Format:($var)).
',subject='.db_input(Format:($var)).
',location='.db_input(Format:($var)). // mod080722_new_ticket_field
',phone='.db_input($var).
',ip_address='.db_input($ipaddress).
',source='.db_input($source);