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[3]); $unix_time_end = strtotime($entry[4]); // 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 '
'; echo date('j',$unix_time_start) . '-' . date('j',$unix_time_end) . ':'; echo '
'; if (strlen($entry[1]) >= 60){ $title = substr($entry[1],0,60) . '...'; } else{ $title = $entry[1]; } echo '
'; echo '' . $title . ''; echo '
'; echo '
'; $days[] = $entry[5]; } else{ echo date('j',$unix_time_start) . '-' . date('j',$unix_time_end) . ':'; $days[] = $entry[5]; } $first = false; $first_day = false; } echo '

'; ?>