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()">
