RSS Feeds for Categories, Forums, Topics and Latest Posts (Page 1 of 3)

// Make sure we (guests) have permission to read the forums
$result = $db->query('SELECT g_read_board FROM '.$db->prefix.'groups WHERE g_id=3') or error('Unable to fetch group info', __FILE__, __LINE__, $db->error());
if ($db->result($result) == '0')
    exit('No permission');

if ($pun_user['g_read_board'] == '0') 
        message($lang_common['No view'])

// hack for allowing the administrators to RSS feed every topic, forum and category
if ($pun_user['group_id']=='1') {
        $rssadm='readall=1&';
} else {
        $rssadm="";
}

<a href="rss.php?<?=$rssadm?>cid=<?php echo $cur_forum['cid'] ?>">

$result = $db->query("
        SELECT p.id AS id, p.message AS message, p.posted AS postposted, t.subject AS subject, f.forum_name, c.cat_name
        FROM ".$db->prefix."posts p
        LEFT JOIN ".$db->prefix."topics t
        ON p.topic_id=t.id
        INNER JOIN ".$db->prefix."forums AS f
        ON f.id=t.forum_id
        LEFT JOIN ".$db->prefix."categories AS c
        ON f.cat_id = c.id
        LEFT JOIN ".$db->prefix."forum_perms AS fp
        ON (
                fp.forum_id=f.id
                AND fp.group_id=3
        )
        WHERE (
                fp.read_forum IS NULL
                OR fp.read_forum=1
        )
        $where
        ORDER BY postposted DESC
        LIMIT 0,15
") or error('Unable to fetch forum posts', __FILE__, __LINE__, $db->error());;

if($readall=="1") {
$result = $db->query("
        SELECT p.id AS id, p.message AS message, p.posted AS postposted, t.subject AS subject, f.forum_name, c.cat_name
        FROM ".$db->prefix."posts p
        LEFT JOIN ".$db->prefix."topics t
        ON p.topic_id=t.id
        INNER JOIN ".$db->prefix."forums AS f
        ON f.id=t.forum_id
        LEFT JOIN ".$db->prefix."categories AS c
        ON f.cat_id = c.id
        LEFT JOIN ".$db->prefix."forum_perms AS fp
        ON (
                fp.forum_id=f.id
                AND fp.group_id=3
        )
        $where
        ORDER BY postposted DESC
        LIMIT 0,15
") or error('Unable to fetch forum posts', __FILE__, __LINE__, $db->error());;
} else {
$result = $db->query("
        SELECT p.id AS id, p.message AS message, p.posted AS postposted, t.subject AS subject, f.forum_name, c.cat_name
        FROM ".$db->prefix."posts p
        LEFT JOIN ".$db->prefix."topics t
        ON p.topic_id=t.id
        INNER JOIN ".$db->prefix."forums AS f
        ON f.id=t.forum_id
        LEFT JOIN ".$db->prefix."categories AS c
        ON f.cat_id = c.id
        LEFT JOIN ".$db->prefix."forum_perms AS fp
        ON (
                fp.forum_id=f.id
                AND fp.group_id=3
        )
        WHERE (
                fp.read_forum IS NULL
                OR fp.read_forum=1
        )
        $where
        ORDER BY postposted DESC
        LIMIT 0,15
") or error('Unable to fetch forum posts', __FILE__, __LINE__, $db->error());;
}

    $rss = "rss.php";
    $rsstype = "latest posts";
    if(strpos($_SERVER['REQUEST_URI'],"viewforum")){
        $rss .= "?forum=".$_GET['id'];
        $rsstype = "forum";
    }else if(strpos($_SERVER['REQUEST_URI'],"viewtopic")){
        $rsstype = "topic";
        if(array_key_exists('id',$_GET))
            $rss .= "?topic=".$_GET['id'] ;
        else 
            $rss = "";
    }
    if($rss) echo "<link rel=\"alternate\" type=\"application/rss+xml\" title=\"$rsstype: $page_title (RSS 2.0)\" href=\"$rss\">\n";