Open Script Solution

Both in osTicket System version 1.6 RC4 and 1.6 RC5 have not saved the “0″ character if the phone number started with the zero character. For example, if the client’s phone number is 08157140595, then this number will be saved in database as 8157140595 (the first “0″ character will not be saved). This happens since the phone number being converted become the numerical data while assigned to SQL statement. So I made this modification in order that “0″ character also will be saved in database.

1. Open \include\class.ticket.php file, find this code:

   1015 1016

   ',phone='.db_input($var['phone']). ',phone_ext='.db_input($var['phone_ext']?$var['phone_ext']:NULL).

   then replace with this following code:

   1015 1016

   ',phone="'.db_input($var['phone']). '",phone_ext='.db_input($var['phone_ext']?$var['phone_ext']:NULL).

   Find this code:

   1189 1190

   ',phone='.db_input($var['phone']). ',phone_ext='.db_input($var['phone_ext']?$var['phone_ext']:'').

   then replace with this following code:

   1189 1190

   ',phone="'.db_input($var['phone']). '",phone_ext='.db_input($var['phone_ext']?$var['phone_ext']:'').

2. Open \scp\profile.php file, and find this code:

   93 94

   ',phone='.db_input($_POST['phone']). ',phone_ext='.db_input($_POST['phone_ext']).

   then replace with this following code:

   93 94

   ',phone="'.db_input($_POST['phone']). '",phone_ext='.db_input($_POST['phone_ext']).