All LEI Fixtures


Download a PDF listing all proposed events for the next few years.


Show LEI Orienteering fixtures only


“;
print $form_block1;
?>

Show All events


“;
print $form_block2;
?>

Show Activities only


“;
print $form_block3;
?>

Show Meetings only


“;
print $form_block4;
?>

= \”$today\” OR event_date_2 >= \”$today\” ORDER BY event_date ASC, event_id ASC”;

$result = @mysqli_query($connection, $sql)or die(mysqli_error($connection));

while ($row = mysqli_fetch_array($result)) {
$event_id = $row[‘event_id’];
$event_flag = $row[‘event_flag’];
$day = $row[‘day’];
$month = $row[‘month’];
$date = $row[‘date’];
$year = $row[‘year’];
$day_2 = $row[‘day_2’];
$month_2 = $row[‘month_2’];
$date_2 = $row[‘date_2’];
if ($date_2 == 0) {
$date_2 = “”;
}
$year_2 = $row[‘year_2’];
if ($year_2 == 0) {
$year_2 = “”;
}
if (isset($day_2)) {
$day_2 = ” – ” . $day_2;
}
$event_title = $row[‘event_title’];
$event_category = $row[‘v_category’];
$event_type = $row[‘v_type’];
$event_details_link = $row[‘event_details_link’];

$lei = isset($_POST[‘lei’]) ? $_POST[‘lei’] : ”;
$all = isset($_POST[‘all’]) ? $_POST[‘all’] : ”;
$activity = isset($_POST[‘activity’]) ? $_POST[‘activity’] : ”;
$meeting = isset($_POST[‘meeting’]) ? $_POST[‘meeting’] : ”;

// $lei = $_POST[‘lei’];
// $all = $_POST[‘all’];
// $activity = $_POST[‘activity’];
// $meeting = $_POST[‘meeting’];

// echo “Day_2 = ” . $day_2 . ” – ” . “Month_2 = ” . $month_2 . ” – ” . “Date_2 = ” . $date_2 . ” – ” . “Year_2 = ” . $year_2 . ” – ” . “
“;

// echo “lei = ” . $lei . ” all = ” . $all . ” activity = ” . $activity . ” meeting = ” . $meeting . “
“;
if (($lei != “yes”) && ($all != “yes”) && ($activity != “yes”) && ($meeting != “yes”)) {
$first_pass = “yes”;
}
else {
$first_pass = “no”;
}
//echo $first_pass . “
“;

if ($year > $new_year) {
$new_year = $year;
$display_block .= ”

“;
}

if ((($event_flag == “y”) || ($event_flag == “Y”)) && (($lei == “yes”) || ($all == “yes”) || ($first_pass == “yes”))) {
$display_block .= ”

“;
}
if (($event_flag == “n”) && (($all == “yes”) || ($first_pass == “yes”))) {
$display_block .= ”

“;
}
if ((($event_flag == “a”) || ($event_flag == “A”)) && (($activity == “yes”) || ($all == “yes”) || ($first_pass == “yes”))) {
$display_block .= ”

“;
}
if (($event_flag == “m”) && (($meeting == “yes”) || ($all == “yes”) || ($first_pass == “yes”))) {
$display_block .= ”

“;
}
else if ($event_flag == “x”) {
$display_block .= ”

“;
}
}
echo $display_block;

?>

$new_year

$day $date $month $day_2 $date_2 $month_2 $event_title Details
    $event_title Details
$day $date $month $day_2 $date_2 $month_2 $event_title Details
$day $date $month $day_2 $date_2 $month_2 $event_title Details
    $event_title