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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
<?php
include_once 'includes/init.php';
$error = "";
if ( $allow_view_other != 'Y' ) {
$error = translate("You are not authorized");
}
if ( empty ( $dups ) )
$dups = 'N';
$updating_public = false;
if ( $is_admin && ! empty ( $public ) && $public_access == "Y" ) {
$updating_public = true;
$layer_user = "__public__";
} else {
$layer_user = $login;
}
if ( $layer_user == $layeruser )
$error = translate ("You cannot create a layer for yourself") . ".";
load_user_layers ( $layer_user, 1 );
if ( ! empty ( $layeruser ) && $error == "" ) {
// existing layer entry
if ( ! empty ( $layers[$id]['cal_layeruser'] ) ) {
// update existing layer entry for this user
$layerid = $layers[$id]['cal_layerid'];
dbi_query ( "UPDATE webcal_user_layers SET cal_layeruser = '$layeruser', cal_color = '$layercolor', cal_dups = '$dups' WHERE cal_layerid = '$layerid'");
} else {
// new layer entry
// check for existing layer for user. can only have one layer per user
$res = dbi_query ( "SELECT COUNT(cal_layerid) FROM webcal_user_layers " .
"WHERE cal_login = '$layer_user' AND cal_layeruser = '$layeruser'" );
if ( $res ) {
$row = dbi_fetch_row ( $res );
if ( $row[0] > 0 ) {
$error = translate ("You can only create one layer for each user") . ".";
}
dbi_free_result ( $res );
}
if ( $error == "" ) {
$res = dbi_query ( "SELECT MAX(cal_layerid) FROM webcal_user_layers" );
if ( $res ) {
$row = dbi_fetch_row ( $res );
$layerid = $row[0] + 1;
} else {
$layerid = 1;
}
dbi_query ( "INSERT INTO webcal_user_layers ( ".
"cal_layerid, cal_login, cal_layeruser, cal_color, cal_dups ) " .
"VALUES ('$layerid', '$layer_user', '$layeruser', " .
"'$layercolor', '$dups')");
}
}
}
if ( $error == "" ) {
if ( $updating_public )
do_redirect ( "layers.php?public=1" );
else
do_redirect ( "layers.php" );
exit;
}
print_header();
?>
<h2><?php etranslate("Error")?></h2>
<blockquote>
<?php echo $error; ?>
</blockquote>
<?php print_trailer(); ?>
</body>
</html>
|
