phpBB • Free and Open Source Forum Software

RSS Facebook Twitter
Menu

[RC][1.1.0-r2] FIND

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

phpBB 3.0 has reached EOL
User avatar
Mess
Registered User
Posts: 985
Joined: Wed Jul 01, 2009 6:37 am
Name: Kim

Re: [DEV] RSS Input

Post by Mess »

PoPoutdoor wrote:
Mess wrote:Hi PoPoutdoor,

Looking forward to the next release.
Here is a feature request list, so you don't get bored. ;)
  1. Option to select different users for each feed.
  2. Option to specify format for each feed.
  3. Option to keep posting a feed in the same thread.
  4. Option to post each feed in a seperate post.
  5. Option for normal members to update feeds (link/page).
  6. Option to update feeds from cron.
  7. Option to add a feed to moderation queue.
Best regards
#1 already in v0.1 by creating different bot user and you can select any RSS Bot users in ACP.
#2 Gobal BBCode format with language file in v0.2 now. I don't see the needs to have different format for each feed (I don't needed this), but you're welcome to tell me why :)
#3 & #4, hardcoded #3 by now (new topic on new day). In long term, it will be better and easier to manage (also related to server loading) if the number of posts is less, lets say under 1,000. Maybe a selection of post in the same topic of 1 day/week/month option in v0.3?
#5 & #6 Still working on this... If I get your ideas right, both related to CRON auto posting. True CRON may works as v0.2 out, but not the phpBB CRON (I can test with this after v0.2 released)
#7 I don't get that... please explain :)
Hi PoPoutdoor,

Thanks for looking over my feature requests.

2 and 7 are a solution to the same problem really. I got some feeds that only include a very short description and a link. What I did on my test board was allow the bot to post iframe's, but put all posts from the bot into the moderation queue. That way I can get the news update without having to load a new page, see if the information is needed, edit the post (delete the iframe) and approve it. Problem is I can only decide on one format for all my feeds currently. So all my feeds include iframes, which could be dangerous for my board if autoposted, or all need approving.
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

All the text posted should be in BBCode format...

Do you mean iframe after user clicking the posted links?
If yes, I don't see any solutions about this from the code, except dropping the feed import.
If NO, you better PM me the feed url and let me check this out.
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

V0.2 released :D Go to first topic for the download link :mrgreen:

Wish all Merry X'mas & Happy New Year!
Top
User avatar
or4n9e
Registered User
Posts: 2
Joined: Fri Dec 18, 2009 11:37 pm
Location: 49.51N, 08.39E

Re: [DEV] RSS Input

Post by or4n9e »

Hi,

I try to install V0.2 with AutoMod on phpbb 3.0.6 and I get

Code: Select all

Error: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 '' at line 15
CREATE TABLE phpbb_xmlfeeds ( feed_id mediumint(8) UNSIGNED NOT NULL auto_increment, feed_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, feed_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, feed_url varchar(255) DEFAULT '' NOT NULL, feed_limit smallint(4) UNSIGNED DEFAULT '0' NOT NULL, post_forum mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_limit smallint(4) UNSIGNED DEFAULT '0' NOT NULL, feed_channel tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, feed_image tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, feed_contents tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, feed_recode varchar(32) DEFAULT '' NOT NULL, robot_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL, post_feedname tinyint(1) UNSIGNED DEFAULT '0' NOT NULL
and

Code: Select all

Error: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 'PRIMARY KEY (feed_id), KEY post_forum (post_forum) ) CHARACTER SET `utf8` COLL' at line 1
PRIMARY KEY (feed_id), KEY post_forum (post_forum) ) CHARACTER SET `utf8` COLLATE `utf8_bin`
May someone please help me to get this running? The requirement php setting "allow_url_fopen = on" is met if that's important at this point (I'm not an expert with this).

Thanks in advance!
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

Sorry! There is a typo error on the sql statements:

Code: Select all

post_feedname tinyint(1) UNSIGNED DEFAULT '0' NOT NULL;
the correct line is:

Code: Select all

post_feedname tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
The download file is updated now!
Top
User avatar
or4n9e
Registered User
Posts: 2
Joined: Fri Dec 18, 2009 11:37 pm
Location: 49.51N, 08.39E

Re: [DEV] RSS Input

Post by or4n9e »

No need to apologize, thanks for the V0.2r1 update. While I got it installed now, nothing new shows up in the ACP. I purged the cache several times but unfortunately I seem to be too silly to actually use this MOD. Any suggestions?
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

Have you read the DIY section of install.xml?
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

Esolitos wrote:Two questions:
......
Second)
How can avoid making more topics each update and only make new replies to the main topic instead?
The related v0.2 posting code in functions_find:

