<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 echo $event['xSerie']; ?>
function getEvents($meeting = 0, $event = 0) { global $glb_connection_server; global $glb_status_results, $glb_status_live; global $glb_types_results; try { if ($meeting != 0) { $and_meeting = " AND xMeeting = :meeting"; } else { $and_meeting = ""; } if ($event != 0) { $and_event = " AND xSerie = :serie"; } else { $and_event = ""; } $sql_get = "SELECT disziplin.Name AS disc_name\r\n , disziplin.Typ AS disc_type\r\n , kategorie.Kurzname AS cat_name\r\n , rundentyp.Typ AS round_type\r\n , rundentyp.Wertung AS round_wertung\r\n , IF(rundentyp.Typ!='0',rundentyp.Name,'') AS round_name\r\n , serie.Bezeichnung AS serie_bez\r\n , TIME_FORMAT(runde.Startzeit, '%H:%i') AS round_start_time\r\n , TIME_FORMAT(runde.Stellzeit, '%H:%i') AS round_call_time\r\n , DATE_FORMAT(runde.Datum, '%d.%m.%y') AS round_start_date\r\n , runde.Status AS round_status\r\n , runde.Versuche AS round_attempts\r\n , runde.Endkampf AS round_final\r\n , runde.Finalisten AS round_finalists\r\n , runde.FinalNach AS round_final_after\r\n , runde.Drehen AS round_drop\r\n , wettkampf.Windmessung AS event_wind\r\n , serie.xSerie AS xSerie\r\n , runde.xRunde AS xRunde\r\n , wettkampf.xWettkampf AS xWettkampf\r\n , disziplin.xDisziplin AS xDisziplin\r\n , kategorie.xKategorie AS xKategorie\r\n , rundentyp.xRundentyp AS xRundentyp\r\n FROM serie\r\n LEFT JOIN runde USING(xRunde)\r\n LEFT JOIN wettkampf USING(xWettkampf)\r\n LEFT JOIN disziplin_" . strtolower(CFG_CURRENT_LANGUAGE) . " AS disziplin USING(xDisziplin)\r\n LEFT JOIN kategorie USING(xKategorie)\r\n LEFT JOIN rundentyp_" . strtolower(CFG_CURRENT_LANGUAGE) . " AS rundentyp USING (xRundentyp)\r\n WHERE runde.Status IN (" . implode(',', $glb_status_results) . ")\r\n AND disziplin.Typ IN (" . implode(',', array_keys($glb_types_results)) . ")\r\n " . $and_meeting . "\r\n " . $and_event . "\r\n ORDER BY \r\n Startzeit\r\n , disc_name;"; $query_get = $glb_connection_server->prepare($sql_get); // +++ bind parameters if ($meeting != 0) { $query_get->bindValue(':meeting', $meeting); } if ($event != 0) { $query_get->bindValue(':serie', $event); } // --- bind parameters $query_get->execute(); if ($event != 0) { $events = $query_get->fetch(PDO::FETCH_ASSOC); define('CFG_CURRENT_WIND', $events['event_wind']); $merged = getMergedRounds($events['xRunde']); if ($merged) { $where = "WHERE xRunde IN " . $merged; $categories = getMergedCategories($merged); $cat_string = ""; $tmp = ""; foreach ($categories as $cat) { $cat_string .= $tmp . $cat['cat_name']; $tmp = "/"; } $events['cat_name'] = $cat_string; } 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', $glb_status_live); if (!$merged) { $query_status->bindValue(':runde', $events['xRunde']); } // --- bind parameters $query_status->execute(); } else { $events = $query_get->fetchAll(PDO::FETCH_ASSOC); } } catch (PDOException $e) { trigger_error($e->getMessage()); } return $events; }