• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP AA_formatYearOfBirth函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中AA_formatYearOfBirth函数的典型用法代码示例。如果您正苦于以下问题:PHP AA_formatYearOfBirth函数的具体用法?PHP AA_formatYearOfBirth怎么用?PHP AA_formatYearOfBirth使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了AA_formatYearOfBirth函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: mysql_free_result

                             $disc = $disc . "(" . $perf . ")";
                         }
                         $sep = ", ";
                     }
                     mysql_free_result($disc_res);
                 }
                 // ET DB error
                 $doc->printLine($list_row[1], $list_row[2] . " " . $list_row[3], AA_formatYearOfBirth($list_row[4]), $disc);
             } else {
                 $disc = '';
                 if ($list_row[0] != $d) {
                     $disc = $list_row[0];
                 }
                 $d = $list_row[0];
                 // keep discipline
                 $doc->printLine($disc, $list_row[1], $list_row[2] . " " . $list_row[3], AA_formatYearOfBirth($list_row[4]));
             }
             $l++;
             // increment line count
         }
         // END LOOP Athletes
         mysql_free_result($list_res);
     }
 }
 // ET DB error athlets
 // read all relays per Team
 $sql = "SELECT\r\n                s.xStaffel\r\n                , s.Name\r\n                , d.Kurzname\r\n                , d.Name\r\n                , s.Startnummer\r\n            FROM\r\n                staffel AS s\r\n                LEFT JOIN start AS st ON (st.xStaffel = s.xStaffel)   \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 s.xTeam = {$row['0']} \r\n            ORDER BY\r\n                d.Anzeige";
 $rel_res = mysql_query($sql);
 if (mysql_errno() > 0) {
     AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
 } else {
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:print_meeting_teams.php


示例2: AA_rankinglist_Combined


//.........这里部分代码省略.........
                                     $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();
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:rankinglist_combined.lib.php


示例3: processCombined


//.........这里部分代码省略.........
                         list($a, $mili) = explode(".", $mili / 100);
                         $sec += $a;
                         // display milli (two decimal after point without 0 in front)
                         $time = '';
                         if ($hour > 0) {
                             $time = sprintf("%02d", $hour) . ":" . sprintf("%02d", $min) . ":" . sprintf("%02d", $sec) . "." . sprintf("%-02s", $mili);
                         } elseif ($min > 0) {
                             $time = sprintf("%02d", $min) . ":" . sprintf("%02d", $sec) . "." . sprintf("%-02s", $mili);
                         } else {
                             $time = $sec . "." . sprintf("%-02s", $mili);
                         }
                         $perf = $time;
                     }
                     // calculate points
                     $points = $points + $pt_row[4];
                     // accumulate points
                     if ($perf != $cfgInvalidResult['DNS']['code']) {
                         if ($perf < 0) {
                             foreach ($cfgInvalidResult as $value) {
                                 if ($value['code'] == $perf) {
                                     $perf = $value['short'];
                                 }
                             }
                         }
                         $info = $info . $sep . $pt_row[0] . "&nbsp;(" . $perf . $wind . "/ " . $pt_row[4] . ")";
                         $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];
             $xTeam = $row[4];
             $club = $row[6];
             $country = $row[7];
         }
         // END WHILE athlete per category
         mysql_free_result($results);
         if (!empty($tm) || $type == 'teamP') {
             // last athlete
             $athleteList[] = array("points" => $points, "name" => $name, "year" => $year, "info" => $info, "country" => $country, "club" => $club);
             // last team
             usort($athleteList, "cmp");
             // sort athletes by points
             $total = 0;
             for ($i = 0; $i < $evaluationPt; $i++) {
                 $total = $total + $athleteList[$i]['points'];
             }
             $teamList[] = array("points" => $total, "rank" => $n, "team" => $team, "teamNr" => $xTeam, "club" => $club, "athletes" => $athleteList, "id" => $tm);
         }
         $GLOBALS[$list]->printSubTitle("{$category}", "", "");
         $GLOBALS[$list]->startList();
         $GLOBALS[$list]->printHeaderLine();
         usort($teamList, "cmp");
         $rank = 1;
         // initialize rank
         $r = 0;
         // start value for ranking
         $p = 0;
         $tp = 0;
         $t = 0;
         foreach ($teamList as $team) {
             if ($limitRank && ($r < $rFrom || $r > $rTo)) {
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:rankinglist_team.lib.php


示例4: AA_rankinglist_Combined


//.........这里部分代码省略.........
                                         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] . "&nbsp;(" . $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] . "&nbsp;(" . $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] . "&nbsp;(" . $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();
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:rankinglist_combined.lib.php


