function AA_rankinglist_Combined($category, $formaction, $break, $cover, $sepu23, $cover_timing = false, $date = '%', $disc_nr, $catFrom, $catTo, $ukc)
{
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';
require './config.inc.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
$contestcat = " ";
if (!empty($category)) {
// show every category
$contestcat = " AND w.xKategorie = {$category}";
}
if ($catFrom > 0) {
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$contestcat = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " ";
} else {
$contestcat = " AND k.Anzeige =" . $getSortCat[$catFrom] . " ";
}
}
}
$GroupByUkc = "";
if ($ukc) {
$checkyear = date('Y') - 16;
$min_age = date('Y') - 7;
$selection = " AND at.Jahrgang > {$checkyear} AND (d.Code = " . $cfgUKC_disc[0] . " || d.Code = " . $cfgUKC_disc[1] . " || d.Code = " . $cfgUKC_disc[2] . ") ";
$sql_leftjoin = " LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d ON (w.xDisziplin = d.xDisziplin) ";
$order = " at.Geschlecht, at.Jahrgang, at.Name, at.Vorname, d.Anzeige";
$disc_nr = 3;
} else {
$selection = " AND w.Mehrkampfcode > 0 ";
$sql_leftjoin = " LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d ON (w.Mehrkampfcode = d.Code)";
$order = " k.Anzeige , w.Mehrkampfcode , ka.Alterslimite DESC";
}
$dCode = 0;
if ($ukc) {
$mk = ",0";
} else {
$mk = ",w.Mehrkampfcode";
}
// get athlete info per contest category
$sql1 = "SELECT DISTINCT \r\n a.xAnmeldung\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang\r\n , k.Name\r\n , IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)\r\n , IF(at.xRegion = 0, at.Land, re.Anzeige)";
$sql2 = ", d.Name\r\n , w.xKategorie\r\n , ka.Code\r\n , ka.Name\r\n , ka.Alterslimite \r\n , d.Code \r\n , at.xAthlet\r\n , at.Geschlecht \r\n FROM\r\n anmeldung AS a\r\n LEFT JOIN athlet AS at ON (at.xAthlet = a.xAthlet )\r\n LEFT JOIN verein AS v ON (v.xVerein = at.xVerein )\r\n LEFT JOIN start as st ON (st.xAnmeldung = a.xAnmeldung ) \r\n LEFT JOIN wettkampf as w ON (w.xWettkampf = st.xWettkampf) " . $sql_leftjoin . "\r\n LEFT JOIN kategorie AS k ON (k.xKategorie = w.xKategorie)\r\n LEFT JOIN kategorie AS ka ON (ka.xKategorie = a.xKategorie) \r\n LEFT JOIN region as re ON (at.xRegion = re.xRegion) \r\n WHERE a.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n " . $contestcat . " \r\n " . $selection . " \r\n AND st.anwesend = 0 ";
$sqlOrder = " ORDER BY " . $order;
$sql = $sql1 . $mk . $sql2 . $sqlOrder;
$results = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$cat = '';
$catEntry = '';
$catEntryLimit = "";
$u23name = "";
$comb = 0;
// hold combined type
$combName = "";
$lastTime = "";
// hold start time of last event for print list
$a = 0;
$info = '';
$points = 0;
$sep = '';
$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') {
// display page for speaker
$list = new GUI_CombinedRankingList($_COOKIE['meeting']);
$list->printPageTitle("{$strRankingLists} " . $_COOKIE['meeting']);
} elseif ($formaction == "print") {
$list = new PRINT_CombinedRankingList($_COOKIE['meeting']);
if ($cover == true) {
// print cover page
$list->printCover($GLOBALS['strResults'], $cover_timing);
}
} elseif ($formaction == "exportpress") {
$list = new EXPORT_CombinedRankingListPress($_COOKIE['meeting'], 'txt');
} elseif ($formaction == "exportdiplom") {
$list = new EXPORT_CombinedRankingListDiplom($_COOKIE['meeting'], 'csv');
}
if ($ukc) {
while ($row = mysql_fetch_row($results)) {
if ($roundsUkc[$row[4]][$row[14]] == "") {
$roundsUkc[$row[4]][$row[14]] = 0;
}
$roundsUkc[$row[4]][$row[14]]++;
}
$GroupByUkc = " GROUP BY at.xAthlet ";
$mk = ",w.Mehrkampfcode";
$sql = $sql1 . $mk . $sql2 . $GroupByUkc . $sqlOrder;
$results = mysql_query($sql);
}
while ($row = mysql_fetch_row($results)) {
$dCode = $row[13];
$row3_tmp = $row[3];
if ($row3_tmp > $min_age) {
$row3_tmp = $min_age;
}
if ($ukc) {
if ($roundsUkc[$row[4]][$row[14]] != 3) {
continue;
}
}
// store previous before processing new athlete
if ($a != $row[0] && $a > 0) {
$points_arr[] = $points;
if ($ukc) {
$xKatUKC = AA_getCatUkc($birthDate, $sex, true);
$points_arr_more_disc_all[$xKatUKC][] = $points_disc;
} else {
$points_arr_more_disc_all[$row[9]][] = $points_disc;
}
$name_arr[] = $name;
$year_arr[] = $year;
$club_arr[] = $club;
$info_arr[] = $info;
$ioc_arr[] = $ioc;
$x_arr[] = $a;
if (isset($points_disc_keep) && sizeof($points_disc_keep) < 3 && $ukc) {
$rank_arr[] = 0;
} else {
$rank_arr[] = $rank;
}
$info = '';
$points = 0;
$sep = '';
}
// print previous before processing new category
if (!empty($cat) && (($row[4] != $cat || $row[7] != $comb) && $ukc == false || $ukc == true && $row3_tmp != $age || ($comb == 410 || $comb == 400) && $catEntry != $row[10] && $row[12] < 23 && !$bU23 && $sepu23)) {
$bU23 = false;
// set the separate flag! else it will be separated by each category
if (($comb == 410 || $comb == 400) && $catEntry != $row[10] && $row[12] < 23) {
$bU23 = true;
}
$u23name = '';
// set the addition for the title if this is the separated cat
if (($comb == 410 || $comb == 400) && $catEntryLimit < 23 && $sepu23) {
$u23name = " (U 23)";
}
$list->endList();
if ($ukc) {
$list->printSubTitle($catUKC . ", " . $cfgUKC_Name);
} else {
$list->printSubTitle($cat . "{$u23name}, " . $combName, "", "");
}
$list->startList();
$list->printHeaderLine($lastTime);
arsort($points_arr, SORT_NUMERIC);
// sort descending by points
$rank = 1;
// initialize rank
$r = 0;
// start value for ranking
$p = 0;
$no_rank = 999999;
$max_rank = $no_rank;
foreach ($points_arr as $key => $val) {
$r++;
if ($limitRank && ($r < $rFrom || $r > $rTo)) {
// limit ranks if set (export)
continue;
}
if ($p != $val) {
// not same points as previous team
$rank = $r;
// next rank
}
// not set rank for invalid results
if (preg_match("@\\(-[1]{1}@", $info_arr[$key])) {
$rank = $max_rank;
$max_rank += 1;
$r--;
}
$rank_arr[$key] = $rank;
$p = $val;
// keep current points
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
$rank_keep = 0;
$key_keep = '';
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank == $rank_keep) {
$c = 0;
$keep_c = 0;
// first rule
for ($i = 1; $i <= sizeof($points_disc); $i++) {
if ($points_arr_more_disc_all[$xKat][$key_keep][$i] > $points_arr_more_disc_all[$xKat][$key][$i]) {
$keep_c++;
} else {
$c++;
}
}
$more = ceil(sizeof($points_disc) / 2);
if (sizeof($points_disc) % 2 == 0) {
// combined with even number discs
$more++;
}
if ($keep_c >= $more && $keep_c > $c) {
$rank_arr[$key]++;
} else {
if ($c >= $more && $c > $keep_c) {
$rank_arr[$key_keep]++;
} else {
// second rule
// check the best points of the highest points of discipline
$k = AA_get_AthletBestPointDisc($points_arr_more_disc_all[$xKat][$key_keep], $points_arr_more_disc_all[$xKat][$key], $key_keep, $key);
if ($k != 0) {
$rank_arr[$k]++;
}
// if $k is 0, all points of diszipline are the same --> athletes with same rank
}
}
}
$rank_keep = $rank;
$key_keep = $key;
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank >= $no_rank) {
$rank = '';
}
$list->printLine($rank, $name_arr[$key], $year_arr[$key], $club_arr[$key], $val, $ioc_arr[$key]);
$list->printInfo($info_arr[$key]);
// insert points into combined top performance of entry
mysql_query("UPDATE anmeldung SET BestleistungMK = {$val} WHERE xAnmeldung = " . $x_arr[$key]);
}
unset($points_arr);
unset($name_arr);
unset($year_arr);
unset($club_arr);
unset($info_arr);
unset($ioc_arr);
unset($x_arr);
unset($rank_arr);
if (is_a($list, "PRINT_CombinedRankingList") && $break == 'category') {
// page break after category
$list->insertPageBreak();
}
}
$cat = $row[4];
// keep current category
$age = $row3_tmp;
if ($ukc) {
$catUKC = AA_getCatUkc($row[3], $row[15], false);
$xKat = AA_getCatUkc($row[3], $row[15], true);
} else {
$xKat = $row[9];
}
$catEntry = $row[10];
$catEntryLimit = $row[12];
$comb = $row[7];
$combName = $row[8];
if ($ukc) {
$order = " d.Anzeige, ru.Datum, ru.Startzeit";
$selectionDisc = " AND (d.Code = " . $cfgUKC_disc[0] . " || d.Code = " . $cfgUKC_disc[1] . " || d.Code = " . $cfgUKC_disc[2] . ") ";
$selectionMk = '';
} else {
$order = " w.Mehrkampfreihenfolge ASC, ru.Datum, ru.Startzeit";
$selectionMk = " AND w.Mehrkampfcode = " . $row[7];
$selectionDisc = '';
}
// events
$query = "SELECT\r\n d.Kurzname\r\n , d.Typ\r\n , MAX(IF ((r.Info='-') && (d.Typ = 6) ,0,r.Leistung)) \r\n , r.Info\r\n , MAX(IF ((r.Info='-') && (d.Typ = 6),0,r.Punkte)) AS pts \r\n , s.Wind\r\n , w.Windmessung\r\n , st.xStart\r\n , CONCAT(DATE_FORMAT(ru.Datum,'{$cfgDBdateFormat}'), ' ', TIME_FORMAT(ru.Startzeit, '{$cfgDBtimeFormat}'))\r\n , w.Mehrkampfreihenfolge \r\n , ss.Bemerkung\r\n , w.info\r\n , ss.xSerienstart \r\n , d.Code\r\n FROM\r\n start AS st USE INDEX (Anmeldung)\r\n LEFT JOIN serienstart AS ss ON (ss.xStart = st.xStart )\r\n LEFT JOIN resultat AS r ON (r.xSerienstart = ss.xSerienstart) \r\n LEFT JOIN serie AS s ON (s.xSerie = ss.xSerie)\r\n LEFT JOIN runde AS ru ON (ru.xRunde = s.xRunde)\r\n LEFT JOIN wettkampf AS w ON (w.xWettkampf = st.xWettkampf)\r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " AS d ON (d.xDisziplin = w.xDisziplin)\r\n WHERE st.xAnmeldung = {$row['0']} \r\n {$selectionDisc} \r\n AND ( (r.Info = '" . $cfgResultsHighOut . "' && d.Typ = 6 && r.Leistung < 0) OR (d.Typ = 6 && (r.Info != '" . $cfgResultsHighOut . "' && r.Info != '" . $cfgResultsHighOut1 . "' \r\n && r.Info != '" . $cfgResultsHighOut2 . "' && r.Info != '" . $cfgResultsHighOut3 . "' && r.Info != '" . $cfgResultsHighOut4 . "'\r\n && r.Info != '" . $cfgResultsHighOut5 . "' && r.Info != '" . $cfgResultsHighOut6 . "' && r.Info != '" . $cfgResultsHighOut7 . "' && r.Info != '" . $cfgResultsHighOut7 . "'))\r\n OR (d.Typ != 6 ) ) \r\n \r\n AND w.xKategorie = {$row['9']}\r\n {$selectionMk} \r\n AND ru.Status = " . $cfgRoundStatus['results_done'] . " \r\n GROUP BY\r\n st.xStart\r\n ORDER BY\r\n {$order}";
$res = mysql_query($query);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$count_disc = 0;
$remark = '';
$points_disc = array();
while ($pt_row = mysql_fetch_row($res)) {
$remark = $pt_row[10];
$lastTime = $pt_row[8];
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeJump]) {
$res2 = mysql_query("SELECT r.Info FROM \r\n\t\t\t\t\t\t\t\tresultat as r\r\n\t\t\t\t\t\t\t\tLEFT JOIN serienstart as ss USING(xSerienstart)\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tss.xStart = {$pt_row['7']}\r\n\t\t\t\t\t\t\tAND\tr.Punkte = {$pt_row['4']}");
$row2 = mysql_fetch_array($res2);
$pt_row[3] = $row2[0];
}
// set wind, if required
if ($pt_row[6] == 1) {
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeTrack]) {
$wind = " / " . $pt_row[5];
} else {
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeJump]) {
$wind = " / " . $pt_row[3];
}
}
} else {
$wind = '';
}
// format output
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeJump] || $pt_row[1] == $cfgDisciplineType[$strDiscTypeJumpNoWind] || $pt_row[1] == $cfgDisciplineType[$strDiscTypeThrow] || $pt_row[1] == $cfgDisciplineType[$strDiscTypeHigh]) {
$perf = AA_formatResultMeter($pt_row[2]);
} else {
$perf = AA_formatResultTime($pt_row[2], true);
}
// show only points for number of choosed disciplines if the diszipline is done
$count_disc++;
if ($count_disc <= $disc_nr) {
if ($pt_row[4] > 0 || $ukc) {
// any points for this event
if ($ukc) {
$pointsUKC = AA_utils_calcPointsUKC(0, $pt_row[2], 0, $row[16], $pt_row[12], $row[14], $row[0], $pt_row[13]);
$points = $points + $pointsUKC;
// calculate points
mysql_query("UPDATE resultat SET\r\n Punkte = {$pointsUKC}\r\n WHERE\r\n xSerienstart = {$pt_row['12']}");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
AA_StatusChanged(0, 0, $pt_row[12]);
} else {
$points = $points + $pt_row[4];
// calculate points
}
if ($dCode == 408) {
// UBS Kids Cup
switch ($pt_row[1]) {
case 1:
case 2:
$c = 1;
// track
break;
case 4:
case 5:
case 6:
$c = 2;
// jump and high
break;
case 8:
$c = 3;
// throw
break;
default:
$c = 0;
break;
}
$points_disc[$c] = $pt_row[4];
} else {
if ($ukc) {
switch ($pt_row[1]) {
case 1:
case 2:
$c = 1;
// track
break;
case 4:
case 5:
case 6:
$c = 2;
// jump and high
break;
case 8:
$c = 3;
// throw
break;
default:
$c = 0;
break;
}
$points_disc[$c] = $pointsUKC;
} else {
$points_disc[$row[9]] = $pt_row[4];
}
}
if ($ukc) {
$info = $info . $sep . $pt_row[0] . " " . " (" . $perf . $wind . ", {$pointsUKC})";
} else {
$info = $info . $sep . $pt_row[0] . " " . " (" . $perf . $wind . ", {$pt_row['4']})";
}
$sep = ", ";
} elseif ($pt_row[4] == 0 && $pt_row[2] >= 0) {
// athlete with 0 points
$info = $info . $sep . $pt_row[0] . " " . " (" . $perf . $wind . ", {$pt_row['4']})";
$sep = ", ";
} else {
$count_disc--;
$pointTxt = "";
foreach ($cfgInvalidResult as $value) {
if ($value['code'] == $perf) {
$pointTxt = $value['short'];
}
}
$info = $info . $sep . $pt_row[0] . $pt_row[11] . " (" . $perf . $wind . ", {$pointTxt})";
$sep = ", ";
}
}
}
// END WHILE combined events
mysql_free_result($res);
}
$a = $row[0];
$name = $row[1] . " " . $row[2];
$year = AA_formatYearOfBirth($row[3]);
$birthDate = $row[3];
$sex = $row[15];
$club = $row[5];
$ioc = $row[6];
$remark_arr[] = $remark;
if ($ukc) {
$xKat = AA_getCatUkc($row[3], $row[15], true);
} else {
$xKat = $row[9];
}
$points_disc_keep = $points_disc;
$dCode_keep = $dCode;
}
// END WHILE athlete per category
if (!empty($a)) {
$points_arr[] = $points;
$points_arr_more_disc_all[$xKat][] = $points_disc;
$name_arr[] = $name;
$year_arr[] = $year;
$club_arr[] = $club;
$info_arr[] = $info;
$ioc_arr[] = $ioc;
$x_arr[] = $a;
$remark_arr[] = $remark;
$rank_arr[] = $rank;
}
if (!empty($cat)) {
$u23name = '';
if (($comb == 410 || $comb == 400) && $catEntryLimit < 23 && $sepu23) {
$u23name = " (U 23)";
}
$list->endList();
if ($ukc) {
$list->printSubTitle($catUKC . ", " . $cfgUKC_Name);
} else {
$list->printSubTitle($cat . "{$u23name}, " . $combName, "", "");
}
$list->startList();
$list->printHeaderLine($lastTime);
arsort($points_arr, SORT_NUMERIC);
// sort descending by points
$rank = 1;
// initialize rank
$r = 0;
// start value for ranking
$p = 0;
$k = 0;
$no_rank = 999999;
$max_rank = $no_rank;
foreach ($points_arr as $key => $val) {
$r++;
if ($limitRank && ($r < $rFrom || $r > $rTo)) {
// limit ranks if set (export)
continue;
}
if ($p != $val) {
// not same points as previous athlete
$rank = $r;
// next rank
}
// not set rank for invalid results
if (preg_match("@\\(-[1]{1}@", $info_arr[$key])) {
$rank = $max_rank;
$max_rank += 1;
$r--;
}
$p = $val;
// keep current points
$k = $key;
// keep current key
$rank_arr[$key] = $rank;
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
$rank_keep = 0;
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank == $rank_keep) {
$c = 0;
$keep_c = 0;
// first rule
for ($i = 1; $i <= sizeof($points_disc); $i++) {
if ($points_arr_more_disc_all[$xKat][$key_keep][$i] > $points_arr_more_disc_all[$xKat][$key][$i]) {
$keep_c++;
} else {
$c++;
}
}
$more = ceil(sizeof($points_disc) / 2);
if (sizeof($points_disc) % 2 == 0) {
// combined with even number discs
$more++;
}
if ($keep_c >= $more && $keep_c > $c) {
$rank_arr[$key]++;
} else {
if ($c >= $more && $c > $keep_c) {
$rank_arr[$key_keep]++;
} else {
// second rule
// check the best points of the highest points of discipline
$k = AA_get_AthletBestPointDisc($points_arr_more_disc_all[$xKat][$key_keep], $points_arr_more_disc_all[$xKat][$key], $key_keep, $key);
if ($k != 0) {
$rank_arr[$k]++;
}
// if $k is 0, all points of diszipline are the same --> athletes with same rank
}
}
}
$rank_keep = $rank;
$key_keep = $key;
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank >= $no_rank) {
$rank = '';
}
$list->printLine($rank, $name_arr[$key], $year_arr[$key], $club_arr[$key], $val, $ioc_arr[$key]);
$list->printInfo($info_arr[$key]);
// insert points into combined top performance of entry
mysql_query("UPDATE anmeldung SET BestleistungMK = {$val} WHERE xAnmeldung = " . $x_arr[$key]);
}
}
mysql_free_result($results);
$list->endList();
$list->endPage();
// end HTML page for printing
}
// ET DB error all teams
}
function AA_rankinglist_Combined($category, $formaction, $break, $cover, $sepu23, $cover_timing = false, $date = '%', $disc_nr, $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
}
$contestcat = " ";
if (!empty($category)) {
// show every category
$contestcat = " AND w.xKategorie = {$category}";
}
if ($catFrom > 0) {
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$contestcat = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " ";
} else {
$contestcat = " AND k.Anzeige =" . $getSortCat[$catFrom] . " ";
}
}
}
$dCode = 0;
// get athlete info per contest category
$results = mysql_query("\r\n\tSELECT DISTINCT \r\n\t\ta.xAnmeldung\r\n\t\t, at.Name\r\n\t\t, at.Vorname\r\n\t\t, at.Jahrgang\r\n\t\t, k.Name\r\n\t\t, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)\r\n\t\t, IF(at.xRegion = 0, at.Land, re.Anzeige)\r\n\t\t, w.Mehrkampfcode\r\n\t\t, d.Name\r\n\t\t, w.xKategorie\r\n\t\t, ka.Code\r\n\t\t, ka.Name\r\n\t\t, ka.Alterslimite \r\n , d.Code \r\n\tFROM\r\n\t\tanmeldung AS a\r\n\t\t, athlet AS at\r\n\t\t, verein AS v\r\n\t\t, kategorie AS k\r\n\t\t, kategorie AS ka\r\n\t\t, start as st\r\n\t\t, wettkampf as w\r\n\t\t, disziplin as d\r\n\t\tLEFT JOIN region as re ON at.xRegion = re.xRegion\r\n\tWHERE a.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t" . $contestcat . "\r\n\tAND at.xAthlet = a.xAthlet\r\n\tAND v.xVerein = at.xVerein\r\n\tAND k.xKategorie = w.xKategorie\r\n\tAND st.xAnmeldung = a.xAnmeldung\r\n\tAND w.xWettkampf = st.xWettkampf \r\n\tAND w.Mehrkampfcode = d.Code \r\n\tAND w.Mehrkampfcode > 0\r\n\tAND ka.xKategorie = a.xKategorie \r\n AND st.anwesend = 0 \t\r\n\tORDER BY \t \r\n\t\tk.Anzeige\r\n\t\t, w.Mehrkampfcode\r\n\t\t, ka.Alterslimite DESC\r\n");
/*
$results= mysql_query("SELECT
a.xAnmeldung
, at.Name
, at.Vorname
, at.Jahrgang
, k.Name
, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)
, IF(at.xRegion = 0, at.Land, re.Anzeige)
, w.Mehrkampfcode
, d.Name
, w.xKategorie
, ka.Code
, ka.Name
, ka.Alterslimite
FROM
anmeldung AS a
LEFT JOIN athlet AS at USING (xAthlet)
LEFT JOIN verein AS v USING (xVerein)
LEFT JOIN kategorie AS k ON (w.xKategorie = k.xKategorie)
LEFT JOIN kategorie AS ka ON (ka.xKategorie = a.xKategorie)
LEFT JOIN start as st ON (st.xAnmeldung = a.xAnmeldung)
LEFT JOIN wettkampf as w On (w.xWettkampf = st.xWettkampf)
LEFT JOIN disziplin as d ON (w.Mehrkampfcode = d.Code)
LEFT JOIN region as re ON at.xRegion = re.xRegion
WHERE a.xMeeting = " . $_COOKIE['meeting_id'] ."
" . $contestcat . "
AND w.Mehrkampfcode > 0
GROUP BY
a.xAnmeldung
ORDER BY
w.xKategorie
, w.Mehrkampfcode
, ka.Alterslimite DESC
");
*/
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$cat = '';
$catEntry = '';
$catEntryLimit = "";
$u23name = "";
$comb = 0;
// hold combined type
$combName = "";
$lastTime = "";
// hold start time of last event for print list
$a = 0;
$info = '';
$points = 0;
$sep = '';
$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') {
// display page for speaker
$list = new GUI_CombinedRankingList($_COOKIE['meeting']);
$list->printPageTitle("{$strRankingLists} " . $_COOKIE['meeting']);
} elseif ($formaction == "print") {
$list = new PRINT_CombinedRankingList($_COOKIE['meeting']);
if ($cover == true) {
// print cover page
$list->printCover($GLOBALS['strResults'], $cover_timing);
}
} elseif ($formaction == "exportpress") {
$list = new EXPORT_CombinedRankingListPress($_COOKIE['meeting'], 'txt');
} elseif ($formaction == "exportdiplom") {
$list = new EXPORT_CombinedRankingListDiplom($_COOKIE['meeting'], 'csv');
}
while ($row = mysql_fetch_row($results)) {
$dCode = $row[13];
// store previous before processing new athlete
if ($a != $row[0] && $a > 0) {
$points_arr[] = $points;
if ($dCode_keep == 403) {
// Athletic Cup
$points_arr_max_disc[$xKat][] = $points_disc;
} else {
$points_arr_max_disc[$xKat][] = AA_get_MaxPointDisc($points_disc);
}
$points_arr_more_disc[$xKat][] = AA_get_MoreBestPointDisc($points_disc);
$points_arr_more_disc_all[$row[9]][] = $points_disc;
$name_arr[] = $name;
$year_arr[] = $year;
$club_arr[] = $club;
$info_arr[] = $info;
$ioc_arr[] = $ioc;
$x_arr[] = $a;
$rank_arr[] = $rank;
$info = '';
$points = 0;
$sep = '';
}
// print previous before processing new category
if (!empty($cat) && ($row[4] != $cat || $row[7] != $comb || ($comb == 410 || $comb == 400) && $catEntry != $row[10] && $row[12] < 23 && !$bU23 && $sepu23)) {
$bU23 = false;
// set the separate flag! else it will be separated by each category
if (($comb == 410 || $comb == 400) && $catEntry != $row[10] && $row[12] < 23) {
$bU23 = true;
}
$u23name = '';
// set the addition for the title if this is the separated cat
if (($comb == 410 || $comb == 400) && $catEntryLimit < 23 && $sepu23) {
$u23name = " (U 23)";
}
$list->endList();
$list->printSubTitle($cat . "{$u23name}, " . $combName, "", "");
$list->startList();
$list->printHeaderLine($lastTime);
arsort($points_arr, SORT_NUMERIC);
// sort descending by points
$rank = 1;
// initialize rank
$r = 0;
// start value for ranking
$p = 0;
$no_rank = 999999;
$max_rank = $no_rank;
foreach ($points_arr as $key => $val) {
$r++;
if ($limitRank && ($r < $rFrom || $r > $rTo)) {
// limit ranks if set (export)
continue;
}
if ($p != $val) {
// not same points as previous team
$rank = $r;
// next rank
}
// not set rank for invalid results
if (preg_match("@\\(-[1]{1}@", $info_arr[$key])) {
$rank = $max_rank;
$max_rank += 1;
$r--;
}
$rank_arr[$key] = $rank;
$p = $val;
// keep current points
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
$rank_keep = 0;
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank == $rank_keep) {
if ($dCode_keep == 403) {
// Athletic Cup
$c = 0;
$c_max_disc1 = 0;
$c_max_disc2 = 0;
for ($i = 0; $i < 3; $i++) {
if ($points_arr_max_disc[$xKat][$key_keep][$i] > $points_arr_max_disc[$xKat][$key][$i]) {
$c_max_disc1++;
}
if ($points_arr_max_disc[$xKat][$key_keep][$i] < $points_arr_max_disc[$xKat][$key][$i]) {
$c_max_disc2++;
}
}
if ($c_max_disc1 == 2 && $c_max_disc2 == 1) {
// two disciplines more points
$rank_arr[$key]++;
} elseif ($c_max_disc1 == 1 && $c_max_disc2 == 2) {
// two disciplines more points
$rank_arr[$key_keep]++;
} elseif ($c_max_disc1 == 1 && $c_max_disc2 == 1) {
// one discipline same points and total same points
$k = AA_get_BestPointDisc($points_arr_max_disc[$xKat][$key_keep], $points_arr_max_disc[$xKat][$key], $key_keep, $key);
$rank_arr[$k]++;
}
} else {
// other combined events
if ($points_arr_more_disc[$xKat][$key_keep] < $points_arr_more_disc[$xKat][$key]) {
$rank_arr[$key_keep]++;
} elseif ($points_arr_more_disc[$xKat][$key_keep] > $points_arr_more_disc[$xKat][$key]) {
$rank_arr[$key]++;
} else {
// always same points --> check
$max_key = AA_get_BestPointDisc($points_arr_more_disc_all[$xKat][$key_keep], $points_arr_more_disc_all[$xKat][$key], $key_keep, $key);
$rank_arr[$max_key]++;
}
}
}
$rank_keep = $rank;
$key_keep = $key;
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank >= $no_rank) {
$rank = '';
}
$list->printLine($rank, $name_arr[$key], $year_arr[$key], $club_arr[$key], $val, $ioc_arr[$key]);
$list->printInfo($info_arr[$key]);
// insert points into combined top performance of entry
mysql_query("UPDATE anmeldung SET BestleistungMK = {$val} WHERE xAnmeldung = " . $x_arr[$key]);
}
unset($points_arr);
unset($name_arr);
unset($year_arr);
unset($club_arr);
unset($info_arr);
unset($ioc_arr);
unset($x_arr);
unset($rank_arr);
if (is_a($list, "PRINT_CombinedRankingList") && $break == 'category') {
// page break after category
$list->insertPageBreak();
}
}
$cat = $row[4];
// keep current category
$xKat = $row[9];
$catEntry = $row[10];
$catEntryLimit = $row[12];
$comb = $row[7];
$combName = $row[8];
// events
$res = mysql_query("\r\n SELECT\r\n d.Kurzname\r\n , d.Typ\r\n , MAX(IF ((r.Info='-') && (d.Typ = 6) ,0,r.Leistung)) \r\n , r.Info\r\n , MAX(IF ((r.Info='-') && (d.Typ = 6),0,r.Punkte)) AS pts \r\n , s.Wind\r\n , w.Windmessung\r\n , st.xStart\r\n , CONCAT(DATE_FORMAT(ru.Datum,'{$cfgDBdateFormat}'), ' ', TIME_FORMAT(ru.Startzeit, '{$cfgDBtimeFormat}'))\r\n , w.Mehrkampfreihenfolge \r\n , ss.Bemerkung\r\n , w.info\r\n FROM\r\n start AS st USE INDEX (Anmeldung)\r\n , serienstart AS ss \r\n , resultat AS r \r\n , serie AS s \r\n , runde AS ru \r\n , wettkampf AS w\r\n , disziplin AS d \r\n WHERE st.xAnmeldung = {$row['0']}\r\n AND ss.xStart = st.xStart\r\n AND r.xSerienstart = ss.xSerienstart\r\n AND s.xSerie = ss.xSerie\r\n AND ru.xRunde = s.xRunde\r\n AND w.xWettkampf = st.xWettkampf\r\n AND d.xDisziplin = w.xDisziplin\r\n AND ( (r.Info = '" . $cfgResultsHighOut . "' && d.Typ = 6 && r.Leistung < 0) OR (r.Info != '" . $cfgResultsHighOut . "') ) \r\n AND w.xKategorie = {$row['9']}\r\n AND w.Mehrkampfcode = {$row['7']}\r\n GROUP BY\r\n st.xStart\r\n ORDER BY\r\n w.Mehrkampfreihenfolge ASC\r\n , ru.Datum\r\n , ru.Startzeit\r\n ");
/*
$res = mysql_query("
SELECT
d.Kurzname
, d.Typ
, MAX(r.Leistung)
, r.Info
, MAX(r.Punkte) AS pts
, s.Wind
, w.Windmessung
, st.xStart
, CONCAT(DATE_FORMAT(ru.Datum,'$cfgDBdateFormat'), ' ', TIME_FORMAT(ru.Startzeit, '$cfgDBtimeFormat'))
FROM
start as st USE INDEX (Anmeldung)
, wettkampf as w
, runde as ru
, disziplin as d
LEFT JOIN serie AS s ON s.xRunde = ru.xRunde
LEFT JOIN serienstart AS ss ON ss.xSerie = s.xSerie AND ss.xStart = st.xStart
LEFT JOIN resultat AS r ON (r.xSerienstart = ss.xSerienstart AND r.Info != '" . $cfgResultsHighOut . "')
WHERE st.xAnmeldung = $row[0]
AND w.xKategorie = $row[9]
AND w.Mehrkampfcode = $row[7]
AND w.xWettkampf = st.xWettkampf
AND d.xDisziplin = w.xDisziplin
AND ru.xWettkampf = w.xWettkampf
AND ru.Datum LIKE '".$date."'
GROUP BY
st.xStart
ORDER BY
w.Mehrkampfreihenfolge ASC
, ru.Datum
, ru.Startzeit
");
*/
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$count_disc = 0;
$remark = '';
$points_disc = array();
while ($pt_row = mysql_fetch_row($res)) {
$remark = $pt_row[10];
$lastTime = $pt_row[8];
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeJump]) {
$res2 = mysql_query("SELECT r.Info FROM \r\n\t\t\t\t\t\t\t\tresultat as r\r\n\t\t\t\t\t\t\t\tLEFT JOIN serienstart as ss USING(xSerienstart)\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tss.xStart = {$pt_row['7']}\r\n\t\t\t\t\t\t\tAND\tr.Punkte = {$pt_row['4']}");
$row2 = mysql_fetch_array($res2);
$pt_row[3] = $row2[0];
}
// set wind, if required
if ($pt_row[6] == 1) {
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeTrack]) {
$wind = " / " . $pt_row[5];
} else {
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeJump]) {
$wind = " / " . $pt_row[3];
}
}
} else {
$wind = '';
}
// format output
if ($pt_row[1] == $cfgDisciplineType[$strDiscTypeJump] || $pt_row[1] == $cfgDisciplineType[$strDiscTypeJumpNoWind] || $pt_row[1] == $cfgDisciplineType[$strDiscTypeThrow] || $pt_row[1] == $cfgDisciplineType[$strDiscTypeHigh]) {
$perf = AA_formatResultMeter($pt_row[2]);
} else {
$perf = AA_formatResultTime($pt_row[2], true);
}
// show only points for number of choosed disciplines if the diszipline is done
$count_disc++;
if ($count_disc <= $disc_nr) {
if (!empty($pt_row[11])) {
$pt_row[11] = " ({$pt_row['11']})";
}
if ($pt_row[4] > 0) {
// any points for this event
$points = $points + $pt_row[4];
// calculate points
if ($dCode == 403) {
// Athletic Cup
switch ($pt_row[1]) {
case 1:
case 2:
$c = 0;
// track
break;
case 4:
case 6:
$c = 1;
// jump and high
break;
case 8:
$c = 2;
// throw
break;
default:
$c = 0;
break;
}
$points_disc[$c] = $pt_row[4];
} else {
$points_disc[$pt_row[9]] = $pt_row[4];
}
$info = $info . $sep . $pt_row[0] . $pt_row[11] . " (" . $perf . $wind . ", {$pt_row['4']})";
$sep = ", ";
} elseif ($pt_row[4] == 0 && $pt_row[2] >= 0) {
// athlete with 0 points
$info = $info . $sep . $pt_row[0] . $pt_row[11] . " (" . $perf . $wind . ", {$pt_row['4']})";
$sep = ", ";
} else {
$count_disc--;
$pointTxt = "";
foreach ($cfgInvalidResult as $value) {
if ($value['code'] == $perf) {
$pointTxt = $value['short'];
}
}
$info = $info . $sep . $pt_row[0] . $pt_row[11] . " (" . $perf . $wind . ", {$pointTxt})";
$sep = ", ";
}
}
}
// END WHILE combined events
mysql_free_result($res);
}
$a = $row[0];
$name = $row[1] . " " . $row[2];
$year = AA_formatYearOfBirth($row[3]);
$club = $row[5];
$ioc = $row[6];
$remark_arr[] = $remark;
$xKat = $row[9];
$points_disc_keep = $points_disc;
$dCode_keep = $dCode;
}
// END WHILE athlete per category
if (!empty($a)) {
$points_arr[] = $points;
if ($dCode == 403) {
$points_arr_max_disc[$xKat][] = $points_disc;
} else {
$points_arr_max_disc[$xKat][] = AA_get_MaxPointDisc($points_disc);
}
$points_arr_more_disc[$xKat][] = AA_get_MoreBestPointDisc($points_disc);
$points_arr_more_disc_all[$xKat][] = $points_disc;
$name_arr[] = $name;
$year_arr[] = $year;
$club_arr[] = $club;
$info_arr[] = $info;
$ioc_arr[] = $ioc;
$x_arr[] = $a;
$remark_arr[] = $remark;
$rank_arr[] = $rank;
}
if (!empty($cat)) {
$u23name = '';
if (($comb == 410 || $comb == 400) && $catEntryLimit < 23 && $sepu23) {
$u23name = " (U 23)";
}
$list->endList();
$list->printSubTitle($cat . "{$u23name}, " . $combName, "", "");
$list->startList();
$list->printHeaderLine($lastTime);
arsort($points_arr, SORT_NUMERIC);
// sort descending by points
$rank = 1;
// initialize rank
$r = 0;
// start value for ranking
$p = 0;
$k = 0;
$no_rank = 999999;
$max_rank = $no_rank;
foreach ($points_arr as $key => $val) {
$r++;
if ($limitRank && ($r < $rFrom || $r > $rTo)) {
// limit ranks if set (export)
continue;
}
if ($p != $val) {
// not same points as previous athlete
$rank = $r;
// next rank
} else {
if ($dCode == 403) {
// Athletic Cup
if ($points_arr_max_disc[$xkat][$key] > $points_arr_max_disc[$xKat][$k]) {
$rank_arr[$k] = $r;
}
}
}
// not set rank for invalid results
if (preg_match("@\\(-[1]{1}@", $info_arr[$key])) {
$rank = $max_rank;
$max_rank += 1;
$r--;
}
$p = $val;
// keep current points
$k = $key;
// keep current key
$rank_arr[$key] = $rank;
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
$rank_keep = 0;
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank == $rank_keep) {
if ($dCode == 403) {
// Athletic Cup
$c = 0;
$c_max_disc1 = 0;
$c_max_disc2 = 0;
for ($i = 0; $i < 3; $i++) {
if ($points_arr_max_disc[$xKat][$key_keep][$i] > $points_arr_max_disc[$xKat][$key][$i]) {
$c_max_disc1++;
}
if ($points_arr_max_disc[$xKat][$key_keep][$i] < $points_arr_max_disc[$xKat][$key][$i]) {
$c_max_disc2++;
}
}
if ($c_max_disc1 == 2 && $c_max_disc2 == 1) {
// two disciplines more points
$rank_arr[$key]++;
} elseif ($c_max_disc1 == 1 && $c_max_disc2 == 2) {
// two disciplines more points
$rank_arr[$key_keep]++;
} elseif ($c_max_disc1 == 1 && $c_max_disc2 == 1) {
// one discipline same points and total same points
$k = AA_get_BestPointDisc($points_arr_max_disc[$xKat][$key_keep], $points_arr_max_disc[$xKat][$key], $key_keep, $key);
$rank_arr[$k]++;
}
} else {
// other combined events
if ($points_arr_more_disc[$xKat][$key_keep] < $points_arr_more_disc[$xKat][$key]) {
$rank_arr[$key_keep]++;
} elseif ($points_arr_more_disc[$xKat][$key_keep] > $points_arr_more_disc[$xKat][$key]) {
$rank_arr[$key]++;
} else {
// always same points --> check
$max_key = AA_get_BestPointDisc($points_arr_more_disc_all[$xKat][$key_keep], $points_arr_more_disc_all[$xKat][$key], $key_keep, $key);
$rank_arr[$max_key]++;
}
}
}
$rank_keep = $rank;
$key_keep = $key;
}
asort($rank_arr, SORT_NUMERIC);
// sort descending by rank
foreach ($rank_arr as $key => $v) {
$val = $points_arr[$key];
$rank = $v;
if ($rank >= $no_rank) {
$rank = '';
}
$list->printLine($rank, $name_arr[$key], $year_arr[$key], $club_arr[$key], $val, $ioc_arr[$key]);
$list->printInfo($info_arr[$key]);
// insert points into combined top performance of entry
mysql_query("UPDATE anmeldung SET BestleistungMK = {$val} WHERE xAnmeldung = " . $x_arr[$key]);
}
}
mysql_free_result($results);
$list->endList();
$list->endPage();
// end HTML page for printing
}
// ET DB error all teams
}