<styleUrl>#marker_cat_' . $tmpcat . '_n</styleUrl>
</Pair>
<Pair>
<key>highlight</key>
<styleUrl>#marker_cat_' . $tmpcat . '_h</styleUrl>
</Pair>
</StyleMap>
';
}
// add filter clauses
$fltr = $_GET['fltr'];
$filter_clause = '';
if ($fltr) {
require_once dirname(__FILE__) . '/CL_filter.php';
$filter = new LeonardoFilter();
$filter->parseFilterString($fltr);
// echo "<PRE>"; print_r($filter->filterArray); echo "</PRE>";
$filter_clause = $filter->makeClause();
if (!strpos($filter_clause, $waypointsTable) === false) {
$extra_tbl = " LEFT JOIN {$waypointsTable} ON {$flightsTable}.takeoffID={$waypointsTable}.ID ";
}
if (!strpos($filter_clause, $pilotsTable) === false) {
$extra_tbl .= " LEFT JOIN {$pilotsTable} ON \n\t\t\t\t\t\t({$flightsTable}.userID={$pilotsTable}.pilotID AND \n\t\t\t\t\t\t{$flightsTable}.userServerID={$pilotsTable}.serverID) ";
}
}
$query = "SELECT * FROM {$flightsTable} {$extra_tbl} WHERE \n\t\t\t\t firstLat>={$south} && firstLat<={$north} && \n\t\t\t\t firstLon>={$west} && firstLon<={$east} {$filter_clause}\n\t\t\t\t ORDER BY FLIGHT_POINTS DESC LIMIT 100 ";
//echo $query;
$res = $db->sql_query($query);
if ($res <= 0) {
echo "<H3> Error in query! {$query} </H3>\n";
exit;
- Extend Filter with checkbox category for Hanggliders with Kingposts.
- Extend Filter page with Pilot Birthdate.
- Extend Filter page for Start type: foot, winch, microlight tow or e-motor (is to be included on GUI_flight_submit.php)
Integrate RSS Feed in Filterpage, to generate Feeds according to filter settings.
Ensure Filter bookmarks function correctly (check seasons mod).
Ensure Filter settings function correctly on all scoring lists.
*/
$filterOps = array(0x20 => array("FILTER_DATE"), 0x22 => array("FILTER_PilotBirthdate"), 0x40 => array("FILTER_pilots_incl", 'pilot', 'userID'), 0x41 => array("FILTER_countries_incl", 'country', $waypointsTable . '.countryCode'), 0x42 => array("FILTER_takeoffs_incl", 'takeoff', 'takeoffID'), 0x43 => array("FILTER_nationality_incl", 'nationality', $pilotsTable . '.countryCode'), 0x44 => array("FILTER_server_incl", 'server', $flightsTable . '.serverID'), 0x45 => array("FILTER_nacclubs_incl", 'nacclub', $flightsTable . '.NACclubID'), 0x60 => array("FILTER_sex"), 0x61 => array("FILTER_cat"), 0x62 => array("FILTER_class"), 0x63 => array("FILTER_olc_type"), 0x64 => array("FILTER_glider_cert"), 0x65 => array("FILTER_start_type"), 0x66 => array("FILTER_WEEKEND"), 0x80 => array("FILTER_linear_distance"), 0x81 => array("FILTER_olc_distance"), 0x82 => array("FILTER_olc_score"), 0x83 => array("FILTER_duration"));
if (0) {
//echo leonardoFilter::getShort("10004",0);
$filter = new LeonardoFilter();
$filterString = $_GET['f'];
if (!$filterString) {
$filterString = "80000260000820C100A64100A741gr_de_us_fr.402466_4672_17282_13461." . "45101_234_235_271.";
}
$filter->parseFilterString($filterString);
echo "<PRE>";
print_r($filter->filterArray);
echo "</PRE>";
echo $filter->makeClause();
echo "<HR>" . $filterString . "<HR>" . $filter->makeFilterString();
}
class leonardoFilter
{
var $filterArray = array();
var $filterTextual = "";
function leonardoFilter()
{
}
function getByte($filterStr, $start)
{
