Esempio n. 1
0
                }
            }
        }
    }
}
//
// Process del-request
//
if ($_GET['arg'] == "del") {
    mysql_query("LOCK TABLES serienstart READ, start WRITE, anmeldung WRITE, athlet WRITE");
    // check if start data still used
    $result = mysql_query("SELECT xStart FROM start" . " WHERE xAnmeldung=" . $_GET['item']);
    $rc = 0;
    // row counter
    while ($row = mysql_fetch_row($result)) {
        $rc = $rc + AA_checkReference("serienstart", "xStart", $row[0]);
    }
    mysql_free_result($result);
    // OK: not used anymore
    if ($rc == 0) {
        // Delete starts
        mysql_query("DELETE FROM start WHERE xAnmeldung=" . $_GET['item']);
        if (mysql_errno() > 0) {
            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
        }
        // get xAthlet
        $res = mysql_query("SELECT xAthlet FROM anmeldung WHERE xAnmeldung=" . $_GET['item']);
        if (mysql_errno() > 0) {
            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
        } else {
            $row = mysql_fetch_array($res);
Esempio n. 2
0
                            $row_activ = $row[1];
                        }
                        mysql_query("\r\n\t\t\t    UPDATE disziplin SET \r\n\t\t\t\t    Kurzname=\"" . strtoupper($_POST['short']) . "\"\r\n\t\t\t\t    , Name=\"" . $_POST['name'] . "\"\r\n\t\t\t\t    , Anzeige=" . $_POST['order'] . "\r\n\t\t\t\t    , Seriegroesse=" . $_POST['heat'] . "\r\n\t\t\t\t    , Staffellaeufer=" . $_POST['relay'] . "\r\n\t\t\t\t    , Typ=" . $_POST['type'] . "\r\n\t\t\t\t    , Appellzeit=SEC_TO_TIME(" . $_POST['time'] * 60 . ")\r\n\t\t\t\t    , Stellzeit=SEC_TO_TIME(" . $_POST['mtime'] * 60 . ")\r\n                    , aktiv='" . $row_activ . "'   \r\n\t\t\t    WHERE xDisziplin=" . $_POST['item']);
                        if (mysql_errno() > 0) {
                            $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
                        }
                    }
                }
            }
        }
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES wettkampf READ, disziplin WRITE");
        // Check if not used anymore
        if (AA_checkReference("wettkampf", "xDisziplin", $_GET['item']) == 0) {
            mysql_query("DELETE FROM disziplin WHERE xDisziplin=" . $_GET['item']);
        } else {
            AA_printErrorMsg($strDiscipline . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
//
// Display current data
//
$page = new GUI_Page('admin_disciplines', TRUE);
Esempio n. 3
0
    // store selected group
    $group = $_POST['group'];
}
//
// add team
//
if ($_POST['arg'] == "add") {
    $name = $_POST['name'];
    // Error: Empty fields
    if (empty($_POST['name']) || empty($_POST['category']) || empty($_POST['club']) || empty($_POST['event'])) {
        AA_printErrorMsg($strErrEmptyFields);
    } else {
        mysql_query("LOCK TABLES\r\n\t\t\t\tteamsm WRITE\r\n\t\t\t\t, wettkampf READ\r\n\t\t\t\t, kategorie READ\r\n                , anmeldung READ\r\n                , staffel READ\r\n                , start as s READ\r\n                , runde as r READ \r\n                , runde WRITE   \r\n                , wettkampf as w READ  \r\n\t\t\t\t, verein READ");
        if (AA_checkReference("kategorie", "xKategorie", $_POST['category']) == 0) {
            AA_printErrorMsg($strCategory . $strErrNotValid);
        } elseif (AA_checkReference("wettkampf", "xWettkampf", $_POST['event']) == 0) {
            AA_printErrorMsg($strEvent . $strErrNotValid);
        } else {
            // check startnumber
            $lastnbr = AA_getLastStartnbrTeamsm();
            $nbr = $_POST['startnumber'];
            if ($nbr > 0) {
                $res = mysql_query("SELECT * FROM teamsm \r\n                                    WHERE Startnummer = {$nbr} \r\n                                    AND xMeeting = " . $_COOKIE['meeting_id']);
                if (mysql_num_rows($res) > 0) {
                    $nbr = $lastnbr;
                    $nbr++;
                }
                //mysql_free_result($res);
                //
                // check if startnumber is used for athletes
                $res = mysql_query("SELECT * FROM anmeldung \r\n                                    WHERE Startnummer = {$nbr} \r\n                                    AND xMeeting = " . $_COOKIE['meeting_id']);
Esempio n. 4
0
 $sql = "SELECT xAthlet \r\n\t\t\t  FROM athlet;";
 $query = mysql_query($sql);
 while ($row = mysql_fetch_assoc($query)) {
     $num = AA_checkReference('anmeldung', 'xAthlet', $row['xAthlet']);
     if ($num > 0) {
         $errors = true;
         break;
     }
 }
 if (!$errors) {
     $sql = "SELECT xVerein \r\n\t\t\t\t  FROM verein;";
     $query = mysql_query($sql);
     while ($row = mysql_fetch_assoc($query)) {
         $num = AA_checkReference('team', 'xVerein', $row['xVerein']);
         $num2 = AA_checkReference('teamsm', 'xVerein', $row['xVerein']);
         $num3 = AA_checkReference('staffel', 'xVerein', $row['xVerein']);
         if ($num > 0 || $num2 > 0 || $num3 > 0) {
             $errors = true;
             break;
         }
     }
 }
 if ($errors) {
     echo $strEmptyCacheReference;
     die;
 } else {
     // reset athletes
     mysql_query("TRUNCATE TABLE athlet");
     if (mysql_errno > 0) {
         AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
     } else {
Esempio n. 5
0
        AA_printErrorMsg($strErrEmptyFields);
    }
} elseif ($_POST['arg'] == "change") {
    if (!empty($_POST['name']) && !empty($_POST['display']) && !empty($_POST['sortvalue']) && !empty($_POST['item'])) {
        mysql_query("UPDATE region SET\r\n\t\t\t\t\tName = '" . $_POST['name'] . "'\r\n\t\t\t\t\t, Anzeige = '" . $_POST['display'] . "'\r\n\t\t\t\t\t, Sortierwert = '" . $_POST['sortvalue'] . "'\r\n\t\t\t\tWHERE xRegion = " . $_POST['item']);
        if (mysql_errno() > 0) {
            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
        }
    } else {
        AA_printErrorMsg($strErrEmptyFields);
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES athlet READ, region WRITE");
        // Still in use?
        $rows = AA_checkReference("athlet", "xRegion", $_GET['item']);
        // OK: not used anymore
        if ($rows == 0) {
            mysql_query("DELETE FROM region WHERE xRegion=" . $_GET['item']);
        } else {
            AA_printErrorMsg($strRegion . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
//
// Display current data
Esempio n. 6
0
    } else {
        mysql_query("\r\n\t\t\tLOCK TABLES\r\n\t\t\t\tteam WRITE\r\n\t\t");
        mysql_query("\r\n\t\t\tUPDATE team SET\r\n\t\t\t\tName=\"" . $_POST['name'] . "\"\r\n\t\t\tWHERE xTeam=" . $_POST['item']);
        if (mysql_errno() > 0) {
            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
        }
        mysql_query("UNLOCK TABLES");
    }
}
//
// Process del-request
//
if ($_GET['arg'] == "del") {
    mysql_query("\r\n\t\tLOCK TABLES\r\n\t\t\tanmeldung READ\r\n\t\t\t, team WRITE\r\n\t");
    // Still in use?
    if (AA_checkReference("anmeldung", "xTeam", $_GET['item']) > 0) {
        AA_printErrorMsg($strTeam . $strErrStillUsed);
    } else {
        // delete team events
        mysql_query("\r\n\t\t\tDELETE FROM team\r\n\t\t\tWHERE xTeam = " . $_GET['item']);
        if (mysql_errno() > 0) {
            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
        }
    }
    // ET DB error (still in use)
    mysql_query("UNLOCK TABLES");
    $_POST['item'] = $_GET['item'];
    // show empty form after delete
}
//
// display data
Esempio n. 7
0
 /**
  * change installations
  * --------------------
  */
 function AA_heats_changeInstallation($round)
 {
     require './lib/common.lib.php';
     if ($_POST['arg'] == 'change_inst' && empty($_POST['item'])) {
         AA_printErrorMsg($GLOBALS['strErrEmptyFields']);
     } else {
         mysql_query("LOCK TABLES anlage READ, serie WRITE");
         $installation = $_POST['installation'];
         if (AA_checkReference("anlage", "xAnlage", $installation) == 0) {
             $installation = 0;
         }
         if ($_POST['arg'] == 'change_inst') {
             // only for one heat
             $clause = " WHERE xSerie=" . $_POST['item'];
         } else {
             // all heats
             $clause = " WHERE xRunde=" . $round;
         }
         mysql_query("UPDATE serie SET" . " xAnlage = {$installation}" . $clause);
         if (mysql_errno() > 0) {
             AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
         }
         mysql_query("UNLOCK TABLES");
     }
 }
Esempio n. 8
0
    } else {
        if ($_POST['arg'] == "add") {
            mysql_query("\r\n\t\t\tINSERT INTO verein SET\r\n\t\t\t\tName=\"" . $_POST['name'] . "\"\r\n\t\t\t\t, Sortierwert=\"" . $_POST['sortvalue'] . "\"\r\n\t\t");
        } else {
            if ($_POST['arg'] == "change") {
                mysql_query("\r\n\t\t\tUPDATE verein SET\r\n\t\t\t\tName=\"" . $_POST['name'] . "\"\r\n\t\t\t\t, Sortierwert=\"" . $_POST['sortvalue'] . "\"\r\n\t\t\tWHERE xVerein=" . $_POST['item']);
            }
        }
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES athlet READ, staffel READ, team READ, verein WRITE");
        // Still in use?
        $rows = AA_checkReference("athlet", "xVerein", $_GET['item']);
        $rows = $rows + AA_checkReference("staffel", "xVerein", $_GET['item']);
        $rows = $rows + AA_checkReference("team", "xVerein", $_GET['item']);
        // OK: not used anymore
        if ($rows == 0) {
            mysql_query("DELETE FROM verein WHERE xVerein=" . $_GET['item']);
        } else {
            AA_printErrorMsg($strClub . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
//
// Display current data
Esempio n. 9
0
 function AA_meeting_deleteEvent()
 {
     require './lib/common.lib.php';
     mysql_query("LOCK TABLES runde READ, start READ, wettkampf WRITE");
     // Still in use?
     $rows = AA_checkReference("runde", "xWettkampf", $_POST['item']);
     $rows = $rows + AA_checkReference("start", "xWettkampf", $_POST['item']);
     // OK: not used anymore
     if ($rows == 0) {
         mysql_query("DELETE FROM wettkampf WHERE xWettkampf=" . $_POST['item']);
     } else {
         AA_printErrorMsg($GLOBALS['strEvent'] . $GLOBALS['strErrStillUsed']);
     }
     mysql_query("UNLOCK TABLES");
     return;
 }
Esempio n. 10
0
        }
    }
    ?>
<tr>
	<td>team</td>
	<td><?php 
    echo $items;
    ?>
</td>
</tr>
<?php 
    $items = 0;
    $sql = "SELECT * \r\n\t\t\t  FROM staffel;";
    $query = mysql_query($sql);
    while ($staffel = mysql_fetch_assoc($query)) {
        $ref = AA_checkReference('meeting', 'xMeeting', $staffel['xMeeting']);
        if ($ref == 0) {
            $sql2 = "DELETE FROM staffel \r\n\t\t\t\t\t\t   WHERE xStaffel = " . $staffel['xStaffel'] . ";";
            $query2 = mysql_query($sql2);
            if ($query2 && mysql_affected_rows() == 1) {
                $items++;
            }
        }
    }
    ?>
<tr>
	<td>staffel</td>
	<td><?php 
    echo $items;
    ?>
</td>
Esempio n. 11
0
             $idcounter = "001";
         } else {
             $idcounter = substr($biggestId, 6, 3);
             $idcounter++;
             $idcounter = sprintf("%03d", $idcounter);
         }
         $xTeamSQL = ", xTeam = " . $eventnr . $idcounter . ", Athleticagen ='y' ";
     }
 }
 if (AA_checkReference("kategorie", "xKategorie", $category) == 0) {
     AA_printErrorMsg($strCategory . $strErrNotValid);
 } else {
     if (AA_checkReference("meeting", "xMeeting", $_COOKIE['meeting_id']) == 0) {
         AA_printErrorMsg($strMeeting . $strErrNotValid);
     } else {
         if (AA_checkReference("verein", "xVerein", $_POST['club']) == 0) {
             AA_printErrorMsg($strClub . $strErrNotValid);
         } else {
             if (!empty($_POST['id'])) {
                 // svm is added from base
                 $xTeamSQL = ", xTeam = " . $_POST['id'] . ", Athleticagen ='n' ";
             }
             mysql_query("\r\n\t\t\t\t\t\tINSERT INTO team SET \r\n\t\t\t\t\t\t\tName=\"" . $_POST['name'] . "\"\r\n\t\t\t\t\t\t\t, xMeeting=" . $_COOKIE['meeting_id'] . "\r\n\t\t\t\t\t\t\t, xKategorie = " . $category . "\r\n\t\t\t\t\t\t\t, xVerein=" . $_POST['club'] . " \r\n                            , xKategorie_svm = '" . $category_svm . "'" . $xTeamSQL);
             if (mysql_errno() > 0) {
                 AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
             } else {
                 $xTeam = mysql_insert_id();
                 // get new ID
             }
         }
         // ET Club valid; add or change
Esempio n. 12
0
                    }
                } else {
                    // in other language without name and short name
                    mysql_query("\r\n                        UPDATE rundentyp_it SET\r\n                            Typ=\"" . $_POST['type'] . "\"                              \r\n                            , Wertung=" . $_POST['valtype'] . "\r\n                        WHERE xRundentyp=" . $_POST['item']);
                    if (mysql_errno() > 0) {
                        $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
                    }
                }
            }
        }
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES runde READ, rundentyp_de WRITE, rundentyp_fr WRITE, rundentyp_it WRITE");
        // Still in use?
        $rows = AA_checkReference("runde", "xRundentyp", $_GET['item']);
        // OK: not used anymore
        if ($rows == 0) {
            mysql_query("DELETE FROM rundentyp_de WHERE xRundentyp=" . $_GET['item']);
            mysql_query("DELETE FROM rundentyp_fr WHERE xRundentyp=" . $_GET['item']);
            mysql_query("DELETE FROM rundentyp_it WHERE xRundentyp=" . $_GET['item']);
        } else {
            AA_printErrorMsg($strRoundtype . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
Esempio n. 13
0
                        mysql_query("UPDATE athlet SET " . "xVerein='" . $_POST['club'] . "' WHERE xAthlet=" . $_POST['item']);
                        // Check if any error returned from DB
                        if (mysql_errno() > 0) {
                            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                        }
                    }
                } else {
                    AA_printErrorMsg($strErrClubChange);
                }
                mysql_query("UNLOCK TABLES");
            }
        } else {
            if ($_GET['arg'] == "del") {
                mysql_query("LOCK TABLES anmeldung READ, staffelathlet READ, athlet WRITE");
                // Still in use?
                $rows = AA_checkReference("anmeldung", "xAthlet", $_GET['item']);
                // OK: not used anymore
                if ($rows == 0) {
                    mysql_query("DELETE FROM athlet WHERE xAthlet=" . $_GET['item']);
                    if (mysql_errno() > 0) {
                        AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                    }
                } else {
                    AA_printErrorMsg($strAthlete . $strErrStillUsed);
                }
                mysql_query("UNLOCK TABLES");
            }
        }
    }
}
//
Esempio n. 14
0
                    }
                }
            } else {
                AA_printErrorMsg($strErrInvalidResult);
            }
        }
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("DELETE FROM wertungstabelle_punkte WHERE xWertungstabelle_Punkte = " . $_GET['item']);
        header('Location: admin_scoretables.php?xw=' . $_GET['xw'] . '&disc=' . $_GET['disc']);
        exit;
    } else {
        if ($_GET['arg'] == "deltbl") {
            // Check if not used anymore
            if (AA_checkReference("wettkampf", "Punktetabelle", $_GET['item']) == 0) {
                mysql_query("DELETE FROM wertungstabelle_punkte WHERE xWertungstabelle = " . $_GET['item']);
                mysql_query("DELETE FROM wertungstabelle WHERE xWertungstabelle = " . $_GET['item']);
                header('Location: admin_scoretables.php');
                exit;
            } else {
                AA_printErrorMsg($strScoreTable . $strErrStillUsed);
            }
        }
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
//
Esempio n. 15
0
 if (AA_checkReference("verein", "xVerein", $_POST['club']) == 0) {
     AA_printErrorMsg($strClub . $strErrNotValid);
 } else {
     // Team selected
     if (!empty($_POST['team']) && AA_checkReference("team", "xTeam", $_POST['team']) == 0) {
         AA_printErrorMsg($strTeam . $strErrNotValid);
     } else {
         if (AA_checkReference("wettkampf", "xWettkampf", $_POST['event']) == 0) {
             AA_printErrorMsg($strEvent . $strErrNotValid);
         } else {
             $startcheck = TRUE;
             $c = 0;
             if ($_POST['starts'] > 0) {
                 foreach ($_POST['starts'] as $start) {
                     // position or athlete not valid
                     if ($_POST['positions'][$c] > 0 && AA_checkReference("start", "xStart", $start) == 0) {
                         $startcheck = FALSE;
                     }
                     $c++;
                 }
             }
             // ET any athletes
             if ($startcheck == FALSE) {
                 AA_printErrorMsg($strAthlete . $strErrNotValid);
             } else {
                 // check startnumber
                 $lastnbr = AA_getLastStartnbrRelay();
                 $nbr = $_POST['startnumber'];
                 if ($nbr > 0) {
                     $res = mysql_query("SELECT * FROM staffel \r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE Startnummer = {$nbr} \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND xMeeting = " . $_COOKIE['meeting_id']);
                     if (mysql_num_rows($res) > 0) {
Esempio n. 16
0
             $perf = 0;
         }
         mysql_query("\r\n\t\t\tUPDATE start SET\r\n\t\t\t\tBestleistung = {$perf}\r\n\t\t WHERE xStart = " . $_POST['start']);
         if (mysql_errno() > 0) {
             AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
         }
     }
     mysql_query("UNLOCK TABLES");
 } else {
     if ($_POST['arg'] == "change_team") {
         mysql_query("\r\n\t\tLOCK TABLES\r\n\t\t\tstaffelathlet READ\r\n\t\t\t, team READ\r\n\t\t\t, start WRITE\r\n\t\t\t, staffel WRITE");
         $res = mysql_query("\r\n\t\t\t\tSELECT\r\n\t\t\t\t\tstaffelathlet.xAthletenstart\r\n\t\t\t\tFROM\r\n\t\t\t\t\tstaffelathlet\r\n\t\t\t\t\t, start AS start\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tstart.xStaffel = " . $_POST['item'] . "\r\n\t\t\t\t\tAND staffelathlet.xStaffelstart = start.xStart\r\n\t\t\t");
         if (mysql_errno() > 0) {
             AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
         } else {
             if (!empty($_POST['team']) && AA_checkReference("team", "xTeam", $_POST['team']) == 0) {
                 AA_printErrorMsg($strTeam . $strErrNotValid);
             } else {
                 // relay data
                 mysql_query("\r\n\t\t\tUPDATE staffel SET\r\n\t\t\t\txTeam = " . $_POST['team'] . "\r\n\t\t\t WHERE xStaffel = " . $_POST['item']);
                 if (mysql_errno() > 0) {
                     AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                 }
             }
         }
         mysql_query("UNLOCK TABLES");
     } else {
         if ($_POST['arg'] == "change_pos") {
             // Error: Empty fields
             if (empty($_POST['item']) || empty($_POST['relay']) || empty($_POST['athlete']) || empty($_POST['round'])) {
                 AA_printErrorMsg($strErrEmptyFields);
                     // set checked automatic
                 } else {
                     AA_printErrorMsg($strMergeRoundsErr);
                 }
             }
         }
         mysql_query("UNLOCK TABLES");
     }
 } elseif ($_POST['arg'] == "merge_del") {
     if (!empty($_POST['mainRound']) && !empty($_POST['round']) && !empty($_POST['roundSet'])) {
         //mysql_query("LOCK TABLES rundenset WRITE, serie READ");
         mysql_query("LOCK TABLES rundenset WRITE, rundenset as rs READ,serie READ, runde AS r Read, Wettkampf AS w READ, meeting READ ");
         $mr = $_POST['mainRound'];
         $r = $_POST['round'];
         $rs = $_POST['roundSet'];
         if (AA_checkReference("serie", "xRunde", $mr) != 0 || AA_checkReference("serie", "xRunde", $r) != 0) {
             $GLOBALS['AA_ERROR'] = $strErrHeatsAlreadySeeded;
         } else {
             // remove round from set
             mysql_query("DELETE FROM rundenset WHERE\r\n\t\t\t\t\txRundenset = {$rs}\r\n\t\t\t\t\tAND xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t\t\t\t\tAND xRunde = {$r}");
             if (mysql_errno() > 0) {
                 $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
             } else {
                 // check if there are no more rounds in set
                 $res = mysql_query("SELECT * FROM rundenset WHERE\r\n\t\t\t\t\t\t\txRundenset = {$rs}");
                 if (mysql_errno() > 0) {
                     $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
                 } else {
                     if (mysql_num_rows($res) == 1) {
                         // mainround only
                         mysql_query("DELETE FROM rundenset WHERE\r\n\t\t\t\t\t\t\txRundenset = {$rs}\r\n\t\t\t\t\t\t\tAND xMeeting = " . $_COOKIE['meeting_id']);
Esempio n. 18
0
            } else {
                if ($_POST['arg'] == "change") {
                    mysql_query("\r\n\t\t\t\tUPDATE anlage SET \r\n\t\t\t\t\tBezeichnung=\"" . $_POST['name'] . "\"\r\n\t\t\t\t\t, xStadion = {$stadium_id}\r\n\t\t\t\t\t, Homologiert = '{$h**o}'\r\n\t\t\t\tWHERE xAnlage=" . $_POST['item']);
                }
            }
        }
        if (mysql_errno() > 0) {
            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
        }
        mysql_query("UNLOCK TABLES");
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES serie READ, anlage WRITE");
        // Check if not used anymore
        if (AA_checkReference("serie", "xAnlage", $_GET['item']) == 0) {
            mysql_query("DELETE FROM anlage WHERE xAnlage=" . $_GET['item']);
            if (mysql_errno() > 0) {
                AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
            }
        } else {
            AA_printErrorMsg($strInstallation . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// get stadium name
$result = mysql_query("\r\n\tSELECT\r\n\t\tName\r\n\tFROM\r\n\t\tstadion\r\n\tWHERE xStadion = {$stadium_id}\r\n");
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
    $stadium_name = "";
Esempio n. 19
0
             		WHERE	start.xWettkampf = wettkampf.xWettkampf
             		AND	wettkampf.xKategorie = $cCat
             		AND	wettkampf.Mehrkampfcode = $cCode
             		AND	wettkampf.xMeeting = ".$_COOKIE['meeting_id']."
             		AND	start.xAnmeldung='" . $_GET['entry'] . "'
             		");*/
             $sql = "UPDATE\r\n\t\t\t\t\t\t\tstart\r\n\t\t\t\t\t\tLEFT JOIN \r\n\t\t\t\t\t\t\twettkampf USING(xWettkampf)\r\n\t\t\t\t\t\tSET \r\n\t\t\t\t\t\t\tstart.Anwesend = '" . $present . "' \t\t\t\t\t\t\t\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\twettkampf.xKategorie = " . $cCat . "\r\n\t\t\t\t\t\tAND\t\r\n\t\t\t\t\t\t\twettkampf.Mehrkampfcode = " . $cCode . "\r\n\t\t\t\t\t\tAND\t\r\n\t\t\t\t\t\t\twettkampf.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t\t\t\t\t\tAND\t\r\n\t\t\t\t\t\t\tstart.xAnmeldung='" . $_GET['entry'] . "';";
             mysql_query($sql);
             if (mysql_errno() > 0) {
                 AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
             }
         }
     }
 } else {
     // single normal event
     if (AA_checkReference("serienstart", "xStart", $_GET['item']) != 0) {
         AA_printErrorMsg($strErrAthleteSeeded);
     } else {
         $sql = "UPDATE start SET \r\n\t\t\t\t\t\tAnwesend='{$present}'\t\t\t\t\t\t\r\n\t\t\t\t\t\tWHERE xStart='" . $_GET['item'] . "'";
         mysql_query($sql);
         /*                    
         		   // relay: set present to start record from relay                        
         		   if ($relay){
         		        $sql = "SELECT DISTINCT  					
         					 		s.xStaffel
         				        FROM
         							staffel AS st
         							LEFT JOIN start AS s USING(xStaffel)
         							LEFT JOIN verein AS v ON(st.xVerein = v.xVerein)
         							LEFT JOIN staffelathlet AS stat ON(stat.xStaffelstart = s.xStart)
         							LEFT JOIN start AS s2 ON(s2.xStart = stat.xAthletenstart)
Esempio n. 20
0
 function AA_results_update($performance, $info, $points = 0)
 {
     require './lib/common.lib.php';
     if ($performance != NULL) {
         if (!empty($_POST['item'])) {
             if (AA_checkReference("resultat", "xResultat", $_POST['item']) == 0) {
                 AA_printErrorMsg($GLOBALS['strErrAthleteNotInHeat']);
             } else {
                 mysql_query("\r\n\t\t\t\t\tUPDATE resultat SET\r\n\t\t\t\t\t\tLeistung = {$performance}\r\n\t\t\t\t\t\t, Info = '{$info}'\r\n\t\t\t\t\t\t, Punkte = {$points}\r\n\t\t\t\t\tWHERE xResultat = " . $_POST['item']);
                 if (mysql_errno() > 0) {
                     AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                 }
                 AA_StatusChanged($_POST['item']);
             }
         } else {
             mysql_query("\r\n\t\t\t\tINSERT INTO resultat SET\r\n\t\t\t\t\tLeistung = {$performance}\r\n\t\t\t\t\t, Info= '{$info}'\r\n\t\t\t\t\t, Punkte = {$points}\r\n\t\t\t\t\t, xSerienstart = " . $_POST['start']);
             if (mysql_errno() > 0) {
                 AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
             }
             AA_StatusChanged(mysql_insert_id());
         }
         // ET add or change
     }
     // ET valid data provided
 }
Esempio n. 21
0
                            $GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
                        }
                    }
                    mysql_query("UNLOCK TABLES");
                }
            }
        }
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES anmeldung READ, staffel READ, team WRITE," . " wettkampf WRITE, kategorie WRITE");
        // Still in use?
        $rows = AA_checkReference("anmeldung", "xKategorie", $_GET['item']);
        $rows = $rows + AA_checkReference("staffel", "xKategorie", $_GET['item']);
        $rows = $rows + AA_checkReference("team", "xKategorie", $_GET['item']);
        $rows = $rows + AA_checkReference("wettkampf", "xKategorie", $_GET['item']);
        // OK: not used anymore
        if ($rows == 0) {
            mysql_query("DELETE FROM kategorie WHERE xKategorie=" . $_GET['item']);
        } else {
            AA_printErrorMsg($strCategory . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
//
//	Display current data
Esempio n. 22
0
    function AA_results_High($round, $layout, $singleRound)
    {
        $zaehler = 0;
        $max = 0;
        foreach ($_POST as $key => $val) {
            $arr_key = explode('_', $key);
            if ($arr_key[0] == 'hight') {
                $max = $arr_key[1];
            }
        }
        if ($max > 0) {
            $max++;
        } else {
            $max = $GLOBALS['cfgCountHeight'];
        }
        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_performance.lib.php';
        $presets = AA_results_getPresets($round);
        // read GET/POST variables
        $performance = 0;
        // initialize
        $svm = AA_checkSVM(0, $round);
        // decide whether to show club or team name
        $prog_mode = AA_results_getProgramMode();
        if ($singleRound > 0) {
            $single_svm = AA_checkSVM(0, $singleRound);
            // decide whether to show club or team name
        }
        $click = true;
        // true = User clicks at this athlete      false = user save athlete before
        //
        // update result(s)
        //
        if ($_POST['arg'] == 'save_res') {
            $click = false;
            // check if athlet valid
            if (AA_checkReference("serienstart", "xSerienstart", $_POST['start']) == 0) {
                AA_printErrorMsg($strErrAthleteNotInHeat);
            } else {
                AA_utils_changeRoundStatus($round, $cfgRoundStatus['results_in_progress']);
                if (!empty($GLOBALS['AA_ERROR'])) {
                    AA_printErrorMsg($GLOBALS['AA_ERROR']);
                }
                mysql_query("\r\n            LOCK TABLES\r\n                disziplin READ\r\n                , runde READ\r\n                , runde AS r READ \r\n                , serienstart WRITE\r\n                , wettkampf READ\r\n                , wettkampf AS w READ \r\n                , resultat WRITE\r\n                , wertungstabelle READ\r\n                , wertungstabelle_punkte READ\r\n                , meeting READ\r\n        ");
                // validate result
                if ($_POST['attempts'] < 0) {
                    $perf = new PerformanceAttempt($_POST['attempts']);
                    $performance = $perf->getPerformance();
                } else {
                    $perf = new PerformanceAttempt($_POST['perf']);
                    $performance = $perf->getPerformance();
                }
                // validate attempts
                if ($performance > 0) {
                    $info = strtoupper($_POST['attempts']);
                    $info = strtr($info, '0', 'O');
                    $info = str_replace("OOO", "O", $info);
                    $info = str_replace("OO", "O", $info);
                    if (in_array($info, $cfgResultsHigh) == false) {
                        $info = NULL;
                    }
                } else {
                    // negative or zero result
                    $info = $cfgResultsHighOut;
                }
                // check on failed attempts (not more than 3 X in a row, it doesent matter on which hights)
                $res = mysql_query("SELECT Leistung, Info FROM \r\n                    resultat\r\n                WHERE\r\n                    xSerienstart = " . $_POST['start'] . "\r\n                ORDER BY\r\n                    Leistung ASC");
                $Xcount = 0;
                while ($row = mysql_fetch_array($res)) {
                    if (strpos($row[1], strtoupper("o")) === false) {
                        preg_match_all("[X]", $row[1], $m);
                        $Xcount += count($m[0]);
                    } else {
                        $Xcount = 0;
                    }
                }
                if (strpos($info, strtoupper("o")) === false) {
                    // count X for last entered attempt
                    preg_match_all("[X]", $info, $m);
                    $Xcount += count($m[0]);
                } else {
                    $Xcount = 0;
                }
                if ($info == $cfgResultsHighOut || $Xcount >= 3) {
                    // last attempt
                    if ($cfgProgramMode[$prog_mode]['name'] == $strProgramModeBackoffice) {
                        $_POST['athlete'] = $_POST['athlete'] + 1;
                        // next athlete
                    }
                    $points = 0;
                } else {
                    /*$sql_sex = "SELECT Geschlecht 
                           FROM athlet 
                      LEFT JOIN anmeldung USING(xAthlet) 
                      LEFT JOIN start USING(xAnmeldung) 
                      LEFT JOIN serienstart USING(xStart) 
                          WHERE xSerienstart = ".$_POST['start'].";";*/
                    $sql_sex = "SELECT Geschlecht \r\n                          FROM kategorie \r\n                     LEFT JOIN wettkampf USING(xKategorie) \r\n                     LEFT JOIN start USING(xWettkampf) \r\n                     LEFT JOIN serienstart USING(xStart) \r\n                         WHERE xSerienstart = " . $_POST['start'] . ";";
                    $query_sex = mysql_query($sql_sex);
                    if ($_POST['attempts'] == '-') {
                        $points = 0;
                    } else {
                        if ($single_svm) {
                            $single_presets = AA_results_getPresets($singleRound);
                            // read GET/POST variables
                            $points = AA_utils_calcPoints($single_presets['event'], $performance, 0, mysql_result($query_sex, 0, 'Geschlecht'));
                        } else {
                            $points = AA_utils_calcPoints($presets['event'], $performance, 0, mysql_result($query_sex, 0, 'Geschlecht'));
                        }
                    }
                }
                if (!empty($info)) {
                    AA_results_update($performance, $info, $points);
                } else {
                    $_POST['athlete']--;
                }
            }
            // ET Athlete valid
            mysql_query("UNLOCK TABLES");
            // set ranks after every new result in mode = decentral with ranking
            // ******************************************************************
            if ($prog_mode == 2) {
                $eval = AA_results_getEvaluationType($round);
                $combined = AA_checkCombined(0, $round);
                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                    serie READ\r\n                    , wettkampf READ\r\n                    , resultat WRITE\r\n                    , serienstart WRITE\r\n                    , tempresult WRITE\r\n            ");
                    // clean ranks, set all to 0
                    mysql_query("UPDATE \r\n                    serienstart\r\n                    , serie\r\n                SET\r\n                    serienstart.Rang = 0\r\n                WHERE\r\n                    serienstart.xSerie = serie.xSerie\r\n                AND    serie.xRunde = {$round}");
                    // Set up a temporary table to hold all results for ranking.
                    mysql_query("\r\n                CREATE TABLE tempresult (\r\n                    xSerienstart int(11)\r\n                    , xSerie int(11)\r\n                    , Leistung int(9)\r\n                    , TopX int(1)\r\n                    , TotalX int(2)\r\n                    )\r\n                    TYPE=HEAP \r\n            ");
                    if (mysql_errno() > 0) {
                        // DB error
                        AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                    } else {
                        // if this is a combined event, rank all rounds togheter
                        $roundSQL = "";
                        if ($combined) {
                            $roundSQL = "AND serie.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] . ",";
                            }
                            $roundSQL = substr($roundSQL, 0, -1) . ")";
                        } else {
                            $roundSQL = "AND serie.xRunde = {$round}";
                        }
                        // read all valid results (per athlet)
                        $result = mysql_query("\r\n                    SELECT\r\n                        resultat.Leistung\r\n                        , resultat.Info\r\n                        , serienstart.xSerienstart\r\n                        , serienstart.xSerie\r\n                    FROM\r\n                        resultat\r\n                        , serienstart\r\n                        , serie\r\n                    WHERE resultat.xSerienstart = serienstart.xSerienstart\r\n                    AND serienstart.xSerie = serie.xSerie\r\n                    {$roundSQL}\r\n                    AND resultat.Leistung != 0\r\n                    ORDER BY\r\n                        serienstart.xSerienstart\r\n                        ,resultat.Leistung DESC\r\n                ");
                        if (mysql_errno() > 0) {
                            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                        } else {
                            // initialize variables
                            $leistung = 0;
                            $serienstart = 0;
                            $serie = 0;
                            $topX = 0;
                            $totX = 0;
                            $ss = 0;
                            // athlete's ID
                            $tt = FALSE;
                            // top result check
                            // process every result
                            while ($row = mysql_fetch_row($result)) {
                                // new athlete: save last athlete's data
                                if ($ss != $row[2] && $ss != 0) {
                                    if ($leistung != 0) {
                                        // add one row per athlete to temp table
                                        mysql_query("\r\n                                    INSERT INTO tempresult\r\n                                    VALUES(\r\n                                        {$serienstart}\r\n                                        , {$serie}\r\n                                        , {$leistung}\r\n                                        , {$topX}\r\n                                        , {$totX})\r\n                                ");
                                        if (mysql_errno() > 0) {
                                            // DB error
                                            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                        }
                                    }
                                    // initialize variables
                                    $leistung = 0;
                                    $serienstart = 0;
                                    $serie = 0;
                                    $totX = 0;
                                    $topX = 0;
                                    $tt = FALSE;
                                }
                                // save data of current athlete's top result
                                if ($tt == FALSE && strstr($row[1], 'O')) {
                                    $leistung = $row[0];
                                    $serienstart = $row[2];
                                    $serie = $row[3];
                                    $topX = substr_count($row[1], 'X');
                                    $tt = TRUE;
                                }
                                // count total invalid attempts
                                $totX = $totX + substr_count($row[1], 'X');
                                $ss = $row[2];
                                // keep athlete's ID
                            }
                            mysql_free_result($result);
                            // insert last pending data in temp table
                            if ($ss != 0 && $leistung != 0) {
                                mysql_query("\r\n                            INSERT INTO tempresult\r\n                            VALUES(\r\n                                {$serienstart}\r\n                                , {$serie}\r\n                                , {$leistung}\r\n                                , {$topX}\r\n                                , {$totX})\r\n                        ");
                                if (mysql_errno() > 0) {
                                    // DB error
                                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                }
                            }
                        }
                        if ($eval == $cfgEvalType[$strEvalTypeHeat]) {
                            // eval per heat
                            $order = "xSerie ,";
                        } else {
                            // default: rank results from all heats together
                            $order = "";
                        }
                        // Read rows from temporary table ordered by performance,
                        // nbr of invalid attempts for top performance and
                        // total nbr of invalid attempts to determine ranking.
                        $result = mysql_query("\r\n                    SELECT\r\n                        xSerienstart\r\n                        , xSerie\r\n                        , Leistung\r\n                        , TopX\r\n                        , TotalX\r\n                    FROM\r\n                        tempresult\r\n                    ORDER BY\r\n                        {$order}\r\n                        Leistung DESC\r\n                        ,TopX ASC\r\n                        ,TotalX ASC\r\n                ");
                        if (mysql_errno() > 0) {
                            // DB error
                            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                        } else {
                            // initialize variables
                            $heat = 0;
                            $perf = 0;
                            $topX = 0;
                            $totalX = 0;
                            $i = 0;
                            $rank = 0;
                            // set rank for every athlete
                            while ($row = mysql_fetch_row($result)) {
                                if ($eval == $cfgEvalType[$strEvalTypeHeat] && $heat != $row[1]) {
                                    $i = 0;
                                    // restart ranking
                                    $perf = 0;
                                    $topX = 0;
                                    $totalX = 0;
                                }
                                $j++;
                                // increment ranking
                                if ($perf != $row[2] || $topX != $row[3] || $totalX != $row[4]) {
                                    $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 = $row[2];
                                $topX = $row[3];
                                $totalX = $row[4];
                            }
                            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)
                AA_results_setNotStarted($round);
                // update athletes with no result
                if (!empty($GLOBALS['AA_ERROR'])) {
                    AA_printErrorMsg($GLOBALS['AA_ERROR']);
                }
            }
            // end prog mode = 2 (decentral with ranking)
        } elseif ($_POST['arg'] == 'save_height') {
            $max = $_POST['max'];
            $arr_prev = array();
            $arr_new = array();
            for ($g = 0; $g < $max; $g++) {
                $name = "hight_" . $g;
                $hiddenName = "hiddenHeight_" . $g;
                $previous_height = $_POST[$hiddenName];
                $previous_height = new PerformanceAttempt($previous_height);
                $previous_height = $previous_height->getPerformance();
                if (isset($_POST[$name])) {
                    $new_height = $_POST[$name];
                    $new_height = new PerformanceAttempt($new_height);
                    $new_height = $new_height->getPerformance();
                } else {
                    $new_height = $previous_height;
                }
                $arr_prev[$g] = $previous_height;
                $arr_new[$g] = $new_height;
            }
            $diff = 0;
            $first_change = false;
            foreach ($arr_prev as $key => $val) {
                if ($first_change) {
                    $arr_new[$key] = $arr_new[$key - 1] + $diff;
                } else {
                    if ($val == $arr_new[$key]) {
                        if ($diff > 0) {
                            $arr_new[$key] = $arr_new[$key - 1] + $diff;
                        }
                    } else {
                        if ($diff == 0) {
                            if ($key == 0) {
                                $first_change = true;
                                if ($_POST['disCode'] == '310') {
                                    // jump
                                    $diff = $cfgHeightDiffJump * 100;
                                } elseif ($_POST['disCode'] == '320') {
                                    $diff = $cfgHeightDiffPole * 100;
                                    // pole
                                } else {
                                    $diff = $cfgHeightDiffJump * 100;
                                }
                            } else {
                                $diff = $arr_new[$key] - $keep_val;
                            }
                        } else {
                            $arr_new[$key] = $arr_prev[$key] + $diff;
                        }
                    }
                }
                $keep_val = $val;
            }
            AA_delHeight($_POST['round'], $_POST['heat']);
            AA_setHeight($arr_new, $_POST['round'], $_POST['heat']);
            $name = "hight_" . $max;
            if (isset($_POST[$name]) && !empty($_POST[$name])) {
                $new_height = $_POST[$name];
                $new_height = new PerformanceAttempt($new_height);
                $new_height = $new_height->getPerformance();
                // insert new hight
                $sql = "INSERT INTO hoehe SET \r\n                                    hoehe = " . $new_height . ",\r\n                                    xRunde = " . $_POST['round'] . ",   \r\n                                    xSerie = " . $_POST['heat'];
                $res = mysql_query($sql);
                if (mysql_errno() > 0) {
                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                }
            }
        } else {
            if ($_GET['arg'] == 'delete') {
                AA_results_delete($round, $_GET['item']);
            }
        }
        //
        // terminate result processing
        //
        if ($_GET['arg'] == 'results_done') {
            $eval = AA_results_getEvaluationType($round);
            $combined = AA_checkCombined(0, $round);
            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                serie READ\r\n                , wettkampf READ\r\n                , resultat WRITE\r\n                , serienstart WRITE\r\n                , tempresult WRITE\r\n        ");
                // clean ranks, set all to 0
                mysql_query("UPDATE \r\n                serienstart\r\n                , serie\r\n            SET\r\n                serienstart.Rang = 0\r\n            WHERE\r\n                serienstart.xSerie = serie.xSerie\r\n            AND    serie.xRunde = {$round}");
                // Set up a temporary table to hold all results for ranking.
                mysql_query("\r\n            CREATE TABLE tempresult (\r\n                xSerienstart int(11)\r\n                , xSerie int(11)\r\n                , Leistung int(9)\r\n                , TopX int(1)\r\n                , TotalX int(2)\r\n                )\r\n               TYPE=HEAP\r\n        ");
                if (mysql_errno() > 0) {
                    // DB error
                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                } else {
                    // if this is a combined event, rank all rounds togheter
                    $roundSQL = "";
                    if ($combined) {
                        $roundSQL = "AND serie.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] . ",";
                        }
                        $roundSQL = substr($roundSQL, 0, -1) . ")";
                    } else {
                        $roundSQL = "AND serie.xRunde = {$round}";
                    }
                    // read all valid results (per athlet)
                    $result = mysql_query("\r\n                SELECT\r\n                    resultat.Leistung\r\n                    , resultat.Info\r\n                    , serienstart.xSerienstart\r\n                    , serienstart.xSerie\r\n                FROM\r\n                    resultat\r\n                    , serienstart\r\n                    , serie\r\n                WHERE resultat.xSerienstart = serienstart.xSerienstart\r\n                AND serienstart.xSerie = serie.xSerie\r\n                {$roundSQL}\r\n                AND resultat.Leistung != 0\r\n                ORDER BY\r\n                    serienstart.xSerienstart\r\n                    ,resultat.Leistung DESC\r\n            ");
                    if (mysql_errno() > 0) {
                        AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                    } else {
                        // initialize variables
                        $leistung = 0;
                        $serienstart = 0;
                        $serie = 0;
                        $topX = 0;
                        $totX = 0;
                        $ss = 0;
                        // athlete's ID
                        $tt = FALSE;
                        // top result check
                        // process every result
                        while ($row = mysql_fetch_row($result)) {
                            // new athlete: save last athlete's data
                            if ($ss != $row[2] && $ss != 0) {
                                if ($leistung != 0) {
                                    // add one row per athlete to temp table
                                    mysql_query("\r\n                                INSERT INTO tempresult\r\n                                VALUES(\r\n                                    {$serienstart}\r\n                                    , {$serie}\r\n                                    , {$leistung}\r\n                                    , {$topX}\r\n                                    , {$totX})\r\n                            ");
                                    if (mysql_errno() > 0) {
                                        // DB error
                                        AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                    }
                                }
                                // initialize variables
                                $leistung = 0;
                                $serienstart = 0;
                                $serie = 0;
                                $totX = 0;
                                $topX = 0;
                                $tt = FALSE;
                            }
                            // save data of current athlete's top result
                            if ($tt == FALSE && strstr($row[1], 'O')) {
                                $leistung = $row[0];
                                $serienstart = $row[2];
                                $serie = $row[3];
                                $topX = substr_count($row[1], 'X');
                                $tt = TRUE;
                            }
                            // count total invalid attempts
                            $totX = $totX + substr_count($row[1], 'X');
                            $ss = $row[2];
                            // keep athlete's ID
                        }
                        mysql_free_result($result);
                        // insert last pending data in temp table
                        if ($ss != 0 && $leistung != 0) {
                            mysql_query("\r\n                        INSERT INTO tempresult\r\n                        VALUES(\r\n                            {$serienstart}\r\n                            , {$serie}\r\n                            , {$leistung}\r\n                            , {$topX}\r\n                            , {$totX})\r\n                    ");
                            if (mysql_errno() > 0) {
                                // DB error
                                AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                            }
                        }
                    }
                    if ($eval == $cfgEvalType[$strEvalTypeHeat]) {
                        // eval per heat
                        $order = "xSerie ,";
                    } else {
                        // default: rank results from all heats together
                        $order = "";
                    }
                    // Read rows from temporary table ordered by performance,
                    // nbr of invalid attempts for top performance and
                    // total nbr of invalid attempts to determine ranking.
                    $result = mysql_query("\r\n                SELECT\r\n                    xSerienstart\r\n                    , xSerie\r\n                    , Leistung\r\n                    , TopX\r\n                    , TotalX\r\n                FROM\r\n                    tempresult\r\n                ORDER BY\r\n                    {$order}\r\n                    Leistung DESC\r\n                    ,TopX ASC\r\n                    ,TotalX ASC\r\n            ");
                    if (mysql_errno() > 0) {
                        // DB error
                        AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                    } else {
                        // initialize variables
                        $heat = 0;
                        $perf = 0;
                        $topX = 0;
                        $totalX = 0;
                        $i = 0;
                        $rank = 0;
                        // set rank for every athlete
                        while ($row = mysql_fetch_row($result)) {
                            if ($eval == $cfgEvalType[$strEvalTypeHeat] && $heat != $row[1]) {
                                $i = 0;
                                // restart ranking
                                $perf = 0;
                                $topX = 0;
                                $totalX = 0;
                            }
                            $j++;
                            // increment ranking
                            if ($perf != $row[2] || $topX != $row[3] || $totalX != $row[4]) {
                                $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 = $row[2];
                            $topX = $row[3];
                            $totalX = $row[4];
                        }
                        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)
                // read all starting athletes with no valid result (rank=0)
                // and add disqualification code
                $result = mysql_query("\r\n            SELECT DISTINCT\r\n                serienstart.xSerienstart\r\n            FROM\r\n                resultat\r\n                , serienstart\r\n                , serie\r\n            WHERE resultat.xSerienstart = serienstart.xSerienstart\r\n            AND serienstart.xSerie = serie.xSerie\r\n            AND serienstart.Rang = 0\r\n            AND serie.xRunde = {$round}\r\n            AND resultat.Leistung >= 0\r\n        ");
                if (mysql_errno() > 0) {
                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                } else {
                    //
                    while ($row = mysql_fetch_row($result)) {
                        // check if "disqualified" result already there
                        $res = mysql_query("\r\n                    SELECT\r\n                        xResultat\r\n                    FROM\r\n                        resultat\r\n                    WHERE xSerienstart = {$row['0']}\r\n                    AND (Leistung = " . $cfgInvalidResult['DSQ']['code'] . "OR Leistung = " . $cfgInvalidResult['NRS']['code'] . ")");
                        if (mysql_errno() > 0) {
                            // DB error
                            AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                        } else {
                            if (mysql_num_rows($res) <= 0) {
                                mysql_query("\r\n                            INSERT INTO\r\n                                resultat\r\n                            SET\r\n                                Leistung = " . $cfgInvalidResult['NRS']['code'] . "\r\n                                , Info = '{$cfgResultsHighOut}'\r\n                                , xSerienstart = {$row['0']}\r\n                        ");
                                if (mysql_errno() > 0) {
                                    // DB error
                                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                }
                            }
                            mysql_free_result($res);
                        }
                    }
                    mysql_free_result($result);
                }
                mysql_query("UNLOCK TABLES");
            }
            // ET DB error (drop temp table)
            AA_results_setNotStarted($round);
            // update athletes with no result
            AA_utils_changeRoundStatus($round, $cfgRoundStatus['results_done']);
            if (!empty($GLOBALS['AA_ERROR'])) {
                AA_printErrorMsg($GLOBALS['AA_ERROR']);
            }
        }
        //
        // calculate ranking points if needed
        //
        if ($_GET['arg'] == 'results_done' || $_POST['arg'] == 'save_rank') {
            AA_utils_calcRankingPoints($round);
        }
        if ($_POST['arg'] == 'save_remark') {
            AA_utils_saveRemark($_POST['item'], $_POST['remark'], $_POST['xAthlete']);
        }
        //
        // 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 && $prog_mode != 2) {
                $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']) {
                            AA_heats_printNewStart($presets['event'], $round, "event_results.php");
                            // display all athletes
                            $result = mysql_query("\r\n            SELECT rt.Name\r\n                , rt.Typ\r\n                , s.xSerie\r\n                , s.Bezeichnung\r\n                , ss.xSerienstart\r\n                , ss.Position\r\n                , ss.Rang\r\n                , a.Startnummer\r\n                , at.Name\r\n                , at.Vorname\r\n                , at.Jahrgang\r\n                , if('" . $svm . "', t.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo))   \r\n                , LPAD(s.Bezeichnung,5,'0') as heatid\r\n                , rs.xResultat\r\n                , rs.Leistung\r\n                , rs.Info\r\n                , at.Land\r\n                , ss.Bemerkung\r\n                , at.xAthlet\r\n                , r.xRunde \r\n                , ss.RundeZusammen  \r\n            FROM\r\n                runde AS r\r\n                , serie AS s\r\n                , serienstart AS ss\r\n                , start AS st\r\n                , anmeldung AS a\r\n                , athlet AS at\r\n                , verein AS v\r\n            LEFT JOIN team AS t ON(a.xTeam = t.xTeam) \r\n            LEFT JOIN rundentyp AS rt\r\n                ON rt.xRundentyp = r.xRundentyp\r\n            LEFT JOIN resultat AS rs\r\n                ON rs.xSerienstart = ss.xSerienstart\r\n            WHERE r.xRunde = {$round}\r\n            AND s.xRunde = r.xRunde\r\n            AND ss.xSerie = s.xSerie\r\n            AND st.xStart = ss.xStart\r\n            AND a.xAnmeldung = st.xAnmeldung\r\n            AND at.xAthlet = a.xAthlet\r\n            AND v.xVerein = at.xVerein\r\n            ORDER BY\r\n                heatid\r\n                , ss.Position\r\n                , rs.xResultat DESC\r\n        ");
                            if (mysql_errno() > 0) {
                                // DB error
                                AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                            } else {
                                AA_results_printMenu($round, $status, $prog_mode, 'high');
                                // initialize variables
                                $a = 0;
                                $h = 0;
                                $i = 0;
                                if (!empty($_GET['athlete'])) {
                                    $_POST['athlete'] = $_GET['athlete'];
                                }
                                if (empty($_POST['athlete']) || mysql_num_rows($result) < $_POST['athlete']) {
                                    $_POST['athlete'] = 1;
                                    // focus to first athlete
                                }
                                $rowclass = 'odd';
                                if ($cfgProgramMode[$prog_mode]['name'] == $strProgramModeBackoffice) {
                                    $focus = 0;
                                    // keep focus on this athlete if Backoffice Mode
                                } else {
                                    $focus = 1;
                                    // focus on next athlete if Field Mode
                                }
                                ?>
<p/>

<table class='dialog'>
<?php 
                                $btn = new GUI_Button('', '');
                                // create button object
                                while ($row = mysql_fetch_row($result)) {
                                    if ($row[20] > 0) {
                                        $singleRound = $row[20];
                                    } else {
                                        $singleRound = $row[19];
                                    }
                                    // terminate last row if new athlete and not first item
                                    if ($a != $row[4] && $i != 0) {
                                        if ($_POST['athlete'] == $i + 1 && $cfgProgramMode[$prog_mode]['name'] == $strProgramModeField) {
                                            if ($row[15] == 'XXX' && !$click) {
                                                $_POST['athlete'] = $_POST['athlete'] + 1;
                                            }
                                        }
                                        if ($_POST['athlete'] == $i) {
                                            echo "<td>";
                                            $btn->set("event_results.php?arg=del_start&item={$a}&round={$round}", $strDelete);
                                            $btn->printButton();
                                            echo "</td>";
                                        }
                                        echo "</tr>";
                                    }
                                    /*
                                     *  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']) {
                                            $c = 1;
                                            // 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 7 + $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='singleRound' value='<?php 
                                        echo $singleRound;
                                        ?>
' />    
            <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']) {
                                            ?>
        <th class='dialog'><?php 
                                            echo $strRank;
                                            ?>
</th>
<?php 
                                        }
                                        ?>
        <th class='dialog' ><?php 
                                        echo $strResultRemark;
                                        ?>
</th>         
        <th class='dialog' colspan='2'><?php 
                                        echo $strPerformance;
                                        ?>
</th>  
    </tr>
<?php 
                                    }
                                    // ET new heat
                                    /*
                                     * Athlete data lines
                                     */
                                    if ($a != $row[4]) {
                                        $a = $row[4];
                                        // keep athlete ID
                                        $i++;
                                        // increment athlete counter
                                        $l = 0;
                                        // reset result counter
                                        if ($_POST['athlete'] == $i) {
                                            // active item
                                            $rowclass = 'active';
                                        } else {
                                            if ($row[5] % 2 == 0) {
                                                // even row numer
                                                $rowclass = 'even';
                                            } else {
                                                // odd row number
                                                $rowclass = 'odd';
                                            }
                                        }
                                        if ($rowclass == 'active') {
                                            ?>
    <tr class='active'>
<?php 
                                        } else {
                                            ?>
    <tr class='<?php 
                                            echo $rowclass;
                                            ?>
'
        onclick='selectAthlete(<?php 
                                            echo $i;
                                            ?>
)'>
<?php 
                                        }
                                        ?>
        <td class='forms_right'><?php 
                                        echo $row[5];
                                        ?>
</td>
        <td class='forms_right'><?php 
                                        echo $row[7];
                                        /* start nbr */
                                        ?>
</td>
        <td nowrap><?php 
                                        echo $row[8] . " " . $row[9];
                                        /* name */
                                        ?>
</td>
        <td class='forms_ctr'><?php 
                                        echo AA_formatYearOfBirth($row[10]);
                                        ?>
</td>
        <td><?php 
                                        echo $row[16] != '' && $row[16] != '-' ? $row[16] : '&nbsp;';
                                        ?>
</td>
        <td nowrap><?php 
                                        echo $row[11];
                                        /* club */
                                        ?>
</td>
   
<?php 
                                        if ($status == $cfgRoundStatus['results_done']) {
                                            if ($_POST['athlete'] == $i) {
                                                ?>
        <form action='event_results.php' method='post'
            name='rank'>
        <td>
            <input type='hidden' name='arg' value='save_rank' />
            <input type='hidden' name='round' value='<?php 
                                                echo $round;
                                                ?>
' />
             <input type='hidden' name='singleRound' value='<?php 
                                                echo $singleRound;
                                                ?>
' />    
            <input type='hidden' name='athlete' value='<?php 
                                                echo $i + $focus;
                                                ?>
' />
            <input type='hidden' name='item' value='<?php 
                                                echo $row[4];
                                                ?>
' />
            <input class='nbr' type='text' name='rank' maxlength='3'
                value='<?php 
                                                echo $row[6];
                                                ?>
' onChange='document.rank.submit()' />
        </td>
        </form>
<?php 
                                            } else {
                                                echo "<td>" . $row[6] . "</td>";
                                            }
                                            echo "<td>" . $row[17] . "</td>";
                                        } else {
                                            ?>
 
                        

<form action='event_results.php' method='post'
            name='remark_<?php 
                                            echo $i;
                                            ?>
'>
        <td>
            <input type='hidden' name='arg' value='save_remark' />
            <input type='hidden' name='round' value='<?php 
                                            echo $round;
                                            ?>
' />
             <input type='hidden' name='singleRound' value='<?php 
                                            echo $singleRound;
                                            ?>
' />    
            <input type='hidden' name='athlete' value='<?php 
                                            echo $i + $focus;
                                            ?>
' />
            <input type='hidden' name='item' value='<?php 
                                            echo $row[4];
                                            ?>
' />
            <input type='hidden' name='xAthlete' value='<?php 
                                            echo $row[18];
                                            ?>
' />    
            <input class='textshort' type='text' name='remark' maxlength='5'
                value='<?php 
                                            echo $row[17];
                                            ?>
' onchange='document.remark_<?php 
                                            echo $i;
                                            ?>
.submit()' />
        </td>
        </form>  
       
  
      
                   <?php 
                                        }
                                    }
                                    // ET new athlete
                                    $new_perf = '';
                                    if ($_POST['athlete'] == $i) {
                                        if (is_null($row[14])) {
                                            // no result yet: show form
                                            $last_perf = 0;
                                        } else {
                                            $last_perf = $row[14];
                                        }
                                        $item = '';
                                        if ($l == 0) {
                                            // read all performances achieved in current heat and
                                            // better than last entered performance
                                            if ($cfgProgramMode[$prog_mode]['name'] == $strProgramModeField) {
                                                if (in_array($row[15], $cfgResultsHighStayDecentral)) {
                                                    $new_perf = AA_formatResultMeter($last_perf);
                                                    $new_info = $row[15];
                                                    $item = $row[13];
                                                } else {
                                                    $new_perf = getNextHeight($row[2], $last_perf);
                                                    $new_info = '';
                                                }
                                            } else {
                                                if (in_array($row[15], $cfgResultsHighStay)) {
                                                    $new_perf = AA_formatResultMeter($last_perf);
                                                    $new_info = $row[15];
                                                    $item = $row[13];
                                                } else {
                                                    $new_perf = getNextHeight($row[2], $last_perf);
                                                    $new_info = '';
                                                }
                                            }
                                            ?>
        <form action='event_results.php' method='post'
            name='perf'>
        <td nowrap colspan='2'> 
            <input type='hidden' name='arg' value='save_res' />
            <input type='hidden' name='round' value='<?php 
                                            echo $round;
                                            ?>
' />
             <input type='hidden' name='singleRound' value='<?php 
                                            echo $singleRound;
                                            ?>
' />    
            <input type='hidden' name='athlete' value='<?php 
                                            echo $i + $focus;
                                            ?>
' />
            <input type='hidden' name='start' value='<?php 
                                            echo $row[4];
                                            ?>
' />
             <input type='hidden' name='xSerie' value='<?php 
                                            echo $row[2];
                                            ?>
' />  
            <input type='hidden' name='item' value='<?php 
                                            echo $item;
                                            ?>
' />
            <input class='perfheight' type='text' name='perf' maxlength='5'
                value='<?php 
                                            echo $new_perf;
                                            ?>
'
                    onChange='checkSubmit(document.perf)' />  
            <input class='texttiny' type='text' name='attempts' maxlength='3'
                value='<?php 
                                            echo $new_info;
                                            ?>
'
                    onChange='document.perf.submit()' onBlur='document.perf.submit()' />
        </td>
        </form>   
        
        
                        <?php 
                                        }
                                        if (is_null($row[14]) == false && empty($item)) {
                                            // next height
                                            ?>
        <td nowrap>
            <?php 
                                            echo AA_formatResultMeter($row[14]) . "<br/>( {$row['15']} )";
                                            ?>
        </td>
        <td>
                        <?php 
                                            $btn = new GUI_Button("event_results.php?arg=delete&round={$round}&item={$row['13']}&athlete={$i}", "X");
                                            $btn->printButton();
                                            ?>
        </td>
                        <?php 
                                        }
                                        $l++;
                                    } else {
                                        if (is_null($row[14]) == false) {
                                            echo "<td colspan='2' nowrap>" . AA_formatResultMeter($row[14]) . " ( {$row['15']} )</td>";
                                        }
                                    }
                                }
                                if ($a != 0) {
                                    if ($_POST['athlete'] == $i) {
                                        echo "<td>";
                                        $btn->set("event_results.php?arg=del_start&item={$a}&round={$round}", $strDelete);
                                        $btn->printButton();
                                        echo "</td>";
                                    }
                                    echo "</tr>";
                                }
                                ?>
           
            
            
            
</table>
  
                 
            <?php 
                                mysql_free_result($result);
                            }
                            // ET DB error
                        }
                    }
                }
            } else {
                if ($round > 0 && $prog_mode == 2) {
                    $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']) {
                                AA_heats_printNewStart($presets['event'], $round, "event_results.php");
                                $ph = 0;
                                // find max height per athlete
                                $sql_max_h = "SELECT \r\n                 LPAD(s.Bezeichnung,5,'0') as heatid\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                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                LEFT JOIN verein AS v ON (v.xVerein = at.xVerein)\r\n                LEFT JOIN team AS t ON(a.xTeam = t.xTeam) \r\n                LEFT JOIN rundentyp AS rt ON rt.xRundentyp = r.xRundentyp\r\n                LEFT JOIN resultat AS rs ON rs.xSerienstart = ss.xSerienstart\r\n            WHERE r.xRunde = {$round}              \r\n            GROUP BY ss.xSerienstart\r\n            ORDER BY\r\n                heatid\r\n                , ss.Position DESC\r\n                , rs.xResultat";
                                $res_max_h = mysql_query($sql_max_h);
                                if (mysql_errno() > 0) {
                                    // DB error
                                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                } else {
                                    $ph = 0;
                                    //  height column
                                    $starts = 0;
                                    // all started athletes
                                    while ($row_max_h = mysql_fetch_row($res_max_h)) {
                                        $starts++;
                                        if ($row_max_h[1] > $ph) {
                                            $ph = $row_max_h[1];
                                        }
                                    }
                                }
                                // fill last infos (included previous info by 'XXX') in an array
                                $sql_info = "SELECT rt.Name\r\n                , rt.Typ\r\n                , s.xSerie\r\n                , s.Bezeichnung\r\n                , ss.xSerienstart\r\n                , ss.Position\r\n                , ss.Rang\r\n                , a.Startnummer\r\n                , at.Name\r\n                , at.Vorname\r\n                , at.Jahrgang\r\n                , if('" . $svm . "', t.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo))   \r\n                , LPAD(s.Bezeichnung,5,'0') as heatid\r\n                , rs.xResultat\r\n                , rs.Leistung\r\n                , rs.Info\r\n                , at.Land\r\n                , ss.Bemerkung\r\n                , at.xAthlet\r\n                , r.xRunde \r\n                , ss.RundeZusammen  \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                LEFT JOIN verein AS v ON (v.xVerein = at.xVerein)\r\n                LEFT JOIN team AS t ON(a.xTeam = t.xTeam) \r\n                LEFT JOIN rundentyp AS rt ON rt.xRundentyp = r.xRundentyp\r\n                LEFT JOIN resultat AS rs ON rs.xSerienstart = ss.xSerienstart  \r\n            WHERE r.xRunde = {$round}      \r\n              ORDER BY\r\n                heatid\r\n                , ss.Position \r\n                , rs.xResultat\r\n                \r\n                ";
                                $res_info = mysql_query($sql_info);
                                if (mysql_errno() > 0) {
                                    // DB error
                                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                } else {
                                    $c = 0;
                                    $arr_info = array();
                                    $arr_info_remark = array();
                                    // previous info 'p'
                                    $count_results = 0;
                                    $count_ends = 0;
                                    // athletes with results 'XXX'
                                    while ($row_info = mysql_fetch_row($res_info)) {
                                        if ($row_info[4] != $a && $c > 0) {
                                            if (!empty($keep_info)) {
                                                if ($c == $ph) {
                                                    $arr_info[] = $keep_info;
                                                    $arr_info_remark[] = '';
                                                    $count_results++;
                                                } else {
                                                    if ($keep_info == 'XXX') {
                                                        $arr_info[] = $keep_info;
                                                        $arr_info_remark[] = 'p';
                                                        // previous
                                                        $count_results++;
                                                    } else {
                                                        $arr_info[] = '';
                                                        $arr_info_remark[] = '';
                                                        $count_results++;
                                                    }
                                                }
                                                $c = 0;
                                            }
                                        }
                                        $c++;
                                        if ($row_info[15] == 'XXX') {
                                            $count_ends++;
                                        }
                                        $a = $row_info[4];
                                        $keep_info = $row_info[15];
                                    }
                                    if (!empty($keep_info)) {
                                        if ($c == $ph) {
                                            $arr_info[] = $keep_info;
                                            $arr_info_remark[] = '';
                                            $count_results++;
                                        } else {
                                            if ($keep_info == 'XXX') {
                                                $arr_info[] = $keep_info;
                                                $arr_info_remark[] = 'p';
                                                // previous
                                                $count_results++;
                                            } else {
                                                $arr_info[] = '';
                                                $arr_info_remark[] = '';
                                                $count_results++;
                                            }
                                        }
                                    }
                                }
                                // array for infos to jump
                                $arr_info_toJump = array();
                                foreach ($arr_info as $key => $val) {
                                    if (!in_array($val, $cfgResultsHighStayDecentralEnd)) {
                                        $arr_info_toJump[$key] = $val;
                                    }
                                }
                                // find out new column (= newHight )
                                $sql_hight = "SELECT    \r\n                LPAD(s.Bezeichnung,5,'0') as heatid                 \r\n                , rs.Leistung\r\n                , rs.Info                   \r\n                , d.Code  \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                LEFT JOIN verein AS v ON (v.xVerein = at.xVerein)\r\n                LEFT JOIN team AS t ON(a.xTeam = t.xTeam) \r\n                LEFT JOIN rundentyp AS rt ON rt.xRundentyp = r.xRundentyp\r\n                LEFT JOIN resultat AS rs ON rs.xSerienstart = ss.xSerienstart\r\n                LEFT JOIN wettkampf AS w ON (w.xWettkampf = r.xWettkampf)  \r\n                LEFT JOIN disziplin AS d ON (d.xDisziplin = w.xDisziplin)   \r\n            WHERE r.xRunde = {$round}                 \r\n              ORDER BY\r\n                heatid\r\n                , rs.Leistung DESC\r\n                , ss.Position ASC\r\n                ";
                                $res_hight = mysql_query($sql_hight);
                                $e = 0;
                                // count performance when is finished with this high
                                $z = 0;
                                $first = true;
                                $disCode = 0;
                                while ($row_hight = mysql_fetch_row($res_hight)) {
                                    if ($perf_keep != $row_hight[1] && !$first) {
                                        $z++;
                                        if ($z > 1) {
                                            break;
                                        } else {
                                            $e_keep = $e;
                                            $e = 0;
                                        }
                                    }
                                    $first = false;
                                    if (in_array($row_hight[2], $cfgResultsHighStayDecentralEnd)) {
                                        if ($row_hight[2] != 'XXX') {
                                            $e++;
                                        }
                                    }
                                    $perf_keep = $row_hight[1];
                                    $disCode = $row_hight[3];
                                }
                                $newHight = false;
                                if (is_null($e_keep)) {
                                    $e_keep = $e;
                                }
                                if ($e_keep == $starts - $count_ends) {
                                    $newHight = true;
                                }
                                if (empty($_POST)) {
                                    if ($ph > $max) {
                                        $max = $ph;
                                    }
                                }
                                if (empty($_POST)) {
                                    $y = 0;
                                    while ($row = mysql_fetch_row($res_c_h)) {
                                        $name = "hight_" . $y;
                                        $hiddenName = "hiddeHight_" . $y;
                                        $performance_new = AA_formatResultMeter($row[0]);
                                        $_POST[$name] = $performance_new;
                                        $_POST[$hiddenName] = $performance_new;
                                        $y++;
                                    }
                                }
                                // found active athlete
                                $a_activ = 0;
                                $flen = 0;
                                $f_len_keep = 0;
                                $r_f_len = 0;
                                $r_f_len_keep = 0;
                                $a_activ_set = false;
                                $f = 0;
                                $reset_activ = false;
                                for ($r = $starts - 1; $r >= 0; $r--) {
                                    if ($arr_info[$r] == '' || $arr_info_remark[$r] == 'p') {
                                        $f++;
                                    } else {
                                        if ($f > 0) {
                                            $a_activ = $r + 2;
                                            for ($j = $a_activ - 1; $j < $starts; $j++) {
                                                if ($arr_info_remark[$a_activ - 1] == 'p') {
                                                    $a_activ++;
                                                }
                                            }
                                            $a_activ_set = true;
                                        }
                                        if ($a_activ > $starts) {
                                            $a_activ_set = false;
                                            $reset_activ = true;
                                        }
                                        break;
                                    }
                                }
                                if (!$a_activ_set) {
                                    if ($newHight) {
                                        for ($r = 0; $r < $starts; $r++) {
                                            if ($arr_info[$r] != 'XXX') {
                                                $a_activ = $r + 1;
                                                $a_activ_set = true;
                                                break;
                                            }
                                        }
                                        if (!$a_activ_set) {
                                            $a_activ = 1;
                                        }
                                    } elseif ($reset_activ) {
                                        $val_keep = '';
                                        foreach ($arr_info_toJump as $key => $val) {
                                            if (strlen($val) == 1) {
                                                $arr_info_toJump_1[$key] = $val;
                                            } elseif (strlen($val) == 2) {
                                                $arr_info_toJump_2[$key] = $val;
                                            }
                                        }
                                        if (count($arr_info_toJump_1) > 0) {
                                            foreach ($arr_info_toJump_1 as $key => $val) {
                                                $a_activ = $key + 1;
                                                break;
                                            }
                                        } else {
                                            foreach ($arr_info_toJump_2 as $key => $val) {
                                                $a_activ = $key + 1;
                                                break;
                                            }
                                        }
                                    } else {
                                        for ($r = $starts - 1; $r >= 0; $r--) {
                                            if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                $athleteValidFirst = false;
                                            } else {
                                                $f_len = strlen($arr_info[$r]);
                                                $r_f_len = $r;
                                                if ($f_len_keep > 0) {
                                                    if ($f_len_keep < $f_len) {
                                                        $a_activ = $r_f_len_keep + 1;
                                                        break;
                                                    } elseif ($f_len_keep = $f_len) {
                                                        $a_activ = $r_f_len + 1;
                                                    } elseif ($f_len_keep > $f_len) {
                                                        break;
                                                    }
                                                } else {
                                                    $a_activ = $r_f_len + 1;
                                                }
                                                $f_len_keep = $f_len;
                                                $r_f_len_keep = $r_f_len;
                                            }
                                        }
                                    }
                                }
                                if (is_null($_POST['athlete'])) {
                                    $_POST['athlete'] = $a_activ;
                                }
                                $aClick = false;
                                if (isset($_POST['result'])) {
                                    // this means that user makes a click to a athlete
                                    $aClick = true;
                                }
                                if (isset($_GET['arg']) && $_GET['arg'] == 'delete') {
                                    $aClick = true;
                                }
                                $athleteValidAfter = true;
                                if ($_POST['athlete'] >= 1 && !$aClick) {
                                    $athleteValidAfter = true;
                                    if ($starts != $count_ends) {
                                        if (count($arr_info) == $starts) {
                                            for ($r = $starts - 1; $r >= 0; $r--) {
                                                if ($r < $_POST['athlete'] - 1) {
                                                    break;
                                                }
                                                if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                    $athleteValidAfter = false;
                                                } else {
                                                    $athleteValidAfter = true;
                                                    break;
                                                }
                                            }
                                            if ($_POST['athlete'] > $starts) {
                                                $athleteValidAfter = false;
                                            }
                                        }
                                    } else {
                                        $athleteValidAfter = false;
                                        if (!$aClick) {
                                            $_POST['athlete'] = 1;
                                            $a_activ = 1;
                                        }
                                    }
                                    if (!$athleteValidAfter && !$aClick && !$newHight) {
                                        // set to first athlete when no valid athletes after
                                        $_POST['athlete'] = 1;
                                    }
                                }
                                // find out first valid athlete
                                $athleteValidFirst = true;
                                $a_first = 0;
                                if ($_POST['athlete'] >= 1 && !$aClick) {
                                    $athleteValidFirst = true;
                                    if ($starts != $count_ends) {
                                        if (count($arr_info) == $starts) {
                                            for ($r = 0; $r < $starts; $r++) {
                                                if ($arr_info[$r] == 'XXX') {
                                                    $athleteValidFirst = false;
                                                } else {
                                                    $athleteValidFirst = true;
                                                    $a_first = $r + 1;
                                                    break;
                                                }
                                            }
                                        }
                                    } else {
                                        $athleteValidAfter = false;
                                        if (!$aClick) {
                                            $_POST['athlete'] = 1;
                                            $a_activ = 1;
                                        }
                                    }
                                    if ($a_first > 0 && !$athleteValidAfter && !$click) {
                                        $_POST['athlete'] = $a_first;
                                    }
                                }
                                if (isset($_POST['result']) || $aClick) {
                                    // this means that user makes a click to a athlete
                                    $a_activ = $_POST['athlete'];
                                }
                                if ($starts == $count_ends && !$aClick) {
                                    $_POST['athlete'] = 1;
                                    $a_activ = 1;
                                }
                                if (mysql_errno() > 0) {
                                    // DB error
                                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                } else {
                                    AA_results_printMenu($round, $status, $prog_mode, 'high');
                                    // initialize variables
                                    $a = 0;
                                    $h = 0;
                                    $i = 0;
                                    if (!empty($_GET['athlete'])) {
                                        $_POST['athlete'] = $_GET['athlete'];
                                    }
                                    if (empty($_POST['athlete']) || $starts < $_POST['athlete']) {
                                        $_POST['athlete'] = 1;
                                        // focus to first athlete
                                    }
                                    $rowclass = 'odd';
                                    if ($cfgProgramMode[$prog_mode]['name'] == $strProgramModeBackoffice) {
                                        $focus = 0;
                                        // keep focus on this athlete if Backoffice Mode
                                    } else {
                                        $focus = 1;
                                        // focus on next athlete if Field Mode
                                    }
                                    ?>
<p/>

<table class='dialog'>
<?php 
                                    $l = 0;
                                    $newAthl = false;
                                    $flagField = false;
                                    $skip = false;
                                    $s = 0;
                                    $s_keep = 0;
                                    $k = 0;
                                    $p = 0;
                                    // all pass
                                    $btn = new GUI_Button('', '');
                                    // create button object
                                    $flagField = false;
                                    $res_info = mysql_query($sql_info);
                                    while ($row = mysql_fetch_row($res_info)) {
                                        if ($a != $row[4] && $i != 0) {
                                            // new athlete
                                            $k = 0;
                                            if ($s >= $s_keep) {
                                                $s_keep = $s;
                                            }
                                            $s = 0;
                                        }
                                        $p++;
                                        $k++;
                                        $s++;
                                        if ($row[15] == 'XXX') {
                                            $skip = true;
                                        } else {
                                            if (in_array($row[15], $cfgResultsHighStayDecentralEnd) && $ph == $k && !$newHight) {
                                                $skip = true;
                                            } else {
                                                $skip = false;
                                            }
                                        }
                                        if ($row[20] > 0) {
                                            $singleRound = $row[20];
                                        } else {
                                            $singleRound = $row[19];
                                        }
                                        // terminate last row if new athlete and not first item
                                        if ($a != $row[4] && $i != 0) {
                                            $athleteValid = true;
                                            $athleteValidAfter = true;
                                            if ($starts != $count_ends) {
                                                if (count($arr_info) == $starts) {
                                                    for ($r = $starts - 1; $r >= 0; $r--) {
                                                        if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                            $athleteValid = false;
                                                        } else {
                                                            $athleteValid = true;
                                                            break;
                                                        }
                                                    }
                                                    for ($r = $starts - 1; $r >= 0; $r--) {
                                                        if ($r < $_POST['athlete'] - 1) {
                                                            break;
                                                        }
                                                        if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                            $athleteValidAfter = false;
                                                        } else {
                                                            $athleteValidAfter = true;
                                                            break;
                                                        }
                                                    }
                                                }
                                            } else {
                                                $athleteValid = false;
                                                $athleteValidAfter = false;
                                                if (!$aClick) {
                                                    $_POST['athlete'] = 1;
                                                    $a_activ = 1;
                                                }
                                            }
                                            if ($_POST['athlete'] == $i || !$athleteValid && $newHight && $k != 1 || $aClick && $a_activ == $i) {
                                                if (!$flagField) {
                                                    ?>
                                <form action='event_results.php' method='post'
                                            name='perf'>
                                <td nowrap colspan='2'> 
                                            <input type='hidden' name='arg' value='save_res' />
                                            <input type='hidden' name='round' value='<?php 
                                                    echo $round;
                                                    ?>
' />
                                             <input type='hidden' name='singleRound' value='<?php 
                                                    echo $singleRound;
                                                    ?>
' />    
                                            <input type='hidden' name='athlete' value='<?php 
                                                    echo $i + $focus;
                                                    ?>
' />
                                            <input type='hidden' name='start' value='<?php 
                                                    echo $a;
                                                    ?>
' />                                              
                                            <input type='hidden' name='item' value='<?php 
                                                    echo $item;
                                                    ?>
' />
                                            <input class='perfheight' type='hidden' name='perf' maxlength='5'    
                                               value='<?php 
                                                    echo $new_perf;
                                                    ?>
'
                                                     />
                                            <?php 
                                                    foreach ($_POST as $key => $val) {
                                                        $arr_key = explode('_', $key);
                                                        $hiddenName = $arr_key[0] . "_" . $arr_key[1];
                                                        ?>
                                                 <input type='hidden' name='<?php 
                                                        echo $hiddenName;
                                                        ?>
' value='<?php 
                                                        echo $val;
                                                        ?>
' /> 
                                                 <?php 
                                                    }
                                                    ?>
         
                                            <input class='texttiny' type='text' name='attempts' maxlength='3'  onfocus="this.value = '<?php 
                                                    echo $new_info;
                                                    ?>
'"
                                                value='<?php 
                                                    echo $new_info;
                                                    ?>
' />
                                             <button type='button' name="butt" onclick="document.perf.submit()">ok</button>
                                </td>
                                </form>                                              
                                          
                               <?php 
                                                    $flagField = true;
                                                    echo "<td colspan='31'>&nbsp;";
                                                    echo "</td>";
                                                    echo "<td>";
                                                    $btn->set("event_results.php?arg=del_start&item={$a}&round={$round}", $strDelete);
                                                    $btn->printButton();
                                                    echo "</td>";
                                                }
                                            }
                                            echo "</tr>";
                                        }
                                        /*
                                         *  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']) {
                                                $c = 1;
                                                // 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 7 + $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='singleRound' value='<?php 
                                            echo $singleRound;
                                            ?>
' />    
            <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> 
        <?php 
                                            if (isset($_POST['max'])) {
                                                $colspanPerf = $_POST['max'] * 2 + 2;
                                            } else {
                                                $colspanPerf = $cfgCountHeight * 2 + 2;
                                            }
                                            ?>
  
            <th colspan="<?php 
                                            echo $colspanPerf;
                                            ?>
"><?php 
                                            echo $strPerformance;
                                            ?>
</th>  
         <?php 
                                            ?>
        </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>  
        <th class='dialog'><?php 
                                            echo $strRank;
                                            ?>
</th>   
        <th class='dialog' ><?php 
                                            echo $strResultRemark;
                                            ?>
</th>    
         
        <?php 
                                            $height_start = $cfgHeightStartJump;
                                            // default jump
                                            if ($disCode == '310') {
                                                // jump
                                                $height_start = $cfgHeightStartJump;
                                            } elseif ($disCode == '320') {
                                                $height_start = $cfgHeightStartPole;
                                                // pole
                                            }
                                            ?>
        <form action='event_results.php' method='post' name='hight_id'> 
        <input type='hidden' name='arg' value='save_height' />
        <input type='hidden' name='round' value='<?php 
                                            echo $round;
                                            ?>
' />
        <input type='hidden' name='heat' value='<?php 
                                            echo $row[2];
                                            ?>
' />  
        <input type='hidden' name='singleRound' value='<?php 
                                            echo $singleRound;
                                            ?>
' />          
                  
        <?php 
                                            $count_height = AA_checkHeight($round, $row[2]);
                                            $arr_height = array();
                                            if ($count_height > 0) {
                                                $max = $count_height;
                                                $sql = "SELECT h.Hoehe \r\n                    FROM \r\n                         hoehe AS h\r\n                         LEFT JOIN runde AS r ON (r.xRunde = h.xRunde)\r\n                         LEFT JOIN wettkampf AS w ON (w.xWettkampf = r.xWettkampf) \r\n                    WHERE \r\n                         h.xRunde = " . $round . " \r\n                         AND h.xSerie = " . $row[2] . " \r\n                         AND w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n                         ORDER BY hoehe";
                                                $res = mysql_query($sql);
                                                if (mysql_errno() > 0) {
                                                    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                                } else {
                                                    $g = 0;
                                                    while ($row_height = mysql_fetch_row($res)) {
                                                        $arr_height[] = $row_height[0];
                                                        $height = AA_formatResultMeter($row_height[0]);
                                                        $dis = '';
                                                        // disable the hight done
                                                        if ($newHight) {
                                                            $ph_vgl = $ph - 1;
                                                            if ($g <= $ph_vgl) {
                                                                $dis = 'disabled="disabled"';
                                                            }
                                                        } else {
                                                            $ph_vgl = ceil($ph - 1);
                                                            if ($g <= $ph_vgl) {
                                                                $dis = 'disabled="disabled"';
                                                            }
                                                            if ($count_results == 0 && $g == 0) {
                                                                $dis = '';
                                                            }
                                                        }
                                                        ?>
   
                                   
                            <input class='perfheight' type='hidden' name='hiddenHeight_<?php 
                                                        echo $g;
                                                        ?>
' maxlength='5' value='<?php 
                                                        echo $height;
                                                        ?>
'/>
                            <th class='dialog' colspan='2'><input class='perfheight' type='text' name='hight_<?php 
                                                        echo $g;
                                                        ?>
' maxlength='5'
                                value='<?php 
                                                        echo $height;
                                                        ?>
' onchange='document.hight_id.submit()' <?php 
                                                        echo $dis;
                                                        ?>
 /></th>   
                           
                            <?php 
                                                        $g++;
                                                    }
                                                }
                                            } else {
                                                $max = $cfgCountHeight;
                                                for ($g = 0; $g < $cfgCountHeight; $g++) {
                                                    $_POST['start'] = 0;
                                                    $height_start_tmp = new PerformanceAttempt($height_start);
                                                    $height_start_tmp = $height_start_tmp->getPerformance();
                                                    $arr_height[] = $height_start_tmp;
                                                    AA_setHeight($height_start_tmp, $round, $row[2], '');
                                                    ?>
     
                                   
                        <input class='perfheight' type='hidden' name='hiddenHeight_<?php 
                                                    echo $g;
                                                    ?>
' maxlength='5' value='<?php 
                                                    echo sprintf("%.2f", $height_start);
                                                    ?>
'/>
                            <th class='dialog' colspan='2'><input class='perfheight' type='text' name='hight_<?php 
                                                    echo $g;
                                                    ?>
' maxlength='5'
                                value='<?php 
                                                    echo sprintf("%.2f", $height_start);
                                                    ?>
' onchange='document.hight_id.submit()' /></th>
                          
                        <?php 
                                                    if ($disCode == '310') {
                                                        // jump
                                                        $height_start += $cfgHeightDiffJump;
                                                    } elseif ($disCode == '320') {
                                                        $height_start += $cfgHeightDiffPole;
                                                        // pole
                                                    } else {
                                                        $height_start += $cfgHeightDiffJump;
                                                    }
                                                }
                                            }
                                            ?>
  
                    
                <input class='perfheight' type='hidden' name='hiddenHeight_<?php 
                                            echo $g;
                                            ?>
' maxlength='5' value=''/> 
                    <th class='dialog' colspan='2'><input class='perfheight' type='text' name='hight_<?php 
                                            echo $max;
                                            ?>
' maxlength='5'
                        value='' onchange='document.hight_id.submit()' /></th>   
                <input type='hidden' name='max' value='<?php 
                                            echo $max;
                                            ?>
' />  
                <input type='hidden' name='disCode' value='<?php 
                                            echo $disCode;
                                            ?>
' />  
                 </form>   
                 
    </tr>
<?php 
                                        }
                                        // ET new heat
                                        /*
                                         * Athlete data lines   
                                         */
                                        if ($newAthl) {
                                            if ($k == $ph) {
                                                // k = results per athlete  ph = hight column
                                                $athleteValid = true;
                                                $athleteValidAfter = true;
                                                if ($starts != $count_ends) {
                                                    if (count($arr_info) == $starts) {
                                                        for ($r = $starts - 1; $r >= 0; $r--) {
                                                            if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                                $athleteValid = false;
                                                            } else {
                                                                $athleteValid = true;
                                                                break;
                                                            }
                                                        }
                                                        for ($r = $starts - 1; $r >= 0; $r--) {
                                                            if ($r < $_POST['athlete'] - 1) {
                                                                break;
                                                            }
                                                            if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                                $athleteValidAfter = false;
                                                            } else {
                                                                $athleteValidAfter = true;
                                                                break;
                                                            }
                                                        }
                                                    }
                                                } else {
                                                    $athleteValid = false;
                                                    $athleteValidAfter = false;
                                                    if (!$aClick) {
                                                        $_POST['athlete'] = 1;
                                                        $a_activ = 1;
                                                    }
                                                }
                                                if (!$athleteValid) {
                                                    $l = 1;
                                                    if (!$click) {
                                                        if ($a_first == 0) {
                                                            $_POST['athlete'] = 1;
                                                            $l = 0;
                                                        }
                                                    }
                                                }
                                            }
                                            if (in_array($row[15], $cfgResultsHighStayDecentralNotPassed)) {
                                                // find O (example: O, XO , XXO )
                                                $l = 0;
                                                // reset result counter
                                                $newAthl = false;
                                            } else {
                                                if (is_null($row[15])) {
                                                    $l = 0;
                                                    $newAthl = false;
                                                } else {
                                                    if (in_array($row[15], $cfgResultsHighStayDecentralEnd) && $_POST['athlete'] == $i && $skip) {
                                                        if ($athleteValidAfter && !$aClick) {
                                                            $_POST['athlete']++;
                                                        }
                                                        $newAthl = false;
                                                        $l = 1;
                                                    } elseif (in_array($row[15], $cfgResultsHighStayDecentralEnd) && $_POST['athlete'] == $i && !$skip && $p != $ph) {
                                                        $l = 1;
                                                    } else {
                                                        $l = 1;
                                                    }
                                                }
                                            }
                                        }
                                        if ($a != $row[4]) {
                                            if ($k == $ph) {
                                                $athleteValid = true;
                                                if ($starts != $count_ends) {
                                                    if (count($arr_info) == $starts) {
                                                        for ($r = $starts - 1; $r >= 0; $r--) {
                                                            if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                                $athleteValid = false;
                                                            } else {
                                                                $athleteValid = true;
                                                                break;
                                                            }
                                                        }
                                                    }
                                                } else {
                                                    $athleteValid = false;
                                                    if (!$aClick) {
                                                        $_POST['athlete'] = 1;
                                                        $a_activ = 1;
                                                    }
                                                }
                                                $athleteValidAfter = true;
                                                for ($r = $starts - 1; $r >= 0; $r--) {
                                                    if ($r >= $_POST['athlete']) {
                                                        break;
                                                    }
                                                    if (in_array($arr_info[$r], $cfgResultsHighStayDecentralEnd)) {
                                                        $athleteValidAfter = false;
                                                    } else {
                                                        $athleteValidAfter = true;
                                                        break;
                                                    }
                                                }
                                                if (!$athleteValid) {
                                                    $l = 1;
                                                    if (!$click) {
                                                        if ($a_first == 0) {
                                                            $_POST['athlete'] = 1;
                                                            $l = 0;
                                                        }
                                                    }
                                                }
                                            }
                                            $a = $row[4];
                                            // keep athlete ID
                                            $info_keep = $row[15];
                                            // keep info
                                            $i++;
                                            // increment athlete counter
                                            $newAthl = true;
                                            if (in_array($row[15], $cfgResultsHighStayDecentralNotPassed)) {
                                                // find O (example: O, XO , XXO )
                                                $l = 0;
                                                // reset result counter
                                                $newAthl = false;
                                            } else {
                                                if (is_null($row[15])) {
                                                    $l = 0;
                                                    $newAthl = false;
                                                } else {
                                                    if (in_array($row[15], $cfgResultsHighStayDecentralEnd) && $_POST['athlete'] == $i && $skip && !$aClick) {
                                                        if ($starts != $count_ends) {
                                                            $_POST['athlete']++;
                                                        }
                                                        $newAthl = false;
                                                        $l = 1;
                                                    } elseif (in_array($row[15], $cfgResultsHighStayDecentralEnd) && $_POST['athlete'] == $i && !$skip && $p != $ph) {
                                                        $l = 1;
                                                    } else {
                                                        $l = 1;
                                                    }
                                                }
                                            }
                                            if ($a_activ == $i) {
                                                // active item
                                                $rowclass = 'active';
                                                if (isset($_POST['start'])) {
                                                    AA_setCurrAthlete($row[2], $row[4]);
                                                }
                                            } else {
                                                if ($row[5] % 2 == 0) {
                                                    // even row numer
                                                    $rowclass = 'even';
                                                } else {
                                                    // odd row number
                                                    $rowclass = 'odd';
                                                }
                                            }
                                            if ($rowclass == 'active') {
                                                ?>
                                <tr  id="athlete_<?php 
                                                echo $i;
                                                ?>
" class='active'>
                            <?php 
                                            } else {
                                                ?>
                                <tr id="athlete_<?php 
                                                echo $i;
                                                ?>
" class='<?php 
                                                echo $rowclass;
                                                ?>
'
                                    onclick='selectAthlete(<?php 
                                                echo $i;
                                                ?>
)'>
                            <?php 
                                            }
                                            ?>
                        <td class='forms_right'><?php 
                                            echo $row[5];
                                            ?>