示例5: AA_formatYearOfBirth

		<th class='dialog'><?php 
    echo $strCategory;
    ?>
</th>
		<td class='dialog'><?php 
    echo $row2[7];
    ?>
</td>
	</tr>
	<tr>
		<th class='dialog'><?php 
    echo $strYear;
    ?>
</th>
		<td class='dialog'><?php 
    echo AA_formatYearOfBirth($row2[4]);
    ?>
</td>
	</tr>
	<tr>
		<th class='dialog'><?php 
    echo $strClub;
    ?>
</th>
		<td class='dialog'><?php 
    echo $row2[5];
    ?>
</td>
	</tr>
	<tr>
		<th class='dialog'><?php 
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:speaker_entry.php


示例6: printf

     // keep current combined
     $ck = $row[14];
 }
 if ($l == 0) {
     // new page, print header line
     if (!$export) {
         printf("<table class='dialog'>\n");
     }
     $doc->printHeaderLine();
 }
 if ($a != $row[0]) {
     $fee = 0;
     $nbr = $row[1];
     $name = $row[2] . " " . $row[3];
     // assemble name field
     $year = AA_formatYearOfBirth($row[4]);
     $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 {
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:print_meeting_entries.php


示例7: AA_results_Tech


//.........这里部分代码省略.........
                                    // ET new heat
                                    /*
                                     * Athlete data lines
                                     */
                                    $i++;
                                    if ($row[7] % 2 == 0) {
                                        // even row numer
                                        $rowclass = 'odd';
                                    } else {
                                        // odd row number
                                        $rowclass = 'even';
                                    }
                                    ?>
    <tr class='<?php 
                                    echo $rowclass;
                                    ?>
'>
        <td class='forms_right'><?php 
                                    echo $row[7];
                                    /* position */
                                    ?>
</td>
        <td class='forms_right'><?php 
                                    echo $row[9];
                                    /* start nbr */
                                    ?>
</td>
        <td nowrap><?php 
                                    echo $row[10] . " " . $row[11];
                                    /* name */
                                    ?>
</td>
        <td class='forms_ctr'><?php 
                                    echo AA_formatYearOfBirth($row[12]);
                                    ?>
</td>
        <td><?php 
                                    echo $row[17] != '' && $row[17] != '-' ? $row[17] : '&nbsp;';
                                    ?>
</td>
        <td nowrap><?php 
                                    echo $row[13];
                                    /* club */
                                    ?>
</td>
<?php 
                                    $res = mysql_query("SELECT rs.xResultat" . ", rs.Leistung" . ", rs.Info" . " FROM resultat AS rs" . " WHERE rs.xSerienstart = " . $row[6] . "\r\n                    ORDER BY rs.xResultat");
                                    if (mysql_errno() > 0) {
                                        // DB error
                                        AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                    } else {
                                        // Show rank
                                        if ($status == $cfgRoundStatus['results_done'] || $prog_mode == 2) {
                                            $disField = ($maxatt + 1) * $maxAthlete;
                                            // attempts * 8 (first 8 athletes)
                                            if ($pass >= 2 && $r + 1 > $disField) {
                                                $dis = 'disabled=" disabled"';
                                            } else {
                                                $dis = '';
                                            }
                                            ?>
        <form action='event_results.php' method='post'
            name='rank_<?php 
                                            echo $r;
                                            ?>
'>
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:results_tech.lib.php


示例8: AA_results_High


//.........这里部分代码省略.........
                            if ($row[1] == '0') {
                                $title = "";
                            } else {
                                $title = "{$row['0']}";
                            }
                        }
                        $content .= "</table><table class='dialog'>";
                        if ($title != '') {
                            $content .= "<tr>";
                            $content .= "<th class='dialog' colspan='6' />" . $title . " " . $row[3] . "</th> ";
                            $content .= "</tr>";
                        }
                        $content .= "<tr>";
                        $content .= "<th class='dialog'>" . $strPositionShort . "</th>";
                        $content .= "<th class='dialog'>" . $strStartnumber . "</th>";
                        $content .= "<th class='dialog'>" . $strAthlete . "</th>";
                        $content .= "<th class='dialog_pc'>" . $strYearShort . "</th>";
                        $content .= "<th class='dialog_pc'>" . $strCountry . "</th>";
                        $content .= "<th class='dialog_pc'>";
                        if ($svm) {
                            $content .= $strTeam;
                        } else {
                            $content .= $strClub;
                        }
                        $content .= "</th>";
                        $content .= "<th class='dialog'>" . $strPerformance . "</th>";
                        $content .= "</tr>";
                    }
                    // ET new heat
                    /*
                     * Athlete data lines
                     */
                    if ($a != $row[4]) {
                        $c_results = 0;
                        $a = $row[4];
                        // keep athlete ID
                        $l = 0;
                        // reset result counter
                        if ($row[5] % 2 == 0) {
                            // even row numer
                            $rowclass = 'even';
                        } else {
                            // odd row number
                            $rowclass = 'odd';
                        }
                        $content .= "<tr class='" . $rowclass . "' >";
                        $content .= "<td class='forms_right'>" . $row[5] . "</td>";
                        $content .= "<td class='forms_right'>" . $row[7] . "</td>";
                        /* start nbr */
                        $content .= "<td nowrap>" . $row[8] . " " . $row[9] . "</td>";
                        /* name */
                        $content .= "<td class='forms_ctr_pc'>" . AA_formatYearOfBirth($row[10]) . "</td>";
                        $content .= "<td class='forms_pc'>";
                        if ($row[16] != '' && $row[16] != '-') {
                            $content .= $row[16];
                        } else {
                            $content .= " ";
                        }
                        $content .= "</td>";
                        $content .= "<td class='forms_pc' nowrap>" . $row[11] . "</td>";
                        /* club */
                    }
                    // ET new athlete
                    $perf = '';
                    if (is_null($row[14]) == false) {
                        $c_results++;
                        if ($c_results > 4) {
                            $content .= "<tr><td colspan='6'></td>";
                            $c_results = 0;
                        }
                        $perf = $row[14];
                        if ($perf == $cfgMissedAttempt['dbx']) {
                            $perf = $cfgMissedAttempt['codeX'];
                        }
                        $content .= "<td colspan='2' nowrap>" . AA_formatResultMeter($perf) . "({$row['15']})</td>";
                    }
                }
                mysql_free_result($result);
                $content .= "</table>";
                $content .= $cfgHtmlFooter;
                $content .= "</div ></div>";
                $content .= $cfgHtmlEnd;
                if (!fwrite($fp, $content)) {
                    AA_printErrorMsg($GLOBALS['strErrFileWriteFailed']);
                    return;
                }
                fclose($fp);
            }
            // ET DB error
        }
        // ET round selected
        AA_UpdateStatusChanged($round);
        ?>
    

