public static function Get($onlyActive = true)
{
global $MySQL;
$query = "SELECT *, DATE(event_date_begin) AS event_date_begin_date, DATE(event_date_end) AS event_date_end_date FROM phpmmo_events";
if ($onlyActive) {
$query .= " WHERE event_date_begin <= NOW() AND event_date_end >= NOW()";
}
$query .= " ORDER BY event_date_begin DESC";
$result = $MySQL->query($query);
$count = $result->num_rows;
$retval = array();
for ($i = 0; $i < $count; $i++) {
$values = $result->fetch_assoc();
$event = Event::GetByAssoc($values);
$retval[] = $event;
}
// return the list of events
return $retval;
}
