Exemple #1
0
        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 
Exemple #2
0
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());
    }
}