$dropdown->addOptionsFromDB("\r\n\t\t\tSELECT\r\n\t\t\t\tst.xStart\r\n\t\t\t\t, CONCAT(a.Startnummer\r\n\t\t\t\t, '. ' \r\n\t\t\t\t, at.Name\r\n\t\t\t\t, ' ' \r\n\t\t\t\t, at.Vorname\r\n\t\t\t\t, ' ( ' \r\n\t\t\t\t, at.Jahrgang\r\n\t\t\t\t, ' )') \r\n\t\t\tFROM\r\n\t\t\t\tanmeldung AS a\r\n\t\t\t\t, athlet AS at\r\n\t\t\t\t, start AS st\r\n\t\t\tLEFT JOIN staffelathlet AS sa\r\n\t\t\t\tON st.xStart = sa.xAthletenstart\r\n\t\t\tWHERE sa.xAthletenstart IS NULL\r\n\t\t\tAND a.xAthlet = at.xAthlet\r\n\t\t\tAND a.xAnmeldung = st.xAnmeldung\r\n\t\t\tAND st.xWettkampf = {$row['8']}\r\n\t\t\tAND at.xVerein = {$row['7']}\r\n\t\t\tAND a.xTeam = {$row['10']}\r\n\t\t\tORDER BY\r\n\t\t\t\tat.Name\r\n\t\t\t\t, at.Vorname\r\n\t\t");
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
//$dropdown->printList('forms', 4);
$dropdown->printList();
?>
</td>
<td class='forms'><input name='position' class='nbr' type='text'
maxlength='2' value='' onchange='document.add_pos.submit()'/>
</td>
</form>
<?php
// extended athlete list (other categories, no relay entry, ...)
$sqlClubLG = " = " . $row[7];
$arrClub = AA_meeting_getLG_Club($row[7]);
// get all clubs with same LG
if (count($arrClub) > 0) {
$sqlClubLG = " IN (";
foreach ($arrClub as $key => $val) {
$sqlClubLG .= $val . ",";
}
$sqlClubLG = substr($sqlClubLG, 0, -1);
$sqlClubLG .= ")";
}
$res = mysql_query("\r\n\t\t\tSELECT\r\n\t\t\t\ta.xAnmeldung\r\n\t\t\t\t, CONCAT(a.Startnummer\r\n\t\t\t\t\t, '. ' \r\n\t\t\t\t\t, at.Name\r\n\t\t\t\t\t, ' ' \r\n\t\t\t\t\t, at.Vorname\r\n\t\t\t\t\t, ' ( ' \r\n\t\t\t\t\t, at.Jahrgang\r\n\t\t\t\t\t, ' )') \r\n\t\t\t\t, a.xTeam\r\n\t\t\tFROM\r\n\t\t\t\tanmeldung AS a\r\n\t\t\t\t, athlet AS at\r\n\t\t\tWHERE a.xAthlet = at.xAthlet\r\n\t\t\tAND a.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t\t\tAND at.xVerein {$sqlClubLG} \r\n\t\t\tORDER BY at.Name, at.Vorname\r\n\t\t");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
?>
<form action='meeting_relay.php' method='post'>
<form action="meeting_teamsm.php" method="POST" name="teamsm_add2">
<input type="hidden" name="arg" value="add_athlete">
<input type="hidden" name="item" value="<?php
echo $_POST['item'];
?>
">
<input type="hidden" name="event" value="<?php
echo $event;
?>
">
<td class="forms" colspan="2">
<?php
// athletes who are in the right club and LG
$sqlClubLG = " = " . $club;
$arrClub = AA_meeting_getLG_Club($club);
// get all clubs with same LG
if (count($arrClub) > 0) {
$sqlClubLG = " IN (";
foreach ($arrClub as $key => $val) {
$sqlClubLG .= $val . ",";
}
$sqlClubLG = substr($sqlClubLG, 0, -1);
$sqlClubLG .= ")";
}
$dropdown = new GUI_Select("athlete", 1, "document.teamsm_add2.submit()");
$dropdown->addOption($strOtherAthletes, 0);
$dropdown->addOptionsFromDB("\r\n\t\t\tSELECT\r\n\t\t\t\ta.xAnmeldung\r\n\t\t\t\t, CONCAT(a.Startnummer, '. ', at.Name, ' ', at.Vorname, ' ( ' , at.Jahrgang, ' )')\r\n\t\t\tFROM\r\n\t\t\t\tanmeldung AS a\r\n\t\t\t\t, athlet AS at\r\n\t\t\t\tLEFT JOIN teamsmathlet AS tsa ON (tsa.xAnmeldung = a.xAnmeldung\r\n\t\t\t\t\tAND tsa.xTeamsm = " . $_POST['item'] . ")\r\n\t\t\t\tLEFT JOIN start AS st ON (st.xAnmeldung = a.xAnmeldung\r\n\t\t\t\t\tAND st.xWettkampf = {$event})\r\n\t\t\tWHERE\r\n\t\t\t\ttsa.xTeamsm IS NULL\r\n\t\t\t\r\n\t\t\tAND\tat.xAthlet = a.xAthlet\r\n\t\t\tAND\tat.xVerein {$sqlClubLG} \r\n\t\t\tAND\ta.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t\t\tORDER BY\r\n\t\t\t\tat.Name\r\n\t\t\t\t, at.Vorname\r\n\t\t");
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
