phpBB.de

Code: Alles auswählen

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
header("Content-Type: text/xml");
include_once($phpbb_root_path . 'extension.inc');
include_once($phpbb_root_path . 'common.'.$phpEx);
include_once($phpbb_root_path . 'includes/functions.'.$phpEx);

if ( $HTTP_GET_VARS["posts"] == "" )
   $reclim = 5;
else
   $reclim = $HTTP_GET_VARS["posts"];

$mode = $_GET['mode'];
$fid = $_GET['fid'];

$sql_allForums = "";
$sql_nameForum = "";

$allForums_check = 1;
$allForums = "All Forums";

if ( $mode != "" )
{

 if ( $fid != "" )
   {
    $sql_singleForum = "AND a.forum_id=".$fid."";
    $sql_nameForum = ", d.forum_name";
    $allForums_check = 0;
   }

 switch ($mode) 
   {
    case "all":
     $sql_forumSwitch = $sql_allForums;
     break;

    case "single":
     $sql_forumSwitch = $sql_singleForum;
     break;

    default:
     $sql_forumSwitch = $sql_allForums;
     break;
   }

}
else
{
 $sql_forumSwitch = $sql_allForums;
}

$recent_topics_sql='SELECT a.topic_id, a.topic_title'.$sql_nameForum.', a.topic_time, b.username, b.user_timezone FROM '.phpbb_topics .' a, '.phpbb_users .'  b, '.phpbb_posts.' c, '.phpbb_forums.' d WHERE a.topic_last_post_id=c.post_id and b.user_id=c.poster_id '.$sql_forumSwitch.' AND d.forum_id=a.forum_id AND d.auth_read=0 ORDER BY topic_last_post_id DESC LIMIT '.$reclim;

$recent_topics = $db->sql_query($recent_topics_sql);
$get_forumNameQuery = $db->sql_query($recent_topics_sql);

switch ($allForums_check) 
 {
  case 0:
   $get_forumName = $db->sql_fetchrow($get_forumNameQuery);
   $rss_forumName = $get_forumName['forum_name'];
   break;

  case 1:
   $rss_forumName = $allForums;
   break;

  default:
   $rss_forumName = $allForums;
   break;
 }


$date = date("m/d/Y; G:i:s A T");

$rss_title = "".$board_config['sitename']." Forum's Syndication Script";
$website_url = "http://".$board_config['server_name']."".$board_config['script_path']."".append_sid("index.".$phpEx)."";
$home_url = "http://".$board_config['server_name']."".$board_config['script_path']."";

print ("<?xml version=\"1.0\" ?>\n\n");
print ("<!--  RSS generated by ". htmlentities($rss_title) ." on ". htmlentities($date) ."  -->\n");
print ("<rss version=\"2.0\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\">\n\n");
print ("<channel>\n");
print ("<title>". htmlentities($rss_title) ."</title>\n");
print ("<link>". htmlentities($home_url) ."</link>\n");
print ("<description>". htmlentities($rss_title)." (". htmlentities($rss_forumName) .")</description>\n");
print ("<language>en-gb</language>\n\n");

while ($line = $db->sql_fetchrow($recent_topics)){
  print ("<item>\n");
  print ("<dc:creator>". htmlentities($line['username']) ."</dc:creator>\n");
  $feeddate = create_date("m/d/Y h:i:s A", $line['topic_time'], $line['user_timezone'] );
  print ("<dc:date>". $feeddate ."</dc:date>\n");
  print ("<title>" . htmlentities($line['topic_title']) . "</title>\n");
  print ("<link>". htmlentities($home_url) ."viewtopic.".$phpEx."?t=" . htmlentities($line['topic_id']) . "</link>\n");
  print ("</item>\n\n");
} 
  
print ("</channel>\n");
print ("</rss>");

$db->sql_close();
?>