Viewing file: edit_template.php (2.59 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php /* * $Id: edit_template.php,v 1.9.2.1 2005/11/28 22:22:51 cknudsen Exp $ * * Page Description: * This page will present the HTML form to edit an entry * in the cal_report table, and this page will also process the * form. * This is only used for editing the custom header/trailer. * The report_id is always 0. * * Input Parameters: * type - "header" or "trailer" * * Security: * Admin permissions are checked in connect.php. */ include_once 'includes/init.php';
$report_id = 0; $error = '';
$type = getValue ( "type", "S|H|T", true ); $cur = ''; $found = false;
// Get existing value. $res = dbi_query ( "SELECT cal_template_text " . "FROM webcal_report_template " . "WHERE cal_template_type = '$type' AND caL_report_id = 0" ); if ( $res ) { if ( $row = dbi_fetch_row ( $res ) ) { $cur = $row[0]; $found = true; } dbi_free_result ( $res ); }
if ( empty ( $REQUEST_METHOD ) ) $REQUEST_METHOD = $_SERVER['REQUEST_METHOD'];
// Handle form submission if ( $REQUEST_METHOD == 'POST' ) { $template = getPostValue ( "template" ); //echo "Template: " . $template . "<br />\n"; exit; if ( $found ) { $sql = "UPDATE webcal_report_template " . "SET cal_template_text = '$template' " . "WHERE cal_template_type = '$type' AND cal_report_id = 0"; } else { $sql = "INSERT INTO webcal_report_template " . "( cal_template_type, cal_report_id, cal_template_text ) " . "VALUES ( '$type', 0, '$template' )"; } if ( ! dbi_query ( $sql ) ) { $error = translate("Database error") . ": " . dbi_error (); } else { //echo "SQL: $sql <br />\n"; echo "<html>\n<head>\n</head>\n<body onload=\"window.close();\">\nDone</body>\n</html>"; exit; } }
print_header( '', '', '', true ); //echo "report_id: $report_id <br />\n"; //echo "report_name: $report_name <br />\n"; //echo "report_user: $report_user <br />\n"; ?>
<h2><?php if ( $type == 'S' ) etranslate("Edit Custom Script/Stylesheet"); else if ( $type == 'H' ) etranslate("Edit Custom Header"); else etranslate("Edit Custom Trailer"); ?></h2>
<?php if ( ! empty ( $error ) ) { echo "<h2>" . translate("Error") . "</h2>\n" . $error . "\n"; } else { ?> <form action="edit_template.php" method="post" name="reportform">
<input type="hidden" name="type" value="<?php echo $type;?>" /> <textarea rows="15" cols="60" name="template"><?php echo htmlspecialchars ( $cur )?></textarea>
<br /> <input type="button" value="<?php etranslate("Cancel")?>" onclick="window.close();" /> <input type="submit" value="<?php etranslate("Save")?>" /> </form>
<?php } print_trailer ( false, true, true ); ?> </body> </html>
|