At my full time job we often reference the ticket ID that we are working on in our daily log, notes or when just when referencing it from person to person. The following will allow for showing the external ticket ID in the browser title.

First we need a new function to reference, find the following in
include/class.ticket.php

/*============== Functions below do not require an instance of the class to be used. To call it use Ticket::function(params); ==================*/

And add the following right after it:

function getExtIdById($id){
$sql ='SELECT ticketID FROM '.TICKET_TABLE.' ticket WHERE ticket_id='.db_input($id);
$res=db_query($sql);
if($res && db_num_rows($res))
list($extid)=db_fetch_row($res);
return $extid;
}

Now open up
include/staff/header.inc.php and add the following just after your <title> tag:

<?if(Ticket::getExtIdById($id)){ echo Ticket::getExtIdById($id)." - "; }?>

Update!
There are a couple of pages you may be on (like “My Preferences”) where the ticket class is not loaded. In order to make sure it’s loaded for use you can added the following just before the title tag:

require_once('../include/class.ticket.php');

Ok this isn’t as nice as my normal MODs, its a bit clunky since its all statically written but it should do the trick nonetheless. This has only been tested right now on 1.6RC5, please let me know if you have success on 1.6ST with it and I’ll update this note. Cheers!

Purpose: When transferring a ticket to another department, the new department will receive an email alerting them to the assignment.

include/class.ticket.php
Inside the function transfer, under ‘global $cfg;’ Add the following:

$sql = 'SELECT email,dept_name FROM ost_email LEFT JOIN ost_department on ost_email.email_id=ost_department.email_id WHERE ost_department.dept_id='.$deptId;
print $sql;
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "Department email is " .$row['email'];
$ticketNumber=$this->getId();
$to = $row['email'];
$deptName = $row['dept_name'];
$subject = "Ticket [#$ticketNumber] Assigned";
$message = "$deptName,\n\nTicket #$ticketNumber has been assigned to you.\n\nhttp://YOUR_DOMAIN.EXT/scp/tickets.php?id=$ticketNumber";
$headers = "From: FROM_EMAIL@YOUR_DOMAIN\r\n";
$headers .= "Reply-To: no-reply@YOUR_DOMAIN\r\n";
$headers .= "X-Mailer: PHP\" . phpversion() . \"\r\n";
mail($to, $subject, $message, $headers);
}

If there is enough desire for it I may some day add it into the template database for emails and such but right now this set in there statically was enough for me. As always let me know if you have any questions or concerns.

This MOD will allow you to view the original email message headers. The headers also take alot of screen space so we have them “hidden” by default but you can click a link to expand and view them.

1.6ST: If you have not yet modified include/staff/viewticket.inc.php or scp/js/scp.js then you can simply download the following files and replace them. As always, make backups of your local files first.
Download

Hidden	Shown

READ MORE »

I’m setting up another install of osTickets for another department (that needs a whole other server). In the process it was requested that they be able to change who the response address is incase they need to send it along to someone else or in order to include multiple addresses. The following is a simple MOD I came up with that seems to work as desired. As always please let me know if you have any questions or notice any problems.
This has been implemented with 1.6RC and 1.6ST and both are functional with the exact same code.

Note: This is for use with sending mail via the PHP mail function and is not intended or coded for use with SMTP sending.

include/class.ticket.php
Inside the postResponse function, just before the $sql variable add the following:

 $send_to = $_POST['send_to'];
$cc_to = $_POST['cc_to'];
$bcc_to = $_POST['bcc_to'];
$SENT = "To: $send_to\nCC: $cc_to\nBCC: $bcc_to\n\n";
$response = "$SENT$response";

Now find the following (still inside postResponse):

$body = str_replace('%response',$response,$body);

And below that line add the following line:

$body = str_replace("$SENT",'',$body);

At the bottom of the postResponse function. Find the following code and remove it:

if($email && $email->getId()) {
 $email->send($this->getEmail(),$subj,$body,$file);
 }

Now replace it with:

 // Just in case they wiped out the send address we still need to make sure it gets somewhere.
if($_POST['send_to']){
$email->send($_POST['send_to'],$subj,$body,$file);
}else{
$email->send($this->getEmail(),$subj,$body,$file);
}

Now we need to setup the actual behind the scenes emailing:
include/class.email.php
Find the following

$to=preg_replace("/(\r\n|\r|\n)/s",'', trim($to));

and just after that add:

// Make sure that tickets is sending via php mail function not smtp or this will not work.
$CC = $_POST['cc_to'];
$BCC = $_POST['bcc_to'];

Then just a bit further down we need to add to the headers of the email:

$headers = array ('From' => $from,
'To' => $to,
'Subject' => $subject,
'Message-ID' =>'<'.Misc::randCode(6).''.time().'-'.$this->getEmail().'>',
'X-Mailer' =>'osTicket v 1.6',
'Content-Type' => 'text/html; charset="UTF-8"'
);

For ease of modding just remove all of that and replace it with this:

$headers = array ('From' => $from,
'To' => $to,
'Bcc' => $BCC,
'CC' => $CC,
'Subject' => $subject,
'Message-ID' =>'<'.Misc::randCode(6).''.time().'-'.$this->getEmail().'>',
'X-Mailer' =>'osTicket v 1.6',
'Content-Type' => 'text/html; charset="UTF-8"'
);

Ok, thats the functionality behind it all, now we just need to add the ability to use it…

include/staff/viewticket.inc.php
Search for the following:

<input type="hidden" name="a" value="reply">

Now just below that line add the following code:

<table>
<tr>
<td>To:</td><td><input size=80 type="text" name="send_to" value="<?=$ticket->getEmail()?>"></td>
</tr>
<tr>
<td>CC:</td><td><input size=80 type="text" name="cc_to" ></td>
</tr>
<tr>
<td>BCC:</td><td><input size=80 type="text" name="bcc_to" ></td>
</tr>
</table>

The following picture shows the “To”, “CC” and “BCC” boxes that allows for changing or adding to the email address to send to. This is automatically filled in with the original email address of the ticket submitter. You can send to multiple email addresses by separating the emails with a comma (bob@example.com, bob2@example.com). Its also user proof… if someone wipes out the email address and doesn’t enter in anything then it will default to the original email address.

Well thats very nice but if we don’t note who we sent it to then we could be getting very confused. Please let us know where we sent what responses to. This note is added to the response database entry but is stripped before emailing the response to the customer.