Fix my RSS 2.0 script (code provided)

Nuke Cadet Joined: Aug 07, 2005 Posts: 4

I am trying to get an RSS feed to display the content out of the nuke_pages database since it is where I post a majority of my content. I am trying to use an RSS 2.0 feed script from this location:

http://www.truden.com/downloads/backend.txt

and the content module RSS feed from:

http://ravenphpscripts.com/postp78701.html

I came up with this mess.

Code:

<?php

/*********************************************/
/* Save this as backend.php and upload in your root directory */
/********************************************/
/* PHP-NUKE: Advanced Content Management System */
/* ============================================ */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/* */
/************************************************************************/
/* Additional security checking code 2003 by chatserv */
/* http://www.nukefixes.com -- http://www.nukeresources.com */
/************************************************************************/
/* RSS/Atom feed created by Brennan Stehling (2004) */
/* http://brennan.offwhite.net/blog/ - http://portal.spiderlogic.com */
/* Adapted for phpNuke7.8 - 7.9 by Truden (http://www.truden.com) */
/************************************************************************/

include("mainfile.php");
global $prefix, $db, $nukeurl;
header("Content-Type: text/xml");

/* entity to unicode decimal value */
function entity_to_decimal_value($string){

$entity_to_decimal = array(
' ' => ' ',
'¡' => '¡',
'¢' => '¢',
'£' => '£',
'¤' => '¤',
'¥' => '¥',
'¦' => '¦',
'§' => '§',
'¨' => '¨',
'©' => '©',
'ª' => 'ª',
'«' => '«',
'¬' => '¬',
'' => '',
'®' => '®',
'¯' => '¯',
'°' => '°',
'±' => '±',
'²' => '²',
'³' => '³',
'´' => '´',
'µ' => 'µ',
'¶' => '¶',
'·' => '·',
'¸' => '¸',
'¹' => '¹',
'º' => 'º',
'»' => '»',
'¼' => '¼',
'½' => '½',
'¾' => '¾',
'¿' => '¿',
'À' => 'À',
'Á' => 'Á',
'Â' => 'Â',
'Ã' => 'Ã',
'Ä' => 'Ä',
'Å' => 'Å',
'Æ' => 'Æ',
'Ç' => 'Ç',
'È' => 'È',
'É' => 'É',
'Ê' => 'Ê',
'Ë' => 'Ë',
'Ì' => 'Ì',
'Í' => 'Í',
'Î' => 'Î',
'Ï' => 'Ï',
'Ð' => 'Ð',
'Ñ' => 'Ñ',
'Ò' => 'Ò',
'Ó' => 'Ó',
'Ô' => 'Ô',
'Õ' => 'Õ',
'Ö' => 'Ö',
'×' => '×',
'Ø' => 'Ø',
'Ù' => 'Ù',
'Ú' => 'Ú',
'Û' => 'Û',
'Ü' => 'Ü',
'Ý' => 'Ý',
'Þ' => 'Þ',
'ß' => 'ß',
'à' => 'à',
'á' => 'á',
'â' => 'â',
'ã' => 'ã',
'ä' => 'ä',
'å' => 'å',
'æ' => 'æ',
'ç' => 'ç',
'è' => 'è',
'é' => 'é',
'ê' => 'ê',
'ë' => 'ë',
'ì' => 'ì',
'í' => 'í',
'î' => 'î',
'ï' => 'ï',
'ð' => 'ð',
'ñ' => 'ñ',
'ò' => 'ò',
'ó' => 'ó',
'ô' => 'ô',
'õ' => 'õ',
'ö' => 'ö',
'÷' => '÷',
'ø' => 'ø',
'ù' => 'ù',
'ú' => 'ú',
'û' => 'û',
'ü' => 'ü',
'ý' => 'ý',
'þ' => 'þ',
'ÿ' => 'ÿ',
'&fnof;' => 'ƒ',
'Α' => 'Α',
'Β' => 'Β',
'Γ' => 'Γ',
'Δ' => 'Δ',
'Ε' => 'Ε',
'Ζ' => 'Ζ',
'Η' => 'Η',
'Θ' => 'Θ',
'Ι' => 'Ι',
'Κ' => 'Κ',
'Λ' => 'Λ',
'Μ' => 'Μ',
'Ν' => 'Ν',
'Ξ' => 'Ξ',
'Ο' => 'Ο',
'Π' => 'Π',
'Ρ' => 'Ρ',
'Σ' => 'Σ',
'Τ' => 'Τ',
'Υ' => 'Υ',
'Φ' => 'Φ',
'Χ' => 'Χ',
'Ψ' => 'Ψ',
'Ω' => 'Ω',
'α' => 'α',
'β' => 'β',
'γ' => 'γ',
'δ' => 'δ',
'ε' => 'ε',
'ζ' => 'ζ',
'η' => 'η',
'θ' => 'θ',
'ι' => 'ι',
'κ' => 'κ',
'λ' => 'λ',
'μ' => 'μ',
'ν' => 'ν',
'ξ' => 'ξ',
'ο' => 'ο',
'π' => 'π',
'ρ' => 'ρ',
'&sigmaf;' => 'ς',
'σ' => 'σ',
'τ' => 'τ',
'υ' => 'υ',
'φ' => 'φ',
'χ' => 'χ',
'ψ' => 'ψ',
'ω' => 'ω',
'&thetasym;' => 'ϑ',
'&upsih;' => 'ϒ',
'ϖ' => 'ϖ',
'•' => '•',
'…' => '…',
'′' => '′',
'″' => '″',
'&oline;' => '‾',
'&frasl;' => '⁄',
'&weierp;' => '℘',
'&image;' => 'ℑ',
'&real;' => 'ℜ',
'™' => '™',
'&alefsym;' => 'ℵ',
'←' => '←',
'↑' => '↑',
'→' => '→',
'↓' => '↓',
'↔' => '↔',
'&crarr;' => '↵',
'⇐' => '⇐',
'&uArr;' => '⇑',
'⇒' => '⇒',
'&dArr;' => '⇓',
'⇔' => '⇔',
'∀' => '∀',
'∂' => '∂',
'∃' => '∃',
'∅' => '∅',
'∇' => '∇',
'∈' => '∈',
'∉' => '∉',
'&ni;' => '∋',
'∏' => '∏',
'∑' => '∑',
'−' => '−',
'&lowast;' => '∗',
'√' => '√',
'&prop;' => '∝',
'∞' => '∞',
'&ang;' => '∠',
'&and;' => '∧',
'&or;' => '∨',
'∩' => '∩',
'∪' => '∪',
'∫' => '∫',
'&there4;' => '∴',
'&sim;' => '∼',
'&cong;' => '≅',
'≈' => '≈',
'≠' => '≠',
'&equiv;' => '≡',
'≤' => '≤',
'≥' => '≥',
'⊂' => '⊂',
'⊃' => '⊃',
'&nsub;' => '⊄',
'&sube;' => '⊆',
'&supe;' => '⊇',
'&oplus;' => '⊕',
'&otimes;' => '⊗',
'&perp;' => '⊥',
'⋅' => '⋅',
'&lceil;' => '⌈',
'&rceil;' => '⌉',
'&lfloor;' => '⌊',
'&rfloor;' => '⌋',
'&lang;' => '〈',
'&rang;' => '〉',
'&loz;' => '◊',
'&spades;' => '♠',
'&clubs;' => '♣',
'&hearts;' => '♥',
'&diams;' => '♦',
'"' => '"',
'&' => '&',
'<' => '<',
'>' => '>',
'&OElig;' => 'Œ',
'&oelig;' => 'œ',
'&Scaron;' => 'Š',
'&scaron;' => 'š',
'&Yuml;' => 'Ÿ',
'&circ;' => 'ˆ',
'&tilde;' => '˜',
'&ensp;' => ' ',
'&emsp;' => ' ',
' ' => ' ',
'&zwnj;' => '‌',
'&zwj;' => '‍',
'&lrm;' => '‎',
'&rlm;' => '‏',
'–' => '–',
'—' => '—',
'‘' => '‘',
'’' => '’',
'&sbquo;' => '‚',
'“' => '“',
'”' => '”',
'&bdquo;' => '„',
'&dagger;' => '†',
'&Dagger;' => '‡',
'&permil;' => '‰',
'&lsaquo;' => '‹',
'&rsaquo;' => '›',
'€' => '€');

return preg_replace(
"/&[A-Za-z]+;/",
" ",
strtr($string,$entity_to_decimal) );

}
$rssFeedLimit = 15; // Maximum lines in feed
$gmtdiff = date("O", time());
$gmtstr = substr($gmtdiff, 0, 3) . ":" . substr($gmtdiff, 3, 9);
$now = date("Y-m-d\TH:i:s", time());
$now = $now . $gmtstr;

