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
}
