First, add the following 3 lines on config.php, just below the line which says "$XmlLimit="10";"


# RSS variables
$ssRSS_Description = "This should be a longer description of your site";
$ssRSS_Copyright = "(c) 2005 by Yours Truly. All rights reserved.";
$ssRSS_Timezone = "GMT";



(change those to reflect your own site's preferences)

Then, go to your own site, look up the interface (or object...) that has your code, and just after the call to the CSS file (if you call it at all) put:


<link rel="alternate" type="application/rss+xml" title="RSS" href="http://www.yoursitename.com/rss.php" />


This will enable browsers with the appropriate settings to "auto-load" your RSS feeds (works great under Mozilla Firefox/Sage as well as Safari!)

Finally, just copy the following code and put it inside a file called "rss.php":



/**************************************

Project: Siteseed (copyright MrNet 2005 - All right reserved)
Filename: article/rss.php
Last modified: 20050718

***************************************/

require_once "config.php";
require_once "article/comon.php";

function mssql_date_parser($indate){
//YYYY-MM-DD HH:mm:ss.splits
$indate = explode(" ", $indate);
$dateArr = explode("-", $indate[0]);
$timeArr = explode(":", $indate[1]);
$timeArr[2] = substr($timeArr[2],0, strpos($timeArr[2],"."));
$outdate = mktime(
$timeArr[0],
$timeArr[1],
$timeArr[2],
$dateArr[1],
$dateArr[2],
$dateArr[0]
);
return $outdate;
}

if($dblink=mysql_pconnect($database_server, $database_username, $database_password))
{
mysql_select_db ("$projecto");

$howmany +=0;
$tlow +=0;
$thigh +=0;

if($howmany>0) { $XmlLimit=$howmany; }

if($thigh+$tlow>0)
{
$query="SELECT ARTICLEbase.serial from ARTICLEbase,ARTICLEtopic WHERE ARTICLEbase.serial=ARTICLEtopic.article and ARTICLEbase.aprovado>0 and ARTICLEbase.lastchanged=$tlow and ARTICLEtopic.topic<=$thigh ORDER BY ARTICLEbase.lastchanged DESC LIMIT 0,$XmlLimit";
}
else
{
$query="SELECT serial from ARTICLEbase WHERE aprovado>0 and lastchanged }

if($listagem=mysql_query("$query", $dblink))
{
header("Content-type: text/xml; charset=iso-8859-1");
print "\n";
print "\n\n";
print "\n";
print "$project_path\n";
print "$ssRSS_Description\n";
print "$ssRSS_Copyright\n";

while($rowlista = mysql_fetch_object($listagem))
{
$serialid= $rowlista -> serial;

$article=$serialid;
if($article>0) {$id=$article;}
$id=addslashes($id);

if($id>0)
{
#
# Load the article base settings
#
if($result=mysql_query("SELECT * from ARTICLEbase where serial=$id AND aprovado>0", $dblink))
{
$gotone=0;
while($row = mysql_fetch_object($result))
{
$base_serial= $row -> serial;
$base_title= $row -> title;
$base_lastchanged= $row -> lastchanged;
$xmlart ="\n";
// do some tweaking of the date to conform to RFC-822
$publishdate ="\t".date("D, d M Y H:i:s", mssql_date_parser($base_lastchanged))." $ssRSS_Timezone\n";
}


#
# Load the article contents (if any)
#
$xmlart3="";
if($result=mysql_query("SELECT * from ARTICLEcontent where artigo=$id ORDER BY type", $dblink))
{

while($row = mysql_fetch_object($result) && gotone < 2)
{
$type= $row -> type;
$item_text[$type]= $row -> stuff;
$campo="field$type";
$what=$$campo;
$item_text[$type]=strip_tags($item_text[$type]);
$item_text[$type]=htmlentities($item_text[$type]);
$item_text[$type]=ereg_replace("\n", " ", $item_text[$type]);

if(strlen($base_title)>1)
{
$gotone++;

$xmlart2 ="\t\n";
$xmlart2 .="\t$project_path/index.php?article=$id&visual=1\n";
}

if($type>0 && strlen($item_text[$type])>1)
{
$item_text[$type]=ereg_replace("\r", "", $item_text[$type]);
$gotone++;
$xmlart3 .="\t$item_text[$type]\n";
}
}
}
}

if($gotone>1)
{
print "$xmlart$xmlart2$xmlart3$publishdate\n";
}

}
}

print "\n\n";
}
}
?>



This gets validated by most validators as a valid RSS feed, but feel free to tweak it to make it better, and try it out on different situations.

Happy syndicating!

Sure... if you give us the link we will promote it on our own Siteseed page.

Sure... all strings are isolated in the code and it´s really easy to do. If you want to donate your work to the project we will be glad to incorporate it. But you can also license it under your own terms (in which case it will _NOT_ get incorporated into Siteseed: only BSD licensed material gets into Siteseed).

We reveived already translations to: