<?php

    
    /*******************************************************************
    *
    *        Titre: générateur de sitemap pour Piwigo  
    *        fichier: sitemap.php
    *        Version: beta 0.6b
    *
    *        dev: h2o pour Piwigo
    *
    *        Commentaire: Cette page va generer automatiquement 
    *        un sitemap au format xml utilisé par les moteur de 
    *        recherche comme Google, Yahou etc..
    *
    *        doc: http://www.sitemaps.org/fr
    *
    ********************************************************************/
    
    /********************************************************************
    *   Format XML
    *
    *   <?xml version="1.0" encoding="UTF-8"?>
    *   <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
    *       <url>
    *         <loc>http://www.example.com/</loc>
    *         <lastmod>2005-01-01</lastmod>
    *         <changefreq>monthly</changefreq>
    *         <priority>0.8</priority>
    *     
    *        <image:image>
    *           <image:loc>http://ulr-de-l'image</image:loc>
    *           <image:title>Titre-de-l'image</image:title>
    *           <image:caption>legende-de-l'image</image:caption>
    *           <image:licence>http://url-ver-la-licence</image:licence>
    *         </image:image>    
    *
    *       </url>
    *   </urlset> 
    *
    *********************************************************************/      

//--------------------------------------------------------------------- include
define('PHPWG_ROOT_PATH','./');
include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );

$xml = new googleXml;

/* Variables
------------------------------------*/
// adresse du site Piwigo
$xml->site_url = "http://" . $_SERVER['HTTP_HOST'];
if(dirname($_SERVER['SCRIPT_NAME']) != "/") {$xml->site_url .= dirname($_SERVER['SCRIPT_NAME']); }

$xml->licence_url = "";  // url complete vers votre licence photo, laisser vide si vous n'en avez pas


/* Format des URLs (a adapater en fonction de votre config)
-------------------------------------*/
$xml->str_loc['category'] = '/index/category/%d-%s';
$xml->str_loc['tag'] =      '/index/tags/%d-%s';
$xml->str_loc['picture'] =  '/picture/%d-%s/category/%d-%s';
$xml->str_loc['add_page'] = '/index.php/additional_page/%d';
$xml->str_loc['image']  =   '/upload/%d/%d/%d/%s';   // lien direct vers l'image


/* Fréquence des changements 
   always, hourly, daily, weekly, monthly, yearly, never
--------------------------------------*/
$xml->changefreq['accueil'] =  'monthly'; // la page d'accueil
$xml->changefreq['category'] = 'monthly'; // les pages des catégories
$xml->changefreq['tag'] =      'monthly'; // les pages corespondant à chaque tags
$xml->changefreq['picture'] =  'monthly'; // les pages corespondant à chaques photo
$xml->changefreq['add_page'] = 'monthly'; // les pages additionnels (Si vous utilisez le Plugin Additionnal page)

/* Priorité  
--------------------------------------*/
$xml->priority['accueil'] =  '1';   // la page d'accueil
$xml->priority['category'] = '0.6'; // les pages des catégories
$xml->priority['tag'] =      '0.5'; // les pages corespondant à chaque tags
$xml->priority['picture'] =  '0.5'; // les pages correspondant à une photo
$xml->priority['add_page'] = '0.5'; // les pages additionnels (Si vous utilisez le Plugin Additionnal page)

/* format des blocs XML 
--------------------------------------*/
$xml->str_xml['url'] =           "<url>\r%s</url>\r";
$xml->str_xml['loc'] =           "\t<loc>%s</loc>\r";
$xml->str_xml['lastmod'] =       "\t<lastmod>%s</lastmod>\r";
$xml->str_xml['changefreq'] =    "\t<changefreq>%s</changefreq>\r";
$xml->str_xml['priority'] =      "\t<priority>%s</priority>\r";
$xml->str_xml['image'] =         "\t<image:image>\r%s\t</image:image>\r";
$xml->str_xml['image_loc'] =     "\t\t<image:loc>%s</image:loc>\r";
$xml->str_xml['image_title'] =   "\t\t<image:title>%s</image:title>\r";
$xml->str_xml['image_caption'] = "\t\t<image:caption>%s</image:caption>\r";
$xml->str_xml['image_licence'] = "\t\t<image:licence>%s</image:licence>\r";

