lunedì 19 settembre 2011

JOOMD RSS

da mettere prima dell' inizio del tag html:

if($_GET['rss']!=''){include('rss.php');exit();}

poi inserire il file rss.php nella root di joomla

<?php


$crea="";
$db =& JFactory::getDBO();
$queryz = "SELECT * FROM mao_directory_entry WHERE published = '1' ORDER BY ordering";

$db->setQuery( $queryz );

$rows = $db->loadObjectList();

foreach($rows as $row)
{
$idd=$row->id;
$title = $row->title;
if(strtotime($row->create_date) > strtotime($crea))$crea= $row->create_date;

$db2 =& JFactory::getDBO();
$queryz2 = "SELECT * FROM mao_directory_enf WHERE entry_id = '".$idd."' AND field_id = '17'";

$db2->setQuery( $queryz2 );

$rows2 = $db2->loadObjectList();

foreach($rows2 as $row2)
{
$val=strip_tags($row2->field_value);

$temp.="<item><title>".$title."</title>
<link>http://maurizioguermandi.agenzia-pubblicita-italia.com/index.php?option=com_joomd&#38;view=joomd&#38;layout=detail&#38;id=".$idd."</link>
<description>".$val."</description>
</item>";
}

}

$temp.= '</channel></rss>';
$tempo= '<rss version="2.0">
<channel>
<title>MAURIZIO GUERMANDI &#38; ASSOCIATI</title>
<description>MAURIZIO GUERMANDI &#38; ASSOCIATI</description>
<link>http://maurizioguermandi.agenzia-pubblicita-italia.com</link>
<lastBuildDate>'.$crea.'</lastBuildDate>
<generator>Joomla! 1.5 - Open Source Content Management</generator>
<language>it-it</language><category>comunicazione, advertising, web, events</category>';

echo $tempo.$temp;
?>
per chiamare il file rss:

http://maurizioguermandi.agenzia-pubblicita-italia.com/index.php?rss=1

Nessun commento:

Posta un commento