function roundCellName($roundId) { $round = getRound($roundId); return $round['cellName']; }
function createResultTable($event) { global $glb_connection, $glb_connection_server; global $glb_results_skip; try { $settings = getTechSettings($event); $round = getRound($event); $sql_drop = "DROP TABLE IF EXISTS tempresult"; $query_drop = $glb_connection->prepare($sql_drop); $query_drop->execute(); $sql_tmp = "CREATE TABLE tempresult (\r\n xSerienstart int(11)\r\n , xSerie int(11)\r\n , skip tinyint(2)"; for ($i = 1; $i <= $settings['round_attempts']; $i++) { $sql_tmp = $sql_tmp . ", Res" . $i . " int(9) default '0'"; $sql_tmp = $sql_tmp . ", Wind" . $i . " char(5) default '0'"; } $sql_tmp = $sql_tmp . ")"; $query_tmp = $glb_connection->prepare($sql_tmp); $query_tmp->execute(); $sql_ath = "SELECT xSerienstart\r\n , xSerie\r\n , IF((SELECT COUNT(*) FROM resultat WHERE xSerienstart = serienstart.xSerienstart AND Leistung IN (" . implode(',', $glb_results_skip) . ")), 1, 0) AS skip\r\n FROM serienstart\r\n LEFT JOIN serie USING(xSerie)\r\n WHERE xRunde = :runde ;"; $query_ath = $glb_connection_server->prepare($sql_ath); $query_ath->bindValue(':runde', $round); $query_ath->execute(); $athletes = $query_ath->fetchAll(PDO::FETCH_ASSOC); foreach ($athletes as $athlete) { $xSerienstart = $athlete['xSerienstart']; $xSerie = $athlete['xSerie']; $skip = $athlete['skip']; $sql_insert = "INSERT INTO tempresult (xSerienstart, xSerie, skip) VALUES({$xSerienstart},{$xSerie}, {$skip})"; $query_insert = $glb_connection->prepare($sql_insert); $query_insert->execute(); $sql_res = "SELECT Leistung AS ath_res\r\n , Info AS ath_wind\r\n FROM resultat\r\n WHERE xSerienstart = :serienstart\r\n ORDER BY xSerienstart\r\n , Leistung DESC;"; $query_res = $glb_connection_server->prepare($sql_res); $query_res->bindValue(':serienstart', $athlete['xSerienstart']); $query_res->execute(); $results = $query_res->fetchAll(PDO::FETCH_ASSOC); $n = 1; foreach ($results as $result) { $sql_update = "UPDATE tempresult \r\n SET Res" . $n . "=:result\r\n , Wind" . $n . "=:wind\r\n WHERE xSerienstart = :serienstart;"; $query_update = $glb_connection->prepare($sql_update); $query_update->bindValue(':result', $result['ath_res']); $query_update->bindValue(':wind', $result['ath_wind']); $query_update->bindValue(':serienstart', $athlete['xSerienstart']); $query_update->execute(); $n++; } } } catch (PDOException $e) { trigger_error($e->getMessage()); } }
function createResultTable($event) { global $glb_connection, $glb_connection_server; global $glb_results_skip; global $glb_high_attempt_passed, $glb_high_attempt_failed, $glb_high_attempt_waived; try { $settings = getHighSettings($event); $round = getRound($event); $sql_drop = "DROP TABLE IF EXISTS tempresult"; $query_drop = $glb_connection->prepare($sql_drop); $query_drop->execute(); $sql_tmp = "CREATE TABLE tempresult (\r\n xSerienstart int(11)\r\n , xSerie int(11)\r\n , position int(11)\r\n , skip tinyint(2)\r\n , result int(11)\r\n , result_attempts int(11)\r\n , miss int(11)\r\n , ath_out int(11)\r\n , curr_height int(11)\r\n , curr_miss int(11));"; $query_tmp = $glb_connection->prepare($sql_tmp); $query_tmp->execute(); $sql_ath = "SELECT xSerienstart AS ath_id\r\n , xSerie\r\n , IF((SELECT COUNT(*) FROM resultat WHERE xSerienstart = serienstart.xSerienstart AND Leistung IN (" . implode(',', $glb_results_skip) . ")), 1, 0) AS skip\r\n , Starthoehe AS ath_start\r\n , Position AS ath_pos\r\n FROM serienstart\r\n LEFT JOIN serie USING(xSerie)\r\n WHERE xRunde = :runde;"; $query_ath = $glb_connection_server->prepare($sql_ath); $query_ath->bindValue(':runde', $round); $query_ath->execute(); $athletes = $query_ath->fetchAll(PDO::FETCH_ASSOC); foreach ($athletes as $athlete) { $xSerienstart = $athlete['ath_id']; $position = $athlete['ath_pos']; $xSerie = $athlete['xSerie']; $skip = $athlete['skip']; $sql_res = "SELECT \r\n xSerienstart\r\n , Leistung AS result_max\r\n , Info AS result_info\r\n FROM\r\n resultat \r\n LEFT JOIN serienstart USING (xSerienstart) \r\n WHERE xSerienstart = :serienstart \r\n AND Info LIKE '%" . $glb_high_attempt_passed . "%'\r\n ORDER BY Leistung DESC\r\n LIMIT 1;"; $query_res = $glb_connection_server->prepare($sql_res); $query_res->bindValue(':serienstart', $xSerienstart); $query_res->execute(); $result = $query_res->fetch(PDO::FETCH_ASSOC); $result_res = $result['result_max'] ? $result['result_max'] : 0; $res_attempts = substr_count($result['result_info'], $glb_high_attempt_failed) + 1; $sql_miss = "SELECT \r\n xSerienstart\r\n , Leistung AS result\r\n , Info AS result_info\r\n FROM\r\n resultat \r\n LEFT JOIN serienstart USING (xSerienstart) \r\n WHERE xSerienstart = :serienstart \r\n AND Info LIKE '%" . $glb_high_attempt_failed . "%';"; $query_miss = $glb_connection_server->prepare($sql_miss); $query_miss->bindValue(':serienstart', $xSerienstart); $query_miss->execute(); $results_miss = $query_miss->fetchAll(PDO::FETCH_ASSOC); $miss = 0; foreach ($results_miss as $result_miss) { $miss = $miss + substr_count($result_miss['result_info'], $glb_high_attempt_failed); } $sql_heights = "SELECT serie\r\n , height\r\n FROM t_heights\r\n WHERE serie = :serie\r\n ORDER BY height ASC;"; $query_heights = $glb_connection->prepare($sql_heights); $query_heights->bindValue(':serie', $xSerie); $query_heights->execute(); $heights = $query_heights->fetchAll(PDO::FETCH_ASSOC); $sql_maxHeight = "SELECT MAX(height) as max_height\r\n FROM t_heights\r\n WHERE serie = :serie\r\n ORDER BY height ASC;"; $query_maxHeight = $glb_connection->prepare($sql_maxHeight); $query_maxHeight->bindValue(':serie', $xSerie); $query_maxHeight->execute(); $maxHeight = $query_maxHeight->fetch(PDO::FETCH_ASSOC); $maxHeight = $maxHeight['max_height']; $diff = $maxHeight < $settings['diff_1_until'] ? $settings['diff_1_value'] : $settings['diff_2_value']; $curr_height = $maxHeight + $diff; $curr_miss = 0; $out = checkOut($athlete['ath_id']); if ($out) { $curr_height = 0; $curr_miss = 0; } else { foreach ($heights as $height) { if ($height['height'] >= $athlete['ath_start']) { $sql_check = "SELECT Info\r\n FROM resultat\r\n WHERE Leistung = :height\r\n AND xSerienstart = :serienstart;"; $query_check = $glb_connection_server->prepare($sql_check); $query_check->bindValue(':height', $height['height']); $query_check->bindValue(':serienstart', $athlete['ath_id']); $query_check->execute(); if ($query_check->rowCount() == 0) { $curr_height = $height['height']; $curr_miss = 0; break; } else { $check = $query_check->fetch(PDO::FETCH_ASSOC); $check_miss = substr_count($check['Info'], $glb_high_attempt_failed); $check_skip = substr_count($check['Info'], $glb_high_attempt_passed) + substr_count($check['Info'], $glb_high_attempt_waived); if ($check_miss > 0 && $check_skip == 0) { $curr_height = $height['height']; $curr_miss = $check_miss; break; } } } } } $sql_insert = "INSERT INTO tempresult (xSerienstart, xSerie, position, skip, result, result_attempts, miss, ath_out, curr_height, curr_miss) VALUES(:serienstart, :serie, :position, :skip, :result, :res_attempts, :miss, :out, :curr_height, :curr_miss)"; $query_insert = $glb_connection->prepare($sql_insert); $query_insert->bindValue(':serienstart', $xSerienstart); $query_insert->bindValue(':serie', $xSerie); $query_insert->bindValue(':position', $position); $query_insert->bindValue(':skip', $skip); $query_insert->bindValue(':result', $result_res); $query_insert->bindValue(':res_attempts', $res_attempts); $query_insert->bindValue(':miss', $miss); $query_insert->bindValue(':out', $out); $query_insert->bindValue(':curr_height', $curr_height); $query_insert->bindValue(':curr_miss', $curr_miss); $query_insert->execute(); } } catch (PDOException $e) { trigger_error($e->getMessage()); } }
/** * @package:SMS * @helper::getGpa(). * @Author:Techno Services */ function getGpa($total_marks = array(), $total_credit = array()) { $gpa = ''; if (isArray($total_credit) && (isset($total_credit[0]) && $total_credit[0] > 0)) { $gpa = getRound(getArraySum($total_marks) / getArraySum($total_credit), 2); } return $gpa; }