<?php
define('GLOBAL_PATH', '../../../../');
define('ROOT_PATH', '../../../');
define('CURRENT_CATEGORY', 'athletica_tech');
define('CURRENT_PAGE', 'results');
require_once ROOT_PATH . 'lib/inc.init.php';
require_once ROOT_PATH . 'lib/cls.result_high.php';
$serie = $_POST['serie'];
$height = $_POST['height'];
$height = formatResultDB($height);
$height_out = insertHeight($height, CFG_CURRENT_EVENT);
createHeightTable(CFG_CURRENT_EVENT);
createResultTable(CFG_CURRENT_EVENT);
echo $height_out;
define('GLOBAL_PATH', '../../../../');
define('ROOT_PATH', '../../../');
define('CURRENT_CATEGORY', 'athletica_tech');
define('CURRENT_PAGE', 'results');
require_once ROOT_PATH . 'lib/inc.init.php';
require_once ROOT_PATH . 'lib/cls.result_tech.php';
$return = "error";
$ath_res = $_POST['ath_res'];
$ath_wind = $_POST['ath_wind'];
$ath_id = $_POST['ath_id'];
$res_id = $_POST['res_id'];
$round = $_POST['round'];
$event = $_POST['event'];
$attempt = $_POST['attempt'];
$ath_res_db = formatResultDB($ath_res);
$ath_wind_db = formatWindDB($ath_res, $ath_wind);
if ($ath_res_db == 'error') {
$return = 'result';
} else {
try {
$sql_sex = "SELECT Geschlecht \r\n FROM kategorie \r\n LEFT JOIN wettkampf USING(xKategorie) \r\n LEFT JOIN start USING(xWettkampf) \r\n LEFT JOIN serienstart USING(xStart) \r\n WHERE xSerienstart = :ath_id;";
$query_sex = $glb_connection_server->prepare($sql_sex);
$query_sex->bindValue(':ath_id', $ath_id);
$query_sex->execute();
$sex = $query_sex->fetch(PDO::FETCH_ASSOC);
$sex = $sex['Geschlecht'];
$points = calcPoints($event, $ath_res_db, $fraction = 0, $sex, $ath_id);
$res_id_sql = !is_null($res_id) ? "xResultat = :res_id, " : "";
$sql = "INSERT INTO resultat\r\n SET " . $res_id_sql . "\r\n Leistung = :ath_res\r\n , Info = :ath_wind\r\n , Punkte = :ath_pts\r\n , xSerienstart = :ath_id\r\n ON DUPLICATE KEY UPDATE\r\n Leistung = :ath_res\r\n , Info = :ath_wind\r\n , Punkte = :ath_pts\r\n , xSerienstart = :ath_id\r\n ;";
$query = $glb_connection_server->prepare($sql);
