debug("the templateid is set to the value ".$templateid); } $sql = "select * from vtiger_emailtemplates where templateid=?"; $result = $adb->pquery($sql, array($templateid)); $emailtemplateResult = str_replace('"','"',$adb->fetch_array($result)); $smod_strings = return_module_language($current_language,'Settings'); //To get Email Template variables -- Pavani $allOptions=getEmailTemplateVariables(); $smarty = new vtigerCRM_smarty; $smarty->assign("UMOD", $mod_strings); $smarty->assign("APP", $app_strings); $smarty->assign("THEME", $theme_path); $smarty->assign("IMAGE_PATH", $image_path); $smarty->assign("MOD", $smod_strings); $smarty->assign("FOLDERNAME", $emailtemplateResult["foldername"]); $smarty->assign("TEMPLATENAME", $emailtemplateResult["templatename"]); $smarty->assign("TEMPLATEID", $emailtemplateResult["templateid"]); $smarty->assign("DESCRIPTION", $emailtemplateResult["description"]); $smarty->assign("SUBJECT", $emailtemplateResult["subject"]); $smarty->assign("BODY", $emailtemplateResult["body"]); $smarty->assign("MODULE", 'Settings'); $smarty->assign("PARENTTAB", getParentTab()); $smarty->assign("EMODE", $mode); $smarty->assign("ALL_VARIABLES", $allOptions); $smarty->display("CreateEmailTemplate.tpl"); ?>