Categories tag in RSS feed

[GeoS+]

Find in /includes/functions_feeds.php:

PHP Code:

    while(list($id,$datetime,$headline,$body,$image) = mysql_fetch_row($query))
    {
        $headline = pullout($headline);
        $headline = htmlspecialchars($headline,ENT_QUOTES);
        $image = $cfgrow['siteurl'].$rsspicdir.$image;
        $datetime = strtotime($datetime);
        $datetime =date("D, d M Y H:i",$datetime);
        $datetime .= ' ' .$tzoner;
        $body = pullout($body);
        $body = stripslashes($body);
        $body = strip_tags( $body);
        $body = htmlspecialchars($body,ENT_QUOTES);
        $body = ereg_replace("\n","\n<br />",$body);
        $output .= "
        <item>
        <title>$headline</title>
        <link>".$cfgrow['siteurl']."index.php?showimage=$id</link>
        <description>
";
        if($rsspicdir) $output .= "            &lt;img src=&quot;$image&quot;&gt;&lt;br/&gt;
";
        if($cfgrow['rsstype'] != 'O') $output .= "            $body";
        $output .= "
        </description>
        <pubDate>$datetime</pubDate>
        <guid isPermaLink='true'>".$cfgrow['siteurl']."index.php?showimage=$id</guid>
        </item>";
    } 


and change to:

PHP Code:

    while(list($id,$datetime,$headline,$body,$image) = mysql_fetch_row($query))
    {
        $headline = pullout($headline);
        $headline = htmlspecialchars($headline,ENT_QUOTES);
        $enclosure = $cfgrow['siteurl']."images/".$image;
        $filesize = filesize("images/".$image."");
        $image = $cfgrow['siteurl'].$rsspicdir.$image;
        $datetime = strtotime($datetime);
        $datetime =date("D, d M Y H:i",$datetime);
# GeoS Hack
        $datetime2 = $datetime;
        $datetime .= ' ' .$tzoner;
        $body = pullout($body);
        $body = stripslashes($body);
        $body = strip_tags( $body);
        $body = htmlspecialchars($body,ENT_QUOTES);
        $body = ereg_replace("\n","\n<br />",$body);
# GeoS Hack

        $rss_cat = '';
        $cat_query = mysql_query("SELECT name FROM ".$pixelpost_db_prefix."categories AS a, ".$pixelpost_db_prefix."catassoc AS b WHERE b.image_id = ".$id." AND b.cat_id = a.id ORDER BY name asc");
        while(list($cat_name) = mysql_fetch_row($cat_query))
        {
            $rss_cat .= "        <category>".$cat_name."</category>\n";
        }

        $body = "&lt;b&gt;Title: ".$headline."&lt;/b&gt;\n&lt;br /&gt;&lt;b&gt;Date: ".$datetime2."&lt;/b&gt;\n&lt;br /&gt;\n&lt;br /&gt;&lt;p&gt;" . $body . "&lt;/p&gt;";
        $output .= "
        <item>
        <title>$headline</title>
        <link>".$cfgrow['siteurl']."rss/$id/</link>
        <description>
";
        if($rsspicdir) $output .= "            &lt;img src=&quot;$image&quot;&gt;&lt;br/&gt;
";
        if($cfgrow['rsstype'] != 'O') $output .= "            $body";
        $output .= "
        </description>
        <enclosure type=\"image/jpeg\" length=\"".$filesize."\" url=\"".$enclosure."\" />
        <pubDate>$datetime</pubDate>
        <guid isPermaLink='true'>".$cfgrow['siteurl']."rss/$id/</guid>
".$rss_cat."      </item>";
    }