Code: Select all

				// New topic on new day ;)
				$new_topic = ($user->format_date($latest_ts + $config['board_timezone'] + $config['board_dst'], 'Y-m-d', true) 
					== $user->format_date($last_update + $config['board_timezone'] + $config['board_dst'], 'Y-m-d', true)) ? 'reply' : 'post';

				rss_autopost($bot, $new_topic, $subject, $heading . $contents);
Where $latest_ts is the latest item date/update timestamp, and $latest_ts is the last successful feed import timestamp.

To add ACP option to set the New Topic time slot, have to add 'newpost_interval' to table phpbb_xmlfeeds and little ACP code updates. But I don't see simple way to add the logic without adding db query for the topic_time to get the first topic post time.

If I add this feature, I have to moved the "New Post" logic into function rss_autopost to do the db query for efficiency. As the autoposting code is the cutdown version of submit_post(), the changes may lead to harder support in future upgrade for new phpBB versions.

If anyone have idea to add this ACP option, please post your comments :)
Top
plasmino
Registered User
Posts: 261
Joined: Sat Jul 25, 2009 11:12 am

Re: [DEV] RSS Input

Post by plasmino »

nice..update perfect ^_^

Edit: Language italian rss input (it)_ver.0.2.zip
Top
Esolitos
Registered User
Posts: 17
Joined: Tue Apr 28, 2009 11:44 am

Re: [DEV] RSS Input

Post by Esolitos »

I've updated twice, but i get this error while trying to update..
Linux Hosting, phpBB 3.0.6

Code: Select all

General Error
SQL ERROR [ mysqli ]

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 '' at line 4 [1064]

SQL

UPDATE phpbb_topics SET topic_last_view_time = 1261394978, topic_replies_real = topic_replies_real + 1, topic_bumped = 0, topic_bumper = 0, topic_replies = topic_replies + 1, topic_last_post_id = 2442, topic_last_poster_id = 101, topic_last_poster_name = 'iPhone [RSS Bot]', topic_last_poster_colour = '9E8DA7', topic_last_post_subject = 'iSpazio - Notizie su iPhone Italiano, iPhone 3GS, iPod To...', topic_last_post_time = 1261394978 WHERE topic_id = 

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_find.php
LINE: 460
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_find.php
LINE: 220
CALL: rss_autopost()

FILE: includes/acp/acp_find.php
LINE: 84
CALL: get_rss_content()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_find->main()

FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

Esolitos,

Seems this is a database issue... my test site also have this problem once.
You have to drop the phpbb_xmlfeeds table and create a new one to fix this.

plasmino,

Thanks!

BTW, v0.2r2 will be out soon :)
Top
Esolitos
Registered User
Posts: 17
Joined: Tue Apr 28, 2009 11:44 am

Re: [DEV] RSS Input

Post by Esolitos »

I've think the same thing and i've try dropping the table but it doesn't seems to work.. :P
I'll try again.. :P

EDIT: Nope... Try 2 times, ut still gaining error...
I'll wait 2.0rc2
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

v0.2r2 released. :) Please go to first topic for download.
Top
plasmino
Registered User
Posts: 261
Joined: Sat Jul 25, 2009 11:12 am

Re: [DEV] RSS Input

Post by plasmino »

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 405: Undefined index: title
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 437: Undefined index: author
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 415: Undefined index: link
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 423: Undefined index: category
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 429: Undefined index: pubDate
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 419: Undefined index: guid
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 410: Undefined index: description
[phpBB Debug] PHP Notice: in file /includes/rss_parser.php on line 349: Undefined index: update

Warning: Cannot modify header information - headers already sent by (output started at /web/htdocs/www.ciricadoforum.it/home/forum/includes/functions.php:3504) in /web/htdocs/www.ciricadoforum.it/home/forum/adm/index.php on line 150

Warning: Cannot modify header information - headers already sent by (output started at /web/htdocs/www.ciricadoforum.it/home/forum/includes/functions.php:3504) in /web/htdocs/www.ciricadoforum.it/home/forum/adm/index.php on line 152

Warning: Cannot modify header information - headers already sent by (output started at /web/htdocs/www.ciricadoforum.it/home/forum/includes/functions.php:3504) in /web/htdocs/www.ciricadoforum.it/home/forum/adm/index.php on line 153

Warning: Cannot modify header information - headers already sent by (output started at /web/htdocs/www.ciricadoforum.it/home/forum/includes/functions.php:3504) in /web/htdocs/www.ciricadoforum.it/home/forum/adm/index.php on line 154
:o
Top
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [DEV] RSS Input

Post by PoPoutdoor »

plasmino,

Seems you doesn't follow the upgrade instructions... have you copy the language files?
Top

Return to “[3.0.x] MODs in Development”