Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
This mod will import RSS feeds as new topics. You can specify which forums the topics are posted to, and who posts them.

Installation file is included in zip. Upload the files following the structure I created in the zip.

Example: [Link Removed]

A version for 7.4+ can be found here.
Attachments
2402-RSSTopicCreator.zip (13.82 KB, 99 downloads)

Sponsored Links
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
Thanks Ian.

Is this the same as the beta version?


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
it's the same as the latest one I posted in that topic, now it has instructions for installation

Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Is there an upgrade script as well, or do we need to alter tables manually?


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
alter manually

Sponsored Links
Joined: Mar 2001
Posts: 19
User
User
Offline
Joined: Mar 2001
Posts: 19
Ian this is awesome. Thank you very much.. Now to get it working for me smile

Joined: Mar 2001
Posts: 19
User
User
Offline
Joined: Mar 2001
Posts: 19
I made a mistake when entering RSS feeds that didn't have any existing data on them ie: future RSS outlets that haven't been used. The program stopped visiting any additional RSS URLs entered in the list the second it found a URL with absolutely no data on it.

So when setting up RSS feed URLs make sure they have existing data on them. When it hits a null it just stopped polling past that url. Other then that this is an oustanding mod..

Thanks so much Ian Spence smile

FYI for now smile

Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
Have added an updated version.

Joined: Mar 2001
Posts: 19
User
User
Offline
Joined: Mar 2001
Posts: 19
Thanks Ian smile

Again well done!!

Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
*curses himself for not being able to do this*

*curses himself for not being able to get other stuff to work*

frown

Sponsored Links
Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
Do we need to add the tables manually?

Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
frown

Totally unfamiliar with PhpAdmin I copy n pasted this:

Code
CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null auto_increment primary key,
USER_ID int(9) unsigned not null,
FORUM_ID int(9) unsigned not null,
FEED_URL varchar(255),
LAST_BUILD int(11) unsigned not null default '0',
LAST_TOPIC_TIME int(11) unsigned not null default '0',
CACHE_TIME int(9) unsigned not null default '30',
TITLE_PREFIX varchar(32),
BODY_FORMAT text,
FEED_IS_ENABLED tinyint(1) default '1',
FEED_WAS_ESCAPED tinyint(1) default '0',
PARSE_BBCODE tinyint(1) default '0',
TOPIC_ICON varchar(30),
REGEXP_SPECIAL text
) TYPE=MyISAM


Into my Query window...resulting in this:


Code
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 14
STR: %%
SQL: CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null auto_increment primary key,
USER_ID int(9) unsigned not null,
FORUM_ID int(9) unsigned not null,
FEED_URL varchar(255),
LAST_BUILD int(11) unsigned not null default '0',
LAST_TOPIC_TIME int(11) unsigned not null default '0',
CACHE_TIME int(9) unsigned not null default '30',
TITLE_PREFIX varchar(32),
BODY_FORMAT text,
FEED_IS_ENABLED tinyint(1) default '1',
FEED_WAS_ESCAPED tinyint(1) default '0',
X PARSE_BBCODE tinyint(1) default '0',
TOPIC_ICON varchar(30),
REGEXP_SPECIAL text
) TYPE=MyISAM


SQL query:

CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null auto_increment primary key, USER_ID int(9) unsigned not null, FORUM_ID int(9) unsigned not null, FEED_URL varchar(255), LAST_BUILD int(11) unsigned not null default '0', LAST_TOPIC_TIME int(11) unsigned not null default '0', CACHE_TIME int(9) unsigned not null default '30', TITLE_PREFIX varchar(32), BODY_FORMAT text, FEED_IS_ENABLED tinyint(1) default '1', FEED_WAS_ESCAPED tinyint(1) default '0', PARSE_BBCODE tinyint(1) default '0', TOPIC_ICON varchar(30), REGEXP_SPECIAL text ) TYPE=MyISAM

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 '%%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null


frown

Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
where it says %%TABLE_PREFIX%% replace this with your usual table prefix - probably ubbt_



Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
*sighs happily*

Thank You

smile

Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
no worries smile


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Mar 2001
Posts: 19
User
User
Offline
Joined: Mar 2001
Posts: 19
you can also use the SQL command in your control panel to do this..

Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
Thank you too.

smile

Joined: Jul 2003
Posts: 46
User
User
Offline
Joined: Jul 2003
Posts: 46
I look at this and it is 100% Greek to me. It is exactly what I am looking for, but have no clue as to what to do. I downloaded the zip file, and man I feel dumber than an ox.

Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
Upload the each of those folders to your forums directory (the directory containing ubbthreads.php)

That'll leave the structure something like

../ubbthreads.php
../cache_builders/rss_topic_creator.php
../languages/english/admin/topic_feeds.php

Then open the txt file and follow the instructions in there. You'll run the one query, replacing %%TABLE_PREFIX%% with the table prefix used at your forums.

