Add New Ticket Source

mike

I know this has been talked about but i cant seem to get this to work.

I changed Column source in my database to read as this.

ENUM('Email','Verbal','Phone','Office Comminicator','Text','Other','Web')

I changed include/staff/newticket.inc.php to this lines 46 - 53

<select name="source">

<option value="" selected >Select Source</option>

<option value="Email" <?=($info=='Email')?'selected':''?>>Email</option>

<option value="Verbal" <?=($info=='Verbal')?'selected':''?>>Verbal</option>

<option value="Phone" <?=($info=='Phone')?'selected':''?>>Phone</option>

<option value="Office Communicator" <?=($info=='Office Communicator')?'selected':''?>>Office Communicator</option>

<option value="Text" <?=($info=='Text')?'selected':''?>>Text</option>

<option value="Other" <?=($info=='Other')?'selected':''?>>Other</option>

I seen other posts saying you must change the scp/tickets.php and add the following info.

if($_POST && !in_array($_POST,array('email','Verbal','Phone','Office Communicator', 'Text','other')))

$errors='Invalid source';

I cant figure out what else to do anyone with any ideas?

mike

Fixed

Ok hope this helps anyone having the same problem.

What I did is..

In /include/class.ticket it has the default vaules Email, Phone, and Other all I did was add my vaules to that line its line 1445

if($var && !in_array(strtolower($var),array('email','phone','other','verbal','text','communicator')))

I could'nt get Office Communicator to work I think it has to due with a space in the word so I just changed it to Comunnicator. Before it kept give and errorIncorrect integer value: '' for column 'msg_id' at row 1 and

Data too long for column 'source' at row

but as soon as I changed in database, newticket.inc.php, and class.ticket.php it fixed the problem. I didnt have to edit the scp/tickets.php not sure why but works without it.

lazyBoy1986

Hi Mike,

Thanks for sharing. Glad you got it working.

Martin