Example #1
0
 function updateMsgTemplate($vars, &$errors)
 {
     if (!($tpls = Template::message_templates()) || !$tpls[$vars['tpl']]) {
         $errors['tpl'] = 'Unknown or invalid template';
     }
     if (!$vars['subj']) {
         $errors['subj'] = 'Message subject required';
     }
     if (!$vars['body']) {
         $errors['body'] = 'Message body required';
     }
     if ($errors) {
         return false;
     }
     $sql = 'UPDATE ' . EMAIL_TEMPLATE_TABLE . ' SET updated=NOW() ';
     switch (strtolower($vars['tpl'])) {
         case 'ticket_autoresp':
             $sql .= ',ticket_autoresp_subj=' . db_input($vars['subj']) . ',ticket_autoresp_body=' . db_input($vars['body']);
             break;
         case 'msg_autoresp':
             $sql .= ',message_autoresp_subj=' . db_input($vars['subj']) . ',message_autoresp_body=' . db_input($vars['body']);
             break;
         case 'ticket_notice':
             $sql .= ',ticket_notice_subj=' . db_input($vars['subj']) . ',ticket_notice_body=' . db_input($vars['body']);
             break;
         case 'overlimit_notice':
             $sql .= ',ticket_overlimit_subj=' . db_input($vars['subj']) . ',ticket_overlimit_body=' . db_input($vars['body']);
             break;
         case 'ticket_reply':
             $sql .= ',ticket_reply_subj=' . db_input($vars['subj']) . ',ticket_reply_body=' . db_input($vars['body']);
             break;
         case 'ticket_alert':
             $sql .= ',ticket_alert_subj=' . db_input($vars['subj']) . ',ticket_alert_body=' . db_input($vars['body']);
             break;
         case 'msg_alert':
             $sql .= ',message_alert_subj=' . db_input($vars['subj']) . ',message_alert_body=' . db_input($vars['body']);
             break;
         case 'note_alert':
             $sql .= ',note_alert_subj=' . db_input($vars['subj']) . ',note_alert_body=' . db_input($vars['body']);
             break;
         case 'assigned_alert':
             $sql .= ',assigned_alert_subj=' . db_input($vars['subj']) . ',assigned_alert_body=' . db_input($vars['body']);
             break;
         case 'transfer_alert':
             $sql .= ',transfer_alert_subj=' . db_input($vars['subj']) . ',transfer_alert_body=' . db_input($vars['body']);
             break;
         case 'overdue_alert':
             $sql .= ',ticket_overdue_subj=' . db_input($vars['subj']) . ',ticket_overdue_body=' . db_input($vars['body']);
             break;
         default:
             $errors['tpl'] = 'Unknown or invalid template';
             return false;
     }
     $sql .= ' WHERE  tpl_id=' . db_input($this->getId());
     return db_query($sql);
 }
Example #2
0
<?php

$msgtemplates = Template::message_templates();
$info = Format::htmlchars($errors && $_POST ? $_POST : $_REQUEST);
$info['tpl'] = $info['tpl'] && $msgtemplates[$info['tpl']] ? $info['tpl'] : 'ticket_autoresp';
$tpl = $msgtemplates[$info['tpl']];
$info = array_merge($template->getMsgTemplate($info['tpl']), $info);
?>
<h2>Email Template Message - <span><?php 
echo $template->getName();
?>
</span></h2>
<div style="padding-top:10px;padding-bottom:5px;">
    <form method="get" action="templates.php">
    <input type="hidden" name="id" value="<?php 
echo $template->getId();
?>
">
    <input type="hidden" name="a" value="manage">
    Message Template:
    <select name="tpl" style="width:300px;">
        <option value="">&mdash; Select Setting Group &mdash;</option>
        <?php 
foreach ($msgtemplates as $k => $v) {
    $sel = $info['tpl'] == $k ? 'selected="selected"' : '';
    echo sprintf('<option value="%s" %s>%s</option>', $k, $sel, $v['name']);
}
?>
    </select>
    <input type="submit" value="Go">
    &nbsp;&nbsp;&nbsp;<font color="red"><?php 
            </td>
        </tr>
        <?php 
if ($template) {
    ?>
        <tr>
            <th colspan="2">
                <em><strong>Template Messages</strong>: Click on the message to edit.&nbsp;
                    <span class="error">*&nbsp;<?php 
    echo $errors['rules'];
    ?>
</span></em>
            </th>
        </tr>
        <?php 
    foreach (Template::message_templates() as $k => $tpl) {
        echo sprintf('<tr><td colspan=2>&nbsp;<strong><a href="templates.php?id=%d&a=manage&tpl=%s">%s</a></strong>&nbsp-&nbsp<em>%s</em></td></tr>', $template->getId(), $k, Format::htmlchars($tpl['name']), Format::htmlchars($tpl['desc']));
    }
} else {
    ?>
        <tr>
            <td width="180" class="required">
                Template To Clone:
            </td>
            <td>
                <select name="tpl_id">
                    <option value="0">&mdash; Select One &dash;</option>
                    <?php 
    $sql = 'SELECT tpl_id,name FROM ' . EMAIL_TEMPLATE_TABLE . ' ORDER by name';
    if (($res = db_query($sql)) && db_num_rows($res)) {
        while (list($id, $name) = db_fetch_row($res)) {