/* Ecrit l'Ouverture du fichier XML
-------------------------------------*/

header("Content-Type: text/xml; charset=UTF-8"); 
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
echo "<?xml-stylesheet href=\"autositemap.css\" type=\"text/css\"?>";
echo "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\" xmlns:image=\"http://www.google.com/schemas/sitemap-image/1.1\">\r";

/* Entete
--------------------------------------*/
 

/* Ecrit le lien de la page d'accueil
-------------------------------------*/ 
$xml->make_url('accueil');
$xml->echo_url();


// echo sprintf($xml_url, $site_url, makedate(), $freq['accueil'], '1');


/* Liens vers les pages Catégories
-------------------------------------*/
$temp_link = '';
$query = 'SELECT c.id, c.name, max(h.date) AS lastmod FROM '.CATEGORIES_TABLE. ' c
            LEFT JOIN '.HISTORY_TABLE.' h ON h.category_id = c.id 
            WHERE status = "public"
            GROUP BY c.id
            ';
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result)) {     
    $xml->data = $row;    
    $xml->make_url('category');
    $xml->echo_url();    
  }

/* Liens vers les  pages Tags
------------------------------------*/
$query = 'SELECT t.id, t.name, max(h.date) AS lastmod FROM '.TAGS_TABLE.' t
            LEFT JOIN '.HISTORY_TABLE.' h ON h.tag_ids = t.id
            GROUP BY t.id';
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result)) {    
    $xml->data = $row;   
    $xml->make_url('tag');
    $xml->echo_url();    
  }


/* Liens vers page Pictures
------------------------------------*/
$query = 'SELECT i.id, i.name, i.path, i.comment, c.name as catname, c.id as catid, c.status, max(h.date) AS maxdate 
            FROM '.IMAGES_TABLE.' i  
            LEFT JOIN '.HISTORY_TABLE.' h ON h.image_id = i.id,             
            '.IMAGE_CATEGORY_TABLE.' ic  
            LEFT JOIN '.CATEGORIES_TABLE.' c ON c.id = ic.category_id             
            WHERE i.id = ic.image_id 
            AND c.status = "public"
            GROUP BY i.id';          
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result)) {          
    $xml->data = $row;   
    $xml->make_img('picture');  // fabrique le bloc <image:image>
    $xml->make_url('picture');  // fabrique le bloc <url>
    $xml->echo_url();           // affiche les blocs precedement créé.    
}



/* lien vers page du plugin Additional Page
------------------------------------------*/

if(defined('ADD_PAGES_TABLE') ) {
    $query = 'SELECT id, title AS name FROM '.ADD_PAGES_TABLE ;
    $result = pwg_query($query);
    while ($row = pwg_db_fetch_assoc($result)) {            
        $xml->data = $row;
        $xml->make_loc('add_page');
        $xml->make_url('add_page');
        $xml->echo_url();               
      }
}


/* Fermeture du fichier XML
-------------------------------------*/
echo '</urlset>';



/* class 
-------------------------------------*/

class googleXml {

    var $str_loc = array();
    var $changefreq = array();
    var $str_xml = array();
    var $priority = array();
    var $data = array();
    var $image;       
       
    /* fabrique le bloc <url>...</url> */
    function make_url($type) {              
       $this->url =  sprintf($this->str_xml['loc'], $this->make_loc($type) );
       $this->url .= sprintf($this->str_xml['lastmod'], $this->make_date());
       $this->url .= sprintf($this->str_xml['changefreq'], $this->changefreq[$type]);
       $this->url .= sprintf($this->str_xml['priority'], $this->priority[$type]);
       if($this->image) { $this->url .= $this->image; }
       $this->url = sprintf($this->str_xml['url'], $this->url);            
    }   // fin make_url    
    
