本文整理汇总了PHP中AA_printErrorMsg函数的典型用法代码示例。如果您正苦于以下问题:PHP AA_printErrorMsg函数的具体用法?PHP AA_printErrorMsg怎么用?PHP AA_printErrorMsg使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了AA_printErrorMsg函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: get_file
function get_file($local, $remote)
{
global $strErrFtpNoGet;
@ftp_pasv($this->ftpc, true);
$download = @ftp_get($this->ftpc, $local, $remote, FTP_BINARY);
if (!$download) {
AA_printErrorMsg($strErrFtpNoGet);
return false;
} else {
return true;
}
}
开发者ID:laiello,项目名称:athletica,代码行数:12,代码来源:cl_ftp_data.lib.php
示例2: save
function save($film = '')
{
global $strErrFilmExists;
$GLOBALS['AA_ERROR'] = '';
$this->film = $film;
/*mysql_query("
LOCK TABLES
serie WRITE
");
mysql_query("
UPDATE serie SET
Film = '" . $this->film . "'
WHERE xSerie = " . $this->heatID
);*/
mysql_query("LOCK TABLES runde READ, wettkampf READ, meeting READ, serie WRITE");
// check if filmnummer already exists in context of current meeting
$res = mysql_query("\r\n\t\t\t\tSELECT * FROM \r\n\t\t\t\t\tserie\r\n\t\t\t\t\tLEFT JOIN runde USING(xRunde) \r\n\t\t\t\t\tLEFT JOIN wettkampf USING(xWettkampf) \r\n\t\t\t\t\tLEFT JOIN meeting USING(xMeeting)\r\n\t\t\t\tWHERE meeting.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t\t\t\tAND serie.Film = " . $_POST['film']);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($res) == 0) {
// no results --> update film nummer
mysql_query("update \r\n\t\t\t\t\t\tserie\r\n\t\t\t\t\tset Film = " . $_POST['film'] . "\r\n\t\t\t\t\twhere xSerie = " . $_POST['item']);
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
} else {
// film already exists
$GLOBALS['AA_ERROR'] = $strErrFilmExists;
}
}
//mysql_query("UNLOCK TABLES");
if (mysql_affected_rows() == 0) {
$GLOBALS['AA_ERROR'] = $GLOBALS['strFilm'] . $GLOBALS['strErrNotValid'];
}
if (mysql_errno() > 0) {
$GLOBALS['AA_ERROR'] = mysql_errno() . ": " . mysql_error();
}
mysql_query("UNLOCK TABLES");
}
开发者ID:laiello,项目名称:athletica,代码行数:41,代码来源:cl_film.lib.php
示例3: AA_results_High
function AA_results_High($round, $layout, $singleRound, $content_navi, $cat, $disc, $rtyp)
{
require './config.inc.php';
require './config.inc.end.php';
require './lib/common.lib.php';
require './lib/heats.lib.php';
require './lib/utils.lib.php';
$p = "./tmp";
$fp = @fopen($p . "/live" . $round . ".html", 'w');
if (!$fp) {
AA_printErrorMsg($GLOBALS['strErrFileOpenFailed']);
return;
}
$svm = AA_checkSVM(0, $round);
// decide whether to show club or team name
if ($singleRound > 0) {
$single_svm = AA_checkSVM(0, $singleRound);
// decide whether to show club or team name
}
$mergedMain = AA_checkMainRound($round);
if ($mergedMain == 1) {
$round = AA_getMainRound($round);
}
// get url
$url = '';
$result = mysql_query("\r\n SELECT\r\n url\r\n FROM\r\n athletica_liveResultate.config");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($result);
$url = $row[0];
}
// read round data
if ($round > 0) {
$status = AA_getRoundStatus($round);
$content = $cfgHtmlStart1;
if (empty($GLOBALS['cfgDir'])) {
$content .= "<meta http-equiv='refresh' content='" . $GLOBALS['cfgMonitorReload'] . "; url=http://" . $url . "/live" . $round . ".html'>";
} else {
$content .= "<meta http-equiv='refresh' content='" . $GLOBALS['cfgMonitorReload'] . "; url=http://" . $url . "/" . $GLOBALS['cfgDir'] . "/live" . $round . ".html'>";
}
$content .= $cfgHtmlStart2;
$content .= $content_navi;
$content .= "</div ><div id='content_pc'><div id='content_pda'>";
$content .= "<h1>{$strStartlist} " . $_COOKIE['meeting'] . "</h1>";
// title
if (!empty($rtyp)) {
$content .= "<h2>{$cat} {$disc}, {$rtyp}</h2>";
} else {
$content .= "<h2>{$cat} {$disc}</h2>";
}
$content .= "<table class='dialog'>";
// display all athletes
$result = mysql_query("\r\n\t\t\tSELECT rt.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, 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, if('" . $svm . "', t.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)) \r\n\t\t\t\t, LPAD(s.Bezeichnung,5,'0') as heatid\r\n\t\t\t\t, rs.xResultat\r\n\t\t\t\t, rs.Leistung\r\n\t\t\t\t, rs.Info\r\n\t\t\t\t, at.Land\r\n , ss.Bemerkung\r\n , at.xAthlet\r\n , r.xRunde \r\n , ss.RundeZusammen \r\n\t\t\tFROM\r\n\t\t\t\tathletica.runde AS r\r\n\t\t\t\tLEFT JOIN athletica.serie AS s ON (s.xRunde = r.xRunde )\r\n\t\t\t\tLEFT JOIN athletica.serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n\t\t\t\tLEFT JOIN athletica.start AS st ON (st.xStart = ss.xStart)\r\n\t\t\t\tLEFT JOIN athletica.anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n\t\t\t\tLEFT JOIN athletica.athlet AS at ON (at.xAthlet = a.xAthlet)\r\n\t\t\t\tLEFT JOIN athletica.verein AS v ON (v.xVerein = at.xVerein)\r\n LEFT JOIN athletica.team AS t ON(a.xTeam = t.xTeam) \r\n\t\t\tLEFT JOIN athletica.rundentyp_" . $_COOKIE['language'] . " AS rt\r\n\t\t\t\tON rt.xRundentyp = r.xRundentyp\r\n\t\t\tLEFT JOIN athletica.resultat AS rs\r\n\t\t\t\tON rs.xSerienstart = ss.xSerienstart\r\n\t\t\tWHERE r.xRunde = {$round} \r\n\t\t\tORDER BY\r\n\t\t\t\theatid\r\n\t\t\t\t, ss.Position\r\n\t\t\t\t, rs.xResultat DESC\r\n\t\t");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$a = 0;
$h = 0;
$c_results = 0;
$rowclass = 'odd';
while ($row = mysql_fetch_row($result)) {
if ($row[20] > 0) {
$singleRound = $row[20];
} else {
$singleRound = $row[19];
}
/*
* Heat headerline
*/
if ($h != $row[2]) {
$h = $row[2];
// keep heat ID
if (is_null($row[0])) {
// only one round
$title = "{$strFinalround}";
} else {
// more than one round
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) {
//.........这里部分代码省略.........
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:results_high.lib.php
示例4: AA_rankinglist_Single
//.........这里部分代码省略.........
if ($getSortDisc[0]) {
if ($discTo > 0) {
$selection .= "d.Anzeige >=" . $getSortDisc[$discFrom] . " AND d.Anzeige <=" . $getSortDisc[$discTo] . " AND ";
} else {
$selection .= "d.Anzeige =" . $getSortDisc[$discFrom] . " AND ";
}
}
}
if ($heatFrom > 0) {
$selectionHeats = ' AND s.xSerie >= ' . $heatFrom . ' AND s.xSerie <= ' . $heatTo . ' ';
}
if ($athleteCat) {
$orderAthleteCat = ' k1.Anzeige, ';
}
if ($catMerged & !$heatSeparate || $eventMerged & !$heatSeparate) {
// get event rounds from DB
if ($ukc) {
$selection = " (d.Code = " . $cfgUKC_disc[0] . " || d.Code = " . $cfgUKC_disc[1] . " || d.Code = " . $cfgUKC_disc[2] . ") AND ";
}
if ($teamsm) {
$sql = "SELECT \r\n group_concat(r.xRunde)\r\n , k.Name\r\n , d.Name\r\n , d.Typ\r\n , w.xWettkampf\r\n , r.QualifikationSieger\r\n , r.QualifikationLeistung\r\n , w.Punkteformel\r\n , w.Windmessung\r\n , r.Speakerstatus\r\n , d.Staffellaeufer\r\n , CONCAT(DATE_FORMAT(r.Datum,'{$cfgDBdateFormat}'), ' ', TIME_FORMAT(r.Startzeit, '{$cfgDBtimeFormat}')) \r\n , w.xDisziplin \r\n , w.info \r\n FROM\r\n wettkampf AS w\r\n LEFT JOIN kategorie AS k ON (k.xKategorie = w.xKategorie)\r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d ON (d.xDisziplin = w.xDisziplin) \r\n LEFT JOIN runde AS r ON (r.xWettkampf = w.xWettkampf) \r\n WHERE " . $selection . "\r\n w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n AND r.Status = " . $cfgRoundStatus['results_done'] . " \r\n AND r.Datum LIKE '" . $date . "'\r\n GROUP BY w.xWettkampf\r\n ORDER BY\r\n k.Anzeige\r\n , d.Anzeige\r\n , r.Datum\r\n , r.Startzeit";
$results = mysql_query($sql);
} else {
$sql = "SELECT \r\n r.xRunde\r\n , k.Name\r\n , d.Name\r\n , d.Typ\r\n , w.xWettkampf\r\n , r.QualifikationSieger\r\n , r.QualifikationLeistung\r\n , w.Punkteformel\r\n , w.Windmessung\r\n , r.Speakerstatus\r\n , d.Staffellaeufer\r\n , CONCAT(DATE_FORMAT(r.Datum,'{$cfgDBdateFormat}'), ' ', TIME_FORMAT(r.Startzeit, '{$cfgDBtimeFormat}'))\r\n , w.xDisziplin \r\n , w.info \r\n FROM\r\n wettkampf AS w\r\n LEFT JOIN kategorie AS k ON (k.xKategorie = w.xKategorie)\r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d ON (d.xDisziplin = w.xDisziplin) \r\n LEFT JOIN runde AS r ON (r.xWettkampf = w.xWettkampf) \r\n WHERE " . $selection . "\r\n w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n AND r.Status = " . $cfgRoundStatus['results_done'] . " \r\n AND r.Datum LIKE '" . $date . "'\r\n ORDER BY\r\n k.Anzeige\r\n , d.Anzeige\r\n , r.Datum\r\n , r.Startzeit";
$results = mysql_query($sql);
}
} else {
// heats separate
$sql = "SELECT DISTINCT \r\n r.xRunde , \r\n k.Name , \r\n d.Name , \r\n d.Typ , \r\n w.xWettkampf , \r\n r.QualifikationSieger , \r\n r.QualifikationLeistung , \r\n w.Punkteformel , \r\n w.Windmessung , \r\n r.Speakerstatus , \r\n d.Staffellaeufer , \r\n CONCAT(DATE_FORMAT(r.Datum,'%d.%m.%y'), \r\n ' ', \r\n TIME_FORMAT(r.Startzeit, '%H:%i')) ,\r\n w.xDisziplin , \r\n rs.Hauptrunde,\r\n w.info \r\n FROM \r\n wettkampf AS w \r\n LEFT JOIN kategorie AS k ON (k.xKategorie = w.xKategorie) \r\n LEFT JOIN disziplin_" . $_COOKIE['language'] . " as d ON (d.xDisziplin = w.xDisziplin) \r\n LEFT JOIN runde AS r ON (r.xWettkampf = w.xWettkampf) \r\n LEFT JOIN rundenset as rs ON (r.xRunde=rs.xRunde ) \r\n WHERE \r\n " . $selection . " \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n AND r.Status = 4 \r\n AND r.Datum LIKE '%' \r\n ORDER BY\r\n k.Anzeige\r\n , d.Anzeige\r\n , r.Datum\r\n , r.Startzeit";
$results = mysql_query($sql);
}
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$limitRankSQL = "";
$limitRank = false;
if ($_GET['limitRank'] == "yes") {
// check if ranks are limited, but limitRankSQL will set only if export is pressed
if (!empty($_GET['limitRankFrom']) && !empty($_GET['limitRankTo'])) {
$limitRank = true;
}
}
// start a new HTML display page
if ($formaction == 'view' || $formaction == 'speaker') {
// display page
$list = new GUI_RankingList($_COOKIE['meeting']);
$list->printPageTitle("{$strRankingLists} " . $_COOKIE['meeting']);
} elseif ($formaction == "print") {
$list = new PRINT_RankingList($_COOKIE['meeting']);
if ($cover == true) {
// print cover page
$list->printCover($GLOBALS['strResults'], $cover_timing);
}
} elseif ($formaction == "exportpress") {
$list = new EXPORT_RankingListPress($_COOKIE['meeting'], 'txt');
if ($limitRank) {
$limitRankSQL = " AND ss.Rang <= " . $_GET['limitRankTo'] . " AND ss.Rang >= " . $_GET['limitRankFrom'] . " ";
}
} elseif ($formaction == "exportdiplom") {
$list = new EXPORT_RankingListDiplom($_COOKIE['meeting'], 'csv');
if ($limitRank) {
$limitRankSQL = " AND ss.Rang <= " . $_GET['limitRankTo'] . " AND ss.Rang >= " . $_GET['limitRankFrom'] . " ";
}
}
// initialize variables
开发者ID:laiello,项目名称:athletica,代码行数:67,代码来源:rankinglist_single.lib.php
示例5: printHeader
function printHeader($team, $category, $competitors)
{
$this->linecnt = $this->linecnt + 7;
?>
<table class='sheet'>
<tr>
<td class='sheet_title' colspan='6'><?php
echo $GLOBALS['strTeamRankingTitle'];
?>
</td>
</tr>
<?php
$result = mysql_query("\r\n\t\t\tSELECT m.Ort\r\n\t\t\t\t, s.Name\r\n\t\t\t\t, DATE_FORMAT(m.DatumBis, '" . $GLOBALS['cfgDBdateFormat'] . "')\r\n\t\t\tFROM\r\n\t\t\t\tmeeting AS m\r\n\t\t\t\tLEFT JOIN stadion AS s ON (m.xStadion = s.xStadion)\r\n\t\t\tWHERE \r\n m.xMeeting = " . $_COOKIE['meeting_id']);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($result);
$place = $row[0];
$stadium = $row[1];
$date = $row[2];
mysql_free_result($result);
}
?>
<tr>
<td class='sheet_col1'><?php
echo $GLOBALS['strPlace'] . ", " . $GLOBALS['strStadium'];
?>
</td>
<td class='sheet_col2'><?php
echo $place . ", " . $stadium;
?>
</td>
<td class='sheet_col3'><?php
echo $GLOBALS['strDate'];
?>
</td>
<td class='sheet_col4' colspan='4'><?php
echo $date;
?>
</td>
</tr>
<tr>
<td class='sheet_col1'><?php
echo $GLOBALS['strClub'];
?>
</td>
<td class='sheet_team'><?php
echo $team;
?>
</td>
<td class='sheet_col3'><?php
echo $GLOBALS['strCategory'];
?>
</td>
<td class='sheet_cat' colspan='4'><?php
echo $category;
?>
</td>
</tr>
<tr>
<td class='sheet_col1'><?php
echo $GLOBALS['strCompetition'];
?>
</td>
<td class='sheet_col2' colspan='6'><?php
echo $competitors;
?>
</td>
</tr>
<tr>
<td colspan='7'><hr class='sep'/></td>
</tr>
<?php
$this->linecnt = $this->linecnt + 3;
// increment line count
}
开发者ID:laiello,项目名称:athletica,代码行数:77,代码来源:cl_print_page.lib.php
示例6: AA_checkHeight
function AA_checkHeight($round, $heat)
{
$sql = "SELECT \r\n h.xHoehe \r\n FROM \r\n hoehe AS h\r\n LEFT JOIN runde AS r ON (r.xRunde = h.xRunde)\r\n LEFT JOIN wettkampf AS w ON (w.xWettkampf = r.xWettkampf) \r\n WHERE h.xRunde = " . $round . " \r\n AND h.xSerie = " . $heat . "\r\n AND w.xMeeting = " . $_COOKIE['meeting_id'];
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
return mysql_num_rows($res);
}
}
开发者ID:laiello,项目名称:athletica,代码行数:10,代码来源:results.lib.php
示例7: check_samePoints
function check_samePoints($xCategory)
{
$sql = "SELECT \r\n Punkte,\r\n xDisziplin,\r\n xTeam\r\n FROM tmp_team \r\n WHERE xKategorie = " . $xCategory . "\r\n ORDER BY xDisziplin, Punkte";
$res = mysql_query($sql);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$disc = 0;
$arr_team = array();
while ($row = mysql_fetch_row($res)) {
if ($disc != $row[1]) {
$arr_team[$row[2]]++;
}
$disc = $row[1];
}
}
return $arr_team;
}
开发者ID:laiello,项目名称:athletica,代码行数:18,代码来源:rankinglist_team.lib.php
示例8: AA_getResultRemark
/**
* get remark if combined heats exist
* -----------------------------------
*
* returns remark
*/
function AA_getResultRemark($xAthlete)
{
$remark = '';
// check for combined event
$query_mk = "SELECT \r\n ss.xSerienstart , ss.Bemerkung \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 wettkampf as w ON (w.xWettkampf = st.xWettkampf)\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 verein AS v ON (v.xVerein = at.xVerein )\r\n LEFT JOIN rundentyp AS rt ON rt.xRundentyp = r.xRundentyp \r\n WHERE w.mehrkampfcode > 0\r\n AND at.xAthlet = " . $xAthlete;
$result = mysql_query($query_mk);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_row($result);
$remark = $row[1];
}
}
return $remark;
}
开发者ID:laiello,项目名称:athletica,代码行数:22,代码来源:heats.lib.php
示例9: get_file
function get_file($filename)
{
global $strErrFileOpenFailed;
// get file
// skip if the file is allredy read on script-runtime
if (isset($GLOBALS['omega_lstfiles'][$filename])) {
return $GLOBALS['omega_lstfiles'][$filename];
}
$GLOBALS['omega_lstfiles'][$filename] = false;
if ($this->connection == "local") {
if (!file_exists($this->path . "/" . $filename)) {
return false;
}
$fp = @fopen($this->path . "/" . $filename, 'r');
} elseif ($this->connection == "ftp") {
$this->ftp->open_connection($this->host, $this->user, $this->pass);
$this->ftp->get_file("./tmp/" . $filename, $this->ftppath . "/" . $filename);
$fp = @fopen("./tmp/" . $filename, 'r');
}
if (!$fp) {
return false;
AA_printErrorMsg($strErrFileOpenFailed);
} else {
$content = array();
while (!feof($fp)) {
$buffer = fgets($fp, 4096);
$t = false;
$field = 0;
$tmp = array();
for ($i = 0; $i < strlen($buffer); $i++) {
if ($buffer[$i] == '"') {
if ($buffer[$i + 1] == '"' && $t) {
$tmp[$field] .= $buffer[$i];
continue 2;
} elseif ($t) {
$t = false;
} elseif (!$t) {
$t = true;
}
} elseif ($buffer[$i] == ';' && !$t) {
$tmp[$field] = trim($tmp[$field]);
$field++;
} else {
$tmp[$field] .= $buffer[$i];
}
}
$tmp[$field] = trim($tmp[$field]);
$content[] = $tmp;
}
}
$GLOBALS['omega_lstfiles'][$filename] = $content;
return $content;
}
开发者ID:laiello,项目名称:athletica,代码行数:53,代码来源:cl_omega.lib.php
示例10: AA_rankinglist_Combined
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") {
//.........这里部分代码省略.........
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:rankinglist_combined.lib.php
示例11: GUI_Page
//
if (isset($_POST['ukc_meeting'])) {
$ukc_meeting = $_POST['ukc_meeting'];
}
$page = new GUI_Page('admin_onlineRegUKC.php');
$page->startPage();
$page->printPageTitle($strImportUKC_Title);
$menu = new GUI_Menulist();
$menu->addButton($cfgURLDocumentation . 'help/administration/base.html', $strHelp, '_blank');
$menu->printMenu();
// get xml file for registrations from athletes
// get uploaded XML file and read its content
$fd = fopen($_FILES['xmlfile']['tmp_name'], 'rb');
$content = fread($fd, filesize($_FILES['xmlfile']['tmp_name']));
if (!$fd) {
AA_printErrorMsg($strErrFtpNoGet);
} else {
$xml = new XML_simple_data();
$arr_noCat = $xml->load_xml_simple($_FILES['xmlfile']['tmp_name'], 'regUKC', '', $ukc_meeting);
if ($arr_noCat['cat'][0] != '') {
foreach ($arr_noCat['cat'] as $key => $val) {
$mess = str_replace('%NAME%', $val, $strXmlNoCatAge);
echo $mess;
}
}
if ($arr_noCat['club'][0] != '') {
foreach ($arr_noCat['club'] as $key => $val) {
$mess = str_replace('%NAME%', $val, $strXmlNoClub);
echo $mess;
}
}
开发者ID:laiello,项目名称:athletica,代码行数:31,代码来源:admin_onlineRegUKC.php
示例12: AA_results_Track
function AA_results_Track($round, $layout, $content_navi, $cat, $disc, $rtyp, $event)
{
require './config.inc.php';
require './config.inc.end.php';
require './lib/common.lib.php';
require './lib/heats.lib.php';
require './lib/utils.lib.php';
require_once './lib/timing.lib.php';
$p = "./tmp";
$fp = @fopen($p . "/live" . $round . ".html", 'w');
if (!$fp) {
AA_printErrorMsg($GLOBALS['strErrFileOpenFailed']);
return;
}
$relay = AA_checkRelay($event);
// check, if this is a relay event
$svm = AA_checkSVM(0, $round);
// decide whether to show club or team name
global $content;
$mergedMain = AA_checkMainRound($round);
if ($mergedMain == 1) {
$round = AA_getMainRound($round);
}
// get url
$url = '';
$result = mysql_query("\r\n SELECT\r\n url\r\n FROM\r\n athletica_liveResultate.config");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($result);
$url = $row[0];
}
// read round data
if ($round > 0) {
$content = $cfgHtmlStart1;
if (empty($GLOBALS['cfgDir'])) {
$content .= "<meta http-equiv='refresh' content='" . $GLOBALS['cfgMonitorReload'] . "; url=http://" . $url . "/live" . $round . ".html'>";
} else {
$content .= "<meta http-equiv='refresh' content='" . $GLOBALS['cfgMonitorReload'] . "; url=http://" . $url . "/" . $GLOBALS['cfgDir'] . "/live" . $round . ".html'>";
}
$content .= $cfgHtmlStart2;
$content .= $content_navi;
$content .= "</div ><div id='content_pc'><div id='content_pda'>";
$content .= "<h1>{$strStartlist} " . $_COOKIE['meeting'] . "</h1>";
// title
if (!empty($rtyp)) {
$content .= "<h2>{$cat} {$disc}, {$rtyp}</h2>";
} else {
$content .= "<h2>{$cat} {$disc}</h2>";
}
$content .= "<table class='dialog'>";
// check if round is final
$sql_r = "SELECT \r\n rt.Typ\r\n FROM\r\n athletica.runde as r\r\n LEFT JOIN athletica.rundentyp_" . $_COOKIE['language'] . " as rt USING (xRundentyp)\r\n WHERE\r\n r.xRunde=" . $round;
$res_r = mysql_query($sql_r);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
$order = "ASC";
if (mysql_num_rows($res_r) == 1) {
$row_r = mysql_fetch_row($res_r);
if ($row_r[0] == 'F') {
$order = "DESC";
}
}
// display all athletes
if ($relay == FALSE) {
// single event
$query = "SELECT \r\n r.Bahnen\r\n , rt.Name\r\n , rt.Typ\r\n , s.xSerie\r\n , s.Bezeichnung\r\n , s.Wind\r\n , s.Film\r\n , an.Bezeichnung\r\n , ss.xSerienstart\r\n , ss.Position\r\n , ss.Rang\r\n , ss.Qualifikation\r\n , a.Startnummer\r\n , at.Name\r\n , at.Vorname\r\n , at.Jahrgang \r\n , if('" . $svm . "', t.Name, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)) \r\n , LPAD(s.Bezeichnung,5,'0') as heatid\r\n , s.Handgestoppt\r\n , at.Land \r\n , ss.Bemerkung \r\n , at.xAthlet \r\n FROM \r\n athletica.runde AS r\r\n LEFT JOIN athletica.serie AS s ON (s.xRunde = r.xRunde)\r\n LEFT JOIN athletica.serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n LEFT JOIN athletica.start AS st ON (st.xStart = ss.xStart)\r\n LEFT JOIN athletica.anmeldung AS a ON (a.xAnmeldung = st.xAnmeldung)\r\n LEFT JOIN athletica.athlet AS at ON (at.xAthlet = a.xAthlet)\r\n LEFT JOIN athletica.verein AS v ON (v.xVerein = at.xVerein)\r\n LEFT JOIN athletica.team AS t ON(a.xTeam = t.xTeam)\r\n LEFT JOIN athletica.rundentyp_" . $_COOKIE['language'] . " AS rt ON rt.xRundentyp = r.xRundentyp\r\n LEFT JOIN athletica.anlage AS an ON an.xAnlage = s.xAnlage\r\n WHERE\r\n r.xRunde = " . $round . " \r\n ORDER BY heatid " . $order . ", ss.Position";
} else {
// relay event
$query = "SELECT \r\n r.Bahnen\r\n , rt.Name\r\n , rt.Typ\r\n , s.xSerie\r\n , s.Bezeichnung\r\n , s.Wind\r\n , s.Film\r\n , an.Bezeichnung\r\n , ss.xSerienstart\r\n , ss.Position\r\n , ss.Rang\r\n , ss.Qualifikation\r\n , sf.Name\r\n , if('" . $svm . "', t.Name, v.Name) \r\n , LPAD(s.Bezeichnung,5,'0') as heatid\r\n , s.Handgestoppt\r\n , ss.Bemerkung \r\n FROM \r\n athletica.runde AS r\r\n LEFT JOIN athletica.serie AS s ON (s.xRunde = r.xRunde)\r\n LEFT JOIN athletica.serienstart AS ss ON (ss.xSerie = s.xSerie)\r\n LEFT JOIN athletica.start AS st ON (st.xStart = ss.xStart)\r\n LEFT JOIN athletica.staffel AS sf ON (sf.xStaffel = st.xStaffel)\r\n LEFT JOIN athletica.verein AS v ON (v.xVerein = sf.xVerein) \r\n LEFT JOIN athletica.team AS t ON(sf.xTeam = t.xTeam)\r\n LEFT JOIN athletica.rundentyp_" . $_COOKIE['language'] . " AS rt ON rt.xRundentyp = r.xRundentyp\r\n LEFT JOIN athletica.anlage AS an ON an.xAnlage = s.xAnlage\r\n WHERE \r\n r.xRunde = " . $round . " \r\n ORDER BY heatid " . $order . ", ss.Position";
}
$result = mysql_query($query);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
// initialize variables
$h = 0;
// heat counter
$p = 0;
// position counter (to evaluate empty heats
$i = 0;
// input counter (an individual id is assigned to each
// input field, focus is then moved to the next input
// field by calling $i+1)
$rowclass = 'odd';
$tracks = 0;
while ($row = mysql_fetch_row($result)) {
$p++;
// increment position counter
/*
* Heat headerline
*/
if ($h != $row[3]) {
$tracks = $row[0];
// keep nbr of planned tracks
// fill previous heat with empty tracks
if ($p > 1) {
//.........这里部分代码省略.........
开发者ID:laiello,项目名称:athletica,代码行数:101,代码来源:results_track.lib.php
示例13: printList
function printList($key = 0)
{
require './config.inc.php';
$this->select->options[1] = 1;
$this->select->options[2] = 2;
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
if ($key == 0) {
$key = '-';
}
$this->select->selectOption($key);
$this->select->printList();
}
开发者ID:laiello,项目名称:athletica,代码行数:14,代码来源:cl_gui_select.lib.php
示例14: getNextHeight
function getNextHeight($heat, $curr_perf)
{
require './lib/common.lib.php';
$result = mysql_query("\r\n SELECT DISTINCT\r\n r.Leistung\r\n FROM\r\n resultat AS r\r\n , serienstart AS ss\r\n WHERE r.xSerienstart = ss.xSerienstart\r\n AND ss.xSerie = {$heat}\r\n AND r.Leistung > {$curr_perf}\r\n ORDER BY\r\n r.Leistung ASC\r\n ");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($result);
$new_perf = AA_formatResultMeter($row[0]);
mysql_free_result($result);
}
return $new_perf;
}
开发者ID:laiello,项目名称:athletica,代码行数:14,代码来源:results_high.lib.php
示例15: AA_timing_getAutoRank
function AA_timing_getAutoRank()
{
$autorank = '';
$res = mysql_query("SELECT AutoRangieren FROM meeting WHERE xMeeting = " . $_COOKIE['meeting_id']);
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_row($res);
$autorank = $row[0];
}
return $autorank;
}
开发者ID:laiello,项目名称:athletica,代码行数:12,代码来源:timing.lib.php
示例16: AA_printErrorMsg
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
} else {
if ($_POST['arg'] == 'add_start') {
// add new athlete/relay
AA_heats_addStart($round);
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
AA_timing_setStartInfo($round, false);
} else {
if ($_GET['arg'] == 'del_start') {
// delete athlete/relay
AA_heats_deleteStart();
if (!empty($GLOBALS['AA_ERROR'])) {
AA_printErrorMsg($GLOBALS['AA_ERROR']);
}
AA_timing_setStartInfo($round, false);
} elseif ($_GET['arg'] == "del_results") {
// delete all results
AA_results_deleteResults
|
请发表评论