load("rss"); if($mybb->input['timeoffset']) { $mybb->settings['timezoneoffset'] = $mybb->input['timeoffset']; } $unviewable = getunviewableforums(); if($unviewable) { $unviewable = "AND f.fid NOT IN($unviewable)"; } if(trim($mybb->input['fid']) > 0) { $forums = explode(",", $mybb->input['fid']); $fidq = "'-1'"; foreach($forums as $fid) { $fidq .= ",'".intval($fid)."'"; } $forumlist = "AND f.fid IN ($fidq) $unviewable"; $query = $db->query("SELECT * FROM ".TABLE_PREFIX."forums f WHERE 1=1 $forumlist"); $comma = " - "; while($forum = $db->fetch_array($query)) { $title .= $comma.$forum['name']; $forumcache[$forum['fid']] = $forum; $comma = ", "; } } $title = htmlentities($mybb->settings['bbname'].$title); $mybb->input['limit'] = intval($mybb->input['limit']); if($mybb->input['limit'] < 1 || !$mybb->input['limit'] || $mybb->input['limit'] > 50) { $mybb->input['limit'] = 15; } if($mybb->input['type'] == "rss2") { $mybb->input['type'] = "rss2.0"; } switch($mybb->input['type']) { case "rss2.0": header("Content-Type: text/xml"); echo "\n"; echo "\n"; echo "\t\n"; echo "\t\t\n"; echo "\t\t".$mybb->settings['bburl']."\n"; echo "\t\tsettings['bbname']." - ".$mybb->settings['bburl']."]]>\n"; echo "\t\tMyBB\n"; break; default: header("Content-Type: text/xml"); echo "\n"; echo "\n"; echo "\t\n"; echo "\t\t\n"; echo "\t\t".$mybb->settings['bburl']."\n"; echo "\t\tsettings['bbname']." - ".$mybb->settings['bburl']."]]>\n"; echo "\t\ten\n"; break; } $query = $db->query("SELECT t.*, f.name AS forumname, p.message AS postmessage FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=t.fid) LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=t.firstpost) WHERE 1=1 $forumlist $unviewable AND t.visible='1' ORDER BY t.dateline DESC LIMIT 0, ".$mybb->input['limit']); while($thread = $db->fetch_array($query)) { $thread['subject'] = htmlspecialchars_uni($thread['subject']); $thread['forumname'] = htmlspecialchars_uni($thread['forumname']); $postdate = mydate($mybb->settings['dateformat'], $thread['dateline'], "", 0); $posttime = mydate($mybb->settings['timeformat'], $thread['dateline'], "", 0); $thread['postmessage'] = nl2br(htmlspecialchars_uni($thread['postmessage'])); $pubdate = mydate("r", $thread['dateline'], "", 0); switch($mybb->input['type']) { case "rss2.0"; echo "\t\t\n"; echo "\t\t\t".$mybb->settings['bburl']."/showthread.php?tid=".$thread['tid']."&action=newpost\n"; echo "\t\t\t\n"; echo "\t\t\t".$thread['username']."\n"; $description = htmlspecialchars($lang->forum." ".$thread['forumname']."\r\n
".$lang->posted_by." ".$thread['username']." ".$lang->on." ".$postdate." ".$posttime); if($thread['postmessage']) { $description .= "\n
".$thread['postmessage']; } echo "\t\t\t"; echo "\t\t\t".$mybb->settings['bburl']."/showthread.php?tid=".$thread['tid']."&action=newpost\n"; echo "\t\t\tsettings['bburl']."/forumdisplay.php?fid=".$thread['fid']."\">".$thread['forumname']."\n"; echo "\t\t\t".$pubdate."\n"; echo "\t\t\n"; break; default: echo "\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t".$thread['username']."\n"; $description = htmlspecialchars($lang->forum." ".$thread['forumname']."\r\n
".$lang->posted_by." ".$thread['username']." ".$lang->on." ".$postdate." ".$posttime); if($thread['postmessage']) { $description .= "\n
".$thread['postmessage']; } echo "\t\t\t"; echo "\t\t\t".$mybb->settings['bburl']."/showthread.php?tid=".$thread['tid']."&action=newpost\n"; echo "\t\t\n"; break; } } switch($mybb->input['type']) { case "rss2.0": echo "\t\n"; echo " \n"; break; default: echo "\t\n"; echo " \n"; break; } ?>