| Author |
 Topic  |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
 Posted - 01 July 2005 : 06:24:47
|
Here's version 2 of the RSS feed, this time fully validated RSS v2; the improved version of this mod.
If you want an RSS feed that works with private forums, check this mod by gelliott.
Functionallity- Creates a general RSS feed for all public fora : rss.asp
- Creates a rss feed per cat, by using rss.asp?cat_id=xx
- Creates a rss feed per forum, by using rss.asp?forum_id=xx
- RSS 0.92 compliant
- Includes RFC-822-compliant dates
- Shows last post-author per topic
- Images and smilies are disabled!!!(comment lines 64 and 65 to enable them)
How to install:
Copy the code below, and save it as RSS.ASP
View source of RSS.ASP (login required, use user: demo, password demoif you're a guest, feel free to register  )
The image & Title
Create an image of your own, and save it as you want on your site, but be sure to adjust lines 151 to 154 to suit your own title and image:
xml = xml & "<url>" & strForumURL & "images/oxlerss.gif</url>" & vbNewLine
xml = xml & "<title>" & strForumTitle & " RSS Feed</title>" & vbNewLine
xml = xml & "<width>144</width>" & vbNewLine
xml = xml & "<height>47</height>" & vbNewLine
The Timezone
Be sure to adjust lines 214 to select the correct timezone of your forum:
' define your timezone offset below. Examples : " +0100" for GMT+1, "EST", "GMT"
rfc822timezone = " +0200"
That's all.
Examples:
http://www.oxle.com/rss.asp (all forums on the entire board)
http://www.oxle.com/rss.asp?cat_id=14 (all forums from the INT category)
http://www.oxle.com/rss.asp?forum_id=43 (all topics from the 'Help' forum)
Remark
The only thing I haven't found a fix for is replacing relative URL's with absolute URL's.
..if someone has a fix, it's welcome!
Enjoy. Any improvements/suggestions are very welcome!
Support -> http://www.oxle.com/topic.asp?TOPIC_ID=1865 |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 01 July 2005 07:26:07 |
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 05 July 2005 : 11:48:56
|
MySQL - Make the following changes to work with a MySQL database.
Find:
strSql = "SELECT TOP " & intResults
Replace with:
strSql = "SELECT "
Find:
strSql = strSql & " ORDER BY T_LAST_POST DESC"
Make a new, empty line below, and ADD this code:
strSql = strSql & " LIMIT 1,15"
The above code is no longer necessary as the base files have been changed and MySQL works, thanks guys!
|
-=NiteOwl=-
|
Edited by - NiteOwl on 05 July 2005 15:52:53 |
 |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 12:19:47
|
| Macrel, per NiteOwl's comments above we probably need to revise our rss.asp file to test the strDBType variable and build the SQL statement accordingly... |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 13:08:57
|
OK, I've uploaded a new file which uses the strDBType variable and incorporates Macrel's new rss.asp 2.0 standard...
http://www.snitzbitz.com/mods/details.asp?Version=&mid=209 |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 05 July 2005 : 13:22:21
|
If you're including inc_func_common.asp anywhere, there's already a function called TopSQL in there for that very purpose. Build your SQL query as normal, without using TOP or LIMIT and, then, when executing your query/opening your recordset use:
set rs=my_Conn.execute(TopSQL(strSQL))
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 13:56:05
|
Thanks Shaggy! Didn't know that! Isn't it funny how you write all these mods and play with the code for several years and still discover little nuggets of slick stuff... I'll make a note of that (although, in this case, we have no other use of inc_func_common.asp and for the sake of speed will simply do it with an if-then...).
But this prompts a general comment - thanks yet again to all the folks that put this software together - it is very well thought out and designed!  |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 05 July 2005 : 13:59:33
|
| OK, now that I'm looking at the function, it's more complex and robust than what I had, so I'll add it into our collection of RSS functions and re-upload a v1b file to SnitzBitz. Thanks for the tip Shaggy! |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 05 July 2005 : 14:50:06
|
Indeed, thanks Shaggy! Never knew that function existed!
Also updated my RSS.ASP file. |
portfolio - linkshrinker - oxle - twitter |
|
|
| |
Topic |
|
Topic Locked
