AA_meeting_addSVMEvent($_SESSION['meeting_infos']['Startgeld'] / 100, $_SESSION['meeting_infos']['Haftgeld'] / 100); } mysql_query("UNLOCK TABLES"); if ($GLOBALS['AA_ERROR'] != '') { AA_printErrorMsg($GLOBALS['AA_ERROR']); } } } } } elseif ($_POST['arg'] == "add_combtype") { AA_meeting_addCombinedEvent($_SESSION['meeting_infos']['Startgeld'] / 100, $_SESSION['meeting_infos']['Haftgeld'] / 100); } elseif ($_POST['arg'] == "add_svmcat") { AA_Meeting_getEventType(); $_POST['date'] = $_SESSION['meeting_infos']['DatumVon']; $_POST['svm'] = $_POST['svmcategory']; AA_meeting_addSVMEvent($_SESSION['meeting_infos']['Startgeld'] / 100, $_SESSION['meeting_infos']['Haftgeld'] / 100); if ($GLOBALS['AA_ERROR'] != '') { AA_printErrorMsg($GLOBALS['AA_ERROR']); } } elseif ($_POST['arg'] == "change_formula") { if (isset($_POST['nocat'])) { AA_meeting_changeFormula(); } else { AA_meeting_changeCategory($_POST['item']); } } elseif ($_POST['arg'] == "new_discipline") { if (!empty($_POST['combtype'])) { $t = $_POST['combtype']; // get short name $res = mysql_query("SELECT Kurzname, Name FROM disziplin_" . $_COOKIE['language'] . " WHERE Code = {$t}"); $row = mysql_fetch_array($res);
function XML_reg_start($parser, $name, $attr) { global $discode, $catcode, $xDis, $distype, $bCombined; global $strBaseAthleteNotFound, $strBaseTeamNotFound, $strBaseRelayNotFound, $strLicenseNr; global $cfgDisciplineType, $cfgEventType, $strEventTypeSingleCombined, $strEventTypeClubCombined, $strDiscTypeTrack, $strDiscTypeTrackNoWind, $strDiscTypeRelay, $strDiscTypeDistance, $strErrNoSuchDisCode, $strNoSuchCategory; global $cfgCombinedDef, $cfgCombinedWO, $appnbr; global $cfgSVM, $relay_id, $relay_pos, $relay_round, $relay_xStart, $category, $team_type, $paid; global $arr_noCat, $cfgResDisc, $cfgSvmDiscFirst, $cfgSvmDiscLast; // // get approval number // if ($name == "MEETDATASET") { $appnbr = $attr['APPROVAL']; mysql_query("UPDATE meeting SET Nummer = '{$appnbr}' WHERE xMeeting = " . $_COOKIE['meeting_id']); $team_type = ''; } // // get costs (entry_fee, entry_fee_reduction, penalty) // if ($name == "MEETDATASET") { $meet_fee_red = $attr['ENTRY_FEE_REDUCTION']; mysql_query("UPDATE meeting SET StartgeldReduktion = '{$meet_fee_red}' WHERE xMeeting = " . $_COOKIE['meeting_id']); } if ($name == "MEETDATASET") { $meet_fee = $attr['ENTRY_FEE']; mysql_query("UPDATE meeting SET Startgeld = '{$meet_fee}' WHERE xMeeting = " . $_COOKIE['meeting_id']); } if ($name == "MEETDATASET") { $meet_penalty = $attr['PENALTY']; mysql_query("UPDATE meeting SET Haftgeld = '{$meet_penalty}' WHERE xMeeting = " . $_COOKIE['meeting_id']); $_SESSION['meeting_infos']['Haftgeld'] = $meet_penalty; } // // start of discipline // if ($name == "DISCIPLINE") { $xDis = array(); $discode = $attr['DISCODE']; $svmCategoryCode = $attr['SVMCATEGORYCODE']; if ($svmCategoryCode == '36_09') { $catcode = 'U12M'; } else { $catcode = $attr['CATCODE']; } $disname = trim($attr['DISNAME']); // special name of discipline, ordinary disname + info (cold be user defined) $disinfo = trim($attr['DISINFO']); // special name of discipline, without ordinary disc-name (cold be user defined) $disspecial = $attr['DISSPECIAL']; $disfee = 0; $disfee = $attr['DISFEE'] / 100; $disid = $attr['DISID']; $type = $attr['TYPE']; $svmCatCode = 0; $xCatSvm = 0; if (isset($attr['SVMCATEGORYCODE'])) { $svmCatCode = $attr['SVMCATEGORYCODE']; // get svm xCat $res = mysql_query("SELECT xKategorie_svm FROM kategorie_svm WHERE Code = '{$svmCatCode}'"); if (mysql_errno() > 0) { XML_db_error("23-" . mysql_errno() . ": " . mysql_error()); } $row = mysql_fetch_row($res); $xCatSvm = $row[0]; } $relay_id = 0; $relay_round = 0; // check discode and return if it doesn't exists $res = mysql_query("SELECT xDisziplin FROM disziplin_" . $_COOKIE['language'] . " WHERE Code = '{$discode}'"); if (mysql_errno() == 0) { if (mysql_num_rows($res) == 0 && ($discode < $cfgResDisc && $discode > $cfgSvmDiscLast)) { echo "<p>{$strErrNoSuchDisCode} {$disname} ({$discode})</p>"; return; } mysql_free_result($res); } // if this is a self specified discipline, check onlineid to differentiate $SQLdisSpecial = ""; if ($disspecial == "y") { $SQLdisSpecial = " AND w.OnlineId = '{$disid}' "; } else { $disname = ""; // do not fill the info-field with disname if there is no need } // if this is a discipline with info, check additonal the info to differentiate $SQLdisInfo = ""; if (strlen($disinfo) != 0) { //$SQLdisInfo = " AND w.OnlineId = '$disid' "; $SQLdisInfo = " AND w.Info = '{$disinfo}' "; $disname = $disinfo; } else { $disname = ""; // do not fill the info-field with disname if there is no need } // combined event if (isset($cfgCombinedDef[$discode])) { $bCombined = true; // check if this combined event exists $query = "SELECT * \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 WHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n AND k.Code = '{$catcode}'\r\n AND w.Mehrkampfcode = {$discode}"; $res = mysql_query($query); } else { $bCombined = false; if ($discode >= $cfgSvmDiscFirst && $discode <= $cfgSvmDiscLast) { $query = "SELECT * \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 WHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n AND xKategorie_svm = " . $xCatSvm . " \r\n AND w.Mehrkampfcode = 0\r\n {$SQLdisSpecial} \r\n {$SQLdisInfo} "; $res = mysql_query($query); while ($row_dis = mysql_fetch_assoc($res)) { $xDis[] = $row_dis['xWettkampf']; } } else { // check if this discipline exists // important: Mehrkampfcode has to be 0, else the query will also select // the already defined combined events (if the same discipline) $query = "SELECT * \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 WHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n AND k.Code = '{$catcode}'\r\n AND d.Code = {$discode} \r\n AND xKategorie_svm = " . $xCatSvm . " \r\n AND w.Mehrkampfcode = 0\r\n {$SQLdisSpecial} \r\n {$SQLdisInfo} "; $res = mysql_query($query); } } if (mysql_errno() > 0) { XML_db_error("1-" . mysql_errno() . ": " . mysql_error()); } else { $res_catcode = mysql_query("SELECT xKategorie FROM kategorie WHERE Code = '{$catcode}'"); if (mysql_errno() > 0) { XML_db_error("2-" . mysql_errno() . ": " . mysql_error()); } else { $row_catcode = mysql_fetch_array($res_catcode); $category = $row_catcode[0]; if ($bCombined) { // create combined disciplines if (mysql_num_rows($res) == 0) { $_POST['combinedtype'] = $discode; // needed by addCombinedEvent $_POST['cat'] = $row_catcode[0]; // needed by addCombinedEvent AA_meeting_addCombinedEvent($disfee, $_SESSION['meeting_infos']['Haftgeld'] / 100); //$xDis = $cfgCombinedWO[$cfgCombinedDef[$discode]]; } } } if ($bCombined) { // create combined disciplines if (mysql_num_rows($res) == 0) { // select again to get all generated xWettkampf ids $query = "SELECT \r\n w.xWettkampf \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 WHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n AND k.Code = '{$catcode}'\r\n AND w.Mehrkampfcode = {$discode}"; $res = mysql_query($query); while ($row_dis = mysql_fetch_assoc($res)) { $xDis[] = $row_dis['xWettkampf']; } } else { // combined event already exists, get existing disciplines while ($row_dis = mysql_fetch_assoc($res)) { $xDis[] = $row_dis['xWettkampf']; } } } else { // create single disciplines if ($discode < $cfgResDisc || $discode > $cfgSvmDiscLast) { if (mysql_num_rows($res) == 0) { //discipline does not exist // insert // ($disname will be empty if this is not a "special" discipline) $sql = "INSERT INTO \r\n wettkampf (xKategorie, xDisziplin, xMeeting\r\n , Info, Haftgeld, Startgeld, OnlineId)\r\n SELECT \r\n k.xKategorie\r\n , d.xDisziplin\r\n , " . $_COOKIE['meeting_id'] . "\r\n , '{$disname}'\r\n , " . $_SESSION['meeting_infos']['Haftgeld'] / 100 . "\r\n , '{$disfee}'\r\n , '{$disid}'\r\n FROM\r\n disziplin_" . $_COOKIE['language'] . " as d\r\n , (kategorie as k)\r\n WHERE d.Code = {$discode}\r\n AND k.Code = '{$catcode}'"; mysql_query($sql); if (mysql_errno() > 0) { XML_db_error("3-" . mysql_errno() . ": " . mysql_error()); } else { $xDis[] = mysql_insert_id(); } } else { $row_dis = mysql_fetch_assoc($res); $xDis[] = $row_dis['xWettkampf']; } } } } } // // start of an athlete // if ($name == "ATHLETE" && (count($xDis) != 0 || $discode == $cfgResDisc || $discode >= $cfgSvmDiscFirst && $discode <= $cfgSvmDiscLast)) { $license = $attr['LICENSE']; if (isset($attr['PAID'])) { $paid = $attr['PAID']; } $relayDisc = AA_checkRelayDisc($discode); $effort = $attr['NOTIFICATIONEFFORT']; if ($relay_id > 0) { $relay_pos++; } $team_id = 0; $xTeam = 0; if (isset($attr['SVMTEAMID'])) { $team_id = $attr['SVMTEAMID']; $sql = "SELECT * FROM team WHERE xTeam = " . $team_id; $res = mysql_query($sql); if (mysql_num_rows($res) == 0) { return; } } if ($relay_id == 0 && $relayDisc) { // if event is a relay and the relay-id doesn't exist --> no announcement for the athletes } else { $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 account_info\r\n FROM base_athlete \r\n WHERE license = '" . $license . "';"; $query2 = mysql_query($sql2); if ($query2 && mysql_num_rows($query2) == 1) { $row2 = mysql_fetch_assoc($query2); $club = $row2['account_code']; $club2 = $row2['second_account_code']; $vInfo = $row2['account_info']; $athlete_id = $row2['id_athlete']; $result2 = mysql_query("SELECT xVerein FROM verein WHERE xCode = '" . $club . "'"); if (mysql_errno() > 0) { XML_db_error("6-" . 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) { XML_db_error("7-" . 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 there are manual changes $sql4 = "SELECT Vorname, Name, xVerein, Manuell FROM athlet WHERE Lizenznummer = '" . $license . "'"; $query4 = mysql_query($sql4); if (mysql_num_rows($query4) > 0) { $row4 = mysql_fetch_assoc($query4); if ($row4['Manuell'] == '0' || $GLOBALS['mode'] == 'overwrite') { // overwrite the manual changes $sql3 = "UPDATE athlet \r\n SET Name = '" . addslashes(trim($row2['lastname'])) . "', \r\n Vorname = '" . addslashes(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 Manuell = 0 \r\n WHERE (Lizenznummer = '" . trim($license) . "' \r\n OR (Name = '" . addslashes(trim($row2['lastname'])) . "' \r\n AND Vorname = '" . addslashes(trim($row2['firstname'])) . "' \r\n AND Jahrgang = '" . trim($row2['jahrgang']) . "' \r\n AND xVerein = '" . trim($club) . "'));"; } else { switch ($row4['Manuell']) { case 1: $firstname = trim($row2['firstname']); $name = trim($row4['Name']); $verein = trim($club); break; case 2: $firstname = $row4['Vorname']; $name = trim($row2['lastname']); $verein = trim($club); break; case 3: $firstname = trim($row2['firstname']); $name = trim($row2['lastname']); $verein = $row4['xVerein']; break; case 4: $firstname = $row4['Vorname']; $name = $row4['Name']; $verein = trim($club); break; case 5: $firstname = trim($row2['firstname']); $name = $row4['Name']; $verein = $row4['xVerein']; break; case 6: $firstname = $row4['Vorname']; $name = trim($row2['lastname']); $verein = $row4['xVerein']; break; case 7: $firstname = $row4['Vorname']; $name = $row4['Name']; $verein = $row4['xVerein']; break; default: break; } $sql3 = "UPDATE athlet \r\n SET Name = '" . addslashes($name) . "', \r\n Vorname = '" . addslashes($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 = '" . $verein . "', \r\n xVerein2 = '" . trim($club2) . "', \r\n Lizenznummer = '" . trim($athlete['LICENSE']) . "' \r\n WHERE (Lizenznummer = '" . trim($athlete['LICENSE']) . "' \r\n OR (Name = '" . addslashes(trim($row2['lastname'])) . "' \r\n AND Vorname = '" . addslashes(trim($row2['firstname'])) . "' \r\n AND Jahrgang = '" . trim($row2['jahrgang']) . "' \r\n AND xVerein = '" . trim($club) . "'));"; } $query3 = mysql_query($sql3); if (mysql_errno() > 0) { XML_db_error("4-" . mysql_errno() . ": " . mysql_error()); } } } // check if athlete is already in "athlet" table $result = mysql_query("SELECT xAthlet FROM athlet WHERE Lizenznummer = {$license}"); if (mysql_errno() > 0) { XML_db_error("4-" . mysql_errno() . ": " . mysql_error()); } else { //first copy athlete from base if (mysql_num_rows($result) == 0) { $sql = "SELECT * FROM base_athlete\r\n WHERE license = {$license}"; $res = mysql_query($sql); if (!$res) { AA_printErrorMsg("5-" . mysql_errno() . ": " . mysql_error()); } else { // check if athlete exists in base if (mysql_num_rows($res) == 0) { // athlete not found in base data echo "<p>{$strBaseAthleteNotFound}: {$strLicenseNr} {$license}</p>\n"; $xAthlete = 0; } else { // get club id from club code $row = mysql_fetch_assoc($res); $club = $row['account_code']; $club2 = $row['second_account_code']; $athlete_id = $row['id_athlete']; $result2 = mysql_query("SELECT xVerein FROM verein WHERE xCode = '" . $club . "'"); if (mysql_errno() > 0) { XML_db_error("6-" . 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) { XML_db_error("7-" . mysql_errno() . ": " . mysql_error()); $club2 = 0; // prevents from insert error in next statement } else { $rowClub2 = mysql_fetch_array($result2); $club2 = $rowClub2[0]; } } } mysql_free_result($result2); // if club is valid // insert athlete from base data if (is_numeric($club)) { $sql = " INSERT IGNORE INTO athlet \r\n (Name, Vorname, Jahrgang, \r\n Lizenznummer, Geschlecht, Land, \r\n Geburtstag, xVerein, xVerein2)\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}'\r\n FROM\r\n base_athlete\r\n WHERE\r\n license = {$license}"; mysql_query($sql); if (mysql_errno() > 0) { XML_db_error("8-" . mysql_errno() . ": " . mysql_error()); } else { $xAthlete = mysql_insert_id(); if ($xAthlete == 0 || empty($xAthlete)) { echo "<p>++: {$strBaseAthleteNotFound}: {$strLicenseNr} {$license}</p>\n"; } } } } // end athlete found } } else { // athlete already available // check if athlete is still in base data (he could be deleted) $sql = "SELECT * FROM base_athlete\r\n WHERE license = {$license}"; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error("5b-" . mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($res) == 0) { // athlete deleted echo "<p>{$strBaseAthleteNotFound} (deleted): {$strLicenseNr} {$license}</p>\n"; $xAthlete = 0; } else { // athlete available, get id $row = mysql_fetch_array($result); $xAthlete = $row[0]; } } } if ($xAthlete > 0) { // check if already registered $result = mysql_query("SELECT xAnmeldung, xTeam , xKategorie FROM anmeldung WHERE xAthlet = {$xAthlete} AND xMeeting = " . $_COOKIE['meeting_id'] . ""); if (mysql_errno() > 0) { XML_db_error("9-" . mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($result) == 0) { // not yet registered // get license category from base data $result = mysql_query(" \r\n SELECT k.xKategorie FROM\r\n kategorie as k\r\n , base_athlete as b\r\n WHERE b.license = {$license}\r\n AND k.Code = b.license_cat"); if (mysql_errno() > 0) { XML_db_error("10-" . mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result); $xCat = $row[0]; if ($xCat != '') { mysql_query(" INSERT INTO anmeldung SET\r\n Startnummer = 0\r\n , Bezahlt = '{$paid}'\r\n , xAthlet = {$xAthlete}\r\n , xMeeting = " . $_COOKIE['meeting_id'] . "\r\n , xKategorie = {$xCat}\r\n , Vereinsinfo = '{$vInfo}'\r\n , xTeam = " . $team_id); if (mysql_errno() > 0) { XML_db_error("11-" . mysql_errno() . ": " . mysql_error()); } else { $xReg = mysql_insert_id(); } } 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]; XML_db_error(str_replace('%cat%', $license_cat, $strNoSuchCategory)); } } else { } } } else { // registered $row = mysql_fetch_array($result); $xReg = $row[0]; $xTeam = $row[1]; $xCat = $row[2]; if ($xTeam != $team_id && $team_id > 0) { if ($xTeam > 0) { if (!in_array($xTeam, $arr_noCat[$xAthlete])) { $arr_noCat[$xAthlete][] = $xTeam; } } if (!in_array($team_id, $arr_noCat[$xAthlete])) { $arr_noCat[$xAthlete][] = $team_id; } } } if ($bCombined) { // 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) { XML_db_error("12-" . 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 WHERE\r\n xAnmeldung = {$xReg}"); } } } 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 \r\n d.Typ, d.Code \r\n 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) { XML_db_error("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) { XML_db_error("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 } if (!$bCombined) { // check on notification effort. $res_effort = mysql_query("\r\n SELECT * FROM base_performance\r\n WHERE id_athlete = {$athlete_id}\r\n AND discipline = {$temp_discode}\r\n AND category = '{$catcode}'"); $sql = "SELECT * FROM base_performance\r\n WHERE id_athlete = {$athlete_id}\r\n AND discipline = {$temp_discode}\r\n AND category = '{$catcode}'"; } else { $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) { XML_db_error("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 { $pa = new PerformanceAttempt($effort); $perf = $pa->getPerformance(); //$perf = (ltrim($effort,"0"))*100; } if ($perf == NULL) { // invalid performance $perf = 0; } $sql = "INSERT INTO start SET\r\n xWettkampf = {$xDis1}\r\n , Bezahlt = '{$paid}'\r\n , xAnmeldung = {$xReg}\r\n , Bestleistung = '" . $perf . "' \r\n , BaseEffort = 'y'"; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error("16-" . mysql_errno() . ": " . mysql_error()); } if ($relay_id > 0) { $xStart = mysql_insert_id(); $sql = "INSERT INTO staffelathlet SET\r\n xStaffelstart=" . $relay_xStart . " \r\n , xAthletenstart = " . $xStart . "\r\n , xRunde = " . $relay_round . "\r\n , Position = " . $relay_pos; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error("16-" . mysql_errno() . ": " . mysql_error()); } } } } } } // enf foreach } // end xReg > 0 } } // end xAthlete > 0 } } } // // start of a relay // if ($name == "RELAY" && count($xDis) != 0) { $id = $attr['ID']; $paid = $attr['PAID']; $notificationEffort = $attr['NOTIFICATIONEFFORT']; $teamID = $attr['TEAMID']; $relay_id = 0; $xDis1 = $xDis[0]; $relay_pos = 0; // check if relay is already in table staffel $res = mysql_query("SELECT xStaffel FROM staffel WHERE xStaffel = {$id}"); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($res) == 0) { // // no, insert relay (get category first) // $result = mysql_query(" SELECT k.xKategorie, b.is_athletica_gen, b.relay_name, b.account_code FROM\r\n kategorie as k\r\n LEFT JOIN base_relay as b ON (k.Code = b.category)\r\n WHERE \r\n b.id_relay = '{$id}'"); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result); $cat = $row[0]; if (empty($teamID)) { $teamID = 0; } mysql_query("\r\n INSERT IGNORE INTO staffel\r\n (xStaffel, Name, xVerein\r\n , xMeeting, xKategorie, Athleticagen, xTeam)\r\n SELECT\r\n id_relay, relay_name, account_code\r\n , " . $_COOKIE['meeting_id'] . ", '{$cat}',is_athletica_gen , {$teamID}\r\n FROM\r\n base_relay\r\n WHERE\r\n id_relay = '{$id}'"); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { $relay_id = $id; // do not use mysql_insert_id() - it will return 0 // like this i will notice if the insert succeeded or not if (mysql_affected_rows() == 0) { echo "Fehler: Staffel ID {$id}"; } } } else { $msg = str_replace('%id%', $id, $strBaseRelayNotFound); echo "<p>{$msg}: </p>\n"; } } } else { // // yes, relay found // if (!empty($teamID)) { $sql = "UPDATE staffel SET xTeam = " . $teamID . " WHERE xStaffel = " . $id; mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { $relay_id = $id; // do not use mysql_insert_id() - it will return 0 } } else { $row = mysql_fetch_array($res); $relay_id = $row[0]; } } // // add start for discipline // if ($relay_id > 0) { $sql = "SELECT \r\n xStart, xRunde \r\n FROM \r\n start AS s\r\n LEFT JOIN runde AS r ON (r.xWettkampf = s.xWettkampf) \r\n WHERE \r\n s.xWettkampf = " . $xDis1 . " AND s.xStaffel = " . $relay_id; $result = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($result) == 0) { // insert into table start mysql_query("\r\n INSERT INTO start SET \r\n Bezahlt = '" . $paid . "',\r\n xWettkampf = {$xDis1}\r\n , xStaffel = {$relay_id}"); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } $relay_xStart = mysql_insert_id(); if ($team_type == "SVM") { $sql = "SELECT \r\n xRunde \r\n FROM \r\n start AS s\r\n LEFT JOIN runde AS r ON (r.xWettkampf = s.xWettkampf) \r\n WHERE \r\n s.xWettkampf = " . $xDis1 . " AND s.xStaffel = " . $relay_id; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { $row = mysql_fetch_row($res); $relay_round = $row[0]; } } else { $sql = "SELECT \r\n r.xRunde, w.xWettkampf , d.Code , d.Typ, m.DatumVon\r\n FROM\r\n wettkampf as w\r\n LEFT JOIN runde as r On (w.xWettkampf = r.xWettkampf)\r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d ON (d.xDisziplin = w.xDisziplin)\r\n LEFT JOIN meeting as m ON (m.xMeeting = w.xMeeting)\r\n WHERE\r\n w.xKategorie = " . $category . " \r\n AND w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n ORDER BY d.Anzeige"; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { $row = mysql_fetch_row($res); // check if dummy round already exists if ($relay_id > 0) { $event = $xDis1; } else { $event = $row[1]; } $sql = "SELECT * FROM runde WHERE xWettkampf = " . $event; $res = mysql_query($sql); if (mysql_num_rows($res) == 0) { // add dummy round for relay $sql = "INSERT into runde SET\r\n Datum = '" . $row[4] . "' \r\n , xRundentyp = 6 \r\n , xWettkampf = " . $event; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } $relay_round = mysql_insert_id(); } } } } else { // already entered $row = mysql_fetch_array($result); $relay_xStart = $row[0]; $relay_round = $row[1]; $sql = "UPDATE start SET \r\n Bezahlt = '" . $paid . "'\r\n WHERE xStart = " . $relay_xStart; mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } } } } } } if ($name == "TEAM") { $id = $attr['TEAMID']; $team_type = $attr['TYPE']; $team_name = $attr['NAME']; $svm_cat = $attr['SVMCATEGORYCODE']; $team_id = 0; if ($team_type == "SVM") { $teamInBase = true; // check if team with same id is already in table team $sql = "SELECT xTeam FROM team WHERE xTeam = " . $id . " AND xMeeting = " . $_COOKIE['meeting_id']; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($res) == 0) { // // no, insert relay (get category first) // $sql = "SELECT k.Code, b.is_athletica_gen, b.svm_name, b.account_code FROM\r\n kategorie_svm as k\r\n LEFT JOIN base_svm as b ON (k.Code = b.svm_category)\r\n WHERE \r\n b.id_svm = '{$id}'"; $result = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result); $svmCode = $row[0]; $cat = 0; if (isset($cfgSVM[$svmCode . "_C"])) { $cat_code = $cfgSVM[$svmCode . "_C"]; } $sql = "SELECT xKategorie FROM kategorie WHERE Code = '" . $cat_code . "'"; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } $row_cat = mysql_fetch_row($res); $cat = $row_cat[0]; // get svm cat $sql = "SELECT xKategorie_svm FROM kategorie_svm WHERE Code = '" . $svm_cat . "'"; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } $row_cat_svm = mysql_fetch_row($res); $xCat_svm = $row_cat_svm[0]; $sql = "SELECT xTeam FROM team WHERE xKategorie = " . $cat . " AND Name = '" . $team_name . "' AND xKategorie_svm = " . $xCat_svm . " AND xMeeting = " . $_COOKIE['meeting_id']; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } if (mysql_num_rows($res) > 0) { $row_team = mysql_fetch_row($res); $sql = "UPDATE team\r\n SET \r\n xTeam = " . $row[3] . ",\r\n Athleticagen = '" . $row[1] . "'\r\n WHERE\r\n xTeam = " . $row_team[0]; } else { $sql = "INSERT IGNORE INTO team\r\n (xTeam, Name, Athleticagen, xMeeting,\r\n xVerein , xKategorie, xKategorie_svm )\r\n SELECT\r\n id_svm, svm_name, is_athletica_gen , " . $_COOKIE['meeting_id'] . ",\r\n account_code , '{$cat}' , '{$xCat_svm}'\r\n \r\n FROM\r\n base_svm\r\n WHERE\r\n id_svm = '{$id}'"; } mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } else { $team_id = $id; // do not use mysql_insert_id() - it will return 0 // like this i will notice if the insert succeeded or not if (mysql_affected_rows() == 0) { echo "Fehler: Team ID {$id}"; } } } else { // team not in base data $msg = str_replace('%name%', $team_name, $strBaseTeamNotFound); $msg = str_replace('%id%', $id, $msg); echo "<p>{$msg}: </p>\n"; $teamInBase = false; } } } else { // // yes, team found // $row = mysql_fetch_array($res); $team_id = $row[0]; } } } } if ($name == "SVMCATCODE") { $svmCode = $attr['SVMCATEGORYCODE']; // // create SVM disciplines $cat = 0; if (isset($cfgSVM[$svmCode . "_C"])) { $cat_code = $cfgSVM[$svmCode . "_C"]; } $sql = "SELECT xKategorie FROM kategorie WHERE Code = '" . $cat_code . "'"; $res = mysql_query($sql); if (mysql_errno() > 0) { XML_db_error(mysql_errno() . ": " . mysql_error()); } $row_cat = mysql_fetch_row($res); $cat = $row_cat[0]; $_POST['cat'] = $row_cat[0]; $res = mysql_query("SELECT ks.xKategorie_svm FROM kategorie_svm AS ks WHERE ks.Code = '{$svmCode}'"); $row = mysql_fetch_array($res); $_POST['svmcategory'] = $row[0]; $_POST['svm'] = $row[0]; $sql = "SELECT \r\n m.DatumVon\r\n FROM \r\n meeting AS m\r\n WHERE \r\n m.xMeeting = " . $_COOKIE['meeting_id']; $res = mysql_query($sql); $row = mysql_fetch_row($res); $_POST['date'] = $row[0]; $_POST['wTyp'] = $cfgSVM[$svmCode . "_ET"]; AA_meeting_addSVMEvent($_SESSION['meeting_infos']['Startgeld'] / 100, $_SESSION['meeting_infos']['Haftgeld'] / 100); } }