Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 RSS feed

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
acnescar Posted - 17 December 2009 : 02:26:11
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
15   L A T E S T    R E P L I E S    (Newest First)
Mr Pink Posted - 06 September 2010 : 09:02:30
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
bobby131313 Posted - 01 March 2010 : 17:22:03
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.
HuwR Posted - 01 March 2010 : 16:56:47
It appeared in my RSS feed, although has since been deleted from the forum
acnescar Posted - 01 March 2010 : 14:50:57
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
AnonJr Posted - 28 December 2009 : 15:40:40
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?
AnonJr Posted - 20 December 2009 : 07:58:03
Very nice Huw.
acnescar Posted - 20 December 2009 : 05:46:59
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
HuwR Posted - 20 December 2009 : 05:30:13
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)
HuwR Posted - 20 December 2009 : 05:27:26
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".
HuwR Posted - 20 December 2009 : 05:03:13
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 Posted - 20 December 2009 : 04:40:18
time stamps al work fine for me, what browser/reader you using Davio ?
acnescar Posted - 19 December 2009 : 17:26:47
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.
Davio Posted - 19 December 2009 : 15:29:15
Way to go Huw!

The time stamp for each post are all set to 7:00pm. Intended? Mistake?
acnescar Posted - 19 December 2009 : 14:30:01
wow that looks exactly like what I asked for. How cool is that?

Many thanks.

Acne
HuwR Posted - 18 December 2009 : 14:28:47
Is this roughly what you were looking for for http://forum.snitz.com/forum/rssfeed2.asp

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07