<?php


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


/* 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 coding modifications by Raven 2004                        */


/* http://ravenphpscripts.com -- http://ravenwebhosting.com             */


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


/* 100% RSS/XML and W3C Compliance by Gaylen Fraley (aka Raven)         */


/* http://ravenphpscripts.com -- http://ravenwebhosting.com             */


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


header("Content-Type: text/xml");


include_once("mainfile.php");


echo makeBackendForumRSS($fid=0,$rssFeedLimit=15);


function makeBackendForumRSS($fid=0,$rssFeedLimit=15) {


   global $db, $nukeurl, $user_prefix, $backend_language;


   $fid = isset($_GET['fid'])?$_GET['fid']:0;


   $fid = intval($fid);


   $whereClause = '';


   $counter = 0;


   $xmlHeader = '';


   $xmlBody = '';


   $xmlFooter = '';


   $addForumName = FALSE;


   if ($fid) {


      $whereClause  = "WHERE forum_id='$fid'";


      $addForumName = TRUE;


   }


   $xmlHeader .= "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n\n";


   $xmlHeader .= "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n";


   $xmlHeader .= " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n\n";


   $xmlHeader .= "<rss version=\"0.91\">\n\n";


   $xmlHeader .= "<channel>\n";


   $xmlHeader .= "<title>".htmlspecialchars($sitename)." - Forums%%_NAME_%%</title>\n";


   $xmlHeader .= "<link>$nukeurl</link>\n";


   $xmlHeader .= "<description>".htmlspecialchars($backend_title)."</description>\n";


   $xmlHeader .= "<language>$backend_language</language>\n\n";


   $result = $db->sql_query("SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_moved_id FROM ".$user_prefix."_bbtopics $whereClause ORDER BY topic_last_post_id DESC");


   while(list($topic_id, $forum_id, $topic_last_post_id, $topic_title, $topic_moved_id) = $db->sql_fetchrow($result)) {


      $result1 = $db->sql_query( "SELECT auth_view, auth_read, forum_name, cat_id FROM ".$user_prefix."_bbforums where forum_id = '$forum_id'");


      list( $auth_view, $auth_read, $forum_name, $cat_id ) = $db->sql_fetchrow($result1);


      if( ( $auth_view != 0 ) or ( $auth_read != 0 ) ) continue;


      if( $topic_moved_id != 0 ) continue;


      ++$counter;


      $result3 = $db->sql_query("SELECT topic_id, FROM_UNIXTIME(post_time,'%b %d, %Y at %T') as post_time, username, user_id FROM ".$user_prefix."_bbposts," .$user_prefix."_users where post_id='$topic_last_post_id' AND user_id=poster_id Limit 1");


      list($topic_id, $post_time, $username, $user_id)=$db->sql_fetchrow($result3);


       $rtitle = superhtmlentities($topic_title);


       $rtitle = str_replace('_',' ',$rtitle); //added 9/1/2004


       $xmlBody .= "<item>\n";


       $xmlBody .= "<title>".htmlspecialchars($rtitle)."</title>\n";


       $xmlBody .= "<link>$nukeurl/postp$topic_last_post_id#$topic_last_post_id</link>\n";


       $xmlBody .= "</item>\n\n";


       if ($counter==$rssFeedLimit) break;


   }


   $xmlFooter .= "</channel>\n";


   $xmlFooter .= "</rss>";


   if ($addForumName) $xmlHeader = str_replace('%%_NAME_%%',": $forum_name",$xmlHeader);


   else $xmlHeader = str_replace('%%_NAME_%%','',$xmlHeader);


   return $xmlHeader.$xmlBody.$xmlFooter;


}





function superhtmlentities($text) {


   // Thanks to mirrorball_girl for this


   $entities = array(128 => 'euro', 130 => 'sbquo', 131 => 'fnof', 132 => 'bdquo', 133 => 'hellip', 134 => 'dagger', 135 => 'Dagger', 136 => 'circ', 137 => 'permil', 138 => 'Scaron', 139 => 'lsaquo', 140 => 'OElig', 145 => 'lsquo', 146 => 'rsquo', 147 => 'ldquo', 148 => 'rdquo', 149 => 'bull', 150 => '#45', 151 => 'mdash', 152 => 'tilde', 153 => 'trade', 154 => 'scaron', 155 => 'rsaquo', 156 => 'oelig', 159 => 'Yuml');


   $new_text = '';


   for($i = 0; $i < strlen($text); $i++) {


      $num = ord($text{$i});


      if (array_key_exists($num, $entities)) {


         switch ($num) {


            case 150:


               $new_text .= '-';


               break;


            case 153:


               $new_text .= '(tm)';


               break;


            default:


               $new_text .= "&".$entities[$num].';';


         }


      }


      elseif ($num < 127 || $num > 159) {


         $new_text .= htmlentities($text{$i});


      }


   }


   $new_text = ereg_replace("  +", " ", $new_text);


   ## remove double spaces.


   return $new_text;


}


?>

−


   <rss version="0.91">


−


   <channel>


<title> - Forums</title>


<link>http://www.subfighter.com</link>


<description/>


<language>en-us</language>


−


   <item>


<title>Bottom Half Guard Submissions</title>


<link>http://www.subfighter.com/postp510780#510780</link>


</item>


−


   <item>


<title>Video-&amp;gt; Gono Akihiro vs Ivan Salaverry</title>


<link>http://www.subfighter.com/postp510779#510779</link>


</item>


−


   <item>


−


   <title>


Lee Murray Finally Caught &amp;amp; Arrested In Morocco?


</title>


<link>http://www.subfighter.com/postp510777#510777</link>


</item>


−


   <item>


<title>Any predictions on Renzo v/s Miletich?</title>


<link>http://www.subfighter.com/postp510776#510776</link>


</item>

# Support: http://ravenphpscripts.com                                  #


# Hosting: http://ravenwebhosting.com                                  #


# Version: 2.3.1   





# Version 2.3.1                                                        #


# 02/13/2006  : Modified default empty $skipTopPostersUserNames="''"   #


#             : due to certain releases of MySQL behavior.             #


#             : Added setting ($showTickerMessage) to control ticker