[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!
Ideas Centre
Locked
User avatar
Mess
Registered User
Posts: 985
Joined: Wed Jul 01, 2009 6:37 am
Name: Kim

Re: [DEV] RSS Input

Post by Mess » Thu Dec 17, 2009 9:50 pm

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.

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Fri Dec 18, 2009 4:01 am

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.

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Fri Dec 18, 2009 11:33 am

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

Wish all Merry X'mas & Happy New Year!

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 » Fri Dec 18, 2009 11:42 pm

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!

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Sat Dec 19, 2009 3:32 am

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!

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 » Sat Dec 19, 2009 2:53 pm

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?

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Sat Dec 19, 2009 4:47 pm

Have you read the DIY section of install.xml?

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Mon Dec 21, 2009 8:49 am

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 :)

plasmino
Registered User
Posts: 261
Joined: Sat Jul 25, 2009 11:12 am

Re: [DEV] RSS Input

Post by plasmino » Mon Dec 21, 2009 9:21 am

nice..update perfect ^_^

Edit: Language italian rss input (it)_ver.0.2.zip

Esolitos
Registered User
Posts: 17
Joined: Tue Apr 28, 2009 11:44 am

Re: [DEV] RSS Input

Post by Esolitos » Mon Dec 21, 2009 11:31 am

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()

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Tue Dec 22, 2009 2:23 am

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 :)

Esolitos
Registered User
Posts: 17
Joined: Tue Apr 28, 2009 11:44 am

Re: [DEV] RSS Input

Post by Esolitos » Tue Dec 22, 2009 9:41 am

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

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Tue Dec 22, 2009 12:53 pm

v0.2r2 released. :) Please go to first topic for download.

plasmino
Registered User
Posts: 261
Joined: Sat Jul 25, 2009 11:12 am

Re: [DEV] RSS Input

Post by plasmino » Tue Dec 22, 2009 8:16 pm

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

User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm
Contact:

Re: [DEV] RSS Input

Post by PoPoutdoor » Wed Dec 23, 2009 2:01 am

plasmino,

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

Locked

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