<?php header('Content-type: text/xml');
include '../utilitats/funcions.php';
include 'wp-config.php';
// ...Connect to WP database
$dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if ( !$dbc ) die( 'Not Connected: ' . mysql_error());
// Select the database
$db = mysql_select_db(DB_NAME);
if (!$db) echo "There is no database: " . $db;
global $wpdb; // you may not need this part. Try with and without it
//echo $wpdb->prefix; // here is your database prefix

?>
<rss version="2.0">
<channel>
<title>Intercambia.net - trucos para ahorrar, cosas gratis, trueques, consumo y salud</title>
<description>Este blog trata un amplio abanico de temas: ecología, críticas al consumismo, movimientos sociales, noticias, ahorro, tipos de trueque, cosas gratis, etc.</description>
<link>http://intercambia.net/temas/</link>
<copyright>El material de este blog es libre para compartirlo en cualquier forma siempre que se cite la fuente</copyright>
<image>
<title>Intercambia.net</title>
<url>http://intercambia.net/disseny/cabecera2.png</url>
<link>http://intercambia.net/temas/</link>
<width>144</width>
<height>35</height>
</image>
<?php
//posts publicats a elvirtual
$q="SELECT *,UNIX_TIMESTAMP(post_date) AS pubDate
FROM wp_posts WHERE post_status='publish' AND post_author!='3' AND post_type='post' ORDER BY pubDate DESC LIMIT 0,14";
$doGet=mysql_query($q);
?>
<?php
while($result = mysql_fetch_array($doGet)){

$titol=utf8_to_unicode( $result['post_title'] );
$titol=unicode_to_entities_preserving_ascii($titol);
$titol=htmlentities(strip_tags( $titol,'ENT_QUOTES'));

$text=utf8_to_unicode( $result['post_content'] );
$text=unicode_to_entities_preserving_ascii($text);
$text=htmlentities(strip_tags( $text,'ENT_QUOTES'));

$idz=$result['ID'];
$urlpost=get_permalink($idz);

$titol=str_replace("&amp;ntilde;", "ñ", $titol);
$titol=str_replace("&amp;Ntilde;", "Ñ", $titol);
$titol=str_replace("&amp;aacute;", "á", $titol);
$titol=str_replace("&amp;eacute;", "é", $titol);
$titol=str_replace("&amp;iacute;", "í", $titol);
$titol=str_replace("&amp;oacute;", "ó", $titol);
$titol=str_replace("&amp;uacute;", "ú", $titol);
$titol=str_replace("&amp;Aacute;", "Á", $titol);
$titol=str_replace("&amp;Eacute;", "É", $titol);
$titol=str_replace("&amp;Iacute;", "Í", $titol);
$titol=str_replace("&amp;Oacute;", "Ó", $titol);
$titol=str_replace("&amp;Uacute;", "Ú", $titol);


$text=str_replace("&amp;ntilde;", "ñ", $text);
$text=str_replace("&amp;Ntilde;", "Ñ", $text);
$text=str_replace("&amp;aacute;", "á", $text);
$text=str_replace("&amp;eacute;", "é", $text);
$text=str_replace("&amp;iacute;", "í", $text);
$text=str_replace("&amp;oacute;", "ó", $text);
$text=str_replace("&amp;uacute;", "ú", $text);
$text=str_replace("&amp;Aacute;", "Á", $text);
$text=str_replace("&amp;Eacute;", "É", $text);
$text=str_replace("&amp;Iacute;", "Í", $text);
$text=str_replace("&amp;Oacute;", "Ó", $text);
$text=str_replace("&amp;Uacute;", "Ú", $text);
$text=str_replace("&amp;ntilde;", "ñ", $text);
$text=str_replace("&amp;Ntilde;", "Ñ", $text);

/*$text=str_replace("&amp;#255;", "á", $text);
$text=str_replace("&amp;#233;", "é", $text);
$text=str_replace("&amp;#237;", "í", $text);
$text=str_replace("&amp;#243;", "ó", $text);
$text=str_replace("&amp;#250;", "ú", $text);
$text=str_replace("&amp;Aacute;", "Á", $text);
$text=str_replace("&amp;Eacute;", "É", $text);
$text=str_replace("&amp;Iacute;", "Í", $text);
$text=str_replace("&amp;Oacute;", "Ó", $text);
$text=str_replace("&amp;Uacute;", "Ú", $text);*/

$titol=str_replace("&amp;#241;", "ñ", $titol);
$titol=str_replace("&amp;#57;", "Ñ", $titol);
$titol=str_replace("&amp;#225;", "á", $titol);
$titol=str_replace("&amp;#233;", "é", $titol);
$titol=str_replace("&amp;#237;", "í", $titol);
$titol=str_replace("&amp;#243;", "ó", $titol);
$titol=str_replace("&amp;#250;", "ú", $titol);
$titol=str_replace("&amp;#41;", "Á", $titol);
$titol=str_replace("&amp;#49;", "É", $titol);
$titol=str_replace("&amp;#53;", "Í", $titol);
$titol=str_replace("&amp;#211;", "Ó", $titol);
$titol=str_replace("&amp;#62;", "Ú", $titol);

$text=str_replace("&amp;#241;", "ñ", $text);
$text=str_replace("&amp;#57;", "Ñ", $text);
$text=str_replace("&amp;#225;", "á", $text);
$text=str_replace("&amp;#233;", "é", $text);
$text=str_replace("&amp;#237;", "í", $text);
$text=str_replace("&amp;#243;", "ó", $text);
$text=str_replace("&amp;#250;", "ú", $text);
$text=str_replace("&amp;#41;", "Á", $text);
$text=str_replace("&amp;#49;", "É", $text);
$text=str_replace("&amp;#53;", "Í", $text);
$text=str_replace("&amp;#211;", "Ó", $text);
$text=str_replace("&amp;#62;", "Ú", $text);


//if ($result['post_type']=="page"){$p="page_id=".$idz;}else{$p="p=".$idz;}


//$titol20=ereg_replace(' ', '%20', $titol);
$titol20=urlencode($titol);

$post="&lt;p&gt; &lt;a href='http://del.icio.us/post?url=" . $urlpost ."&amp;title=". $titol20 ."'&gt;&lt;img src='http://intercambia.net/temas/delicious.png' border='0'&gt;Del.icio.us &lt;/a&gt; - &lt;a href='http://meneame.net/submit.php?url=". $urlpost ."'&gt;&lt;img src='http://intercambia.net/temas/meneame.gif' border='0'&gt;Env&amp;iacute;ala a Men&amp;eacute;ame si te gust&amp;oacute;&lt;/a&gt; - &lt;a href='http://intercambia.net/agregador'&gt;Selecci&amp;oacute;n de noticias interesantes&lt;/a&gt;  - &lt;a href='http://intercambia.net/conversaciones/'&gt;Foro&lt;/a&gt; - &lt;a href='http://feeds.feedburner.com/intercambia-comentarios'&gt;Comentarios&lt;/a&gt;&lt;/p&gt;
";

/*$post2="&lt;p&gt; &lt;a href='http://del.icio.us/post?url=" . $urlpost ."&amp;title=". $titol20 ."'&gt;&lt;img src='http://intercambia.net/temas/delicious.png' border='0'&gt;Del.icio.us&lt;/a&gt; - &lt;a href='http://feeds.feedburner.com/intercambia-comentarios'&gt;Comentarios&lt;/a&gt;&lt;/p&gt;
";*/
$post2=$post;

$i++;

if (strstr($result['post_content'], "<exec>")){
$artconphp="si";



  $textb="Por problemas de formato del texto para ver el contenido de este artículo concreto es necesario visitar el blog. Con el resto de artículos el feed sigue funcionando correctamente. Disculpa las molestias.";

}
?>
     <item>
	<guid><?php echo $urlpost; ?></guid>
        <title> <?php echo $titol; ?></title>
        <description> <?php if ($artconphp=="si"){echo $textb; $artconphp="";}else{echo $text;} if ($i=="1"){echo $post;}else {echo $post2;} ?></description>
        <link><?php echo $urlpost; ?></link>
        <pubDate><?php echo strftime( "%a, %d %b %Y %T %z" , $result['pubDate']); ?></pubDate>
	<comments><?php echo $urlpost;?>#comment</comments>
     </item>  
<?php
/*
if ($artconphp="si"){
  $artconphp="";
  unlink("inter_articulos_con_php_a_feed.php");
}*/

} 



