Initial post edited for forum mod at posters request:
I can't explain the sql stuff, but I get what it's doing. Here is the short and sweet of it:The
goal is to pull select data from the database and populate it into the
browser's title page. The default page title is "Ticket # and
$ticket->getId()The
solution is to find the table and value, then put a sql query into the
/include/staff/header.inc.php Here is an example.
ost_form_entry_values and ost_form_entry are tables in the database.
Replace the <title> tage with the following: <title><?phpif(isset($ticket)){
$sql ="SELECT value FROM ost_form_entry_values a INNER JOIN
ost_form_entry e ON e.object_id=".$ticket->getId()." AND
e.object_type='T' AND e.id=a.entry_id WHERE field_id=13"; // The query
itself $res = db_query($sql); list($val) = db_fetch_row($res);
echo $ticket->getStatus() . " & " . $val . " & " .
$ticket->getId(); // This is what is displayed on the title page.
getStatus() will tell if the ticket is open or closed, etc.. $val is
the custom value, getId() is the ticket number}else{
echo ($ost &&
($title=$ost->getPageTitle()))?$title:'osTicket :: Staff Control
Panel'; // If not a ticket, then display this title page}?> </title>Might be easier to copy all this into your favorite text editor so it's not crowded and you can read the comments etc.. I followed the directions here http://www.forum.osticket.com/d/discussion//mod-change-page-title-to-ticket-subject-when-ticket-open-staff but it looks like things are different with the newer version. I have a custom list and custom forms in tickets now (awesome! ) . My minions will need to know what is populated in one of those fields while they have multiple tickets open in each tab. What I'd like for them to see is: <custom form value> & <status> & <ticket #>I surely don't mind doing the footwork, just would someone point me in the right direction. (I'm a php tard but am learning). Thanks,