<? header('Content-type: text/xml'); ?>
<rss version="2.0">
<channel>
<title>RedTV - Resumen y listado de documentales sociales</title>
<description>Resumen y listado de documentales con contenido social, de denuncia e investigación</description>
<link>http://nodo50.org/redprogresista/redtv/</link>
<copyright>Los resumenes tienen licencia libre con cita, se libre de utilizarlos para generar nuevo contenido</copyright>
<image>
<title>RedTV</title>
<url>http://nodo50.org/redprogresista/redtv/images/redtvbordespeque.gif</url>
<link>http://nodo50.org/redprogresista/redtv/</link>
<width>126</width>
<height>155</height>
</image>
<?
$dbhost = 'mysql.nodo50.org';
$dbname = 'redprogresista3';
$dbuser = 'redprogresista3';
$dbpasswd = '43fyy7kv';

if (!($conecta=mysql_connect($dbhost,$dbuser,$dbpasswd)))
{
  echo "Error conectant amb la base de dades.";
  exit();
}
if (!mysql_select_db($dbname,$conecta))
{
  echo "Error sel·leccionant la base de dades.";
  exit();
}

//últims resums de redtv
$q="SELECT *,UNIX_TIMESTAMP(created) AS pubDate
FROM antis_content WHERE state='1' ORDER BY pubDate DESC LIMIT 0,13";
$doGet=mysql_query($q);


?>
<?
while($result = mysql_fetch_array($doGet)){

$titol=htmlentities(strip_tags($result['title'])); 
$titol=str_replace("&ntilde;", "ny", $titol);
$titol=str_replace("&Ntilde;", "NY", $titol);
$titol=str_replace("&aacute;", "a", $titol);
$titol=str_replace("&eacute;", "e", $titol);
$titol=str_replace("&iacute;", "i", $titol);
$titol=str_replace("&oacute;", "o", $titol);
$titol=str_replace("&uacute;", "u", $titol);
$titol=str_replace("&Aacute;", "A", $titol);
$titol=str_replace("&Eacute;", "E", $titol);
$titol=str_replace("&Iacute;", "I", $titol);
$titol=str_replace("&Oacute;", "O", $titol);
$titol=str_replace("&Uacute;", "U", $titol);


$text=htmlentities(strip_tags($result['fulltext'],'ENT_QUOTES'));
$text=str_replace("&ntilde;", "n", $text);
$text=str_replace("&Ntilde;", "NY", $text);
$text=str_replace("&aacute;", "a", $text);
$text=str_replace("&eacute;", "e", $text);
$text=str_replace("&iacute;", "i", $text);
$text=str_replace("&oacute;", "o", $text);
$text=str_replace("&uacute;", "u", $text);
$text=str_replace("&Aacute;", "A", $text);
$text=str_replace("&Eacute;", "E", $text);
$text=str_replace("&Iacute;", "I", $text);
$text=str_replace("&Oacute;", "O", $text);
$text=str_replace("&Uacute;", "U", $text);

if ($data=="")$data=$result['pubDate'];

?>
     <item>
	<guid>http://nodo50.org/redprogresista/redtv/content/view/<?=$result['id'];?>/</guid>
        <title> <?=$titol; ?></title>
        <description> <?=$text; ?></description>
        <link>http://nodo50.org/redprogresista/redtv/content/view/<?=$result['id'];?>/</link>
        <pubDate><?=strftime( "%a, %d %b %Y %T %z" , $result['pubDate']); ?></pubDate>
     </item>  
<? } 

//última estrena
$ql="SELECT * FROM antis_jos_estrenos ORDER BY id DESC";
$consulta_id=mysql_query($ql);
$taules = mysql_fetch_array($consulta_id, MYSQL_ASSOC);
$estrena=$taules["estreno"];
$id=$taules["id"];



$estrena=htmlentities(strip_tags($estrena,'ENT_QUOTES'));
$estrena=str_replace("&ntilde;", "n", $estrena);
$estrena=str_replace("&Ntilde;", "NY", $estrena);
$estrena=str_replace("&aacute;", "a", $estrena);
$estrena=str_replace("&eacute;", "e", $estrena);
$estrena=str_replace("&iacute;", "i", $estrena);
$estrena=str_replace("&oacute;", "o", $estrena);
$estrena=str_replace("&uacute;", "u", $estrena);
$estrena=str_replace("&Aacute;", "A", $estrena);
$estrena=str_replace("&Eacute;", "E", $estrena);
$estrena=str_replace("&Iacute;", "I", $estrena);
$estrena=str_replace("&Oacute;", "O", $estrena);
$estrena=str_replace("&Uacute;", "U", $estrena);

?>  

     <item>
	<guid>http://nodo50.org/redprogresista/redtv/redtv.php?res=<?=$id;?></guid>
        <title> Próximo resumen </title>
        <description> <?=$estrena; ?></description>
        <link>http://nodo50.org/redprogresista/redtv/</link>
        <pubDate><?=strftime( "%a, %d %b %Y %T %z" , $data); ?></pubDate>
     </item>  

<?

$datapro=date("Y-m-d");

/*
$sql="SELECT * FROM antis_jos_programas ORDER BY id DESC";
$consulta_id=mysql_query($sql);
$taules = mysql_fetch_array($consulta_id, MYSQL_ASSOC);
$diaemissio=$taules["fecha"];
$id2=$taules["id"];
*/

//últims resums de redtv
$mysq="SELECT *,UNIX_TIMESTAMP(fecha) AS pubDate
FROM antis_jos_programas WHERE fecha='".$datapro."' ORDER BY nombre_video";
$doGet2=mysql_query($mysq);

while($result2 = mysql_fetch_array($doGet2)){

$emetent=htmlentities(strip_tags($result2['nombre_video'])); 
$emetent=str_replace("&ntilde;", "ny", $emetent);
$emetent=str_replace("&Ntilde;", "NY", $emetent);
$emetent=str_replace("&aacute;", "a", $emetent);
$emetent=str_replace("&eacute;", "e", $emetent);
$emetent=str_replace("&iacute;", "i", $emetent);
$emetent=str_replace("&oacute;", "o", $emetent);
$emetent=str_replace("&uacute;", "u", $emetent);
$emetent=str_replace("&Aacute;", "A", $emetent);
$emetent=str_replace("&Eacute;", "E", $emetent);
$emetent=str_replace("&Iacute;", "I", $emetent);
$emetent=str_replace("&Oacute;", "O", $emetent);
$emetent=str_replace("&Uacute;", "U", $emetent);

$emissions .= $result2['hora'] . " - " . $emetent . " - " . $result2['cadena'] ." -||| ";



 } 


$n= mysql_num_rows($doGet2);


if ($n>0){


 ?>

  <item>
	<guid>http://nodo50.org/redprogresista/redtv/redtv.php?em=<?=$datapro;?></guid>
        <title> Emisiones de documentales recomendadas para el <?=$datapro;?> en España. Para otros países consultar a redtv.org.es@gmail.es  </title>
        <description> <?=$emissions; ?></description>
        <link>http://nodo50.org/redprogresista/redtv/</link>
        <pubDate><?=strftime( "%a, %d %b %Y %T %z" , $data); ?></pubDate>
     </item>  

<?
}
?>
</channel>
</rss>