$sql="SELECT * FROM inter_noticies_externes ORDER BY id DESC";
$consulta_id=mysql_query($sql);
$taules = mysql_fetch_array($consulta_id, MYSQL_ASSOC);
$diapublicacio=$taules["data"];
$id2=$taules["id"];


//ultimes noticies seleccionades
$mysq="SELECT *,UNIX_TIMESTAMP(data) AS pubDate
FROM inter_noticies_externes WHERE data='".$diapublicacio."' ORDER BY titol";
$doGet2=mysql_query($mysq);

//$emissions="Últimes noticies seleccionades de la prensa i els blogs";

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

$emetent=utf8_to_unicode( $result2['titol'] );
$emetent=unicode_to_entities_preserving_ascii($emetent);
$emetent=htmlentities(strip_tags( $emetent,'ENT_QUOTES'));

//$emetenturl=urlencode(utf8_decode($result2['titol']));
//$emetenturl=rawurlencode($result2['titol']);



$emetent=str_replace("&amp;ntilde;", "ñ", $emetent);
$emetent=str_replace("&amp;Ntilde;", "Ñ", $emetent);
$emetent=str_replace("&amp;aacute;", "á", $emetent);
$emetent=str_replace("&amp;eacute;", "é", $emetent);
$emetent=str_replace("&amp;iacute;", "í", $emetent);
$emetent=str_replace("&amp;oacute;", "ó", $emetent);
$emetent=str_replace("&amp;uacute;", "ú", $emetent);
$emetent=str_replace("&amp;Aacute;", "Á", $emetent);
$emetent=str_replace("&amp;Eacute;", "É", $emetent);
$emetent=str_replace("&amp;Iacute;", "Í", $emetent);
$emetent=str_replace("&amp;Oacute;", "Ó", $emetent);
$emetent=str_replace("&amp;Uacute;", "Ú", $emetent);

