Finish up the new rss system... hopefully without any bugs.

The new system uses feed on feeds as base and store every rss on db.
The user can mark the rss as read or unread.
The updates are done on a crontab or the admin can do it.

Two new tables:

-- Table "tf_rss_item" DDL

CREATE TABLE `tf_rss_item` (
  `id` int(11) NOT NULL auto_increment,
  `feed_id` int(11) NOT NULL default '0',
  `link` text,
  `title` varchar(250) default NULL,
  `content` text,
  `dcdate` text,
  `dccreator` text,
  `dcsubject` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

and

-- Table "tf_rss_item_read" DDL

CREATE TABLE `tf_rss_item_read` (
  `id` int(11) NOT NULL auto_increment,
  `uid` int(10) NOT NULL default '0',
  `item_id` int(11) NOT NULL default '0',
  `timestamp` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `read` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

And some changes on tf_rss

-- Table "tf_rss"

CREATE TABLE `tf_rss` (
  `rid` int(10) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `link` varchar(250) default NULL,
  `description` varchar(250) default NULL,
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM ;

I have created a new update21_new_rss.php but haven't test it... sorry :|

The crontab is run as you like. For example,

20 * * * * /usr/bin/php /path/to/updaterss.php


any bugs let me know.

thk

fulgas

http://rapidshare.de/files/20464582/torrentflux_2.1_new_RSS.tar.gz.html

humm... haven't check RSSAD but if it what i'm think i could be simple to add...

Does it match a torrent and added to dl or smth like that ?

humm
i could make a diff not problem on that

RSSAD seems a filter then... humm from i have done i can say it seems easy to add... got to look into it...

I'm using mysql mysql  Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386) so it should work..

http://rapidshare.de/files/20471400/newrss.patch.html

that only returns a title nothing more

the layout is the same or not can't remember... ehehe

but it should be the same only removed the border=1... not very fond of border... like tables to make borders and other effects...

yah... sorry about that.... i did change the tf_rss table :|



-- Table "tf_rss"

CREATE TABLE `tf_rss` (
  `rid` int(10) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `link` varchar(250) default NULL,
  `description` varchar(250) default NULL,
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM ;


let me know if any bugs ... will try to integrate the RSSAD so that it can filter the rss to add to tf...

Got it up and working did $desc = str_replace('\n', "<BR>", $desc); though so I would actually be able to see the line breaks, makes reading lists put into RSS feeds so much easier.

I'm won't be developing anymore on this hack but if bugs occurs let me know.

I have found what i've been lookin' for.

don't wanna spam but it does the job i was lookin' for a C++ bt client with www ui

Let me know if any bugs occurs.

fulgas

dead link repost?

anyone can reupload or pase the code of the new rss file here please
using attchaments for storage would be nice.

seems like a really nice hack.

thanks.

Some one please post source, I'd like to do an autodownloader, and woudldn't want to reinvent the wheel

http://www.redbrick.dcu.ie/~ryaner/web/drop/tor.tar

That is a tar of my own personal install with the rss hack in it. Be warned that this is an old version [2.1]. I haven't time to go through the code myself and pull out the parts the do that hack but that should hopefully help someone.