[ABD] lastRSS autoposting bot MOD (0.1.4)

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
User avatar
Smix
Registered User
Posts: 482
Joined: Mon Sep 11, 2006 1:07 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by Smix »

Thanks ibelphegor for quick answer ;) ...

Hello TiTex,
it´s not the same bug as ibelphegor reported, so thank you too! ...

:roll: Well, that means, we have two bugs, which must be fixed :evil:

TiTex
Registered User
Posts: 79
Joined: Sun Jul 06, 2008 1:27 pm

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by TiTex »

Smix wrote:Thanks ibelphegor for quick answer ;) ...

Hello TiTex,
it´s not the same bug as ibelphegor reported, so thank you too! ...

:roll: Well, that means, we have two bugs, which must be fixed :evil:
yeah , i wanned to say "users posted before me" like this one
http://www.phpbb.com/community/viewtopi ... &start=375

so i tried other feeds and some of them are ok ... like this one
http://www.subs.ro/subtitrari/rss.php
but i still get that error in my error log even if the phpbb_lastrss_autopost table is empty or feed is working ok :shock:

Code: Select all

 lastRSS error - malformed
phpBB version 3.0.3

User avatar
MrGroove
Registered User
Posts: 24
Joined: Sun Nov 02, 2008 10:15 pm
Location: groovyPost.com
Contact:

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by MrGroove »

Great news the mod is getting close to being finished! Looking forward to the final touches w/ACP.

Nice job SMIX!

User avatar
Smix
Registered User
Posts: 482
Joined: Mon Sep 11, 2006 1:07 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by Smix »

TiTex wrote:so i tried other feeds and some of them are ok ... like this one
http://www.subs.ro/subtitrari/rss.php
Hello again,
yes this feed is working, but please post all feeds which are having problems ... I thought that this bug (as you´ve posted the pages ago) was already fixed ... :oops:

@ibelphegor
Still no progress ... :cry: :oops:

@MrGroove
Thanks :)

TiTex
Registered User
Posts: 79
Joined: Sun Jul 06, 2008 1:27 pm

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by TiTex »

i guess it's an encoding problem ... i hope you can fix it soon smix , this is a great mode for portal type forums :D
good job so far by the way

neilwiththedeal
Registered User
Posts: 19
Joined: Thu Sep 11, 2008 8:38 pm

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by neilwiththedeal »

Hi, what do I need to do to adjust the limit of posts per feed from 5? Thanks! Agregator and AP work great :D :D :D
Last edited by neilwiththedeal on Sun Nov 23, 2008 4:27 am, edited 3 times in total.

somebodee
Registered User
Posts: 1
Joined: Sun Nov 23, 2008 3:00 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by somebodee »

I'm not quite sure where to set the userid for the bot, but I'm guess it's in this part.

Code: Select all

	// prepare user data for lastRSS autopost bot
	$user_backup = $user->data;
	$sql = 'SELECT username, user_colour
		      FROM ' . USERS_TABLE . '
		      WHERE user_id = "' . $config['lastrss_ap_bot_id'] . '"';
	$result	= $db->sql_query($sql);
	$row = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);
	
	// change poster ...
	$user->data = array_merge($user->data, array(
		'user_id'		=> $config['lastrss_ap_bot_id'],
		'username'		=> $row['username'],
		'user_colour'	=> $row['user_colour'],
	));
Can anyone tell me where to add the userid?

User avatar
Smix
Registered User
Posts: 482
Joined: Mon Sep 11, 2006 1:07 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by Smix »

Hello neilwiththedeal & somebodee,
both questions are answered in :arrow: mod´s knowledge base ;)

@TiTex
Yes, it´s possibly related to encoding ... :? I really thought that it was fixed when I´ve used phpBB´s core functions for UTF-8-ising the content ...

pacca
Registered User
Posts: 5
Joined: Sat Nov 08, 2008 10:18 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by pacca »

