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 "; //----------------------------------------------------------