Viewing file: views_edit_handler.php (2.24 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include_once 'includes/init.php';
$error = "";
$viewisglobal = getPostValue ( "is_global" ); if ( ! $is_admin || $viewisglobal != 'Y' ) $viewisglobal = 'N'; // only admin can create global view //echo "viewisglobal = $viewisglobal"; exit;
if ( $action == "Delete" || $action == translate ("Delete") ) { // delete this view dbi_query ( "DELETE FROM webcal_view WHERE cal_view_id = $id " . "AND cal_owner = '$login'" ); } else { if ( empty ( $viewname ) ) { $error = translate("You must specify a view name"); } else if ( ! empty ( $id ) ) { # update if ( ! dbi_query ( "UPDATE webcal_view SET cal_name = " . "'$viewname', cal_view_type = '$viewtype', " . "cal_is_global = '$viewisglobal' " . "WHERE cal_view_id = $id AND cal_owner = '$login'" ) ) { $error = translate ("Database error") . ": " . dbi_error(); } } else { # new... get new id first $res = dbi_query ( "SELECT MAX(cal_view_id) FROM webcal_view" ); if ( $res ) { $row = dbi_fetch_row ( $res ); $id = $row[0]; $id++; dbi_free_result ( $res ); $sql = "INSERT INTO webcal_view " . "( cal_view_id, cal_owner, cal_name, cal_view_type, cal_is_global ) " . " VALUES ( $id, '$login', '$viewname', '$viewtype', '$viewisglobal' )"; if ( ! dbi_query ( $sql ) ) { $error = translate ("Database error") . ": " . dbi_error(); } } else { $error = translate ("Database error") . ": " . dbi_error(); } }
# update user list if ( $error == "" ) { dbi_query ( "DELETE FROM webcal_view_user WHERE cal_view_id = $id" ); // If selected "All", then just put "__all__" in for usernamne. if ( getPostValue ( "viewuserall" ) == "Y" ) $users = array ( "__all__" ); for ( $i = 0; ! empty ( $users ) && $i < count ( $users ); $i++ ) { dbi_query ( "INSERT INTO webcal_view_user ( cal_view_id, cal_login ) " . "VALUES ( $id, '$users[$i]' )" ); } } }
if ( $error == "" ) { do_redirect ( "views.php" ); } print_header(); ?>
<h2><?php etranslate("Error")?></h2>
<blockquote> <?php
echo $error; //if ( $sql != "" ) // echo "<br /><br /><span style=\"font-weight:bold;\">SQL:</span> $sql"; //?> </blockquote>
<?php print_trailer(); ?> </body> </html>
|