pquery($sql, array($_REQUEST["templateid"])); $tempArray = $adb->fetch_array($tempresult); $fileContent = $tempArray["body"]; checkFileAccess($root_directory.'/modules/Emails/templates/'.$_REQUEST["templatename"]); $handle = fopen($root_directory.'/modules/Emails/templates/'.$_REQUEST["templatename"],"wb") ; fwrite($handle,$fileContent,89999999); fclose($handle); //create a file and write to it so that it can be used as the emailtemplateusage.php file if (is_file($root_directory.'/modules/Emails/templates/testemailtemplateusage.php')) { $is_writable = is_writable($root_directory.'/modules/Emails/templates/testemailtemplateusage.php'); } else { $is_writable = is_writable('.'); } $myString = "retrieve_entity_info($recordid,$module); $i=0; $m=0; $n=0; $myString; //storing the columnname and the value pairs foreach ($focus->column_fields as $columnName=>$value) { $myString .= "$" .$module ."_" .$columnName.' = "'. $value."\";\n\n"; $colName[$i] = $columnName; $i++; $j=$i; } global $current_user; global $adb; $query = 'select * from vtiger_users where id= ?'; $result = $adb->pquery($query, array($current_user->id)); $res_row = $adb->fetchByAssoc($result); foreach ($res_row as $columnName=>$value) { $myString .='$users_' .$columnName.' = "'. $value."\";\n\n"; $usercolName[$n] = $columnName; $n++; $m=$n; } $myString .= "\$globals = \""; for($i=0;$i<$j-1;$i++) { $myString .= "\\$" .$module ."_" .$colName[$i].", "; } for($n=0;$n<$m;$n++) { $myString .= '\\$users_' .$usercolName[$n].", "; } $myString .= "\\$" .$module ."_" .$colName[$i]; $myString .="\"; \n\n"; $myString .= "?> \n"; if ($is_writable && ($config_file = @ fopen($root_directory.'/modules/Emails/templates/testemailtemplateusage.php', "w"))) { $log->debug("writing to the testemailtemplatuseage.php file"); fputs($config_file, $myString, strlen($myString)); fclose($config_file); } checkFileAccess($root_directory.'/modules/Emails/templates/'.$_REQUEST["templatename"]); $templatename = $root_directory.'/modules/Emails/templates/'.$_REQUEST["templatename"]; header("Location:index.php?module=Users&action=TemplateMerge&templatename=".$templatename); ?>