$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']); }