InigoValentin/www/rss.php

<?php
    header('Content-type: application/xml');
    session_start();
    $http_host = $_SERVER["HTTP_HOST"];
    $doc_root = $_SERVER["DOCUMENT_ROOT"] . "/";
    include $doc_root . "functions.php";
    $proto = get_protocol();
    $con = start_db();
    $server = $proto . $http_host;
    $lang = select_language($con);
    $lserver = $server . "/" . $lang;
    $cur_section = "";
    $cur_entry = "";
    ob_clean();
    echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
    <channel>
        <title>Iñigo Valentin</title>
        <link><?=$lserver?></link>
        <atom:link href="<?=$lserver?>/rss.xml" rel="self" type="application/rss+xml" />
        <description>TODO 3D art</description>
        <category>TODO cgi</category>
        <image>
            <url><?=$lserver?>/img/logo/cover.png</url>
            <title>Iñigo Valentin</title>
            <link><?=$lserver?></link>
            <width>140</width>
            <height>140</height>
        </image>
        <language><?=$lang?></language>
<?php
            $res_date = mysqli_query($con, "(SELECT DATE_FORMAT(dtime, '%a, %d %b %Y %H:%i:%s +0100') AS cdate FROM project_version) UNION (SELECT DATE_FORMAT(dtime, '%a, %d %b %Y %H:%i:%s +0100') AS cdate FROM post) ORDER BY cdate DESC LIMIT 1;");
            $row_date = mysqli_fetch_array($res_date);
?>
            <pubDate><?=$row_date["cdate"]?></pubDate>
<?php
            $res = mysqli_query($con, "(SELECT 'PROJECT_TITLE' AS type, id, permalink, dtime, DATE_FORMAT(dtime, '%a, %d %b %Y %H:%i:%s +0100') AS cdate, title, text, logo AS image FROM project, project_version WHERE project = project.id) UNION (SELECT 'BLOG_TITLE' AS type, post.id AS id, permalink, dtime, DATE_FORMAT(dtime, '%a, %d %b %Y %H:%i:%s +0100') AS cdate, title, text, image FROM post, post_image WHERE post = post.id) ORDER BY dtime DESC;");
            while ($row = mysqli_fetch_array($res)){
?>
                <item>
                    <title><?=text($con, $row["title"], $lang)?></title>
                    <category><?=text($con, $row["type"], $lang)?></category>
<?php
                    $text = html_entity_decode(text($con, $row["text"], $lang));
                    switch ($row["type"]){
                    case "PROJECT_TITLE":
?>
                        <description>
                            <![CDATA[
                                <img src='<?=$lserver?>/img/project/x5/<?=$row["image"]?>' height='160' width='160' />
                                <?=$text?>
                            ]]>
                        </description>
                        <link><?=$lserver?>/project/<?=$row["permalink"]?></link>
                        <guid><?=$lserver?>/project/<?=$row["permalink"]?></guid>
<?php
                        break;
                    case 'Blog':
?>
                        <description>
                            <![CDATA[
<?php
                                if ($row['image'] != null){
?>
                                    <img src='<?=$lserver?>/img/blog/x8/$row[image]' height='224' width='224' />
<?php
                                }
?>
                                <?=$text?>
                            ]]>
                        </description>
                        <link><?=$lserver?>/blog/<?=$row["permalink"]?></link>
                        <guid><?=$lserver?>/blog/<?=$row["permalink"]?></guid>
<?php
                        break;
                    }
?>
                    <pubDate><?=$row["cdate"]?></pubDate>
                </item>
<?php
            }
            mysqli_close($con);
?>
    </channel>
</rss>