</td>
                        <td class='forms_right'><?php 
                                            echo $row[7];
                                            /* start nbr */
                                            ?>
</td>
                        <td nowrap><?php 
                                            echo $row[8] . " " . $row[9];
                                            /* name */
                                            ?>
</td>
                        <td class='forms_ctr'><?php 
                                            echo AA_formatYearOfBirth($row[10]);
                                            ?>
</td>
                        <td><?php 
                                            echo $row[16] != '' && $row[16] != '-' ? $row[16] : '&nbsp;';
                                            ?>
</td>
                        <td nowrap><?php 
                                            echo $row[11];
                                            /* club */
                                            ?>
</td>
                               
                        <?php 
                                            if ($a_activ == $i) {
                                                ?>
                                    <form action='event_results.php' method='post'
                                        name='rank'>
                                    <td>
                                        <input type='hidden' name='arg' value='save_rank' />
                                        <input type='hidden' name='round' value='<?php 
                                                echo $round;
                                                ?>
' />
                                         <input type='hidden' name='singleRound' value='<?php 
                                                echo $singleRound;
                                                ?>
' />    
                                        <input type='hidden' name='athlete' value='<?php 
                                                echo $i + $focus;
                                                ?>
' />
                                        <input type='hidden' name='item' value='<?php 
                                                echo $row[4];
                                                ?>
' />                                           
                                        <input class='nbr' type='text' name='rank' maxlength='3'
                                            value='<?php 
                                                echo $row[6];
                                                ?>
' onchange='document.rank.submit()' />
                                    </td>
                                    </form>
                              
                                  <?php 
                                                if ($zaehler == 0) {
                                                    ?>
                                    
                                     <form action='event_results.php' method='post'
                                        name='remark_<?php 
                                                    echo $i;
                                                    ?>
'>
                                    <td>
                                        <input type='hidden' name='arg' value='save_remark' />
                                        <input type='hidden' name='round' value='<?php 
                                                    echo $round;
                                                    ?>
' />
                                         <input type='hidden' name='singleRound' value='<?php 
                                                    echo $singleRound;
                                                    ?>
' />    
                                        <input type='hidden' name='athlete' value='<?php 
                                                    echo $i + $focus;
                                                    ?>
' />
                                        <input type='hidden' name='item' value='<?php 
                                                    echo $row[4];
                                                    ?>
' />                                          
                                        <input type='hidden' name='xAthlete' value='<?php 
                                                    echo $row[18];
                                                    ?>
' />    
                                        <input class='textshort' type='text' name='remark' maxlength='5'
                                            value='<?php 
                                                    echo $row[17];
                                                    ?>
' onchange='document.remark_<?php 
                                                    echo $i;
                                                    ?>
.submit()' />
                                    </td>
                                    </form>  
                                    <?php 
                                                    $zaehler++;
                                                }
                                            } else {
                                                echo "<td>" . $row[6] . "</td>";
                                                echo "<td>" . $row[17] . "</td>";
                                            }
                                        }
                                        // ET new athlete
                                        $new_perf = '';
                                        if ($_POST['athlete'] == $i) {
                                            // only current athlet
                                            $item = '';
                                            $ph_perf = $ph - 1;
                                            $hiddenName = "hiddenHight_" . $ph_perf;
                                            if ($newHight) {
                                                $ph_perf += 1;
                                            }
                                            $hiddenName = "hiddenHight_" . $ph_perf;
                                            $new_perf = $arr_height[$ph_perf];
                                            $new_perf = new PerformanceAttempt($new_perf);
                                            $new_perf = $new_perf->getPerformance();
                                            // read all performances achieved in current heat and
                                            // better than last entered performance
                                            if (in_array($row[15], $cfgResultsHighStayDecentral)) {
                                                $new_info = $row[15];
                                                if (in_array($row[15], $cfgResultsHighStayDecentralEnd)) {
                                                    $new_info = '';
                                                } else {
                                                    $item = $row[13];
                                                }
                                            } else {
                                                $new_info = '';
                                            }
                                            if (is_null($row[14]) == false && empty($item)) {
                                                // next height
                                                ?>
                                <td nowrap>
                                    <?php 
                                                echo $row[15];
                                                ?>
                                </td>
                                <?php 
                                                if ($_POST['athlete'] == $a_activ) {
                                                    ?>
                                        <td>
                                        <?php 
                                                    $btn = new GUI_Button("event_results.php?arg=delete&round={$round}&item={$row['13']}&athlete={$i}", "del");
                                                    $btn->printButton();
                                                    ?>
                                        </td>
                                        <?php 
                                                } else {
                                                    ?>
                                        <td></td>  
                                        <?php 
                                                }
                                            }
                                            if ($l == 0) {
                                                // first item
                                                $find = strpos(strtoupper($row[15], 'O'));
                                                if ($row[15] == '-') {
                                                    if (!$skip) {
                                                        $l++;
                                                    }
                                                } elseif (!in_array($row[15], $cfgResultsHighStayDecentralNotPassed)) {
                                                    $l++;
                                                }
                                                $flagField = true;
                                                ?>
                            <form action='event_results.php' method='post'
                                        name='perf'>
                            <td nowrap colspan='2'> 
                                        <input type='hidden' name='arg' value='save_res' />
                                        <input type='hidden' name='round' value='<?php 
                                                echo $round;
                                                ?>
' />
                                         <input type='hidden' name='singleRound' value='<?php 
                                                echo $singleRound;
                                                ?>
' />    
                                        <input type='hidden' name='athlete' value='<?php 
                                                echo $i + $focus;
                                                ?>
' />
                                        <input type='hidden' name='start' value='<?php 
                                                echo $row[4];
                                                ?>
' />  
                                        <input type='hidden' name='xSerie' value='<?php 
                                                echo $row[2];
                                                ?>
' />                                        
                                        <input type='hidden' name='item' value='<?php 
                                                echo $item;
                                                ?>
' />
                                        <input class='perfheight' type='hidden' name='perf' maxlength='5'
                                            value='<?php 
                                                echo $new_perf;
                                                ?>
'
                                                 />
                                         <?php 
                                                foreach ($_POST as $key => $val) {
                                                    $arr_key = explode('_', $key);
                                                    $hiddenName = $arr_key[0] . "_" . $arr_key[1];
                                                    ?>
                                                 <input type='hidden' name='<?php 
                                                    echo $hiddenName;
                                                    ?>
' value='<?php 
                                                    echo $val;
                                                    ?>
' /> 
                                                 <?php 
                                                }
                                                ?>
         
                                        <input class='texttiny' type='text' name='attempts' maxlength='3' onfocus="this.value = '<?php 
                                                echo $new_info;
                                                ?>
'"  
                                            value='<?php 
                                                echo $new_info;
                                                ?>
' />
                                                
                                             <button type='button' name="butt" onclick="document.perf.submit()">ok</button> 
                            </td>
                            </form>      
                            
                                           <?php 
                                                $prev_info = '';
                                                echo "<td colspan='31'>&nbsp;";
                                                echo "</td>";
                                                echo "<td>";
                                                $btn->set("event_results.php?arg=del_start&item={$a}&round={$round}", $strDelete);
                                                $btn->printButton();
                                                echo "</td>";
                                            }
                                        } else {
                                            if (is_null($row[14]) == false) {
                                                // result entered
                                                $showNotValidRes = '';
                                                if ($row[14] < 0) {
                                                    $showNotValidRes = "({$row['14']})";
                                                }
                                                echo "<td colspan='2' nowrap>{$showNotValidRes} {$row['15']} </td>";
                                            }
                                        }
                                    }
                                    if ($a != 0) {
                                        if ($s == $s_keep || $s_keep == 1 || $info_keep == '-' && $ph == $k) {
                                            if (!$aClick) {
                                                $skip = true;
                                                $_POST['athlete']++;
                                            }
                                        } else {
                                            $skip = false;
                                        }
                                        if ($_POST['athlete'] == $i) {
                                            if (!$flagField && !$skip) {
                                                ?>
                            <form action='event_results.php' method='post'
                                        name='perf'>
                            <td nowrap colspan='2'> 
                                        <input type='hidden' name='arg' value='save_res' />
                                        <input type='hidden' name='round' value='<?php 
                                                echo $round;
                                                ?>
' />
                                         <input type='hidden' name='singleRound' value='<?php 
                                                echo $singleRound;
                                                ?>
' />    
                                        <input type='hidden' name='athlete' value='<?php 
                                                echo $i + $focus;
                                                ?>
' />
                                        <input type='hidden' name='start' value='<?php 
                                                echo $a;
                                                ?>
' />                                            
                                        <input type='hidden' name='item' value='<?php 
                                                echo $item;
                                                ?>
' />
                                        <input class='perfheight' type='hidden' name='perf' maxlength='5'
                                            value='<?php 
                                                echo $new_perf;
                                                ?>
'
                                                 />
                                                  <?php 
                                                foreach ($_POST as $key => $val) {
                                                    $arr_key = explode('_', $key);
                                                    $hiddenName = $arr_key[0] . "_" . $arr_key[1];
                                                    ?>
                                                 <input type='hidden' name='<?php 
                                                    echo $hiddenName;
                                                    ?>
' value='<?php 
                                                    echo $val;
                                                    ?>
' /> 
                                                 <?php 
                                                }
                                                ?>
         
                                        <input class='texttiny' type='text' name='attempts' maxlength='3' onfocus="this.value = '<?php 
                                                echo $new_info;
                                                ?>
'"   
                                            value='<?php 
                                                echo $new_info;
                                                ?>
' />
                                         <button type='button' name="butt" onclick="document.perf.submit()">ok</button>
                            </td>
                            </form> 
                            <?php 
                                                echo "<td colspan='15'>&nbsp;";
                                                echo "</td>";
                                                echo "<td>";
                                                $btn->set("event_results.php?arg=del_start&item={$a}&round={$round}", $strDelete);
                                                $btn->printButton();
                                                echo "</td>";
                                            }
                                        }
                                        echo "</tr>";
                                    }
                                    ?>
    
            
