[mod] HTML Email Templates

[bkonia]

This mod adds a field called HTML Email Template to the Preferences screen. In this field, you can enter an HTML template that will be used for every outgoing email. Insert a %message placeholder where you want the text of the outgoing message to be inserted into the template. If the script finds the %message placeholder in this field, it will automatically create an HTML MIME part in every outgoing email, in addition to the existing text part.

The mod required changes to:

* class.email.php
* class.config.php
* preferences.inc.php

The modified versions of those files are attached. This will work as a drop-in replacement for the original files with version 1.6ST. Additionally, you will have to add a new field, "html_email_template", in the ost_config database table. The field type should be "text". All the changes are commented with my initials, BSK.

This mod also fixes a bug in class.config.php that was causing the "Allow Spoof" setting to become disabled every time the Preferences screen was saved, regardless of whether the checkbox was enabled or disabled. This is completely unrelated to HTML templates, but since it fixes a fairly nasty bug, I figured I may as well include it.

[mig2000]

This MOD is only for the HTML Templates or it actually add the capability for OS Ticket to send Email in HTML?

[bkonia]

Originally Posted by mig2000

This MOD is only for the HTML Templates or it actually add the capability for OS Ticket to send Email in HTML?

Not sure I understand your question. With this mod, osTicket will send all emails with both a plain text part and an HTML part. The mod creates the HTML part by wrapping an HTML template that you define around your plain text message that you would type in a support ticket, etc...

If you're asking whether you can use HTML within the actual message text, currently the answer would be no, because the HTML you enter would be sent in the plain text part of the email, which would make it unreadable for the 0.1% of people who still use plain text email programs.

On the other hand, it's pretty easy to update the mod to support HTML within the message text. On line 171 of my modified class.email.php, change:

$mime->setTXTBody($body);

to

$mime->setTXTBody(strip_tags($body));

Now, your HTML part will be sent as HTML and your text part will be stripped of all the HTML tags, so it will be sent as plain text.

[blazeman]

This worked great. Thanks for this mod!

[guiloc4]

i get an error response that ends with:



Unknown column 'html_email_template' in 'field list'

[bkonia]

Originally Posted by guiloc4

i get an error response that ends with:

Unknown column 'html_email_template' in 'field list'

That's correct. As I stated in my original post:

Additionally, you will have to add a new field, "html_email_template", in the ost_config database table. The field type should be "text".

[Paolo Poma]

This MOD also allow to receive mail in html with image ?
i have a problem when the client open a ticket via e-mail and attach an immage (screen shot) in the test to explain his problem.
In this case in the ticket the image is lost.

thanks

[bkonia]

Originally Posted by Paolo Poma

This MOD also allow to receive mail in html with image ?
i have a problem when the client open a ticket via e-mail and attach an immage (screen shot) in the test to explain his problem.
In this case in the ticket the image is lost.

thanks

Sorry, but this mod has nothing to do with receiving emails. It affects sending only.

[krott]

How can I add new field?
What type command in mysql?

[AlphaDesignsGroup]

Excellent piece of code. Thank You very much. I think we can all agree that the original format was a bit plain without any formatting. Your instructions were well worded and worked perfect right out of the box. Fortunatly, for me, the three files you .zipped we some of the few that I had not already made other changes to... but...

There is always one of those in there... And this is not a bad thing, just a matter of conveneince for the person receiving the mail. I know the variables used in the orignal templates can not be used in the HTML box. The thing is, the link back to the support system to check/update your ticket info "was" an html link that could just be clicked on in the email. With the HTML format around it, it is no longer a link, but just text. This software is too new for me to figure it out, so I was wondering if anyone had found a way around that so clickable links could be put into the original templates, or code to find and convert links to a clickable link before it is sent. Thanks Bkonia !!!