RSS feed
Snitz™ Forums 2000https://forum.snitz.com/forumTopic/Posts/69084?pagenum=1
05 November 2025, 10:21
Topic
acnescar
RSS feed
17 December 2009, 02:26
RSS feed
17 December 2009, 02:26
I have had a good look through the site for an rss feed. I see that a few have been developed but they all only hold the last post in any active topic. What I would like is an rss feed that will hold the last 100 posts on the forum by time irrespective of which topic they are in.
When trying to find an rss feed that will do this I see that a few other people have asked for the same in the threads about rss feed but have largely gone unanswered or directed towards the active topics mod which is not what I want.
Thanks
Acne
When trying to find an rss feed that will do this I see that a few other people have asked for the same in the threads about rss feed but have largely gone unanswered or directed towards the active topics mod which is not what I want.
Thanks
Acne
Replies ...
HuwR
17 December 2009, 05:18
17 December 2009, 05:18
it wouldn't really make sense to do it that way since you could end up with 100 entries that are all look the same, don't forget that ONLY topics have a title, replies do not, so how would you display them in the RSS ??
An RSS feed is for publishing frequently updated works, replies are not frequently updated it is the topics which are, so that is why the RSS deals with Topics not replies.
An RSS feed is for publishing frequently updated works, replies are not frequently updated it is the topics which are, so that is why the RSS deals with Topics not replies.
acnescar
17 December 2009, 07:41
17 December 2009, 07:41
I already subscribe to a forum where the feed contains all the most recent posts. Each entry in the feed contains the information on who posted it, the topic title, the post and a time/date stamp. That way one is able open the rss reader and sort by topic and then read through all the posts in that topic that are new since the last time the rss reader was used.
At present I use windows live mail and rss bandit, when only the last post in each topic is held in the feed one reader does not update what it shows and the other reader deletes the original post and replaces it with the most recent.
I'm trying to create an rss feed where one can access it see all the posts sortable by topic,date or poster. that way one can keep up with a busy forum, in a low bandwidth way, without having to navigate around the forum website. At the end one can mark all posts as read or leave bits unread and comeback to them when time permits.
As to your question about how to display them in the rss I'm not a coder so i have no idea i just know it can be done as i use a feed that does it, albeit on a php-nuke based forum. I would like to help implement the same type of feed on a snitz forum that I have ended up trying to provide some assistance on.
Acne
At present I use windows live mail and rss bandit, when only the last post in each topic is held in the feed one reader does not update what it shows and the other reader deletes the original post and replaces it with the most recent.
I'm trying to create an rss feed where one can access it see all the posts sortable by topic,date or poster. that way one can keep up with a busy forum, in a low bandwidth way, without having to navigate around the forum website. At the end one can mark all posts as read or leave bits unread and comeback to them when time permits.
As to your question about how to display them in the rss I'm not a coder so i have no idea i just know it can be done as i use a feed that does it, albeit on a php-nuke based forum. I would like to help implement the same type of feed on a snitz forum that I have ended up trying to provide some assistance on.
Acne
HuwR
17 December 2009, 08:38
17 December 2009, 08:38
ok, should be fairly simple to mod one of the existing rss ods to do that. I should have some free time over christmas so I will sort one out for you
acnescar
17 December 2009, 08:48
17 December 2009, 08:48
Wow really? Thanks very much, thats incredible. dunno what to say
Acne
Acne
HuwR
18 December 2009, 14:28
18 December 2009, 14:28
Is this roughly what you were looking for for http://forum.snitz.com/forum/rssfeed2.asp
acnescar
19 December 2009, 14:30
19 December 2009, 14:30
wow that looks exactly like what I asked for. How cool is that?
Many thanks.
Acne
Many thanks.
Acne
Davio
19 December 2009, 15:29
19 December 2009, 15:29
Way to go Huw! 
The time stamp for each post are all set to 7:00pm. Intended? Mistake?
The time stamp for each post are all set to 7:00pm. Intended? Mistake?
acnescar
19 December 2009, 17:26
19 December 2009, 17:26
i see everything posted on my rss reader showing the same time as the forum here. which is about 7hrs different to my local time, is that what you mean?
oh how i love seeing all the forum posts on my rss reader as they come through...
Acne
edit actually its 5 hrs for me.
oh how i love seeing all the forum posts on my rss reader as they come through...
Acne
edit actually its 5 hrs for me.
HuwR
20 December 2009, 04:40
20 December 2009, 04:40
time stamps al work fine for me, what browser/reader you using Davio ?
HuwR
20 December 2009, 05:03
20 December 2009, 05:03
try the feed now Davio, I have changed it to use an rfc-822 compliant date format so it should display in your own timezone now.
HuwR
20 December 2009, 05:27
20 December 2009, 05:27
here is a copy of the file rssfeed
I can not guarentee that this will work on anything other than an MS SQL database
you will need to set 2 values which are near the top of the file, below the copyright and includes,they are.
intResults = 25
TimeZoneOffset="-0500"
intResults is the number of posts to fetch. TimeZoneOffset should be set to the same as your forum time offset, for example here the offset is -5 so the TimeZoneOffset is "-0500", if yours was +3 TimeZoneOffset would be "+0300".
you will need to set 2 values which are near the top of the file, below the copyright and includes,they are.
intResults = 25
TimeZoneOffset="-0500"
intResults is the number of posts to fetch. TimeZoneOffset should be set to the same as your forum time offset, for example here the offset is -5 so the TimeZoneOffset is "-0500", if yours was +3 TimeZoneOffset would be "+0300".
HuwR
20 December 2009, 05:30
20 December 2009, 05:30
I set up the feed so that it can be filtered by forum_category, but if you would prefer that it could be filtered by forums instead let me know (you can't have both I'm afraid)
acnescar
20 December 2009, 05:46
20 December 2009, 05:46
It looks perfect now thank you so much. I'll direct our website tinkerer here now so he can find the file and resolve any queries he may have.
Again many thanks
Nigel
Again many thanks
Nigel
AnonJr
20 December 2009, 07:58
20 December 2009, 07:58
Very nice Huw.
AnonJr
28 December 2009, 15:40
The following SQL works (so far, in limited testing) on Access and MS SQL Server 2005.
Correct me if I'm wrong, but wouldn't it just be the "TOP " sections that would need to be changed to make it work on MySQL?
28 December 2009, 15:40
Originally posted by HuwR
here is a copy of the file rssfeed I can not guarentee that this will work on anything other than an MS SQL database
The following SQL works (so far, in limited testing) on Access and MS SQL Server 2005.
Code:
strSql = "SELECT TOP " & intResults
strSql = strSql & " TopicId, ReplyId, Author, PageCounter, Title, Descript, PostDate, Category "
strSql = strSql & "FROM "
strSql = strSql & "(SELECT TOP 100 PERCENT "
strSql = strSql & "C.CAT_NAME AS Category, "
strSql = strSql & "R.TOPIC_ID AS TopicId, "
strSql = strSql & "R.REPLY_ID AS ReplyId, "
strSql = strSql & "M.M_NAME AS Author, "
strSql = strSql & "T.T_REPLIES AS PageCounter, "
strSql = strSql & "T.T_SUBJECT AS Title, "
strSql = strSql & "R.R_MESSAGE AS Descript, "
Select Case strDBType
case "sqlserver", "mysql"
strSql = strSql & "COALESCE(R.R_LAST_EDIT, R.R_DATE) AS PostDate "
case "access"
strSql = strSql & "IIf(R.R_LAST_EDIT, R.R_DATE) AS PostDate "
End Select
strSql = strSql & "FROM (((" & strTablePrefix & "REPLY R "
strSql = strSql & "INNER JOIN " & strTablePrefix & "TOPICS T ON R.TOPIC_ID = T.TOPIC_ID) "
strSql = strSql & "INNER JOIN " & strTablePrefix & "FORUM F ON R.FORUM_ID = F.FORUM_ID) "
strSql = strSql & "INNER JOIN " & strMemberTablePrefix & "MEMBERS M ON R.R_AUTHOR = M.MEMBER_ID) "
strSql = strSql & "INNER JOIN " & strTablePrefix & "CATEGORY C ON R.CAT_ID = C.CAT_ID "
strSql = strSql & "WHERE (F.F_PRIVATEFORUMS = 0) AND T.T_STATUS=1 "
strSql = strSql & "UNION ALL "
strSql = strSql & "SELECT TOP 100 PERCENT "
strSql = strSql & "C.CAT_NAME AS Category, "
strSql = strSql & "T.TOPIC_ID AS TopicId, "
strSql = strSql & "(-1) AS ReplyId, "
strSql = strSql & "M.M_NAME AS Author, "
strSql = strSql & "T.T_REPLIES AS PageCounter, "
strSql = strSql & "T.T_SUBJECT AS Title, "
strSql = strSql & "T.T_MESSAGE AS Descript,"
strSql = strSql & "T.T_DATE AS PostDate "
strSql = strSql & "FROM ((" & strTablePrefix & "TOPICS T "
strSql = strSql & "INNER JOIN " & strTablePrefix & "FORUM F ON T.FORUM_ID = F.FORUM_ID) "
strSql = strSql & "INNER JOIN " & strMemberTablePrefix & "MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID) "
strSql = strSql & "INNER JOIN " & strTablePrefix & "CATEGORY C ON T.CAT_ID = C.CAT_ID "
strSql = strSql & "WHERE (F.F_PRIVATEFORUMS = 0) AND T.T_STATUS=1 "
strSql = strSql & "ORDER BY PostDate DESC "
strSql = strSql & ") AS Posts "
strSql = strSql & "ORDER BY PostDate DESC;"Correct me if I'm wrong, but wouldn't it just be the "TOP " sections that would need to be changed to make it work on MySQL?
acnescar
01 March 2010, 14:50
01 March 2010, 14:50
This rss feed has been working perfectly on our forum now for a while - so thank you very much all those who assisted here.
Today I noticed that one thread was being ommited - not just one post but the whole thread. The Thread was titled "DVDs 3 for £10!!" Is it possible the use of the £ or the !! is somehow causing the problem or should i shutup before I demonstrate any further how little i know about any of this?
Thanks
Acne
Today I noticed that one thread was being ommited - not just one post but the whole thread. The Thread was titled "DVDs 3 for £10!!" Is it possible the use of the £ or the !! is somehow causing the problem or should i shutup before I demonstrate any further how little i know about any of this?
Thanks
Acne
HuwR
01 March 2010, 16:56
01 March 2010, 16:56
It appeared in my RSS feed, although has since been deleted from the forum
bobby131313
01 March 2010, 17:22
01 March 2010, 17:22
I had some issues with it breaking my feed. I put "£" in my bad word filter and changed it to "£" and it's fixed it so far.
Mr Pink
06 September 2010, 09:02
06 September 2010, 09:02
I've been using this feed for a few months without any problems but I have just moved my forum to a new host and changed the forum path. Now when I use Google Reader it shows the feed but goes to an invalid path when I click on it. I've tried looking at it in IE and it goes to the correct path.
Here's and example
Link from google reader
http://forum.leylandtown.info/forum/topic.asp?whichpage=-1&TOPIC_ID=3595&REPLY_ID=45876
Correct link
http://forum.leylandtown.info/topic.asp?whichpage=-1&TOPIC_ID=3595&REPLY_ID=45876
Here's and example
Link from google reader
http://forum.leylandtown.info/forum/topic.asp?whichpage=-1&TOPIC_ID=3595&REPLY_ID=45876
Correct link
http://forum.leylandtown.info/topic.asp?whichpage=-1&TOPIC_ID=3595&REPLY_ID=45876