static function get_events()
{
$events = array();
require dirname(__FILE__) . '/settings.php';
$db = mysql_connect($db_host, $db_user, $db_password);
//connect to database
mysql_select_db($db_name, $db);
$result = mysql_query("SELECT * FROM events WHERE dtstart > " . time() . " OR rrule > 0 ORDER BY dtstart ASC, event_id DESC", $db) or die(mysql_error());
while ($event = mysql_fetch_assoc($result)) {
$obj = new Event($event);
if ($obj->repeats()) {
$obj->save();
}
$events[] = $obj;
}
//end while event
mysql_close($db);
return $events;
}
