Showing All Messages in Support Emails

[grantwood]

Hello,

 

One of the placeholders in the support emails is {$ticket_url}, which links to a page that shows all of the messages for a given ticket.

 

Is it possible to include all messages in a support email, perhaps using the {foreach} tag? Or maybe you can add a {ticket_messgae_all} tag?

 

The reason has to do with Amazon (we are a reseller there). Amazon does not allow URLs when communicating with customers.

 

Regards,

Sean

[m00]

Hello,

 

One of the placeholders in the support emails is {$ticket_url}, which links to a page that shows all of the messages for a given ticket.

 

Is it possible to include all messages in a support email, perhaps using the {foreach} tag? Or maybe you can add a {ticket_messgae_all} tag?

 

The reason has to do with Amazon (we are a reseller there). Amazon does not allow URLs when communicating with customers.

 

Regards,

Sean

 

One of our customers is also Amazon reseller. There isn't a variable available in the ticket reply email template for this, so we've created the following code:

{php}
$result = select_query("tbltickets", "id,date,message", array("tid" => $this->_tpl_vars['ticket_id']));
while($data = mysql_fetch_array($result))
{
$result2 = select_query("tblticketreplies", "date,message", array("tid" => $data['id']), "id", "DESC");
while($data2 = mysql_fetch_array($result2))
{
	echo "----------------------------------------------<br />\n"; 
	echo $data2['date']."<br />\n"; 
	echo "----------------------------------------------<br />\n"; 
	echo $data2['message']."<br />\n"; 
}

echo "----------------------------------------------<br />\n"; 
echo $data['date']."<br />\n"; 
echo "----------------------------------------------<br />\n"; 
echo $data['message']."<br />\n"; 
}
{/php}

[grantwood]

@m00,

 

Thanks for the reply. Where can I find information on the select_query function?

[m00]

@m00,

 

Thanks for the reply. Where can I find information on the select_query function?

 

I don't think there's official documentation about that. Do you have any questions about it?