示例#1
0
 /**    
  * ranking for decentral before new position
  * ------------------------------------------
  */
 function AA_rankingForNewPosition($round, $pass)
 {
     $presets = AA_results_getPresets($round);
     // read GET/POST variables
     $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;
     $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;
     $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          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);
     if (mysql_errno() > 0) {
         // DB error
         AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
     } else {
         $z = 0;
         $arr_attAthlete = array();
         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];
             }
             $z++;
         }
         $maxAthleteAtt = max($arr_attAthlete);
         $minAthleteAtt = min($arr_attAthlete);
         $onlyMaxAthlete = false;
         if ($count_athlete > $maxAthlete) {
             if ($maxAthleteAtt == $minAthleteAtt && $minAthleteAtt == $cfgAfterAttempts1) {
                 $onlyMaxAthlete = true;
             } elseif ($maxAthleteAtt > $cfgAfterAttempts1) {
                 $onlyMaxAthlete = true;
             }
         }
         if ($onlyMaxAthlete && $count_athlete > $maxAthlete) {
             $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);
         }
         if ($count_athlete < $maxAthlete) {
             $maxAthlete = $count_athlete;
             // update max athlete
             AA_setMaxAthlete($xSerie, $maxAthlete);
         }
         if ($pass == 2) {
             $r = 3;
         } elseif ($pass == 3) {
             $r = 5;
         }
         $first_row = false;
         if ($maxAthleteAtt == $minAthleteAtt && $z == $count_athlete) {
             $first_row = true;
             $maxAthleteAtt++;
         }
         $z = 0;
         $att_athlet = 0;
         $fieldFocus = 0;
         $first = true;
         if ($pass == 2) {
             $posSQL = "  ss.Position2 > 0 ";
         } elseif ($pass == 3) {
             $posSQL = "  ss.Position3 > 0 ";
         } else {
             $posSQL = "";
         }
         if (!empty($posSQL) && !empty($roundSQL2)) {
             $roundSQL2 = " AND " . $roundSQL2;
         }
         $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                  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 " . $posSQL . $roundSQL2 . "                       \r\n                  GROUP BY r.xSerienstart\r\n                  ORDER BY posOrder ";
         $result = mysql_query($sql);
         if (mysql_num_rows($result) < $maxAthlete) {
             $maxAthlete = mysql_num_rows($result);
         }
         while ($row = mysql_fetch_row($result)) {
             $z++;
             $att_athlet = $row[0];
             if ($row[0] < $maxAthleteAtt && !$first_row) {
                 break;
             } elseif ($row[0] < $maxAthleteAtt) {
                 $fieldFocus = $att_athlet + 1;
                 break;
             } else {
                 $fieldFocus = $z * ($maxatt + 1) + $att_athlet;
             }
             if ($onlyMaxAthlete && $z >= $maxAthlete) {
                 break;
             }
         }
         if ($fieldFocus == 0) {
             $fieldFocus = 1;
         } else {
             if ($onlyMaxAthlete) {
                 if ($z == $maxAthlete && $att_athlet == $maxAthleteAtt) {
                     $z = 1;
                     $att_athlet++;
                     $fieldFocus = $att_athlet;
                 }
             } else {
                 if ($z == $count_athlete && $att_athlet == $maxAthleteAtt) {
                     $z = 1;
                     $att_athlet++;
                     $fieldFocus = $att_athlet;
                 }
             }
         }
         mysql_free_result($result);
     }
     if ($r > 0) {
         mysql_query("DROP TABLE IF EXISTS tempresult1");
         // temporary table
         mysql_query("DROP TABLE IF EXISTS tempresult2");
         // temporary table
         if (mysql_errno() > 0) {
             // DB error
             AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
         } else {
             mysql_query("\r\n                LOCK TABLES\r\n                    resultat as r READ\r\n                    , serie as s READ   \r\n                    , serienstart as ss WRITE\r\n                    , tempresult1 WRITE\r\n                    , tempresult2 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 tempresult1 (\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 . ") ENGINE=HEAP";
             mysql_query($qry);
             // create temporary table
             if (mysql_errno() > 0) {
                 // DB error
                 AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
             } else {
                 $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.xResultat\r\n                       \r\n                ");
                 $sql_temp = "CREATE TABLE tempresult2 (\r\n                                    Leistung int(9)\r\n                                    , Info char(5)\r\n                                     , xSerienstart int(11)  \r\n                                      , xSerie int(11)  )";
                 mysql_query($sql_temp);
                 if (mysql_errno() > 0) {
                     // DB error
                     AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                 }
                 $i = 0;
                 while ($row = mysql_fetch_row($result)) {
                     if ($ss != $row[2]) {
                         // next athlete
                         $i = 0;
                     }
                     if ($i < $r) {
                         $ins = "INSERT INTO tempresult2 VALUES({$row['0']},'{$row['1']}', {$row['2']},{$row['3']})";
                         mysql_query($ins);
                         if (mysql_errno() > 0) {
                             // DB error
                             AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                         }
                     }
                     $ss = $row[2];
                     // keep athlete's ID
                     $i++;
                     // count nbr of results
                 }
                 $sql = "SELECT * FROM tempresult2 \r\n                        ORDER BY\r\n                                xSerienstart\r\n                                , Leistung DESC";
                 $result = mysql_query($sql);
                 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 tempresult1 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                            tempresult1\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                            tempresult1\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 tempresult1");
                 mysql_query("DROP TABLE IF EXISTS tempresult2");
                 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
 }
示例#2
0
    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] : '&nbsp;';
                                    ?>
</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);
        }
    }