RSS Injector available

Started by confusion, December 24, 2005, 04:04:48 PM

Previous topic - Next topic

Xarcell

That was another thing I overlooked. Sorry... I did get it working properly though, thanks!

I feel dumb today.

Also, is there anyway to modify it so that it select a certain post icon, instead of the default "note" one? That would be a nice feature.

EDIT: yep, it's pretty easy to install, just gotta pay attention, lol...


Xarcell

#261
I also intend to run multiple feeds, to different boards. Should I create different tables for each with the proper sql, or can I add another row to the insert with the proper board id?

I also noticed that the post text is really small. Anyway to modify this?

edit:

I added this to the sql file for import:


INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (2, 2, 3, 'http://rss.teamxbox.com/news/latest.rss', 1157028360);# Affected rows: 1


It seems to work as well.

jkrlvgn

Just add another row, and just change the board ID (if posting to another board), I think.

Xarcell

Ya, it seems to work beautifully. Nice to see a rss injector that works with my host.

TLM

To change how it looks, its in the code, look for the bbc tag [ p r e ],

To change the icon, its one of those options in there somewhere.

jkrlvgn

...and...from there, I'm lost.  I don't see either in the rss_injector.php file.

TLM

sorry, [ t t ]

was thinking in html not bbc.

Xarcell

#267
Which file?

Also, I'm trying to insert multiple feeds. Only 2 of 6 seem to be working. I get this error when I run the php file:

QuoteFatal error: Only variables can be passed by reference in /home/.abigaildryer/xarcell/xboxnarc.com/MagpieRSS/rss_parse.inc on line 343

Is it the feeds themselves causing that error?

Here's what I use:


INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (1, 4, 66, 'http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (2, 4, 35, 'http://rss.teamxbox.com/news/latest.rss', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (3, 4, 69, 'http://scripts.ign.com/rss/ign.Xbox360.2.0.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (4, 4, 70, 'http://www.achieve360points.com/rss.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (5, 4, 67, 'http://www.gametrailers.com/rss/newestxb360.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (6, 4, 68, 'http://www.xbox360fanboy.com/rss.xml', 1157028360);# Affected rows: 1

haktanir2

Yeah I tried it also, the sql code gives errors. Probably doesn't work on all servers.

Xarcell

Quote from: haktanir2 on September 05, 2006, 06:44:53 AM
Yeah I tried it also, the sql code gives errors. Probably doesn't work on all servers.

You may need to import the file, not edit it in the myphpadmin. If you edit it, it will give errors. You must import...

haktanir2

Quote from: Xarcell on September 05, 2006, 08:31:22 AM
Quote from: haktanir2 on September 05, 2006, 06:44:53 AM
Yeah I tried it also, the sql code gives errors. Probably doesn't work on all servers.

You may need to import the file, not edit it in the myphpadmin. If you edit it, it will give errors. You must import...
I entered the sql thing in mysql and it did not like it.

jkrlvgn

Quote from: Xarcell on September 04, 2006, 04:15:19 PM
Which file?

Also, I'm trying to insert multiple feeds. Only 2 of 6 seem to be working. I get this error when I run the php file:

QuoteFatal error: Only variables can be passed by reference in /home/.abigaildryer/xarcell/xboxnarc.com/MagpieRSS/rss_parse.inc on line 343

Is it the feeds themselves causing that error?

Here's what I use:


INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (1, 4, 66, 'http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (2, 4, 35, 'http://rss.teamxbox.com/news/latest.rss', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (3, 4, 69, 'http://scripts.ign.com/rss/ign.Xbox360.2.0.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (4, 4, 70, 'http://www.achieve360points.com/rss.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (5, 4, 67, 'http://www.gametrailers.com/rss/newestxb360.xml', 1157028360);# Affected rows: 1

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (6, 4, 68, 'http://www.xbox360fanboy.com/rss.xml', 1157028360);# Affected rows: 1


You want to make sure that the feeds are not RSS 2.0, as MagpieRSS doesn't seem to work with that....or at least, that's what I found on the website.  A few of my feeds didn't work either, but...it's the parser problem, not so much the script.

As soon as it's upgraded (and it will be, check the website), then I would recommend just uploading the updated files.

If I'm wrong, then...lemme know.


Quote from: haktanir2 on September 05, 2006, 12:46:14 PM
Quote from: Xarcell on September 05, 2006, 08:31:22 AM
Quote from: haktanir2 on September 05, 2006, 06:44:53 AM
Yeah I tried it also, the sql code gives errors. Probably doesn't work on all servers.

You may need to import the file, not edit it in the myphpadmin. If you edit it, it will give errors. You must import...
I entered the sql thing in mysql and it did not like it.

What I did, basically, was copy and paste the entire SQL into phpMyAdmin.  The only other thing you can do is try to import it, but...if you had the same problem that I did, you'll have to copy and paste directly.

TLM

#272
If the data took and was put into the DB then the next problem should be, does magpie actually parse the feed?  I have run into feeds that look right but were not and magpie barfed on them.

What you might want to do is look at the examples magpie gives you, one I think shows what magpie gets out of the feed, and test the problem four feeds to see if its a problem with the feed or the injector.

(Had a couple feeds refuse to "Inject")

Xarcell

I tried to paste the sql and got errors. I had to delete the table and import the file everytime I made changes to get it to work.

lordmenace

Is there any way to have the bot grab the ENTIRE news feed?

TLM

It depends on what the feed gives....
Some feeds only give a sentance at most, then others give the whole paragraph(s).

Now if the feed is doing both, I dunno, due to I have not encountered any like so...

Gosu Schwarz

Is anyone working on finishing this?

Ben_S

#277
Quote from: TLM on August 31, 2006, 03:22:02 PM
http://www.mindlesstux.com/rss_injector.phps
http://www.mindlesstux.com/rss_injector.sql

For those that like what I have done with mine.  You will need to get MagpieRSS and extract it to a MagpieRSS directory in your forum dir.  Then simply load the sql into the same table with your forum, and edit the feeds, I think the fields are self explanitory.  I am not going to make this into a mod, someone can if they like, but I dont have time to make a admin panel like I had before the hd crash.

Quote from: Ben_S on August 31, 2006, 02:56:38 PM
Basically if you just include SSI.php in your injector file you should be able to call createPost with the required variables. Having included SSI.php, SMF should deal with connecting to the database etc.
I think you have to include Subs-Post.php as well for it to work.  Or at least for me I did.

Thanks for that, works perfectly with the RSS feed from our blog.
Liverpool FC Forum with 14 million+ posts.

TLM


Xarcell

Anyone find what to modify to change the icon selected on the posts? I browsed through the files and didn't see anything.

Advertisement: