function save_layer($layer_user, $layeruser, $layercolor, $dups, $id) { global $error, $layers; 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_execute('UPDATE webcal_user_layers SET cal_layeruser = ?, cal_color = ?, cal_dups = ? WHERE cal_layerid = ?', array($layeruser, $layercolor, $dups, $layerid)); } else { // New layer entry. // Check for existing layer for user. Can only have one layer per user. $res = dbi_execute('SELECT COUNT( cal_layerid ) FROM webcal_user_layers WHERE cal_login = ? AND cal_layeruser = ?', array($layer_user, $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_execute('SELECT MAX( cal_layerid ) FROM webcal_user_layers'); if ($res) { $row = dbi_fetch_row($res); $layerid = $row[0] + 1; } else { $layerid = 1; } dbi_execute('INSERT INTO webcal_user_layers ( cal_layerid, cal_login, cal_layeruser, cal_color, cal_dups ) VALUES ( ?, ?, ?, ?, ? )', array($layerid, $layer_user, $layeruser, $layercolor, $dups)); } } } }
<?php include_once $gfplugins . 'webcalendar/www/includes/init.php'; load_user_layers(); if (!$is_admin) { echo "<h2>" . translate("Error") . "</h2>" . translate("You are not authorized") . ".\n"; echo "</body>\n</html>"; exit; } $error = ""; if ($action == "Delete" || $action == translate("Delete")) { // delete this nonuser calendar $user = $nid; // Get event ids for all events this user is a participant $events = array(); $res = dbi_query("SELECT webcal_entry.cal_id " . "FROM webcal_entry, webcal_entry_user " . "WHERE webcal_entry.cal_id = webcal_entry_user.cal_id " . "AND webcal_entry_user.cal_login = '******'"); if ($res) { while ($row = dbi_fetch_row($res)) { $events[] = $row[0]; } } // Now count number of participants in each event... // If just 1, then save id to be deleted $delete_em = array(); for ($i = 0; $i < count($events); $i++) { $res = dbi_query("SELECT COUNT(*) FROM webcal_entry_user " . "WHERE cal_id = " . $events[$i]); if ($res) { if ($row = dbi_fetch_row($res)) { if ($row[0] == 1) { $delete_em[] = $events[$i]; }
$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 = "******"; } 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 = '******', 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 = '******' AND cal_layeruser = '******'"); if ($res) { $row = dbi_fetch_row($res); if ($row[0] > 0) { $error = translate("You can only create one layer for each user") . "."; }
$u = getValue("user", "[A-Za-z0-9_\\.=@,\\-]+", true); if (!empty($u)) { $username = $u; $login = $u; // We also set $login since some functions assume that it is set. } } $cat_id = ''; if ($categories_enabled == 'Y') { $x = getIntValue("cat_id", true); if (!empty($x)) { $cat_id = $x; } } if ($load_layers) { load_user_layers($username); } //load_user_categories (); // Calculate date range $date = getIntValue("date", true); if (empty($date) || strlen($date) != 8) { // If no date specified, start with today $date = date("Ymd"); } $thisyear = substr($date, 0, 4); $thismonth = substr($date, 4, 2); $thisday = substr($date, 6, 2); $startTime = mktime(3, 0, 0, $thismonth, $thisday, $thisyear); $x = getIntValue("days", true); if (!empty($x)) { $numDays = $x;
<?php /* $Id: week.php,v 1.133.2.5 2008/09/27 14:50:18 cknudsen Exp $ */ include_once 'includes/init.php'; //check UAC if (!access_can_access_function(ACCESS_WEEK) || !empty($user) && !access_user_calendar('view', $user)) { send_to_preferred_view(); } load_user_layers($user != $login && $is_nonuser_admin ? $user : ''); load_user_categories(); $nextYmd = date('Ymd', mktime(0, 0, 0, $thismonth, $thisday + 7, $thisyear)); $prevYmd = date('Ymd', mktime(0, 0, 0, $thismonth, $thisday - 7, $thisyear)); $boldDays = !empty($BOLD_DAYS_IN_YEAR) && $BOLD_DAYS_IN_YEAR == 'Y'; $wkstart = get_weekday_before($thisyear, $thismonth, $thisday + 1); $wkend = $wkstart + 86400 * ($DISPLAY_WEEKENDS == 'N' ? 5 : 7); $startdate = date('Ymd', $wkstart); $enddate = date('Ymd', $wkend); $start_ind = 0; if ($DISPLAY_WEEKENDS == 'N') { $end_ind = 4; $WEEK_START = 1; //Set to Monday. } else { $end_ind = 6; } if (empty($TIME_SLOTS)) { $TIME_SLOTS = 24; } $interval = 1440 / $TIME_SLOTS; $first_slot = intval($WORK_DAY_START_HOUR * 60 / $interval); $last_slot = intval($WORK_DAY_END_HOUR * 60 / $interval);