Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Topic started by: confusion on December 24, 2005, 04:04:48 PM

Title: RSS Injector available
Post by: confusion on December 24, 2005, 04:04:48 PM
Here's my Christmas present to the SMF community. http://www.stelesys.com/content/view/21/34/ (http://www.stelesys.com/content/view/21/34/)
This script will take an RSS feed and inject it into an SMF board as posts.
It's still somewhat crude, but it works.  Please let me know of any problems that you're having.  You can see it in action at http://www.cyvin.org (http://www.cyvin.org) under the "News" boards.

Cheers,

Jerry
Title: Re: RSS Injector available
Post by: Ben_S on December 25, 2005, 09:09:23 PM
Moved this here, will get more attention than in the "Declined or Applied Requests" board
Title: Re: RSS Injector available
Post by: dtm.exe on December 25, 2005, 10:54:13 PM
Nice.  What versions of SMF does it work with?
Title: Re: RSS Injector available
Post by: confusion on December 25, 2005, 11:26:46 PM
I've tried it with 1.1rc2.  I can't say if it works on earlier versions.  If it doesn't, it should be a quick fix to get it to work.

Jerry
Title: Re: RSS Injector available
Post by: JayBachatero on December 25, 2005, 11:33:24 PM
A quick questions.  How did you manage to get a hold of 1.1 RC2?

-JayBachatero
Title: Re: RSS Injector available
Post by: confusion on December 25, 2005, 11:40:08 PM
Simple.  I took the 1.1RC1 and added 1.  Actually, I was lazy and looked at what this forum was running, since I assumed it was the latest, as mine is.  Anyway, ass/u/me, you get the point :)
I take it that 1.1RC2 is a closely guarded RC?
Title: Re: RSS Injector available
Post by: JayBachatero on December 25, 2005, 11:42:53 PM
Well there are a many changes in RC2.  I'm just making sure og the version you had ;)

-JayBachatero
Title: Re: RSS Injector available
Post by: Remaker on January 03, 2006, 04:03:47 PM
Is this working for rc2 because it's a nice tool to use. :) ?
Title: Re: RSS Injector available
Post by: TLM on January 03, 2006, 04:21:58 PM
Well, I dloaded the code you linked to some time ago, noted it used some file I did not have so I deleted it with out thinking.  Later I figured it might be PEAR-XML, just went back to dload it again so I may tweak it to my use and cant find the link to the code again.  The one on the page seems to be broken in a way, for it goes on talking about your host, not the code.  Oh well guess I will have to build this idea by hand.
Title: Re: RSS Injector available
Post by: confusion on January 03, 2006, 05:45:26 PM
I'm sorry about that.  I was monkeying with the site an broke the link.  Here is again:
http://www.stelesys.com/content/view/21/34/index.php?option=com_content&task=view&id=21&Itemid=34
Title: Re: RSS Injector available
Post by: confusion on January 03, 2006, 05:46:17 PM
I'll give it a shot on RC2 tonight, but I would be suprised if it didn't work.
Title: Re: RSS Injector available
Post by: TLM on January 03, 2006, 06:19:35 PM
I'm sorry about that.  I was monkeying with the site an broke the link.  Here is again:
http://www.stelesys.com/content/view/21/34/index.php?option=com_content&task=view&id=21&Itemid=34
That and the link on the site it's self is linked wrong, have to copy the url manual and paste in browser to get the code...
Title: Re: RSS Injector available
Post by: confusion on January 03, 2006, 06:52:02 PM
I'm really batting a thousand today.  Actually, the problem is joomla trying to be a little too helpful.  Anyhow, the link should work now.  Thanks for pointing it out to me.

Jerry
Title: Re: RSS Injector available
Post by: wizard13335 on January 03, 2006, 07:01:25 PM
Ok now that link works... but the one on the website that links to the txt file still doesn't!
Title: Re: RSS Injector available
Post by: TLM on January 03, 2006, 07:09:42 PM
Well I took it upon my self to write my own custom injector, only issue remaining is double posting, once I solve that, I will be letting it run for a day or two to be sure of no issues, then to a live site followed by thoughts of maybe letting it be released to the public.
Title: Re: RSS Injector available
Post by: Vish on January 04, 2006, 12:41:10 PM
Can I get the script? THe link provided is not workin !!
Title: Re: RSS Injector available
Post by: Aquilo on January 04, 2006, 12:55:50 PM
http://www.stelesys.com/projects/smfrssinjector.php.txt
Title: Re: RSS Injector available
Post by: GC on January 04, 2006, 11:09:05 PM
Think you guys could whipe up something for birthdays and events and special occasions and new members. So that they each get a new post?
Title: Re: RSS Injector available
Post by: Vish on January 05, 2006, 12:18:04 AM
Pardon my noobie type questions, but I am not able to get this to run...I get following. I understand that I need to have that rss.php, but where to get it from?

Warning: main(XML/RSS.php): failed to open stream: No such file or directory in /home/vpahuja/public_html/smfrssinjector.php on line 12

Warning: main(XML/RSS.php): failed to open stream: No such file or directory in /home/vpahuja/public_html/smfrssinjector.php on line 12

