}
switch ($feed_type) {
case "calendar.ics":
case "ics":
require_once "Entrada/icalendar/class.ical.inc.php";
$query = "\tSELECT a.*, CONCAT_WS(' ', b.`firstname`, b.`lastname`) AS `fullname`, b.`email`, c.*, d.`community_title`\n\t\t\t\t\t\t\tFROM `community_events` AS a\n\t\t\t\t\t\t\tLEFT JOIN `" . AUTH_DATABASE . "`.`user_data` AS b\n\t\t\t\t\t\t\tON b.`id` = a.`proxy_id`\n\t\t\t\t\t\t\tLEFT JOIN `community_pages` AS c\n\t\t\t\t\t\t\tON c.`cpage_id` = a.`cpage_id`\n\t\t\t\t\t\t\tLEFT JOIN `communities` AS d\n\t\t\t\t\t\t\tON a.`community_id` = d.`community_id`\n\t\t\t\t\t\t\tWHERE c.`cpage_id` = " . $db->qstr($page_record["cpage_id"]) . "\n\t\t\t\t\t\t\tAND a.`event_active` = '1'\n\t\t\t\t\t\t\tAND c.`page_active` = '1'\n\t\t\t\t\t\t\tORDER BY a.`event_start` ASC";
$results = $db->GetAll($query);
if ($results) {
$community_title = $results[0]["community_title"];
$ical = new iCal("-//" . html_encode($_SERVER["HTTP_HOST"]) . "//iCal Learning Events Calendar MIMEDIR//EN", 1, ENTRADA_ABSOLUTE . "/community/feeds" . $community_url . ":" . $page_url . "/ics", str_replace(array("/", " ", "_"), "-", $community_title . "->" . $page_record["menu_title"]));
// (ProgrammID, Method (1 = Publish | 0 = Request), Download Directory)
foreach ($results as $result) {
$ical->addEvent(array($result["fullname"] != "" ? $result["fullname"] : "", $result["email"] ? $result["email"] : ""), (int) $result["event_start"], (int) $result["event_finish"], $result["event_location"], 1, array($result["community_title"]), strip_tags(str_replace("<br />", " ", $result["event_description"])), strip_tags($result["event_title"]), 1, array(), 5, 0, 0, 0, array(), date("w", (int) $result["event_start"]), "", 0, 1, str_replace("http://", "https://", COMMUNITY_URL) . $page_record["community_url"] . ":" . $page_record["page_url"] . "?id=" . (int) $result["cevent_id"], "en", "");
}
if (!isset($ical->output)) {
$ical->generateOutput();
}
header("Content-Disposition: inline; filename=\"" . str_replace(array("/", " ", "_"), "-", $page_record["menu_title"]) . ".ics\"");
header("Content-Type: text/calendar");
echo $ical->output;
}
break;
case "rss":
case "rss10":
case "rss20":
default:
$query = "\tSELECT a.*, CONCAT_WS(' ', b.`firstname`, b.`lastname`) as `author_name`, b.`email`\n\t\t\t\t\t\tFROM `community_history` AS a\n\t\t\t\t\t\tLEFT JOIN `" . AUTH_DATABASE . "`.`user_data` AS b\n\t\t\t\t\t\tON b.`id` = a.`proxy_id`\n\t\t\t\t\t\tWHERE a.`community_id` = " . $db->qstr($community_id) . "\n\t\t\t\t\t\tAND a.`history_display` = '1'\n\t\t\t\t\t\tORDER BY a.`history_timestamp` DESC\n\t\t\t\t\t\tLIMIT 0, 30";
$results = $db->GetAll($query);
if ($results) {
foreach ($results as $result) {
$rss_output[$result["chistory_id"]] = $result;
