if (empty($_POST['mtime'])) {
// if manipulation time is empty, calculate with discipline standard (15min before)
$tmp = strtotime($_POST['hr'] . ":" . $_POST['min'] . ":00");
$tmp = $tmp - $stdMtime;
$_POST['mtime'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
// the other times are parsed in the timetable constructor
$tt = new Timetable();
$tt->add();
} else {
if ($_POST['arg'] == "del_round") {
$tt = new Timetable();
$tt->delete();
} else {
if ($_POST['arg'] == 'change_round') {
list($_POST['hr'], $_POST['min']) = AA_formatEnteredTime($_POST['time']);
// auto configure enrolement and manipulation time
$result = mysql_query("\r\n SELECT\r\n d.Typ\r\n , d.Appellzeit\r\n , d.Stellzeit\r\n FROM\r\n wettkampf as w\r\n LEFT JOIN disziplin as d USING(xDisziplin)\r\n WHERE w.xWettkampf = " . $_POST['item']);
$row = mysql_fetch_row($result);
$stdEtime = strtotime($row[1]);
// hold standard delay for enrolement time
$stdMtime = strtotime($row[2]);
// and manipulation time
$tmp = strtotime($_POST['hr'] . ":" . $_POST['min'] . ":00");
$tmp = $tmp - $stdEtime;
$_POST['etime'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
$tmp = strtotime($_POST['hr'] . ":" . $_POST['min'] . ":00");
$tmp = $tmp - $stdMtime;
$_POST['mtime'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
// the other times are parsed in the timetable constructor
$tt = new Timetable();
function change()
{
include './convtables.inc.php';
require './lib/common.lib.php';
// Error: Empty fields
if (empty($this->round)) {
$GLOBALS['AA_ERROR'] = $GLOBALS['strErrEmptyFields'];
} else {
mysql_query("LOCK TABLES serie READ, kategorie_svm as ks READ, wettkampf as w READ, runde as r READ, disziplin_de as d READ, disziplin_fr as d READ, disziplin_it as d READ, runde WRITE, wettkampf WRITE, meeting WRITE");
$status = AA_utils_getRoundStatus($this->round);
if ($status == $GLOBALS['cfgRoundStatus']['results_done']) {
$GLOBALS['AA_ERROR'] = $GLOBALS['strErrResultsEntered'];
} else {
if (empty($this->type)) {
// round type is not optional!
$GLOBALS['AA_ERROR'] = $GLOBALS['strType'] . $GLOBALS['strErrNotValid'];
} else {
if (!empty($this->etime)) {
$et = AA_formatEnteredTime($this->etime);
$sqlEtime = ", Appellzeit = '{$et['0']}:{$et['1']}:00'";
}
if (!empty($this->mtime)) {
$mt = AA_formatEnteredTime($this->mtime);
$sqlMtime = ", Stellzeit = '{$mt['0']}:{$mt['1']}:00'";
}
// set conversion table
if (isset($cfgSVM[$this->svmCode])) {
$cfgSVM_arr = $cfgSVM[$this->svmCode];
if (isset($cfgSVM[$this->svmCode . "_NT"])) {
// _NT = nulltime
$cfgSVM_arr_NT = $cfgSVM[$this->svmCode . "_NT"];
}
}
if (isset($cfgSVM[$this->svmCode . "_NT"])) {
// _NT = nulltime
foreach ($cfgSVM_arr as $key => $val) {
if ($val == $_POST['dCode']) {
$keep_key = $key;
continue;
}
}
if ($cfgSVM_arr_NT[$keep_key] == '0000') {
// discipline with nulltime
$this->change_all();
} else {
mysql_query("\r\n UPDATE runde SET\r\n Datum = '" . $this->date . "'\r\n , Startzeit = '" . $this->hour . ":" . $this->min . ":00" . "'\r\n , xRundentyp = " . $this->type . "\r\n , Gruppe = '" . $this->group . "' \r\n {$sqlEtime}\r\n {$sqlMtime}\r\n WHERE xRunde = " . $this->round);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
} else {
$sql = "SELECT \r\n xRundentyp,\r\n xWettkampf\r\n FROM\r\n runde as r\r\n WHERE\r\n r.xRunde = " . $this->round;
$result = mysql_query($sql);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row = mysql_fetch_array($result);
if ($row[0] == 8 && $this->type != 8) {
// typ 8 = combined event
$typchange = '';
$sql_event = "SELECT \r\n w.Typ,\r\n w.Punktetabelle,\r\n w.Punkteformel,\r\n w.Info,\r\n w.Mehrkampfcode,\r\n w.Mehrkampfende, \r\n w.Mehrkampfreihenfolge \r\n FROM\r\n wettkampf as w\r\n WHERE\r\n w.xWettkampf = " . $row[1];
$res_event = mysql_query($sql_event);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row_event = mysql_fetch_array($res_event);
$typchange = $row_event[0] . "," . $row_event[1] . "," . $row_event[2] . "," . $row_event[3] . "," . $row_event[4] . "," . $row_event[5] . "," . $row_event[6];
// update event as single event
mysql_query("\r\n UPDATE wettkampf SET\r\n Typ = 0\r\n , Punktetabelle = 0\r\n , Punkteformel = '0'\r\n , Info = '' \r\n , Mehrkampfcode = 0\r\n , Mehrkampfende = 0 \r\n , Mehrkampfreihenfolge = 0 \r\n , TypAenderung = '" . $typchange . "' \r\n WHERE xWettkampf = " . $row[1]);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
} elseif ($this->type == 8 && $row[0] != 8) {
// typ 8 = combined event
$sql_event = "SELECT \r\n w.TypAenderung \r\n FROM\r\n wettkampf as w\r\n WHERE\r\n w.xWettkampf = " . $row[1];
$res_event = mysql_query($sql_event);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
} else {
$row_event = mysql_fetch_array($res_event);
if ($row_event[0] != '') {
$typchange = explode(",", $row_event[0]);
// update event as combined event
mysql_query("\r\n UPDATE wettkampf SET\r\n Typ = " . $typchange[0] . "\r\n , Punktetabelle = " . $typchange[1] . " \r\n , Punkteformel = '" . $typchange[2] . "' \r\n , Info = '" . $typchange[3] . "' \r\n , Mehrkampfcode = " . $typchange[4] . " \r\n , Mehrkampfende = " . $typchange[5] . " \r\n , Mehrkampfreihenfolge = " . $typchange[6] . " \r\n , TypAenderung = '' \r\n WHERE xWettkampf = " . $row[1]);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
}
}
mysql_query("\r\n\t\t\t\t\t\t UPDATE runde SET\r\n\t\t\t\t\t\t\t Datum = '" . $this->date . "'\r\n\t\t\t\t\t\t\t , Startzeit = '" . $this->hour . ":" . $this->min . ":00" . "'\r\n\t\t\t\t\t\t\t , xRundentyp = " . $this->type . "\r\n\t\t\t\t\t\t\t , Gruppe = '" . $this->group . "' \r\n\t\t\t\t\t\t\t {$sqlEtime}\r\n\t\t\t\t\t\t\t {$sqlMtime}\r\n\t\t\t\t\t\t WHERE xRunde = " . $this->round);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
}
$sql = "UPDATE meeting SET\r\n StatusChanged = 'y' \r\n WHERE xMeeting = " . $_COOKIE['meeting_id'];
mysql_query($sql);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
}
}
mysql_query("UNLOCK TABLES");
if ($status > 0 && $status != 4) {
$txt = $GLOBALS['strTimetableChanged'] . ": " . $this->date . ", " . $this->hr . ":" . $this->min;
AA_utils_logRoundEvent($this->round, $txt);
}
}
// ET round status
}
function AA_meeting_addEvent()
{
require './lib/common.lib.php';
require './lib/cl_timetable.lib.php';
$info = '';
if (!empty($_POST['info'])) {
$info = $_POST['info'];
}
$type = 0;
if (!empty($_POST['type'])) {
$type = $_POST['type'];
}
$deposit = 0;
if (!empty($_POST['deposit'])) {
$deposit = strtr($_POST['deposit'], ",", ".");
}
$fee = 0;
if (!empty($_POST['fee'])) {
$fee = strtr($_POST['fee'], ",", ".");
}
$conv = 0;
$formula = 0;
if (!empty($_POST['conv'])) {
$conv = $_POST['conv'];
if (!empty($_POST['formula'])) {
$formula = $_POST['formula'];
}
}
$stdEtime = '';
$stdMtime = '';
mysql_query("LOCK TABLES kategorie READ, disziplin_de READ, disziplin_fr READ, disziplin_ite READ, meeting READ" . ", wettkampf WRITE");
// check if category ist still valid
if (AA_checkReference("kategorie", "xKategorie", $_POST['cat']) == 0) {
AA_printErrorMsg($GLOBALS['strCategory'] . $GLOBALS['strErrNotValid']);
} else {
// check if meeting is still valid
if (AA_checkReference("meeting", "xMeeting", $_COOKIE['meeting_id']) == 0) {
AA_printErrorMsg($GLOBALS['strMeeting'] . $GLOBALS['strErrNotValid']);
} else {
$result = mysql_query("\r\n\t\t\t\tSELECT\r\n\t\t\t\t\tTyp\r\n\t\t\t\t\t, Appellzeit\r\n\t\t\t\t\t, Stellzeit\r\n\t\t\t\tFROM \r\n\t\t\t\t\tdisziplin_" . $_COOKIE['language'] . "\r\n\t\t\t\tWHERE xDisziplin = " . $_POST['discipline']);
if (mysql_errno() > 0) {
AA_printErrorMsg($GLOBALS['strDiscipline'] . $GLOBALS['strErrNotValid']);
} else {
// set default wind info, timing for this descipline
$row = mysql_fetch_row($result);
$wind = 0;
$timing = 0;
$tauto = 0;
$stdEtime = strtotime($row[1]);
// hold standard delay for enrolement time
$stdMtime = strtotime($row[2]);
// and manipulation time
if ($row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrack']] || $row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeJump']]) {
if ($_POST['wind'] == "yes") {
$wind = 1;
} else {
$wind = 0;
}
}
mysql_free_result($result);
if ($row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeNone']] || $row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrack']] || $row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeTrackNoWind']] || $row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeDistance']] || $row[0] == $GLOBALS['cfgDisciplineType'][$GLOBALS['strDiscTypeRelay']]) {
if ($_POST['timing'] == "yes") {
$timing = 1;
} else {
$timing = 0;
}
if ($_POST['timingAuto'] == "yes") {
$tauto = 1;
} else {
$tauto = 0;
}
}
// fetch parameters Typ, Mehrkampfcode, xKategorie_svm
$res = mysql_query("\r\n\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\tTyp\r\n\t\t\t\t\t\t\t, Mehrkampfcode\r\n\t\t\t\t\t\t\t, xKategorie_svm\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\twettkampf\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\txKategorie = " . $_POST['cat'] . "\r\n\t\t\t\t\t\tAND\txMeeting = " . $_COOKIE['meeting_id']);
if (mysql_num_rows($res) > 0) {
$rowT = mysql_fetch_array($res);
if ($type == 0) {
if ($rowT[0] != $GLOBALS['cfgEventType'][$GLOBALS['strEventTypeSingleCombined']]) {
$type = $rowT[0];
}
}
//$mkcode = $rowT[1];
$svmcat = $rowT[2];
} else {
$mkcode = 0;
$svmcat = 0;
}
//OK, add event
mysql_query("\r\n\t\t\t\t\tINSERT INTO wettkampf SET\r\n\t\t\t\t\t\tTyp='{$type}'\r\n\t\t\t\t\t\t, Mehrkampfcode='{$mkcode}'\r\n\t\t\t\t\t\t, xKategorie_svm='{$svmcat}'\r\n\t\t\t\t\t\t, Windmessung={$wind}\r\n\t\t\t\t\t\t, Zeitmessung={$timing}\r\n\t\t\t\t\t\t, ZeitmessungAuto={$tauto}\r\n\t\t\t\t\t\t, Haftgeld='{$deposit}'\r\n\t\t\t\t\t\t, Startgeld='{$fee}'\r\n\t\t\t\t\t\t, Punktetabelle='{$conv}'\r\n\t\t\t\t\t\t, Punkteformel='{$formula}'\r\n\t\t\t\t\t\t, Info=\"{$info}\"\r\n\t\t\t\t\t\t, xKategorie = " . $_POST['cat'] . "\r\n\t\t\t\t\t\t, xDisziplin = " . $_POST['discipline'] . "\r\n\t\t\t\t\t\t, xMeeting = " . $_COOKIE['meeting_id']);
}
}
}
// Check if any error returned from DB
$event = 0;
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$event = mysql_insert_id();
}
mysql_query("UNLOCK TABLES");
// add rounds if any
if ($event > 0) {
if (!empty($_POST['time_1'])) {
list($hr, $min) = AA_formatEnteredTime($_POST['time_1']);
if (empty($_POST['etime_1'])) {
// if enrolement time is empty, calculate with discipline standard (1h bevor)
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$_POST['etime_1'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
if (empty($_POST['mtime_1'])) {
// if manipulation time is empty, calculate with discipline standard (15min bevor)
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$_POST['mtime_1'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
$tt = new TimetableNew($_POST['date_1'], $event, 0, $_POST['roundtype_1'], $hr, $min, $_POST['etime_1'], $_POST['mtime_1']);
$tt->add();
}
if (!empty($_POST['time_2'])) {
list($hr, $min) = AA_formatEnteredTime($_POST['time_2']);
if (empty($_POST['etime_2'])) {
// if enrolement time is empty, calculate with discipline standard (1h bevor)
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$_POST['etime_2'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
if (empty($_POST['mtime_2'])) {
// if manipulation time is empty, calculate with discipline standard (15min bevor)
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$_POST['mtime_2'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
$tt = new TimetableNew($_POST['date_2'], $event, 0, $_POST['roundtype_2'], $hr, $min, $_POST['etime_2'], $_POST['mtime_2']);
$tt->add();
}
if (!empty($_POST['time_3'])) {
list($hr, $min) = AA_formatEnteredTime($_POST['time_3']);
if (empty($_POST['etime_3'])) {
// if enrolement time is empty, calculate with discipline standard (1h bevor)
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$_POST['etime_3'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
if (empty($_POST['mtime_3'])) {
// if manipulation time is empty, calculate with discipline standard (15min bevor)
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$_POST['mtime_3'] = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
}
$tt = new TimetableNew($_POST['date_3'], $event, 0, $_POST['roundtype_3'], $hr, $min, $_POST['etime_3'], $_POST['mtime_3']);
$tt->add();
}
// Check if any error returned
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
}
return;
}
function XML_regZLV_start($parser, $name, $attr)
{
global $bCombined, $arr_noCat;
global $strBaseAthleteNotFound, $strLicenseNr;
global $cfgDisciplineType, $strDiscTypeTrack, $strDiscTypeTrackNoWind, $strDiscTypeRelay, $strDiscTypeDistance, $strNoSuchCategory;
global $cfgCombinedDef, $cfgCombinedWO;
if ($name == "ATHLETE") {
$regNr = $attr['ANMELDENR'];
$license = $attr['LIZENZNR'];
$name = $attr['NAME'];
$firstname = $attr['VORNAME'];
$birth = $attr['GEBDAT'];
$arr_birth = explode(".", $birth);
$birthdate = $arr_birth[2] . "-" . $arr_birth[1] . "-" . $arr_birth[0];
$birthyear = $arr_birth[2];
$club = $attr['VEREIN'];
$sex = $attr['GESCHLECHT'];
$nationality = $attr['NATIONALITAET'];
$cat = $attr['KATEGORIE'];
$group = $attr['GRUPPENR'];
$starttime = $attr['STARTZEIT'];
$license_paid = $attr['BEZ'];
if ($license_paid == '') {
$license_paid = 'n';
}
$registerNr = $attr['ANMELDENR'];
$meetingDate = '';
$discode = 0;
if ($license > 0) {
// check if event exist for this cateory and select event to get all generated events ids
$sql = "SELECT \r\n w.xWettkampf,\r\n w.Mehrkampfcode,\r\n m.DatumVon \r\n FROM\r\n wettkampf as w\r\n LEFT JOIN kategorie as k on (w.xKategorie = k.xKategorie)\r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d on (w.xDisziplin = d.xDisziplin)\r\n LEFT JOIN meeting AS m ON (m.xMeeting = w.xMeeting)\r\n WHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n AND k.Code = '" . $cat . "'";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-1-" . mysql_errno() . ": " . mysql_error());
}
if (mysql_num_rows($res) > 0) {
while ($row_dis = mysql_fetch_assoc($res)) {
$xDis[] = $row_dis['xWettkampf'];
if ($row_dis['Mehrkampfcode'] > 0) {
$discode = $row_dis['Mehrkampfcode'];
// same for all combined disciplines
}
$meetingDate = $row_dis['DatumVon'];
}
$athlete_id = 0;
$sql2 = "SELECT TRIM(lastname) AS lastname, \r\n TRIM(firstname) AS firstname, \r\n substring(birth_date, 1,4) AS jahrgang, \r\n license, \r\n TRIM(sex) AS sex, \r\n nationality, \r\n birth_date, \r\n account_code, \r\n second_account_code,\r\n id_athlete,\r\n license_paid \r\n FROM base_athlete \r\n WHERE license = '" . $license . "';";
$query2 = mysql_query($sql2);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-2-" . mysql_errno() . ": " . mysql_error());
} else {
if ($query2 && mysql_num_rows($query2) == 1) {
// athlete exist in base data
$row2 = mysql_fetch_assoc($query2);
$club = $row2['account_code'];
$club2 = $row2['second_account_code'];
$athlete_id = $row2['id_athlete'];
$result2 = mysql_query("SELECT xVerein FROM verein WHERE xCode = '" . $club . "'");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-3-" . mysql_errno() . ": " . mysql_error());
} else {
$rowClub1 = mysql_fetch_array($result2);
$club = $rowClub1[0];
if (!empty($club2)) {
$result2 = mysql_query("SELECT xVerein FROM verein WHERE xCode = '" . $club2 . "'");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-4-" . mysql_errno() . ": " . mysql_error());
$club2 = 0;
// prevents from insert error in next statement
} else {
$rowClub2 = mysql_fetch_array($result2);
$club2 = $rowClub2[0];
}
} else {
$club2 = 0;
}
}
mysql_free_result($result2);
// check if athlete exist // check if athlete is already in "athlet" table
$sql4 = "SELECT xAthlet FROM athlet WHERE Lizenznummer = '" . $license . "'";
$query4 = mysql_query($sql4);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-5-" . mysql_errno() . ": " . mysql_error());
}
if (mysql_num_rows($query4) > 0) {
$row4 = mysql_fetch_assoc($query4);
$sql3 = "UPDATE athlet \r\n SET Name = '" . trim($row2['lastname']) . "', \r\n Vorname = '" . trim($row2['firstname']) . "', \r\n Jahrgang = '" . trim($row2['jahrgang']) . "', \r\n Geschlecht = '" . trim($row2['sex']) . "', \r\n Land = '" . trim($row2['nationality']) . "', \r\n Geburtstag = '" . trim($row2['birth_date']) . "', \r\n xVerein = '" . trim($club) . "', \r\n xVerein2 = '" . trim($club2) . "', \r\n Lizenznummer = '" . trim($license) . "',\r\n Bezahlt = '" . trim($row2['license_paid']) . "',\r\n Manuell = 0 \r\n WHERE (Lizenznummer = '" . trim($license) . "' \r\n OR (Name = '" . trim($row2['lastname']) . "' \r\n AND Vorname = '" . trim($row2['firstname']) . "' \r\n AND Jahrgang = '" . trim($row2['jahrgang']) . "' \r\n AND xVerein = '" . trim($club) . "'));";
$query3 = mysql_query($sql3);
$xAthlete = $row4['xAthlet'];
} else {
// if club is valid
// insert athlete from base data
if (is_numeric($club)) {
$sql = "INSERT INTO athlet \r\n (Name, Vorname, Jahrgang, \r\n Lizenznummer, Geschlecht, Land, \r\n Geburtstag, xVerein, xVerein2, Bezahlt, Lizenztyp)\r\n SELECT \r\n TRIM(lastname), TRIM(firstname), substring(birth_date, 1,4), \r\n license, TRIM(sex), nationality, \r\n birth_date, '{$club}', '{$club2}', license_paid, '1'\r\n FROM\r\n base_athlete\r\n WHERE\r\n license = {$license}";
mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-6-" . mysql_errno() . ": " . mysql_error());
} else {
$xAthlete = mysql_insert_id();
}
}
}
if ($xAthlete > 0) {
// check if already registered
$result = mysql_query("SELECT xAnmeldung FROM anmeldung WHERE xAthlet = {$xAthlete} AND xMeeting = " . $_COOKIE['meeting_id'] . "");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-7-" . mysql_errno() . ": " . mysql_error());
} else {
// get license category from base data
$res = mysql_query(" \r\n SELECT k.xKategorie FROM\r\n kategorie as k\r\n LEFT JOIN base_athlete as b on (k.Code = b.license_cat)\r\n WHERE b.license = " . $license);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-8-" . mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_array($res);
$xCat = $row[0];
if ($xCat != '') {
if (mysql_num_rows($result) == 0) {
// not yet registered
// insert
mysql_query("INSERT INTO anmeldung SET\r\n Startnummer = 0\r\n , Bezahlt = '" . $row2['license_paid'] . "'\r\n , Gruppe = '" . $group . "' \r\n , xAthlet = {$xAthlete}\r\n , xMeeting = " . $_COOKIE['meeting_id'] . "\r\n , xKategorie = {$xCat}\r\n , Anmeldenr_ZLV = {$registerNr}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-9-" . mysql_errno() . ": " . mysql_error());
} else {
$xReg = mysql_insert_id();
}
} else {
// update
$row = mysql_fetch_array($result);
mysql_query("Update anmeldung SET\r\n Startnummer = 0\r\n , Bezahlt = '" . $row2['license_paid'] . "' \r\n , Gruppe = '" . $group . "' \r\n , xAthlet = {$xAthlete}\r\n , xMeeting = " . $_COOKIE['meeting_id'] . "\r\n , xKategorie = {$xCat}\r\n , Anmeldenr_ZLV = {$registerNr}\r\n WHERE xAnmeldung = {$row['0']}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-10-" . mysql_errno() . ": " . mysql_error());
} else {
$xReg = $row[0];
}
}
} else {
$result2 = mysql_query("SELECT license_cat \r\n FROM base_athlete\r\n WHERE license = {$license};");
$row2 = mysql_fetch_array($result2);
$license_cat = $row2[0];
AA_printErrorMsg(str_replace('%cat%', $license_cat, $strNoSuchCategory));
}
}
// only combined events for ZLV
// effort are points, saved on registration
$sql = "SELECT notification_effort \r\n FROM base_performance\r\n WHERE id_athlete = {$athlete_id}\r\n AND discipline = {$discode}";
$res_effort = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-11-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($res_effort) > 0) {
$row_effort = mysql_fetch_assoc($res_effort);
$effort = $row_effort['notification_effort'];
mysql_query("UPDATE anmeldung SET\r\n BestleistungMK = '{$effort}'\r\n , xMeeting = " . $_COOKIE['meeting_id'] . " \r\n WHERE\r\n xAnmeldung = {$xReg}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-12-" . mysql_errno() . ": " . mysql_error());
}
}
}
if ($xReg > 0) {
// check if athlete alredy starts for this discipline(s)
foreach ($xDis as $xDis1) {
// because we can get multiple disciplines (combined event),
// it is nessesary to determinate distype and discode for each discipline
// (catcode won't change)
$res_distype = mysql_query("\r\n SELECT d.Typ, d.Code, d.Appellzeit, d.Stellzeit FROM \r\n disziplin_" . $_COOKIE['language'] . " as d\r\n LEFT JOIN wettkampf as w ON (w.xDisziplin = d.xDisziplin)\r\n WHERE \r\n w.xWettkampf = {$xDis1}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-13-" . mysql_errno() . ": " . mysql_error());
} else {
$row_distype = mysql_fetch_Array($res_distype);
$distype = $row_distype[0];
$temp_discode = $row_distype[1];
}
$result = mysql_query("SELECT xStart FROM start WHERE xAnmeldung = {$xReg} and xWettkampf = {$xDis1}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-14-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($result) == 0) {
// not yet starting, add start
$saison = $_SESSION['meeting_infos']['Saison'];
if ($saison == '') {
$saison = "O";
//if no saison is set take outdoor
}
$sql = "SELECT\r\n base_performance.notification_effort\r\n FROM\r\n athletica.base_performance\r\n INNER JOIN athletica.disziplin_" . $_COOKIE['language'] . " AS d \r\n ON (base_performance.discipline = d.Code)\r\n INNER JOIN athletica.wettkampf \r\n ON (d.xDisziplin = wettkampf.xDisziplin)\r\n WHERE (base_performance.id_athlete ={$athlete_id}\r\n AND wettkampf.xWettkampf ={$xDis1}\r\n AND wettkampf.xMeeting =" . $_COOKIE['meeting_id'] . "\r\n AND base_performance.season ='I')";
$res_effort = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-15-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($res_effort) > 0) {
$row_effort = mysql_fetch_assoc($res_effort);
$effort = $row_effort['notification_effort'];
}
//
// convert effort
//
if ($distype == $cfgDisciplineType[$strDiscTypeTrack] || $distype == $cfgDisciplineType[$strDiscTypeTrackNoWind] || $distype == $cfgDisciplineType[$strDiscTypeRelay] || $distype == $cfgDisciplineType[$strDiscTypeDistance]) {
$pt = new PerformanceTime($effort);
$perf = $pt->getPerformance();
} else {
//echo $bigger;
$pa = new PerformanceAttempt($effort);
$perf = $pa->getPerformance();
//$perf = (ltrim($effort,"0"))*100;
}
if ($perf == NULL) {
// invalid performance
$perf = 0;
}
mysql_query("INSERT INTO start SET\r\n xWettkampf = {$xDis1} \r\n , Bezahlt = '{$license_paid}'\r\n , xAnmeldung = {$xReg} \r\n , Bestleistung = '" . $perf . "' \r\n , BaseEffort = 'y'");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-16-" . mysql_errno() . ": " . mysql_error());
}
}
}
}
// update group in round for every event
$sql_r = "SELECT Gruppe FROM runde WHERE xWettkampf = " . $xDis1;
$res_r = mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-16a-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($res_r) > 0) {
while ($row_r = mysql_fetch_row($res_r)) {
$arr_row[] = $row_r[0];
}
if ($arr_row[0] == "") {
//update group in round for every event
$sql_r = "UPDATE IGNORE runde SET Gruppe = '" . $group . "' WHERE xWettkampf = " . $xDis1;
mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-17-" . mysql_errno() . ": " . mysql_error());
}
} elseif (!in_array($group, $arr_row)) {
$stdEtime = strtotime($row_distype[2]);
// hold standard delay for enrolement time
$stdMtime = strtotime($row_distype[3]);
// and manipulation time
list($hr, $min) = AA_formatEnteredTime($starttime);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$appellTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$putTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
//insert group in round for every event
$sql_r = "INSERT INTO runde SET\r\n Datum = '" . $meetingDate . "', \r\n Startzeit = '" . $starttime . "', \r\n Appellzeit= '" . $appellTime . "', \r\n Stellzeit= '" . $putTime . "', \r\n Gruppe = '" . $group . "', \r\n xRundentyp = 8, \r\n xWettkampf = " . $xDis1;
mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-18-" . mysql_errno() . ": " . mysql_error());
}
}
} else {
$stdEtime = strtotime($row_distype[2]);
// hold standard delay for enrolement time
$stdMtime = strtotime($row_distype[3]);
// and manipulation time
list($hr, $min) = AA_formatEnteredTime($starttime);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$appellTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$putTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
//insert group in round for every event
$sql_r = "INSERT INTO runde SET\r\n Datum = '" . $meetingDate . "', \r\n Startzeit = '" . $starttime . "', \r\n Appellzeit= '" . $appellTime . "', \r\n Stellzeit= '" . $putTime . "', \r\n Gruppe = '" . $group . "', \r\n xRundentyp = 8, \r\n xWettkampf = " . $xDis1;
mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-18I-" . mysql_errno() . ": " . mysql_error());
}
}
}
}
// enf foreach
}
// end xReg > 0
}
}
// end xAthlete > 0
} else {
// athlete with this license not in base
if (!in_array($license, $arr_noCat)) {
$arr_noCat['lic'][] = $license;
}
}
}
} else {
// category not in meeting
if (!in_array($cat, $arr_noCat)) {
$arr_noCat['cat'][] = $cat;
}
}
} else {
// license = 0
// select event to get all generated events ids
$sql = "SELECT \r\n w.xWettkampf,\r\n w.Mehrkampfcode,\r\n k.xKategorie,\r\n m.DatumVon \r\n FROM\r\n wettkampf as w\r\n LEFT JOIN kategorie as k on (w.xKategorie = k.xKategorie )\r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d on (w.xDisziplin = d.xDisziplin)\r\n LEFT JOIN meeting AS m ON (m.xMeeting = w.xMeeting) \r\n WHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n AND k.Kurzname = '" . $cat . "'";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1) {
while ($row_dis = mysql_fetch_assoc($res)) {
$xDis[] = $row_dis['xWettkampf'];
if ($row_dis['Mehrkampfcode'] > 0) {
$discode = $row_dis['Mehrkampfcode'];
// same for all combined disciplines
}
$catnr = $row_dis['xKategorie'];
$meetingDate = $row_dis['DatumVon'];
}
$result2 = mysql_query("SELECT xVerein FROM verein WHERE xCode = '" . $club . "'");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-19-" . mysql_errno() . ": " . mysql_error());
} else {
$rowClub1 = mysql_fetch_array($result2);
$clubnr = $rowClub1[0];
}
mysql_free_result($result2);
// if club is valid
// insert athlete from base data
if (is_numeric($clubnr)) {
$name = mysql_real_escape_string(str_replace("\r", "\n", trim(utf8_decode($name))));
$firstname = mysql_real_escape_string(str_replace("\r", "\n", trim(utf8_decode($firstname))));
// if athlet exist
$sql = "SELECT * FROM athlet WHERE Name= '" . $name . "' AND Vorname = '" . $firstname . "' AND Geburtstag = '" . $birthdate . "'";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-20-" . mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_array($res);
if (mysql_num_rows($res) == 0) {
$sql = "INSERT IGNORE INTO athlet SET\r\n Name = '" . $name . "',\r\n Vorname = '" . $firstname . "', \r\n Jahrgang = '" . $birthyear . "', \r\n Lizenznummer = 0 , \r\n Geschlecht = '" . $sex . "', \r\n Land = '" . $nationality . "', \r\n Geburtstag = '" . $birthdate . "',\r\n Athleticagen = 'n', \r\n xVerein = '" . $clubnr . "', \r\n Bezahlt = '" . $license_paid . "', \r\n Lizenztyp = 3";
mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-21-" . mysql_errno() . ": " . mysql_error());
} else {
$xAthlete = mysql_insert_id();
}
} else {
$sql = "UPDATE athlet SET \r\n Jahrgang = '" . $birthyear . "', \r\n Geschlecht = '" . $sex . "', \r\n Land = '" . $nationality . "', \r\n xVerein = '" . $clubnr . "', \r\n Bezahlt = '" . $license_paid . "'\r\n WHERE Name= '" . $name . "' AND Vorname = '" . $firstname . "' AND Geburtstag = '" . $birthdate . "'";
mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-22-" . mysql_errno() . ": " . mysql_error());
} else {
$xAthlete = $row[0];
}
}
}
} else {
// club not found
if (!in_array($license, $arr_noCat)) {
$arr_noCat['club'][] = $club;
}
}
}
// end athlete found
if ($xAthlete > 0) {
// check if already registered
$result = mysql_query("SELECT xAnmeldung FROM anmeldung WHERE xAthlet = {$xAthlete} AND xMeeting = " . $_COOKIE['meeting_id'] . "");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-23-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($result) == 0) {
// not yet registered
if ($catnr != '') {
mysql_query("INSERT INTO anmeldung SET\r\n Startnummer = 0\r\n , Bezahlt = '{$license_paid}'\r\n , xAthlet = {$xAthlete}\r\n , xMeeting = " . $_COOKIE['meeting_id'] . "\r\n , xKategorie = {$catnr}\r\n , Anmeldenr_ZLV = {$registerNr}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-24-" . mysql_errno() . ": " . mysql_error());
} else {
$xReg = mysql_insert_id();
}
}
} else {
// registered
$row = mysql_fetch_array($result);
mysql_query("Update anmeldung SET\r\n Startnummer = 0\r\n , Bezahlt = '{$license_paid}'\r\n , xAthlet = {$xAthlete}\r\n , xMeeting = " . $_COOKIE['meeting_id'] . "\r\n , xKategorie = {$xCat}\r\n , Anmeldenr_ZLV = {$registerNr}\r\n WHERE xAnmeldung = {$row['0']}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-25-" . mysql_errno() . ": " . mysql_error());
} else {
$xReg = $row[0];
}
}
if ($xReg > 0) {
// check if athlete alredy starts for this discipline(s)
foreach ($xDis as $xDis1) {
// because we can get multiple disciplines (combined event),
// it is nessesary to determinate distype and discode for each discipline
// (catcode won't change)
$res_distype = mysql_query("\r\n SELECT d.Typ, d.Code, d.Appellzeit, d.Stellzeit FROM \r\n disziplin_" . $_COOKIE['language'] . " as d\r\n LEFT JOIN wettkampf as w ON (w.xDisziplin = d.xDisziplin)\r\n WHERE w.xWettkampf = {$xDis1}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-26-" . mysql_errno() . ": " . mysql_error());
} else {
$row_distype = mysql_fetch_Array($res_distype);
$distype = $row_distype[0];
$temp_discode = $row_distype[1];
}
$result = mysql_query("SELECT xStart FROM start WHERE xAnmeldung = {$xReg} and xWettkampf = {$xDis1}");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-27-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($result) == 0) {
// not yet starting, add start
$saison = $_SESSION['meeting_infos']['Saison'];
if ($saison == '') {
$saison = "O";
//if no saison is set take outdoor
}
mysql_query("INSERT INTO start SET\r\n xWettkampf = {$xDis1}\r\n , Bezahlt = '{$license_paid}'\r\n , xAnmeldung = {$xReg}\r\n ");
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-28-" . mysql_errno() . ": " . mysql_error());
}
}
}
// update group in round for every event
$sql_r = "SELECT Gruppe FROM runde WHERE xWettkampf = " . $xDis1;
$res_r = mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-28a-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($res_r) > 0) {
while ($row_r = mysql_fetch_row($res_r)) {
$arr_row[] = $row_r[0];
}
if ($arr_row[0] == "") {
//update group in round for every event
$sql_r = "UPDATE IGNORE runde SET Gruppe = " . $group . " WHERE xWettkampf = " . $xDis1;
mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-29-" . mysql_errno() . ": " . mysql_error());
}
} elseif (!in_array($group, $arr_row)) {
$stdEtime = strtotime($row_distype[2]);
// hold standard delay for enrolement time
$stdMtime = strtotime($row_distype[3]);
// and manipulation time
list($hr, $min) = AA_formatEnteredTime($starttime);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$appellTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$putTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
//insert group in round for every event
$sql_r = "INSERT INTO runde SET\r\n Datum = '" . $meetingDate . "', \r\n Startzeit = '" . $starttime . "', \r\n Appellzeit= '" . $appellTime . "', \r\n Stellzeit= '" . $putTime . "', \r\n Gruppe = '" . $group . "', \r\n xRundentyp = 8, \r\n xWettkampf = " . $xDis1;
mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-30-" . mysql_errno() . ": " . mysql_error());
}
}
} else {
$stdEtime = strtotime($row_distype[2]);
// hold standard delay for enrolement time
$stdMtime = strtotime($row_distype[3]);
// and manipulation time
list($hr, $min) = AA_formatEnteredTime($starttime);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdEtime;
$appellTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
$tmp = strtotime($hr . ":" . $min . ":00");
$tmp = $tmp - $stdMtime;
$putTime = floor($tmp / 3600) . ":" . floor($tmp % 3600 / 60);
//insert group in round for every event
$sql_r = "INSERT INTO runde SET\r\n Datum = '" . $meetingDate . "', \r\n Startzeit = '" . $starttime . "', \r\n Appellzeit= '" . $appellTime . "', \r\n Stellzeit= '" . $putTime . "', \r\n Gruppe = '" . $group . "', \r\n xRundentyp = 8, \r\n xWettkampf = " . $xDis1;
mysql_query($sql_r);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-18I-" . mysql_errno() . ": " . mysql_error());
}
}
}
// end foreach
}
}
// end xReg > 0
}
}
// end xAthlete > 0
}
}
// end ATHLETE
if ($name == "ANMELDUNG") {
$regNr = $attr['ANMELDENR'];
$team = $attr['MANNSCHAFT'];
$cat = $attr['KATEGORIE'];
$license = $attr['LIZENZNR'];
$group = $attr['GRUPPENR'];
$club = $attr['VEREIN'];
$registerNr = $attr['ANMELDENR'];
$sql = "SELECT id_athlete FROM base_athlete WHERE license = '" . $license . "';";
$query = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-31-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($query) > 0 || $license == '') {
// athlete not in base
if (!in_array($cat, $arr_noCat)) {
// get the eventnumber of this meeting for generating a team id in the form eventnumber999 (xxxxxx999)
$res = mysql_query("SELECT xControl FROM meeting WHERE xMeeting = " . $_COOKIE['meeting_id']);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-32-" . mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_array($res);
$eventnr = $row[0];
if (empty($eventnr)) {
$idcounter = "";
} else {
mysql_free_result($res);
$arrid = array();
$res = mysql_query("select max(xStaffel) from staffel where xStaffel like '{$eventnr}%'");
$row = mysql_fetch_array($res);
$arrid[] = $row[0];
$res = mysql_query("select max(xTeam) from team where xTeam like '{$eventnr}%'");
$row = mysql_fetch_array($res);
$arrid[] = $row[0];
$res = mysql_query("select max(id_relay) from base_relay where id_relay like '{$eventnr}%'");
$row = mysql_fetch_array($res);
$arrid[] = $row[0];
$res = mysql_query("select max(id_svm) from base_svm where id_svm like '{$eventnr}%'");
$row = mysql_fetch_array($res);
$arrid[] = $row[0];
rsort($arrid);
$biggestId = $arrid[0];
if ($biggestId == 0 || strlen($biggestId) != 9) {
$idcounter = "001";
} else {
$idcounter = substr($biggestId, 6, 3);
$idcounter++;
$idcounter = sprintf("%03d", $idcounter);
}
$xTeamSQL = ", xTeam = " . $eventnr . $idcounter . ", Athleticagen ='y' ";
}
}
$sql = "SELECT xKategorie FROM kategorie WHERE Kurzname = '" . $cat . "'";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-33-" . mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($res);
$catnr = $row[0];
$sql = "SELECT xVerein FROM verein WHERE xCode = '" . $club . "'";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-34-" . mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($res);
$clubnr = $row[0];
if ($license > 0) {
$sql_a = "SELECT \r\n an.xAnmeldung\r\n FROM\r\n athlet AS a\r\n LEFT JOIN anmeldung AS an ON (a.xAthlet = an.xAthlet)\r\n WHERE\r\n a.Lizenznummer = " . $license . "\r\n AND an.xMeeting = " . $_COOKIE['meeting_id'];
} else {
$sql_a = "SELECT \r\n an.xAnmeldung\r\n FROM\r\n athlet AS a\r\n LEFT JOIN anmeldung AS an ON (a.xAthlet = an.xAthlet)\r\n WHERE\r\n an.Anmeldenr_ZLV = " . $registerNr . "\r\n AND an.xMeeting = " . $_COOKIE['meeting_id'];
}
$result = mysql_query($sql_a);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-35-" . mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($result) >= 1) {
$row_a = mysql_fetch_row($result);
$sql = "SELECT xTeam FROM team WHERE Name = '" . $team . "' AND xMeeting=" . $_COOKIE['meeting_id'] . " AND xKategorie = " . $catnr . " AND xVerein=" . $clubnr;
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
$row = mysql_fetch_array($res);
$xTeam = $row[0];
} else {
if ($clubnr > 0) {
// no club exist --> error msg in ATHLETE
$sql = "INSERT IGNORE INTO team SET \r\n Name=\"" . $team . "\"\r\n , xMeeting=" . $_COOKIE['meeting_id'] . "\r\n , xKategorie = " . $catnr . "\r\n , xVerein=" . $clubnr . $xTeamSQL;
mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-36-" . mysql_errno() . ": " . mysql_error());
} else {
$xTeam = mysql_insert_id();
// get new ID
}
}
}
$sql = "UPDATE anmeldung SET xTeam = '" . $xTeam . "', Gruppe = '" . $group . "' WHERE xAnmeldung = " . $row_a[0] . " AND xMeeting = " . $_COOKIE['meeting_id'];
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg("xml-37-" . mysql_errno() . ": " . mysql_error());
}
}
}
}
}
}
}
}
}
// end ANMELDUNG
}
