| T O P I C R E V I E W |
| MarcelG |
Posted - 12 July 2005 : 04:51:51
I'm trying to design a mod that enables a 'bloglines' like facility for registered members.
The idea that I'm having is this:
- Create a new table in the db, called FORUM_FEEDS, where the ID, URL and NAME of the RSS feeds are stored.
For instance:
FEED_ID, FEED_URL, FEED_NAME
1 , http://forum.snitz.com/rssfeed.asp , Snitz Forums 2000
2 , http://news.bbc.co.uk/rss/newsonline_world_edition/front_page/rss091.xml , BBC World News
Etc etc.
Let's assume that this list is filled with 40+ feeds.
Now, I want to enable each member to select a maximum of 10 feeds from that central list, in a page called 'my_feeds_edit.asp'.
At first I thought I'd take the Avatar mod as the base for this mod, but I see that the Avatar mod stores the actual avatar_url in the members table, instead of the reference to the avatar_id.
Using that route would mean that I'd have to add at least 10 columns to the members table, but that's not what I want to do.
Instead, I want to add only 1 field, called MEMBERS.M_FEEDS, where I want to store the FEED_ID's, in this format :
1,4,5,8,21,34,28,12,14,17
Then, finally, I create a page called my_feeds.asp, where one sees the RSS Feeds displayed in the forum layout.
I already have a piece of code to display the feeds.
I think I need to pull the feeds via this query ;
strSqL = "SELECT M_FEEDS "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "FEEDS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'"
Now I've got the 'array', let's call it myFeeds
The second query pulls the URL's from the FEEDS table.
strSql = "SELECT FEED_URL, FEED_NAME "
strSql = strSql & "FROM " & strTablePrefix & "FEEDS "
strSql = strSql & "WHERE " & strTablePrefix & "FEEDS.FEED_ID IN (" & myFeeds & ") "
Perhaps, these two queries above can be put together in one query.. 
After this, I can loop through the feeds, and display them one by one.
So, the general idea is there, but perhaps someone has some other ideas about this, or is willing to work together on this mod.  < |
| 15 L A T E S T R E P L I E S (Newest First) |
| blackinwhite |
Posted - 29 October 2006 : 07:46:52
it works great in terms of functionality. But whole code must be taken care of in terms of tidiness.
thanks man for the initiative.< |
| Bassman |
Posted - 24 April 2006 : 10:44:06
Yep i did, also there are a couple of includes in there we do not have like _spacer and _sidebar.< |
| MarcelG |
Posted - 24 April 2006 : 09:57:21
Mmm...bummer. Have you ran the dbs ?< |
| Bassman |
Posted - 24 April 2006 : 09:45:13
Treid to on my test forum, I keep getting _MFEEDS errors and a lots of JET's< |
| MarcelG |
Posted - 24 April 2006 : 08:13:14
Etymon, have you tried to isntall it yet ? Just curious.< |
| Etymon |
Posted - 23 April 2006 : 12:28:03
Marcel meant to post a link to his own board ...
Subject: Member Feeds
Download URL: http://oxle.nl/topic.asp?tid=3751< |
| MarcelG |
Posted - 08 April 2006 : 08:16:02
Nope, I never came to posting this mod as a base-install-compatible mod.
However, triggered by you, I decided to take all the files and put them in one zip file. You can find that one here.
Be aware ; this is not a complete mod. It has no readme, it has no documentation and it has not been tested outside oxle.
Feel free to use it as you please!
For support, just post your questions at oxle, or here.
quote:
Originally posted by Zeus
Did this mod ever get posted anywhere. The above links get you most of it, but you cant access the admin_feeds.asp (even when logged into oxle)
Thanks in advance!
Zeus
< |
| Zeus |
Posted - 07 April 2006 : 15:38:21
Did this mod ever get posted anywhere. The above links get you most of it, but you cant access the admin_feeds.asp (even when logged into oxle)
Thanks in advance!
Zeus< |
| jeffery |
Posted - 03 August 2005 : 16:12:56
Scratch that, it was not inserting from the sub newForumModerators() because MFEED_ORDER is set to not allow NULLS but I didn't know it wasn't because of the 'on error resume next' in the function.< |
| jeffery |
Posted - 03 August 2005 : 15:11:33
Hi marcelgoertz. I'm testing this using MSSQL. Fist thing is I'm not seeing the javascript:limitOptions code in conf.asp. I'm wondering if this is why it is not keeping the chosen feeds. If I manually put entries in the database field MFEED they are deleted when I submit conf.asp, I am assuming because of the sub updateForumModerators(). But the sub newForumModerators() is not entering any new data. Otherwise the code seems to be working. I am able to use admin_feeds.asp to submit new available feeds. I guess it's maxselect.js that I need.< |
| MarcelG |
Posted - 03 August 2005 : 05:11:39
The current code is not ready to be used on default Snitz forums.
I will however focus on releasing this entire system as a mod for Snitz, but, not until after my holiday.
So, after August 23rd I'll get busy with it ; I guess I need about 2 days to finish it then, excluding these features: - Member defined sorting of selected feeds
- 'personal' feeds (e.g. only available to that member, and not to the entire memberlist)
Feel free to have a look at the current code, but be aware that it needs some tweaking to get it to work on default Snitz. (source accessible to registered members of oxle, use demo/demo if you don't want to register)
Here's the DBS file:
Members RSS Feeds Mod for 3.4
[CREATE]
FEEDS
FEED_ID
FEED_URL#varchar(255)#NULL#
FEED_NAME#varchar(50)#NULL#
FEED_REFRESH#varchar(20)#NULL#
[END]
[CREATE]
MFEEDS
MFEED_ID#int#NULL#0
MEMBER_ID##NULL#0
MFEED_ORDER##NULL#0
[END]
This already provides the db field for the custom ordering.
Just save it as dbs_feeds.asp in your forum folder, and go to the Mod Setup.
Be sure to backup your DB!!!< |
| NiteOwl |
Posted - 03 August 2005 : 04:07:06
looking pretty good so far from what I can tell by testing!!! Have you got somecode to share? :)< |
| MarcelG |
Posted - 21 July 2005 : 10:25:10
[:-/] No more bumping necessary!!!!
With this step by step caching manual, I enabled 15-minute output caching just as decribed!
So, the XML feeds are only collected once every 15 minutes (at max), and processed also only once every 15 minutes.
So, the My Feeds feature is LIVE!!!! (and ready to testdrive by all of you guys!  )
Sponsoring members can select up to 20 feeds at this moment, non-sponsoring members can select up to 15 feeds.
Go ahead, and fiddle around!
Oh, you can find the direct link here, and when registered at the "my oxle" submenu on the site! [good]< |
| MarcelG |
Posted - 20 July 2005 : 07:28:56
Shaggy, perhaps this is too much too ask of you, but could you shed some light on the following:
I've incorporated some form of caching now, but it's rather buggy.
It now caches the input XML file now to a file, however, in some instances (for example the DPReview RSS feed, it gives this error:
msxml3.dll error '80004005'
Unable to save character to 'ISO-8859-1' encoding.
/inc_my_feeds.asp, line 39
This error does NOT seem to be caused by the existence of characters such as é etc, as you can see in the actual feed that gives the error when saving to cache : http://www.dpreview.com/news/dpr.rdf .. nothing strange in that feed as far as I can see.
It's not the 'usual' RSS feed, so perhaps tháts the problem.
However, I was thinking of the following ; instead of caching the input, the output should be cached.
The current process is this ;
This process has two flaws:
- The save-action fails on several feeds (as described above).
- Processing of the XML file is done on every reload of the page, even when the cache is used. This only caches the XML file, saving a HTTPRequest, but not saving the looping through the arrays.
Therefore I'd like to apply this process instead:
Now, the output is cached, and only in case the output is outdated, the whole cycle starts of again, including the HTTPRequest ánd the looping through the arrays.
So, in theory I know what to do. But....I cannot seem to get all the outputdata into one variable...it seems that the data collected within the FOR ... NEXT loops isn't added to the variable. This function is within this file : inc_my_feed.asp (login demo/demo)< |
| Shaggy |
Posted - 20 July 2005 : 04:37:04
Try switching to UTF encoding and see if that helps although I've never come across any problems using those 2 chracters you mentioned in ISO-8859-1.
< |
|
|