</body>
</html>

<?php 
    }
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:results_high.lib.php


示例9: AA_speaker_Track


//.........这里部分代码省略.........
                                 $p = 1;
                                 // start with track one
                                 if (is_null($row[1])) {
                                     // only one round
                                     $title = "{$strFinalround} {$row['4']}";
                                 } else {
                                     // more than one round
                                     $title = "{$row['1']}: {$row['2']}{$row['4']}";
                                 }
                                 // increment colspan to include ranking and qualification
                                 $c = 0;
                                 if ($status == $cfgRoundStatus['results_done']) {
                                     $c++;
                                     if ($nextRound > 0) {
                                         $c++;
                                     }
                                 }
                                 $resTable->printHeatTitle($row[3], $row[4], $title, $row[7], $row[6], $row[5]);
                                 if ($relay == FALSE) {
                                     // athlete display
                                     $resTable->printAthleteHeader('', $round);
                                 } else {
                                     // relay display
                                     $resTable->printRelayHeader('', $round);
                                 }
                             }
                             // ET new heat
                             /*
                              * Empty tracks
                              */
                             if ($layout == $cfgDisciplineType[$strDiscTypeTrack] || $layout == $cfgDisciplineType[$strDiscTypeTrackNoWind] || $layout == $cfgDisciplineType[$strDiscTypeRelay]) {
                                 // current track and athlete's position not identical
                                 if ($p < $row[9]) {
                                     $p = $resTable->printEmptyTracks($p, $row[9] - 1, 6 + $c);
                                 }
                             }
                             // ET empty tracks
                             /*
                              * Athlete/Relay data lines
                              */
                             // get performance
                             $perf = '';
                             $perfRounded = '';
                             $res = mysql_query("\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\trs.xResultat\r\n\t\t\t\t\t\t, rs.Leistung\r\n\t\t\t\t\t\t, rs.Info\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tresultat AS rs\r\n\t\t\t\t\tWHERE rs.xSerienstart = {$row['8']}\r\n\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\trs.Leistung ASC\r\n\t\t\t\t");
                             if (mysql_errno() > 0) {
                                 // DB error
                                 AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                             } else {
                                 $resrow = mysql_fetch_row($res);
                                 if ($resrow != NULL) {
                                     // result found
                                     $perf = AA_formatResultTime($resrow[1]);
                                     $perfRounded = AA_formatResultTime($resrow[1], true);
                                 }
                                 mysql_free_result($res);
                             }
                             // ET DB error
                             // print lines
                             if ($relay == FALSE) {
                                 $resTable->printAthleteLine($row[9], $row[12], "{$row['13']} {$row['14']}", AA_formatYearOfBirth($row[15]), $row[16], AA_formatResultTime($row[19], true), $perfRounded, $row[10], $row[11], $row[18], $row[20]);
                             } else {
                                 // relay
                                 // get Athletes
                                 $arrAthletes = array();
                                 $sql = "SELECT at.Vorname, at.Name, at.Jahrgang, a.Startnummer FROM\r\n\t\t\t\t\t\t\t\tstaffelathlet as sfat\r\n\t\t\t\t\t\t\t\tLEFT JOIN start as st ON sfat.xAthletenstart = st.xStart\r\n\t\t\t\t\t\t\t\tLEFT JOIN anmeldung as a USING(xAnmeldung)\r\n\t\t\t\t\t\t\t\tLEFT JOIN athlet as at USING(xAthlet)\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\tsfat.xStaffelstart = {$row['16']}\r\n\t\t\t\t\t\t\tAND\tsfat.xRunde = {$row['15']}\r\n\t\t\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\t\t\tsfat.Position";
                                 $res_at = mysql_query($sql);
                                 if (mysql_errno() > 0) {
                                     // DB error
                                     AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                                 } else {
                                     while ($row_at = mysql_fetch_array($res_at)) {
                                         $arrAthletes[] = array($row_at[1], $row_at[0], AA_formatYearOfBirth($row_at[2]), $row_at[3]);
                                     }
                                 }
                                 $arrAthletes = count($arrAthletes) > 0 ? $arrAthletes : 0;
                                 $resTable->printRelayLine($row[9], $row[12], $row[13], $perfRounded, $row[10], $row[11], $arrAthletes);
                             }
                         }
                         // Fill last heat with empty tracks for disciplines run in
                         // individual tracks
                         if ($layout == $cfgDisciplineType[$strDiscTypeTrack] || $layout == $cfgDisciplineType[$strDiscTypeTrackNoWind] || $layout == $cfgDisciplineType[$strDiscTypeRelay]) {
                             if ($p > 0) {
                                 // heats set up
                                 $p++;
                                 $resTable->printEmptyTracks($p, $tracks, 6 + $c);
                             }
                         }
                         // ET track disciplines
                         $resTable->endTable();
                         mysql_free_result($result);
                     }
                     // ET DB error
                 }
             }
         }
         // ET heat seeding done
     } else {
         AA_printErrorMsg($strErrMergedRoundSpeaker);
     }
 }
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:speaker_results_track.lib.php