    /* fabrique le bloc <image:image>...</image:image> */
    function make_img($type) {       
        if(!empty($this->data['path'])) { 
            $this->image = sprintf($this->str_xml['image_loc'], $this->make_image_loc() );            
            $this->image .= sprintf($this->str_xml['image_title'], $this->html_entity2xml($this->data['name']) );
            if(!empty($this->data['comment'])) { $this->image .= sprintf($this->str_xml['image_caption'], $this->html_entity2xml($this->data['comment']) ); }
            if(!empty($this->licence_url)) { $this->image .= sprintf($this->str_xml['image_licence'], $this->licence_url); }
            $this->image = sprintf($this->str_xml['image'], $this->image);                     
        }         
    }   // fin make_img    
    
    /* fabrique une URL formatée pour <loc>...</loc> */
    function make_loc($type) {
        if($type == 'picture') { return $this->site_url . sprintf($this->str_loc[$type], $this->data['id'], str2url($this->data['name']), $this->data['catid'], str2url($this->data['catname'])   ); }
        if($type == 'accueil') { return $this->site_url; }       
        return $this->site_url . sprintf($this->str_loc[$type], $this->data['id'], str2url($this->data['name']));       
    }
    
    /* fabrique (si besoin) une date pour <lastmod>...</lastmod> */    
    function make_date () {
        if(empty($this->data['lastmod'])){ return date('Y-m-d'); }
        return $this->data['lastmod'];
    }
    
    /* fabrique une URL formatée pour <image:loc>...</image:loc> */ 
    function make_image_loc() {         
        return $this->site_url . substr($this->data['path'], 1);        
    }
    
    /* nettoie et met en forme les phrases pour injection dans le XML */
    function html_entity2xml($string) {               
        $string = utf8_decode($string);
        $string = strip_tags($string);         
        $string = html_entity_decode($string, ENT_QUOTES);
        $trouve = array("&lsquo;", "&rsquo;");
        $replace = array("'", "'");
        $string = str_replace($trouve, $replace, $string);
        $string = utf8_encode($string);
        return $string;                
    }        
    
    /* envois le bloc <url>...</url> à l'affichage */
    function echo_url() {
        echo $this->url;
        $this->data = array();  // on vide la variable
    }     

} // fin de la class

?>

    /**************************************************
    *     CSS pour autositemap   
    *     Version 0.3
    *
    *   <urlset>
    *       <url>
    *         <loc>http://www.example.com/</loc>
    *         <lastmod>2005-01-01</lastmod>
    *         <changefreq>monthly</changefreq>
    *         <priority>0.8</priority>
    *         <image:image>
    *           <image:loc>http://ulr-de-l'image</image:loc>
    *           <image:title>Titre-de-l'image</image:title>
    *           <image:caption>legende-de-l'image</image:caption>
    *           <image:licence>http://url-ver-la-licence</image:licence>
    *         </image:image>      
    *       </url>    
    *   </urlset> 
    **************************************************/

urlset {
    background: transparent url(autositemap.jpg) no-repeat center fixed; 
    
}

url {   
    margin: 1em;
    display: block;
    border-bottom: 1px solid lightgrey;      
}


loc {    
    display: block;
    margin-left: .5em;
    font-weight: bold;    
}
lastmod, changefreq, priority {
    margin-left: 1em;    
}
changefreq {
    font-style: italic; 
}
priority {
    border: 1px solid lightgrey;    
    padding: .1px;
}

image>loc {
    padding-left: 2em;
    color: green;   
}

image>title {
    padding-left: 2em;
}

image>caption {
    padding-left: 2em;
    font-style: italic;
}