function process()
{
require './lib/common.lib.php';
require './lib/utils.lib.php';
// get program mode
$prog_mode = AA_results_getProgramMode();
if ($prog_mode == 2) {
$sql = "SELECT \r\n ss.xSerienstart,\r\n ss.Position,\r\n MAX(ss.Position2), \r\n MAX(ss.Position3),\r\n s.MaxAthlet,\r\n count(*)\r\n FROM \r\n runde AS r\r\n LEFT JOIN serie AS s ON (s.xRunde = r.xRunde)\r\n LEFT JOIN serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n WHERE \r\n r.xRunde = " . $_POST['round'] . "\r\n GROUP BY s.xSerie";
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
$maxPos2 = $row[2];
$maxPos3 = $row[3];
$maxAthlete = $row[4];
$countAthlete = $row[5];
}
global $cfgMaxAthlete, $cfgAfterAttempts1, $cfgAfterAttempts2;
// track disciplines, with or without wind
if ($this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeNone']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrack']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrackNoWind']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeDistance']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeRelay']]) {
$result = new TrackResult($_POST['round'], $_POST['start'], $_POST['item']);
// if this is a track (wind / nowind) format results in seconds e.g. 80,123 secs
if ($this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrack']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrackNoWind']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeRelay']]) {
$this->reply = $result->save($_POST['perf'], '', true, $_POST['remark'], $_POST['xAthlete']);
} else {
$this->reply = $result->save($_POST['perf'], '', '', $_POST['remark'], $_POST['xAthlete']);
}
if (!empty($GLOBALS['AA_ERROR'])) {
return;
}
if ($_POST['perf'] == '') {
$txt = '';
} else {
$txt = AA_formatResultTime($this->reply->getPerformance());
}
} else {
if ($this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeJump']]) {
$result = new TechResult($_POST['round'], $_POST['start'], $_POST['item']);
$this->reply = $result->save($_POST['perf'], $_POST['wind'], '', $_POST['remark'], $_POST['xAthlete'], $_POST['row_col'], $_POST['maxatt']);
if ($prog_mode == 2) {
$arrfield_nr = explode('_', $this->reply->getRowCol());
$current_col = $arrfield_nr[1];
$current_field_nr = $arrfield_nr[0];
$maxatt = $this->reply->getMaxatt();
$field_nr_pass2 = ($maxatt + 1) * ($countAthlete - 1) + $cfgAfterAttempts1;
$field_nr_pass3 = ($maxatt + 1) * ($maxAthlete - 1) + $cfgAfterAttempts2;
switch ($current_col) {
case 1:
case 2:
case 3:
if ($current_field_nr == $field_nr_pass2) {
$this->reply->setPass(2);
} else {
$this->reply->setPass(0);
}
break;
case 4:
case 5:
if ($current_field_nr == $field_nr_pass3) {
$this->reply->setPass(3);
} else {
$this->reply->setPass(2);
}
break;
case 6:
default:
$this->reply->setPass(3);
break;
}
if ($maxPos2 > 0 && $maxPos3 == 0 && $current_col <= 3) {
if ($_POST['perf'] == '') {
// reset position 2
AA_resetPos($_POST['heat'], 2);
$this->reply->setPass(0);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
} else {
$this->reply->setPass(2);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
}
} elseif ($maxPos3 > 0 && $current_col >= 4 && $current_col < 6) {
if ($_POST['perf'] == '') {
// reset position 3
AA_resetPos($_POST['heat'], 3);
$this->reply->setPass(2);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
} else {
$this->reply->setPass(3);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
}
} elseif ($maxPos3 > 0 && $current_col <= 3) {
$this->reply->setPass(2);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
$this->reply->setPass(3);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
} elseif ($current_field_nr == $field_nr_pass2 || $current_field_nr == $field_nr_pass3) {
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
}
}
if (!empty($GLOBALS['AA_ERROR'])) {
return;
}
$txt = AA_formatResultMeter($this->reply->getPerformance()) . ", " . $this->reply->getInfo();
} else {
if ($this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeJumpNoWind']] || $this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeThrow']]) {
$result = new TechResult($_POST['round'], $_POST['start'], $_POST['item']);
$this->reply = $result->save($_POST['perf'], '', '', $_POST['remark'], $_POST['xAthlete'], $_POST['row_col'], $_POST['maxatt']);
if ($prog_mode == 2) {
$arrfield_nr = explode('_', $this->reply->getRowCol());
$current_col = $arrfield_nr[1];
$current_field_nr = $arrfield_nr[0];
$maxatt = $this->reply->getMaxatt();
$field_nr_pass2 = ($maxatt + 1) * ($countAthlete - 1) + $cfgAfterAttempts1;
$field_nr_pass3 = ($maxatt + 1) * ($maxAthlete - 1) + $cfgAfterAttempts2;
switch ($current_col) {
case 1:
case 2:
case 3:
if ($current_field_nr == $field_nr_pass2) {
$this->reply->setPass(2);
} else {
$this->reply->setPass(0);
}
break;
case 4:
case 5:
if ($current_field_nr == $field_nr_pass3) {
$this->reply->setPass(3);
} else {
$this->reply->setPass(2);
}
break;
case 6:
default:
$this->reply->setPass(3);
break;
}
if ($maxPos2 > 0 && $maxPos3 == 0 && $current_col <= 3) {
if ($_POST['perf'] == '') {
// reset position 2
AA_resetPos($_POST['heat'], 2);
$this->reply->setPass(0);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
} else {
$this->reply->setPass(2);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
}
} elseif ($maxPos3 > 0 && $current_col >= 4 && $current_col < 6) {
if ($_POST['perf'] == '') {
// reset position 3
AA_resetPos($_POST['heat'], 3);
$this->reply->setPass(2);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
} else {
$this->reply->setPass(3);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
}
} elseif ($maxPos3 > 0 && $current_col <= 3) {
$this->reply->setPass(2);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
$this->reply->setPass(3);
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
} elseif ($current_field_nr == $field_nr_pass2 || $current_field_nr == $field_nr_pass3) {
AA_rankingForNewPosition($_POST['round'], $this->reply->getPass());
AA_newPosition($_POST['round'], $this->reply->getPass());
}
}
if (!empty($GLOBALS['AA_ERROR'])) {
return;
}
if ($this->reply->getPerformance() == '') {
$txt = '';
} else {
$txt = AA_formatResultMeter($this->reply->getPerformance());
}
} else {
if ($this->type == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeHigh']]) {
$result = new HighResult($_POST['round'], $_POST['start'], $_POST['item']);
$this->reply = $result->save($_POST['perf']);
$this->reply = $result->save($_POST['perf'], $_POST['attempts']);
if (!empty($GLOBALS['AA_ERROR'])) {
return;
}
$txt = AA_formatResultMeter($this->reply->getPerformance()) . " [ " . $this->reply->getInfo() . " ]";
}
}
}
}
switch ($this->reply->getAction()) {
case RES_ACT_INSERT:
$msg = $GLOBALS['strOKInsert'] . ": {$txt} (xStart=" . $_POST['start'] . ")";
break;
case RES_ACT_UPDATE:
$msg = $GLOBALS['strOKUpdate'] . ": {$txt} (xResultat=" . $this->reply->getKey() . ")";
break;
case RES_ACT_DELETE:
$msg = $GLOBALS['strOKDelete'] . " (xResultat=" . $this->reply->getKey() . ")";
break;
default:
$msg = "";
}
$this->ok_out['msg'] = $msg;
}
function AA_results_Tech($round, $layout)
{
require './lib/cl_gui_button.lib.php';
require './config.inc.php';
require './lib/common.lib.php';
require './lib/heats.lib.php';
require './lib/results.lib.php';
require './lib/utils.lib.php';
require './lib/cl_wind.lib.php';
$presets = AA_results_getPresets($round);
// read GET/POST variables
$nextRound = AA_getNextRound($presets['event'], $round);
$svm = AA_checkSVM(0, $round);
// decide whether to show club or team name
$prog_mode = AA_results_getProgramMode();
//
// terminate result processing
//
if ($_GET['arg'] == 'results_done' || $prog_mode == 2 && $_GET['arg'] != 'change_results' && $_GET['arg'] != 'del_results') {
$eval = AA_results_getEvaluationType($round);
$combined = AA_checkCombined(0, $round);
mysql_query("LOCK TABLES r READ, s READ, ss READ, runde READ");
// if this is a combined event, rank all rounds togheter
$roundSQL = "";
$roundSQL2 = "";
if ($combined) {
$roundSQL = " s.xRunde IN (";
$roundSQL2 = " s.xRunde IN (";
$res_c = mysql_query("SELECT xRunde FROM runde WHERE xWettkampf = " . $presets['event']);
while ($row_c = mysql_fetch_array($res_c)) {
$roundSQL .= $row_c[0] . ",";
$roundSQL2 .= $row_c[0] . ",";
}
$roundSQL = substr($roundSQL, 0, -1) . ")";
$roundSQL2 = substr($roundSQL2, 0, -1) . ")";
} else {
$roundSQL = " s.xRunde = {$round}";
$roundSQL2 = " s.xRunde = {$round}";
}
// number of athletes
$sql = "SELECT \r\n ss.xSerienstart \r\n FROM \r\n runde AS r\r\n LEFT JOIN serie AS s ON (s.xRunde = r.xRunde)\r\n LEFT JOIN serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n LEFT JOIN start AS st ON (st.xStart = ss.xStart)\r\n LEFT JOIN anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n LEFT JOIN athlet AS at ON (at.xAthlet = a.xAthlet)\r\n WHERE r.xRunde = " . $round . "\r\n ";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$count_athlete = mysql_num_rows($res);
}
// evaluate max. nbr of results entered
$r = 0;
if ($prog_mode == 2) {
// create array for calculate field focus
$sql_r = "SELECT \r\n ru.Versuche, \r\n LPAD(s.Bezeichnung,5,'0') as heatid, \r\n if (ss.Position2 > 0, if (ss.Position3 > 0, ss.Position3, ss.Position2) , ss.Position ) as posOrder \r\n , ss.Position\r\n , ss.Position2\r\n , ss.Position3 \r\n , ss.xSerienstart\r\n , ss.Rang\r\n , s.MaxAthlet\r\n , s.xSerie \r\n , r.Leistung \r\n FROM \r\n resultat AS r\r\n LEFT JOIN serienstart AS ss ON (r.xSerienstart = ss.xSerienstart)\r\n LEFT JOIN serie AS s ON (ss.xSerie = s.xSerie )\r\n LEFT JOIN runde AS ru ON (s.xRunde = ru.xRunde) \r\n WHERE " . $roundSQL2 . " \r\n ORDER BY posOrder, r.xResultat ";
$result_r = mysql_query($sql_r);
$heatStart = '';
$arr_perfAthlete = array();
$arr_perfAthleteValids = array();
$c = 0;
$h = 0;
$pos2 = 0;
// calculate attempts of athletes
while ($row_r = mysql_fetch_row($result_r)) {
if ($heatStart != $row_r[6]) {
// new heat start
if (!empty($heatStart)) {
$arr_perfAthlete[$h] = $c;
if ($c > 0) {
$arr_perfAthleteValids[$h] = $c;
}
$h++;
if ($h >= $row_r[8] && $row_r[4] > 0) {
// maxAthlete reached by second/third Position
break;
}
}
$c = 0;
if ($row_r[10] > 0 || $row_r[10] < $cfgInvalidResult['DSQ']['code']) {
$c++;
} elseif ($row_r[10] == $cfgInvalidResult['DNS']['code']) {
$c = $cfgInvalidResult['DNS']['code'];
} elseif ($row_r[10] == $cfgInvalidResult['DNF']['code']) {
$c = $cfgInvalidResult['DNF']['code'];
} elseif ($row_r[10] == $cfgInvalidResult['DSQ']['code']) {
$c = $cfgInvalidResult['DSQ']['code'];
}
} else {
if ($row_r[10] > 0 || $row_r[10] < $cfgInvalidResult['DSQ']['code']) {
$c++;
} elseif ($row_r[10] == $cfgInvalidResult['DNS']['code']) {
$c = $cfgInvalidResult['DNS']['code'];
} elseif ($row_r[10] == $cfgInvalidResult['DNF']['code']) {
$c = $cfgInvalidResult['DNF']['code'];
} elseif ($row_r[10] == $cfgInvalidResult['DSQ']['code']) {
$c = $cfgInvalidResult['DSQ']['code'];
}
}
$heatStart = $row_r[6];
$maxAthlete = $row_r[8];
$pos2 = $row_r[4];
}
// last athlete
if ($h >= $maxAthlete && $pos2 > 0) {
} else {
$arr_perfAthlete[$h] = $c;
if ($c > 0) {
$arr_perfAthleteValids[$h] = $c;
}
}
$p1 = 0;
$p2 = 0;
//calculate doing new position
foreach ($arr_perfAthlete as $key => $val) {
if ($val == 3 || $val < 0) {
$p1++;
} elseif ($val == 5 || $val < 0) {
$p2++;
}
}
if (count($arr_perfAthlete) == $p1) {
AA_rankingForNewPosition($round, 2);
AA_newPosition($round, 2);
} elseif (count($arr_perfAthlete) == $p2) {
AA_rankingForNewPosition($round, 3);
AA_newPosition($round, 3);
}
$sql = "SELECT \r\n COUNT(*), \r\n ru.Versuche, \r\n LPAD(s.Bezeichnung,5,'0') as heatid, \r\n if (ss.Position2 > 0, if (ss.Position3 > 0, ss.Position3, ss.Position2) , ss.Position ) as posOrder \r\n , ss.Position\r\n , ss.Position2\r\n , ss.Position3 \r\n , ss.xSerienstart\r\n , ss.Rang\r\n , s.MaxAthlet\r\n , s.xSerie \r\n , r.Leistung\r\n \r\n FROM \r\n resultat AS r\r\n LEFT JOIN serienstart AS ss ON (r.xSerienstart = ss.xSerienstart)\r\n LEFT JOIN serie AS s ON (ss.xSerie = s.xSerie )\r\n LEFT JOIN runde AS ru ON (s.xRunde = ru.xRunde) \r\n WHERE " . $roundSQL2 . " \r\n GROUP BY r.xSerienstart\r\n ORDER BY posOrder ";
$result = mysql_query($sql);
} else {
$result = mysql_query("SELECT COUNT(*), ru.Versuche" . " FROM resultat AS r" . " LEFT JOIN serienstart AS ss ON (r.xSerienstart = ss.xSerienstart)" . " LEFT JOIN serie AS s ON (ss.xSerie = s.xSerie)" . " LEFT JOIN runde AS ru ON (s.xRunde = ru.xRunde)" . " WHERE " . " {$roundSQL2} " . " GROUP BY r.xSerienstart" . " ORDER BY 1 DESC");
}
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if ($prog_mode == 2) {
// decentral with ranking
$z = 0;
$pass = 0;
$arr_attAthlete = array();
$maxAthlete = 0;
while ($row = mysql_fetch_row($result)) {
if ($z == 0) {
// first row
$maxatt = $row[1];
$maxAthlete = $row[9];
$xSerie = $row[10];
}
if ($row[11] != $cfgInvalidResult['DNS']['code']) {
$arr_attAthlete[] = $row[0];
}
$keep_rank = $row[8];
$z++;
}
if ($count_athlete < $maxAthlete) {
$maxAthlete = $count_athlete;
// update max athlete in serie
AA_setMaxAthlete($xSerie, $maxAthlete);
}
$maxAthleteAtt = max($arr_attAthlete);
$minAthleteAtt = min($arr_attAthlete);
$onlyMaxAthlete = false;
if ($count_athlete > $cfgMaxAthlete) {
if ($maxAthleteAtt == $minAthleteAtt && $minAthleteAtt == $cfgAfterAttempts1) {
$onlyMaxAthlete = true;
} elseif ($maxAthleteAtt > $cfgAfterAttempts1) {
$onlyMaxAthlete = true;
}
}
if ($onlyMaxAthlete && $count_athlete > $cfgMaxAthlete) {
$c = 0;
$arr_attAthlete_new = array();
foreach ($arr_attAthlete as $key => $val) {
$c++;
$arr_attAthlete_new[] = $val;
if ($c >= $maxAthlete) {
break;
}
}
$arr_attAthlete = $arr_attAthlete_new;
$maxAthleteAtt = max($arr_attAthlete);
$minAthleteAtt = min($arr_attAthlete);
}
$r = $maxAthleteAtt;
$first_row = false;
$maxAthleteAtt = max($arr_perfAthleteValids);
$minAthleteAtt = min($arr_perfAthleteValids);
if ($maxAthleteAtt == $cfgAfterAttempts1 && $maxAthleteAtt == $minAthleteAtt) {
$pass = 2;
} elseif ($maxAthleteAtt == $cfgAfterAttempts2 && $maxAthleteAtt == $minAthleteAtt) {
$pass = 3;
} elseif ($maxAthleteAtt > $cfgAfterAttempts1 && $maxAthleteAtt < $cfgAfterAttempts2 + 1) {
$pass = 2;
} elseif ($maxAthleteAtt == $cfgAfterAttempts2 + 1) {
$pass = 3;
} elseif ($maxAthleteAtt == $minAthleteAtt && $z == $count_athlete) {
$first_row = true;
$maxAthleteAtt++;
}
$fieldFocus = 1;
} else {
$row = mysql_fetch_row($result);
$r = $row[0];
}
mysql_free_result($result);
}
$minPerfAthl = min($arr_perfAthleteValids);
$maxPerfAthl = max($arr_perfAthleteValids);
$keep_val = '';
$keep_key = '';
foreach ($arr_perfAthlete as $key => $val) {
if (empty($keep_val) && !empty($val)) {
$fieldFocus = $maxatt + 1 + $maxPerfAthl;
}
$keep_key = $key;
if ($keep_val > $val) {
if ($val == $cfgInvalidResult['DNS']['code'] || $val == $cfgInvalidResult['DNF']['code'] || $val == $cfgInvalidResult['DSQ']['code']) {
continue;
}
$fieldFocus = $key * ($maxatt + 1) + $maxPerfAthl;
break;
}
$keep_val = $val;
}
if ($pos2 == 0) {
if ($count_athlete > count($arr_perfAthlete)) {
$fieldFocus = ($keep_key + 1) * ($maxatt + 1) + $maxPerfAthl;
} elseif ($count_athlete == count($arr_perfAthlete) && $minPerfAthl == $maxPerfAthl) {
$fieldFocus = $maxPerfAthl + 1;
}
} else {
if ($minPerfAthl == $maxPerfAthl) {
$fieldFocus = $maxPerfAthl + 1;
}
}
if ($r > 0) {
mysql_query("DROP TABLE IF EXISTS tempresult");
// temporary table
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
mysql_query("\r\n LOCK TABLES\r\n resultat READ\r\n , serie READ\r\n , wettkampf READ\r\n , serienstart WRITE\r\n , tempresult WRITE\r\n ");
// Set up a temporary table to hold all results for ranking.
// The number of result columns varies according to the maximum
// number of results per athlete.
$qry = "\r\n CREATE TABLE tempresult (\r\n xSerienstart int(11)\r\n , xSerie int(11)";
for ($i = 1; $i <= $r; $i++) {
$qry = $qry . ", Res" . $i . " int(9) default '0'";
$qry = $qry . ", Wind" . $i . " char(5) default '0'";
}
$qry = $qry . ") TYPE=HEAP";
mysql_query($qry);
// create temporary table
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// reset rank to 0 first
$sql = " SELECT\r\n r.Leistung\r\n , r.Info\r\n , ss.xSerienstart\r\n , ss.xSerie\r\n FROM\r\n resultat as r\r\n LEFT JOIN serienstart as ss ON (r.xSerienstart = ss.xSerienstart)\r\n LEFT JOIN serie AS s ON (ss.xSerie = s.xSerie)\r\n WHERE \r\n {$roundSQL}\r\n AND r.Leistung <= 0\r\n ORDER BY\r\n ss.xSerienstart\r\n ,r.Leistung DESC";
$result = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
while ($row = mysql_fetch_row($result)) {
mysql_query("\r\n UPDATE serienstart SET\r\n Rang = 0\r\n WHERE xSerienstart = {$row['2']}\r\n ");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
}
}
$result = mysql_query("\r\n SELECT\r\n r.Leistung\r\n , r.Info\r\n , ss.xSerienstart\r\n , ss.xSerie\r\n FROM\r\n resultat as r\r\n LEFT JOIN serienstart as ss ON (r.xSerienstart = ss.xSerienstart)\r\n LEFT JOIN serie AS s ON (ss.xSerie = s.xSerie)\r\n WHERE \r\n {$roundSQL}\r\n AND r.Leistung >= 0\r\n ORDER BY\r\n ss.xSerienstart\r\n ,r.Leistung DESC\r\n ");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$ss = 0;
$i = 0;
// process every result
while ($row = mysql_fetch_row($result)) {
if ($ss != $row[2]) {
// add one row per athlete to temp table
if ($ss != 0) {
for (; $i < $r; $i++) {
// fill remaining result cols.
$qry = $qry . ",0,''";
}
mysql_query($qry . ")");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
}
// (re)set SQL statement
$qry = "INSERT INTO tempresult VALUES({$row['2']},{$row['3']}";
$i = 0;
}
$qry = $qry . ",{$row['0']},'{$row['1']}'";
// add current result to query
$ss = $row[2];
// keep athlete's ID
$i++;
// count nbr of results
}
mysql_free_result($result);
// insert last pending data in temp table
if ($ss != 0) {
for (; $i < $r; $i++) {
// fill remaining result cols.
$qry = $qry . ",0,''";
}
mysql_query($qry . ")");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
}
}
if ($eval == $cfgEvalType[$strEvalTypeHeat]) {
// eval per heat
$qry = "\r\n SELECT\r\n *\r\n FROM\r\n tempresult\r\n ORDER BY\r\n xSerie";
for ($i = 1; $i <= $r; $i++) {
$qry = $qry . ", Res" . $i . " DESC";
}
} else {
// default: rank results from all heats together
$qry = "\r\n SELECT\r\n *\r\n FROM\r\n tempresult\r\n ORDER BY ";
$comma = "";
// order by available result columns
for ($i = 1; $i <= $r; $i++) {
$qry = $qry . $comma . "Res" . $i . " DESC";
$comma = ", ";
}
}
$result = mysql_query($qry);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$heat = 0;
$perf_old[] = '';
$j = 0;
$rank = 0;
// set rank for every athlete
while ($row = mysql_fetch_row($result)) {
for ($i = 0; $i <= $r; $i++) {
$perf[$i] = $row[2 * $i + 2];
$wind[$i] = $row[2 * $i + 3];
}
if ($eval == $cfgEvalType[$strEvalTypeHeat] && $heat != $row[1]) {
$j = 0;
// restart ranking
$perf_old[] = '';
}
$j++;
// increment ranking
if ($perf_old != $perf) {
// compare performances
$rank = $j;
// next rank (only if not same performance)
}
mysql_query("\r\n UPDATE serienstart SET\r\n Rang = {$rank}\r\n WHERE xSerienstart = {$row['0']}\r\n ");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
$heat = $row[1];
// keep current heat ID
$perf_old = $perf;
}
mysql_free_result($result);
}
mysql_query("DROP TABLE IF EXISTS tempresult");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
}
// ET DB error (create temp table)
mysql_query("UNLOCK TABLES");
}
// ET DB error (drop temp table)
}
// ET any results found
AA_results_setNotStarted($round);
// update athletes with no result
if ($_GET['arg'] == 'results_done') {
AA_utils_changeRoundStatus($round, $cfgRoundStatus['results_done']);
}
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
AA_results_resetQualification($round);
}
//
// calculate ranking points if needed
//
if ($_GET['arg'] == 'results_done' || $_POST['arg'] == 'save_rank' || $prog_mode == 2 && $_GET['arg'] != 'change_results' && $_GET['arg'] != 'del_results') {
AA_utils_calcRankingPoints($round);
}
//
// Qualify athletes after ranks are set
//
if ($_GET['arg'] == 'results_done' || $_POST['arg'] == 'save_rank' || $_POST['arg'] == 'set_qual' || $prog_mode == 2 && $_GET['arg'] != 'change_results' && $_GET['arg'] != 'del_results') {
// read qualification criteria
$qual_top = 0;
$qual_perf = 0;
$result = mysql_query("SELECT QualifikationSieger" . ", QualifikationLeistung" . " FROM runde" . " WHERE xRunde = " . $round);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if (($row = mysql_fetch_row($result)) == TRUE) {
}
$qual_top = $row[0];
$qual_perf = $row[1];
mysql_free_result($result);
}
// ET DB error
// qualify top athletes for next round
if ($qual_top > 0) {
mysql_query("LOCK TABLES serie READ, serienstart WRITE");
// get athletes by qualifying rank (random order if same rank)
$result = mysql_query("SELECT serienstart.xSerienstart" . ", serienstart.xSerie" . ", serienstart.Rang" . " FROM serienstart" . ", serie" . " WHERE serienstart.Rang > 0" . " AND serienstart.xSerie = serie.xSerie" . " AND serie.xRunde = " . $round . " AND serienstart.Qualifikation = 0" . " ORDER BY serienstart.xSerie" . ", serienstart.Rang ASC" . ", RAND()");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$h = 0;
unset($heats);
// clear array containing heats
while ($row = mysql_fetch_row($result)) {
if ($h != $row[1]) {
// new heat
if (count($starts) > 0) {
// count athletes
$heats[] = $starts;
// keep athletes per heat
}
unset($starts);
$c = 0;
}
$starts[$row[0]] = $row[2];
// keep athlete's rank
$h = $row[1];
// keep heat
}
$heats[] = $starts;
// keep remaining athletes
mysql_free_result($result);
foreach ($heats as $starts) {
$rankcount = array_count_values($starts);
// count athletes/rank
$q = 0;
foreach ($starts as $id => $rank) {
// check if more athletes per rank than qualifying spots
if ($rankcount[$rank] > $qual_top - $rank + 1) {
$qual = $cfgQualificationType['top_rand']['code'];
} else {
$qual = $cfgQualificationType['top']['code'];
}
if ($q < $qual_top) {
mysql_query("UPDATE serienstart SET" . " Qualifikation = " . $qual . " WHERE xSerienstart = " . $id);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
$q++;
// count nbr of qualified athletes
}
}
}
// END loop every heat
}
// ET DB error
mysql_query("UNLOCK TABLES");
}
// ET top athletes
// qualify top performing athletes for next round
if ($qual_perf > 0) {
mysql_query("LOCK TABLES resultat READ, serie READ, serienstart WRITE");
// get remaining athletes by performance (random order if equal performance)
/* other possible criteria to order equal performances:
* - ranking within heat (not implemented)
* - wind (not implemented)
*/
$result = mysql_query("SELECT serienstart.xSerienstart" . ", resultat.Leistung" . ", serienstart.Qualifikation" . " FROM resultat" . ", serienstart" . ", serie" . " WHERE resultat.xSerienstart = serienstart.xSerienstart" . " AND resultat.Leistung > 0" . " AND (serienstart.Qualifikation = 0 " . " OR serienstart.Qualifikation = " . $cfgQualificationType['waived']['code'] . ")" . " AND serienstart.xSerie = serie.xSerie" . " AND serie.xRunde = " . $round . " ORDER BY resultat.Leistung DESC" . ", RAND()");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$i = 1;
$perf = 0;
$cWaived = 0;
while ($row = mysql_fetch_row($result)) {
// count waived qualifyings
if ($row[2] == $cfgQualificationType['waived']['code']) {
$cWaived++;
continue;
}
if ($i > $qual_perf) {
// terminate if enough top performers found
if ($perf != $row[1]) {
// last perf. worse than last qualified
$perf = 0;
}
break;
}
// if athletes waived on qualifying, set random code for next best athletes
$code = $cfgQualificationType['perf']['code'];
if ($i + $cWaived > $qual_perf) {
$code = $cfgQualificationType['perf_rand']['code'];
}
mysql_query("UPDATE serienstart SET" . " Qualifikation = " . $code . " WHERE xSerienstart = " . $row[0]);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
$i++;
$perf = $row[1];
// keep performance
}
// reset performance if enough qualifing spots
if (mysql_num_rows($result) <= $qual_perf) {
$perf = 0;
}
mysql_free_result($result);
// Change qualification type to "perf_rand" for athletes with same
// performance as the 1st unqualified athlete
if ($perf != 0) {
$result = mysql_query("SELECT serienstart.xSerienstart" . " FROM resultat" . ", serienstart" . ", serie" . " WHERE resultat.xSerienstart = serienstart.xSerienstart" . " AND resultat.Leistung = " . $perf . " AND serienstart.Qualifikation > 0" . " AND serienstart.xSerie = serie.xSerie" . " AND serie.xRunde = " . $round);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
while ($row = mysql_fetch_row($result)) {
mysql_query("UPDATE serienstart SET" . " Qualifikation = " . $cfgQualificationType['perf_rand']['code'] . " WHERE xSerienstart = " . $row[0]);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
}
mysql_free_result($result);
}
}
// ET unqualified athlete
}
// ET DB error qualified by performance
mysql_query("UNLOCK TABLES");
}
// ET top performances
}
//
// print HTML page header
//
AA_results_printHeader($presets['category'], $presets['event'], $round);
$mergedMain = AA_checkMainRound($round);
if ($mergedMain != 1) {
// read round data
if ($round > 0) {
$status = AA_getRoundStatus($round);
// No action yet
if ($status == $cfgRoundStatus['open'] || $status == $cfgRoundStatus['enrolement_done'] || $status == $cfgRoundStatus['heats_in_progress']) {
AA_printWarningMsg($strHeatsNotDone);
} else {
if ($status == $cfgRoundStatus['enrolement_pending']) {
AA_printWarningMsg($strEnrolementNotDone);
} else {
if ($status >= $cfgRoundStatus['heats_done']) {
// get program mode
$prog_mode = AA_results_getProgramMode();
AA_heats_printNewStart($presets['event'], $round, "event_results.php");
if ($pass == 2) {
$fieldPos = "ss.Position2";
$order = "posOrder";
} elseif ($pass == 3) {
$fieldPos = "ss.Position3";
$order = "ss.Rang DESC";
} else {
$fieldPos = "ss.Position";
$order = "posOrder";
}
// display all athletes
$sql = "SELECT rt.Name" . ", rt.Typ" . ", s.xSerie" . ", s.Bezeichnung" . ", s.Wind" . ", an.Bezeichnung" . ", ss.xSerienstart" . ", ss.Position" . ", ss.Rang" . ", a.Startnummer" . ", at.Name" . ", at.Vorname" . ", at.Jahrgang" . ", if('" . $svm . "', t.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo))" . ", LPAD(s.Bezeichnung,5,'0') as heatid" . ", r.Versuche" . ", ss.Qualifikation" . ", at.Land" . ", r.nurBestesResultat" . ", ss.Bemerkung" . ", at.xAthlet" . ", if (ss.Position2 > 0, if (ss.Position3 > 0, ss.Position3, ss.Position2) , ss.Position ) as posOrder " . " FROM runde AS r" . ", serie AS s" . ", serienstart AS ss" . ", start AS st" . ", anmeldung AS a" . ", athlet AS at" . ", verein AS v" . " LEFT JOIN team AS t ON(a.xTeam = t.xTeam)" . " LEFT JOIN rundentyp AS rt" . " ON rt.xRundentyp = r.xRundentyp" . " LEFT JOIN anlage AS an" . " ON an.xAnlage = s.xAnlage" . " WHERE r.xRunde = " . $round . " AND s.xRunde = r.xRunde" . " AND ss.xSerie = s.xSerie" . " AND st.xStart = ss.xStart" . " AND a.xAnmeldung = st.xAnmeldung" . " AND at.xAthlet = a.xAthlet" . " AND v.xVerein = at.xVerein" . " ORDER BY heatid, posOrder";
$result = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$sum_athlet = mysql_num_rows($result);
AA_results_printMenu($round, $status, $prog_mode, 'tech');
// initialize variables
$h = 0;
$i = 0;
$r = 0;
$rowclass = 'odd';
$r_rem = 0;
$nextRound = AA_getNextRound($presets['event'], $round);
// show qualification form if another round follows
if ($nextRound > 0) {
// next round
$sql = "SELECT QualifikationSieger, \r\n QualifikationLeistung \r\n FROM runde \r\n WHERE xRunde = " . $round . ";";
$result2 = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row2 = mysql_fetch_row($result2);
if ($row2 == true) {
// round found
?>
<p/>
<form name="qualification" action="event_results.php" method="post">
<input type="hidden" name="arg" value="set_qual"/>
<input type="hidden" name="round" value="<?php
echo $round;
?>
"/>
<table class="dialog">
<tr>
<td class="dialog"><?php
echo $strQualification;
?>
<?php
echo $strQualifyTop;
?>
</td>
<td class="dialog"><input type="text" name="qual_top" class="nbr" maxlength="4" value="<?php
echo $row2[0];
?>
"/></td>
<td class='dialog'><?php
echo $strQualification;
?>
<?php
echo $strQualifyPerformance;
?>
</td>
<td class='dialog'><input type="text" name="qual_perf" class="nbr" maxlength="4" value="<?php
echo $row2[1];
?>
"/></td>
<td><button type="submit"><?php
echo $strChange;
?>
</button></td>
</tr>
</table>
</form>
<form name="frmQual" action="event_results.php" method="post">
<input type="hidden" name="arg" value="change_qual"/>
<input type="hidden" name="round" value="<?php
echo $round;
?>
"/>
<input type="hidden" name="focus" value="qual_0"/>
<input type="hidden" name="item" value="0"/>
<input type="hidden" name="oldqual" value="0"/>
<input type="hidden" name="heat" value="0"/>
<input type="hidden" name="qual" value="0"/>
</form>
<script type="text/javascript">
function changequal(valFocus, valItem, valOldQual, valHeat, valQual){
var obj = document.frmQual;
obj.focus.value = valFocus;
obj.item.value = valItem;
obj.oldqual.value = valOldQual;
obj.heat.value = valHeat;
obj.qual.value = valQual;
obj.submit();
}
</script>
<p/>
<?php
}
// ET round found
}
// ET DB error
}
// ET next round
?>
<p/>
<table class='dialog'>
<?php
$btn = new GUI_Button('', '');
// create button object
while ($row = mysql_fetch_row($result)) {
//
// get entered number of attempts
//
$maxatt = $row[15];
if ($maxatt != 0) {
$cfgProgramMode[$prog_mode]['tech_res'] = $maxatt;
}
/*
* Heat headerline
*/
if ($h != $row[2]) {
$h = $row[2];
// keep heat ID
if (is_null($row[0])) {
// only one round
$title = "{$strFinalround}";
} else {
// more than one round
$title = "{$row['0']}";
}
$c = 0;
if ($status == $cfgRoundStatus['results_done'] || $prog_mode == 2) {
$c++;
// increment colspan to include ranking
}
?>
<tr>
<form action='event_results.php#heat_<?php
echo $row[3];
?>
' method='post'
name='heat_id_<?php
echo $h;
?>
'>
<th class='dialog' colspan='
<?php
echo 5 + $cfgProgramMode[$prog_mode]['tech_res'] + $c;
?>
'>
<?php
echo $title;
?>
<input type='hidden' name='arg' value='change_heat_name' />
<input type='hidden' name='round' value='<?php
echo $round;
?>
' />
<input type='hidden' name='item' value='<?php
echo $row[2];
?>
' />
<input class='nbr' type='text' name='id' maxlength='2'
value='<?php
echo $row[3];
?>
'
onChange='document.heat_id_<?php
echo $h;
?>
.submit()' />
<a name='heat_<?php
echo $row[3];
?>
' />
</th>
</form>
</tr>
<tr>
<th class='dialog'><?php
echo $strPositionShort;
?>
</th>
<th class='dialog' colspan='2'><?php
echo $strAthlete;
?>
</th>
<th class='dialog'><?php
echo $strYearShort;
?>
</th>
<th class='dialog'><?php
echo $strCountry;
?>
</th>
<th class='dialog'><?php
if ($svm) {
echo $strTeam;
} else {
echo $strClub;
}
?>
</th>
<?php
if ($status == $cfgRoundStatus['results_done'] || $prog_mode == 2) {
?>
<th class='dialog'><?php
echo $strRank;
?>
</th>
<?php
if ($nextRound > 0) {
?>
<th class='dialog'><?php
echo $strQualification;
?>
</th>
<?php
}
}
if ($cfgProgramMode[$prog_mode]['tech_res'] <= 1) {
?>
<th class='dialog'><?php
echo $strPerformance;
?>
</th>
<?php
} else {
for ($c = 1; $c <= $cfgProgramMode[$prog_mode]['tech_res']; $c++) {
?>
<th class='dialog'><?php
echo $c . ".";
?>
</th>
<?php
}
?>
<th class='dialog'><?php
echo $strResultRemark;
?>
</th>
<?php
}
?>
</tr>
<?php
}
// ET new heat
/*
* Athlete data lines
*/
$i++;
if ($row[7] % 2 == 0) {
// even row numer
$rowclass = 'odd';
} else {
// odd row number
$rowclass = 'even';
}
?>
<tr class='<?php
echo $rowclass;
?>
'>
<td class='forms_right'><?php
echo $row[7];
/* position */
?>
</td>
<td class='forms_right'><?php
echo $row[9];
/* start nbr */
?>
</td>
<td nowrap><?php
echo $row[10] . " " . $row[11];
/* name */
?>
</td>
<td class='forms_ctr'><?php
echo AA_formatYearOfBirth($row[12]);
?>
</td>
<td><?php
echo $row[17] != '' && $row[17] != '-' ? $row[17] : ' ';
?>
</td>
<td nowrap><?php
echo $row[13];
/* club */
?>
</td>
<?php
$res = mysql_query("SELECT rs.xResultat" . ", rs.Leistung" . ", rs.Info" . " FROM resultat AS rs" . " WHERE rs.xSerienstart = " . $row[6] . "\r\n ORDER BY rs.xResultat");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// Show rank
if ($status == $cfgRoundStatus['results_done'] || $prog_mode == 2) {
$disField = ($maxatt + 1) * $maxAthlete;
// attempts * 8 (first 8 athletes)
if ($pass >= 2 && $r + 1 > $disField) {
$dis = 'disabled=" disabled"';
} else {
$dis = '';
}
?>
<form action='event_results.php' method='post'
name='rank_<?php
echo $r;
?>
'>
<td>
<input type='hidden' name='arg' value='save_rank' />
<input type='hidden' name='round' value='<?php
echo $round;
?>
' />
<input type='hidden' name='item' value='<?php
echo $row[6];
?>
' />
<input type='hidden' name='focus' value='rank_<?php
echo $r;
?>
' />
<input class='nbr' type='text' name='rank' maxlength='3' <?php
echo $dis;
?>
value='<?php
echo $row[8];
?>
' onChange='document.rank_<?php
echo $r;
?>
.submit()' />
</td>
<?php
if ($status == $cfgRoundStatus['results_done'] || $prog_mode == 2) {
if ($nextRound > 0) {
?>
<form name="qual_<?php
echo $i;
?>
" action="event_results.php" method="post">
<td>
<input type="hidden" name="arg" value="change_qual"/>
<input type="hidden" name="round" value="<?php
echo $round;
?>
"/>
<input type="hidden" name="focus" value="qual_<?php
echo $i;
?>
"/>
<input type="hidden" name="item" value="<?php
echo $row[6];
?>
"/>
<input type="hidden" name="oldqual" value="<?php
echo $row[16];
?>
"/>
<input type="hidden" name="heat" value="<?php
echo $row[2];
?>
"/>
<?php
$dropdown = new GUI_Select('qual', 1, 'changequal("qual_' . $i . '", ' . $row[6] . ', ' . $row[16] . ', ' . $row[2] . ', this.value)');
$dropdown->addOptionNone();
foreach ($cfgQualificationType as $type) {
$dropdown->addOption($type['text'], $type['code']);
if ($type['code'] == $row[16]) {
$dropdown->selectOption($type['code']);
}
}
$dropdown->printList();
?>
</td>
</form>
<?php
$i++;
// next element
}
// qualification info
} else {
// no rank
?>
<td />
<?php
if ($nextRound > 0) {
?>
<td />
<?php
}
}
// ET valid rank
?>
</form>
<?php
}
$disField = ($maxatt + 1) * $maxAthlete;
// attempts * 8 (first 8 athletes)
for ($c = 1; $c <= $cfgProgramMode[$prog_mode]['tech_res']; $c++) {
// Result focus:
// - Backoffice mode: same athlete, next result
// - Field mode: next athlete, same result
$r++;
// increment result form counter
if ($cfgProgramMode[$prog_mode]['name'] == $strProgramModeBackoffice) {
if ($row[18] == 'y') {
// only best result --> focus next line
$focus = "perf_" . ($r + $cfgProgramMode[$prog_mode]['tech_res'] + 1);
if (mysql_num_rows($result) == $i) {
// no more athletes
if ($c == $cfgProgramMode[$prog_mode]['tech_res']) {
// last result
$focus = "perf_" . ($r + 1);
// keep focus on this athlete
} else {
$focus = "perf_" . ($c + 1);
// focus to next result of first athlete
}
}
} else {
if ($c == $cfgProgramMode[$prog_mode]['tech_res']) {
// last result of this line
if (mysql_num_rows($result) == $i) {
// no more athletes
$focus = "perf_" . $r;
// keep focus on last athlete
} else {
$focus = "perf_" . ($r + 2);
// focus to next line result
}
} else {
$focus = "perf_" . ($r + 1);
// focus to next result
}
}
} else {
// field mode
$focus = "perf_" . ($r + $cfgProgramMode[$prog_mode]['tech_res'] + 1);
if (mysql_num_rows($result) == $i) {
// no more athletes
if ($c == $cfgProgramMode[$prog_mode]['tech_res']) {
// last result
$focus = "perf_" . $r;
// keep focus on this athlete
} else {
$focus = "perf_" . ($c + 1);
// focus to next result of first athlete
}
}
}
// ET program mode
$item = '';
$perf = '';
$info = '';
if ($resrow = mysql_fetch_row($res)) {
$item = $resrow[0];
$perf = AA_formatResultMeter($resrow[1]);
$info = $resrow[2];
}
if ($status != $cfgRoundStatus['results_done'] || $prog_mode == 2) {
?>
<form action='controller.php' method='post'
name='perf_<?php
echo $r;
?>
' target='controller'>
<td nowrap>
<input type='hidden' name='act' value='saveResult' />
<input type='hidden' name='obj' value='perf_<?php
echo $r;
?>
' />
<input type='hidden' name='type' value='<?php
echo $layout;
?>
' />
<input type='hidden' name='round' value='<?php
echo $round;
?>
' />
<input type='hidden' name='start' value='<?php
echo $row[6];
?>
' />
<input type='hidden' name='item' value='<?php
echo $item;
?>
' />
<input type='hidden' name='row_col' value='<?php
echo $r . "_" . $c;
?>
' />
<input type='hidden' name='maxatt' value='<?php
echo $maxatt;
?>
' />
<input type='hidden' name='heat' value='<?php
echo $row[2];
?>
' />
<?php
// technical disciplines with wind
if ($layout == $cfgDisciplineType[$strDiscTypeJump]) {
?>
<input class='perfmeter' type='text' id='perf_<?php
echo $r;
?>
' name='perf' maxlength='6' <?php
echo $dis;
?>
value='<?php
echo $perf;
?>
'
onChange='checkSubmit(document.perf_<?php
echo $r;
?>
, <?php
echo $focus;
?>
)' />
<input class='nbr' type='text' name='wind' maxlength='5'
value='<?php
echo $info;
?>
'
onChange='submitResult(document.perf_<?php
echo $r;
?>
, <?php
echo $focus;
?>
)' />
<?php
} else {
?>
<input class='perfmeter' type='text' id='perf_<?php
echo $r;
?>
' name='perf' maxlength='6' <?php
echo $dis;
?>
value='<?php
echo $perf;
?>
'
onChange='submitResult(document.perf_<?php
echo $r;
?>
, <?php
echo $focus;
?>
)' />
<?php
}
?>
</td>
</form>
<?php
if ($c == $cfgProgramMode[$prog_mode]['tech_res']) {
$r++;
if (mysql_num_rows($result) != $i) {
// more athletes
$focus = "perf_" . ($c + $r + 1);
} else {
$focus = "perf_" . $r;
}
?>
<form action='controller.php' method='post'
name='perf_<?php
echo $r;
?>
' target='controller'>
<td>
<input type='hidden' name='act' value='saveResult' />
<input type='hidden' name='obj' value='perf_<?php
echo $r;
?>
' />
<input type='hidden' name='type' value='<?php
echo $layout;
?>
' />
<input type='hidden' name='round' value='<?php
echo $round;
?>
' />
<input type='hidden' name='start' value='<?php
echo $row[6];
?>
' />
<input type='hidden' name='item' value='<?php
echo $item;
?>
' />
<input type='hidden' name='xAthlete' value='<?php
echo $row[20];
?>
' />
<input class='textshort' type='text' name='remark' maxlength='5' <?php
echo $dis;
?>
value='<?php
echo $row[19];
?>
'
onChange='submitResult(document.perf_<?php
echo $r;
?>
, <?php
echo $focus;
?>
)' />
</td>
</form>
<?php
}
?>
<?php
} else {
// results done
?>
<td nowrap>
<?php
// technical disciplines with wind
if ($layout == $cfgDisciplineType[$strDiscTypeJump]) {
echo "{$perf} ( {$info} )";
} else {
echo "{$perf}";
}
?>
</td>
<?php
if ($c == $cfgProgramMode[$prog_mode]['tech_res']) {
?>
<td nowrap><?php
echo $row[19];
?>
</td>
<?php
}
}
// ET results done
}
// end loop every tech result acc. programm mode
?>
<td>
<?php
$btn->set("event_results.php?arg=del_start&item={$row['6']}&round={$round}", $strDelete);
$btn->printButton();
?>
</td>
<?php
}
// ET DB error
}
?>
</table>
<?php
mysql_free_result($result);
}
// ET DB error
}
}
}
}
// ET round selected
if (!empty($presets['focus'])) {
?>
<script type="text/javascript">
<!--
if(document.<?php
echo $presets['focus'];
?>
) {
document.<?php
echo $presets['focus'];
?>
.rank.focus();
document.<?php
echo $presets['focus'];
?>
.rank.select();
window.scrollBy(0,200);
}
//-->
</script>
<?php
} else {
?>
<script type="text/javascript">
<!--
document.perf_<?php
echo $fieldFocus;
?>
.elements['perf_<?php
echo $fieldFocus;
?>
'].focus();
//-->
</script>
<?php
}
?>
</body>
</html>
<?php
} else {
AA_printErrorMsg($strErrMergedRound);
}
}