示例10: AA_sheets_printRelayAthletes

 function AA_sheets_printRelayAthletes($relay)
 {
     $sql = "\r\n        SELECT\r\n          at.Name\r\n          , at.Vorname\r\n          , at.Jahrgang\r\n          , sta.Position\r\n          , IF(at.xRegion = 0, at.Land, re.Anzeige) AS Land     \r\n      FROM\r\n          athlet AS at \r\n          LEFT JOIN anmeldung AS a ON (at.xAthlet = a.xAthlet    ) \r\n          LEFT JOIN start AS st ON (a.xAnmeldung = st.xAnmeldung)\r\n          LEFT JOIN staffelathlet AS sta ON (st.xStart = sta.xAthletenstart)    \r\n          LEFT JOIN start AS s ON (sta.xStaffelstart = s.xStart)  \r\n          LEFT JOIN region AS re ON (at.xRegion = re.xRegion)    \r\n      WHERE \r\n          s.xStaffel = {$relay}  \r\n      ORDER BY\r\n          sta.Position\r\n    ";
     $at_res = mysql_query($sql);
     if (mysql_errno() > 0) {
         // DB error
         AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
     } else {
         while ($at_row = mysql_fetch_row($at_res)) {
             $year = AA_formatYearOfBirth($at_row[2]);
             $GLOBALS[$list]->printRelayAthlete("{$at_row['3']}. {$at_row['0']} {$at_row['1']}, {$year}, {$at_row['4']}");
         }
         mysql_free_result($at_res);
     }
 }
