<?php
# Fichier : /sitemap.php
# Dernière modification : 19/03/2008
# Créateur : Philippe CD - philippe@carpediem.fr

# Fichiers requis :
require_once('./includes/config.php');
require_once('./includes/config_referencement.php');
require_once('./includes/functions.php');

# Config
$domaine = "http://www.domaine.tld/dossier";

# Don't edit below :

// Connexion MySQL :
$db_1                            = @mysql_connect($sql_config['host'], $sql_config['login'], $sql_config['pass']);
$db_2                            = @mysql_select_db($sql_config['bdd']);
if(!$db_1 || !$db_2)            die('Connexion MySQL impossible');

$sitemap_page = array();

$sitemap_page[0]['loc']            = $domaine . $config['home'] . '/';
$sitemap_page[0]['lastmod']        = date('Y-m-d');
$sitemap_page[0]['changefreq']    = 'daily';
$sitemap_page[0]['priority']    = '1.0';

$n = 1;

# Toutes les langues :
foreach($config['lg'] as $lg=>$lg_ok)    {
    # Toutes les synergies :
    foreach($config['g'] as $syn=>$syn_ok)    {
    
        // Nouveautés :
        $sql                            = sprintf("SELECT id_video FROM cd_videos WHERE synergie='%s'", mysql_real_escape_string($syn));
        $req                            = mysql_query($sql);
        $nb_pages                        = ceil(mysql_num_rows($req)/$config['aff_nb']);
    
        for($a=2;$a<=$nb_pages;$a++)
        {
            $sitemap_page[$n]['loc']        = $domaine . $config['home'].'/'.str_replace('[LG]', $lg, str_replace('[G]', $syn, str_replace('[PG]', $a, $ecriture_lien['nouveautes'])));
            $sitemap_page[$n]['lastmod']    = date('Y-m-d');
            $sitemap_page[$n]['changefreq']    = 'daily';
            $sitemap_page[$n]['priority']    = '0.8';
        
            $n++;
        }
        
        // Catégories :
        $sql                            = sprintf("SELECT id_cat, %s FROM cd_videos_categories WHERE %s='yes' ORDER BY %s", mysql_real_escape_string($lg), mysql_real_escape_string($syn), mysql_real_escape_string($lg));
        $req                            = mysql_query($sql);

        while($v = mysql_fetch_array($req)) {
            $key = forceFilename($v[$lg]);
            $sitemap_page[$n]['loc']        = $domaine . $config['home'].'/'.str_replace('[NOM]', $key, str_replace('[LG]', $lg, str_replace('[G]', $syn, str_replace('[PG]', 1, $ecriture_lien['cat']))));
            $sitemap_page[$n]['lastmod']    = date('Y-m-d');
            $sitemap_page[$n]['changefreq']    = 'daily';
            $sitemap_page[$n]['priority']    = '0.7';
        
            $n++;
    
            // Pagination des catégories
            $sql                            = sprintf("SELECT id_video FROM cd_videos WHERE synergie='hetero' AND categories  LIKE '%s'", mysql_real_escape_string('%:'.$v['id_cat'].':%'));
            $req_1                            = mysql_query($sql);
            $nb_pages                        = ceil(mysql_num_rows($req_1)/$config['aff_nb']);
            for($a=2;$a<=$nb_pages;$a++)
            {
                $sitemap_page[$n]['loc']        = $domaine . $config['home'].'/'.str_replace('[NOM]', $key, str_replace('[LG]', $lg, str_replace('[G]', $syn, str_replace('[PG]', $a, $ecriture_lien['cat']))));;
                $sitemap_page[$n]['lastmod']    = date('Y-m-d');
                $sitemap_page[$n]['changefreq']    = 'daily';
                $sitemap_page[$n]['priority']    = '0.5';
            
                $n++;
            }    
        } 

        // Stars 
        $sql                            = sprintf("SELECT id_actor, nom FROM cd_videos_actors WHERE synergie='%s' ORDER BY nom", mysql_real_escape_string($syn));
        $req                            = mysql_query($sql);
        
        while($v = mysql_fetch_array($req)) {
            $key = forceFilename($v['nom']);
            
            // Pagination des stars
            $sql                            = sprintf("SELECT id_video FROM cd_videos WHERE synergie='hetero' AND actors  LIKE '%s'", mysql_real_escape_string('%:'.$v['id_actor'].':%'));
            $req_1                            = mysql_query($sql);
            
            if(mysql_num_rows($req) > 0)    {
                $sitemap_page[$n]['loc']        = $domaine . $config['home'].'/'.str_replace('[ACTOR]', $key, str_replace('[LG]', $lg, str_replace('[G]', $syn, str_replace('[PG]', 1, $ecriture_lien['actor']))));
                $sitemap_page[$n]['lastmod']    = date('Y-m-d');
                $sitemap_page[$n]['changefreq']    = 'daily';
                $sitemap_page[$n]['priority']    = '0.7';
            
                $n++;
                
                $nb_pages                        = ceil(mysql_num_rows($req_1)/$config['aff_nb']);
                for($a=2;$a<=$nb_pages;$a++)    {
                    $sitemap_page[$n]['loc']        = $domaine . $config['home'].'/'.str_replace('[ACTOR]', $key, str_replace('[LG]', $lg, str_replace('[G]', $syn, str_replace('[PG]', $a, $ecriture_lien['actor']))));;
                    $sitemap_page[$n]['lastmod']    = date('Y-m-d');
                    $sitemap_page[$n]['changefreq']    = 'daily';
                    $sitemap_page[$n]['priority']    = '0.5';
                
                    $n++;
                }
            }    
        }
    }
}

echo '<?xml version="1.0" encoding="UTF-8"?>'."\n"; 
?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">
<?php foreach($sitemap_page as $page) : ?>
    <url>
        <loc><?php echo utf8_encode($page['loc']); ?></loc>
        <lastmod><?php echo utf8_encode($page['lastmod']); ?></lastmod>
        <changefreq><?php echo utf8_encode($page['changefreq']); ?></changefreq>
        <priority><?php echo utf8_encode($page['priority']); ?></priority>
    </url>
<?php endforeach ; ?>    
</urlset>