if ($sortOrder == "") {
$sortOrder = "CountryCode";
}
$page_num = $_REQUEST["page_num"] + 0;
if ($page_num == 0) {
$page_num = 1;
}
if ($cat == 0) {
$where_clause = "";
} else {
$where_clause = " AND cat={$cat} ";
}
$queryExtraArray = array();
$legend = _MENU_TAKEOFFS;
// SEASON MOD
$where_clause .= dates::makeWhereClause(0, $season, $year, $month, 0);
// BRANDS MOD
$where_clause .= brands::makeWhereClause($brandID);
// take care of exluding flights
// 1-> first bit -> means flight will not be counted anywhere!!!
$bitMask = 1 & ~($includeMask & 0x1);
$where_clause .= " AND ( excludeFrom & {$bitMask} ) = 0 ";
if ($pilotID != 0) {
$where_clause .= " AND userID='" . $pilotID . "' AND userServerID={$serverID} ";
} else {
// 0 means all flights BUT not test ones
$where_clause .= " AND userID>0 ";
}
if ($country) {
$where_clause_country .= " AND " . $waypointsTable . ".countryCode='" . $country . "' ";
//$legend.=" (".$countries[$country].") | ";
$page_num = $_REQUEST["page_num"] + 0;
if ($page_num == 0) {
$page_num = 1;
}
if ($cat == 0) {
$where_clause = "";
} else {
$where_clause = " AND cat={$cat} ";
}
$queryExtraArray = array();
$legend = "";
$legend = "<b>" . _MENU_FLIGHTS . "</b> ";
// SEASON MOD
if (!$clubID) {
// if we are viewing a club, the dates will be taken care wit hthe CLUB code
$where_clause .= dates::makeWhereClause(0, $season, $year, $month, $CONF_use_calendar ? $day : 0);
}
// BRANDS MOD
$where_clause .= brands::makeWhereClause($brandID);
// take care of exluding flights
// 1-> first bit -> means flight will not be counted anywhere!!!
$bitMask = 1 & ~($includeMask & 0x1);
$where_clause .= " AND ( excludeFrom & {$bitMask} ) = 0 ";
if ($pilotID != 0) {
$where_clause .= " AND userID='" . $pilotID . "' AND userServerID={$serverID} ";
} else {
// 0 means all flights BUT not test ones
$where_clause .= " AND userID>0 ";
}
if ($takeoffID) {
$where_clause .= " AND takeoffID='" . $takeoffID . "' ";
if ( $clubsList[$clubID]['useCustomSeasons'] ) {
$CONF['seasons']=$clubsList[$clubID]['seasons'];
}
//if ( $clubsList[$clubID]['useCustomYears'] ) {
// $CONF['years']=$clubsList[$clubID]['years'];
//}
# Martin Jursa 23.05.2007: support for NacClub Filtering
if (!empty($CONF_use_NAC)) {
if ($nacid && $nacclubid) {
$where_clause.=" AND $flightsTable.NACid=$nacid AND $flightsTable.NACclubID=$nacclubid";
}
}
// SEASON MOD
list($dates_where_clause,$dates_legend) = dates::makeWhereClause(0,$season,$year,$month,0 , 1);
if (!$clubID) {
$where_clause.=$dates_where_clause;
}
$legend.=$dates_legend;
// BRANDS MOD
$where_clause.= brands::makeWhereClause($brandID);
// take care of exluding flights
// 1-> first bit -> means flight will not be counted anywhere!!!
$bitMask=2 & ~( $includeMask & 0x03 );
$where_clause.= " AND ( excludeFrom & $bitMask ) = 0 ";
//----------------------------------------------------------
