1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
<?php
/* $Id: layers_toggle.php,v 1.17.2.1 2005/12/02 21:45:15 cknudsen Exp $ */
include_once 'includes/init.php';
load_user_layers ();
$status = getValue ( 'status', '(on|off)', true );
if ( $allow_view_other != 'Y' ) {
print_header ();
etranslate("You are not authorized");
print_trailer ();
exit;
}
$updating_public = false;
if ( $is_admin && ! empty ( $public ) && $public_access == "Y" ) {
$updating_public = true;
$layer_user = "__public__";
$url = 'layers.php?public=1';
} else {
$layer_user = $login;
$url = 'layers.php';
}
$sql = "DELETE FROM webcal_user_pref WHERE cal_login = '$layer_user' " .
"AND cal_setting = 'LAYERS_STATUS'";
dbi_query ( $sql );
$value = ( $status == "off" ? "N" : "Y" );
$sql = "INSERT INTO webcal_user_pref " .
"( cal_login, cal_setting, cal_value ) VALUES " .
"( '$layer_user', 'LAYERS_STATUS', '$value' )";
if ( ! dbi_query ( $sql ) ) {
$error = "Unable to update preference: " . dbi_error () .
"<br /><br /><span style=\"font-weight:bold;\">SQL:</span> $sql";
break;
}
if ( empty ( $error ) ) {
do_redirect ( $url );
}
print_header();
?>
<h2><?php etranslate("Error")?></h2>
<?php etranslate("The following error occurred")?>:
<blockquote>
<?php echo $error; ?>
</blockquote>
<?php print_trailer(); ?>
</body>
</html>
|