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:
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 :

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 ;
Now I've got the 'array', let's call it myFeeds
The second query pulls the URL's from the FEEDS table.
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. <