selectDB('calendar'); $query = "SELECT events.id, events.name, activities.all_day, activities.start_date_time, activities.end_date_time, activities.event_id FROM `events`,`authorized`,`activities` WHERE authorized.calendar_id = 21 AND events.id = authorized.event_id AND events.id = activities.event_id ORDER BY activities.start_date_time ASC"; $entries = $sqlManager->getResults($query); // Archive Script of Death $years = array(); $first = true; $first_day = true; echo '

'; foreach($entries as $entry){ $unix_time_start = strtotime($entry['start_date_time']); $unix_time_end = strtotime($entry['end_date_time']); // YEARS if (!in_array(date('Y', $unix_time_start), $years)){ if(!$first){ echo ''; } echo '

' . date('Y', $unix_time_start) . '

'; $years[] = date('Y', $unix_time_start); $months = array(); } // MONTHS if(!in_array(date('F', $unix_time_start), $months)){ if(count($months) > 0){ echo '

'; } echo '

' . date('F', $unix_time_start) . '

'; echo '
'; if ($unix_time_start != $unix_time_end){ echo date('j',$unix_time_start) . ':'; } else{ echo date('j',$unix_time_start) . '-' . date('j',$unix_time_end) . ':'; } echo '
'; echo '
'; echo '' . $title . ''; echo '
'; echo '
'; $days[] = $entry['event_id']; } $first = false; } echo '

'; ?>