i install all ....

i have in the table the follwing line

name url next_check next_check_after destination_id enabled
lastRSS http://phpbb3.smika.net/lastrss.php 0 1 16 1


but when i click my forum home page ... (index.php) ... it come out just a blank page !!!

can u help me ?
please

i restore the old index.php ... otherwise i had a dead forum ...
the forum direct link (id 16) is

http://www.pacca.info/public/phpbb3/viewforum.php?f=16

neilwiththedeal
Registered User
Posts: 19
Joined: Thu Sep 11, 2008 8:38 pm

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by neilwiththedeal »

Great, thanks smix!

But I have stumbled across a problem. I had the autoposter running well for a couple days, but it has stopped posted suddenly. I noticed that before it stopped, I was starting to get sql errors when I would attempt to delete posts. I would return to the previous screen, and it said the post did not exist. I didn't think much about it, because even though I was getting the errors, the posts were deleting.

I was adding some feeds in phpadmin, just like normal, and at one point I deleted an autoposted thread, but didn't get the error anymore (which was happening often). Then I noticed that all the autoposting had stopped, even after attempting to reset the next check to 0 several times, and re-adding the feeds outright.

The only other mods I had done earlier the day the autoposts stopped was increasing the max length of topic titles. But I am pretty sure autoposting was still working even after I had adjusted this...please help if you can!

subfighter
Registered User
Posts: 46
Joined: Wed Sep 05, 2007 9:10 pm

Question about lastRSS autoposting bot MOD (0.1.3)

Post by subfighter »

I have questions about this mod as i am going to use it as i had an old mod like this that i used on my phpbb2 board but know i just converted over to phpbb3.0.3 and need to find something similar to this and this how i found lastRSS as it looks like the only thing similar to what i had for phpbb 3.0.x

And i started reading the posts as i see there are hacks on getting this to work the way i need and changes also by you so is the latest download have these fixes and updates in the package..

1. Will this work with PHPBB 3.0.3

2. Can you Setup Multiple RSS FEEDS as i will be using about 6 different Feeds. nothing crazy :)

3. Also need to assign a seperate user BOT username to each feed so each feed will have its own user.. i see some posted hack for this and you saying this how it will be setup the same way.. So is this in the current package?

4. Does it extract the complete text from the ARTICLE from the RSS Feed an post it in the forum. As i looked at the examples and it looked like it did?

5. I saw that you had some code to accomplish line breaks which would be needed for it to look proper and clean formatted the way it was suppose be..

6. Photos do no seem to be parsed at the moment am i correct there.. And didnt see any hacks or any getting this working..

i need know if i can accomplish questions 1-5 at the moment and i could get by with all the features i need..

and also any news on the version below release.. :twisted:
pre-list of features for 0.2.0
* set poster per feed
* set feed auto-approving on/off
* ACP
* posting templates (via ACP)

User avatar
Smix
Registered User
Posts: 482
Joined: Mon Sep 11, 2006 1:07 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by Smix »

Hello everybody,

@pacca
Hello,
thanks for report, I´ll check it ...

@neilwiththedeal
Hello,
the "lost" posts is the bug that I actually can´t find :evil: ... If you´ll find anything more descriptive or any more informations about anything what can help me, I´ll be very happy ... Anyway thanks !

@subfighter
Hello,
  1. Yes, it will work on 3.0.3
  2. Yes, using phpMyAdmin ...
  3. It will be available in 0.2.x versions. There was a proposed hack in previous posts - you can use it this way, while I´ll develop the 0.2.x package ...
  4. Yes, complete text is extracted from the feed ...
  5. The breaking lines is a small problem, which can be fixed through the hack, which has been posted few posts ago (and will be included in next version - possibly 0.1.4 ...)
  6. No images are extracted from the feed at this time - only text ... I´ll try to do it as soon as I´ll have some more time to continue developing ...

:ugeek:

neilwiththedeal
Registered User
Posts: 19
Joined: Thu Sep 11, 2008 8:38 pm

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by neilwiththedeal »

Hey smix,

Regarding the lost posts bug, the only other thing I can think of that sticks out was that they stopped posting once I had started sending my RSS feeds into forums with an ID of 100 or over. To my recollection everything in 99 and under worked well...



ADDON: I am just going to try and do a fresh install and start over, but when I attempt to drop the lines of the autopost table I get this error:

Code: Select all

Error

SQL query: Edit

ALTER TABLE `phpbb_lastrss_autopost` DROP `name` ,
DROP `url` ,
DROP `next_check` ,
DROP `next_check_after` ,
DROP `destination_id` ,
DROP `enabled` ;

MySQL said: Documentation
#1090 - You can't delete all columns with ALTER TABLE; use DROP TABLE instead 
But then when I try and drop the table, I get this error:

Code: Select all

The server was not able to find the document (./403.shtml) you requested.
Please check the url and try again. You might also want to report this 
error to your webhost.

subfighter
Registered User
Posts: 46
Joined: Wed Sep 05, 2007 9:10 pm

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by subfighter »

hplc wrote:While I did a little patch to let every feed has its' own posting user id.

The new MySQL looks like this(just added lastrss_ap_bot_id to table phpbb_lastrss_autopost'):

Code: Select all

CREATE TABLE `phpbb_lastrss_autopost` (
  `name` varchar(255) collate utf8_bin NOT NULL,
  `url` varchar(255) collate utf8_bin NOT NULL,
  `next_check` int(10) NOT NULL,
  `next_check_after` int(2) NOT NULL,
  `lastrss_ap_bot_id` int(3) NOT NULL,
  `destination_id` int(3) NOT NULL,
  `enabled` int(1) NOT NULL,
  PRIMARY KEY  (`name`)
);

INSERT INTO `phpbb_lastrss_autopost` (`name`, `url`, `next_check`, `next_check_after`, `lastrss_ap_bot_id`, `destination_id`, `enabled`) VALUES 
('lastRSS', 'http://phpbb3.smika.net/lastrss.php', 0, 1, 3, 1, 1);

INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('lastrss_type', 'curl', 0),
('lastrss_ap_version', '0.1.3', 0),
('lastrss_ap_enabled', '1', 0),
('lastrss_ap_items_limit', '5', 0),
('lastrss_ap_bot_id', '2', 0);
the patch for functions_lastrss_autopost.php:

Code: Select all

diff -r1.2 functions_lastrss_autopost.php
19c19
<   $sql = 'SELECT name, url, next_check, next_check_after, destination_id, enaled
---
>   $sql = 'SELECT name, url, next_check, next_check_after, lastrss_ap_bot_id, estination_id, enabled
89c89
<                     WHERE user_id = "' . $config['lastrss_ap_bot_id'] . '"';
---
>                     WHERE user_id = "' . $post_data['lastrss_ap_bot_id'] . '";
96c96
<               'user_id'               => $config['lastrss_ap_bot_id'],
---
>               'user_id'               => $post_data['lastrss_ap_bot_id'],
you have a website address.. i want to add this but want to check it out and make sure it works correctly the way i want..

thanks...

User avatar
Smix
Registered User
Posts: 482
Joined: Mon Sep 11, 2006 1:07 am

Re: [DEV] lastRSS autoposting bot MOD (0.1.3)

Post by Smix »

Hello,

@neilwiththedeal
Well it´s weird that you can´t drop the table - if you are really unable to drop/remove it, try to rename the table ...

@subfighter
Yes, it´s possibly working. I´m going to make the 0.2.x version in this way. There wouldn´t be any problem while upgrading, because you´ll copy new files over this old one ... Only database structure can be different (I´m not sure, I didn´t developed it yet :lol: ) ...

Locked

Return to “[3.0.x] Abandoned MODs”