Don't forget to modify the update() function, too
Well, guess what?
I think you have just missed the update() function in \include\class.ticket.php file around line 996:
Find this code around line 1006:
$fields = array('type'=>'date', 'required'=>0, 'error'=>'Invalid date - must be MM/DD/YY');
then after that line, please insert this following code:
$fields = array('type'=>'string', 'required'=>0, 'error'=>'Serial Number required');
$fields = array('type'=>'string', 'required'=>0, 'error'=>'Model Number required');
$fields = array('type'=>'string', 'required'=>0, 'error'=>'Product ID required');
$fields = array('type'=>'string', 'required'=>0, 'error'=>'HP Cased ID required');
Find again this code around line 1043:
$sql='UPDATE '.TICKET_TABLE.' SET updated=NOW() '.
',email='.db_input($var).
',name='.db_input(Format:($var)).
',subject='.db_input(Format:($var)).
',phone='.db_input($var).
',phone_ext='.db_input($var?$var).
',priority_id='.db_input($var).
',duedate='.($var?db_input(date('Y-m-d G',Misc:($var.' '.$var))):'NULL');
then replace with this following code:
$sql='UPDATE '.TICKET_TABLE.' SET updated=NOW() '.
',email='.db_input($var).
',name='.db_input(Format:($var)).
',subject='.db_input(Format:($var)).
',serial='.db_input($var).
',model='.db_input($var).
',product='.db_input($var).
',hpcaseid='.db_input($var).
',phone='.db_input($var).
',phone_ext='.db_input($var?$var).
',priority_id='.db_input($var).
',duedate='.($var?db_input(date('Y-m-d G',Misc:($var.' '.$var))):'NULL');
Good luck. ;)
Sincerely,
Masino Sinaga
