if (count($events) == 0) { ?> <option value="">-- <?php echo $lg['EVENTS_EMPTY']; ?> --</option> <?php } else { ?> <option value="">-- <?php echo $lg['CHOOSE']; ?> --</option> <?php foreach ($events as $event) { $merged = getMergedRounds($event['xRunde']); if ($merged != "") { $categories = getMergedCategories($merged); $cat_string = ""; $tmp = ""; foreach ($categories as $cat) { $cat_string .= $tmp . $cat['cat_name']; $tmp = "/"; } } else { $cat_string = $event['cat_name']; } $sel = $event['xSerie'] == CFG_CURRENT_EVENT ? ' selected="selected"' : ''; $round_bez = $event['round_type'] != '0' ? "- " . $event['round_name'] . " " . $event['serie_bez'] : ""; ?> <option value="<?php
function closeEvent($round, $status) { global $glb_connection_server; try { $_SESSION[CFG_SESSION]['xSerie'] = 0; $_SESSION[CFG_SESSION]['xMeeting'] = 0; if ($round > 0) { $merged = getMergedRounds($round); if ($merged) { $where = "WHERE xRunde IN " . $merged; } else { $where = "WHERE xRunde = :runde"; } $sql_status = "UPDATE runde\r\n SET Status = :status\r\n " . $where . ";"; $query_status = $glb_connection_server->prepare($sql_status); // +++ bind parameters $query_status->bindValue(':status', $status); if (!$merged) { $query_status->bindValue(':runde', $round); } // --- bind parameters $query_status->execute(); } } catch (PDOException $e) { trigger_error($e->getMessage()); } }