\n";
$buffer .= "\t\n";
$buffer .= "\t\n";
$buffer .= "\tMargarida.net \n";
$buffer .= "\tblog e portfolio\n";
$buffer .= "\thttp://margarida.net\n";
$bufPost = sitemap_posts($dbfuncoes);
$buffer .= $bufPost;
$buffer .= "\t\n";
$buffer .= "\t\n";
//GRAVA FICHEIRO
$file = fopen("feed.xml", "w");
fwrite($file, $buffer);
fclose($file);
header ('Content-Type: text/xml');
echo $buffer;
function sitemap_posts($dbfuncoes) {
$changeFreqGca = "daily";
$url = "http://".$_SERVER["HTTP_HOST"];
$timezone = date('T');
$query = "SELECT DATE_FORMAT(a.dt_add, '%a, %d %b %Y %T') as pubDate, b.id as idcat, b.nome as nomecat, a.id, a.titulo, a.texto, a.dt_add as data, a.comentarios, DATE_FORMAT(a.dt_add, '%d de %M de %Y, %H:%i:%s') as dt_add, a.dt_edit FROM posts a, categorias b, posts_categorias c WHERE c.cat=b.id AND a.id=c.post GROUP BY a.id ORDER BY a.dt_add desc LIMIT 10";
$resultado = $dbfuncoes->doQuery($query);
$r = '';
while ($r = mysql_fetch_assoc($resultado)) {
$id = $r["id"];
$titulo = $r["titulo"];
$pubDate = $r["pubDate"];
$texto = $r["texto"];
$data = $r["data"];
$comentarios = $r["comentarios"];
$dt_add = $r["dt_add"];
$nomecat = $r["nomecat"];
$idcat = $r["idcat"];
$dt_edit = $r["dt_edit"];
$explodeDataHora = explode(' ',$data);
$explodeData = explode('-',$explodeDataHora[0]);
$ano = $explodeData[0];
$mesN = $explodeData[1];
$dia = $explodeData[2];
$urlf = $dbfuncoes->generate_seo_link($titulo);
$link = "$url/$ano/$mesN/$dia/$urlf/";
$bufPost .= "\t- \n";
$bufPost .= "\t\t$titulo\n";
$bufPost .= "\t\t$pubDate\n";
$bufPost .= "\t\t$link\n";
$bufPost .= "\t\t".$titulo."\n";
$bufPost .= "\t\t\n";
$bufPost .= "\t\t$link\n";
$bufPost .= "\t
\n";
}
return $bufPost;
}
?>