fetchAll() as $row) {
if ($row['gewertet'] == '1') {
$checked = "Ja";
} else {
$checked = "Nein";
}
if ($row['direkte_punkte'] == '1') {
$direkte_punkte = "Ja";
} else {
$direkte_punkte = "Nein";
}
echo "";
echo "| " . $row['name'] . " | ";
echo "" . $row['standort'] . " | ";
echo "". $checked . " | ";
echo "" . $direkte_punkte . " | ";
echo "
";
}
}
function load_teams_table($con) {
$stmt = get_teams($con);
foreach($stmt->fetchAll() as $row) {
echo "";
echo "| " . $row['name'] . " | ";
echo "" . $row['feuerwehr'] . " | ";
echo "
";
}
}
function load_total_score($con) {
echo " \n
Mannschaft | \n
Feuerwehr | \n
Gesamtpunkte | \n
\n
\n";
$stmt = get_total_score($con);
foreach($stmt->fetchAll() as $row) {
echo "\n";
echo "| " . $row['Mannschaftsname'] . " | \n";
echo "" . $row['Feuerwehr'] . " | \n";
echo "" . $row['Gesamtpunkte'] . " | \n";
echo "
\n";
}
echo "\n";
}
function load_station_ranking($con) {
echo " \n
Station | \n
Gesamtpunkte | \n
\n
\n";
$stmt = get_station_ranking($con);
foreach($stmt->fetchAll() as $row) {
echo "\n";
echo "| " . $row['Stationsname'] . " | \n";
echo "" . $row['Gesamtpunkte'] . " | \n";
echo "
\n";
}
echo "\n";
}
function load_options_stations($con, $session, $stats) {
$stmt = get_stations_all($con);
if ($session == "total-score"){
$total_score_selected = " selected";
} else {
$total_score_selected = "";
}
if($stats) {
echo "";
}
foreach($stmt->fetchAll() as $option) {
if($session == $option['s_id']){
$station_selected = " selected";
} else {
$station_selected = "";
}
echo "";
}
}
function load_station_table($con, $s_id) {
echo " \n
Mannschaft |
Feuerwehr |
Punkte |
Zeit |
\n";
$stmt = get_station($con, $s_id);
foreach($stmt->fetchAll() as $row) {
echo "\n";
echo "| " . $row['Name'] . " | \n";
echo "" . $row['Feuerwehr'] . " | \n";
echo "" . $row['Punkte'] . " | \n";
if ($row['Zeit'] != NULL) {
$time = get_time_str($con, $row['m_id'], $s_id);
echo "" . $time . " | \n";
} else {
echo "" . $row['Zeit'] . " | \n";
}
echo "
\n";
}
echo "\n";
}
function load_teams_no_points($con, $s_id) {
if (station_exists($con, $s_id)) {
$stmt = get_teams_no_points($con, $s_id);
foreach($stmt->fetchAll() as $option) {
echo "";
}
}
}
function load_fire_departments($con) {
$stmt = get_fire_departments($con);
foreach($stmt->fetchAll() as $option) {
echo "\n";
}
}
function check_admin($con) {
$user_data = check_login($con);
if($user_data['user_group'] == "admin") {
return $user_data;
} else {
unset($_SESSION['user_id']);
unset($_SESSION['user_group']);
header("Location: login.php");
die;
}
}
function load_users($con) {
$stmt = get_users($con);
foreach($stmt->fetchAll() as $row) {
echo "\n";
echo "| " . $row['user_name'] . " | \n";
echo "" . $row['user_group'] . " | \n";
echo "";
if ($row['s_id'] != NULL) {
echo get_station_all($con, $row['s_id'])->fetch()['name'];
} else {
echo $row['s_id'];
}
echo " | \n";
echo "
\n";
}
}
function check_time($con, $m_id, $s_id) {
$stmt = get_time($con, $m_id, $s_id);
if (($stmt->fetch()) == NULL) {
return false;
} else {
return true;
}
}
function get_time_str($con, $m_id, $s_id) {
$minutes = get_minutes($con, $m_id, $s_id)->fetch()['minutes'];
$seconds = get_seconds($con, $m_id, $s_id)->fetch()['seconds'];
$millis = get_millis($con, $m_id, $s_id)->fetch()['millis'];
if ($minutes < 10) {
$time = "0" . $minutes;
} else {
$time = $minutes;
}
if ($seconds < 10) {
$time .= ":0" . $seconds;
} else {
$time .= ":" . $seconds;
}
$millis /= 10000;
if ($millis < 10) {
$time .= ".0" . $millis;
} else {
$time .= "." . $millis;
}
return $time;
}
function sanitize_input ($input) {
$return = strip_tags($input);
return htmlspecialchars($return, ENT_QUOTES);
}
function update_points($con, $s_id) {
$results = get_results($con, $s_id)->fetchAll();
$factor = $results[0]['erg']/ 15.0;
foreach($results as $row) {
$points = round($row['erg']/$factor);
if ($points == 0 && $row['erg'] != 0) {
$points = 1;
}
change_points($con, $row['m_id'], $s_id, $points);
}
}
function write_result($con, $s_id, $m_id, $result) {
write_result_db($con, $s_id, $m_id, $result);
write_points($con, $s_id, $m_id, 0, null);
update_points($con, $s_id);
}
function update_result($con, $s_id, $m_id, $result) {
update_result_db($con, $s_id, $m_id, $result);
update_points($con, $s_id);
}