本文整理汇总了PHP中AA_connectToDB函数的典型用法代码示例。如果您正苦于以下问题：PHP AA_connectToDB函数的具体用法？PHP AA_connectToDB怎么用？PHP AA_connectToDB使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了AA_connectToDB函数的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: setPrint
<?php
/**********
*
* 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'
开发者ID:laiello，项目名称:athletica，代码行数:31，代码来源:meeting_entries_print.php
示例2: 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 . ' ';
//.........这里部分代码省略.........
开发者ID:laiello，项目名称:athletica，代码行数:101，代码来源:rankinglist_single.lib.php
示例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]);
//.........这里部分代码省略.........
开发者ID:laiello，项目名称:athletica，代码行数:101，代码来源:rankinglist_team.lib.php
示例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") {
//.........这里部分代码省略.........
开发者ID:laiello，项目名称:athletica，代码行数:101，代码来源:rankinglist_combined.lib.php
示例5: 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();
}
开发者ID:laiello，项目名称:athletica，代码行数:72，代码来源:rankinglist_teamsm.lib.php
示例6: 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) {
//.........这里部分代码省略.........
开发者ID:laiello，项目名称:athletica，代码行数:101，代码来源:rankinglist_single.lib.php
示例7: 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
}
开发者ID:laiello，项目名称:athletica，代码行数:99，代码来源:rankinglist_sheets.lib.php
示例8: 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
//.........这里部分代码省略.........
开发者ID:laiello，项目名称:athletica，代码行数:101，代码来源:rankinglist_combined.lib.php
注：本文中的AA_connectToDB函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论