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.
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;
$ticketNumber=$this->getId();
$to = $row;
$deptName = $row;
$subject = "Ticket 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.
http://sudobash.net/?p=930(http://sudobash.net/?p=930) for further comments as they come in.