</table>
  
                 
            <?php 
                                    mysql_free_result($res);
                                }
                                // ET DB error
                            }
                        }
                    }
                }
            }
            ?>

<script type="text/javascript">
<!--
    var prog = "<?php 
            echo $prog_mode;
            ?>
";
  
   
    if (prog == 2) {   
           if(document.perf) { 
               document.perf.attempts.focus();                
               window.scrollBy(0,100);  
            }    
    }
    else {      
        if(document.perf) {
                    document.perf.perf.focus();
                    document.perf.perf.select();
                    window.scrollBy(0,100);
        }
         if(document.rank) {
            document.rank.rank.focus();
            document.rank.rank.select();
            window.scrollBy(0,100);
        }
    }  
//-->
</script>

</body>
</html>

<?php 
        } else {
            AA_printErrorMsg($strErrMergedRound);
        }
    }
Esempio n. 23
0
     AA_printErrorMsg($strCategory . $strErrNotValid);
 } else {
     if (AA_checkReference("meeting", "xMeeting", $_COOKIE['meeting_id']) == 0) {
         AA_printErrorMsg($strMeeting . $strErrNotValid);
     } else {
         if (AA_checkReference("verein", "xVerein", $_POST['club']) == 0) {
             AA_printErrorMsg($strClub . $strErrNotValid);
         } else {
             // Team selected
             if (!empty($_POST['team']) && AA_checkReference("team", "xTeam", $_POST['team']) == 0) {
                 AA_printErrorMsg($strTeam . $strErrNotValid);
             } else {
                 $eventcheck = TRUE;
                 if (count($_POST['events']) > 0) {
                     foreach ($_POST['events'] as $event) {
                         if (AA_checkReference("wettkampf", "xWettkampf", $event) == 0) {
                             $eventcheck = FALSE;
                         }
                     }
                 }
                 if ($eventcheck == FALSE) {
                     AA_printErrorMsg($strEvent . $strErrNotValid);
                 } else {
                     $startnbr = AA_getLastStartnbr();
                     // startnbrs already assigned, none provided
                     if ($startnbr > 0 && empty($_POST['startnbr'])) {
                         $startnbr++;
                         // use next available nbr
                         // check if this nbr is used for a relay
                         $result = mysql_query("SELECT xStaffel " . " FROM staffel" . " WHERE xMeeting=" . $_COOKIE['meeting_id'] . " AND Startnummer=" . $startnbr);
                         if (mysql_errno() > 0) {
Esempio n. 24
0
        AA_printErrorMsg($strErrEmptyFields);
    } else {
        if ($_POST['arg'] == "add") {
            mysql_query("\r\n\t\t\tINSERT INTO stadion SET \r\n\t\t\t\tName=\"" . $_POST['name'] . "\"\r\n\t\t\t\t, Bahnen=\"" . $_POST['tracks'] . "\"\r\n\t\t\t\t, BahnenGerade=\"" . $_POST['tracks2'] . "\"\r\n\t\t\t\t, Ueber1000m=\"{$o1000m}\"\r\n\t\t\t\t, Halle=\"{$inhall}\"\r\n\t\t");
        } else {
            if ($_POST['arg'] == "change") {
                mysql_query("\r\n\t\t\tUPDATE stadion SET \r\n\t\t\t\tName=\"" . $_POST['name'] . "\"\r\n\t\t\t\t, Bahnen=" . $_POST['tracks'] . "\r\n\t\t\t\t, BahnenGerade=\"" . $_POST['tracks2'] . "\"\r\n\t\t\t\t, Ueber1000m=\"{$o1000m}\"\r\n\t\t\t\t, Halle=\"{$inhall}\"\r\n\t\t\tWHERE xStadion=" . $_POST['item']);
            }
        }
    }
} else {
    if ($_GET['arg'] == "del") {
        mysql_query("LOCK TABLES anlage READ, meeting READ, stadion WRITE");
        // Still in use?
        $rows = AA_checkReference("anlage", "xStadion", $_GET['item']);
        $rows = $rows + AA_checkReference("meeting", "xStadion", $_GET['item']);
        // OK: not used anymore
        if ($rows == 0) {
            mysql_query("DELETE FROM stadion WHERE xStadion=" . $_GET['item']);
        } else {
            AA_printErrorMsg($strStadium . $strErrStillUsed);
        }
        mysql_query("UNLOCK TABLES");
    }
}
// Check if any error returned from DB
if (mysql_errno() > 0) {
    AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
//
//	Display current data