Procesing template fields

[erbe]

I've modified the ticketlist template to show also the ticket creation date.

After some tests I've found that I can get the creation date in unix time using the var <{$ticket[dateline]}> but I know that this is not a real php variable and is more like a string to be parsed by kayako.

Since I want to use date('dd-mm-YY', $ticket[dateline]) to format the unix time to a human readable time I don't really know how I can proces this variable inside php. I've tried with <?php echo " <{$ticket[dateline]}> "; ?> for example but it doesn't works so I don't know what I have to do...

[thuan]

Hi,
I did this by changing the sql behind the whole thing..
In the client_tickets.php under \modules\tickets

....
//$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."tickets` AS tickets WHERE `email` IN (". buildIN($_emaillist) .") ORDER BY `lastactivity` DESC LIMIT ".intval($_offset).",".intval($_limit).";");
$dbCore->query("SELECT ticketmaskid,subject,ticketid,ticketstatusid,prior ityid,departmentid,from_unixtime(dateline) as dateline,lastreplier,fullname FROM `". TABLE_PREFIX ."tickets` AS tickets WHERE `email` IN (". buildIN($_emaillist) .") ORDER BY `lastactivity` DESC LIMIT ".intval($_offset).",".intval($_limit).";");
..............