Display message body in a template

[Evert]

Hi I like to include the users' message in one of my templates. I know how to include the ticketid & subject line, but I can't find out how to reference the actual message. Could you provide me the proper code for this please?

[supportskins]

Admin CP > Tickets > General Ticket Settings > Send Complete History in Staff Replies

[Evert]

Tx supportskins, but what I actually try to reach is to include the original message via a template-variable in the Auto-reply message.
Just as I can use the <{$ticket[subject]}>-notation in any template to include the subjectline, I'd like to include the mail message as well.

[Dewak]

Hi Evert,

Dewak is a software development company with a lot of experience doing Kayako modifications. Here is what you need to do:

1. Open file modules/tickets/functions_ticketmain.php

2. Go to line #1758, on function "loadTemplateVariables"

3. Do a MySQL query to get the mail message and then store it on a variable

$messageMail = $dbCore->queryFetch("SELECT message 
                                        FROM table". 
                                        WHERE condition);

4. Assign the variable to Smarty.

$template->assign("messageMail", $messageMail);

5. Now you can use the variable on the template <{$messageMail}>

If you need further assistance please contact us, feel free to send me an email to andres@dewak.com.

[Evert]

Hi Andres,
many thanks for the answer.
Do you know any way to do this in the Hosted version of Kayako?

Cheers, Evert

[supportskins]

No. Incase of hosted solution you do not have access to software source code.

[Dewak]

that's correct Evert, with the hosted version you can't change the source code. (Thanks Supportskins). If you wish to implement these changes go for the Owned or leased versions.