| Author |
 Topic  |
|
wildfiction
Junior Member
167 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
kensalter
Starting Member
USA
3 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
 Posted - 10 April 2005 : 10:17:29
|
Nice work!
But...if I validate it, it still gives me lots of 'errors'... (even some more than with my version...) SharpReader works fine with it btw.
I'm now trying to migrate my 'headlines.asp' to your version.< |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 10 April 2005 10:23:32 |
 |
|
|
wildfiction
Junior Member
167 Posts |
Posted - 11 April 2005 : 08:50:21
|
quote:
Originally posted by marcelgoertz
if I validate it, it still gives me lots of 'errors'... (even some more than with my version...) SharpReader works fine with it btw.
I'm now trying to migrate my 'headlines.asp' to your version.
What does the headlines.asp file do - with respect to RSS?
Also, Ken or Marcel: will there be any changes in the near future in an attempt to address some of the validation errors? If so, I won't install that version but wait for the next, otherwise I'll go ahead and install ken's RSS 2.0 file.
Thanks for the time and effort that you guys are putting into this. It is much appreciated.
< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 11 April 2005 : 13:33:14
|
Wildfiction ; I've upgraded to Ken's version, so I guess this topic should be locked, and replaced by Ken's RSS mod!  Works as a charm!
I haven't converted headlines.asp yet, but that's something that will follow soon.
FYI ; the headlines.asp takes the topics from my Frontpage forum and linkdump forum, and puts them in a seperate RSS feed. It displays the contents of each (starting)post, and not the last reply. So, more or less a 'news'-rss feed.< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
wildfiction
Junior Member
167 Posts |
Posted - 12 April 2005 : 09:28:22
|
| thanks for the info marcel and thanks again for the update ken :) - i'll be installing it shortly.< |
|
|
|
wildfiction
Junior Member
167 Posts |
Posted - 13 April 2005 : 06:22:16
|
quote:
Originally posted by kensalter
quote:
Originally posted by wildfiction
Many thanks marcel for the code and ken for the extra mod. I've added it to my forum:
http://emini.deltat1.com/forum/default.asp
Regards,
Guy
I have made a new update:
1) conforms to RSS version 2.0 (previous was 0.92)
2) adds the text of replies to a topic to the feed
Same link as before to download:
http://www.kensalter.com/downloads/rss.zip
I can't see any difference in this new RSS.ASP file. Can I confirm that the date stamp on the RSS.ASP (inside the zip) file should be 19 March 2005?< |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 20 June 2005 : 22:23:16
|
Marcel - Since the code on your site appears to be using he "Ken" code does this indicate that we no longer need to define timezones or images?
I am sorry but I am slightly confused as how to install.
< |
-=NiteOwl=-
|
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 20 June 2005 : 22:57:14
|
quote:
Originally posted by modification
For who has a Mysql db:
Change the lines from 48 to 69 with these:
strSql = "SELECT "
---- Original message cut here-----
strSql = strSql & " LIMIT " & intResults
set rs = Server.CreateObject("ADODB.Recordset")
Look to the corresponding lines, if tyhere are some little variations in numeration.
So it's working in MySql
The variation is the elimination of TOP in the select statement, and the adding of the LIMIT value to select the last post.
I have made the following changes, however I still get this error, BTW this is using the only code I can find which is provided by Ken and Marcel.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
strSql = "SELECT " & intResults
strSql = strSql & " T.T_REPLIES,"
strSql = strSql & " T.T_SUBJECT,"
strSql = strSql & " T.TOPIC_ID,"
strSql = strSql & " T.T_LAST_POST,"
strSql = strSql & " T.T_LAST_POST_AUTHOR,"
strSql = strSql & " T.T_LAST_POST_REPLY_ID,"
strSql = strSql & " T.T_MESSAGE,"
strSql = strSql & " F.F_SUBJECT,"
strSql = strSql & " R.R_MESSAGE "
strSql = strSql & "FROM (FORUM_TOPICS T INNER JOIN FORUM_FORUM F ON T.FORUM_ID = F.FORUM_ID) LEFT JOIN FORUM_REPLY R ON T.T_LAST_POST_REPLY_ID = R.REPLY_ID"
'strSql = strSql & " FROM " & strTablePrefix & "TOPICS T," & strTablePrefix & "FORUM F," & strTablePrefix & "REPLY R"
'strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID"
'strSql = strSql & " AND R.REPLY_ID = T.T_LAST_POST_REPLY_ID "
strSql = strSql & " WHERE (F.F_PRIVATEFORUMS = 0 OR F.F_PRIVATEFORUMS = 4) "
if Request.QueryString("FORUM_ID") <> "" then
strSql = strSql & " AND T.FORUM_ID = " & cLng(Request.QueryString("FORUM_ID"))
end if
if Request.QueryString("CAT_ID") <> "" then
strSql = strSql & " AND T.CAT_ID = " & cLng(Request.QueryString("CAT_ID"))
end if
strSql = strSql & " AND T.T_STATUS <= 1"
strSql = strSql & " ORDER BY T_LAST_POST DESC"
strSql = strSql & " LIMIT " & intResults
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
I receive this error:
[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.T_REPLIES, T.T_SUBJECT, T.TOPIC_ID, T.T_LAST_POST, T.T_LAST_PO
/CIMarE/forum/rss.asp, line 92
< |
-=NiteOwl=-
|
Edited by - NiteOwl on 22 June 2005 16:25:24 |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 21 June 2005 : 04:35:49
|
quote:
Originally posted by NiteOwl
Marcel - Since the code on your site appears to be using he "Ken" code does this indicate that we no longer need to define timezones or images?
I am sorry but I am slightly confused as how to install.
Yes you still need to define the timezone. Check the function Date2RFC822(Date2Convert); more specifically these lines:
' define your timezone offset below. Examples : "+0100" for GMT+1, "EST", "GMT"
rfc822timezone = " +0200"
The images need to be defined here:
xml = xml & "<title>" & strNewTitle & "</title>"
xml = xml & "<link>" & strForumURL & "</link>"
xml = xml & "<description>" & strForumTitle & "</description>"
xml = xml & "<image2>" & strForumURL & "images/oxlerss.gif</image2>"
xml = xml & "<image>"
xml = xml & "<link>" & strForumURL & strHomeURL & "</link>"
xml = xml & "<url>" & strForumURL & "images/oxlerss.gif</url>"
For the MySQL error; I'm afraid I cannot help you; my MySQL knowledge is zero...
< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 21 June 2005 : 09:32:41
|
Thanks Marcel! I have also sent an email to modifichicci asking if he could review the MySQL code for me. - Fingers are crossed.
BTW - What if one does not have any timezone offset, would entering 0000 be acceptable?
< |
-=NiteOwl=-
|
Edited by - NiteOwl on 21 June 2005 09:34:21 |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 21 June 2005 : 10:05:08
|
NiteOwl ;
The timezone offset that should be used is defined in RFC-822 ;
zone = "UT" / "GMT" ; Universal Time
; North American : UT
/ "EST" / "EDT" ; Eastern: - 5/ - 4
/ "CST" / "CDT" ; Central: - 6/ - 5
/ "MST" / "MDT" ; Mountain: - 7/ - 6
/ "PST" / "PDT" ; Pacific: - 8/ - 7
/ 1ALPHA ; Military: Z = UT;
; A:-1; (J not used)
; M:-12; N:+1; Y:+12
/ ( ("+" / "-") 4DIGIT ) ; Local differential
Here are examples of valid RFC822 dates:
<pubDate>Wed, 02 Oct 2002 08:00:00 EST</pubDate>
<pubDate>Wed, 02 Oct 2002 13:00:00 GMT</pubDate>
<pubDate>Wed, 02 Oct 2002 15:00:00 +0200</pubDate>
So, in *all* cases you should have a timezone offset, whether it's EST, GMT, or +200< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 21 June 2005 : 22:45:15
|
Thanks Marcel, that helps a lot!
Now I just have to get the MySQL fixed up and I am away to the races,
any help or suggestions would be greatly appreciated.
< |
-=NiteOwl=-
|
Edited by - NiteOwl on 22 June 2005 16:23:46 |
|
|
|
hans_
Junior Member
Czech Republic
161 Posts |
Posted - 22 June 2005 : 14:44:07
|
Great and how simple to use it!
quote:
Originally posted by marcelgoertz
I've been tuning the rss-feed functionality, and have come up with a RSS feed that should run on virtually all Snitz fora.
Installation ; very very very easy.
21-12-2004 ; Initial version, tested at oxle.com.
22-12-2004 ; Version 1.1, working at oxle.com.
18-01-2005 ; Version 1.2, working at oxle.com.
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
How to install:
Copy the code below, and save it as RSS.ASP
View source of RSS.ASP (login required, use user: demo, password demo if you're a guest)
The image
Create an image of your own, and save it as RSS.GIF.
Be sure to adjust lines 122 and 123 to make it fit:
xml = xml & "<width>128</width>"
xml = xml & "<height>29</height>"
The Timezone
Be sure to adjust lines 154 and 155 to select the correct timezone of your forum:
' define your timezone offset below. Examples : "+0100" for GMT+1, "EST", "GMT"
rfc822timezone = " +0100"
That's all.
Examples:
http://www.oxle.com/rss.asp
http://www.oxle.com/rss.asp?cat_id=14
http://www.oxle.com/bevers/rss.asp (with different LCID, showing that the RFC822 formatting does work)
Enjoy. Any improvements/suggestions are very welcome!
BTW ; food for thought ; should 'views' by RSS feed be counted as a topic-view ? (so, increase viewcount ???)
Support -> this topic: http://www.oxle.com/topic.asp?TOPIC_ID=1865
Update 18-1-2005 Updated version, fixed some bugs.
< |
I am still learning.
Sorry for my stupid questions (sometimes) and bad English. |
Edited by - hans_ on 22 June 2005 23:51:57 |
|
|
|
Topic |
|
RSS Feed (by forum & by cat)
