Add news item content as <description> field in RSS feed. Fixes viewe…

…rs that want to show more than just the link and title, like Sage.
icculus · Apr 12, 2007 · ec33170 · ec33170
1 parent c4bd46f
commit ec33170
Showing 1 changed file with 3 additions and 1 deletion.
diff --git a/IcculusNews_daemon.pl b/IcculusNews_daemon.pl
@@ -491,7 +491,7 @@ sub generate_rdf {
     $max = $row[8] if not defined $max;
 
     $sql = "select t1.author, t1.id, t1.title, t1.postdate, t2.name," .
-           " t1.ip, t1.approved, t1.deleted" .
+           " t1.ip, t1.approved, t1.deleted, t1.text" .
            " from $dbtable_items as t1" .
            " left outer join $dbtable_users as t2" .
            " on t1.author=t2.id" .
@@ -525,6 +525,7 @@ sub generate_rdf {
         my $ipaddr       = long2ip($row[5]);
         my $approved     = $row[6];
         my $deleted      = $row[7];
+        my $text         = encode_entities($row[8]);
         my $viewurl = $itemviewurl;
         1 while ($viewurl =~ s/\%id/$itemid/);
         $viewurl = encode_entities($viewurl);
@@ -542,6 +543,7 @@ sub generate_rdf {
         $rdfitems .= "    <ipaddr>$ipaddr</ipaddr>\n";
         $rdfitems .= "    <approved>$approved</approved>\n";
         $rdfitems .= "    <deleted>$deleted</deleted>\n";
+        $rdfitems .= "    <description>\n$text\n    </description>\n";
         $rdfitems .= "  </item>";
     }
     $sth->finish();