本文整理汇总了PHP中AA_checkMeetingID函数的典型用法代码示例。如果您正苦于以下问题：PHP AA_checkMeetingID函数的具体用法？PHP AA_checkMeetingID怎么用？PHP AA_checkMeetingID使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了AA_checkMeetingID函数的10个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: setPrint
/**********
*
* meeting_entries_print.php
* -------------------------
*
*/
require './lib/cl_gui_dropdown.lib.php';
require './lib/cl_gui_menulist.lib.php';
require './lib/cl_gui_page.lib.php';
require './lib/common.lib.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
$page = new GUI_Page('meeting_entries_print');
$page->startPage();
$page->printPageTitle($strPrint);
?>
<script type="text/javascript">
<!--
function setPrint()
{
document.printdialog.formaction.value = 'print'
document.printdialog.target = '_blank';
}示例2: AA_checkControl_UKC
/**
check if xControl of the meeting is set
@return 1 if xControl is given and result upload is wished
2 if no result upload will be made
0 if xControl is 0 but the result upload is activated
*/
function AA_checkControl_UKC($meeting_nr = '')
{
if (AA_checkMeetingID()) {
if (empty($meeting_nr)) {
$res = mysql_query("SELECT Nummer FROM meeting WHERE xMeeting = " . $_COOKIE['meeting_id']);
if (mysql_errno() > 0) {
AA_printErrorPage(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_array($res);
if ($row[0] > 0) {
return 1;
} else {
return 0;
}
}
} else {
return 1;
}
}
}示例3: AA_rankinglist_Team
function AA_rankinglist_Team($category, $formaction, $break, $cover, &$parser, $event, $heatSeparate, $type, $catFrom, $catTo)
{
require './lib/cl_gui_page.lib.php';
require './lib/cl_print_page.lib.php';
require './lib/cl_export_page.lib.php';
require './lib/common.lib.php';
require './lib/results.lib.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
global $rFrom, $rTo, $limitRank;
// limits rank if limitRank set to true
$rFrom = 0;
$rTo = 0;
$limitRank = false;
if ($_GET['limitRank'] == "yes" && substr($formaction, 0, 6) == "export") {
// check if ranks are limited
if (!empty($_GET['limitRankFrom']) && !empty($_GET['limitRankTo'])) {
$limitRank = true;
$rFrom = $_GET['limitRankFrom'];
$rTo = $_GET['limitRankTo'];
}
}
// start a new HTML display page
if ($formaction == 'view') {
$GLOBALS[$list] = new GUI_TeamRankingList($_COOKIE['meeting']);
$GLOBALS[$list]->printPageTitle("{$strRankingLists} " . $_COOKIE['meeting']);
} elseif ($formaction == "xml") {
$GLOBALS['xmladdon'] = true;
$GLOBALS[$list] = new XML_TeamRankingList($parser);
} elseif ($formaction == "print") {
$GLOBALS[$list] = new PRINT_TeamRankingList($_COOKIE['meeting']);
if ($cover == true) {
// print cover page
$GLOBALS[$list]->printCover($GLOBALS['strResults']);
}
} elseif ($formaction == "exportpress") {
$GLOBALS[$list] = new EXPORT_TeamRankingListPress($_COOKIE['meeting'], 'txt');
} elseif ($formaction == "exportdiplom") {
$GLOBALS[$list] = new EXPORT_TeamRankingListDiplom($_COOKIE['meeting'], 'csv');
}
$selection = '';
if ($formaction != "xml") {
if ($event != '') {
$mergedCat = AA_mergedCatEvent($category, $event);
} else {
$mergedCat = AA_mergedCat($category);
}
}
if (!empty($category)) {
// show every category
if ($mergedCat == '') {
$selection = " AND k.xKategorie = {$category}";
} else {
if ($heatSeparate) {
$selection = " AND k.xKategorie = {$category}";
} else {
$selection = " AND k.xKategorie IN {$mergedCat}";
}
}
}
// show category from .... to
if ($catFrom > 0) {
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$selection = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " ";
} else {
$selection = "AND k.Anzeige =" . $getSortCat[$catFrom] . " ";
}
}
}
// evaluation per category
global $cfgEventType, $strEventTypeSingleCombined, $strEventTypeClubMA, $strEventTypeClubMB, $strEventTypeClubMC, $strEventTypeClubFA, $strEventTypeClubFB, $strEventTypeClubBasic, $strEventTypeClubAdvanced, $strEventTypeClubTeam, $strEventTypeClubCombined, $strEventTypeTeamSM;
$results = mysql_query("\r\n\tSELECT Distinct\r\n\t \tk.xKategorie\r\n\t \t, k.Name\r\n\t\t, w.Typ\r\n , ks.xKategorie_svm\r\n , ks.Code\r\n \tFROM\r\n\t \twettkampf AS w\r\n\t \tLEFT JOIN kategorie AS k ON (k.xKategorie = w.xKategorie)\r\n LEFT JOIN kategorie_svm AS ks ON (ks.xKategorie_svm = w.xKategorie_svm)\r\n \tWHERE \r\n w.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t " . $selection . " \r\n AND w.Typ >= " . $cfgEventType[$strEventTypeClubBasic] . " \r\n\t AND w.Typ < " . $cfgEventType[$strEventTypeTeamSM] . "\r\n\t\r\n\tORDER BY\r\n\t\tk.Anzeige, ks.Code\r\n");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
mysql_query("DROP TABLE IF EXISTS tmp_team");
// temporary table
mysql_query("CREATE TEMPORARY TABLE tmp_team( \r\n xKategorie int(11)\r\n , xDisziplin int(11) \r\n , Punkte float\r\n , xTeam int(11) \r\n )\r\n ENGINE=HEAP");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
// process all teams per category
while ($row = mysql_fetch_row($results)) {
// Club rankinglist:Combined
if ($row[2] == $cfgEventType[$strEventTypeClubCombined]) {
processCombined($row[0], $row[1], $type, $row[2]);
} else {
processSingle($row[0], $row[1], $row[3], $row[4]);
//.........这里部分代码省略.........
示例4: 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") {
//.........这里部分代码省略.........
示例5: AA_rankinglist_Single
function AA_rankinglist_Single($category, $event, $round, $formaction, $break, $cover, $biglist = false, $cover_timing = false, $date = '%', $show_efforts = 'none', $heatSeparate, $catFrom, $catTo, $discFrom, $discTo, $heatFrom, $heatTo, $athleteCat, $content_navi)
{
require './lib/cl_gui_page.lib.php';
require './lib/common.lib.php';
require './config.inc.php';
require './config.inc.end.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
$p = "./tmp";
$fp = @fopen($p . "/live" . $round . ".html", 'w');
if (!$fp) {
AA_printErrorMsg($GLOBALS['strErrFileOpenFailed']);
return;
}
// set up ranking list selection
$selection = '';
$eventMerged = false;
$catMerged = false;
$flagSubtitle = false;
$flagInfoLine1 = false;
$flagInfoLine2 = false;
$selectionHeats = '';
$orderAthleteCat = '';
$saison = $_SESSION['meeting_infos']['Saison'];
if ($saison == '') {
$saison = "O";
//if no saison is set take outdoor
}
if ($round > 0) {
// show a specific round
$eventMerged = false;
$sqlEvents = AA_getMergedEventsFromEvent($event);
if ($sqlEvents != '') {
$selection = "w.xWettkampf IN " . $sqlEvents . " AND ";
$eventMerged = true;
} else {
$selection = "w.xWettkampf =" . $event . " AND ";
}
} else {
if ($category == 0) {
// show all disciplines for every category
$catMerged = true;
} else {
if ($event == 0) {
// show all disciplines for a specific category
$catMerged = false;
$mergedCat = AA_mergedCat($category);
if ($mergedCat != '') {
$selection = "w.xKategorie =" . $category . " AND ";
$catMerged = true;
} else {
$selection = "w.xKategorie =" . $category . " AND ";
}
} else {
if ($round == 0) {
// show all rounds for a specific event
$eventMerged = false;
$sqlEvents = AA_getMergedEventsFromEvent($event);
if ($sqlEvents != '') {
$selection = "w.xWettkampf IN " . $sqlEvents . " AND ";
$eventMerged = true;
} else {
$selection = "w.xWettkampf =" . $event . " AND ";
}
}
}
}
}
if ($catFrom > 0) {
//
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$selection = "k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " AND ";
} else {
$selection = "k.Anzeige =" . $getSortCat[$catFrom] . " AND ";
}
}
}
if ($discFrom > 0) {
//
$getSortDisc = AA_getSortDisc($discFrom, $discTo);
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 . ' ';
//.........这里部分代码省略.........
示例6: AA_rankinglist_TeamSM
function AA_rankinglist_TeamSM($category, $event, $formaction, $break, $cover, $cover_timing = false, $date = '%')
{
require './lib/cl_gui_page.lib.php';
require './lib/cl_print_page.lib.php';
require './lib/cl_export_page.lib.php';
require './lib/common.lib.php';
require './lib/results.lib.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
global $rFrom, $rTo, $limitRank, $date;
$rFrom = 0;
$rTo = 0;
// limits rank if limitRank set to true
$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') {
$list = new GUI_TeamSMRankingList($_COOKIE['meeting']);
$list->printPageTitle("{$strRankingLists} " . $_COOKIE['meeting']);
} elseif ($formaction == "print") {
$list = new PRINT_TeamSMRankingList($_COOKIE['meeting']);
if ($cover == true) {
// print cover page
$list->printCover($GLOBALS['strResults']);
}
} elseif ($formaction == "exportpress") {
$list = new EXPORT_TeamSMRankingListPress($_COOKIE['meeting'], 'txt');
} elseif ($formaction == "exportdiplom") {
$list = new EXPORT_TeamSMRankingListDiplom($_COOKIE['meeting'], 'csv');
}
$selection = '';
if (!empty($event)) {
// show specific event
$selection = " w.xWettkampf = {$event}";
} elseif (!empty($category)) {
// show disciplines per specific category
$selection = " w.xMeeting = " . $_COOKIE['meeting_id'] . " AND w.xKategorie = {$category}";
} else {
// show events over all categories
$selection = " w.xMeeting = " . $_COOKIE['meeting_id'] . " ";
}
//
// get each discipline for selection and process
//
$result = mysql_query("\r\n\t\tSELECT\r\n\t\t\tw.xWettkampf\r\n\t\t\t, d.Typ\r\n\t\t\t, k.Name\r\n\t\t\t, d.Name\r\n\t\t\t, w.Windmessung\r\n\t\tFROM\r\n\t\t\twettkampf AS w\r\n\t\t\t, kategorie AS k\r\n\t\t\t, disziplin AS d\r\n\t\tWHERE\r\n\t\t\t{$selection}\r\n\t\tAND\tk.xKategorie = w.xKategorie\r\n\t\tAND\td.xDisziplin = w.xDisziplin\r\n\t\tAND\tw.Typ = " . $cfgEventType[$strEventTypeTeamSM] . "\r\n\t\tORDER BY\r\n\t\t\tk.Anzeige\r\n\t\t\t, d.Anzeige\r\n\t");
if (mysql_errno() > 0) {
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$cat = "";
while ($row = mysql_fetch_array($result)) {
if ($cat != $row[2] && !empty($cat)) {
}
processDiscipline($row[0], $row[1], $row[2], $row[3], $row[4], $list);
}
}
$list->endPage();
}示例7: AA_rankinglist_Single
function AA_rankinglist_Single($category, $event, $round, $formaction, $break, $cover, $biglist = false, $cover_timing = false, $date = '%', $show_efforts = 'none', $heatSeparate, $catFrom, $catTo, $discFrom, $discTo, $heatFrom, $heatTo, $athleteCat, $withStartnr, $ranklistAll, $ukc)
{
// anstead of remove the function "rankinglist ubs kids cup"", set $ukc for the moment false --> later remove it perhaps
// "rankinglist ubs kids cup" is solved in rankinglist_combined.lib.php
$ukc = false;
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 './lib/utils.lib.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
// check teamsm
$teamsm = AA_checkTeamsm(0, 0);
// set up ranking list selection
$selection = '';
$eventMerged = false;
$catMerged = false;
$flagSubtitle = false;
$flagInfoLine1 = false;
$flagInfoLine2 = false;
$results_ukc = FALSE;
$selectionHeats = '';
$orderAthleteCat = '';
$saison = $_SESSION['meeting_infos']['Saison'];
if ($saison == '') {
$saison = "O";
//if no saison is set take outdoor
}
if ($round > 0) {
// show a specific round
$eventMerged = false;
$sqlEvents = AA_getMergedEventsFromEvent($event);
if ($sqlEvents != '') {
$selection = "w.xWettkampf IN " . $sqlEvents . " AND ";
$eventMerged = true;
} else {
$selection = "r.xRunde =" . $round . " AND ";
}
} elseif ($category == 0) {
// show all disciplines for every category
$catMerged = true;
} elseif ($event == 0) {
// show all disciplines for a specific category
$catMerged = false;
$mergedCat = AA_mergedCat($category);
if ($mergedCat != '') {
$selection = "w.xKategorie IN " . $mergedCat . " AND ";
$catMerged = true;
} else {
$selection = "w.xKategorie =" . $category . " AND ";
}
} else {
if ($round == 0) {
// show all rounds for a specific event
$eventMerged = false;
$sqlEvents = AA_getMergedEventsFromEvent($event);
if ($sqlEvents != '') {
$selection = "w.xWettkampf IN " . $sqlEvents . " AND ";
$eventMerged = true;
} else {
$selection = "w.xWettkampf =" . $event . " AND ";
}
}
}
if ($catFrom > 0) {
//
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$selection = "k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " AND ";
} else {
$selection = "k.Anzeige =" . $getSortCat[$catFrom] . " AND ";
}
}
}
if ($discFrom > 0) {
//
$getSortDisc = AA_getSortDisc($discFrom, $discTo);
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) {
//.........这里部分代码省略.........
示例8: AA_rankinglist_Sheets
function AA_rankinglist_Sheets($category, $event, $formaction, $cover, $cover_timing = false, $heatSeparate, $catFrom, $catTo, $discFrom, $discTo)
{
// $heatSeparate=true (always show heat separate)
$heatSeparate = true;
require './lib/cl_gui_page.lib.php';
require './lib/cl_print_page.lib.php';
require './lib/common.lib.php';
require './lib/results.lib.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
// start a new HTML display page
if ($formaction == 'view') {
$GLOBALS[$list] = new GUI_TeamSheet($_COOKIE['meeting']);
$GLOBALS[$list]->printPageTitle("{$strClubSheets} " . $_COOKIE['meeting']);
} else {
$GLOBALS[$list] = new PRINT_TeamSheet($_COOKIE['meeting']);
if ($cover == true) {
// print cover page
$GLOBALS[$list]->printCover($strClubSheets, $cover_timing);
}
}
$selection = '';
if ($event != '') {
$mergedCat = AA_mergedCatEvent($category, $event);
} else {
$mergedCat = AA_mergedCat($category);
}
if (!empty($category)) {
// show every category
if ($mergedCat == '') {
$selection = " AND k.xKategorie = {$category}";
} else {
if ($heatSeparate) {
$selection = " AND k.xKategorie = {$category}";
} else {
$selection = " AND k.xKategorie IN {$mergedCat}";
}
}
}
if ($catFrom > 0) {
//
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$selection = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo];
} else {
$selection = " AND k.Anzeige =" . $getSortCat[$catFrom];
}
}
}
if ($discFrom > 0) {
//
$getSortDisc = AA_getSortDisc($discFrom, $discTo);
if ($getSortDisc[0]) {
if ($discTo > 0) {
$selection2 .= " AND d.Anzeige >=" . $getSortDisc[$discFrom] . " AND d.Anzeige <=" . $getSortDisc[$discTo];
} else {
$selection2 .= " AND d.Anzeige =" . $getSortDisc[$discFrom];
}
}
}
// evaluation per category
mysql_query("DROP TABLE IF EXISTS tempresult");
mysql_query("DROP TABLE IF EXISTS sheet_tmp");
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
}
$sql = "SELECT\r\n k.xKategorie\r\n , k.Name\r\n , w.Typ\r\n FROM\r\n kategorie AS k\r\n LEFT JOIN wettkampf AS w ON (k.xKategorie = w.xKategorie)\r\n WHERE w.xMeeting = " . $_COOKIE['meeting_id'] . " \r\n " . $selection . " AND w.Typ >= " . $cfgEventType[$strEventTypeClubBasic] . " \r\n GROUP BY\r\n k.xKategorie,\r\n w.Typ\r\n ORDER BY\r\n k.Anzeige";
$results = mysql_query($sql);
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$GLOBALS['AA_TC'] = 0;
// team counter
// process all categories
while ($row = mysql_fetch_row($results)) {
// Team sheet: Combined
if ($row[2] == $cfgEventType[$strEventTypeClubCombined]) {
AA_sheets_processCombined($row[0], $row[1], $row[2]);
} else {
AA_sheets_processSingle($row[0], $row[1], $selection2);
}
}
mysql_free_result($results);
}
// ET DB error categories
$GLOBALS[$list]->endPage();
// end HTML page for printing
}示例9: AA_checkControl
/**
check if xControl of the meeting is set
@return 1 if xControl is given and result upload is wished
2 if no result upload will be made
0 if xControl is 0 but the result upload is activated
*/
function AA_checkControl()
{
if (AA_checkMeetingID()) {
$res = mysql_query("SELECT xControl, Online FROM meeting WHERE xMeeting = " . $_COOKIE['meeting_id']);
if (mysql_errno() > 0) {
AA_printErrorPage(mysql_errno() . ": " . mysql_error());
} else {
$row = mysql_fetch_array($res);
if ($row[0] > 0 && $row[1] == 'y') {
return 1;
} elseif ($row[0] == 0 && $row[1] == 'y') {
return 0;
} elseif ($row[1] == 'n') {
return 2;
}
}
}
}示例10: AA_rankinglist_Combined
function AA_rankinglist_Combined($category, $formaction, $break, $cover, $sepu23, $cover_timing = false, $date = '%', $disc_nr, $catFrom, $catTo)
{
require './lib/cl_gui_page.lib.php';
require './lib/cl_print_page.lib.php';
require './lib/cl_export_page.lib.php';
require './lib/common.lib.php';
require './lib/results.lib.php';
if (AA_connectToDB() == FALSE) {
// invalid DB connection
return;
// abort
}
if (AA_checkMeetingID() == FALSE) {
// no meeting selected
return;
// abort
}
$contestcat = " ";
if (!empty($category)) {
// show every category
$contestcat = " AND w.xKategorie = {$category}";
}
if ($catFrom > 0) {
$getSortCat = AA_getSortCat($catFrom, $catTo);
if ($getSortCat[0]) {
if ($catTo > 0) {
$contestcat = " AND k.Anzeige >=" . $getSortCat[$catFrom] . " AND k.Anzeige <=" . $getSortCat[$catTo] . " ";
} else {
$contestcat = " AND k.Anzeige =" . $getSortCat[$catFrom] . " ";
}
}
}
$dCode = 0;
// get athlete info per contest category
$results = mysql_query("\r\n\tSELECT DISTINCT \r\n\t\ta.xAnmeldung\r\n\t\t, at.Name\r\n\t\t, at.Vorname\r\n\t\t, at.Jahrgang\r\n\t\t, k.Name\r\n\t\t, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)\r\n\t\t, IF(at.xRegion = 0, at.Land, re.Anzeige)\r\n\t\t, w.Mehrkampfcode\r\n\t\t, d.Name\r\n\t\t, w.xKategorie\r\n\t\t, ka.Code\r\n\t\t, ka.Name\r\n\t\t, ka.Alterslimite \r\n , d.Code \r\n\tFROM\r\n\t\tanmeldung AS a\r\n\t\t, athlet AS at\r\n\t\t, verein AS v\r\n\t\t, kategorie AS k\r\n\t\t, kategorie AS ka\r\n\t\t, start as st\r\n\t\t, wettkampf as w\r\n\t\t, disziplin as d\r\n\t\tLEFT JOIN region as re ON at.xRegion = re.xRegion\r\n\tWHERE a.xMeeting = " . $_COOKIE['meeting_id'] . "\r\n\t" . $contestcat . "\r\n\tAND at.xAthlet = a.xAthlet\r\n\tAND v.xVerein = at.xVerein\r\n\tAND k.xKategorie = w.xKategorie\r\n\tAND st.xAnmeldung = a.xAnmeldung\r\n\tAND w.xWettkampf = st.xWettkampf \r\n\tAND w.Mehrkampfcode = d.Code \r\n\tAND w.Mehrkampfcode > 0\r\n\tAND ka.xKategorie = a.xKategorie \r\n AND st.anwesend = 0 \t\r\n\tORDER BY \t \r\n\t\tk.Anzeige\r\n\t\t, w.Mehrkampfcode\r\n\t\t, ka.Alterslimite DESC\r\n");
/*
$results= mysql_query("SELECT
a.xAnmeldung
, at.Name
, at.Vorname
, at.Jahrgang
, k.Name
, IF(a.Vereinsinfo = '', v.Name, a.Vereinsinfo)
, IF(at.xRegion = 0, at.Land, re.Anzeige)
, w.Mehrkampfcode
, d.Name
, w.xKategorie
, ka.Code
, ka.Name
, ka.Alterslimite
FROM
anmeldung AS a
LEFT JOIN athlet AS at USING (xAthlet)
LEFT JOIN verein AS v USING (xVerein)
LEFT JOIN kategorie AS k ON (w.xKategorie = k.xKategorie)
LEFT JOIN kategorie AS ka ON (ka.xKategorie = a.xKategorie)
LEFT JOIN start as st ON (st.xAnmeldung = a.xAnmeldung)
LEFT JOIN wettkampf as w On (w.xWettkampf = st.xWettkampf)
LEFT JOIN disziplin as d ON (w.Mehrkampfcode = d.Code)
LEFT JOIN region as re ON at.xRegion = re.xRegion
WHERE a.xMeeting = " . $_COOKIE['meeting_id'] ."
" . $contestcat . "
AND w.Mehrkampfcode > 0
GROUP BY
a.xAnmeldung
ORDER BY
w.xKategorie
, w.Mehrkampfcode
, ka.Alterslimite DESC
");
*/
if (mysql_errno() > 0) {
// DB error
AA_printErrorMsg(mysql_errno() . ": " . mysql_error());
} else {
$cat = '';
$catEntry = '';
$catEntryLimit = "";
$u23name = "";
$comb = 0;
// hold combined type
$combName = "";
$lastTime = "";
// hold start time of last event for print list
$a = 0;
$info = '';
$points = 0;
$sep = '';
$rFrom = 0;
$rTo = 0;
$limitRank = false;
if ($_GET['limitRank'] == "yes" && substr($formaction, 0, 6) == "export") {
// check if ranks are limited
if (!empty($_GET['limitRankFrom']) && !empty($_GET['limitRankTo'])) {
$limitRank = true;
$rFrom = $_GET['limitRankFrom'];
$rTo = $_GET['limitRankTo'];
}
}
// start a new HTML display page
//.........这里部分代码省略.........