Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 RSS feed		  New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

acnescar
Starting Member

United Kingdom
7 Posts
Posted - 17 December 2009 :  02:26:11  Show Profile  Reply with Quote
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

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 17 December 2009 :  05:18:46  Show Profile  Visit HuwR's Homepage  Reply with Quote
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.
Go to Top of Page

acnescar
Starting Member

United Kingdom
7 Posts
Posted - 17 December 2009 :  07:41:33  Show Profile  Reply with Quote
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
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 17 December 2009 :  08:38:55  Show Profile  Visit HuwR's Homepage  Reply with Quote
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
Go to Top of Page

acnescar
Starting Member

United Kingdom
7 Posts
Posted - 17 December 2009 :  08:48:16  Show Profile  Reply with Quote
Wow really? Thanks very much, thats incredible. dunno what to say

Acne
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 18 December 2009 :  14:28:47  Show Profile  Visit HuwR's Homepage  Reply with Quote
Is this roughly what you were looking for for http://forum.snitz.com/forum/rssfeed2.asp
Go to Top of Page

acnescar
Starting Member

United Kingdom
7 Posts
Posted - 19 December 2009 :  14:30:01  Show Profile  Reply with Quote
wow that looks exactly like what I asked for. How cool is that?

Many thanks.

Acne
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 19 December 2009 :  15:29:15  Show Profile  Reply with Quote
Way to go Huw!

The time stamp for each post are all set to 7:00pm. Intended? Mistake?
Support Snitz Forums
Edited by - Davio on 19 December 2009 15:29:28
Go to Top of Page

acnescar
Starting Member

United Kingdom
7 Posts
Posted - 19 December 2009 :  17:26:47  Show Profile  Reply with Quote
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.
Edited by - acnescar on 19 December 2009 17:28:04
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 December 2009 :  04:40:18  Show Profile  Visit HuwR's Homepage  Reply with Quote
time stamps al work fine for me, what browser/reader you using Davio ?
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 December 2009 :  05:03:13  Show Profile  Visit HuwR's Homepage  Reply with Quote
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.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 December 2009 :  05:27:26  Show Profile  Visit HuwR's Homepage  Reply with Quote
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".
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 December 2009 :  05:30:13  Show Profile  Visit HuwR's Homepage  Reply with Quote
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)
Go to Top of Page

acnescar
Starting Member

United Kingdom
7 Posts
Posted - 20 December 2009 :  05:46:59  Show Profile  Reply with Quote
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
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 20 December 2009 :  07:58:03  Show Profile  Visit AnonJr's Homepage  Reply with Quote
Very nice Huw.
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 28 December 2009 :  15:40:40  Show Profile  Visit AnonJr's Homepage  Reply with Quote
quote:
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. 

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?
Edited by - AnonJr on 28 December 2009 15:49:40
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07