/** * export a round to alge * * exportet are 2 files, .txt (competitiors) and .rac (race information) * - param round */ function export_round($round) { $relay = AA_checkRelay(0, $round); mysql_query("LOCK TABLES wettkampf as w READ, runde as r READ\r\n\t\t\t\t\t, serie as s READ, disziplin_de as d READ , disziplin_fr as d READ , disziplin_it as d READ \r\n\t\t\t\t\t, rundentyp_de as rt READ, rundentyp_fr as rt READ, rundentyp_it as rt READ\r\n , kategorie as k READ\r\n\t\t\t\t\t, anmeldung as a READ, athlet as at READ\r\n\t\t\t\t\t, start as st READ, serienstart as ss READ\r\n\t\t\t\t\t, verein as v READ, meeting as m READ\r\n\t\t\t\t\t, stadion as sta, staffel as sf READ"); $file = $this->make_filename($round); // get each heat with race informations /*$sql = "SELECT s.xSerie , m.Name , m.Ort , d.Kurzname , k.Name , rt.Name , w.xWettkampf , d.Strecke , s.Film , s.Bezeichnung , sta.Name FROM meeting as m , wettkampf as w , disziplin as d , kategorie as k , runde as r , serie as s , rundentyp as rt , stadion as sta WHERE r.xRunde = $round AND w.xWettkampf = r.xWettkampf AND m.xMeeting = w.xMeeting AND sta.xStadion = m.xStadion AND d.xDisziplin = w.xDisziplin AND k.xKategorie = w.xKategorie AND s.xRunde = r.xRunde AND rt.xRundentyp = r.xRundentyp AND w.Zeitmessung = 1 ";*/ $sql = "SELECT s.xSerie, \r\n\t\t\t\t\t\t m.Name, \r\n\t\t\t\t\t\t m.Ort, \r\n\t\t\t\t\t\t d.Kurzname, \r\n\t\t\t\t\t\t k.Name, \r\n\t\t\t\t\t\t rt.Name, \r\n\t\t\t\t\t\t w.xWettkampf, \r\n\t\t\t\t\t\t d.Strecke, \r\n\t\t\t\t\t\t s.Film, \r\n\t\t\t\t\t\t s.Bezeichnung, \r\n\t\t\t\t\t\t sta.Name,\r\n d.Code \r\n\t\t\t\t\t FROM meeting AS m \r\n\t\t\t\t LEFT JOIN wettkampf AS w USING(xMeeting) \r\n\t\t\t\t LEFT JOIN disziplin_" . $_COOKIE['language'] . " AS d USING(xDisziplin) \r\n\t\t\t\t LEFT JOIN kategorie AS k ON(w.xKategorie = k.xKategorie) \r\n\t\t\t\t LEFT JOIN runde AS r ON(w.xWettkampf = r.xWettkampf) \r\n\t\t\t\t LEFT JOIN serie AS s USING(xRunde) \r\n\t\t\t\t LEFT JOIN rundentyp_" . $_COOKIE['language'] . " AS rt ON(r.xRundentyp = rt.xRundentyp) \r\n\t\t\t\t LEFT JOIN stadion AS sta ON(m.xStadion = sta.xStadion) \r\n\t\t\t\t\t WHERE r.xRunde = " . $round . " \r\n\t\t\t\t\t AND w.Zeitmessung = 1;"; $resHeat = mysql_query($sql); if (mysql_errno() > 0) { AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } else { while ($rowHeat = mysql_fetch_array($resHeat)) { $fileHeat = sprintf("%03d", $rowHeat[8]) . $file . $rowHeat[9]; // race information (*.rac file) // "RaceNo" = Heat Number, no identification $windmode = 7; // no measurement if ($rowHeat[11] == 10 || $rowHeat[11] == 30 || $rowHeat[11] >= 252 & $rowHeat[11] <= 256) { $windmode = 6; } elseif ($rowHeat[11] == 35 || $rowHeat[11] == 258 || $rowHeat[11] == 40) { $windmode = 5; } elseif ($rowHeat[11] >= 259 & $rowHeat[11] <= 271) { $windmode = 4; } elseif ($rowHeat[11] == 50) { $windmode = 3; } else { $windmode = 7; } $tmp = "[RaceInfo]\r\nMeeting={$rowHeat['1']}, {$rowHeat['2']}\r\nPlace={$rowHeat['10']}\r\nCompType={$rowHeat['3']} {$rowHeat['4']} - {$rowHeat['5']}\r\nCompNo={$rowHeat['6']}\r\nDistance={$rowHeat['7']}m\r\nRaceNo={$rowHeat['9']}\r\nPrepared=1\r\nWindmode={$windmode}\r\n[Files]\r\nName={$fileHeat}\r\n"; $this->send_file($tmp, "{$fileHeat}.rac"); if ($relay == false) { // starts for each race (*.txt file) $tmp = ""; /*$sql = "SELECT a.Startnummer , ss.Bahn , at.Name , at.Vorname , v.Name , at.Jahrgang FROM runde as r , wettkampf as w , serie as s , serienstart as ss , start as st , anmeldung as a , athlet as at , verein as v WHERE s.xSerie = $rowHeat[0] AND r.xWettkampf = w.xWettkampf AND s.xRunde = r.xRunde AND ss.xSerie = s.xSerie AND st.xStart = ss.xStart AND a.xAnmeldung = st.xAnmeldung AND at.xAthlet = a.xAthlet AND v.xVerein = at.xVerein";*/ $sql = "SELECT a.Startnummer, \r\n\t\t\t\t\t\t\t\t ss.Bahn, \r\n\t\t\t\t\t\t\t\t at.Name, \r\n\t\t\t\t\t\t\t\t at.Vorname, \r\n\t\t\t\t\t\t\t\t v.Name, \r\n\t\t\t\t\t\t\t\t at.Jahrgang \r\n\t\t\t\t\t\t\t FROM runde AS r \r\n\t\t\t\t\t\t LEFT JOIN wettkampf AS w USING(xWettkampf) \r\n\t\t\t\t\t\t LEFT JOIN serie AS s ON(r.xRunde = s.xRunde) \r\n\t\t\t\t\t\t LEFT JOIN serienstart AS ss USING(xSerie) \r\n\t\t\t\t\t\t LEFT JOIN start AS st USING(xStart) \r\n\t\t\t\t\t\t LEFT JOIN anmeldung AS a USING(xAnmeldung) \r\n\t\t\t\t\t\t LEFT JOIN athlet AS at USING(xAthlet) \r\n\t\t\t\t\t\t LEFT JOIN verein AS v USING(xVerein) \r\n\t\t\t\t\t\t\t WHERE s.xSerie = " . $rowHeat[0] . "\r\n ORDER BY ss.Position"; $res = mysql_query($sql); if (mysql_errno() > 0) { AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($res) == 0) { } else { while ($row = mysql_fetch_array($res)) { $tmp .= "\t{$row['0']}\t{$row['1']}\t" . trim($row[2]) . "\t" . trim($row[3]) . "\t" . trim($row[4]) . "\t{$row['5']}"; $tmp .= "\t\t\t999999999\t1\t3"; $tmp .= "\t\t\t\t\t999999999\t\t\t\t\r\n"; } $this->send_file($tmp, "{$fileHeat}.txt"); } } mysql_Free_result($res); } else { // relay event // starts for each race (*.txt file) $tmp = ""; /*$sql = "SELECT sf.Startnummer , ss.Bahn , sf.Name , '-' , v.Name , '-' FROM runde as r , wettkampf as w , serie as s , serienstart as ss , start as st , staffel as sf , verein as v WHERE s.xSerie = $rowHeat[0] AND r.xWettkampf = w.xWettkampf AND s.xRunde = r.xRunde AND ss.xSerie = s.xSerie AND st.xStart = ss.xStart AND sf.xStaffel = st.xStaffel AND v.xVerein = sf.xVerein";*/ $sql = "SELECT sf.Startnummer, \r\n\t\t\t\t\t\t\t\t ss.Bahn, \r\n\t\t\t\t\t\t\t\t sf.Name, \r\n\t\t\t\t\t\t\t\t '-', \r\n\t\t\t\t\t\t\t\t v.Name, \r\n\t\t\t\t\t\t\t\t '-' \r\n\t\t\t\t\t\t\t FROM runde AS r \r\n\t\t\t\t\t\t LEFT JOIN wettkampf AS w USING(xWettkampf) \r\n\t\t\t\t\t\t LEFT JOIN serie AS s ON(r.xRunde = s.xRunde) \r\n\t\t\t\t\t\t LEFT JOIN serienstart AS ss USING(xSerie) \r\n\t\t\t\t\t\t LEFT JOIN start AS st USING(xStart) \r\n\t\t\t\t\t\t LEFT JOIN staffel AS sf USING(xStaffel) \r\n\t\t\t\t\t\t LEFT JOIN verein AS v USING(xVerein) \r\n\t\t\t\t\t\t\t WHERE s.xSerie = " . $rowHeat[0] . "\r\n ORDER BY ss.Position"; $res = mysql_query($sql); if (mysql_errno() > 0) { AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($res) == 0) { } else { while ($row = mysql_fetch_array($res)) { $tmp .= "\t{$row['0']}\t{$row['1']}\t" . trim($row[2]) . "\t" . trim($row[3]) . "\t" . trim($row[4]) . "\t{$row['5']}"; $tmp .= "\t\t\t999999999\t1\t3"; $tmp .= "\t\t\t\t\t999999999\t\t\t\t\r\n"; } $this->send_file($tmp, "{$fileHeat}.txt"); } } mysql_Free_result($res); } } } mysql_query("UNLOCK TABLES"); }
?> ][1] = '<?php echo $row_dis[1]; ?> '; disz[<?php echo $row_dis[0]; ?> ] = '<?php echo $row_dis[1]; ?> '; <?php $i++; } mysql_Free_result($res); ?> function check(item) // state has changed; check what to do { if((item=='discipline') && (document.add_event.discipline.value=='new')) // new discipline { window.open("admin_disciplines.php", "_self"); } else if((item=='category') && (document.add_event.cat.value=='new')) // new category { window.open("admin_categories.php", "_self"); } }