GMWeb/www/sitemap.php

<?php
    header('Content-type: application/xml');
    $http_host = $_SERVER['HTTP_HOST'];
    include("functions.php");
    $con = startdb();
    $proto = getProtocol();
    echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
?>
<urlset
    xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
    xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">
    <url>
        <loc><?php echo $proto$http_host; ?>/</loc>
        <?php
            $res_date = mysqli_query($con, "(SELECT DATE_FORMAT(dtime, '%Y-%m-%d') AS cdate FROM post) UNION (SELECT DATE_FORMAT(dtime, '%Y-%m-%d') AS cdate FROM activity) UNION (SELECT DATE_FORMAT(uploaded, '%Y-%m-%d') AS cdate FROM photo) ORDER BY cdate DESC LIMIT 1;");
            $row_date = mysqli_fetch_array($res_date);
        ?><lastmod><?php echo $row_date['cdate']; ?></lastmod>
        <changefreq>weekly</changefreq>
        <priority>0.8</priority>
        <image:image>
            <image:loc><?php echo $proto$http_host; ?>/img/logo/GasteizkoMargolariak.png</image:loc>
            <image:caption>Gasteizko Margolariak</image:caption>
            <image:title>Gasteizko Margolariak</image:title>
        </image:image>
        <image:image>
            <image:loc><?php echo $proto$http_host; ?>/img/logo/GasteizkoMargolariak-0.png</image:loc>
            <image:caption>Gasteizko Margolariak Original</image:caption>
            <image:title>Gasteizko Margolariak Original</image:title>
        </image:image>
    </url>
    <url>
        <loc><?php echo $proto$http_host; ?>/ayuda/</loc>
        <changefreq>monthly</changefreq>
        <priority>0.5</priority>
    </url>
    <url>
        <loc><?php echo $proto$http_host; ?>/nosotros/</loc>
        <changefreq>monthly</changefreq>
        <priority>0.6</priority>
    </url>
    <url>
        <loc><?php echo $proto$http_host; ?>/blog/</loc>
        <?php
            $res_date = mysqli_query($con, "SELECT DATE_FORMAT(dtime, '%Y-%m-%d') AS cdate FROM post ORDER BY cdate DESC LIMIT 1;");
            $row_date = mysqli_fetch_array($res_date);
        ?><lastmod><?php echo $row_date['cdate']; ?></lastmod>
        <changefreq>weekly</changefreq>
        <priority>0.8</priority>
    </url>
    <?php
        $res_post = mysqli_query($con, "SELECT id, title_es, permalink, DATE_FORMAT(dtime, '%Y-%m-%d') AS cdate FROM post WHERE visible = 1 ORDER BY cdate DESC;");
        $priority = 0.75;
        while ($row_post = mysqli_fetch_array($res_post)){
            echo "\t<url>\n";
            echo "\t\t<loc>$proto$http_host/blog/$row_post[permalink]</loc>\n";
            echo "\t\t<lastmod>$row_post[cdate]</lastmod>\n";
            echo "\t\t<changefreq>weekly</changefreq>\n";
            echo "\t\t<priority>$priority</priority>\n";
            $q_i = mysqli_query($con, "SELECT image FROM post_image WHERE post = $row_post[id] ORDER BY idx;");
            while ($r_i = mysqli_fetch_array($q_i)){
                echo("\t\t<image:image>\n");
                echo("\t\t\t<image:loc>$proto$http_host/img/blog/view/$r_i[image]</image:loc>\n");
                echo("\t\t\t<image:title>$row_post[title_es]</image:title>\n");
                echo("\t\t</image:image>\n");
            } 
            echo "\t</url>\n";
            $priority = $priority - 0.05;
            if ($priority < 0.45)
                $priority = 0.45;
        }
    ?>
    <url>
        <loc><?php echo $proto$http_host; ?>/actividades/</loc>
        <?php
            $res_date = mysqli_query($con, "SELECT DATE_FORMAT(dtime, '%Y-%m-%d') AS cdate FROM activity ORDER BY cdate DESC LIMIT 1;");
            $row_date = mysqli_fetch_array($res_date);
        ?><lastmod><?php echo $row_date['cdate']; ?></lastmod>
        <changefreq>weekly</changefreq>
        <priority>1</priority>
    </url>
    <?php
        $res = mysqli_query($con, "SELECT title_es, id, permalink, DATE_FORMAT(dtime, '%Y-%m-%d') AS cdate FROM activity WHERE visible = 1 ORDER BY cdate DESC;");
        $priority = 0.95;
        while ($row = mysqli_fetch_array($res)){
            echo "\t<url>\n";
            echo "\t\t<loc>$proto$http_host/actividades/$row[permalink]</loc>\n";
            echo "\t\t<lastmod>$row[cdate]</lastmod>\n";
            echo "\t\t<changefreq>weekly</changefreq>\n";
            echo "\t\t<priority>$priority</priority>\n";
            $q_i = mysqli_query($con, "SELECT image FROM activity_image WHERE activity = $row[id] ORDER BY idx;");
            while ($r_i = mysqli_fetch_array($q_i)){
                echo("\t\t<image:image>\n");
                echo("\t\t\t<image:loc>$proto$http_host/img/actividades/view/$r_i[image]</image:loc>\n");
                echo("\t\t\t<image:title>$row[title_es]</image:title>\n");
                echo("\t\t</image:image>\n");
            } 
            echo "\t</url>\n";
            $priority = $priority - 0.05;
            if ($priority < 0.65)
                $priority = 0.65;
        }
    ?>
    <url>
        <loc><?php echo $proto$http_host; ?>/galeria/</loc>
        <?php
            $res_date = mysqli_query($con, "SELECT DATE_FORMAT(uploaded, '%Y-%m-%d') AS cdate FROM photo ORDER BY cdate DESC LIMIT 1;");
            $row_date = mysqli_fetch_array($res_date);
        ?><lastmod><?php echo $row_date['cdate']; ?></lastmod>
        <changefreq>weekly</changefreq>
        <priority>0.8</priority>
    </url>
    <?php
        $res = mysqli_query($con, "SELECT DISTINCT album.id AS albumid, album.title_es AS title, album.permalink AS permalink, DATE_FORMAT(uploaded, '%Y-%m-%d') AS cdate FROM photo, album, photo_album WHERE photo = photo.id AND album = album.id ORDER BY cdate DESC;");
        $priority = 0.75;
        while ($row = mysqli_fetch_array($res)){
            echo "\t<url>\n";
            echo "\t\t<loc>$proto$http_host/galeria/$row[permalink]</loc>\n";
            echo "\t\t<lastmod>$row[cdate]</lastmod>\n";
            echo "\t\t<changefreq>weekly</changefreq>\n";
            echo "\t\t<priority>$priority</priority>\n";
            $q_i = mysqli_query($con, "SELECT file, title_es FROM photo, photo_album WHERE id = photo AND album = $row[albumid];");
            while ($r_i = mysqli_fetch_array($q_i)){
                echo("\t\t<image:image>\n");
                echo("\t\t\t<image:loc>$proto$http_host/img/galeria/view/$r_i[file]</image:loc>\n");
                if (strlen($r_i['title_es']) > 0){
                    echo("\t\t\t<image:title>$r_i[title_es]</image:title>\n");
                }
                else{
                    echo("\t\t\t<image:title>$row[title]</image:title>\n");
                }
                echo("\t\t</image:image>\n");
            } 
            echo "\t</url>\n";
            $priority = $priority - 0.05;
            if ($priority < 0.45)
                $priority = 0.45;
        }
    ?>
    <url>
        <loc><?php echo $proto$http_host; ?>/lablanca/</loc>
        <?php
            $res_lb = mysqli_query($con, 'SELECT value FROM settings WHERE name= "festivals";');
            if (mysqli_num_rows($res_lb) > 0){
                $r_lb = mysqli_fetch_array($res_lb);
                if ($r_lb['value'] == 1){
                    echo "<changefreq>daily</changefreq>\n";
                    echo "\t\t<priority>1</priority>\n";
                }
                else{
                    echo "<changefreq>monthly</changefreq>\n";
                    echo "\t\t<priority>0.5</priority>\n";
                }
            }
            else{
                echo "<changefreq>monthly</changefreq>\n";
                echo "\t\t<priority>0.5</priority>\n";
            }
        ?>
    </url>
    <?php
        $year = date("Y");
        $res_years = mysqli_query($con, "SELECT img, year FROM festival ORDER BY year DESC;");
        $priority = 0.55;
        while ($row_years = mysqli_fetch_array($res_years)){
            echo "\t<url>\n";
            echo "\t\t<loc>$proto$http_host/lablanca/$row_years[year]</loc>\n";
            echo "\t\t<changefreq>yearly</changefreq>\n";
            echo "\t\t<priority>$priority</priority>\n";
            if (strlen($row_years['img']) > 0){
                echo("\t\t<image:image>\n");
                echo("\t\t\t<image:loc>$proto$http_host/img/fiestas/view/$row_years[img]</image:loc>\n");
                echo("\t\t\t<image:title>La Blanca $row_years[year]</image:title>\n");
                echo("\t\t</image:image>\n");
            }
            echo "\t</url>\n";
            $priority = $priority - 0.05;
            if ($priority < 0.40)
                $priority = 0.40;
        }
    ?>
</urlset>