Fatal error: main(): Failed opening required 'XML/RSS.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/vpahuja/public_html/smfrssinjector.php on line 12
Title: Re: RSS Injector available
Post by: TLM on January 05, 2006, 01:03:52 AM
Google: PEAR XML RSS (http://www.google.com/search?q=PEAR+XML+RSS)
Title: Re: RSS Injector available
Post by: Vish on January 25, 2006, 03:45:58 PM
Thanks. I believe I have made considerable progress here. I am now able to get the script run, but the script only injected two post !!!

Is there a counter or something that is preventing this script to insert more than 2 posts?

The RSS feed that I am working with is

http://forum.joomla.org/index.php/board,162.0/type,rss2/sa,news/action,.xml

I am suspecting that it might have to do with Indic Language....
Title: Re: RSS Injector available
Post by: Sharjeel66 on January 28, 2006, 09:22:28 PM
Google: PEAR XML RSS (http://www.google.com/search?q=PEAR+XML+RSS)
hi

since im a newb..any chance of explenation?
Title: Re: RSS Injector available
Post by: Vish on January 30, 2006, 03:30:26 PM
What do you want explained?
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 04, 2006, 07:29:34 AM
Table 'pakecono_pp.smf_messages' doesn't exist

this is the error im getting at the moment.
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 04, 2006, 10:58:40 PM
realised it had wrong table titles....so updated them and it works.

:D

mua ha ah ah aha

yeeeh haww...
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 04, 2006, 11:06:52 PM
here is a more user friendly version...and way of presenting to noobs like me.

http://www.pakeconomist.com//Varius%20Pics/injector.rar

unzip it. (needs winrar) and then open the file news.php in wordpad and edit all the fields which need to be edited.

(upto the source of the feed)

save the file as news.php
and upload it.

then you can open the http://www.yourdomain.etc\injector\news.php

and a blank screen will come....thats it.

go to your forum and check the location you selected. if there are no names then that means you have entered the username and not the userid (which is usualy the number)

any problems...report here.
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 04, 2006, 11:52:24 PM
the above i am not sure will work for 1.1rc2.

it will work for 1.6 though.

it seems like the tables 1.6 creates in SQL have difrent names to the ones 1.1rc2 creates?

ill upload the version compatible with 1.1rc2 in a few hours...so hold you horses.

(word of advice to SMF coderz...standerdise!)



Edit
-----------------------------------------------
Fears are over...
But be aware. it will not work for one of the SMF versions (doent ask which)
if you have errors..post them here.
Title: Re: RSS Injector available
Post by: Vish on February 09, 2006, 12:53:12 PM
I am still not able to get this to work with UTF-8 encoding and Indic Characters...
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 21, 2006, 08:03:24 PM
ok what seems to be the problem? what errors are you getting?
Title: Re: RSS Injector available
Post by: Vish on February 21, 2006, 08:12:29 PM
no errors, it is just not working...
Title: Re: RSS Injector available
Post by: Grandnegis on February 22, 2006, 06:26:30 AM
I downloaded the injector.rar file.  I there a step by step how to set this up.  I get I have to configure the php files and place them on my server but how do I pull it into a forum topic.  If someone can right a from scratch step by step in laymans terms it would be much appreciated.
Title: Re: RSS Injector available
Post by: Vish on February 22, 2006, 01:14:00 PM
I think I was able to get it to work just fine. What I mean is that the script is not working for UNICODE characters....

In my case the RSS I have that I want to inject has Hindi/Sanskrit/Malyalam charachters. This injector does not insert them....It does insert the other until it found the UNICODE charachter I believe.

This is what I was able to accomplish

http://www.joomlaindia.org/test/smf/

The RSS is from this board...

http://forum.joomla.org/index.php?board=162.0
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 22, 2006, 05:39:30 PM
aah.

the script i doent think is able to handle those characters.
Title: Re: RSS Injector available
Post by: Sharjeel66 on February 22, 2006, 05:44:58 PM
I downloaded the injector.rar file.  I there a step by step how to set this up.  I get I have to configure the php files and place them on my server but how do I pull it into a forum topic.  If someone can right a from scratch step by step in laymans terms it would be much appreciated.
the injector reads the feed and inserts the articles seperatly in the apropriate table in the SQL. so they just APPEAR in your forum. you doent have to set up anything on your forum how ever to get the script to work automaticly you might have to set up a cron job which executes the script automaticly after every 20 minutes as i have set it. you doent have to set up any thing else..just the things the writer of the script asks. but the writer did not include certain files which are required for the script to function properly so i thought it would be helpfull to include those in aswell and sort the script out so it works out of the box.


(the script will have to executed...ie visit the url the script is @ and it will come up with a blank page...but would have done its job.)
Title: Re: RSS Injector available
Post by: Grandnegis on February 23, 2006, 09:44:13 AM
ok I am getting this error;

Warning: main(PEAR.php): failed to open stream: No such file or directory in /client/home/iamwhistler/docs/forums/injector/Parser.php on line 39

Fatal error: main(): Failed opening required 'PEAR.php' (include_path='.:/php_includes') in /client/home/iamwhistler/docs/forums/injector/Parser.php on line 39

What is PEAR.php????
Title: Re: RSS Injector available
Post by: Sharjeel66 on March 04, 2006, 11:29:25 PM
i think it should work if you rename the RSS.php to PEAR.php

if that does not work then open the Parser.php in a editing program (dreamweaver or anything else with search function)

and search for "PEAR.php" and replace it with "RSS.php"

this would tell the parser to look for RSS.php and not PEAR.php which does not exist.
Title: Re: RSS Injector available
Post by: Grandnegis on March 07, 2006, 09:42:36 AM
Now I get this error;

Fatal error: Class xml_rss: Cannot inherit from undefined class xml_parser in /client/home/iamwhistler/docs/forums/injector/PEAR.php on line 36

AND if I change it to RSS I get an error on line 96 in the php file.  I will jsut wait I am working on a different way of doing this anyway using a portal program combined with SMF.
Title: Re: RSS Injector available
Post by: Xarcell on March 12, 2006, 09:57:13 PM
@ Sharjeel66

It doesn't seem to work for me...
---------------
Runnin 1.1RC2.

I downloaded the injector.

I edited the news.php file. Filled in my HOSTNAME, USERNAME, PASSWD, and DATABASE.

USERID = 4
BOARDID = 35
(also tried 1 and 1)

I inserted the feed url: http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml

Uploaded to root directory of SMF.

I run the news.php file: http://xboxnarc.com/injector/news.php  (blank page)

Nothing as appeared in my forum. What am I doing wrong? Did I miss something?
Title: Re: RSS Injector available
Post by: TechnoDragon on March 14, 2006, 11:22:34 AM
ok...got a new one:

My host uses a format for the databases of USERNAME_DB, where username is my username for the host and DB is the name of the Database (in this case SMF)

So I filled out the news feed so:

define("DB_HOSTNAME","webhost.com"); //Insert your DB server name here
define("DB_USERNAME","USERNAME_smf"); //DB username here
define("DB_PASSWD","********"); // DB password here
define("DB_DATABASE","smf"); //DB name here
$userid = 17; //Set this to the SMF userid you want the messages posted from
$boardid = 35;//Set this to the id of the board you want to post the messages in

this returns an error that it cannot connect to the database, so I changed the Database to USERNAME_smf, and then it says it cannot find the USERNAME_smf_messages table.

The problem is the literal nature of the above info...of course the database doesn't exist...but if I try to trick it by just putting the SMF part, then access is denied because it tries to connect to a database that doesn't exist...any ideas how to fix it?
Title: Re: RSS Injector available
Post by: TechnoDragon on March 15, 2006, 10:50:01 PM
Update...I see what the problem is but I cannot figure out how to fix it...when it goes to select the database, instead of selecting technodrag_smf_messages, it is trying to select technodrag_smf._messages.

Why is it inserting that period and how do I make it stop?


Update...got it figured out...now...how do I make it show all of these posts as new...currently they show as read posts and how is it going to attract attention from memebers if they all show as read?
Title: Re: RSS Injector available
Post by: Xarcell on March 16, 2006, 05:37:46 AM
I've been fiddling with it, and still no luck. IK entered all the info right, uploaded the injector/files to my root directory. I get a blank page (no errors) when I run the news.php file. However nothing shows up in my forum.

Code: [Select]

/** DATABASE Configuration */
define("DB_HOSTNAME","*myhostname"); //Insert your DB server name here
define("DB_USERNAME","*myusername"); //DB username here
define("DB_PASSWD","******"); // DB password here
define("DB_DATABASE","*mydbname"); //DB name here
$userid = 4; //Set this to the SMF userid you want the messages posted from
$boardid = 35; //Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS('http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml'); //Insert your URL here
//$rss_feed = & new XML_RSS('feed.xml'); //Used this for testing with local file, a bit quicker

Is that all I edit?
Title: Re: RSS Injector available
Post by: balzizras on March 19, 2006, 12:55:25 AM
This script is a really great idea, and I'd like to get it working, but im getting this error:
Quote
Table 'schultz_forum.messages' doesn't exist

Could someone tell me what I need to edit in order to make this work?


Im using the news.php file btw.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 09:26:07 AM
@balzizras

you have to manually edit the news.php file.

at each sql call for the table you have to add the prefix for the table.

so example... messages should be smf_messages (or whatever prefix you have in your database)

i am looking at a way to recode the template so there is less editing by using ssi calls, but it is slow going for me as I am new to all of this
Title: Re: RSS Injector available
Post by: daveso on March 19, 2006, 10:12:25 AM
i wish i knew what you guys are talking about.
as a new person to all this stuff. it is just too overwhelming.

I'm putting together a forum for our group, at least trying to...all i want is to include news feeds within a couople of topics, but all this editing and stuff of these files i dont even know what you're taling about.

I don;t even know where the files are on my website...or anything...
just a newbie...
can't someone write up a simple step by step from square 1 for new guys?

SMF seems not user friendly anyway compared to the php board I originally tried to run
Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 01:22:22 PM
If you run SMF with say Tiny Portal and no mods it is a very user friendly system...the majority of the talk here is for modifying the forum do do more than it was coded to do.

If you are looking for just an rss feed, you can use a package called Tiny Portal (www.tinyportal.net) and it uses an easy system of "blocks" one of which is designed to do rss feeds.

If you are looking to have the feeds entered into your forum as topics and posts that is what this is for and I can help you with the setup if you like.

Also,most of the files that ever need to be modified are usually in one of two places...either the sources directory or the default theme directory.
Title: Re: RSS Injector available
Post by: balzizras on March 19, 2006, 02:15:27 PM
Well I got rid of the error i mentioned above, but now I'm getting this one:
Quote
Duplicate entry '0-48' for key 2

Any idea what is wrong?
Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 02:29:02 PM
post a copy of your news.php here and I'll take a look at it
Title: Re: RSS Injector available
Post by: Xarcell on March 19, 2006, 02:42:34 PM
You can't have attachments here...
Title: Re: RSS Injector available
Post by: balzizras on March 19, 2006, 02:45:22 PM
Quote
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
//
// This script requires XML_RSS and PHP Pear Libraries
//
//
// This script is quick and dirty. Please remember to abide by the RSS content providers' terms of use. 

/** the PEAR XML_RSS object/class is required */
require 'RSS.php';

/** DATABASE Configuration */
define("DB_HOSTNAME","localhost"); //Insert your DB server name here
define("DB_USERNAME","schultz_smf1"); //DB username here
define("DB_PASSWD","notpostingmypassherelol"); // DB password here
define("DB_DATABASE","schultz_forum"); //DB name here
$userid = 8; //Set this to the SMF userid you want the messages posted from
$boardid = 48.0;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS('http://newsrss.bbc.co.uk/rss/newsplayer_world_edition/sci-tech/rss.xml'); //Insert your URL here
//$rss_feed = & new XML_RSS(''); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string, $max_length){
   if (strlen($string) > $max_length){
       $string = substr($string, 0, $max_length);
       $pos = strrpos($string, " ");
       if($pos === false) {return substr($string, 0, $max_length)."...";}
       return substr($string, 0, $pos)."...";
   }else{return $string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

      $num_articles=0; //Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    foreach ($rss_feed->getItems() as $item) {
        $obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = '". str_stop(addslashes($item['title']),100) ."'
        ",$obj_db) or die(mysql_error());

        $int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result($obj_query);

        if ($int_count['link_match'] == 0) {

          $num_articles = $num_articles +1;
         /**
          * REFORMATTING CODE
          **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things. 
      $titletext = str_stop(addslashes($item['title']),100);
// This adds an html link at to the original article at the very bottom of the post.
      $maintext = addslashes($item['description']) . "<p><a href=\"" . $item['link'] . "\">" . $item['link'] . "</a>";
    @mysql_query("
         INSERT INTO smf_topics(
            ID_BOARD,
            ID_MEMBER_STARTED,
            ID_MEMBER_UPDATED
         ) VALUES (
            '$boardid',
            '$userid',
            '$userid'
         )
      ",$obj_db) or die(mysql_error());
$topic = mysql_insert_id();
$postertime = date('U');
//Insert the actual message
    @mysql_query("
         INSERT INTO smf_messages(
            subject,
            body,
             ID_MEMBER,
            ID_BOARD,
            ID_TOPIC,
            posterTime
         ) VALUES (
            '". $titletext ."',
            '". $maintext ."',
            '$userid',
            '$boardid',   
            '$topic',
            '$postertime'
         )
      ",$obj_db) or die(mysql_error());
$messageid = mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    @mysql_query("
         UPDATE topics
            SET ID_FIRST_MSG = '$messageid',
            ID_LAST_MSG = '$messageid'
            WHERE ID_TOPIC = '$topic'
      ",$obj_db) or die(mysql_error());
//Increment total posts for board
    @mysql_query("
         UPDATE boards
            SET numPosts = numPosts + 1,
            numTopics = numTopics + 1
            WHERE ID_BOARD = '$boardid'
      ",$obj_db) or die(mysql_error());
//Increment Total Messages
    @mysql_query("
         UPDATE settings
            SET value = value + 1
            WHERE variable = 'totalMessages'
      ",$obj_db) or die(mysql_error());
//Increment Total Topics
    @mysql_query("
         UPDATE settings
            SET value = value + 1
            WHERE variable = 'totalTopics'
      ",$obj_db) or die(mysql_error());
// Increment post count for user record
    @mysql_query("
                        UPDATE members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = '$userid'
                ",$obj_db) or die(mysql_error());
        }
    }

if ($obj_db) {
    @mysql_close($obj_db);
}
?>

There ya go thanks.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 03:32:27 PM
Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME",""); //Insert your DB server name here
define("DB_USERNAME",""); //DB username here
define("DB_PASSWD",""); // DB password here
define("DB_DATABASE",""); //DB name here
$userid 8//Set this to the SMF userid you want the messages posted from
$boardid 48;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://newsrss.bbc.co.uk/rss/newsplayer_world_edition/sci-tech/rss.xml&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
INSERT INTO smf_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
INSERT INTO smf_messages(
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
UPDATE smf_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        } 
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>

There...you missed some of the database calls.
Title: Re: RSS Injector available
Post by: Xarcell on March 19, 2006, 03:47:34 PM
Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME",""); //Insert your DB server name here
define("DB_USERNAME",""); //DB username here
define("DB_PASSWD",""); // DB password here
define("DB_DATABASE",""); //DB name here
$userid 8//Set this to the SMF userid you want the messages posted from
$boardid 48;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://newsrss.bbc.co.uk/rss/newsplayer_world_edition/sci-tech/rss.xml&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
INSERT INTO smf_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
INSERT INTO smf_messages(
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
UPDATE smf_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        } 
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>

There...you missed some of the database calls.

I'm completely lost.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 03:54:29 PM
There were minor ommissions in there.  I found them as I had exactly the same problem with it when I tried to use it.
Title: Re: RSS Injector available
Post by: Xarcell on March 19, 2006, 04:07:40 PM
@technodragon73

What version of SMF do you have it installed on?
Title: Re: RSS Injector available
Post by: balzizras on March 19, 2006, 04:51:31 PM
I'm getting this error now :
Quote
Access denied for user: 'schultz@localhost' (Using password: NO)
I only saw two places to put my password, am I blind or stupid? (prolly) what am I doing wrong now?

Btw; sorry to bother you..

Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("localhost",""); //Insert your DB server name here
define("schultz_smf1",""); //DB username here
define("mypass",""); // DB password here
define("schultz_forum",""); //DB name here
$userid 8//Set this to the SMF userid you want the messages posted from
$boardid 48;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://rss.news.yahoo.com/rss/topstories&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(localhost,schultz_smf1,mypass) or die (mysql_error());

/** select the intended database */
@mysql_select_db(schultz_forum,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
INSERT INTO smf_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
INSERT INTO smf_messages(
subject,
body,
 ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
UPDATE smf_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        } 
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>
Title: Re: RSS Injector available
Post by: Xarcell on March 19, 2006, 05:01:12 PM
There's only one place to put yer password.

I don't think you should have done it the way you have. cut & paste techno's last reply with the news.php code and fill in the info. It should work for your particluar DB...

Title: Re: RSS Injector available
Post by: Xarcell on March 19, 2006, 05:03:58 PM
Cut and paste this code and write in your DB password in the configuration.

Code: [Select]

<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME","localhost"); //Insert your DB server name here
define("DB_USERNAME","schultz_smf1"); //DB username here
define("DB_PASSWD","yourDBpassword"); // DB password here
define("DB_DATABASE","schultz_forum"); //DB name here
$userid 8//Set this to the SMF userid you want the messages posted from
$boardid 48;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://rss.news.yahoo.com/rss/topstories&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
INSERT INTO smf_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
INSERT INTO smf_messages(
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
UPDATE smf_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        } 
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>

Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 05:09:11 PM
Sorry...i figured he would know to put his info in the right spaces...lol
Title: Re: RSS Injector available
Post by: balzizras on March 19, 2006, 05:34:30 PM
Cut and paste this code and write in your DB password in the configuration.

Code: [Select]

<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME","localhost"); //Insert your DB server name here
define("DB_USERNAME","schultz_smf1"); //DB username here
define("DB_PASSWD","yourDBpassword"); // DB password here
define("DB_DATABASE","schultz_forum"); //DB name here
$userid 8//Set this to the SMF userid you want the messages posted from
$boardid 48;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://rss.news.yahoo.com/rss/topstories&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (strlen($string) > $max_length){
       $string substr($string0$max_length);
       $pos strrpos($string" ");
       if($pos === false) {return substr($string0$max_length)."...";}
       return substr($string0$pos)."...";
   }else{return $string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    foreach ($rss_feed->getItems() as $item) {
        $obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        ",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    @mysql_query("
INSERT INTO smf_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    @mysql_query("
INSERT INTO smf_messages(
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    @mysql_query("
UPDATE smf_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    @mysql_query("
UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    @mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    @mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    @mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        
    }

if (
$obj_db) {
    @mysql_close($obj_db);
}
?>


Ok I used the above code, and I finially see what I was doing wrong.. But anyway Im still getting the error I had before: Duplicate entry '0-48' for key 2
Title: Re: RSS Injector available
Post by: TechnoDragon on March 19, 2006, 08:12:01 PM
first, does that board number actually exist?

Second, if it doesn't you need to create a board with that ID.

If it does, try using another board to make sure that is/is not the problem.

When I had the error I had to first add the database prefix, then I had to change the board
Title: Re: RSS Injector available
Post by: balzizras on March 19, 2006, 10:43:19 PM
first, does that board number actually exist?

Second, if it doesn't you need to create a board with that ID.

If it does, try using another board to make sure that is/is not the problem.

When I had the error I had to first add the database prefix, then I had to change the board


First yep that board/board number did exist. Anyway I changed it to another board and it worked.. weird.

So thanks a bunch for helping me out. I know it took me long enough,.. heh.  :)

Anyway one more question, would it be as simple as adding more of this line:
Code: [Select]
$rss_feed = & new XML_RSS(''); to get it to post from multi rss feeds? Or am I just being stupid.. Thanks again.

EDIT: Nevermind i tried it (duh why didn't I think of that) and it does work.

EDIT: It won't insert feeds from this site: http://info.detnews.com/rss/index.cfm
Any idea why?
Title: Re: RSS Injector available
Post by: TechnoDragon on March 20, 2006, 01:18:50 AM
Probably becasue oif the way the rss feed is provided...even though you can add mulitple rss feedss to the news file, you might try creating different files with different names (news.php does not need to be named that and no editing is required if you change the file name), that way you can independently run the feeds if you like rather than run them all at once.

Plus after you run the file(s) make sure to go to the admin section and run recount forum totals and find and fix errors...

lastly...if anyone can figure out how to make the posts from this show up as new in the recent posts (TP uses a block for this) I would be greatly appreciative.
Title: Re: RSS Injector available
Post by: daveso on March 20, 2006, 05:40:12 PM
Yes...I want to put the feeds into a topic. I appreciate the offer on helping me do this.
Where do we start?
Did I say thank you ?
thanks :)

If you run SMF with say Tiny Portal and no mods it is a very user friendly system...the majority of the talk here is for modifying the forum do do more than it was coded to do.

If you are looking for just an rss feed, you can use a package called Tiny Portal (www.tinyportal.net) and it uses an easy system of "blocks" one of which is designed to do rss feeds.

If you are looking to have the feeds entered into your forum as topics and posts that is what this is for and I can help you with the setup if you like.

Also,most of the files that ever need to be modified are usually in one of two places...either the sources directory or the default theme directory.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 20, 2006, 08:39:02 PM
Yes...I want to put the feeds into a topic. I appreciate the offer on helping me do this.
Where do we start?
Did I say thank you ?
thanks :)

If you run SMF with say Tiny Portal and no mods it is a very user friendly system...the majority of the talk here is for modifying the forum do do more than it was coded to do.

If you are looking for just an rss feed, you can use a package called Tiny Portal (www.tinyportal.net) and it uses an easy system of "blocks" one of which is designed to do rss feeds.

If you are looking to have the feeds entered into your forum as topics and posts that is what this is for and I can help you with the setup if you like.

Also,most of the files that ever need to be modified are usually in one of two places...either the sources directory or the default theme directory.

Hmmmm...well, you could contact me on msn and i can send you the files you need from there since you cannot attach anything in this topic.
Title: Re: RSS Injector available
Post by: L.G.S on March 21, 2006, 01:52:56 PM
Hmm I need help please.

I have filled everything out, checked the board number, userID, and the database prefix.

I use the file and I get a blank page, but nothing happens to my forum :(
Title: Re: RSS Injector available
Post by: TechnoDragon on March 21, 2006, 08:38:29 PM
post a link to the site so i can take a look
Title: Re: RSS Injector available
Post by: Xarcell on March 21, 2006, 11:09:43 PM
Doesn't work with RC2
Title: Re: RSS Injector available
Post by: TechnoDragon on March 21, 2006, 11:14:19 PM
Not true...that is the version of SMF i am using.
Title: Re: RSS Injector available
Post by: JSalvador on March 22, 2006, 04:01:08 AM
I first of all... Awesome work!  I'm really impressed. Got the script to work and it works great!!!

I've got two questions.

1) is there a way to batch enter in RSS feeds? that way a person would only have to run the news.php file once.

2) is there a way to automate this script so that it retrieves the RSS items and converts them to posts as they come?
Title: Re: RSS Injector available
Post by: L.G.S on March 22, 2006, 11:58:48 AM
post a link to the site so i can take a look

http://www.tactical-illusion.com/board

should be going into the sport area.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 22, 2006, 05:08:40 PM
post a link to the site so i can take a look

http://www.tactical-illusion.com/board

should be going into the sport area.

do you have a test account?

that way i can view the booard and topics.
Title: Re: RSS Injector available
Post by: Xarcell on March 22, 2006, 10:41:08 PM
What am I doing wrong then? I can't seem to get it to work, and I want it to work so bad...

Quote
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
//
// This script requires XML_RSS and PHP Pear Libraries
//
//
// This script is quick and dirty. Please remember to abide by the RSS content providers' terms of use.

/** the PEAR XML_RSS object/class is required */
require 'RSS.php';

/** DATABASE Configuration */
define("DB_HOSTNAME","360.xboxnarc.com"); //Insert your DB server name here
define("DB_USERNAME","narcmaster"); //DB username here
define("DB_PASSWD","*********"); // DB password here
define("DB_DATABASE","gamemod"); //DB name here
$userid = 4; //Set this to the SMF userid you want the messages posted from
$boardid = 35;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS('http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml'); //Insert your URL here
//$rss_feed = & new XML_RSS('feed.xml'); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string, $max_length){
   if (strlen($string) > $max_length){
       $string = substr($string, 0, $max_length);
       $pos = strrpos($string, " ");
       if($pos === false) {return substr($string, 0, $max_length)."...";}
       return substr($string, 0, $pos)."...";
   }else{return $string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

      $num_articles=0; //Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    foreach ($rss_feed->getItems() as $item) {
        $obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                messages
            WHERE
                subject = '". str_stop(addslashes($item['title']),100) ."'
        ",$obj_db) or die(mysql_error());

        $int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result($obj_query);

        if ($int_count['link_match'] == 0) {

          $num_articles = $num_articles +1;
         /**
          * REFORMATTING CODE
          **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.
      $titletext = str_stop(addslashes($item['title']),100);
// This adds an html link at to the original article at the very bottom of the post.
      $maintext = addslashes($item['description']) . "<p><a href=\"" . $item['link'] . "\">" . $item['link'] . "</a>";
    @mysql_query("
         INSERT INTO topics(
            ID_BOARD,
            ID_MEMBER_STARTED,
            ID_MEMBER_UPDATED
         ) VALUES (
            '$boardid',
            '$userid',
            '$userid'
         )
      ",$obj_db) or die(mysql_error());
$topic = mysql_insert_id();
$postertime = date('U');
//Insert the actual message
    @mysql_query("
         INSERT INTO messages(
            subject,
            body,
             ID_MEMBER,
            ID_BOARD,
            ID_TOPIC,
            posterTime
         ) VALUES (
            '". $titletext ."',
            '". $maintext ."',
            '$userid',
            '$boardid',
            '$topic',
            '$postertime'
         )
      ",$obj_db) or die(mysql_error());
$messageid = mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    @mysql_query("
         UPDATE topics
            SET ID_FIRST_MSG = '$messageid',
            ID_LAST_MSG = '$messageid'
            WHERE ID_TOPIC = '$topic'
      ",$obj_db) or die(mysql_error());
//Increment total posts for board
    @mysql_query("
         UPDATE boards
            SET numPosts = numPosts + 1,
            numTopics = numTopics + 1
            WHERE ID_BOARD = '$boardid'
      ",$obj_db) or die(mysql_error());
//Increment Total Messages
    @mysql_query("
         UPDATE settings
            SET value = value + 1
            WHERE variable = 'totalMessages'
      ",$obj_db) or die(mysql_error());
//Increment Total Topics
    @mysql_query("
         UPDATE settings
            SET value = value + 1
            WHERE variable = 'totalTopics'
      ",$obj_db) or die(mysql_error());
// Increment post count for user record
    @mysql_query("
                        UPDATE members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = '$userid'
                ",$obj_db) or die(mysql_error());
        }
    }

if ($obj_db) {
    @mysql_close($obj_db);
}
?>
[/qoute]
Title: Re: RSS Injector available
Post by: TechnoDragon on March 22, 2006, 10:54:12 PM
I am so sorry Xarcell...I did not realize you were looking for help as well, you are usually the helper...lol

It looks to me like you are missing the prefix for your tables in the body of the code....

try this (you obviously need to put your password in and this is assuming that you are using the smf_ prefix):
Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
//
// This script requires XML_RSS and PHP Pear Libraries
//
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME","360.xboxnarc.com"); //Insert your DB server name here
define("DB_USERNAME","narcmaster"); //DB username here
define("DB_PASSWD","*********"); // DB password here
define("DB_DATABASE","gamemod"); //DB name here
$userid 4//Set this to the SMF userid you want the messages posted from
$boardid 35;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;feed.xml&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

      
$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

          
$num_articles = $num_articles +1;
         /**
          * REFORMATTING CODE
          **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.
      
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
      
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
         INSERT INTO smf_topics(
            ID_BOARD,
            ID_MEMBER_STARTED,
            ID_MEMBER_UPDATED
         ) VALUES (
            &#39;
$boardid&#39;,
            &#39;
$userid&#39;,
            &#39;
$userid&#39;
         )
      "
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
         INSERT INTO smf_messages(
            subject,
            body,
             ID_MEMBER,
            ID_BOARD,
            ID_TOPIC,
            posterTime
         ) VALUES (
            &#39;"
$titletext ."&#39;,
            &#39;"
$maintext ."&#39;,
            &#39;
$userid&#39;,
            &#39;
$boardid&#39;,
            &#39;
$topic&#39;,
            &#39;
$postertime&#39;
         )
      "
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
         UPDATE smf_topics
            SET ID_FIRST_MSG = &#39;
$messageid&#39;,
            ID_LAST_MSG = &#39;
$messageid&#39;
            WHERE ID_TOPIC = &#39;
$topic&#39;
      "
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
         UPDATE smf_boards
            SET numPosts = numPosts + 1,
            numTopics = numTopics + 1
            WHERE ID_BOARD = &#39;
$boardid&#39;
      "
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
         UPDATE smf_settings
            SET value = value + 1
            WHERE variable = &#39;totalMessages&#39;
      "
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
         UPDATE smf_settings
            SET value = value + 1
            WHERE variable = &#39;totalTopics&#39;
      "
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        }
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>


let me know if this works for ya!
Title: Re: RSS Injector available
Post by: Xarcell on March 22, 2006, 11:14:30 PM
Same as before.

When I run the news.php file I don't get any errors, but nothing shows up in the forums...
Title: Re: RSS Injector available
Post by: TechnoDragon on March 22, 2006, 11:19:28 PM
what is the link to your board you are trying to post in?
Title: Re: RSS Injector available
Post by: Xarcell on March 22, 2006, 11:23:19 PM
www.xboxnarc.com

the "Xbox.com" board...

www.xboxnarc.com/injector/news.php
Title: Re: RSS Injector available
Post by: TechnoDragon on March 22, 2006, 11:43:48 PM
Try this...I got it to work on my forum...just make sure you have the top four items correct...

Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME","360.xboxnarc.com"); //Insert your DB server name here
define("DB_USERNAME","narcmaster"); //DB username here
define("DB_PASSWD","********"); // DB password here
define("DB_DATABASE","gamemod"); //DB name here
$userid 5//Set this to the SMF userid you want the messages posted from
$boardid 25;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
INSERT INTO smf_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
INSERT INTO smf_messages(
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
UPDATE smf_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
UPDATE smf_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        } 
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>
Title: Re: RSS Injector available
Post by: Xarcell on March 23, 2006, 12:26:00 AM
Still no prevail...
Title: Re: RSS Injector available
Post by: TechnoDragon on March 23, 2006, 12:28:13 AM
hmmmm....Are you sure that the details at the top are correct?  All i did with that posted info was put my details in there in it's place (plus change the userid and board number) and it worked flawlessly.

try using a different board and/or userid just to test it out
Title: Re: RSS Injector available
Post by: L.G.S on March 23, 2006, 12:30:55 PM
post a link to the site so i can take a look

http://www.tactical-illusion.com/board

should be going into the sport area.

do you have a test account?

that way i can view the booard and topics.

username: test
pass: test
Title: Re: RSS Injector available
Post by: TechnoDragon on March 23, 2006, 10:07:32 PM
post a link to the site so i can take a look

http://www.tactical-illusion.com/board

should be going into the sport area.
Did you try copying and pasting the last code update from this page?  Try that and put your info in there and let me know what happens.
do you have a test account?

that way i can view the booard and topics.

username: test
pass: test
Title: Re: RSS Injector available
Post by: L.G.S on March 24, 2006, 10:57:08 AM
I have tried the code yes, and nothing. Worked once now it's dead.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 24, 2006, 08:51:47 PM
it worked once?

Well it may not be working not because it is broken, but because there are no new news coming rom that feed...the php file is designed to test against what has already been posted and skip it if it thinks it is already there...try a different feed and see what happens
Title: Re: RSS Injector available
Post by: Xarcell on March 24, 2006, 09:58:14 PM
You have to run the new.php to show feeds each time, unless you set up a cron job to run it for you automactically.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 24, 2006, 10:15:07 PM
You have to run the new.php to show feeds each time, unless you set up a cron job to run it for you automactically.

Did you get your to work?  I hadn't heard from you in awhile.  Just wondering.
Title: Re: RSS Injector available
Post by: L.G.S on March 25, 2006, 05:30:15 AM
You have to run the new.php to show feeds each time, unless you set up a cron job to run it for you automactically.

Yes I know that, I did read the posts.

thanks for the help everyone, although I think I will not use this
Title: Re: RSS Injector available
Post by: L.G.S on March 25, 2006, 09:55:54 AM
Scratch that last comment, I have figured it out.

Although I have one problem, when I click MARK READ in recent posts they never go away :(
Title: Re: RSS Injector available
Post by: TechnoDragon on March 25, 2006, 10:13:40 AM
ok, that is a very fixable problem.  Go into your admin panel, click forum maitenence, click recount forum statistics.  Once that it complete, click fixes all errors and click yes...voila...problems go away!

It is a bug that I cannot figure out how to fix.  (not that familiar with coding)
Title: Re: RSS Injector available
Post by: L.G.S on March 25, 2006, 11:57:06 AM
Nope, they are all still there lol.

Also how do I make them appear on the forum index as new posts? in the 'last post' are it always says NA
Title: Re: RSS Injector available
Post by: TechnoDragon on March 25, 2006, 02:01:02 PM
Nope, they are all still there lol.

Also how do I make them appear on the forum index as new posts? in the 'last post' are it always says NA

That is another problem i have been trying to get fixed....I did not write the original coding for this...jsut figured out how to get it to work.  Anyone that can answer that question of how to make them show up as "new" would be greatly appreciated...as far as NA...it is because the injector uses the member ID rather than the name...I could not figure out how to get it to do that either.
Title: Re: RSS Injector available
Post by: L.G.S on March 25, 2006, 02:23:21 PM
ok thanks,

I guess I will have to wait until someone picks up on this.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 25, 2006, 03:56:55 PM
ok thanks,

I guess I will have to wait until someone picks up on this.

You can see how it works at my site...I have three different boards right now using it:

http://forum.technodragon.net/index.php?board=56.0
http://forum.technodragon.net/index.php?board=57.0
http://forum.technodragon.net/index.php?board=58.0

(Actually I have more, but I figure these are enough to see what works)
Title: Re: RSS Injector available
Post by: L.G.S on March 25, 2006, 07:10:07 PM
I do not know what you are trying to show me but mine are here:

http://www.tactical-illusion.com/board/index.php?board=167.0
Title: Re: RSS Injector available
Post by: Xarcell on March 25, 2006, 08:50:47 PM
Damnit, wish mine would work...
Title: Re: RSS Injector available
Post by: TechnoDragon on March 26, 2006, 12:44:57 AM
I do not know what you are trying to show me but mine are here:

http://www.tactical-illusion.com/board/index.php?board=167.0

So basically you got yours working?  Except for the "new" issue?
Damnit, wish mine would work...

Yours is still not working at all?
Title: Re: RSS Injector available
Post by: L.G.S on March 26, 2006, 05:32:01 AM
Yes they are working except for the part where they dont show as new.

I'm not too good with code, where would I increase the post characters?
Title: Re: RSS Injector available
Post by: TechnoDragon on March 26, 2006, 10:10:06 AM
Yes they are working except for the part where they dont show as new.

I'm not too good with code, where would I increase the post characters?

The post is entirely dependant on what the news feed provides...it doesn't pull any more info than the fedd gives...so if it only gives a link and title...that is all you get, but if it gives more (as some do) like an image, brief summary, and link then you get that instead.
Title: Re: RSS Injector available
Post by: L.G.S on March 26, 2006, 01:39:22 PM
ok, thanks.
Title: Re: RSS Injector available
Post by: Xarcell on March 26, 2006, 01:59:11 PM
@ L.G.S

At first you where having the same problem I was. Now yours is work. What did you do to get it to work?

Can I please get a copy of the news.php you used? Just remove your password and such.

Thanks,

-Xarcell

Title: Re: RSS Injector available
Post by: L.G.S on March 26, 2006, 03:36:10 PM
I now have a file for each news type, so here is my world news file:

Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// This script requires XML_RSS and PHP Pear Libraries
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers&#39; terms of use.  

/** the PEAR XML_RSS object/class is required */
require &#39;RSS.php&#39;;

/** DATABASE Configuration */
define("DB_HOSTNAME","localhost"); //Insert your DB server name here
define("DB_USERNAME",""); //DB username here
define("DB_PASSWD",""); // DB password here
define("DB_DATABASE",""); //DB name here
$userid 475//Set this to the SMF userid you want the messages posted from
$boardid 170.0;//Set this to the id of the board you want to post the messages in

/** pull list of remote RSS feeds, via a remote RSS feed. */
$rss_feed = & new XML_RSS(&#39;http://news.google.co.uk/nwshp?tab=wn&ned=uk&topic=w&output=rss&#39;); //Insert your URL here
//$rss_feed = & new XML_RSS(&#39;&#39;); //Used this for testing with local file, a bit quicker
// Function for shortening articles based on maximum length
function str_stop($string$max_length){
   if (
strlen($string) > $max_length){
       
$string substr($string0$max_length);
       
$pos strrpos($string" ");
       if(
$pos === false) {return substr($string0$max_length)."...";}
       return 
substr($string0$pos)."...";
   }else{return 
$string;}
}
/** create the database connection object */
$obj_db = @mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());

/** select the intended database */
@mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

$rss_feed->parse();

$num_articles=0//Variable used to count number of new articles, displayed in an email below

    // Here we make sure that feed articles do not already exist in DB
    // this uses title names, make sure to use the same title formatting here as you will use further down
    // state = 1 not trashed
    
foreach ($rss_feed->getItems() as $item) {
        
$obj_query = @mysql_query("
            SELECT
                COUNT(ID_MSG) AS link_match
            FROM
                smf2_messages
            WHERE
                subject = &#39;"
str_stop(addslashes($item[&#39;title&#39;]),100) ."&#39;
        
",$obj_db) or die(mysql_error());

        
$int_count = @mysql_fetch_assoc($obj_query) or die(mysql_error());

        mysql_free_result(
$obj_query);

        if (
$int_count[&#39;link_match&#39;] == 0) {

    
$num_articles = $num_articles +1;
/**
 * REFORMATTING CODE
 **/
// In my experience you have to play with the definitions from different RSS feeds - some rss feeds call fields different things.  
$titletext = str_stop(addslashes($item[&#39;title&#39;]),100);
// This adds an html link at to the original article at the very bottom of the post.
$maintext = addslashes($item[&#39;description&#39;]) . "<p><a href=\"" $item[&#39;link&#39;] . "\">" . $item[&#39;link&#39;] . "</a>";
    
@mysql_query("
INSERT INTO smf2_topics(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED
) VALUES (
&#39;
$boardid&#39;,
&#39;
$userid&#39;,
&#39;
$userid&#39;
)
"
,$obj_db) or die(mysql_error());
$topic mysql_insert_id();
$postertime date(&#39;U&#39;);
//Insert the actual message
    
@mysql_query("
INSERT INTO smf2_messages(
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime
) VALUES (
&#39;"
$titletext ."&#39;,
&#39;"
$maintext ."&#39;,
&#39;
$userid&#39;,
&#39;
$boardid&#39;,
&#39;
$topic&#39;,
&#39;
$postertime&#39;
)
"
,$obj_db) or die(mysql_error());
$messageid mysql_insert_id();
//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
    
@mysql_query("
UPDATE smf2_topics
SET ID_FIRST_MSG = &#39;
$messageid&#39;, 
ID_LAST_MSG = &#39;
$messageid&#39;
WHERE ID_TOPIC = &#39;
$topic&#39;
"
,$obj_db) or die(mysql_error());
//Increment total posts for board
    
@mysql_query("
UPDATE smf2_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = &#39;
$boardid&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Messages
    
@mysql_query("
UPDATE smf2_settings
SET value = value + 1
WHERE variable = &#39;totalMessages&#39;
"
,$obj_db) or die(mysql_error());
//Increment Total Topics
    
@mysql_query("
UPDATE smf2_settings
SET value = value + 1
WHERE variable = &#39;totalTopics&#39;
"
,$obj_db) or die(mysql_error());
// Increment post count for user record
    
@mysql_query("
                        UPDATE smf2_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = &#39;
$userid&#39;
                "
,$obj_db) or die(mysql_error());
        } 
    }

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>
Title: Re: RSS Injector available
Post by: TechnoDragon on March 26, 2006, 04:24:35 PM
I did exactly the same thing...every feed has a different file...now if I had enough CRON jobs to run them all!  LOL
Title: Re: RSS Injector available
Post by: L.G.S on March 27, 2006, 09:58:10 AM
Would somebody mind telling me what I would need to enter for a cronjob? I tried tutorials from google but it makes no sense to me :(

I need a file located at /board/news/file.php

to run every 1 hour
Title: Re: RSS Injector available
Post by: TechnoDragon on March 27, 2006, 10:40:00 AM
doesn't your server provide documentation?  I'll see what I can find for you.  I user an off-site cronjob provider that was easy and free.
Title: Re: RSS Injector available
Post by: L.G.S on March 27, 2006, 10:57:31 AM
nope they dont :(
Title: Re: RSS Injector available
Post by: TechnoDragon on March 27, 2006, 11:41:13 AM
nope they dont :(

Well, if it is similar to what i have seen you pick how often it runs and the command would just be the path to your file. usually without the http:// part
Title: Re: RSS Injector available
Post by: L.G.S on March 27, 2006, 12:51:19 PM
ok thanks,

because I tried it with http:// and I got emails saying the directory could not be found
Title: Re: RSS Injector available
Post by: TechnoDragon on March 27, 2006, 01:33:42 PM
ok thanks,

because I tried it with http:// and I got emails saying the directory could not be found

coolness...just let me know if it works.  Oh, btw, have you rmembered to go to recount forum statistics, and find and fix errors?
Title: Re: RSS Injector available
Post by: L.G.S on March 27, 2006, 01:48:26 PM
yeah, everything is fine except NEW posts as I said
Title: Re: RSS Injector available
Post by: TechnoDragon on March 27, 2006, 01:59:04 PM
yeah, everything is fine except NEW posts as I said

Ya, hopefully someone will help us out there
Title: Re: RSS Injector available
Post by: starrbuck on March 28, 2006, 08:06:53 PM
This is a neat script.  However, it is not without its issues...

Primarily, it does not appear to insert the messages properly.  If you run it, then go to forum maintenance, then find and repair any errors, it reports issues with the messages that were added.  Also, probably related, the last post column on the main forum screen
does not contain anything about the new posts.

Is there any way to run forum maintenance (repairboards) from the command line/cron job?  I would be OK with using this script if I could automatically run the maintenance afterwards.  Ideally, however, it should be fixed to insert its messages properly.
Title: Re: RSS Injector available
Post by: TechnoDragon on March 28, 2006, 09:00:31 PM
I noticed that too, but i am not good enough in coding to fix that problem either.
Title: Re: RSS Injector available
Post by: spun2u on April 02, 2006, 09:44:53 PM
Nice mod. I had to edit it to get it to work but it's running now.

Title: Re: RSS Injector available
Post by: starrbuck on April 03, 2006, 03:34:42 PM
In your edits did you fix it so that it doesn't need forum maintenance after it does its inserts?
Title: Re: RSS Injector available
Post by: spun2u on April 03, 2006, 09:13:04 PM
Um. Now I'm getting this cron error

/public_html/injector/news.php: line 1: ?php
: No such file or directory
/public_html/injector/news.php: line 2: //
: No such file or directory
/public_html/injector/news.php: line 3: //: is a directory
/public_html/injector/news.php: line 4: //: is a directory
/public_html/injector/news.php: line 5: //: is a directory
/public_html/injector/news.php: line 6: //: is a directory
/public_html/injector/news.php: line 7: //: is a directory
/public_html/injector/news.php: line 8: //
: No such file or directory
/public_html/injector/news.php: line 133: unexpected EOF while looking for matching `''
/public_html/injector/news.php: line 142: syntax error: unexpected end of file


What am I doing wrong?
Title: Re: RSS Injector available
Post by: TechnoDragon on April 03, 2006, 10:36:56 PM
looks like you have your path setting wrong with using the cron job
Title: Re: RSS Injector available
Post by: JSalvador on April 04, 2006, 05:29:17 PM
Is there a way to add more than one rss feed to the news.php file?
Title: Re: RSS Injector available
Post by: L.G.S on April 04, 2006, 06:06:51 PM
The only way I found was to make another file and paste the code from the original in, just changing the feed link.
Title: Re: RSS Injector available
Post by: JSalvador on April 04, 2006, 06:59:30 PM
Thanks,

That's the only way that i figured out as well.  However, I was hoping there was a better way, that way i could put in a set of newsfeeds and set the cron job for just one file.  If anyone has any insight on how to do this it would be much appreciated.
Title: Re: RSS Injector available
Post by: TechnoDragon on April 04, 2006, 09:31:57 PM
potentially if you are any good at coding you could create a php file that would run all of your news feed php files.  Then set a cron job to run that file.  I just haven't figured out a way to do it yet.
Title: Re: RSS Injector available
Post by: JSalvador on April 06, 2006, 12:59:25 AM
You know this is a great script i was just wondering if it was available for any other forums as well. I know I probably shouldn't be asking here  ::), but I have another forum that's running on phpBB2 and was hoping this would work for it.
Title: Re: RSS Injector available
Post by: starrbuck on April 07, 2006, 12:02:04 PM
There is a similar product for phpBB2 called NewsSync but I don't think it's being actively supported any longer.

Here is a thread about it:  http://www.phpbb.com/phpBB/viewtopic.php?t=121946
Title: Re: RSS Injector available
Post by: linux_learner on April 08, 2006, 06:15:53 PM
ok, I tried this, and ended up with;
Quote
Warning: main(RSS.php): failed to open stream: No such file or directory in /home/*****/public_html/phpBB2/injector/news.php on line 34

Warning: main(RSS.php): failed to open stream: No such file or directory in /home/*****/public_html/phpBB2/injector/news.php on line 34

Warning: main(RSS.php): failed to open stream: No such file or directory in /home/*****/public_html/phpBB2/injector/news.php on line 34

Fatal error: main(): Failed opening required 'RSS.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/*****/public_html/phpBB2/injector/news.php on line 34



Code: [Select]
require 'RSS.php';







/** DATABASE Configuration */



define("DB_HOSTNAME","localhost"); //Insert your DB server name here



define("DB_USERNAME","********"); //DB username here



define("DB_PASSWD","******"); // DB password here



define("DB_DATABASE","smf"); //DB name here



$userid = 15; //Set this to the SMF userid you want the messages posted from



$boardid = 87;//Set this to the id of the board you want to post the messages in







/** pull list of remote RSS feeds, via a remote RSS feed. */



$rss_feed = & new XML_RSS('http://microsoft.weblogsinc.com/rss.xml'); //Insert your URL here

Title: Re: RSS Injector available
Post by: linux_learner on April 08, 2006, 08:15:06 PM
ok, I figured out a bit more on my own, and now I just have;
Quote
Access denied for user: '*******_@localhost' (Using password: YES)
Title: Re: RSS Injector available
Post by: spun2u on April 08, 2006, 08:21:46 PM
ok, I figured out a bit more on my own, and now I just have;
Quote
Access denied for user: '*******_@localhost' (Using password: YES)

This looks like you have an incorrect login. Either username or password.

The injector is working fine on my forum http://forums.u2torrents.com
Title: Re: RSS Injector available
Post by: linux_learner on April 08, 2006, 08:59:36 PM
now i have
Quote
Table 'goofynut_smf.messages' doesn't exist
Title: Re: RSS Injector available
Post by: TechnoDragon on April 08, 2006, 10:12:55 PM
okay, the issue i see (and it has been a problem for everyone) is in the news.php file you seed to manually change it so that all the table refrences have your db prefix in them
Title: Re: RSS Injector available
Post by: linux_learner on April 08, 2006, 10:53:43 PM
okay, the issue i see (and it has been a problem for everyone) is in the news.php file you seed to manually change it so that all the table refrences have your db prefix in them


ok, i posted my code previously. can you give me an example of what you mean? i don't quite get you.
Title: Re: RSS Injector available
Post by: linux_learner on April 08, 2006, 11:59:07 PM
got it. took another browse through this thread, and solved it. ( i read this thread like for times  ::) :o )
Title: Re: RSS Injector available
Post by: linux_learner on April 09, 2006, 12:37:01 AM
now can someone tell me how to do different feeds under different catagories?
Title: Re: RSS Injector available
Post by: TechnoDragon on April 09, 2006, 01:28:35 AM
got it. took another browse through this thread, and solved it. ( i read this thread like for times  ::) :o )

I'll need to see the entire code to be able to show you...you only posted the top part of it.

now can someone tell me how to do different feeds under different catagories?

just change the board id and create a different news.php file...they do not have to be named news.php, could even be xbox.php or anything.
Title: Re: RSS Injector available
Post by: linux_learner on April 09, 2006, 06:25:07 AM
Thanks. I have it all done now. Just one last question, does this program automatically import the news every so often? Or do I need to refresh each one everyso often?
Title: Re: RSS Injector available
Post by: TechnoDragon on April 09, 2006, 10:58:54 AM
you have to either manually run the php file to import the news, or use a cron job to run it for you
Title: Re: RSS Injector available
Post by: linux_learner on April 09, 2006, 11:15:11 AM
ok. I have never done a cron job before. Whats the command that I would use?
Title: Re: RSS Injector available
Post by: TechnoDragon on April 09, 2006, 12:01:40 PM
ok. I have never done a cron job before. Whats the command that I would use?

Typically in simple mode you just paste the path to the file...

something like /home/www/yourdomain/news.php

you can get the server path from the server settings in smf
Title: Re: RSS Injector available
Post by: linux_learner on April 09, 2006, 04:08:48 PM
Either the file isnt pulling in news, or, theres no news on the server, or the command doesn't work. In any case, I dont seem to be getting any new news from any of my source, whether i manually refresh or not.
Title: Re: RSS Injector available
Post by: TechnoDragon on April 09, 2006, 04:55:41 PM
the code was written in a way to make sure it did not repost the same news...so it is possible that there is no new news to pull.
Title: Re: RSS Injector available
Post by: starrbuck on April 11, 2006, 01:30:43 PM
potentially if you are any good at coding you could create a php file that would run all of your news feed php files.  Then set a cron job to run that file.  I just haven't figured out a way to do it yet.

You could also make it parameter-driven so that you pass in the URL each time you run the script.  Would not be hard to implement.
Title: Re: RSS Injector available
Post by: kilokat7 on May 01, 2006, 10:58:09 PM
Thanks to the instructions in this thread, the script is working nice for me.  I have one request now that I've played with it.  I'm interested in injecting one RSS feed that consists of 5-8 topics.  Since this is a short feed, I would like all 5-8 topics to appear in one single post on my forum as opposed to 5-8 individual posts.  Any clues on how to hack the code to achieve this?  I'm referring to the "news.php" code...
Title: Re: RSS Injector available
Post by: JamieinNH on May 02, 2006, 12:24:32 AM
OK,   I still have a problem with this not working for some reason.

I have done a couple of tests and think maybe it's something to do with my host.

I installed SMF on Host A, ran the script and everything worked like a charm.

I installed SMF on Host B, ran the script and got nothing.   I got a blank page, but no results.


So, I know the script works on one host, FutureQuest, but it doesn't work on the second host DreamHost.

Anyone have any ideas as to why it would work on one host, but not another?


Thanks for any suggestions.

Jamie
Title: Re: RSS Injector available
Post by: Xarcell on May 03, 2006, 11:02:40 PM
I also use dreamhost, and this script doesn't work for me either. I'm beaten my head against the wall trying to figure it out. If you figure it out, please let me know.

Dreamhost is a great host, but it isn't SMF friendly...
Title: Re: RSS Injector available
Post by: SEO on May 04, 2006, 01:34:01 AM
Dreamhost is a terrible host for things like the rssbot
It will probably be an fsock problem and you will need to redo the code to get it to work.
Title: Re: RSS Injector available
Post by: xcooling on May 08, 2006, 02:17:14 AM
Does this support multiple news feeds per a defined forum ?

where can i get the most stable code for this addon ?
Title: Re: RSS Injector available
Post by: rmccarley on May 08, 2006, 04:26:21 AM
It seems everyone is complaining! I got it to work though it took a bit of doing (someone at my host was being "clever" when they set things up and it took a bit to figure out). Still, less than 30 minutes to get it up amd working correctly. This is a very excellent mod. Thank you and thanks for the support (it was all helpful).  ;D
Title: Re: RSS Injector available
Post by: SEO on May 08, 2006, 04:48:45 AM
same as anywhere rand.
people are good enough to submit hacks and most of the posts are complaining it dosent work.

Glad you got it working.
Title: Re: RSS Injector available
Post by: JamieinNH on May 08, 2006, 04:59:36 PM
I'm not sure if I was one of the complainer's or not, but I did get this working on one host, but not on my other site hosted by DreamHost.

So, I can say it's a great mod, but I can't get it working, and since I have little php skills, I do need help installing it on my Dreamhost account.

That is why I listed this post in the Paid/Free Help wanted portion of this site:

http://www.simplemachines.org/community/index.php?topic=86261.0

Since I can't get it working I will pay someone to help me get it working.   I do appreiate the efforts of the people that submit mods, but I have to work within my limited skillset when it comes to PHP and have to rely on other people that know PHP.


Thanks!

Jamie
Title: Re: RSS Injector available
Post by: Niteblade on May 27, 2006, 02:32:38 AM
Issues :

The posts that my 'forum bot' makes are not searchable. I don't know if this is because I have so many mods  installed or what.

The posts that my 'forum bot' makes from yahoo! finance have the correct subject, which reflects the news headline, but the body of the post is a link to the .html file on yahoo's site. It'd be nice if the bot could capture the entire rss body and post it, in its entirety, inside my forum, from yahoo! finance. I understand that this is probably because of the way yahoo formats their rss feeds, however, it'd be real spiffy I could capture the entire body of the headline. In paricular, this is because I want to have rss news on certain companies that my members consider to be popular. For example, http://biz.yahoo.com/iw/060523/0130838.html is the "full" news from company PBLS.PK. The feed for the news from just this particular company is http://finance.yahoo.com/rss/headline?s=pbls.pk . When pbls.php (my own custom version of news.php) grabs the feed from http://finance.yahoo.com/rss/headline?s=pbls.pk , the body of the post inside my forum looks like this :
Quote
http://us.rd.yahoo.com/finance/news/rss/story/*http://biz.yahoo.com/iw/050919/095559.html

When my forum bot makes a post, the "Last post" section of the forum (to the right of the category on the board index) is left blank. While the counter that says "75 posts 75 topics" is updated correctly, the little snippet from the "Last Post" is missing entirely.
Title: Re: RSS Injector available
Post by: sanax on June 02, 2006, 10:12:06 PM
I've read trough this thread about a tousand time and I just don't get it...

Get this error:

Quote
Warning: main(XML/RSS.php) [function.main]: failed to open stream: No such file or directory in /home/gangster/public_html/switchboard/news.php on line 12

Fatal error: main() [function.require]: Failed opening required 'XML/RSS.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gangster/public_html/switchboard/news.php on line 12

I get stuck with the RSS.php

Help will be appreciated!
Title: Re: RSS Injector available
Post by: htmlmaster on June 04, 2006, 05:31:19 PM
Can someone post an example script? I'm new to MySQL and I'm a bit confused with the database information (I'm used to connecting, not doing whatever it is here).
Title: Re: RSS Injector available
Post by: Xarcell on June 06, 2006, 11:54:15 PM
Somestiems it's not complianing. It's called feedback.
Title: Re: RSS Injector available
Post by: Niteblade on June 07, 2006, 12:12:19 AM
There's a new RSS Injector mod coming out in about a week or two. (Not from me. I don't know how to code.)

It'll make this script obsolete. :)
Title: Re: RSS Injector available
Post by: Xarcell on June 07, 2006, 08:31:54 AM
I hope so, but I can't jump for joy. It's been said a hundred times already, and it's yet to happen.

All I can do is hope.
Title: Re: RSS Injector available
Post by: Ole 223 on June 07, 2006, 08:08:38 PM
Jake04 is a cheap person on this site and has deleted my friends site for no reason!
Title: Re: RSS Injector available
Post by: Josh_345 on June 07, 2006, 09:19:00 PM
No he did not delete it... read the other topic..
Title: Re: RSS Injector available
Post by: fernandose on June 12, 2006, 04:15:03 PM
hey wanted to know if this modification is still in developement? would be really interested in it

Thanks
Title: Re: RSS Injector available
Post by: haktanir2 on June 13, 2006, 10:00:49 AM
I don't know why but when I execute the php file, I just get an empty page, has anyone found a solution for this problem?

There's a new RSS Injector mod coming out in about a week or two. (Not from me. I don't know how to code.)

It'll make this script obsolete. :)
Is there a website we can check the progress on?
Title: Re: RSS Injector available
Post by: sanax on June 13, 2006, 12:10:50 PM
Not yet!!... seems to me there is no support for this topic?! Would've been nice to have this feature working though...
Title: Re: RSS Injector available
Post by: SEO on June 13, 2006, 03:30:47 PM
If you are really interested in it put up some cash to incentivise a developer.
I am sure if you offer $1000 somone will do it.
Title: Re: RSS Injector available
Post by: haktanir2 on June 14, 2006, 05:44:07 AM
If you are really interested in it put up some cash to incentivise a developer.
I am sure if you offer $1000 somone will do it.
I'm sure they would but $1000 is a lot, especially since some people got it to work without further development.

I'm just curious if someone faced the exact same problem as I did, being that the php just gives a blank page.
Title: Re: RSS Injector available
Post by: L.G.S on June 14, 2006, 11:16:53 AM
It's not a problem, that's what happens. Read the first pages and you will see that it gives no feedback once done.
Title: Re: RSS Injector available
Post by: spun2u on June 20, 2006, 03:19:11 PM
This mod is working fine for me.

Thanks for the time taken to post this originally for all of to find and use!!


Title: Re: RSS Injector available
Post by: sanax on June 20, 2006, 03:54:39 PM
Sorry... maybe a dumb question... where and how do I get the userID?
Title: Re: RSS Injector available
Post by: carlatf on June 28, 2006, 09:06:43 PM
Sorry... maybe a dumb question... where and how do I get the userID?

Admin -> Users  the ID is listed in your table of users.

or yourdomain.com/index.php?action=viewmembers

Btw, is there any news on the RSS injector mod, I'm about to test the injector script but I read somewhere that someone was making a mod....

Best.
Carla
Title: Re: RSS Injector available
Post by: haktanir2 on June 29, 2006, 07:37:45 PM
It's not a problem, that's what happens. Read the first pages and you will see that it gives no feedback once done.
Alright but I also get no injection in the forum.
Title: Re: RSS Injector available
Post by: Niteblade on June 30, 2006, 07:42:54 PM
If you are really interested in it put up some cash to incentivise a developer.
I am sure if you offer $1000 somone will do it.

It's already done. I've seen it in action and it works wonderfully and elegantly. But the code author, *cough* , is really, really busy. Perhaps he should release it as an unfinished mod and let someone else pick up where he left off. *shrug*

I keep on sacrificing goats, but it doesn't help. I've tried financial bribery, and he won't be bribed. I've offered beer, women, and cigarettes, but still, all to no avail.
Title: Re: RSS Injector available
Post by: TLM on July 11, 2006, 09:56:28 AM
If you are really interested in it put up some cash to incentivise a developer.
I am sure if you offer $1000 somone will do it.

It's already done. I've seen it in action and it works wonderfully and elegantly. But the code author, *cough* , is really, really busy. Perhaps he should release it as an unfinished mod and let someone else pick up where he left off. *shrug*

I keep on sacrificing goats, but it doesn't help. I've tried financial bribery, and he won't be bribed. I've offered beer, women, and cigarettes, but still, all to no avail.
Women! You did not offer such thing!

For those complaining about how this mod has to have seperate news files, mine does not, it stores in the DB, and no real settings to edit as long as your forum sql data is right.

I might get to this hidden project of mine this weekend, maybe.
For those interested in seeing its progress, just lacking admin interface and packaging...
http://www.mindlesstux.com/forums/index.php?board=14.0
Title: Re: RSS Injector available
Post by: SEO on July 11, 2006, 10:53:21 AM
http://www.mindlesstux.com/forums/index.php?topic=1493.msg1514#msg1514

wow
thats really superb
Title: Re: RSS Injector available
Post by: haktanir2 on July 12, 2006, 09:18:43 AM
Any update on an RSS Injector that works for everyone?

Eahn time I check someone says in a week it will be done...heheh...
Title: Re: RSS Injector available
Post by: tarkhorani on July 15, 2006, 10:57:23 AM
here is a more user friendly version...and way of presenting to noobs like me.

http://www.pakeconomist.com//Varius%20Pics/injector.rar

unzip it. (needs winrar) and then open the file news.php in wordpad and edit all the fields which need to be edited.

(upto the source of the feed)

save the file as news.php
and upload it.

then you can open the http://www.yourdomain.etc\injector\news.php

and a blank screen will come....thats it.

go to your forum and check the location you selected. if there are no names then that means you have entered the username and not the userid (which is usualy the number)

any problems...report here.

download not work
Title: Re: RSS Injector available
Post by: tarkhorani on July 15, 2006, 11:06:53 AM
what changes i Must do here to work on my forum:

Code: [Select]
[php]<?xml version="1.0" encoding="iso-8859-1"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Stelesys Internet Hosting - Home</title>
<meta name="description" content="Mambo - the dynamic portal engine and content management system" />
<meta name="keywords" content="mambo, Mambo" />
<meta name="Generator" content="Joomla! - Copyright (C) 2005 - 2006 Open Source Matters. All rights reserved." />
<meta name="robots" content="index, follow" />
<link rel="shortcut icon" href="http://www.stelesys.com/images/favicon.ico" />
<!-- Design by Brian Diaz of Media 65 @ http://www.joomlalabs.com All Rights Reserved -->
<meta name="Generator" content="Media 65 - Copyright 1999 - 2005 Design by Brian Diaz of Media 65 @ http://www.m65.net.  All Rights Reserved." />
<link rel="stylesheet" type="text/css" href="http://www.stelesys.com/templates/0017_lightbluediv/css/template_css.css" />
<link rel="shortcut icon" href="http://www.stelesys.com/templates/0017_lightbluediv/favicon.ico" />
  </head>
<body>

<div id="header">
<h1>Stelesys Internet Hosting </h1>
</div>

<div id="wrapper">

<div id="left">
<table cellpadding="0" cellspacing="0" class="moduletable">
<tr>
<th valign="top">
Services </th>
</tr>
<tr>
<td>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_content&amp;task=view&amp;id=14&amp;Itemid=27" class="mainlevel" >Colocation</a></td></tr>
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_content&amp;task=view&amp;id=15&amp;Itemid=28" class="mainlevel" >Managed Servers</a></td></tr>
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_content&amp;task=view&amp;id=19&amp;Itemid=31" class="mainlevel" >Web Hosting</a></td></tr>
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_content&amp;task=view&amp;id=22&amp;Itemid=41" class="mainlevel" >Forum Hosting</a></td></tr>
</table> </td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" class="moduletable">
<tr>
<th valign="top">
Main Menu </th>
</tr>
<tr>
<td>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_frontpage&amp;Itemid=1" class="mainlevel" id="active_menu">Home</a></td></tr>
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_content&amp;task=view&amp;id=20&amp;Itemid=32" class="mainlevel" >Acceptable Use</a></td></tr>
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_wrapper&amp;Itemid=33" class="mainlevel" >Support</a></td></tr>
<tr align="left"><td><a href="http://www.stelesys.com/index.php?option=com_content&amp;task=blogcategory&amp;id=15&amp;Itemid=42" class="mainlevel" >Projects</a></td></tr>
</table> </td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" class="moduletable">
<tr>
<td>
</td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" class="moduletable">
<tr>
<th valign="top">
Login Form </th>
</tr>
<tr>
<td>
<form action="http://www.stelesys.com/index.php" method="post" name="login" >

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<label for="mod_login_username">
Username </label>
<br />
<input name="username" id="mod_login_username" type="text" class="inputbox" alt="username" size="10" />
<br />
<label for="mod_login_password">
Password </label>
<br />
<input type="password" id="mod_login_password" name="passwd" class="inputbox" size="10" alt="password" />
<br />
<input type="checkbox" name="remember" id="mod_login_remember" class="inputbox" value="yes" alt="Remember Me" />
<label for="mod_login_remember">
Remember me </label>
<br />
<input type="submit" name="Submit" class="button" value="Login" />
</td>
</tr>
<tr>
<td>
<a href="http://www.stelesys.com/index.php?option=com_registration&amp;task=lostPassword">
Lost Password?</a>
</td>
</tr>
</table>

<input type="hidden" name="option" value="login" />
<input type="hidden" name="op2" value="login" />
<input type="hidden" name="lang" value="english" />
<input type="hidden" name="return" value="http://www.stelesys.com/content/view/21/34/projects/smfrssinjector.php.txt" />
<input type="hidden" name="message" value="0" />
<input type="hidden" name="9e1a2d1d306a76d3f970bbeb39d0642c" value="1" />
</form>
</td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" class="moduletable">
<tr>
<td>
<ul id="mainlevel-nav"><li><a href="http://www.stelesys.com/index.php?option=com_contact&amp;Itemid=3" class="mainlevel-nav" >Contact Us</a></li><li><a href="http://www.stelesys.com/index.php" class="mainlevel-nav" >Home</a></li></ul> </td>
</tr>
</table>


</div>
  <div id="content">
    <div id="date" align="right">Saturday, 15 July 2006</div>
<span class="pathway">Home </span><hr />
<center></center>
      <table class="blog" cellpadding="0" cellspacing="0"><tr><td valign="top"><div> <table class="contentpaneopen">
<tr>
<td class="contentheading" width="100%">
Stelesys Internet Hosting </td>
</tr>
</table>

<table class="contentpaneopen">
<tr>
<td valign="top" colspan="2">
<h3>Who is Stelesys?</h3><p>Stelesys Internet has been providing customized&nbsp;web hosting services, specializing in PHP and MySQL since 1999.&nbsp; </p><h3>Why Stelesys?</h3><p>Stelesys understands that no matter how small your site is, it is critical to you.&nbsp; We work extensively with our customers to tailor solutions to meet their needs.&nbsp; We provide a secure and reliable platform to host Internet applications on, as well as&nbsp;extensive security protections for our managed customers.</p><h3>What services does Stelesys offer?</h3><p>&nbsp;Stelesys offers FreeBSD web hosting plans, FreeBSD managed servers and FreeBSD dedicated servers for hosting your Internet applications.</p> </td>
</tr>
</table>

<span class="article_seperator">&nbsp;</span>

</div></td></tr></table> <div class="back_button">
<a href='javascript:history.go(-1)'>
[ Back ]</a>
</div>
  </div>
</div>
<br />
</div>
<div id="footer">
<!-- Note Do not remove design credit Link -->
Contact us! Phone: 678.773.3290 | E-Mail: <a href="mailto:Sales@Stelesys.com">Sales@Stelesys.com</a>
  <div align="center">
&copy; 2006 Stelesys Internet Hosting</div>

<div align="center">
<a href="http://www.joomla.org">Joomla!</a> is Free Software released under the GNU/GPL License.</div><a href="http://www.joomlalabs.com" target="_blank" style="color: #FFFFFF">Desinger</a> 
</div>
</body>
</html>
<!-- 1152974651 -->[/php]
Title: Re: RSS Injector available
Post by: Niteblade on July 15, 2006, 02:34:51 PM
If you are really interested in it put up some cash to incentivise a developer.
I am sure if you offer $1000 somone will do it.

It's already done. I've seen it in action and it works wonderfully and elegantly. But the code author, *cough* , is really, really busy. Perhaps he should release it as an unfinished mod and let someone else pick up where he left off. *shrug*

I keep on sacrificing goats, but it doesn't help. I've tried financial bribery, and he won't be bribed. I've offered beer, women, and cigarettes, but still, all to no avail.
Women! You did not offer such thing!

For those complaining about how this mod has to have seperate news files, mine does not, it stores in the DB, and no real settings to edit as long as your forum sql data is right.

I might get to this hidden project of mine this weekend, maybe.
For those interested in seeing its progress, just lacking admin interface and packaging...
http://www.mindlesstux.com/forums/index.php?board=14.0

* Crosses fingers *

I hope so.
Title: Re: RSS Injector available
Post by: confusion on July 16, 2006, 12:00:01 PM
Sorry to all.  I have been incredibly busy lately.  I wil go through the comments on this thread and make some changes according to the feedback and make sure it works with rc2.  I can probably have that working pretty quickly depending on what suprises are thrown at me this week.

It'll take me a while to make it a plug-in though.  I've had some good thoughts on how to make it work, but they haven't made it out of the "thought" stage yet. 

One thing to note: when I was developing this, I noticed that many different rss feeds had slightly different naming conventions for some of the fields.  So, it it's not working (save some incompatibility with the latest version), then that is likely the cause.

Feel free to make feature requests here.
Title: Re: RSS Injector available
Post by: confusion on July 16, 2006, 01:22:33 PM
It's already done. I've seen it in action and it works wonderfully and elegantly. But the code author, *cough* , is really, really busy. Perhaps he should release it as an unfinished mod and let someone else pick up where he left off. *shrug*

I keep on sacrificing goats, but it doesn't help. I've tried financial bribery, and he won't be bribed. I've offered beer, women, and cigarettes, but still, all to no avail.

I can say that no one has tried to bribe me.  If they had, it would be done :)

Anyhow, I have been very very busy, and I haven't done anything to prevent someone else from picking it up and running with it.  Quite honestly, at the time I made the original post, there was another person (can't recall who now) that was working on a "competing" rss injector.  He seemed to have some good ideas and a lot more time than I did, so I faded into the background.  I have gotten about 5 emails over the months about people asking for help, mostly around compatibility with RC2, and I've had every intention of responding to them, but my priorities have been elsewhere. 

I'm intending to become active again, so hopefully I can make this thing a lot more useable for the masses.

I had no idea there was so much discussion about this thing.  I was looking through my list of unanswered email and decided to pull up the original thread, and it is no 12 pages long. 

Jerry
Title: Re: RSS Injector available
Post by: tarkhorani on July 16, 2006, 04:33:19 PM
i saw that you said that request future here ; so see this:

is there any automatic poster for SMF like this:

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Ffiles.vbulletin.com%2F3.6%2Frssposter-edit.png&hash=4626e059ddd551ca28739b70c051595e)

Part 4 - Saturday June 3rd


RSS Poster Robot
vBulletin 3.6 includes a new scheduled task that can check RSS feeds from the internet, read their contents and insert items from them onto your board.



The system is fully flexible, allowing the administrator to fine-tune the items that are inserted using keywords and to control the output of the robot using special templates for both the titles and body text of inserted items, which can be inserted either as threads or as announcements.








Product System: Latest Version Check and Product URL
Products can now be associated with two URLs: the URL to the product’s home page and the URL to a special version check page. If a product URL is entered, the title of the product links to that page in the product manager.

The version check URL is slightly more complex. For the version check to function properly, the URL must return text in the form of:
Code:

<version productid="x">1.2.3</version>

With x being the ID of the product and 1.2.3 being the latest version. When a user selects “check version” for the product, the currently installed version is compared against the latest version.


Receive Private Messages from Buddies Only
You may now select to receive private messages only from users on your buddy list. If a non-buddy tries to send you a message, they will receive an error saying that you do not accept private messages. Administrators and moderators are automatically able to bypass this restriction.




“Show Private Forum” Option per Forum
While the “Show Private Forums” option has existed for quite some time, it was only controllable at the entire board level. Now, you may specify what information users without permission to view a forum can see about the forum.



For example, you likely wouldn’t want your moderator-only forum to be shown to anyone but moderators. However, if you have a specific forum that only users who bought a subscription can access, you may wish to allow normal users to see the forum name and post counts to entice them to buy a subscription.


Give Reputation Using AJAX
Reputation can now be added to a post without leaving the page. When you click the reputation icon on a post, a box will appear and allow you to choose whether you approve or disapprove of the post and provide a reason.




Error Prevention in Upgrades
Upgrading should now be less painful. The script will automatically detect if you already have the changes necessary and skip trying to add them again. The vast majority of errors that occur during upgrades should no longer happen.

This also helps with long upgrade steps that may timeout on large boards. Should this happen, you can simply refresh the page and the upgrade will continue from the exact place it stopped.




Option to Disable Scheduled Tasks
Default scheduled tasks can no longer be removed, but they can be individually disabled.




Parsed Signature Storage
Signatures are now stored in a parsed format. This increases performance when viewing a thread.


Phrased Items: Scheduled Tasks, Custom Profile Fields, Subscriptions, Holidays
These items are now all phrased so they can be translated into different values per language.


And By Popular Demand...
We have (just) added the ability to sort a forum by thread creation time by default.




That's all for today. We hope you like what we've announced so far and I'll be back tomorrow with another batch of features to show you.
__________________
All good things to those who wait.
Oops I got married!

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Ffiles.vbulletin.com%2F3.6%2Frssposter-manager.png&hash=edb5627f658f3835fde03684af8308e3)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Ffiles.vbulletin.com%2F3.6%2Frssposter-edit.png&hash=4626e059ddd551ca28739b70c051595e)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Ffiles.vbulletin.com%2F3.6%2Frssposter-forumdisplay.png&hash=d34be44eff6653188fb6f134ce5f53b8)
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Ffiles.vbulletin.com%2F3.6%2Frssposter-postbit.png&hash=34a831ae186b516de4d44179559af5f1)
Title: Re: RSS Injector available
Post by: confusion on July 16, 2006, 07:04:09 PM
That is along the lines of what I had in mind ultimately.  I suspect there will be a few steps in between.
Title: Re: RSS Injector available
Post by: TLM on July 16, 2006, 07:24:58 PM
That is along the lines of what I had in mind ultimately.  I suspect there will be a few steps in between.
Ditto, btw, I am the other person.  Maybe we should just combine projects seeing how we have similar ideas.
Title: Re: RSS Injector available
Post by: confusion on July 16, 2006, 08:21:43 PM
I'm up for that.  What do you have in the works?
Title: Re: RSS Injector available
Post by: TLM on July 16, 2006, 08:50:22 PM
What I got so far is one script file, using the database, to run thru multiple feeds.  It posts as what ever user you set, and to what ever board.  It uses a 3rd party script that parses rss feeds rather well, http://magpierss.sourceforge.net/ Right now I am working on the admin interface, and I hit a road block the stored array is not working out rather well...

*edit* forgot to add it has a better method of posting the posts, instead of what appears forcing the messages into the db, I sorta used the functions in smf which do half the work */edit*
Title: Re: RSS Injector available
Post by: boilerroom86 on July 18, 2006, 10:00:32 AM
here is a more user friendly version...and way of presenting to noobs like me.

http://www.pakeconomist.com//Varius%20Pics/injector.rar

unzip it. (needs winrar) and then open the file news.php in wordpad and edit all the fields which need to be edited.

(upto the source of the feed)

save the file as news.php
and upload it.

then you can open the http://www.yourdomain.etc\injector\news.php

and a blank screen will come....thats it.

go to your forum and check the location you selected. if there are no names then that means you have entered the username and not the userid (which is usualy the number)

any problems...report here.

download not work


well until TLM gets a chance to work on the awesome mod he is trying to put together..does anyone have the rar file from the pakeconomist site??  I would like to implement this and see if does work successfully for me..
Title: Re: RSS Injector available
Post by: forumposters on July 21, 2006, 04:55:50 PM
Looking forward to this mod and thanks very much for the two who are working on it.
Title: Re: RSS Injector available
Post by: Uber Schwarz on July 24, 2006, 11:45:53 PM
Any updates on the project?
Title: Re: RSS Injector available
Post by: TLM on July 25, 2006, 12:26:57 AM
Right now I am shooting for a triple release this coming weekend.

1) Modifications mod, adds a new menu section to admin area for larger mods that outgrow what features and options can offer, (Google Member Map, RSS Injector, and I know of 1 more that would use this)

2) RSS Injector, 0.01, wont be very polished, but functional, just solved a bug thats been plauging me for a while, :)

3) Google Member Map, complete re-write on it to APIv2 and hopefully a couple of new features...
Title: Re: RSS Injector available
Post by: Niteblade on July 25, 2006, 02:45:11 AM
Right now I am shooting for a triple release this coming weekend.

1) Modifications mod, adds a new menu section to admin area for larger mods that outgrow what features and options can offer, (Google Member Map, RSS Injector, and I know of 1 more that would use this)

2) RSS Injector, 0.01, wont be very polished, but functional, just solved a bug thats been plauging me for a while, :)

3) Google Member Map, complete re-write on it to APIv2 and hopefully a couple of new features...

I shall applaud you if this works without anyone getting hurt. :P
Title: Re: RSS Injector available
Post by: Uber Schwarz on July 25, 2006, 03:20:42 AM
Right now I am shooting for a triple release this coming weekend.

1) Modifications mod, adds a new menu section to admin area for larger mods that outgrow what features and options can offer, (Google Member Map, RSS Injector, and I know of 1 more that would use this)

2) RSS Injector, 0.01, wont be very polished, but functional, just solved a bug thats been plauging me for a while, :)

3) Google Member Map, complete re-write on it to APIv2 and hopefully a couple of new features...
Well once it is released I will be glad to test it. :)
Title: Re: RSS Injector available
Post by: haktanir2 on July 26, 2006, 11:18:17 AM
Right now I am shooting for a triple release this coming weekend.

1) Modifications mod, adds a new menu section to admin area for larger mods that outgrow what features and options can offer, (Google Member Map, RSS Injector, and I know of 1 more that would use this)

2) RSS Injector, 0.01, wont be very polished, but functional, just solved a bug thats been plauging me for a while, :)

3) Google Member Map, complete re-write on it to APIv2 and hopefully a couple of new features...
awesome!
Title: Re: RSS Injector available
Post by: lordmenace on July 27, 2006, 08:06:21 AM
Right now I am shooting for a triple release this coming weekend.

1) Modifications mod, adds a new menu section to admin area for larger mods that outgrow what features and options can offer, (Google Member Map, RSS Injector, and I know of 1 more that would use this)

2) RSS Injector, 0.01, wont be very polished, but functional, just solved a bug thats been plauging me for a while, :)

3) Google Member Map, complete re-write on it to APIv2 and hopefully a couple of new features...

Please do.
Title: Re: RSS Injector available
Post by: Alan G on July 28, 2006, 08:53:09 AM
I'd just like to say thanks for this, i've got the early version up and working and had pretty much no problems with it at all.

To give you some context this is what i'm doing:

I have a news / culture site (http://www.leftlion.co.uk) which has an rss feed for latest articles.  it's actually built in CFM but we use smf for the forum part of the site (http://www.leftlion.co.uk/forum).

At present there is a seperate article comments section on the main site, but i'd like to pull that out and use smf for comments.  So i'm now running the injector to pull new articles into an  article comments board (http://www.nottinghamculture.co.uk/leftlion/index.php?board=13.0).

That's all working fine.  However if i want to remove the current article comments system i need a way of linking from the article  to the topic in the comments board. 

So the process would ideally be:



How would i go about editing the injector to insert the new topic id into the articles database (they are both mysql db's on the same server).  is it just a case of locking the db and doing a select max? That doesn't seem very robust to me...

Any help / advise would be massively appreciated!

regards and thanks,
Alan
Title: Re: RSS Injector available
Post by: Alan G on July 28, 2006, 10:57:24 AM
No matter, i figured out how to do it.  very straightforward in the end. i canexplain how i did it if anyone is interested.

Title: Re: RSS Injector available
Post by: TLM on July 28, 2006, 01:06:48 PM
Lemme guess,
Post new topic in the forum and use ssi_news ssi_boardNews (I think thats what it is) and display from the forum directly on the front page? In the end you have a artical in the forum and on the front page, and the front page you can setup to have # comments link along with add comment.
Title: Re: RSS Injector available
Post by: Ben_S on July 30, 2006, 10:18:28 AM
I'm deffo interested when you get this done, having looked at the first one posted in this topic, I'm not entirely sure it's suitable for a board with 2.1 million posts.
Title: Re: RSS Injector available
Post by: Harro on July 30, 2006, 05:49:02 PM
Looking forward to this aswell!
Just read an article about the advantages of RSS feeds on your site ;)
Title: Re: RSS Injector available
Post by: lordmenace on August 01, 2006, 09:40:36 PM
When is the mod version  coming out. He keeps saying "in a week". Also, I want to make a forum posts automatically after I make an update on my site. This is possible, but it is annoying. Is it possible to stop the bot from posting the liunk to the original article? It is double linking, one made by me and the other made by it.
Title: Re: RSS Injector available
Post by: o_1281 on August 02, 2006, 05:02:53 AM
In the meantime can someone please explain how I can que these up into a db, have it filter by keywords and then post only the postings that have those keywords in the sentences.
Title: Re: RSS Injector available
Post by: jkrlvgn on August 04, 2006, 04:57:27 PM
If you are really interested in it put up some cash to incentivise a developer.
I am sure if you offer $1000 somone will do it.

It's already done. I've seen it in action and it works wonderfully and elegantly. But the code author, *cough* , is really, really busy. Perhaps he should release it as an unfinished mod and let someone else pick up where he left off. *shrug*

I keep on sacrificing goats, but it doesn't help. I've tried financial bribery, and he won't be bribed. I've offered beer, women, and cigarettes, but still, all to no avail.
Women! You did not offer such thing!

For those complaining about how this mod has to have seperate news files, mine does not, it stores in the DB, and no real settings to edit as long as your forum sql data is right.

I might get to this hidden project of mine this weekend, maybe.
For those interested in seeing its progress, just lacking admin interface and packaging...
http://www.mindlesstux.com/forums/index.php?board=14.0


....maybe without the packaging?  I'm itching to get it myself....
Title: Re: RSS Injector available
Post by: haktanir2 on August 05, 2006, 09:16:52 AM
any developments?
Title: Re: RSS Injector available
Post by: lordmenace on August 05, 2006, 11:51:52 PM
I guess the dev decided to keep it all for himself...
Title: Re: RSS Injector available
Post by: jkrlvgn on August 06, 2006, 09:20:23 AM
Oh, I seriously doubt he's keeping just for himself.  More than likely "it'll be done by this weekend, probably" is what he expects, and then life comes in and screws up the schedule.  I can wait.

The other injector, if you HAVE TO have one right now, works....but...like it's been said, it takes a little to set it up.  I got it working, so....it can't be too hard.

TLM, love your other mods!  This one's gonna be freakin' huge when it's done.
Title: Re: RSS Injector available
Post by: TLM on August 06, 2006, 12:01:56 PM
Oh, I seriously doubt he's keeping just for himself.  More than likely "it'll be done by this weekend, probably" is what he expects, and then life comes in and screws up the schedule.  I can wait.
We have a winner folks....  This really comes into effect when preping to move about 350mi...

TLM, love your other mods!  This one's gonna be freakin' huge when it's done.
Title: Re: RSS Injector available
Post by: Xarcell on August 07, 2006, 09:32:13 AM
Note to others:

the more you annoying him with it, the less motivated he's gonna be to do it.
Title: Re: RSS Injector available
Post by: lordmenace on August 07, 2006, 01:12:59 PM
Note to others:

the more you annoying him with it, the less motivated he's gonna be to do it.

Oh..I thought it usually worked the opposite.
Title: Re: RSS Injector available
Post by: Cool Surfer on August 07, 2006, 04:20:54 PM
here is a more user friendly version...and way of presenting to noobs like me.

http://www.pakeconomist.com//Varius%20Pics/injector.rar

unzip it. (needs winrar) and then open the file news.php in wordpad and edit all the fields which need to be edited.

(upto the source of the feed)

save the file as news.php
and upload it.

then you can open the http://www.yourdomain.etc\injector\news.php

and a blank screen will come....thats it.

go to your forum and check the location you selected. if there are no names then that means you have entered the username and not the userid (which is usualy the number)

any problems...report here.

I think problem with account. Pl check.
Title: Re: RSS Injector available
Post by: starrbuck on August 08, 2006, 11:39:18 AM
I think problem with account. Pl check.

This probably means they either didn't pay the bill or are over their bandwidth limit.
Title: Re: RSS Injector available
Post by: o_1281 on August 13, 2006, 03:22:29 PM
any updates?
Title: Re: RSS Injector available
Post by: garg on August 13, 2006, 08:57:18 PM
thank you for working on this :) I was looking for this.

The thread is getting a bit confusing. Does any one know which link is working? Thanks.
Title: Re: RSS Injector available
Post by: Uber Schwarz on August 25, 2006, 12:28:08 AM
Everyone have patience! I want this mod too but the longer we wait the better it will be.
Title: Re: RSS Injector available
Post by: L.G.S on August 29, 2006, 12:25:56 PM
I used the original code from the first few pages, but now the links which helped me do not work so I cannot reuse it :(
Title: Re: RSS Injector available
Post by: forumposters on August 29, 2006, 04:34:54 PM
When you follow the original link to the supposed rss injector mod, there's nothing there. 
Title: Re: RSS Injector available
Post by: L.G.S on August 29, 2006, 05:54:06 PM
On page two somebody reposted it and it worked
Title: Re: RSS Injector available
Post by: forumposters on August 29, 2006, 06:31:32 PM
Are you sure?  I just followed the link on page 2 to the .rar file and it's broken.
Title: Re: RSS Injector available
Post by: L.G.S on August 29, 2006, 07:49:46 PM
Not it's not to a rar file

http://www.stelesys.com/projects/smfrssinjector.php.txt
Title: Re: RSS Injector available
Post by: lordmenace on August 30, 2006, 08:21:09 PM
I don't think he's going to release it. He's had a working copy for a while AND has it installed on a live board. That was weeks ago. He's not giving it uop so let's just stop asking.
Title: Re: RSS Injector available
Post by: L.G.S on August 30, 2006, 08:36:08 PM
'd be happy if someone could just repost how to do the original script properly, because I'm in need of something like this real fast..
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 03:55:42 AM
I don't know if it'll help anyone, but I hacked a quick one together using simplepie RSS.

I'm using it very successfully at http://www.lordifans.com/forum/index.php?action=collapse;c=6;sa=expand#6 (http://www.lordifans.com/forum/index.php?action=collapse;c=6;sa=expand#6)

Download the RSS from here http://simplepie.org/ (http://simplepie.org/) and forget about the PEAR XML/RSS.

I don't have time to support it but feel free to use it.  I'm not responsible if it breaks your server or your smf installation.

Code: [Select]
<?php
//
// SMF RSS Injector by Jerry Bell - jerry@cyvin.org
// Based on the Joomla RSS import script by Max Soukhomlinov, maxs@intellectit.com.au
// 
// 
//
// This script is quick and dirty. Please remember to abide by the RSS content providers' terms of use.  

// Modified to use simplepie by Shawn Herrin herrin@gmail.com
/** the simplepie RSS library is required */
require("./includes/simplepie/simplepie.inc");

/** DATABASE Configuration */
define("DB_HOSTNAME",""); //Insert your DB server name here
define("DB_USERNAME",""); //DB username here
define("DB_PASSWD","*"); // DB password here
define("DB_DATABASE",""); //DB name here
$sSql "";
$userid 3//Set this to the SMF userid you want the messages posted from
$boardid 21;//Set this to the id of the board you want to post the messages in
$sUrl "http://yourdomain.com/feed";
$feed = new SimplePie();
$feed->feed_url($sUrl);

$feed->init();
$feed->handle_content_type();

$obj_db mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());
mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

if (
$feed->data
{    
$max $feed->get_item_quantity(20);
for ($x 0$x $max$x++) 
    {
    
$item $feed->get_item($x);
        
    
$sSql "SELECT
                COUNT(ID_MSG) AS link_match
             FROM smf_messages 
             WHERE subject = '"
addslashes($item->get_title()) ."'";
        
    
$obj_query mysql_query($sSql$obj_db) or die(mysql_error());

        
$int_count mysql_fetch_assoc($obj_query) or die(mysql_error());

        
mysql_free_result($obj_query);
        
        if (
$int_count['link_match'] == 0
        { 
$titletext addslashes($item->get_title());

$maintext "<p>" $item->get_date('j M Y') . "</p><p>" addslashes($item->get_description()) . "</p><p><a href=\"" $item->get_permalink() . "\">" $item->get_permalink() . "</a></p>";
        


        
echo("*******************************************************************<br />");
echo("title: " $titletext "<br />");
        
echo("*******************************************************************<br />");
$sSql "INSERT INTO smf_topics
(
ID_BOARD,
ID_MEMBER_STARTED,
ID_MEMBER_UPDATED

VALUES 
(
'
$boardid',
'
$userid',
'
$userid'
)"
;
mysql_query($sSql,$obj_db) or die(mysql_error());

$topic mysql_insert_id();

$postertime date('U');

//Insert the actual message
    $sSql "INSERT INTO smf_messages
     (
subject,
body,
  ID_MEMBER,
ID_BOARD,
ID_TOPIC,
posterTime

     VALUES 
     (
'"
$titletext ."',
'"
$maintext ."',
'
$userid',
'
$boardid',
'
$topic',
'
$postertime'
)"
;
mysql_query($sSql$obj_db) or die(mysql_error());

$messageid mysql_insert_id();

//Go back and set ID_FIRST_MSG and ID_LAST_MSG in the topics table
$sSql "UPDATE smf_topics
SET ID_FIRST_MSG = '
$messageid', 
ID_LAST_MSG = '
$messageid'
WHERE ID_TOPIC = '
$topic'";

mysql_query($sSql$obj_db) or die(mysql_error());

//Increment total posts for board
    $sSql "UPDATE smf_boards
SET numPosts = numPosts + 1, 
numTopics = numTopics + 1
WHERE ID_BOARD = '
$boardid'";
mysql_query($sSql$obj_db) or die(mysql_error());

//Increment Total Messages
$sSql "UPDATE smf_settings
SET value = value + 1
WHERE variable = 'totalMessages'"
;
mysql_query($sSql,$obj_db) or die(mysql_error());

//Increment Total Topics
    $sSql "UPDATE smf_settings
SET value = value + 1
WHERE variable = 'totalTopics'"
;
mysql_query($sSql$obj_db) or die(mysql_error());

// Increment post count for user record
    $sSql "UPDATE smf_members
                        SET posts = posts + 1
                                WHERE ID_MEMBER = '
$userid'";
mysql_query($sSql$obj_db) or die(mysql_error());
        }
        else 
        {
        
echo("There is already a match<br />");
        } 
    }
}

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>


Title: Re: RSS Injector available
Post by: Azashub on August 31, 2006, 06:01:43 AM
It's really interesting and thank you for the job!
But as a total noob can you just explain a bit more what we must do?

1. download the tool at simplepie.org
2. install the needed files on the server in a simplepie directory
3. create a php file and copy/paste (and of course adapt) your script
4. where do you save this php file?
5. what is the name of this php file?

Anyhow your work is exactly what I'm looking for!
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 07:09:50 AM
Great script, it works but I have 2 questions:

when I run it, I get this:
Warning: ./cache/http%3A%2F%2Fnews.google.com%2F%3Fned%3Dus%26topic%3Dt%26output%3Drss.spc is not writeable in /home/tscar/public_html/board/RSS/simplepie.inc on line 1252


And how would I be able to limit the width the post can go, because it is seriously screwing up my post display.

Edit:

Also how do I stop the topics coming up as new topics since last visit? When my members go on the forum they cannot remove them from the list by marking all read and the on/off button always stays on for new posts.
Title: Re: RSS Injector available
Post by: Azashub on August 31, 2006, 09:32:14 AM
Ok so we only need to run the adapted scipt, but.... how can you update the board automatically? I mean, when a new feed is coming, you have to run the script once again to add the newest news, no?

Also, all the feeds are added in an ascending manner, the top news is the latest news, the bottom news is the newest.
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 10:20:05 AM
Are you asking me?

To do them automatically you need to set up a cron job.

Your last part does not make sense, you say the top news is the latest, and the bottom is the newest, although these things are one and the same.
Title: Re: RSS Injector available
Post by: Azashub on August 31, 2006, 10:26:56 AM
I mean when I ran the script it creates me 20 new topics.

-> The topic in the top of the board section was the oldest news of the feed.
-> The topic in the bottom of the board section was the newest news of the feed.

Normally, the newest topics are on top...not on bottom. That's what I mean  :-\
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 12:08:49 PM
I'm not sure then, it works fine for me.
Title: Re: RSS Injector available
Post by: TLM on August 31, 2006, 01:03:37 PM
Some sad news on my part of my injector people want.

The hd where it was stored died in my recent move, so I lost the admin panel.  But the code for the injector and its db lived else where, so that is still alive.  I am contimplating on if I should just release the code now and come back later with a full mod when I have time or not.
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 01:06:37 PM
Great script, it works but I have 2 questions:

when I run it, I get this:
Warning: ./cache/http%3A%2F%2Fnews.google.com%2F%3Fned%3Dus%26topic%3Dt%26output%3Drss.spc is not writeable in /home/tscar/public_html/board/RSS/simplepie.inc on line 1252


And how would I be able to limit the width the post can go, because it is seriously screwing up my post display.

Edit:

Also how do I stop the topics coming up as new topics since last visit? When my members go on the forum they cannot remove them from the list by marking all read and the on/off button always stays on for new posts.

Ok, I forgot about that caching thing.  You have two options.  Create a ./cache directory in the same dir that you are running the script from and change it's permissions to be writable.  OR add the following line right after the $feed->feed_url($sUrl); line
Code: [Select]
$feed->enable_caching(false);
As far as stopping the topics from coming up as new, I have no idea.  I don't know SMF at all.

As far as the making the titles shorter, try this.

Save the following code to your server in the same directory as your news script as smart_trim.php.
Code: [Select]
<?php

#################################################
####
#### smart_trim
#### This function trims a string to a specified length.
#### Words are separated by space characters, and they are not
#### chopped if possible.
#### 
#### @package smart_trim
#### @author  Michael Gauthier <mike@silverorange.com>
#### silverorange
#### labs.silverorange.com
#### 
#### Copyright (c) 2003, silverorange Inc.
#### All rights reserved.
#### 
#### Redistribution and use in source and binary forms, with or without modification,
#### are permitted provided that the following conditions are met:
#### 
####     * Redistributions of source code must retain the above copyright notice, this
####       list of conditions and the following disclaimer.
####     * Redistributions in binary form must reproduce the above copyright notice,
####       this list of conditions and the following disclaimer in the documentation
####       and/or other materials provided with the distribution.
####     * Neither the name of silverorange Inc. nor the names of its contributors may
####       be used to endorse or promote products derived from this software without
####       specific prior written permission.
#### 
#### THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
#### ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
#### WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
#### IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
#### INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
#### BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
#### DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
#### LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
#### OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
#### OF THE POSSIBILITY OF SUCH DAMAGE.
#### 
#################################################

/**
 * Trim the string.
 *
 * @param  string  $text        The line to trim.
 * @param  integer $max_len     The maximum length of the trimmed line.
 *                              This ignores the length of the characters
 *                              that indicate trimming has occured.
 * @param  boolean $trim_middle Trimming takes place in the middle of the line
 *                              iff true. Otherwise, the line is trimmed at the
 *                              end. Defaults to false.
 * @param  string  $trim_chars  Characters to use to indicate trimming has
 *                              occured. Defaults to '...'.
 *
 * @return string               The trimmed line of text.
 */
function smart_trim($text$max_len$trim_middle false$trim_chars '...')
{
$text trim($text);

if (strlen($text) < $max_len) {

return $text;

} elseif ($trim_middle) {

$hasSpace strpos($text' ');
if (!$hasSpace) {
/**
 * The entire string is one word. Just take a piece of the
 * beginning and a piece of the end.
 */
$first_half substr($text0$max_len 2);
$last_half substr($text, -($max_len strlen($first_half)));
} else {
/**
 * Get last half first as it makes it more likely for the first
 * half to be of greater length. This is done because usually the
 * first half of a string is more recognizable. The last half can
 * be at most half of the maximum length and is potentially
 * shorter (only the last word).
 */
$last_half substr($text, -($max_len 2));
$last_half trim($last_half);
$last_space strrpos($last_half' ');
if (!($last_space === false)) {
$last_half substr($last_half$last_space 1);
}
$first_half substr($text0$max_len strlen($last_half));
$first_half trim($first_half);
if (substr($text$max_len strlen($last_half), 1) == ' ') {
/**
 * The first half of the string was chopped at a space.
 */
$first_space $max_len strlen($last_half);
} else {
$first_space strrpos($first_half' ');
}
if (!($first_space === false)) {
$first_half substr($text0$first_space);
}
}

return $first_half.$trim_chars.$last_half;

} else {

$trimmed_text substr($text0$max_len);
$trimmed_text trim($trimmed_text);
if (substr($text$max_len1) == ' ') {
/**
 * The string was chopped at a space.
 */
$last_space $max_len;
} else {
/**
 * In PHP5, we can use 'offset' here -Mike
 */
$last_space strrpos($trimmed_text' ');
}
if (!($last_space === false)) {
$trimmed_text substr($trimmed_text0$last_space);
}
return remove_trailing_punctuation($trimmed_text).$trim_chars;

}

}

/**
 * Strip trailing punctuation from a line of text.
 *
 * @param  string $text The text to have trailing punctuation removed from.
 *
 * @return string       The line of text with trailing punctuation removed.
 */
function remove_trailing_punctuation($text)
{
return preg_replace("'[^a-zA-Z_0-9]+$'s"''$text);
}
?>


Add
Code: [Select]
include ("smart_trim.php"); to the top of your news script

Then in your news script just change the line

Code: [Select]
$titletext = addslashes($item->get_title());
to

Code: [Select]
$titletext = smart_trim(addslashes($item->get_title()), 50, false, "...");
Where 50 is the max length of the title and ... is the characters to append to the end of the cut.

Additionally, change the following query as well.

Code: [Select]
    $sSql = "SELECT
                COUNT(ID_MSG) AS link_match
            FROM smf_messages
            WHERE subject = '". addslashes($item->get_title()) ."'";

to


Code: [Select]
    $sSql = "SELECT
                COUNT(ID_MSG) AS link_match
            FROM smf_messages
            WHERE subject = '". smart_trim(addslashes($item->get_title()), 50, false, "...") ."'";

I don't know if this works, I didn't do it on mine, just hoping to offer an option.
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 01:48:48 PM
Thanks for the help,

but, I meant the post itself, not the title. The content of the post stretches the page and makes sigs unreadable.

What exactly does creating the cache directory do?
Title: Re: RSS Injector available
Post by: Ben_S on August 31, 2006, 02:25:15 PM
Nicely done, herrin.

One thing I'd suggest as an enhancment though would be to use SMF's createPost function to actually post the message rather than direcly putting it into the database.
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 02:38:19 PM
Yes that's what I forgot to say, it would be nice if the posts were actually added to the overall post count / topic count.
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 02:48:58 PM
Thanks for the help,

but, I meant the post itself, not the title. The content of the post stretches the page and makes sigs unreadable.

What exactly does creating the cache directory do?

Ahhhh, you could apply the same function to the get description on this line to chop it.

Code: [Select]
$maintext = "<p>" . $item->get_date('j M Y') . "</p><p>" . addslashes($item->get_description()) . "</p><p><a href=\"" . $item->get_permalink() . "\">" . $item->get_permalink() . "</a></p>";
The simplepie caching mechanism is to make sure you aren't overloading the feed.  Like if you pull from a feed everytime a page is viewed, this will cache it and expire it so you aren't hitting the feed everytime.  For this though I don't think that's a desired feature as I assume you want to see new items everytime you run your script.
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 02:50:37 PM
Nicely done, herrin.

One thing I'd suggest as an enhancment though would be to use SMF's createPost function to actually post the message rather than direcly putting it into the database.

I didn't do anything I just stood on the shoulders of whoever wrote it first. :)

If you have a link to some documentation or explanation of the createPost function I would love to use that instead as there are some inconsistencies doing it with the method it's currently using.
Title: Re: RSS Injector available
Post by: Ben_S on August 31, 2006, 02:56:38 PM
Not sure of any documentation but the function itself is pretty simple to use, have a look in Subs-Post.php for createPost.

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 should add that the createPost function is 1.1x feature.

Also see http://www.simplemachines.org/community/index.php?topic=48529.msg348548#msg348548
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 03:18:19 PM
Not sure of any documentation but the function itself is pretty simple to use, have a look in Subs-Post.php for createPost.

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 should add that the createPost function is 1.1x feature.

Also see http://www.simplemachines.org/community/index.php?topic=48529.msg348548#msg348548

You the bomb in phantoms yo.  I'm 10 minutes from having it working.  I'll post it shortly, by the way, using that function works MUCH better!
Title: Re: RSS Injector available
Post by: 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 (http://magpierss.sourceforge.net/) 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.

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.
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 03:57:15 PM
Hey herrin, your script is seriously screwin my pages up lol.

Check here:

http://www.ruthlessintent.com/board/index.php?topic=8930.0

Login with: JTCM
Password: helper
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 04:02:02 PM
New version using a safer native SMF function. createPost()

Apparently this only works in SMF 1.1.

USE AT YOUR OWN RISK.  IT COULD SCREW UP YOUR FORUM.  IT WORKS FINE FOR ME, BUT THAT MEANS NOTHING. I CAN'T HELP YOU IF IT SCREWS UP YOUR FORUM.

Code: [Select]
<?php
/*
SMF FEED / RSS INJECTOR by Shawn Herrin - herrin@gmail.com

This script will grab a feed or even autodetect feeds and inject them into the
SMF forum of your choice.

This script is based on the great work done by:
- SMF RSS Injector by Jerry Bell - jerry@cyvin.org

** I don't know whether this is secure or unsafe or what.  I don't support it 
it's a quick hack to get a feature I need.  It could hose your SMF db.  Who knows.
Use with caution and at your own risk.
*/

error_reporting(E_ALL);

require(
"./includes/simplepie/simplepie.inc");
// these need the full path to your SMF files
require_once('/home/user/public_html/forum/SSI.php');
require_once(
'/home/user/public_html/forum/Sources/Subs-Post.php');

/** DATABASE Configuration */
define("DB_HOSTNAME","localhost"); //Insert your DB server name here
define("DB_USERNAME",""); //DB username here
define("DB_PASSWD","*"); // DB password here
define("DB_DATABASE",""); //DB name here

// initialize variables ** Don't touch these.
$sSql  "";
$aryMsgOptions = Array();
$aryTopicOptions = Array();
$aryPosterOptions = Array();

// set variables ** Modify these to match your board
$iUserId  0 // Set this to the SMF userid you want the messages posted from
$iBoardId  0; // Set this to the id of the board you want to post the messages in
$sRealName  ""; // **Not quite sure - I believe this allows you to override the realname of the $iUserId specified
$sEmailAddr  ""; // **Not quite sure - I believe this allows you to override the email address of the $iUserId specified
$iMarkAsRead TRUE// Set this either true or false This defines whether the injected posts are marked as read.
$iUpdatePostCount TRUE;// Set this to either true or false.  This defines whether to include the injected items in your post counts.
$sFeedUrl  "http://yourfeed.com/rss"// This is the feed to fetch.
$iMaxItemsToRetrieve 5// This is the max number of feed items to retreive.
// Instantiate SimplePie object
$feed = new SimplePie();

$feed->feed_url($sFeedUrl);

$feed->enable_caching(false);

$feed->init();

$feed->handle_content_type();

$obj_db mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWD) or die (mysql_error());
mysql_select_db(DB_DATABASE,$obj_db) or die (mysql_error());

if (
$feed->data
{    
$max $feed->get_item_quantity($iMaxItemsToRetrieve);
for ($x 0$x $max$x++) 
    {
    
$item $feed->get_item($x);
        
// This is a simple check to make sure that the item doesn't already exist in your SMF.
    
$sSql "SELECT
                COUNT(ID_MSG) AS ENTRY_EXISTS
             FROM smf_messages 
             WHERE subject = '"
addslashes($item->get_title()) ."'";
        
    
$obj_query mysql_query($sSql$obj_db) or die(mysql_error());

        
$int_count mysql_fetch_assoc($obj_query) or die(mysql_error());

        
mysql_free_result($obj_query);
        
        
// If it's a new item, insert it!
        
if ($int_count['ENTRY_EXISTS'] == 0
        { 
$sItemTitle addslashes($item->get_title());
//$sItemTitle = smart_trim(addslashes($item->get_title()), 50, false, "...");

$sItemBody "<p>" $item->get_date('j M Y') . "</p><p>" addslashes($item->get_description()) . "</p><p><a href=\"" $item->get_permalink() . "\">" $item->get_permalink() . "</a></p>";
 
        
// Setup the variables for creatPost()
$aryTopicOptions = array
(
        'id' => 0,
        'board' => $iBoardId,
        'mark_as_read' => $iMarkAsRead,
);

$aryPosterOptions = array
(
        'id' => $iUserId,
        'name' => $sRealName,
        'email' => $sEmailAddr,
        'ip' => '127.0.0.1',
        'update_post_count' => $iUpdatePostCount,
);

$aryMsgOptions = array
(
        'id' => 0,
        'subject' => $sItemTitle,
        'body' => $sItemBody,
);  
      
        
echo("*******************************************************************<br />\r\n");
echo("title: " $sItemTitle "<br />\r\n");
        
echo("*******************************************************************<br />\r\n");
        

        
createPost($aryMsgOptions$aryTopicOptions$aryPosterOptions);
        }
        else 
        {
        
echo("There is already a match<br />\r\n");
        } 
    }
}

if (
$obj_db) {
    @
mysql_close($obj_db);
}
?>


Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 04:03:36 PM
Do I need any rss.php extra files?

edit: nevermind I got it thanks
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 04:04:02 PM
Hey herrin, your script is seriously screwin my pages up lol.

Check here:

http://www.ruthlessintent.com/board/index.php?topic=8930.0

Login with: JTCM
Password: helper

That sucks, try the new one, otherwise, not sure what's causing it.  My guess is the formatting from the feed.  Don't know, mine works fine so far.
Title: Re: RSS Injector available
Post by: herrin on August 31, 2006, 04:05:50 PM
Now that TLM is back, I won't be updating mine anymore.  I wasn't trying to step on you, just hadn't seen any working versions and wanted to post for anyone who needed one.
Title: Re: RSS Injector available
Post by: haktanir2 on August 31, 2006, 04:10:52 PM
TLM could you give more information about the editing parts?

So I've sent the Magpie folder, but do I need any other files? It talks of SSI.php and some other stuff.

And where do I enter the username, password, feed URL, etc?
Title: Re: RSS Injector available
Post by: L.G.S on August 31, 2006, 04:11:34 PM
Hey herrin, your script is seriously screwin my pages up lol.

Check here:

http://www.ruthlessintent.com/board/index.php?topic=8930.0

Login with: JTCM
Password: helper

That sucks, try the new one, otherwise, not sure what's causing it.  My guess is the formatting from the feed.  Don't know, mine works fine so far.

Yeah same with the new one, it causes the bg colours to mess up and everything
Title: Re: RSS Injector available
Post by: vbgamer45 on August 31, 2006, 04:13:02 PM
The RSS mod is one of the ones I am really looking forward to. Just to use to make the forum look more active and to give topics for people to comment on.
Title: Re: RSS Injector available
Post by: TLM on August 31, 2006, 04:22:55 PM
Now that TLM is back, I won't be updating mine anymore.  I wasn't trying to step on you, just hadn't seen any working versions and wanted to post for anyone who needed one.
No big deal, I wanted to make a whole mod on this one, I have several ideas but its looking like I wont have time.  I figured I better release what I got, seeing how it seems to be the better so far, for supporting multiple feeds/posters/boards.

TLM could you give more information about the editing parts?

So I've sent the Magpie folder, but do I need any other files? It talks of SSI.php and some other stuff.

And where do I enter the username, password, feed URL, etc?

(assuming your forum is at /forum)
1. copy the .phps code into a text file, save as a .php and place in /forum
2. dload magpierss, and place everything in it at /forum/MagpieRSS
3. dload the sql file, and use something like phpmyadmin to load the table into the forum database
4. go back to the table you just now imported and the feilds are rather descriptive in themselves.  Just add rows with the desired information.
5. Make a cronjob or what ever to run the script, eg in linux,
0 */4 * * * php /homedirectory/forums/rss_injector.php
would run the script every 4 hours.  Note you will have to alter your path to the script as needed.
6. Enjoy hopefully.

If I ever have time that are not involved with life, priorities are to finsh the google maps mod then finsh this one.  Although I would not mind if someone made this into a mod using my code, as long as they credited me for what is due.
Title: Re: RSS Injector available
Post by: Ben_S on August 31, 2006, 04:26:04 PM
Looks good TLM, I'll probably make use of yours in a couple of weeks when I'm back from holiday.
Title: Re: RSS Injector available
Post by: TLM on August 31, 2006, 04:33:09 PM
Looks good TLM, I'll probably make use of yours in a couple of weeks when I'm back from holiday.
Hehe, no prob there, have a beer for me too. (The holiday is bday for me, and I dont plan on celerbrating it, but rather reading about 60 pages of small print books for one class)
Title: Re: RSS Injector available
Post by: o_1281 on August 31, 2006, 07:07:48 PM
I thin I have TLM mods implemented, how can I check to see if its working correctly?
Title: Re: RSS Injector available
Post by: TLM on August 31, 2006, 08:26:05 PM
Load the rss_injector.php and if you get nothing back, should have.  Then go check the forum.  Or wait till the server hits one of the 4th hour points (if thats what you set it up as).
Title: Re: RSS Injector available
Post by: o_1281 on September 01, 2006, 09:14:48 AM
works nicely, now I just need to figure out where I can have that user id set to have admin approve the postings first before putting it on the board.
Title: Re: RSS Injector available
Post by: L.G.S on September 01, 2006, 11:10:54 AM
Hey guys, how would I make the topics/posts add to the daily stats??
Title: Re: RSS Injector available
Post by: Xarcell on September 02, 2006, 11:56:10 AM
I don't understand on how to get this to work.

Where do I enter in my xml feed I want it to use? Also the board id and user id?

Title: Re: RSS Injector available
Post by: TLM on September 02, 2006, 12:51:49 PM
works nicely, now I just need to figure out where I can have that user id set to have admin approve the postings first before putting it on the board.
No feature of that exists.

Hey guys, how would I make the topics/posts add to the daily stats??
My injector should do that automatically

I don't understand on how to get this to work.

Where do I enter in my xml feed I want it to use? Also the board id and user id?
The sql table you should have installed.
Title: Re: RSS Injector available
Post by: L.G.S on September 02, 2006, 12:58:26 PM
No it doesn't,

by daily stats I mean like each day:

http://www.ruthlessintent.com/board/index.php?action=stats

I've injected at least 30 topics today but nothing show up on today's:

Total Topics: 3
Title: Re: RSS Injector available
Post by: Xarcell on September 02, 2006, 01:04:40 PM
Can you post an example of an edit in the mysql table.

I do not know mysql, but can prolly figure it out.
Title: Re: RSS Injector available
Post by: TLM on September 02, 2006, 01:48:51 PM
No it doesn't,

by daily stats I mean like each day:

http://www.ruthlessintent.com/board/index.php?action=stats

I've injected at least 30 topics today but nothing show up on today's:

Total Topics: 3
Hrm noted your on rc3, maybe something changed on that fact, I might have some time later I might look into this.
Ah that feature I never really liked....  Umm... Not sure, but if I get free time I will see what I can do....

Can you post an example of an edit in the mysql table.

I do not know mysql, but can prolly figure it out.
Install phpmyadmin and navagate to the table and insert the rows as desired...
Or read the insert line in the sql file.
Title: Re: RSS Injector available
Post by: L.G.S on September 02, 2006, 02:13:49 PM
OK then I get ya.

I know this isn't the thread but you seem helpful and I don't want to waste space making another one:

What could I do to make the stats of each day / month for admins only?
Title: Re: RSS Injector available
Post by: TLM on September 02, 2006, 02:20:47 PM
Dont think there is a way to do that with out throwing code in a template.
Title: Re: RSS Injector available
Post by: L.G.S on September 02, 2006, 03:04:36 PM
Damn ok, thanks.
Title: Re: RSS Injector available
Post by: Xarcell on September 02, 2006, 03:52:07 PM
I used/edited .sql

Code: [Select]
INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (2, 2, 1, 'http://rss.slashdot.org/Slashdot/slashdot', 1157028360);
imported it into my databse via myphpadmin

I visited the url pointing to the .phps file.

I got nothing. Did I do it right?
Title: Re: RSS Injector available
Post by: jkrlvgn on September 03, 2006, 01:41:36 AM
When you put in the rss_injector.php (make sure you take off the S), it'll come up with a blank page still.  SO..if you saw nothing, then it's right.



I had a question, though....is there anyway to get the whole story instead of just the linkback and the description?
Title: Re: RSS Injector available
Post by: Xarcell on September 03, 2006, 09:27:52 PM
I get these errors:

Warning: main(MagpieRSS/rss_fetch.inc): failed to open stream: No such file or directory in /home/.abigaildryer/xarcell/xarcell-studios.com/demo/RC3-9.5/rss_injector.php on line 11

Warning: main(MagpieRSS/rss_fetch.inc): failed to open stream: No such file or directory in /home/.abigaildryer/xarcell/xarcell-studios.com/demo/RC3-9.5/rss_injector.php on line 11

Fatal error: main(): Failed opening required 'MagpieRSS/rss_fetch.inc' (include_path='.:/usr/local/lib/php') in /home/.abigaildryer/xarcell/xarcell-studios.com/demo/RC3-9.5/rss_injector.php on line 11
Title: Re: RSS Injector available
Post by: jkrlvgn on September 03, 2006, 09:47:07 PM
Xarcell: Did you download the MagpieRSS files?  You need those, and they need to be in a directory called "MagpieRSS" specifically.  Just the extlib folder and the files ending in .inc need to be in the folder.

It works fine for me...except for my previous question, which isn't a nonworking problem, just an option I'd like to have.

If you need to know where to download the MagpieRSS files, I think there's a link in TLM's post.  If there isn't, I know you can google MagpieRSS and get it from the direct site.
Title: Re: RSS Injector available
Post by: Xarcell on September 04, 2006, 09:46:07 AM
Ok I'm a dummy. I had the Mag dir inside a magdir.

I get the blank page now like I'm supposed to. However it does not work for me. As all other feeds I have tried. No errors, no nothing. I think it has something to do with my host dreamhost. They are very SMF unfriendly...
Title: Re: RSS Injector available
Post by: jkrlvgn on September 04, 2006, 11:50:56 AM
Ugh.  *kicks Dreamhost for them*

Anyway, I knew it was something that you just overlooked, because you're usually the one that helps out with like...everything.

Basically what I did:

Made a member (BoardBot! 1.0), copied his id# (372)
Made a board (RSS TEST), copied the boardid (45)

then went into rss_injector.sql and changed everything accordingly:

Quote
--
-- Table structure for table `smf_rssfeeds`
--

CREATE TABLE IF NOT EXISTS `smf_rssfeeds` (
  `ID` int(11) NOT NULL auto_increment,
  `MEMBER_ID` int(11) NOT NULL default '372',
  `BOARD_ID` int(11) NOT NULL default '45',
  `RSS_FEED` text NOT NULL,
  `LAST_UPDATE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `smf_rssfeeds`
--

INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (1, 10, 1, 'rssfeedaddresshere', 1157028360);

I kept the feed address (highlighted in yellow) with slashdot, because I just wanted to see it work.  To add more feeds,  you just do it via the phpMyAdmin, and add as many rows as you need.  If you mess up on the row, just reset the "last update" to 0, then try it again.

Did you make sure to make a member to post the feeds?  And, also, did you change it in the .sql file?  If you forgot to import it into phpMyAdmin (which I did like...5 times), just click on the SQL tab and copy/past the code into there.


Acks.  I'm trying to cover all the bases here too....but...since you haven't been able to see any results yet, I think it's probably the last part....you have to import the sql into your database too, manually.

Lemme know if that works?  If not, maybe make a temp account, and I can set it up for you?
Title: Re: RSS Injector available
Post by: Xarcell on September 04, 2006, 12:41:58 PM
Ok, I'm getting ALOT closer to getting this to work.

Right now I cannot seem to get it to post in the right board. My member ID is 2, and my board ID is 2, but it keep posting it in in board ID 1.

my sql:

Code: [Select]
--
-- Table structure for table `smf_rssfeeds`
--

CREATE TABLE IF NOT EXISTS `smf_rssfeeds` (
  `ID` int(11) NOT NULL auto_increment,
  `MEMBER_ID` int(11) NOT NULL default '2',
  `BOARD_ID` int(11) NOT NULL default '2',
  `RSS_FEED` text NOT NULL,
  `LAST_UPDATE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `smf_rssfeeds`
--

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

Is that right?
Title: Re: RSS Injector available
Post by: jkrlvgn on September 04, 2006, 12:54:39 PM
That LOOKS right...

...where's your board at?  Is it the one that's at "xboxnarc.com"?
Title: Re: RSS Injector available
Post by: TLM on September 04, 2006, 01:10:58 PM
Ugh.... I hate late night parties....



Right now I cannot seem to get it to post in the right board. My member ID is 2, and my board ID is 2, but it keep posting it in in board ID 1.
Code: [Select]
--
INSERT INTO `smf_rssfeeds` (`ID`, `MEMBER_ID`, `BOARD_ID`, `RSS_FEED`, `LAST_UPDATE`) VALUES (2, 2, 1, 'http://rss.gamespot.com/misc/rss/gamespot_updates_xbox_360.xml', 1157028360);
Problem,
IDMEMBER IDBOARD ID...
221...
Note the ID feild is 2, and BOARD ID is 1.  ID is just a thing to keep the rows seperate and have an index to work with.  ID should auto-incrment, but if it does not, make sure its the next # in line.



I had a question, though....is there anyway to get the whole story instead of just the linkback and the description?
If you want to format it, it will take a little php know how, there is a spot to where you can format it, but what your asking for will probally have two diffrent fields in the array of data so you would have to find them in the array.  I just used a generic setup for most people that would work.
Title: Re: RSS Injector available
Post by: jkrlvgn on September 04, 2006, 01:16:24 PM
...how much did you want again to make it post with the full story?  *points to Paypal*

I honestly don't know much about coding...just following instruction, and...usually fixing something that I've totally screwed up (like installing Joomla on a safemoded server....ugh!).

Anyway...if it's something that I can find myself (if you don't want to do it), just lemme know where to look...  I'm just ecstatic that it works, and wasn't all that much trouble to install!
Title: Re: RSS Injector available
Post by: Xarcell on September 04, 2006, 01:17:08 PM
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...

Title: Re: RSS Injector available
Post by: Xarcell on September 04, 2006, 01:25:12 PM
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:

Code: [Select]
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.
Title: Re: RSS Injector available
Post by: jkrlvgn on September 04, 2006, 01:28:10 PM
Just add another row, and just change the board ID (if posting to another board), I think.
Title: Re: RSS Injector available
Post by: Xarcell on September 04, 2006, 01:36:39 PM
Ya, it seems to work beautifully. Nice to see a rss injector that works with my host.
Title: Re: RSS Injector available
Post by: TLM on September 04, 2006, 01:45:34 PM
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.
Title: Re: RSS Injector available
Post by: jkrlvgn on September 04, 2006, 01:59:19 PM
...and...from there, I'm lost.  I don't see either in the rss_injector.php file.
Title: Re: RSS Injector available
Post by: TLM on September 04, 2006, 04:02:50 PM
sorry, [ t t ]

was thinking in html not bbc.
Title: Re: RSS Injector available
Post by: 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:

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

Code: [Select]
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
Title: Re: RSS Injector available
Post by: 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.
Title: Re: RSS Injector available
Post by: Xarcell on September 05, 2006, 08:31:22 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...
Title: Re: RSS Injector available
Post by: haktanir2 on September 05, 2006, 12:46:14 PM
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.
Title: Re: RSS Injector available
Post by: jkrlvgn on September 06, 2006, 01:47:41 AM
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:

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

Code: [Select]
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.


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.
Title: Re: RSS Injector available
Post by: TLM on September 06, 2006, 07:57:25 AM
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")
Title: Re: RSS Injector available
Post by: Xarcell on September 08, 2006, 11:51:21 AM
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.
Title: Re: RSS Injector available
Post by: lordmenace on September 12, 2006, 01:50:00 AM
Is there any way to have the bot grab the ENTIRE news feed?
Title: Re: RSS Injector available
Post by: TLM on September 12, 2006, 08:39:49 AM
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...
Title: Re: RSS Injector available
Post by: Uber Schwarz on September 15, 2006, 07:28:51 PM
Is anyone working on finishing this?
Title: Re: RSS Injector available
Post by: Ben_S on September 16, 2006, 11:12:02 AM
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 (http://magpierss.sourceforge.net/) 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.

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.
Title: Re: RSS Injector available
Post by: TLM on September 16, 2006, 02:45:31 PM
Is anyone working on finishing this?

If I ever have time again...
Title: Re: RSS Injector available
Post by: Xarcell on September 25, 2006, 07:58:35 PM
Anyone find what to modify to change the icon selected on the posts? I browsed through the files and didn't see anything.
Title: Re: RSS Injector available
Post by: Ben_S on September 25, 2006, 08:28:22 PM
Have a look at the post.php in the SMF sources dir and look at how that calls createPost.
Title: Re: RSS Injector available
Post by: TLM on September 25, 2006, 08:29:24 PM
Anyone find what to modify to change the icon selected on the posts? I browsed through the files and didn't see anything.

I did not try to change the icon but quick grep in the sources dir, reveals that on the $msgOptions array, add something like, 'icon' => "thumbup",
That might work, untested, and just off the top of my head during a break on studies.
Title: Re: RSS Injector available
Post by: Xarcell on September 26, 2006, 06:01:08 PM
K, it too me a minute to figure what you guys were talking about. I don't know any php.

However I think I figured it out by following your instructions.

In rss_injoector.php under "$msgOptions" I added this line: 'icon' => 'thumbup',

It seems to work.

Thanks guys...
Title: Re: RSS Injector available
Post by: haktanir2 on October 01, 2006, 07:45:54 AM
Does anyone have time to make this into a mod?
Title: Re: RSS Injector available
Post by: Sindorf on October 01, 2006, 09:04:58 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 (http://magpierss.sourceforge.net/) 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.

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.

Well, I want to thank TLM for this great script. It is working nice and fast :) But, this script doesn't work when the feed charset is other than UTF-8.

I have searched Google about this problem and I have found some information about it. The charset problem comes from PHP itself. There are some temporary solutions for using some piece of code to transform the non-UTF-8 charset to UTF-8 but I couldn't find a way to implement them into this script at least for now.

People using MagpieRSS to fetch RSS feeds are having this kind of problems also... Of course, in different applications.

Maybe this script can be modified for use in different charsets (I mean rss_injector.php, not MagpieRSS)

TLM, may I have a very very little request for you? Is it possible to modify your rss_injector.php for using non-UTF-8 RSS feed charsets? If you have time of course... If you don't have time to do, it doesn't matter.

In any case, thanks for your efforts. :)

Regards... - Sindorf
Title: Re: RSS Injector available
Post by: TLM on October 01, 2006, 11:18:09 PM
Give me a non utf-8 feed and i'll poke at it when I have time...

/me roams back to books for classes...
Title: Re: RSS Injector available
Post by: Ben_S on October 02, 2006, 08:41:22 AM
Does anyone have time to make this into a mod?

To be honest, your better off using it as it is, you aren't going to want to change your feeds that often, and if you do, it's easy via phpMyAdmin and you won't have to wait for a new version every time you upgrade etc.
Title: Re: RSS Injector available
Post by: Sindorf on October 02, 2006, 11:12:05 AM
Give me a non utf-8 feed and i'll poke at it when I have time...

/me roams back to books for classes...

Thanks TLM :)

I am giving some feeds in my native language.

http://tools.ntvmsnbc.com/rss/TECH.xml

http://www.aa.com.tr/rss/ajansguncel.xml

1st one is a television channel's (such as CNN International) RSS feed about latest Technology news.

2nd one is a local news agency. Also they have news feeds in English (http://www.aa.com.tr/rss/ajansgunceleng.xml)

I also want to provide an UTF-8 feed. In this feed, special characters (such as apostrophes or commas) cannot be seen (for example "Sindorf's White Jacket" is shown as "Sindorf?s White Jacket") Also some additional characters, which can be found in ISO-8859-9 character set, are sometimes problematic.

The feed is: http://rss.hurriyet.com.tr/rss.aspx?sectionId=12

In addition, I want to provide a feed which is written in Japanese. This is also a non-UTF-8 RSS feed, as far as I think.

http://japanese.engadget.com/rss.xml

Maybe it is better to help you a bit more. I am providing you a link, in which some guy has developed a way to fetch non-UTF8 characters using MagpieRSS.

http://minutillo.com/steve/weblog/2004/6/17/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss

I couldn't manage to solve the problem, using the provided help in the above link. But maybe it can help you find a solution quicker.

Thank you for your interest in solving this problem :) I am very grateful to you :)

Edit: I have an idea. How about changing the RSS fetching system? :) I mean, is it possible to use other PHP RSS parser script? For example, SimplePie (http://simplepie.org/) Maybe it is better (and maybe more easier) to use SimplePie for non-UTF8 charsets... What do you think about it?
Title: Re: RSS Injector available
Post by: Xarcell on October 09, 2006, 08:34:48 AM
SimplePie does look nice.

I was looking at magpie and it hasn't been updated in over a year, and clearly it has issues that need fixing.
Title: Re: RSS Injector available
Post by: simonm on October 09, 2006, 03:25:46 PM
Quote
Give me a non utf-8 feed and i'll poke at it when I have time...

... any progress with non utf-8 feeds yet?
Title: Re: RSS Injector available
Post by: TLM on October 09, 2006, 05:17:43 PM
Quote
Give me a non utf-8 feed and i'll poke at it when I have time...

... any progress with non utf-8 feeds yet?

Midterms right now, give me till end of the week before I can start to really look at this.
Title: Re: RSS Injector available
Post by: simonm on October 10, 2006, 02:08:26 PM
Quote
Give me a non utf-8 feed and i'll poke at it when I have time...

... any progress with non utf-8 feeds yet?

Midterms right now, give me till end of the week before I can start to really look at this.

no hurry... just keep up with the good work on this... and good luck with the midterms...
Title: Re: RSS Injector available
Post by: efootball on October 13, 2006, 10:06:54 AM
Thanks for the MOD TLM

The only problem i have was the cron job, just a quick search on google resolved that

See it in action here using bbc rss feeds : http://www.englishfootball.me.uk/football/index.php?board=3.0
 
 
Title: Re: RSS Injector available
Post by: RRasco on October 26, 2006, 01:10:42 PM
anyone figured out why it doesn't show the Last Post in the forum index to the right in each category?
Title: Re: RSS Injector available
Post by: TLM on October 26, 2006, 01:31:00 PM
anyone figured out why it doesn't show the Last Post in the forum index to the right in each category?
I am gonna assume your talking about the first one made by someone else, and not mine.  Last check mine does that.
Title: Re: RSS Injector available
Post by: RRasco on October 26, 2006, 01:34:41 PM
where is yours at?  i saw you reference it in alot of the posts, but didnt see a link to it.
Title: Re: RSS Injector available
Post by: TLM on October 26, 2006, 01:44:29 PM
http://www.simplemachines.org/community/index.php?topic=62121.msg709129#msg709129
Title: Re: RSS Injector available
Post by: RRasco on October 26, 2006, 03:10:39 PM
thx TLM.  how often does this update? and how?  any cron jobs needed?
Title: Re: RSS Injector available
Post by: ketchup on November 01, 2006, 02:41:34 PM
can someone make this a mods pleeese  :P
Title: Re: RSS Injector available
Post by: Xarcell on November 01, 2006, 04:14:50 PM
There is no need to make it a mod really. It's very simple.
Title: Re: RSS Injector available
Post by: ketchup on November 01, 2006, 04:23:49 PM
There is no need to make it a mod really. It's very simple.

Ok since everyone has go this down...uhm would it be too much to ask for a step by step? Without broken links?   :P
Title: Re: RSS Injector available
Post by: Xarcell on November 01, 2006, 04:25:04 PM
http://www.simplemachines.org/community/index.php?topic=62121.msg709129#msg709129
Title: Re: RSS Injector available
Post by: ketchup on November 01, 2006, 04:45:48 PM
 :-\

ok

1. I downloading the magpie file - then uploaded those files to my forum directory into a folder called MagpieRSS

2. ? I see his 2 links but how do I download those?
http://www.mindlesstux.com/rss_injector.phps
http://www.mindlesstux.com/rss_injector.sql

thnaks for the help  :D
Title: Re: RSS Injector available
Post by: ketchup on November 01, 2006, 05:45:48 PM
Ok so I make a table right

am I doing this right?

 (https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg34.imagevenue.com%2Floc542%2Fth_21091_table_122_542lo.jpg&hash=e420eaef065b2a4d0cbf2f5180cef03a) (http://img34.imagevenue.com/img.php?image=21091_table_122_542lo.jpg)

thansk frot the help!
Title: Re: RSS Injector available
Post by: TLM on November 01, 2006, 05:49:56 PM
In phpMyAdmin, you should be able to go to SQL and uplaod the sql file and it takes care of that for you.
Title: Re: RSS Injector available
Post by: ketchup on November 01, 2006, 07:20:05 PM
I get this when I tryi to import the rssinjector.sql text file ( I saved that link up top as a sql file right)

Error

SQL query:

--
-- Table structure for table `smf_rssfeeds`
--
CREATE TABLE IF NOT EXISTS `smf_rssfeeds` (
`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`MEMBER_ID` int( 11 ) NOT NULL default '0',
`BOARD_ID` int( 11 ) NOT NULL default '0',
`RSS_FEED` text NOT NULL ,
`LAST_UPDATE` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation
#1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 8

Title: Re: RSS Injector available
Post by: Xarcell on November 01, 2006, 10:23:17 PM
YOu need to drop the table smf_rssfeed. Then try to import the sql file again.
Title: Re: RSS Injector available
Post by: ketchup on November 01, 2006, 11:29:32 PM
Ok I looked over my tables 5 times I cannot find any table smf_rssfeed.  I never made one either as the other one wasn't saved (my pic up top).  ::) >:(
Title: Re: RSS Injector available
Post by: Xarcell on November 01, 2006, 11:53:29 PM
I wrote some instructions on how to add the rss_injector, and how to tweak it with Tiny Portal.

http://www.tinyportal.net/smf/index.php?topic=10239.0
Title: Re: RSS Injector available
Post by: ketchup on November 02, 2006, 12:54:21 AM
Hey that was awemsome write up made it sound much more clear!

But i got this again...I looked still don't have any rss tables to drop though  :o

Error

SQL query:

--
-- Table structure for table `smf_rssfeeds`
--
CREATE TABLE IF NOT EXISTS `smf_rssfeeds` (
`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`MEMBER_ID` int( 11 ) NOT NULL default '0',
`BOARD_ID` int( 11 ) NOT NULL default '0',
`RSS_FEED` text NOT NULL ,
`LAST_UPDATE` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation
#1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 8
Title: Re: RSS Injector available
Post by: TLM on November 02, 2006, 01:06:08 AM
Gonna go on a limb, and very tired limb at that, but it might be something with version diff of MySQL?

You could try to create the table by hand if you like, but i have to much on my plate right now to help with that.

/me goes back to working on papers for class
Title: Re: RSS Injector available
Post by: ketchup on November 02, 2006, 01:28:10 AM
ok I tried it on anoter server space and it went through no errors... :D\

BUT... when I ran injector with yahoo rss news feed

I got

Warning: main(MagpieRSS/rss_fetch.inc): failed to open stream: No such file or directory in /home/tgnabe2z/public_html/smf/rss_injector.php on line 11

Warning: main(MagpieRSS/rss_fetch.inc): failed to open stream: No such file or directory in /home/tgnabe2z/public_html/smf/rss_injector.php on line 11

Fatal error: main(): Failed opening required 'MagpieRSS/rss_fetch.inc' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tgnabe2z/public_html/smf/rss_injector.php on line 11
Title: Re: RSS Injector available
Post by: ketchup on November 02, 2006, 02:46:26 PM
hi everyone...I was so close any ideas what I need to do  :)
Title: Re: RSS Injector available
Post by: forumposters on November 02, 2006, 02:51:10 PM
Is there anyone here who would install this for a small Paypal payment?
Title: Re: RSS Injector available
Post by: Xarcell on November 02, 2006, 04:05:18 PM
@ Ketchup

Give me the URL of the site you are trying to run it on.

@forumposters

I can try...
Title: Re: RSS Injector available
Post by: ketchup on November 02, 2006, 04:52:01 PM
@ Ketchup

Give me the URL of the site you are trying to run it on.

@forumposters

I can try...

Hi i guess it doesn't matter as the mysql version must not be up to date  on the board I want it ???

On my control panel it says:
PHP version     4.4.2
MySQL version    4.0.27-standard


Is there anyway i can manually add the table? If so can someone help me with the feilds in the pic i posted above

Thanks!
Title: Re: RSS Injector available
Post by: tonilah on November 05, 2006, 09:48:57 PM
Here are some reasons why i'd like to see this as an official smf mod

1st, i don't like the idea of playing around in phpmyadmin anytime i want to add an rss link, i'm just so afraid of messing around with the tables unless it's absolutely necessary.
2nd, i'd like to eventually allow moderators or special board members to add rss links if they want....maybe even have regular members submit or suggest an rss link for mods/admins to consider....
3rd, it would be nice to configure the posts that the 'bot' makes...ie, colors, fonts, signature etc.
4th, as a mod, it will be up for constant updates and revisions in the future by other coders.

I think that this idea has great potential and would greatly benefit the smf community. 

I like the simlar mod that vbulletin has...

if somebody could look at that....
Title: Re: RSS Injector available
Post by: L.G.S on November 07, 2006, 03:52:37 PM
You don't need to touch phpmyadmin if you use the file based RSS script a few pages back. All you do is modify the file with your username and link etc and you open it and it's done.
Title: Re: RSS Injector available
Post by: tonilah on November 07, 2006, 05:05:48 PM
can you please direct me to that page?   ;D

i got the hack to work nicely ;)  but it would stil be nice to see this as a mod, as is, this is a very very very cool feature.....

Also,

**UPDATE**
??? I'm trying to set the cron job to have the rss_injector.php run automatically like posted earlier
but, i get the following message emailed back to me:

/home/*****/******/rss_injector.php: line 1: ?php: No such file or directory
/home/*****/******/rss_injector.php: line 3: //: is a directory
/home/*****/******/rss_injector.php: line 4: syntax error near unexpected token `dirname'
/home/*****/******/rss_injector.php: line 4: `@include_once(dirname(__FILE__) . '/SSI.php');'

what does that mean?  When I run the script manually, it's fine....i only get this message for cron jobs....  is the script still working?


** I figured this out, never mind..... but so that others can learn from my mistake... i set the cron job as 
Quote
0 */4 * * *  /XXXXX.com/rss_injector.php
where it should have been 
Quote
0 */4 * * *  php /XXXXX.com/rss_injector.php

duh,  :P
 
Title: Re: RSS Injector available
Post by: efootball on November 09, 2006, 08:08:46 AM
s
Title: Re: RSS Injector available
Post by: dupont24 on November 12, 2006, 12:57:33 PM
I have got TLM'S to work great... ty very much

One issue I am having and i have no expierence with cron is getting it to run.

I named the file inject.php and from my browser it runs fine....

Here is the last error I got from the cron job

/home/sprintcu/public_html/sportsforum/inject.php: line 1: ?php
: No such file or directory
/home/sprintcu/public_html/sportsforum/inject.php: line 2:
: command not found
/home/sprintcu/public_html/sportsforum/inject.php: line 3: //: is a directory
/home/sprintcu/public_html/sportsforum/inject.php: line 4: syntax error near unexpected token `dirname'
/home/sprintcu/public_html/sportsforum/inject.php: line 4: `@include_once(dirname(__FILE__) . '/SSI.php');
'

Then I renamed it to rss_injector to see if that made any difference, and get this from the cron job

/bin/sh: /home/sprintcu/public_html/sportsforum/rss_injector.php: Permission denied
Title: Re: RSS Injector available
Post by: pihutch on November 14, 2006, 09:57:54 AM
I am getting the following error when I run TLM's injector:

Quote
Fatal error: Call to undefined function: createpost() in /homepages/41/d87694803/htdocs/palmettoshutterbugs/forum/rss_injector.php on line 113

And here is that portion of the rss_injector.php (I think):

Quote
createPost($msgOptions, $topicOptions, $posterOptions);


I'm running SMF1.0.8 but will be updating to 1.0.9 as soon as I get this sorted out (one thing at a time, ya know).  Any help would be greatly appreciated.

Cheers,
Patrick
Title: Re: RSS Injector available
Post by: TLM on November 14, 2006, 10:32:19 AM
I named the file inject.php and from my browser it runs fine....
Ok....
/home/sprintcu/public_html/sportsforum/inject.php: line 1: ?php
: No such file or directory
/home/sprintcu/public_html/sportsforum/inject.php: line 2:
: command not found
/home/sprintcu/public_html/sportsforum/inject.php: line 3: //: is a directory
/home/sprintcu/public_html/sportsforum/inject.php: line 4: syntax error near unexpected token `dirname'
/home/sprintcu/public_html/sportsforum/inject.php: line 4: `@include_once(dirname(__FILE__) . '/SSI.php');
'

Then I renamed it to rss_injector to see if that made any difference, and get this from the cron job

/bin/sh: /home/sprintcu/public_html/sportsforum/rss_injector.php: Permission denied
Do you have command line access to your host?  Also are you setting up the cron job with
Code: [Select]
php rss_injector.php
Note the cmd php infront of the script.



Quote
createPost($msgOptions, $topicOptions, $posterOptions);
I'm running SMF1.0.8 but will be updating to 1.0.9 as soon as I get this sorted out (one thing at a time, ya know).  Any help would be greatly appreciated.

Not possible to upgrade to 1.1 rc3?  I never poked 1.0.8/9 at all with this so I dont know if it will work at all.
Title: Re: RSS Injector available
Post by: pihutch on November 14, 2006, 11:08:28 AM
I haven't had any success in upgrading to RC1.1/1.3.  I can't get the dang tables to convert correctly and I really don't have that much time to work around it, so I am just sticking with 1.0.8/9 until I absolutely have to upgrade.  Is this something you can look into working out for 1.0.8/9?

Cheers,
Patrick
Title: Re: RSS Injector available
Post by: TLM on November 14, 2006, 11:19:25 AM
Like you my friend, time is my enemy as well...  Otherwise I would.
Title: Re: RSS Injector available
Post by: pihutch on November 14, 2006, 06:05:03 PM
Thanks anyway, TLM.  Does anyone else have any idea what is causing this error?  I'm assuming that the createpost function is not a valid command in 1.0.x, but I have no idea what it should be.

Cheers,
Patrick
Title: Re: RSS Injector available
Post by: dupont24 on November 14, 2006, 10:29:54 PM

Code: [Select]
php rss_injector.php
Note the cmd php infront of the script.


I am trying this from cpanel I am with Bluehost and I have really no clue as to what I should be putting in the command line.

I thought i was to put a path to the file.

So I tried : sportsforum/inject.php and other various forms.....and I take it that is in correct....lol

Calling the url up in the browser works great so I thought that a cron job just basically called up the url.

What should i put in the command line.

Thanks for your help......And thanks for this great mod......now if i could only get google to index smf better.....I just switched from Vbulletin and already I can see indexing is going to be an issue......Google is not reading the posts...oh well different topic not for here....
Title: Re: RSS Injector available
Post by: haktanir2 on November 15, 2006, 04:04:19 PM
I've been trying to get this RSS injector to work for some time now, it just does not want to work so I gave up on the idea until someone can make a mod of it.

With all the complicated mods made for SMF, it just surprises me that no one still made a mod of this. It's a great concept and I'd probably pay to have this mod if I could be sure it would work.
Title: Re: RSS Injector available
Post by: RRasco on November 17, 2006, 03:10:37 PM
ok, so I got this mod working a while back.  its TLMs version.  and it works great.  i dont know if this can even be made into a mod because it requires you to install magpieRSS as well as do something with pear.  I dont even remember all the steps I did but it was pretty complex in getting it to work.  I am going to try and refresh my memory as to what I did to get it to work to help out.  If there is an easy way to make it a mod, I am going to try and do it, but I am still pretty new to PHP.  Attached is my cronjob I use to update the feeds.  You may be having permissions problems(obviously).  CHMOD it to allow write access read and execute access for all.

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fs170193323.onlinehome.us%2Fpics%2Frssinjectorcronjob.gif&hash=7fd8d7503b3a90c9787e4a191c698659)
Title: Re: RSS Injector available
Post by: buzlighty2007 on November 24, 2006, 06:45:36 PM
Is this available in a mod yet? I will definately beta test any such mod for rss injection.
Title: Re: RSS Injector available
Post by: TLM on November 24, 2006, 10:00:54 PM
Why should it be a mod?  Honestly its not that hard to install, there is no code modification and only a simple sql setup which should be almost self explanatory.  If anything all that should be done is for a better documention on how to set it up properly.  I see no point in making this a mod package for SMF as it weeds out those that don't understand the script.  I have seen peoples boards where they simple installed every package they could, and then asked what does it do, and complain it does not do what they wanted.  By not putting this into a package, I am saving myself the grief of this, either educate your selves some to understand simple instructions on how to install it, or don't use it.



RRasco, whats wrong with calling the php script via a cli php instead of attempting to "browse" to the script?  The only advantage you would get is that you would fill your logs with when the script was called is all I can see.  Is GET even a vaild cli cmd in linux/bsd boxes?  I know of wget thats it.



dupont24, you have to understand the concept of where the cronjob would start for you if you dont like playing around with paths till it works.  Most companys would dump you in something like a root folder for your site which has something like public_html, public_ftp, etc... inside public_html you put your website.  Once you figure out where they start you off at, call that home.  From there you figure the path to the script, eg

/home/mindless, is my websites home directory, but the script is in public_html/forums/rss_injector.php.  So for a cron job I have two possible options to keep things simple.

*/4 * * * * php public_html/forums/rss_injector.php
or
*/4 * * * * php /home/mindless/public_html/forums/rss_injector.php

note how I setup the paths in both examples, both would work just as well.  Adding > /dev/null to the end of both cmds/crons would be ideal if you dont want spam from the cron system.



Whom ever suggested I use simplePie, I have poked at it some and have a test version that works mostly, just a few small things here and there I need to be sure that work before I post the newer script.  Also you may have noted the old link some pages back I posted is broken, I will be fixing that sometime here in the near future.
Title: Re: RSS Injector available
Post by: Sindorf on November 26, 2006, 04:19:35 AM
Whom ever suggested I use simplePie, I have poked at it some and have a test version that works mostly, just a few small things here and there I need to be sure that work before I post the newer script.

That was me :)

Thanks for your work TLM...
Title: Re: RSS Injector available
Post by: kuklovod on November 26, 2006, 05:18:42 AM
Thanks for the nice injector TLM, got it working with a bit of polish to have it insert text in correct codepage (but that was magPIE's fault, fixed by adding iconv to _cdata parser there).
Title: Re: RSS Injector available
Post by: georgepdog on November 30, 2006, 12:35:00 PM
Outstanding work on this code.  I have it running at Arkansas Sports Talk (http://www.arsportstalk.net/smf) under the user NewsHound.  I'm using the MagPie version, but would love to change over to SimplePie when it's offered.

I do have a request.  Some of the feeds we use will duplicate posts.  This is especially true when an article is a breaking news article.  It gets published once it breaks, but then, they either update the story to fill in more details or make some other tweak.  Since the check is by date, the story gets injected again.  I would like to see some sort of way, whether matching on the article title or the like, that I can avoid this.  I've thought about adding the code myself but time and my newness to SMF have prevented me from doing so.

Thank you very much for paving the way.  This has helped our site tremendously in keeping fresh content going on the site.
Title: Re: RSS Injector available
Post by: TLM on November 30, 2006, 02:32:16 PM
I do have a request.  Some of the feeds we use will duplicate posts.  This is especially true when an article is a breaking news article.  It gets published once it breaks, but then, they either update the story to fill in more details or make some other tweak.  Since the check is by date, the story gets injected again.  I would like to see some sort of way, whether matching on the article title or the like, that I can avoid this.  I've thought about adding the code myself but time and my newness to SMF have prevented me from doing so.

Iv accually thought about this for the same reason, just no time right now to really sit down and hash out an idea for that...
Title: Re: RSS Injector available
Post by: Uber Schwarz on December 02, 2006, 12:05:55 AM
Good work on the mod. How about someone make a new topic with the links to download it and how to install it so people don't have to search through 20+ pages? Just a suggestion. :)
Title: Re: RSS Injector available
Post by: georgepdog on December 03, 2006, 02:43:33 PM
TLM, may I have a very very little request for you? Is it possible to modify your rss_injector.php for using non-UTF-8 RSS feed charsets? If you have time of course... If you don't have time to do, it doesn't matter.

In any case, thanks for your efforts. :)

Regards... - Sindorf

I'm using the MagPie version and am having the opposite problem.  Any UTF-8 feed such as search based feeds from Yahoo or Google do not work at all.  If it is an ISO-something or other, it works beautifully.
Title: Re: RSS Injector available
Post by: Sindorf on December 03, 2006, 06:39:09 PM
Latin1 works beautifully georgepdog... (that would be ISO-8859-1) but Latin5 (which is ISO-8859-9) is not working at all...

I have searched a bit about that (shoot google) , and other people are getting some kind of errors like me...

Also some UTF-(a number) links are not working...

Maybe that's a problem of MagpieRSS... (it was updated a year and a month a ago... brrrrr... very old :)) or maybe related with the PHP itself...
Title: Re: RSS Injector available
Post by: georgepdog on December 03, 2006, 09:48:54 PM
Latin1 works beautifully georgepdog... (that would be ISO-8859-1) but Latin5 (which is ISO-8859-9) is not working at all...

I have searched a bit about that (shoot google) , and other people are getting some kind of errors like me...

Also some UTF-(a number) links are not working...

Maybe that's a problem of MagpieRSS... (it was updated a year and a month a ago... brrrrr... very old :)) or maybe related with the PHP itself...

Yep.  That's been my experience.  I think all the ones I've been successful with have been the Latin 1 feeds.

Also, I can't get any feeds through feedburner to work, but I think that has to do with their feeds not having a pubdate to use for the date compare.
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 12:57:04 AM
I don't want to step on anyone's toes but I have a modified version that:
- Uses SimplePie as the feed parser
- Pulls requested feeds from a DB table (feed url, board id, member id)
- Uses some very basic configuration settings in the php file to control the look of the post

If anyone is interested in this I will upload to my server so you can check it out (have it).  If this steps on the toe's of TLM than I didn't mean to and will not make another post on this subject.

Title: Re: RSS Injector available
Post by: TLM on December 23, 2006, 01:07:20 AM
By all means, I have little time right now to program/script anymore.

/me passes the torch on...
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 01:15:30 AM
OK.  I will get the code and SQL to build the table up on my server in the morning and post a link here - going to sleep now.

Thanx for all the work you put into it!
Title: Re: RSS Injector available
Post by: KGIII on December 23, 2006, 02:45:46 AM
I have a slight request or three...

Let us say we pull the requests from WordPress...

1) A URL inside the post isn't pulled - just the text is.
2) If it is already tagged AND you're using the tag system MOD with SMF - can those tags be pulled into the same system?
3) I think that is it BUT it was easy enough for me to do, even easy to setup the CRON jobs. For some it may not be so simple. Is it POSSIBLE to set a 4 hour CRON and/or admin control panel for that?
4) They pull 'em in backwards. A blog post made at 10:00 will show up on the top of a blog post made at 10:05... Buggered if I can figure it out.

That's all I can think of with it.
Title: Re: RSS Injector available
Post by: KGIII on December 23, 2006, 02:46:10 AM
Oh, crap, multiple feeds in a single file... That'd be nice too.
Title: Re: RSS Injector available
Post by: L.G.S on December 23, 2006, 06:17:27 AM
I don't want to step on anyone's toes but I have a modified version that:
- Uses SimplePie as the feed parser
- Pulls requested feeds from a DB table (feed url, board id, member id)
- Uses some very basic configuration settings in the php file to control the look of the post

If anyone is interested in this I will upload to my server so you can check it out (have it).  If this steps on the toe's of TLM than I didn't mean to and will not make another post on this subject.



Sounds great, could I test it ???
Title: Re: RSS Injector available
Post by: TLM on December 23, 2006, 12:25:45 PM
I have a slight request or three...

Let us say we pull the requests from WordPress...

1) A URL inside the post isn't pulled - just the text is.
2) If it is already tagged AND you're using the tag system MOD with SMF - can those tags be pulled into the same system?
3) I think that is it BUT it was easy enough for me to do, even easy to setup the CRON jobs. For some it may not be so simple. Is it POSSIBLE to set a 4 hour CRON and/or admin control panel for that?
4) They pull 'em in backwards. A blog post made at 10:00 will show up on the top of a blog post made at 10:05... Buggered if I can figure it out.

That's all I can think of with it.
Oh, crap, multiple feeds in a single file... That'd be nice too.
1) Example of this occuring?
2) Huh?  tag system mod?
3) Im sorry I am hard ass, if you cant figure out how to setup a cron job, tough cookies...
4) I think I fixed this, for most feeds unless your feed unfixes this...

5) Uh... Have you not bothered to setup my script?  Multiple feeds via sql....



Sounds great, could I test it ???

Your answer....

By all means, I have little time right now to program/script anymore.

/me passes the torch on...
OK.  I will get the code and SQL to build the table up on my server in the morning and post a link here - going to sleep now.

Thanx for all the work you put into it!
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 01:05:09 PM
I posted the code to:
http://www.veign.com/vrc_codeview.asp?type=web&id=47

Sample board where its working:
http://www.scarymind.com/index.php?board=26.0

Improvements that I need to make:
- Add the date/time stamp back to the DB when a feed was last retrieved (very easy to do just need to do it)
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 01:10:25 PM
I have a slight request or three...

Let us say we pull the requests from WordPress...

1) A URL inside the post isn't pulled - just the text is.
2) If it is already tagged AND you're using the tag system MOD with SMF - can those tags be pulled into the same system?
3) I think that is it BUT it was easy enough for me to do, even easy to setup the CRON jobs. For some it may not be so simple. Is it POSSIBLE to set a 4 hour CRON and/or admin control panel for that?
4) They pull 'em in backwards. A blog post made at 10:00 will show up on the top of a blog post made at 10:05... Buggered if I can figure it out.

That's all I can think of with it.
Oh, crap, multiple feeds in a single file... That'd be nice too.
1) Example of this occuring?
2) Huh?  tag system mod?
3) Im sorry I am hard ass, if you cant figure out how to setup a cron job, tough cookies...
4) I think I fixed this, for most feeds unless your feed unfixes this...

5) Uh... Have you not bothered to setup my script?  Multiple feeds via sql....



Sounds great, could I test it ???

Your answer....

By all means, I have little time right now to program/script anymore.

/me passes the torch on...
OK.  I will get the code and SQL to build the table up on my server in the morning and post a link here - going to sleep now.

Thanx for all the work you put into it!

TLM pretty much answered everything.   

Also, note I was never able to download TLM's version so I grabbed an earlier version that used SimplePie Feed parser and modified it to suit my needs.  So far, its works as I need without any known issues.

I will continue to support the script as needed.
Title: Re: RSS Injector available
Post by: KGIII on December 23, 2006, 06:51:08 PM
1. The link in my signature - it pulls blog posts from my blog and puts them in the news.
2. http://mods.simplemachines.org/index.php?mod=579 <-- tagging system
    http://blog.kgiii.info <-- also has tags
3. I suppose but some people might not be able to figure it out. But, as you say, tough cookies.
4 & 5. Hmm... I'll scroll back through and re-read all the posts but I'm pretty sure it is the one that Veign was using with SimplePie and so I don't think I've installed your script, instead I was posting for/to Veign to whom you'd passed the torch on.

I do believe that your's was at a mindlesstux site? If so then when I went to go download it, it was gone.
Title: Re: RSS Injector available
Post by: TLM on December 23, 2006, 07:08:58 PM
1) Did not see any specific examples, but running with the problem, some feeds encase the url in html tags.  Could have that disabled, auto linking of urls could also be another factor.  My script I did not see any flaw with this.
ex.  http://www.tpf-guild.com/forum/index.php?topic=622.0

2) Hrm interesting idea, dunno, all the feeds I played with did not have tagging systems...  /me might have something else to do now on tha huge stack of things to look at in free time.

3) Good you see it my way, it helps keep out those that install mods for the sake of installing them.  (I know people that do this and it drives me crazy)

4/5)  Yeah I moved it and forgot to relink it.  I still dont have the sql file remade again but back a few pages someone posted the create table info, just fill in the blanks and set time to 0.
http://www.mindlesstux.com/files/rss_injector.phps

*edit*
Code: [Select]
--
-- Table structure for table `smf_rssfeeds`
--

DROP TABLE IF EXISTS `smf_rssfeeds`;
CREATE TABLE `smf_rssfeeds` (
  `ID` int(11) NOT NULL default '0',
  `MEMBER_ID` int(11) NOT NULL default '0',
  `BOARD_ID` int(11) NOT NULL default '0',
  `RSS_FEED` text NOT NULL,
  `LAST_UPDATE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `smf_rssfeeds`
--


/*!40000 ALTER TABLE `smf_rssfeeds` DISABLE KEYS */;
LOCK TABLES `smf_rssfeeds` WRITE;
INSERT INTO `smf_rssfeeds` VALUES
  (0,1,14,'http://www.guildwars.com/newsarchive/rss/news-current.xml',1166836846),
  (1,1,14,'http://www.guildwars.com/support/gameupdates/rss/updates-current.xml',1166770029),
  (2,1,16,'http://steampowered.com/rss.xml',1166778000);
UNLOCK TABLES;
/*!40000 ALTER TABLE `smf_rssfeeds` ENABLE KEYS */;
The SQL Code for what I have right now on tpfguild.com
*/edit*


Oh Veign,
I just glanced at your code, you might be interested in db_query provided through SSI.php....  Saves a little more work for users to setup things.  See the .phps file linked above that will not move.
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 08:17:37 PM
Oh Veign,
I just glanced at your code, you might be interested in db_query provided through SSI.php....  Saves a little more work for users to setup things.  See the .phps file linked above that will not move.

Cool.  Will get this replaced out in the next version - sometime late tonight. 

I need to sit down and look through the Function list for SMF to see if there is anything I can gain from their code.
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 08:21:12 PM
2. http://mods.simplemachines.org/index.php?mod=579 <-- tagging system
    http://blog.kgiii.info <-- also has tags

I will have to look at how / if tags are embedded in the feed and if SimplePie parses them out. I'll check into this.
Title: Re: RSS Injector available
Post by: TLM on December 23, 2006, 08:35:27 PM
Quick glance the tages are under things like subject and catagory.  Now I have no clue as to if simplepie pulls them out.
Title: Re: RSS Injector available
Post by: Veign on December 23, 2006, 09:35:06 PM
Quick glance the tages are under things like subject and catagory.  Now I have no clue as to if simplepie pulls them out.

I can get access to them with SimplePie. 

The problem I have is making RSS Injector dependant, even slightly, on a mod. Also, not sure I want to waste the processing time checking if the mod is installed (not sure there is a simple mechanism for this).  What I would rather do is wait for tags to become part of the core SMF code and then add the functionality.
Title: Re: RSS Injector available
Post by: KGIII on December 23, 2006, 09:58:59 PM
Thanks TLM. I'll take a look at the code later and see what happens.

Here's one such example:

http://forum.kgiii.info/index.php?topic=257.0

(Though it's not your code so I don't expect you to have the answer though, well, you might?)

The line:
Microsoft seeks patent covering Web feed readers | Tech News on ZDNet

Should actually be a link, well it was at the blog...

It was, of course, wrapped in tags and so it only grabbed the text instead of the link.

That and the tagging system is pretty interesting. Getting the two to work together would be a lot like work I suppose.
Title: Re: RSS Injector available
Post by: RvG on December 26, 2006, 04:59:26 PM
I posted thde code to:
http://www.veign.com/vrc_codeview.asp?type=web&id=47

Sample board where its working:
http://www.scarymind.com/index.php?board=26.0

Improvements that I need to make:
- Add the date/time stamp back to the DB when a feed was last retrieved (very easy to do just need to do it)
Thanks. :) it works perfectly... i have tried also TLM files but I think I will use this one...  8)
Title: Re: RSS Injector available
Post by: mindiam1 on January 13, 2007, 10:53:34 PM
Where is the download for this mod file?
Title: Re: RSS Injector available
Post by: Veign on January 13, 2007, 11:26:55 PM
Did you read through any of the posts in this thread?
Title: Re: RSS Injector available
Post by: Sindorf on January 14, 2007, 09:10:09 AM
Check this mod ;)

http://custom.simplemachines.org/mods/index.php?mod=624
Title: Re: RSS Injector available
Post by: dextrous on January 16, 2007, 02:15:22 AM
I tried the zip file instruction...

but here's where I'm stuck (im a n00b!)
3) Run the rss-injector.sql script against your SMF database in MySQL (delete this file
when completed).

What does this mean?? Just requires me to upload file to the smf_forum table?? if so, then why do i have to delete it?

thanks for help.
Title: Re: RSS Injector available
Post by: ketchup on January 23, 2007, 02:32:02 AM
Can someone tell me what this means when I run the injector

Warning: main(RSS.php) [function.main]: failed to open stream: No such file or directory in /home/ag8090/domains/blahblahforums.com/public_html/forums/rss_injector1.php on line 12

Warning: main(RSS.php) [function.main]: failed to open stream: No such file or directory in /home/ag8090/domains/blahblahforums.com/public_html/forums/rss_injector1.php on line 12

Fatal error: main() [function.require]: Failed opening required 'RSS.php' (include_path='.:/usr/local/lib/php') in /home/ag8090/domains/blahblahforums.com/public_html/forums/rss_injector1.php on line 12
Title: Re: RSS Injector available
Post by: samyot on February 01, 2007, 01:24:54 PM
I posted the code to:
http://www.veign.com/vrc_codeview.asp?type=web&id=47

Sample board where its working:
http://www.scarymind.com/index.php?board=26.0

Improvements that I need to make:
- Add the date/time stamp back to the DB when a feed was last retrieved (very easy to do just need to do it)

Hi,

Is this supposed to update the Forum History part on the Statistics page of the forum?

The script has posted many new topics but the count is still 0 under New Topics....
Title: Re: RSS Injector available
Post by: confusion on February 01, 2007, 01:36:18 PM
I'm glad to see that so much has come out of my little script.  I really apologize for dumping it and not coming back to help.  Life has been quite busy for the past 18 months.
Title: Re: RSS Injector available
Post by: samyot on February 01, 2007, 01:53:44 PM
This script uses the createPost function which doesn't seem to update the log_activity table from which the stats page displays the daily stats.

Does someone know how to add the code for this to happen?
Title: Re: RSS Injector available
Post by: vipmoney on August 20, 2007, 03:03:03 AM
Does it work on 1.1.3 ?
Title: Re: RSS Injector available
Post by: Ben_S on August 20, 2007, 08:31:50 AM
Yes
Title: Re: RSS Injector available
Post by: BorderAmigos on March 14, 2008, 05:43:54 PM
Ok, I've gotten this working well, even modified a bit to suit me.  I have it running on a cron job and it is good.

Now, is there a yang to this ying?  I want a script that can also run on a cron job and delete the posts specifically created by this one.

Anything around already?  I've pulled the RemovePosts2 subs out and it's a lot of back engineering to get there.  Hoping not to re-invent the wheel.
Title: Re: RSS Injector available
Post by: Chris369 on March 25, 2008, 03:10:26 PM
Does it work on 1.1.4?
Title: Re: RSS Injector available
Post by: BorderAmigos on March 27, 2008, 11:40:42 AM
Yes it works on 1.1.4.  The issues I am having with it are that it does not update the post count and it does duplicate posts.  I also still need and automated post deletion mechanism.  I've disabled it for now.
Title: RSS Injector available - example for MYSQL editing
Post by: tulsabobt on April 09, 2008, 06:12:30 PM
Hello,

I'm pretty familiar with setting up boards and when I run the script manually I get a blank page (from previous posts that's a good thing) but I never get any posts. I have tried in mysql to change the feed to several known updating feeds to no avail.

I've yet to see someone explain exactly which mysql fields to input the variables. If someone could do that I would appreciate. I am using the "default" fields, but maybe that is wrong?

I ran the sql without customizations, which inserted rssfeeds tables just fine.

MemberID I have set to "1" under "default".
BoardID is set to 2, again under "default"
FeedURL is set to a slashdot feed url, again under "default"
(the feed is just a wordpress feec urrently that begins with http//www.site.com/rss.php or whatever- is that ok or must it be an xml file it points to?)
FeedName is also populated, under "default"

Any help you be appreciated!

Bob