开发者ID:laiello,项目名称:athletica,代码行数:15,代码来源:rankinglist_sheets.lib.php


示例11: 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


示例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,代码来源:speaker_results_tech.lib.php


示例13: AA_speaker_Tech


//.........这里部分代码省略.........
                                 $argument = "v.Name, a.Startnummer";
                                 $img_club = "img/sort_act.gif";
                             } else {
                                 if ($arg == "perf") {
                                     $argument = "st.Bestleistung, ss.Position";
                                     $img_perf = "img/sort_act.gif";
                                 } else {
                                     if ($arg == "rang") {
                                         $argument = "t.rang, 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.Wind\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, w.Windmessung\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\t\t, t.rang\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\t\t, wettkampf AS w\r\n\t\t\t\t, temp AS t\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 w.xWettkampf = r.xWettkampf\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\tAND t.athlet = ss.xSerienstart\r\n\t\t\tORDER BY s.xSerie, \r\n\t\t\t\t" . $argument . "\r\n\t\t");
                 if (mysql_errno() > 0) {
                     // DB error
                     AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
                 } else {
                     // initialize variables
                     $h = 0;
                     $i = 0;
                     $r = 0;
                     $resTable = new GUI_TechResultTable($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;
                             $c++;
                             // increment colspan to include ranking
                             $resTable->printHeatTitle($row[2], $row[3], $title, $row[5]);
                             $resTable->printAthleteHeader();
                         }
                         // 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);
                         //echo $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]) 

鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP AA_printErrorMsg函数代码示例发布时间:2022-05-14
下一篇:
PHP AA_formatResultTime函数代码示例发布时间:2022-05-14
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap