Product Release Information

Product:	Email template Express for order notification for CRELoaded 6.2
Release Number:	1.0.1
Release Date:	Nov 18, 2008
Customer Support:	For more information or support, please visit our website or contact us from the online form

Introduction

This document describes how to install and get started with Email template Express for order notification.

Features of the Email template Express for order notification:

• Allow to define email templates, macros in the email template.
• When loading the email, automatically replace macros with product name, customer name etc.
• No need to write the same content email again and again.

Minimal System Requirements

System requirements are described in the release notes.

Installation

What other software must be installed first?

Before you can install this product, you must obtain access to a web server with the following:

• PHP 4.x with :
• GD Library
• mCrypt
• Register Globals set to On via httpd.conf, php.ini or .htaccess
• The Apache Webserver
• MySQL database
• The Linux / Unix Operating System
• CRE Loaded 6.2 or later

How do I install CRE Loaded : Email template Express for order notification?

Please follow these steps:

1. Upload the files to your catalog directory on the webserver.


2. Open admin/includes/functions/general.php file, before last:
   ?>
   add:
   function html2text($html) { $html = preg_replace(array("/<br [\/]>/", "/<br>/", "/<p>/", "/<P>/", "/<BR>/"), "\n", $html); $html = preg_replace("/ /", " ", $html); $html = preg_replace("/>/", ">", $html); $html = preg_replace("/</", "<", $html); $html = preg_replace(array("/“/", "/”/"), '"', $html); $html = preg_replace("/<[\/\!]*?[^<>]*?>/", "", $html); $html = preg_replace("/.*?[{]*?[}]/", "", $html); return $html; }


3. Open admin/includes/filenames.php file, before last:
   ?>
   add:
   define('FILENAME_EMAIL_TEMPLATE', 'email_template.php');


4. Open admin/includes/database_tables.php file, before last:
   ?>
   add:
   define('TABLE_EMAIL_TEMPLATE', 'email_template');


5. Open admin/includes/languages/english.php file, before last:
   ?>
   add:
   define('TEXT_DISPLAY_NUMBER_OF_TEMPLATES', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> templates)'); define('BOX_OTHER_MENU','Other Menu'); define('BOX_EMAIL_TEMPLATES','Email Templates');


6. Open admin/edit_orders.php file, change:
   echo ' <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n";
   to:
   echo ' <td class="smallText">' . $orders_history['comments'] . ' </td>' . "\n";


7. Open admin/orders.php file, change:
   tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
   to:
   $message = $email; $message_text = htmlspecialchars_decode(html2text($email), ENT_QUOTES); $mimemessage = new email(array('X-Mailer: osCommerce')); $mimemessage->add_html($message); $mimemessage->add_text($message_text); $mimemessage->build_message(); $mimemessage->send($check_status['customers_name'], $check_status['customers_email_address'], STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_TEXT_SUBJECT);


8. Open admin/orders.php file, after:
   <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
   add:
   <?php if (tep_not_null($action)) { include('includes/javascript/editor.php'); echo tep_load_html_editor(); echo tep_insert_html_editor('mail_content_new','simple','300'); } ?>


9. Open admin/orders.php file, after:
   <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr>
   add:
   <tr> <td><div class="size_link"><strong><?php printf(TEXT_COMMENT_LIST_EXPLAIN, tep_image(DIR_WS_ICONS . 'f5a.gif', 'Collapse'), tep_image(DIR_WS_ICONS . 'f5b.gif', 'Collapse')); ?></strong></div><td> </tr>


10. Open admin/orders.php file, before:
    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>
    add:
    <td> </td>


11. Open admin/orders.php file, change:
    if (tep_db_num_rows($orders_history_query)) { while ($orders_history = tep_db_fetch_array($orders_history_query)) { echo ' <tr>' . "\n" . ' <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">'; if ($orders_history['customer_notified'] == '1') { echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n"; } else { echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n"; } echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n"; if($CommentsWithStatus) { echo ' <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n"; } echo ' </tr>' . "\n"; } } else {
    to:
    if ($number = tep_db_num_rows($orders_history_query)) { $index=0; while ($orders_history = tep_db_fetch_array($orders_history_query)) { echo ' <tr valign="top">' . "\n"; if ($index == $number - 1) { echo ' <td align="center" style="padding-top:5px!important;padding-top:9px;"><a class="linksize" href="javascript:set_status_history(' . $index . ');" ><div id="click' . $index . '" class="size_link" >' . tep_image(DIR_WS_ICONS . 'f5b.gif', TEXT_COLLAPSE, '', '', 'style="padding:3px"') . '</div></a></td>' . "\n"; } else { echo ' <td align="center" style="padding-top:5px!important;padding-top:9px;"><a class="linksize" href="javascript:set_status_history(' . $index.');" ><div id="click' . $index . '" class="size_link">' . tep_image(DIR_WS_ICONS . 'f5a.gif', TEXT_EXPAND, '', '', 'style="padding:3px"') . '</div></a></td>' . "\n"; } echo ' <td class="smallText" align="center" width="150">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">'; if ($orders_history['customer_notified'] == '1') { echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n"; } else { echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n"; } echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n"; if($CommentsWithStatus) { if ($index == $number - 1){ echo ' <td class="smallText"><div id="div_status_history' . $index . '" style="display:block;">' . nl2br($orders_history['comments']) . ' </div><div id="div_status_history_blank' . $index . '" style="display:none;"> </div></td>' . "\n"; } else { echo ' <td class="smallText"><div id="div_status_history' . $index . '" style="display:none;">' . nl2br($orders_history['comments']) . ' </div><div id="div_status_history_blank' . $index . '" style="display:block;"> </div></td>' . "\n"; } } echo ' </tr>' . "\n"; $index++; } } else {


12. Open admin/orders.php file, change:
    <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order', 'post', '', 'SSL'); ?> <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td> </tr>
    to:
    <?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order', 'post', '', 'SSL'); ?> <?php $email_templates = array(); $email_template_query = tep_db_query("select template_content, template_name,template_id from ". TABLE_EMAIL_TEMPLATE . " where template_type='1' " ); while ($templates = tep_db_fetch_array($email_template_query)) { $email_templates[] = array( 'name' => $templates['template_name'], 'content' => $templates['template_content'], 'template_id' =>$templates['template_id'] ); } $email_templates_dropdown = array(); $email_templates_dropdown[] = array('id' => '', 'text' => TEXT_SELECT_TEMPLATE); foreach ($email_templates as $value) { $email_templates_dropdown[] = array('id' => $value['template_id'], 'text' => $value['name']); } ?> <tr id='cusComments' style=" display:block;"> <td> <table> <tr> <td class="main" width="120px"> <?php echo TEXT_EMAIL_TEMPLATE . ': </td><td width="330px">' . tep_draw_pull_down_menu('template', $email_templates_dropdown, '', 'id="template" onchange="updateEmailContent(\'' . $oID . '\', \'2\', \'' . tep_session_id() . '\')"'); ?> </td> <td class="main" ><?php echo tep_draw_checkbox_field('html2', 'true', true, '', 'onclick="editorConvText2();" align="left" id="lhtml2"') . TEXT_ENABLE_HTML; ?></td> </tr> </table> </td> </tr> <tr > <td class="main"> <div id="text_content"><?php echo tep_draw_textarea_field('mail_content_new', 'soft', '100', '15', $mail_content, 'id="mail_content_new" '); ?></div> </td> </tr> <tr> <td > <div id="text_content2" style="display: none;"><?php echo tep_draw_textarea_field('mail_content_new2', 'soft', '100', '15', $mail_content, 'id="mail_content_new2"'); ?></div> </td> <tr>


13. Run SQL statement in phpMyAdmin:
    CREATE TABLE IF NOT EXISTS `email_template` ( `template_id` int(11) NOT NULL auto_increment, `template_content` text NOT NULL, `date_created` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `subject` varchar(255) NOT NULL default '', `template_type` varchar(4) NOT NULL default '', `template_name` varchar(32) NOT NULL default '', PRIMARY KEY (`template_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

How can I uninstall CRE Loaded : Email template Express for order notification?

    Delete all files that you added

    Change all modified files back

What if I encounter problems?

    Please see the troubleshooting section in the FAQ.