There have been a lot of questions about how to add a new field to the ticket and rightly so, the more info a user can provide the better. For our purposes we wanted to add a Company field so we knew exactly who we were dealing with.

We added the field successfully and this thread explains the process. As a favor, can someone help us with adding that new field to the "tickets.inc.php" page?!?! It would be greatly appreciated. We'd like to be able to see Company in that table as a column where you see the ticket id, date, department, priority etc.

To add a new field there are 6 places you have to go to accomplish your goal.

MySQL Database: manually add a field to ost_Ticket

support/include/class.ticket.php

support/include/client/open.inc.php

support/include/client/viewticket.inc.php

include/staff/viewticket.inc.php

include/staff/newticket.inc.php

2.) class.ticket.php

Add your variable here:

class Ticket{

var $id;

var $extid;

var $email;

var $status;

var $created;

var $updated;

var $priority;

and here: like so ($this->newvar=$row;)

if(($res=db_query($sql)) && db_num_rows($res)):

$row=db_fetch_array($res);

$this->id =$row;

$this->extid =$row;

$this->email =$row;

$this->fullname =$row;

and here:

//GET

function getId(){

return $this->id;

}

function getExtId(){

return $this->extid;

}

function getEmail(){

return $this->email;

}

function getNewvar(){

return $this->newvar;

}

and here:

function create($var,&$errors,$origin,$autorespond=true,$alertstaff=true) {

global $cfg,$thisclient,$_FILES;

$id=0;

$fields=array();

$fields = array('type'=>'string', 'required'=>1, 'error'=>'newvar required');

and finally:

$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)).

',newvar='.db_input(Format:($var)).

3.) open.inc.php Copy info from other the other fields, just make sure the new field php scripts are different.

4.) viewticket.inc.php Repeat Step 3

5.) staff/viewticket.inc.php Repeat Step 4

6.) staff/newticket.inc.php Repeat Step 5