Please refer to the official MYSL Open House Rules HERE

get_var($wpdb->prepare(“select count(*) from wp_mysl_event_submissions where myslApproved = %d and (dateToRemove is NULL OR dateToRemove >= %s)”,
1, date(‘Y-m-d’)
)
);

$totalPages = ceil((float)$totalCount / 2.0) ;

if(isset($_GET[displayPage]))
{
$pageToDisplay = ((int)$_GET[displayPage]);

$queryWith = ($pageToDisplay*2)-2;
}
else
{
$pageToDisplay = 1;
$queryWith = 0;
}

$query = $wpdb->prepare(“select * from wp_mysl_event_submissions where myslApproved = %d and (dateToRemove is NULL OR dateToRemove >= %s) order by id limit %d,%d”,
1, date(‘Y-m-d’), $queryWith,2
);

$queryResults = $wpdb->get_results( $query);

?>

1)
{
?>


1)
{
?>


Previous Page“);
}

$i = 1;

while($i <= $totalPages) { if($i != $pageToDisplay) { echo("...“.$i.”“);
}
else
{
echo(“…”.$i);
}
$i++;
}

if($pageToDisplay == $totalPages)
{
echo(“…Next Page”);
}
else
{
echo(“…Next Page“);
}

?>

Event Information Event Contact Info
clubLeagueName) { ?>

Club League Name: clubLeagueName));?>

AgeGroups) { ?>

Age Group(s): AgeGroups));?>

Genders) { ?>

Gender(s): Genders));?>

eventDatesAndTimes) { ?>

Event Date(s) and Time(s): eventDatesAndTimes));?>

eventLocation) { ?>

Event Location: eventLocation));?>

eventDetails) { ?>

Event Details: eventDetails));?>

No tryouts or registration can take place at this event.

 eventInfoContactName) { ?>

Name: eventInfoContactName));?>

eventInfoContactPhone) { ?>

Phone: eventInfoContactPhone));?>

eventInfoContactEmail) { ?>

Email:
Website:
evenInfoContactWebsite,”http”)===FALSE){echo(“http://”);} ?>eventInfoContactWebsite);?>” >eventInfoContactWebsite);?>

Previous Page“);
}

$i = 1;

while($i <= $totalPages) { if($i != $pageToDisplay) { echo("...“.$i.”“);
}
else
{
echo(“…”.$i);
}
$i++;
}

if($pageToDisplay == $totalPages)
{
echo(“…Next Page”);
}
else
{
echo(“…Next Page“);
}

?>