You'll then use your trusty text editor (notepad if you have nothing better) to edit a couple of files specified, and then you upload the modified files.

Go to your control panel, click "Topic Feeds" in the left bar, and set the feeds up

Joined: Dec 2002
Posts: 67
Power User
Power User
Joined: Dec 2002
Posts: 67
Thanks for this, Ian. This was exactly what I needed.

Joined: Feb 2003
Posts: 7
Lurker
Lurker
Offline
Joined: Feb 2003
Posts: 7
I have the tables created and files uploaded / modified. I can use the admin panel to add feeds to forums, but nothing is actually taking place / nothing is bieng added to the forum.

I type in the url of script which triggers things. It executes just fine, but does not add any informaiton to the DB about the new topics it finds.

Is it possible that the changes made between 7.1 and 7.2 (some tables changed) and this mod simply do not work well togeather?


IAΩ ABPAΣAΞ AΔΩN ATA
Joined: Feb 2003
Posts: 7
Lurker
Lurker
Offline
Joined: Feb 2003
Posts: 7
After install, i had a problem where only some feeds would work. It looks like if the feed does not provide a date for each topic, the mod will not work. If that sounds right, why not change it so that it defaults to todays date?


IAΩ ABPAΣAΞ AΔΩN ATA
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
I am still getting 2 or 3 copies of each feed.

I installed the latest version from the first post, set up a new forum and linked to a new rss feed from google.

However I still got 2 or 3 copies of each feed frown


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
One thing that sucks is that sites with popular editors will take and rename the feed topic several times sometimes... Which will be grabbed each time, which is entertaining to say the least (reuters tech is what I'm viewing)


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
True - but I do not see this issue on feeds pulled in from the same sources on F*sion


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
Just noticed on this one I set up - I have two new articles - each have been repeated 10 times LOL - this is hidden at the moment from users, so it is not an issue - but it also means I can not use this script in real time yet.


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
'eh get a couple editors to troll for dups; that's ultimately what i do


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
Sorry Gizzy - not a solution frown


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
arrghhh!! Just gone to my forums and I have 5 news items - each published over 40 times frown frown

Are you serious in saying people should manually edit these daily???


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
I've never got more than 3 and it was due to changing the title


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
previously I had only had 10 - 40 copies of 5 news items was the largest frown

These are all identical, all at the same time.



Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
This won't work in 7.3; the error is:
Quote
[Sat May 10 04:50:16 2008] [error] [client 76.115.79.184] PHP Fatal error: Class 'HTML' not found in /home/undergroundnews/public_html/forum/cache_builders/rss_topic_creator.php on line 22, referer: http://www.undergroundnews.com/forum/ubbthreads.php/forums/27/1/Technology.html


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
With some help from SD I have this up and running again...

Change:
Code
// Setup the smarty class
require_once('../libs/smarty/Smarty.class.php');
$smarty = new Smarty();
$smarty->template_dir = 'templates/default';
$smarty->compile_dir = 'templates/compile';
// include all of the required libraries
require_once( "../libs/phpmailer/class.phpmailer.php" );
require_once( "../includes/config.inc.php" );
require_once( "../libs/mysql.inc.php" );
require_once( "../libs/ubbthreads.inc.php" );

/**
* Should each new item increase the user's post count?
*/
$config['TOPIC_FEED_INC_POSTCOUNT'] = true;

$html =& new html;

To:
Code
// Setup the smarty class
require('../libs/smarty/Smarty.class.php');
$smarty = new Smarty();

$smarty->template_dir = 'templates/default';
$smarty->compile_dir = 'templates/compile';

// include all of the required libraries
require_once("../libs/phpmailer/class.phpmailer.php");
require_once("../includes/config.inc.php");
require_once("../libs/mysql.inc.php");
require_once("../libs/bbcode.inc.php");
require_once("../styles/wrappers.php");
require_once("../libs/html.inc.php");
require_once("../libs/mailer.inc.php");
require_once("../libs/user.inc.php");
require_once("../libs/ubbthreads.inc.php");

/**
* Should each new item increase the user's post count?
*/
$config['TOPIC_FEED_INC_POSTCOUNT'] = true;

$html =& new html;

/me bows


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2003
Posts: 482
Enthusiast
Enthusiast
Offline
Joined: Nov 2003
Posts: 482
[Linked Image]

Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
Still creates multiple copies of feeds as posts frown

Have had to stop using it.


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Actually, I think I know the cause of that... Once I took it out of the footer (to where it's loaded every page load) and put it in the forum stats island so it's cached it only pulls one copy...

I think it's the occasional X amout of people hitting it at the same time when it's supposed to refresh that gets doubles...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Anyone have any idea why nothing is being populated to the Active Topics display?


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
To my knowledge it never was.


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
It was for me prior to 7.3 frown... At least, I recall it being lol...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
For me having 900+ posts a day, it would make little difference. wink


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Page 1 of 2 1 2

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 449
Joined: February 2008
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)