echo $strDiscipline; ?> </th> <td class='forms'> <form name="discipline" action="meeting_entries_setgroups.php" method="GET"> <input type="hidden" name="category" value="<?php echo $category; ?> "> <?php if ($category > 0) { $sqlCategory = "AND w.xKategorie = {$category}"; } $dropdown = new GUI_Select("disc", 1, "document.discipline.submit()"); $dropdown->addOptionNone(); $dropdown->addOptionsFromDB("\r\n\t\t\tSELECT\r\n\t\t\t\tw.xWettkampf\r\n\t\t\t\t, CONCAT(k.Kurzname, ', ', d.Kurzname, ' (', w.Info, ')')\r\n\t\t\tFROM\r\n\t\t\t\twettkampf AS w\r\n\t\t\t\t, kategorie AS k\r\n\t\t\t\t, disziplin AS d\r\n\t\t\tWHERE\r\n\t\t\t\tk.xKategorie = w.xKategorie\r\n\t\t\tAND\td.xDisziplin = w.xDisziplin\r\n\t\t\tAND\tw.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t\t\tAND\tw.Typ = " . $cfgEventType[$strEventTypeTeamSM] . "\r\n\t\t\t{$sqlCategory}\r\n\t\t\tORDER BY\r\n\t\t\t\tk.Anzeige, d.Anzeige\r\n\t\t"); if (!empty($GLOBALS['AA_ERROR'])) { AA_printErrorMsg($GLOBALS['AA_ERROR']); } $dropdown->selectOption($disc); $dropdown->printList(); ?> </form> </td> </tr></table> <br> <?php // // show entries for discipline // if ($disc > 0) {
?> " onclick="document.location.href='admin_service.php?a=statusupload&v=1'"> </td> </tr> </table><br/><br/> <table class='dialog' width="475"> <tr> <th>Bewilligungsnummer zuordnen</th> </tr> <tr class="odd"> <td> Meeting: <?php $dropdown = new GUI_Select('xMeeting_xControl', 1, ''); $dropdown->addOptionsFromDB("select xMeeting, Name from meeting order by DatumVon, DatumBis"); $dropdown->selectOption("-"); $dropdown->printList(); ?> <br/> Bewilligungsnummer: <input type="text" name="xControl" id="xControl" style="width: 50px;"/><br/> <input type="button" value="Los" onclick="document.location.href='admin_service.php?a=xControl&m='+document.getElementById('xMeeting_xControlselectbox').value+'&c='+document.getElementById('xControl').value"> </td> </tr> </table> </td> </tr> </table> <?php } } else {
echo $row[8]; ?> ' /> <input name='team' type='hidden' value='<?php echo $row[10]; ?> ' /> <input name='relay' type='hidden' value='<?php echo $row[5]; ?> ' /> <?php // Drop down list of all athletes in team $dropdown = new GUI_Select("athlete", 1); $dropdown->addOption($strAllRegisteredRelayTeam, 0); $dropdown->addOptionsFromDB(" SELECT\r\n a.xAnmeldung\r\n , CONCAT( at.Name,' ', at.Vorname) \r\n , a.Startnummer\r\n , at.Jahrgang \r\n FROM\r\n anmeldung AS a\r\n LEFT JOIN athlet AS at ON (a.xAthlet = at.xAthlet)\r\n WHERE \r\n a.xMeeting = " . $_COOKIE['meeting_id'] . " AND a.xTeam = " . $row[10] . " \r\n AND a.xTeam > 0 \r\n ORDER BY at.Name, at.Vorname", true); if (!empty($GLOBALS['AA_ERROR'])) { AA_printErrorMsg($GLOBALS['AA_ERROR']); } $dropdown->printList(false); ?> </td> <td class='forms'><input name='position' class='nbr' type='text' maxlength='2' value='' onchange='this.form.submit()'/> </td> </form> <?php ?> </tr>
<input name='team' type='hidden' value='<?php echo $row[10]; ?> ' /> <input name='relay' type='hidden' value='<?php echo $row[5]; ?> ' /> <input name='event' type='hidden' value='<?php echo $row[8]; ?> ' /> <?php $dropdown = new GUI_Select("athlete", 1); $dropdown->addOption($strUnassignedAthletes, 0); $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]);
<form action="meeting_teamsm.php" method="POST" name="teamsm_add3"> <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="4"> <?php // athletes who are in the right club $dropdown = new GUI_Select("athlete", 4, "", "multiple"); $dropdown->addOption($strAllRegisteredAthletes, 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\tWHERE\r\n\t\t\t\ttsa.xTeamsm IS NULL\r\n\t\t\tAND\tat.xAthlet = a.xAthlet\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']); } $dropdown->printList(); ?> <br/> </td> <td class="forms_bottom" > <input type="button" value="<?php echo $strAdd; ?> " onclick="document.teamsm_add3.submit()">