本文整理汇总了PHP中AA_formatResultMeter函数的典型用法代码示例。如果您正苦于以下问题:PHP AA_formatResultMeter函数的具体用法?PHP AA_formatResultMeter怎么用?PHP AA_formatResultMeter使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了AA_formatResultMeter函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: AA_rankinglist_Combined
//.........这里部分代码省略.........
, 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;
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:rankinglist_combined.lib.php
示例2: AA_formatResultMeter
<th class='dialog' colspan="3"><?php
echo $strSB_long;
?>
</th>
</tr>
<?php
}
if ($row_perf['Typ'] == $cfgDisciplineType[$strDiscTypeJump] || $row_perf['Typ'] == $cfgDisciplineType[$strDiscTypeJumpNoWind] || $row_perf['Typ'] == $cfgDisciplineType[$strDiscTypeThrow] || $row_perf['Typ'] == $cfgDisciplineType[$strDiscTypeHigh]) {
if (strlen($row_perf['season_effort']) > 0) {
$sb_perf = AA_formatResultMeter(str_replace(".", "", $row_perf['season_effort']));
} else {
$sb_perf = '';
}
if (strlen($row_perf['best_effort']) > 0) {
$pb_perf = AA_formatResultMeter(str_replace(".", "", $row_perf['best_effort']));
} else {
$pb_perf = '';
}
} else {
//convert performance-time to milliseconds
$timepices = explode(":", $row_perf['season_effort']);
$season_effort = $timepices[0] * 360 * 1000 + $timepices[1] * 60 * 1000 + $timepices[2] * 1000 + $timepices[3];
$timepices = explode(":", $row_perf['best_effort']);
$best_effort = $timepices[0] * 360 * 1000 + $timepices[1] * 60 * 1000 + $timepices[2] * 1000 + $timepices[3];
if ($row_perf['Typ'] == $cfgDisciplineType[$strDiscTypeTrack] || $row_perf['Typ'] == $cfgDisciplineType[$strDiscTypeTrackNoWind]) {
if ($season_effort != 0) {
$sb_perf = AA_formatResultTime($season_effort, true, true);
} else {
$sb_perf = '';
}
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:speaker_entry.php
示例3: AA_formatResultTime
$cat = $row[5];
if (empty($row[8])) {
// not assigned to a team
$club = $row[7];
// use club name
} else {
$club = $row[8];
// use team name
}
$ioc = $row[13];
$mkcode = $row[23];
}
if ($row[11] == $cfgDisciplineType[$strDiscTypeTrack] || $row[11] == $cfgDisciplineType[$strDiscTypeTrackNoWind] || $row[11] == $cfgDisciplineType[$strDiscTypeRelay] || $row[11] == $cfgDisciplineType[$strDiscTypeDistance]) {
$perf = AA_formatResultTime($row[12]);
} else {
$perf = AA_formatResultMeter($row[12]);
}
if (!is_a($doc, "PRINT_CatDiscEntryPage") && !is_a($doc, "GUI_CatDiscEntryPage") && !is_a($doc, "PRINT_ClubCatDiscEntryPage") && !is_a($doc, "GUI_ClubCatDiscEntryPage")) {
// 403 = UBS Kids Cup
// 799 = ...kampf
// show all disziplines (also if performance is 0) by UBS Kids Cup and ...kampf
if ($perf == 0 && $row[23] != 408 && $row[23] != 799 || $row[23] > 0 && $row[23] != 408 && $row[23] != 799 && isset($cfgCombinedDef[$row[23]]) && $perf > 0) {
//$Info = ($row[17]!="") ? ' ('.$row[17].')' : '';
$Info = $row[18] != "" ? ' (' . $row[18] . ')' : '';
$noFee = false;
if ($row[18] != "" && $m != $row[19]) {
if ($row[23] > 0 && isset($cfgCombinedDef[$row[23]])) {
// normal combined
$disc = $disc . $sep . $row[19] . $Info;
// add combined
} else {
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:print_meeting_entries.php
示例4: AA_formatResultMeter
$pf = $row[10];
// best effort by choosed combined disziplin
} else {
$pf = $row[5];
// best MK
}
} else {
$pf = $row[5];
// best effort
}
if ($pf == 9999999) {
$pf = 0;
}
// show top performance of athletes
if ($row[6] == $cfgDisciplineType[$strDiscTypeJump] || $row[6] == $cfgDisciplineType[$strDiscTypeJumpNoWind] || $row[6] == $cfgDisciplineType[$strDiscTypeThrow] || $row[6] == $cfgDisciplineType[$strDiscTypeHigh]) {
$perf = AA_formatResultMeter($pf);
//$perf = AA_formatResultMeter($row[5]);
} else {
if ($row[6] == $cfgDisciplineType[$strDiscTypeTrack] || $row[6] == $cfgDisciplineType[$strDiscTypeTrackNoWind]) {
// $perf = AA_formatResultTime($row[5], true, true);
$perf = AA_formatResultTime($pf, true, true);
} else {
//$perf = AA_formatResultTime($row[5], true);
$perf = AA_formatResultTime($pf, true);
}
}
if ($combined) {
if ($_GET['event'] == 0) {
// the whole combined event
$perf = $pf;
// points
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:print_event_enrolement.php
示例5: AA_speaker_High
function AA_speaker_High($event, $round, $layout)
{
require './lib/cl_gui_resulttable.lib.php';
require './config.inc.php';
require './lib/common.lib.php';
require './lib/results.lib.php';
$status = AA_getRoundStatus($round);
$svm = AA_checkSVM(0, $round);
// decide whether to show club or team name
$mergedMain = AA_checkMainRound($round);
if ($mergedMain != 1) {
// No action yet
if ($status == $cfgRoundStatus['open'] || $status == $cfgRoundStatus['enrolement_done'] || $status == $cfgRoundStatus['heats_in_progress']) {
AA_printWarningMsg($strHeatsNotDone);
} else {
if ($status == $cfgRoundStatus['enrolement_pending']) {
AA_printWarningMsg($strEnrolementNotDone);
} else {
if ($status >= $cfgRoundStatus['heats_done']) {
// show link to rankinglist if results done
if ($status == $cfgRoundStatus['results_done']) {
$menu = new GUI_Menulist();
$menu->addButton("print_rankinglist.php?event={$event}&round={$round}&type=single&formaction=speaker", $GLOBALS['strRankingList']);
$menu->addButton("print_rankinglist.php?event={$event}&round={$round}&type=single&formaction=speaker&show_efforts=sb_pb", $GLOBALS['strRankingListEfforts']);
$menu->printMenu();
echo "<p/>";
}
$prog_mode = AA_results_getProgramMode();
// display all athletes
$sql = "\r\n SELECT\r\n rt.Name\r\n , rt.Typ\r\n , s.xSerie\r\n , s.Bezeichnung\r\n , s.Status\r\n , ss.xSerienstart\r\n , ss.Position\r\n , ss.Rang\r\n , a.Startnummer\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang\r\n , if('" . $svm . "', te.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)) \r\n , LPAD(s.Bezeichnung,5,'0') as heatid\r\n , st.Bestleistung\r\n , at.xAthlet\r\n , at.Land\r\n , r.Status\r\n , ss.Starthoehe\r\n FROM\r\n runde AS r\r\n LEFT JOIN serie AS s ON (s.xRunde = r.xRunde)\r\n LEFT JOIN serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n LEFT JOIN start AS st ON (st.xStart = ss.xStart)\r\n LEFT JOIN anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n LEFT JOIN athlet AS at ON (at.xAthlet = a.xAthlet)\r\n LEFT JOIN team AS te ON(a.xTeam = te.xTeam) \r\n LEFT JOIN verein AS v ON (v.xVerein = at.xVerein)\r\n LEFT JOIN rundentyp_" . $_COOKIE['language'] . " AS rt ON rt.xRundentyp = r.xRundentyp\r\n WHERE \r\n r.xRunde = {$round} \r\n ORDER BY\r\n heatid\r\n , ss.Position";
$result = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$h = 0;
$i = 0;
$current_athlete = false;
$curr_class = '';
$resTable = new GUI_HighResultTable($round, $layout, $status);
while ($row = mysql_fetch_row($result)) {
/*
* Heat headerline
*/
if ($h != $row[2]) {
$h = $row[2];
// keep heat ID
if (is_null($row[0])) {
// only one round
$title = "{$strFinalround} {$row['3']}";
} else {
// more than one round
$title = "{$row['0']}: {$row['1']}{$row['3']}";
}
$c = 0;
if ($status == $cfgRoundStatus['results_done']) {
$c = 1;
// increment colspan to include ranking
}
$resTable->printHeatTitle($row[2], $row[3], $title, $row[4]);
$resTable->printAthleteHeader('', $round, $row[17]);
}
// ET new heat
/*
* Athlete data lines
*/
$rank = '';
$perfs = array();
$res = mysql_query("\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tr.Leistung\r\n\t\t\t\t\t\t, r.Info\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tresultat as r\r\n\t\t\t\t\tWHERE r.xSerienstart = {$row['5']}\r\n\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\tr.xResultat DESC\r\n\t\t\t\t");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if ($status == $cfgRoundStatus['results_done']) {
$rank = $row[7];
}
while ($resrow = mysql_fetch_row($res)) {
$perf = AA_formatResultMeter($resrow[0]);
$info = $resrow[1];
$perfs[] = "{$perf} ( {$info} )";
}
// end loop every tech result acc. programm mode
mysql_free_result($res);
}
$heatStart = AA_getCurrAthlete($row[2]);
if ($heatStart > 0) {
if ($row[5] == $heatStart) {
$curr_class = "active";
}
} else {
if (empty($perfs) && !$current_athlete) {
$current_athlete = true;
$curr_class = "active";
}
}
$resTable->printAthleteLine($row[6], $row[8], "{$row['9']} {$row['10']}", AA_formatYearOfBirth($row[11]), $row[12], AA_formatResultMeter($row[14]), $perfs, $fett, $rank, $row[16], $row[15], $curr_class, '', $row[17], $row[18]);
$curr_class = "";
}
$resTable->endTable();
//.........这里部分代码省略.........
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:speaker_results_high.lib.php
示例6: ON
// increment line count
$athletes = '';
$sql = "SELECT a.xAnmeldung\r\n , a.Startnummer\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang \r\n , s.Bestleistung\r\n , d.Typ \r\n , d.xDisziplin \r\n FROM anmeldung AS a \r\n LEFT JOIN teamsmathlet AS sma ON(a.xAnmeldung = sma.xAnmeldung) \r\n LEFT JOIN athlet AS at ON(a.xAthlet = at.xAthlet) \r\n LEFT JOIN start AS s ON(s.xAnmeldung = a.xAnmeldung) \r\n LEFT JOIN wettkampf AS w ON (w.xWettkampf = s.xWettkampf) \r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " AS d ON (d.xDisziplin = w.xDisziplin) \r\n WHERE sma.xTeamsm = " . $s . " \r\n ORDER BY at.Name\r\n , at.Vorname";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$sep = "";
while ($ath_row = mysql_fetch_row($res)) {
if ($disc_keep != $ath_row[7]) {
continue;
}
$perf = 0;
if ($ath_row[6] == $cfgDisciplineType[$strDiscTypeJump] || $ath_row[6] == $cfgDisciplineType[$strDiscTypeJumpNoWind] || $ath_row[6] == $cfgDisciplineType[$strDiscTypeThrow] || $ath_row[6] == $cfgDisciplineType[$strDiscTypeHigh]) {
$perf = AA_formatResultMeter($ath_row[5]);
} else {
if ($ath_row[6] == $cfgDisciplineType[$strDiscTypeTrack] || $ath_row[6] == $cfgDisciplineType[$strDiscTypeTrackNoWind]) {
$perf = AA_formatResultTime($ath_row[5], true, true);
} else {
$perf = AA_formatResultTime($ath_row[5], true);
}
}
$athletes = $athletes . $sep . $ath_row[1] . ". " . $ath_row[2] . " " . $ath_row[3] . " (" . $perf . ") ";
$sep = ", ";
}
mysql_free_result($res);
}
$doc->printAthletes($athletes, true);
}
printf("</table>\n");
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:print_meeting_teamsms.php
示例7: AA_formatResultTime
$span = "<span class='highlight_red'>";
$span_end = "</span>";
} else {
$span = "";
$span_end = "";
}
if ($event_row[2] == $cfgDisciplineType[$strDiscTypeTrack] || $event_row[2] == $cfgDisciplineType[$strDiscTypeTrackNoWind] || $event_row[2] == $cfgDisciplineType[$strDiscTypeRelay] || $event_row[2] == $cfgDisciplineType[$strDiscTypeDistance]) {
$class = 'time';
if ($event_row[2] == $cfgDisciplineType[$strDiscTypeDistance]) {
$perf = AA_formatResultTime($start_row[1]);
} else {
$perf = AA_formatResultTime($start_row[1], false, true);
}
} else {
$class = 'meter';
$perf = AA_formatResultMeter($start_row[1]);
}
//
// merge the disciplines for a combined event
//
if ($event_row[10] == $cfgEventType[$strEventTypeSingleCombined]) {
if (!$comb_start) {
echo "</tr>";
}
$comb_start = true;
$d = 1;
// check if one of the combined events is selected
$start_comb = false;
$resStartComb = mysql_query("SELECT xStart FROM\r\n start as s\r\n , wettkampf as w\r\n WHERE\r\n w.xKategorie = {$event_row['8']}\r\n AND w.Mehrkampfcode = {$event_row['9']}\r\n AND s.xWettkampf = w.xWettkampf\r\n AND s.xAnmeldung = {$row['0']}");
if (mysql_num_rows($resStartComb) > 0) {
$start_comb = true;
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:meeting_entry.php
示例8: AA_regie_High
//.........这里部分代码省略.........
}
$arg = isset($_GET['arg1']) ? $_GET['arg1'] : (isset($_COOKIE['sort_speakres']) ? $_COOKIE['sort_speakres'] : 'pos');
setcookie('sort_speakres', $arg1, time() + 2419200);
// display all athletes
if ($arg == "pos") {
$argument = "ss.Position";
$img_pos = "img/sort_act.gif";
} else {
if ($arg == "rang") {
$argument = "orderRang, ss.Position";
$img_rang = "img/sort_act.gif";
} else {
if ($relay == FALSE) {
// single event
$argument = "ss.Position";
$img_pos = "img/sort_act.gif";
}
}
}
$result = mysql_query("\r\n\t\t\tSELECT\r\n\t\t\t\trt.Name\r\n\t\t\t\t, rt.Typ\r\n\t\t\t\t, s.xSerie\r\n\t\t\t\t, s.Bezeichnung\r\n\t\t\t\t, s.Status\r\n\t\t\t\t, ss.xSerienstart\r\n\t\t\t\t, ss.Position\r\n\t\t\t\t, ss.Rang\r\n\t\t\t\t, a.Startnummer\r\n\t\t\t\t, at.Name\r\n\t\t\t\t, at.Vorname\r\n\t\t\t\t, at.Jahrgang\r\n\t\t\t\t, v.Name\r\n\t\t\t\t, LPAD(s.Bezeichnung,5,'0') as heatid\r\n\t\t\t\t, st.Bestleistung\r\n\t\t\t\t, at.xAthlet\r\n\t\t\t\t, at.Land \r\n , if (t.rang > 0, t.rang, 999999) as orderRang \r\n\t\t\tFROM\r\n\t\t\t\trunde AS r\r\n\t\t\t\tLEFT JOIN serie AS s ON (s.xRunde = r.xRunde )\r\n\t\t\t\tLEFT JOIN serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n\t\t\t\tLEFT JOIN start AS st ON (st.xStart = ss.xStart)\r\n\t\t\t\tLEFT JOIN anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n\t\t\t\tLEFT JOIN athlet AS at ON (at.xAthlet = a.xAthlet)\r\n\t\t\t\tLEFT JOIN verein AS v ON (v.xVerein = at.xVerein)\r\n LEFT JOIN tempHigh AS t ON (t.xSerienstart = ss.xSerienstart) \r\n\t\t\t LEFT JOIN rundentyp AS rt ON (rt.xRundentyp = r.xRundentyp)\r\n\t\t\tWHERE r.xRunde = {$round} \t\t\t\r\n\t\t\tORDER BY \r\n\t\t\t\theatid ,\r\n\t\t\t\t" . $argument);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$h = 0;
$i = 0;
$current_athlete = false;
$curr_class = '';
$resTable = new GUI_HighResultTable($round, $layout, $status);
$resTable->printHeatTitleRegie($cat, $disc);
while ($row = mysql_fetch_row($result)) {
/*
* Heat headerline
*/
if ($h != $row[2]) {
$h = $row[2];
// keep heat ID
if (is_null($row[0])) {
// only one round
$title = "{$strFinalround} {$row['3']}";
} else {
// more than one round
$title = "{$row['0']}: {$row['1']}{$row['3']}";
}
$c = 0;
if ($status == $cfgRoundStatus['results_done']) {
$c = 1;
// increment colspan to include ranking
}
$resTable->printHeatTitle($row[2], $row[3], $title, $row[4], 'regie');
$resTable->printAthleteHeader('regie');
}
// ET new heat
/*
* Athlete data lines
*/
$rank = '';
$perfs = array();
$res = mysql_query("\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tr.Leistung\r\n\t\t\t\t\t\t, r.Info\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tresultat as r\r\n\t\t\t\t\tWHERE r.xSerienstart = {$row['5']}\r\n\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\tr.xResultat DESC\r\n\t\t\t\t");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if ($status == $cfgRoundStatus['results_done']) {
$rank = $row[7];
} else {
$rank = $row[17];
}
while ($resrow = mysql_fetch_row($res)) {
$perf = AA_formatResultMeter($resrow[0]);
$info = $resrow[1];
$perfs[] = "{$perf} ( {$info} )";
}
// end loop every tech result acc. programm mode
mysql_free_result($res);
}
$heatStart = AA_getCurrAthlete($row[2]);
if ($heatStart > 0) {
if ($row[5] == $heatStart) {
$curr_class = "active";
}
} else {
if (empty($perfs) && !$current_athlete) {
$current_athlete = true;
$curr_class = "active";
}
}
if ($rank == 999999) {
$rank = '';
}
$resTable->printAthleteLine($row[6], $row[8], "{$row['9']} {$row['10']}", '', '', AA_formatResultMeter($row[14]), $perfs, $fett, $rank, '', $row[15], $curr_class, 'regie');
$curr_class = "";
}
$resTable->endTable();
mysql_free_result($result);
}
// ET DB error
mysql_query("UNLOCK TABLES");
}
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:regie_results_high.lib.php
示例9: AA_sheets_processCombined
function AA_sheets_processCombined($xCategory, $category, $wTyp)
{
require './config.inc.php';
// get athlete info per category and team
$sql = "\r\n SELECT\r\n DISTINCT(a.xAnmeldung)\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang\r\n , t.xTeam\r\n , t.Name\r\n , v.Name\r\n , IF(at.xRegion = 0, at.Land, re.Anzeige) AS Land \r\n FROM\r\n anmeldung AS a\r\n LEFT JOIN athlet AS at ON (at.xAthlet = a.xAthlet)\r\n INNER JOIN team AS t ON (t.xTeam = a.xTeam )\r\n LEFT JOIN verein AS v ON (v.xVerein = t.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)\r\n LEFT JOIN region AS re ON (at.xRegion = re.xRegion) \r\n WHERE \r\n a.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n AND w.xKategorie = {$xCategory}\r\n AND w.Typ = {$wTyp}\r\n ORDER BY\r\n t.xTeam\r\n ";
$results = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$evaluation = 5;
// nbr of athletes included in total result
$a = 0;
$club = '';
$info = '';
$name = '';
$points = 0;
$team = '';
$sep = '';
$tm = '';
$year = '';
$country = '';
while ($row = mysql_fetch_row($results)) {
// store previous athlete before processing new athlete
if ($a != $row[0] && $a > 0) {
$athleteList[] = array("points" => $points, "name" => $name, "year" => $year, "info" => $info, "country" => $country);
$points = 0;
$info = '';
$sep = '';
}
// store previous team before processing new team
if ($tm != $row[4] && $tm > 0) {
usort($athleteList, "AA_sheets_cmp");
// sort athletes by points
// nbr of athletes to include in team result
$total = 0;
for ($i = 0; $i < $evaluation; $i++) {
$total = $total + $athleteList[$i]['points'];
}
$teamList[] = array("points" => $total, "name" => $team, "club" => $club, "athletes" => $athleteList);
$team = '';
$club = '';
unset($athleteList);
$sep = '';
}
$tm = $row[4];
// keep current team
// events
$sql = "\r\n SELECT\r\n d.Kurzname\r\n , d.Typ\r\n , MAX(r.Leistung)\r\n , r.Info\r\n , MAX(r.Punkte) AS pts\r\n , s.Wind\r\n , w.Windmessung\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 \r\n st.xAnmeldung = {$row['0']} \r\n AND w.Typ = " . $cfgEventType[$strEventTypeClubCombined] . " \r\n AND r.Info != '" . $cfgResultsHighOut . "'\r\n GROUP BY\r\n st.xStart\r\n ORDER BY\r\n ru.Datum\r\n , ru.Startzeit\r\n ";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
while ($pt_row = mysql_fetch_row($res)) {
// 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], true);
} else {
$perf = AA_formatResultTime($pt_row[2], true);
}
// calculate points
$points = $points + $pt_row[4];
// accumulate points
if ($pt_row[4] > 0) {
// any points for this event
$info = $info . $sep . $pt_row[0] . " (" . $perf . $wind . ")";
$sep = ", ";
}
}
// END WHILE combined events
mysql_free_result($res);
}
$a = $row[0];
$name = $row[1] . " " . $row[2];
$year = AA_formatYearOfBirth($row[3]);
$team = $row[5];
$club = $row[6];
$country = $row[7];
}
// END WHILE athlete per category
mysql_free_result($results);
if (!empty($tm)) {
// last athlete
$athleteList[] = array("points" => $points, "name" => $name, "year" => $year, "info" => $info, "country" => $country);
// last team
usort($athleteList, "AA_sheets_cmp");
// sort athletes by points
//.........这里部分代码省略.........
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:rankinglist_sheets.lib.php
示例10: AA_speaker_High
function AA_speaker_High($event, $round, $layout)
{
require './lib/cl_gui_resulttable.lib.php';
require './config.inc.php';
require './lib/common.lib.php';
require './lib/results.lib.php';
$status = AA_getRoundStatus($round);
// No action yet
if ($status == $cfgRoundStatus['open'] || $status == $cfgRoundStatus['enrolement_done'] || $status == $cfgRoundStatus['heats_in_progress']) {
AA_printWarningMsg($strHeatsNotDone);
} else {
if ($status == $cfgRoundStatus['enrolement_pending']) {
AA_printWarningMsg($strEnrolementNotDone);
} else {
if ($status >= $cfgRoundStatus['heats_done']) {
// show link to rankinglist if results done
if ($status == $cfgRoundStatus['results_done']) {
$menu = new GUI_Menulist();
$menu->addButton("print_rankinglist.php?round={$round}&type=single&formaction=speaker", $GLOBALS['strRankingList']);
$menu->addButton("print_rankinglist.php?round={$round}&type=single&formaction=speaker&show_efforts=sb_pb", $GLOBALS['strRankingListEfforts']);
$menu->printMenu();
echo "<p/>";
}
$prog_mode = AA_results_getProgramMode();
// display all athletes
$result = mysql_query("\r\n\t\t\tSELECT\r\n\t\t\t\trt.Name\r\n\t\t\t\t, rt.Typ\r\n\t\t\t\t, s.xSerie\r\n\t\t\t\t, s.Bezeichnung\r\n\t\t\t\t, s.Status\r\n\t\t\t\t, ss.xSerienstart\r\n\t\t\t\t, ss.Position\r\n\t\t\t\t, ss.Rang\r\n\t\t\t\t, a.Startnummer\r\n\t\t\t\t, at.Name\r\n\t\t\t\t, at.Vorname\r\n\t\t\t\t, at.Jahrgang\r\n\t\t\t\t, v.Name\r\n\t\t\t\t, LPAD(s.Bezeichnung,5,'0') as heatid\r\n\t\t\t\t, st.Bestleistung\r\n\t\t\t\t, at.xAthlet\r\n\t\t\t\t, at.Land\r\n\t\t\tFROM\r\n\t\t\t\trunde AS r\r\n\t\t\t\t, serie AS s\r\n\t\t\t\t, serienstart AS ss\r\n\t\t\t\t, start AS st\r\n\t\t\t\t, anmeldung AS a\r\n\t\t\t\t, athlet AS at\r\n\t\t\t\t, verein AS v\r\n\t\t\tLEFT JOIN rundentyp AS rt\r\n\t\t\t\tON rt.xRundentyp = r.xRundentyp\r\n\t\t\tWHERE r.xRunde = {$round}\r\n\t\t\tAND s.xRunde = r.xRunde\r\n\t\t\tAND ss.xSerie = s.xSerie\r\n\t\t\tAND st.xStart = ss.xStart\r\n\t\t\tAND a.xAnmeldung = st.xAnmeldung\r\n\t\t\tAND at.xAthlet = a.xAthlet\r\n\t\t\tAND v.xVerein = at.xVerein\r\n\t\t\tORDER BY\r\n\t\t\t\theatid\r\n\t\t\t\t, ss.Position\r\n\t\t");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$h = 0;
$i = 0;
$resTable = new GUI_HighResultTable($round, $layout, $status);
while ($row = mysql_fetch_row($result)) {
/*
* Heat headerline
*/
if ($h != $row[2]) {
$h = $row[2];
// keep heat ID
if (is_null($row[0])) {
// only one round
$title = "{$strFinalround} {$row['3']}";
} else {
// more than one round
$title = "{$row['0']}: {$row['1']}{$row['3']}";
}
$c = 0;
if ($status == $cfgRoundStatus['results_done']) {
$c = 1;
// increment colspan to include ranking
}
$resTable->printHeatTitle($row[2], $row[3], $title, $row[4]);
$resTable->printAthleteHeader();
}
// ET new heat
/*
* Athlete data lines
*/
$rank = '';
$perfs = array();
$res = mysql_query("\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tr.Leistung\r\n\t\t\t\t\t\t, r.Info\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tresultat as r\r\n\t\t\t\t\tWHERE r.xSerienstart = {$row['5']}\r\n\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\tr.xResultat DESC\r\n\t\t\t\t");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if ($status == $cfgRoundStatus['results_done']) {
$rank = $row[7];
}
while ($resrow = mysql_fetch_row($res)) {
$perf = AA_formatResultMeter($resrow[0]);
$info = $resrow[1];
$perfs[] = "{$perf} ( {$info} )";
}
// end loop every tech result acc. programm mode
mysql_free_result($res);
}
$resTable->printAthleteLine($row[6], $row[8], "{$row['9']} {$row['10']}", AA_formatYearOfBirth($row[11]), $row[12], AA_formatResultMeter($row[14]), $perfs, $fett, $rank, $row[16], $row[15]);
}
$resTable->endTable();
mysql_free_result($result);
}
// ET DB error
}
}
}
// ET heat seeding done
}
开发者ID:laiello,项目名称:athletica,代码行数:89,代码来源:speaker_results_high.lib.php
示例11: gen_result_xml_UKC_CM
//.........这里部分代码省略.........
// store round ids for later purpose
$GLOBALS['rounds'][] = $row_results['xRunde'];
//
// athlete results
//
if ($ru == $row_results['xRunde'] && $id == $row_results['xAthlet']) {
continue;
}
$ru = $row_results['xRunde'];
if ($id != $row_results['xAthlet']) {
// new athlete
$id = $row_results['xAthlet'];
if (empty($row_results['Lizenznummer']) && empty($row_results['kidID'])) {
$inMasterData = 1;
$licensePaid = 1;
} else {
$inMasterData = 0;
if ($row_results['Bezahlt'] == 'y') {
$licensePaid = 1;
} else {
$licensePaid = 0;
}
}
}
$perf = 0;
// result for alabus
$wind = "";
$perfRounded = 0;
// result for combined detail text
// add effort parameters
$wind = "";
if ($row[2] == $cfgDisciplineType[$strDiscTypeJump] || $row[2] == $cfgDisciplineType[$strDiscTypeJumpNoWind] || $row[2] == $cfgDisciplineType[$strDiscTypeThrow] || $row[2] == $cfgDisciplineType[$strDiscTypeHigh]) {
$perf = AA_alabusDistance($row_results['Leistung']);
$perfRounded = AA_formatResultMeter($row_results['Leistung']);
$wind = strtr($row_results['Info'], ",", ".");
} else {
$perf = AA_alabusTime($row_results['Leistung']);
$perfRounded = AA_formatResultTime($row_results['Leistung'], true);
$wind = strtr($row_results['Wind'], ",", ".");
}
if ($row[1] == 0 || $wind == "-" || $wind == "") {
$wind = " ";
}
if (is_numeric($row_results['Bezeichnung'])) {
$row_results['Bezeichnung'] = sprintf("%02s", $row_results['Bezeichnung']);
} else {
if (strlen($row_results['Bezeichnung']) == 1) {
$row_results['Bezeichnung'] .= "_";
}
}
$rank = " ";
$row_results['Bezeichnung'] = " ";
//
//add points for combined contests
if ($combined[$row_results['xAthlet']][$row[3]]['points'] < $row_results['Punkte']) {
$license = $row_results['Lizenznummer'];
if ($row_results['Lizenznummer'] == 0) {
$license = '';
}
$kidsID_upload = $row_results['kidID'];
if ($row_results['kidID'] == 0) {
$kidsID_upload = '';
}
if ($row[3] == 30) {
$perfRounded = "r" . $perfRounded;
// r = run
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:cl_xml_data.lib.php
示例12: AA_speaker_Tech
//.........这里部分代码省略.........
// keep heat ID
if (is_null($row[0])) {
// only one round
$title = "{$strFinalround} {$row['3']}";
} else {
// more than one round
$title = "{$row['0']}: {$row['1']}{$row['3']}";
}
$c = 0;
$c++;
// increment colspan to include ranking
$resTable->printHeatTitle($row[2], $row[3], $title, $row[5]);
$resTable->printAthleteHeader('', $row[20]);
}
// ET new heat
/*
* Athlete data lines
*/
$perfs = array();
$fett = array();
$sql = "SELECT\r\n\t\t\t\t\t\tr.Leistung\r\n\t\t\t\t\t\t, r.Info\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tresultat AS r\r\n\t\t\t\t\tWHERE r.xSerienstart = {$row['6']}\r\n\t\t\t\t\tORDER BY\r\n\t\t\t\t\tr.xResultat";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
while ($resrow = mysql_fetch_row($res)) {
$sql2 = "SELECT\r\n\t\t\t\t\t\tleistung\r\n\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\ttemp\r\n\t\t\t\t\t\tWHERE athlet = {$row['6']}";
$res2 = mysql_query($sql2);
while ($row2 = mysql_fetch_row($res2)) {
if ($row2[0] == $resrow[0]) {
$fett[] = 1;
} else {
$fett[] = 0;
}
$perf = AA_formatResultMeter($resrow[0]);
if ($row[15] == 1) {
// with wind
$info = $resrow[1];
$perfs[] = "{$perf} ( {$info} )";
} else {
$perfs[] = "{$perf}";
}
}
}
// end loop every tech result acc. programm mode
mysql_free_result($res);
}
//print_r($perfs);
if ($keep_ss > 0) {
if ($keep_ss == $row[6]) {
$curr_class = "active";
}
} else {
if (empty($perfs) && !$current_athlete) {
$current_athlete = true;
$curr_class = "active";
}
}
$resTable->printAthleteLine($row[7], $row[9], "{$row['10']} {$row['11']}", AA_formatYearOfBirth($row[12]), $row[13], AA_formatResultMeter($row[16]), $perfs, $fett, $row[19], $row[18], $row[17], $curr_class);
$curr_class = "";
}
$resTable->endTable();
mysql_free_result($result);
}
// ET DB error
}
}
}
// ET heat seeding done
$temp = mysql_query("\r\n\t\tDROP TABLE IF EXISTS `temp`\r\n\t");
} else {
AA_printErrorMsg($strErrMergedRoundSpeaker);
}
?>
<script type="text/javascript">
<!--
window.setTimeout("updatePage()", <?php
echo $cfgMonitorReload * 1000;
?>
);
function updatePage()
{
window.open("speaker_results.php?round=<?php
echo $round;
?>
", "main");
}
</script>
<?php
}
开发者ID:laiello,项目名称:athletica,代码行数:101,代 |
请发表评论