$emetent=str_replace("&amp;#241;", "ñ", $emetent);
$emetent=str_replace("&amp;#57;", "Ñ", $emetent);
$emetent=str_replace("&amp;#225;", "á", $emetent);
$emetent=str_replace("&amp;#233;", "é", $emetent);
$emetent=str_replace("&amp;#237;", "í", $emetent);
$emetent=str_replace("&amp;#243;", "ó", $emetent);
$emetent=str_replace("&amp;#250;", "ú", $emetent);
$emetent=str_replace("&amp;#41;", "Á", $emetent);
$emetent=str_replace("&amp;#49;", "É", $emetent);
$emetent=str_replace("&amp;#53;", "Í", $emetent);
$emetent=str_replace("&amp;#211;", "Ó", $emetent);
$emetent=str_replace("&amp;#62;", "Ú", $emetent);
$emetent=str_replace("&amp;#128;", "euro", $emetent);



$url=$result2['url'];
$url=str_replace(" ", "", $url);
//$emetenturl=str_replace("+", "%20", $emetenturl);
$urele = urlencode($result2['url']);

//$emissions .= "<a href='http://intercambia.net/inter_noticiesplus.php?url=" . $urele . "'>" . $emetent . "</a> -||| ";

$emissions .= "&lt;p&gt; &lt;a href=<![CDATA[http://intercambia.net/inter_noticiesplus.php?url=" . $url . "]]> &gt;" . $emetent."&lt;/a&gt; &lt;/p&gt;";

//$emissions .= $emetent . " -||| ";
//enlace &lt;a href="http://"&gt;    &lt;/a&gt;
//resaltado &lt;strong&gt;Amie Street&lt;/strong&gt;
//imagen &lt;img src="http://www.error500.net/images/articulos/amie.gif" alt="Amie Street" hspace="10" align="right"/&gt;
//parrafo &lt;p&gt; &lt;/p&gt;


} 
$dataultimesnews=substr($diapublicacio, 0, 10);
$n= mysql_num_rows($doGet2);


if ($n>0){


 ?>

  <item>
	<guid>http://intercambia.net/inter_noticies.php?em=<?php echo $dataultimesnews; ?></guid>
        <title>Últimas noticias seleccionadas de prensa y blogs con fecha de <?php echo $dataultimesnews; ?>. Para más información contacta con intercambia.net@gmail.com. Si quieres ver alguna de estas noticias clica en el enlace</title>
        <description><?php echo $emissions; ?></description>
        <link>http://intercambia.net/inter_noticies.php</link>
        <pubDate><?php echo strftime( "%a, %d %b %Y %T %z" , $diapublicacio); ?></pubDate>
     </item>  

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