echo "<?xml version=\"1.0\" encoding=\"windows-1251\"?>\n";
echo "<rss version=\"2.0\" \n";
echo " xmlns:dc=\"http://purl.org/dc/elements/1.1/\"\n";
echo " xmlns:sy=\"http://purl.org/rss/1.0/modules/syndication/\"\n";
echo " xmlns:admin=\"http://webns.net/mvcb/\"\n";
echo " xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\">\n\n";
echo "<channel>\n";
echo "<title>".htmlspecialchars($sitename)."</title>\n";
echo "<link>".htmlspecialchars($nukeurl)."</link>\n";
echo "<description>".$slogan."</description>\n";
echo "<dc:language>".$backend_language."</dc:language>\n";
echo "<dc:creator>".$adminmail."</dc:creator>\n";
echo "<dc:date>".$now."</dc:date>\n\n";
echo "<sy:updatePeriod>hourly</sy:updatePeriod>\n";
echo "<sy:updateFrequency>1</sy:updateFrequency>\n";
echo "<sy:updateBase>".$now."</sy:updateBase>\n\n";

$result = $db->sql_query("SELECT text, pid, title, date FROM '.$user_prefix.'_pages WHERE active=1 ORDER BY date DESC LIMIT '.$rssFeedLimit");

while ($row = $db->sql_fetchrow($result)) {
$rsid = intval($row['pid']);
$title = $row['title'];
$text = $row['text'];
$time = $row['date'];

// format: 2004-08-02T12:15:23-06:00
$date = date("Y-m-d\TH:i:s", strtotime($time));
$date = $date . $gmtstr;

echo "<item>\n";
echo "<title>".$title."</title>\n";
echo "<link>$nukeurl/modules.php?name=News&file=article&sid=$rsid</link>\n";
echo "<description>".$text."></description>\n";
echo "<guid isPermaLink=\"false\">".$rsid."@".$nukeurl."</guid>\n";
echo "<dc:subject>".$title."</dc:subject>\n";
echo "<dc:date>".$date."</dc:date>\n";
echo "<dc:creator>Posted by ".$adminmail."</dc:creator>\n";
echo "</item>\n\n";
}

echo "</channel>\n";
echo "</rss>\n";

?>

I need it to work correctly, since I primarly use the content module for my site. I can pay through paypal immediatly.

Support Mod Joined: Oct 19, 2004 Posts: 1032 Location: UK

Is it just the scripts that raven did you want installing? or do you want an rss feed script from scratch?

Nuke Cadet Joined: Aug 07, 2005 Posts: 4

I can install the script just fine. I need the two scripts combined so that the RSS 2.0 script outputs ravens script that uses the content module output as opposed to the news or whatever the default RSS is. If I use ravens script it still uses RSS 0.92, and I would like it to instead by 2.0, but coming out of the content module.