Hi there,
In current version (1.6 RC4), we can only use one selection for email template from Admin Panel -> Settings -> Preferences. You can see that, there is a "Default Email Template:" directive, with drop-down combobox that Admin SHOULD select one of some selections.
In fact, only one record available that Admin can select from this directive. It is: "osTicket Default Template"!. Although if we add new record in email_template table, this drop-down combobox will still contains only one selection! :(
Now I made MOD Multiple Email Template, in order Admin can select another one from this selections after we add new record in email_template table.
Okay. Let's getting started now.
Open \include\staff\templates.inc.php, and FIND:
<?php
if(!defined('OSTADMININC') || !$thisuser->isadmin()) die('Access Denied');
$tpl=null;
$id=1;
$sql='SELECT * FROM '.EMAIL_TEMPLATE_TABLE.' WHERE tpl_id=1 AND cfg_id='.db_input($cfg->getId());
$tpl=Format:(($errors && $_POST)?$_POST(db_query($sql)));
?>
<div class="msg">Email Templates</div>
<table width="100%" border="0" cellspacing=0 cellpadding=0>
<form action="admin.php?t=templates" method="post">
<input type="hidden" name="t" value="templates">
<input type="hidden" name="do" value="update">
<input type="hidden" name="id" value="1">
REPLACE WITH:
<?php
if(!defined('OSTADMININC') || !$thisuser->isadmin()) die('Access Denied');
$tpl=null;
// MOD: Multiple Email Template, by Masino Sinaga, April 18, 2009
$id=db_input($cfg->getDefaultTemplateId());
$sql='SELECT * FROM '.EMAIL_TEMPLATE_TABLE.' WHERE tpl_id='.$id.' AND cfg_id='.db_input($cfg->getId());
$tpl=Format:(($errors && $_POST)?$_POST(db_query($sql)));
?>
<div class="msg">Email Templates: <?php echo $tpl; ?></div>
<table width="100%" border="0" cellspacing=0 cellpadding=0>
<form action="admin.php?t=templates" method="post">
<input type="hidden" name="t" value="templates">
<input type="hidden" name="do" value="update">
<input type="hidden" name="id" value="<?php echo ($id); ?>">
<?php // MOD: Multiple Email Template, by Masino Sinaga, April 18, 2009 ?>
Open file \scp\admin.php, FIND:
' WHERE tpl_id='.db_input($_POST);
REPLACE WITH:
' WHERE tpl_id='.db_input($_POST).' AND cfg_id='.db_input($cfg->getId()).'';
// MOD: Multiple Email Template, by Masino Sinaga, April 18, 2009
Open file \include\staff\preference.inc.php, FIND:
$templates=db_query('SELECT tpl_id,name FROM '.EMAIL_TEMPLATE_TABLE.' WHERE tpl_id=1 AND cfg_id='.db_input($cfg->getId()));
REPLACE WITH:
// MOD: Multiple Email Template, by Masino Sinaga, April 18, 2009
$templates=db_query('SELECT tpl_id,name FROM '.EMAIL_TEMPLATE_TABLE.' WHERE cfg_id='.db_input($cfg->getId()));
Now, we will see the effect. Please follow these three steps:
First, Add a new record in email_template table, with different name template that already exists in that table. Please make sure in "cfg_id" field the value = 1 whereas autonumber value in "tpl_id"; in this case the value of "tpl_id" = 2. Enter the different name in "name" field, i.e: "Another Template One".
Second, Go to Admin Panel -> Settings -> Preferences. You should now have another selections in "Default Email Template:" drop-down. Tarraaa... now we have "Another Template One" selection. Select this new item, and save this new setting by clicking on "Save Changes" button.
Third, Go to Admin Panel -> Emails -> Templates. Now, you should see that the name of this template is: "Email Template: Another Template One". Each time you want to use/change to another template, you have to go first to Admin Panel -> Settings -> Preferences, then change default setting from "Default Email Template:" directive, save the new setting, then goto Admin Panel -> Emails -> Templates.
That's all, everyone. I know some of you need list of email template to make easy for editing. But I still don't have much time to do this.
Hope this helpful for you. Have a nice code, and Cheers! :)
Best regards,
Masino Sinaga
