I assume you have changed the admin setting "Use sequential ID's" in /scp/settings.php?t=tickets
You're probably looking for this part in /include/class.ticket.php:
/* -------------------- POST CREATE ------------------------ */
if (!$cfg->useRandomIds()) {
//Sequential ticketIDs support really..really suck arse.
$extId = $id; //To make things really easy we are going to use autoincrement ticket_id.
db_query('UPDATE ' . TICKET_TABLE . ' SET ticketID=' . db_input($extId) . ' WHERE ticket_id=' . $id . ' LIMIT 1');
//TODO: RETHING what happens if this fails??
}
Although, you may want to look into the $extId: (generated in same file)
function genExtRandID() {
global $cfg;
//We can allow collissions...extId and email must be unique ...so same id with diff emails is ok..
// But for clarity...we are going to make sure it is unique.
$id = Misc:(EXT_TICKET_ID_LEN);
if (db_num_rows(db_query('SELECT ticket_id FROM ' . TICKET_TABLE . ' WHERE ticketID=' . db_input($id))))
return Ticket:();
return $id;
}
However, the columns on the database themselves will not support the characters, they are configured to use integers only. So you should first modify that, then change the code. I'm thinking to the first part above, and use zero padding then CAT them, something like:
db_query('UPDATE ' . TICKET_TABLE . ' SET ticketID= CONCATENATE('. 'BD'. ',LPAD('.db_input($extId).', 5, 0)) WHERE ticket_id=' . $id . ' LIMIT 1');
