/**
* 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");
}
}
