RSS Topic Creator 1.2 - Updated for UBB.threads 7.7.0+
If you had been running version 1.1, your topics were being prevented from displaying on the News Portal. This release fixes that 1.1 bug, along with several other minor issues such as encoding corrections and images within the RSS feed, especially html5 img tags, and respecting responsive design guidelines.
Run the following SQL from Control Panel / Database Tools / SQL Command to retroactively correct the News Portal bug from version 1.1
Fix missing TOPIC_STATUS created by RSS Topic Creator 1.1
UPDATE ubbt_TOPICS SET TOPIC_STATUS = 'O' WHERE TOPIC_STATUS ISNULL
IIRC as long as the cache time of the feed has passed it should insert data; this should trigger when there is activity on the forum (the file is called on every page view)... So if you've never inserted data and the feeds are valid it should insert data as soon as a page on the main forum is accessed.
This script is simple and maintained just as required, so your mileage will vary.
Sorry, I do not do support in private messaging. More people can benefit from a support reply by making it public, keeping related questions within the correct thread, and on the correct domain.
From your PM to me on UBBCentral.com:
Originally Posted by Mors
I did the 1.2 upgrade on the script and I finally figured out I needed to assign a posting user. I got all that setup including creating my new topic feeds table etc.. all that went great.
It's still not posting yet. If I had you look at things what would you want to charge ?
Don't have lots of time and willing to pay for your services
If you added cache_builders/rss_topic_creator.php to your footer file, the RSS feed will update when your page footer is viewed and the "Feed Update Interval" timer expires.
You can view ubbt_TOPIC_FEEDS to see what is/is not happening. I believe that if you set LAST_BUILD to 0, the script force itself to run again.
If nothing is populating the database, you may have any of the following issues. 1/ Source feed is ATOM and not RSS 2.0. 2/ Source feed has an error in it. 3/ Source feed is empty. 4/ You are using a bad URL. 5/ You missed part of the directions within the rss_topic_creator.txt documentation. 6/ You have not set a User ID that the feeds should be posted by. 7/ You have not set a forum to put the feeds in to. 8/ Your "Format Of The Posts" is empty or incorrect. 9/ The Topic Feed is not enabled.
TIP: Create an RSS TEST FORUM so you can repete your feed fetches until you have them displaying exactly as you desire. Then you can easily delete the entire forum and all of your test posts in a single swoop of deleting that entire forum. You can also prune your tests with Control Panel > Prune Threads.
But first things first, watch your ubbt_TOPIC_FEEDS database to see if it is getting populated upon 1/ refreshing of a forum page with a footer (usually category page is easiest to do) 2/ setting LAST_BUILD to 0 to the feed in the database.
1/ You could modify the script to support ATOM instead of RSS. 2/ You could modify the script to do #1, and along side the current RSS script, so you'll have two different processors. 3/ You could install a 3rd party feed agitator that exports everything in to an RSS 2.0 template.
I currently do #3 using https://tt-rss.org/ This also gives me the benefit of having feeds from multiple sources with hundreds of posts daily. Then applying a filter, for example, "Pixel" or "Nexus" and must include "Google." Then the UBB.threads RSS Topic Creator only downloads those items from custom feed that TTRSS made for me, with its own URL, in RSS 2.0 format.
While there are many initial intents for providing/serving RSS feeds, please keep in mind that that the RSS TOPIC CREATOR script provides something that is somewhat of a grey area with respect to taking someone elses content, hosting it on your server, and presenting it as your own content.
RSS is for news syndication. Not free web content for your website.
Game scores, weather, news snippets pointing back to the source...etc. Basically being responsible with the content someone else created and is sharing.
as far as your other question on who can write this for you, feel free to open the script and look at its bits. the script is rather short. Pull up a sample RSS 2.0 and ATOM (rss/xml) file and read them. its straight forward.
its one of those things where once you set it up and it is working, there is no further adjustments needed its low level "take from column A put in to column B." stuff.
If I wanted to figure out why it's just not doing anything, though the topic feed shows up as enabled and it's standard WordPress RSS2 (?feed=rss2), and works in desktop RSS viewers - what would I do? Is there a good place to put in a "log errors" command?