rss.php

<?php

/*
*  ========================================================================
*  * Open eClass
*  * E-learning and Course Management System
*  * ========================================================================
 *  * Copyright 2003-2024, Greek Universities Network - GUnet
*  *
 *  * Open eClass is an open platform distributed in the hope that it will
*  * be useful (without any warranty), under the terms of the GNU (General
    *  * Public License) as published by the Free Software Foundation.
 *  * The full license can be read in "/info/license/license_gpl.txt".
 *  *
 *  * Contact address: GUnet Asynchronous eLearning Group
*  *                  e-mail: info@openeclass.org
*  * ========================================================================
 *
 */

/*
 * Announcements RSS Feed Component
 */

require_once 'include/init.php';


$result = Database::get()->querySingle("SELECT DATE_FORMAT(`date`,'%a, %d %b %Y %T +0300') AS dateformat
    FROM admin_announcement
    WHERE visible = 1 AND lang = ?s
    ORDER BY `date` DESC", $language);


if ($result) {
    $lastbuilddate = $result->dateformat;
} else {
    $lastbuilddate = '';
}

header("Content-Type: application/xml;");
echo "<?xml version='1.0' encoding='utf-8'?>";
echo "<rss version='2.0' xmlns:atom='http://www.w3.org/2005/Atom'>";
echo "<channel>";
echo "<atom:link href='{$urlServer}rss.php' rel='self' type='application/rss+xml' />";
echo "<title>$langAnnouncements $siteName</title>";
echo "<link>" . $urlServer . "rss.php?lang=$language</link>";
echo "<description>$langAnnouncements</description>";
echo "<lastBuildDate>$lastbuilddate</lastBuildDate>";
echo "<language>" . $language . "</language>";


$sql = Database::get()->queryArray("SELECT id, title, body, DATE_FORMAT(`date`,'%a, %d %b %Y %T +0300') AS dateformat
        FROM admin_announcement
        WHERE visible = 1 AND lang = ?s
        ORDER BY `date` DESC", $language);

if ($sql) {
    foreach ($sql as $r) {
        echo "<item>";
        echo "<title>" . htmlspecialchars($r->title, ENT_NOQUOTES) . "</title>";
        echo "<link>" . $urlServer . "modules/announcements/main_ann.php?aid=" . $r->id . "</link>";
        echo "<description>" . htmlspecialchars($r->body, ENT_NOQUOTES) . "</description>";
        echo "<pubDate>" . $r->dateformat . "</pubDate>";
        echo "<guid isPermaLink='false'>" . $r->dateformat . $r->id . "</guid>";
        echo "</item>";
    }
}
echo "</channel></rss>";