if (mysql_num_rows($res_event) > 0) { // data found $row = mysql_fetch_row($res_event); $event = $row[0]; } } $mainEvent = AA_getMainRoundEvent($event, false); if ($mainEvent != $event & $mainEvent != '') { //$flagMain=false; AA_printErrorMsg($strErrMergedRound); return; } // else { // $flagMain=true; // } $sqlCats = AA_mergedCatEvent($cCat, $event); if (!empty($sqlCats)) { if (empty($sqlEventComb)) { $sqlCat = " w.xKategorie IN {$sqlCats} AND "; } else { $sqlCat = " AND w.xKategorie IN {$sqlCats} "; } } if (!empty($mk_group) || !empty($tm_group)) { if ($teamsm) { $sql = "SELECT\r\n s.xStart\r\n , s.Anwesend\r\n , a.Startnummer\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang \r\n , t.Name \r\n , a.xAnmeldung\r\n , s.Bezahlt \r\n , s.Gruppe \r\n FROM\r\n anmeldung AS a\r\n LEFT JOIN\r\n athlet AS at USING(xAthlet)\r\n LEFT JOIN \r\n start AS s ON(s.xAnmeldung = a.xAnmeldung) \r\n LEFT JOIN \r\n verein AS v ON(at.xVerein = v.xVerein) \r\n INNER JOIN\r\n teamsmathlet AS tat ON(a.xAnmeldung = tat.xAnmeldung) \r\n LEFT JOIN teamsm as t ON (tat.xTeamsm = t.xTeamsm) \r\n WHERE s.Gruppe = " . $tm_group . "\r\n AND s.xWettkampf = " . $event . "\r\n GROUP BY a.xAnmeldung \r\n ORDER BY\r\n " . $argument . ", a.xAnmeldung;"; } else { $sql = "SELECT\r\n s.xStart\r\n , s.Anwesend\r\n , a.Startnummer\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang \r\n , if('" . $svm . "', t.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)) \r\n , a.xAnmeldung\r\n , s.Bezahlt \r\n , a.Gruppe \r\n FROM\r\n anmeldung AS a\r\n LEFT JOIN\r\n athlet AS at USING(xAthlet)\r\n LEFT JOIN \r\n start AS s ON(s.xAnmeldung = a.xAnmeldung)\r\n LEFT JOIN \r\n verein AS v ON(at.xVerein = v.xVerein)\r\n LEFT JOIN\r\n team AS t ON(a.xTeam = t.xTeam) \r\n WHERE a.Gruppe = " . $mk_group . "\r\n GROUP BY a.xAnmeldung \r\n ORDER BY\r\n " . $argument . ", a.xAnmeldung;"; } } else { if ($teamsm) {
function AA_rankinglist_Team($category, $formaction, $break, $cover, &$parser, $event, $heatSeparate, $type, $catFrom, $catTo) { require './lib/cl_gui_page.lib.php'; require './lib/cl_print_page.lib.php'; require './lib/cl_export_page.lib.php'; require './lib/common.lib.php'; require './lib/results.lib.php'; if (AA_connectToDB() == FALSE) { // invalid DB connection return; // abort } if (AA_checkMeetingID() == FALSE) { // no meeting selected return; // abort } global $rFrom, $rTo, $limitRank; // limits rank if limitRank set to true $rFrom = 0; $rTo = 0; $limitRank = false; if ($_GET['limitRank'] == "yes" && substr($formaction, 0, 6) == "export") { // check if ranks are limited if (!empty($_GET['limitRankFrom']) && !empty($_GET['limitRankTo'])) { $limitRank = true; $rFrom = $_GET['limitRankFrom']; $rTo = $_GET['limitRankTo']; } } // start a new HTML display page if ($formaction == 'view') { $GLOBALS[$list] = new GUI_TeamRankingList($_COOKIE['meeting']); $GLOBALS[$list]->printPageTitle("{$strRankingLists} " . $_COOKIE['meeting']); } elseif ($formaction == "xml") { $GLOBALS['xmladdon'] = true; $GLOBALS[$list] = new XML_TeamRankingList($parser); } elseif ($formaction == "print") { $GLOBALS[$list] = new PRINT_TeamRankingList($_COOKIE['meeting']); if ($cover == true) { // print cover page $GLOBALS[$list]->printCover($GLOBALS['strResults']); } } elseif ($formaction == "exportpress") { $GLOBALS[$list] = new EXPORT_TeamRankingListPress($_COOKIE['meeting'], 'txt'); } elseif ($formaction == "exportdiplom") { $GLOBALS[$list] = new EXPORT_TeamRankingListDiplom($_COOKIE['meeting'], 'csv'); } $selection = ''; if ($formaction != "xml") { if ($event != '') { $mergedCat = AA_mergedCatEvent($category, $event); } else { $mergedCat = AA_mergedCat($category); } } if (!empty($category)) { // show every category if ($mergedCat == '') { $selection = " AND k.xKategorie = {$category}"; } else { if ($heatSeparate) { $selection = " AND k.xKategorie = {$category}"; } else { $selection = " AND k.xKategorie IN {$mergedCat}"; } } } // show category from .... to if ($catFrom > 0) { $getSortCat = AA_getSortCat($catFrom, $catTo); if ($getSortCat[0]) { if ($catTo > 0) { $selection = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " "; } else { $selection = "AND k.Anzeige =" . $getSortCat[$catFrom] . " "; } } } // evaluation per category global $cfgEventType, $strEventTypeSingleCombined, $strEventTypeClubMA, $strEventTypeClubMB, $strEventTypeClubMC, $strEventTypeClubFA, $strEventTypeClubFB, $strEventTypeClubBasic, $strEventTypeClubAdvanced, $strEventTypeClubTeam, $strEventTypeClubCombined, $strEventTypeTeamSM; $results = mysql_query("\r\n\tSELECT Distinct\r\n\t \tk.xKategorie\r\n\t \t, k.Name\r\n\t\t, w.Typ\r\n , ks.xKategorie_svm\r\n , ks.Code\r\n \tFROM\r\n\t \twettkampf AS w\r\n\t \tLEFT JOIN kategorie AS k ON (k.xKategorie = w.xKategorie)\r\n LEFT JOIN kategorie_svm AS ks ON (ks.xKategorie_svm = w.xKategorie_svm)\r\n \tWHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t " . $selection . " \r\n AND w.Typ >= " . $cfgEventType[$strEventTypeClubBasic] . " \r\n\t AND w.Typ < " . $cfgEventType[$strEventTypeTeamSM] . "\r\n\t\r\n\tORDER BY\r\n\t\tk.Anzeige, ks.Code\r\n"); if (mysql_errno() > 0) { // DB error AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } else { mysql_query("DROP TABLE IF EXISTS tmp_team"); // temporary table mysql_query("CREATE TEMPORARY TABLE tmp_team( \r\n xKategorie int(11)\r\n , xDisziplin int(11) \r\n , Punkte float\r\n , xTeam int(11) \r\n )\r\n ENGINE=HEAP"); if (mysql_errno() > 0) { // DB error AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } // process all teams per category while ($row = mysql_fetch_row($results)) { // Club rankinglist:Combined if ($row[2] == $cfgEventType[$strEventTypeClubCombined]) { processCombined($row[0], $row[1], $type, $row[2]); } else { processSingle($row[0], $row[1], $row[3], $row[4]); } } mysql_query("DROP TABLE IF EXISTS tmp_team"); // temporary table mysql_free_result($results); } // ET DB error categories $GLOBALS[$list]->endPage(); // end HTML page for printing }
function AA_rankinglist_Sheets($category, $event, $formaction, $cover, $cover_timing = false, $heatSeparate, $catFrom, $catTo, $discFrom, $discTo) { // $heatSeparate=true (always show heat separate) $heatSeparate = true; require './lib/cl_gui_page.lib.php'; require './lib/cl_print_page.lib.php'; require './lib/common.lib.php'; require './lib/results.lib.php'; if (AA_connectToDB() == FALSE) { // invalid DB connection return; // abort } if (AA_checkMeetingID() == FALSE) { // no meeting selected return; // abort } // start a new HTML display page if ($formaction == 'view') { $GLOBALS[$list] = new GUI_TeamSheet($_COOKIE['meeting']); $GLOBALS[$list]->printPageTitle("{$strClubSheets} " . $_COOKIE['meeting']); } else { $GLOBALS[$list] = new PRINT_TeamSheet($_COOKIE['meeting']); if ($cover == true) { // print cover page $GLOBALS[$list]->printCover($strClubSheets, $cover_timing); } } $selection = ''; if ($event != '') { $mergedCat = AA_mergedCatEvent($category, $event); } else { $mergedCat = AA_mergedCat($category); } if (!empty($category)) { // show every category if ($mergedCat == '') { $selection = " AND k.xKategorie = {$category}"; } else { if ($heatSeparate) { $selection = " AND k.xKategorie = {$category}"; } else { $selection = " AND k.xKategorie IN {$mergedCat}"; } } } if ($catFrom > 0) { // $getSortCat = AA_getSortCat($catFrom, $catTo); if ($getSortCat[0]) { if ($catTo > 0) { $selection = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo]; } else { $selection = " AND k.Anzeige =" . $getSortCat[$catFrom]; } } } if ($discFrom > 0) { // $getSortDisc = AA_getSortDisc($discFrom, $discTo); if ($getSortDisc[0]) { if ($discTo > 0) { $selection2 .= " AND d.Anzeige >=" . $getSortDisc[$discFrom] . " AND d.Anzeige <=" . $getSortDisc[$discTo]; } else { $selection2 .= " AND d.Anzeige =" . $getSortDisc[$discFrom]; } } } // evaluation per category mysql_query("DROP TABLE IF EXISTS tempresult"); mysql_query("DROP TABLE IF EXISTS sheet_tmp"); if (mysql_errno() > 0) { // DB error AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } $sql = "SELECT\r\n k.xKategorie\r\n , k.Name\r\n , w.Typ\r\n FROM\r\n kategorie AS k\r\n LEFT JOIN wettkampf AS w ON (k.xKategorie = w.xKategorie)\r\n WHERE w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n " . $selection . " AND w.Typ >= " . $cfgEventType[$strEventTypeClubBasic] . " \r\n GROUP BY\r\n k.xKategorie,\r\n w.Typ\r\n ORDER BY\r\n k.Anzeige"; $results = mysql_query($sql); if (mysql_errno() > 0) { // DB error AA_printErrorMsg(mysql_errno() . ": " . mysql_error()); } else { $GLOBALS['AA_TC'] = 0; // team counter // process all categories while ($row = mysql_fetch_row($results)) { // Team sheet: Combined if ($row[2] == $cfgEventType[$strEventTypeClubCombined]) { AA_sheets_processCombined($row[0], $row[1], $row[2]); } else { AA_sheets_processSingle($row[0], $row[1], $selection2); } } mysql_free_result($results); } // ET DB error categories $GLOBALS[$list]->endPage(); // end HTML page for printing }