[ABD] lastRSS autoposting bot MOD (0.1.4)

Smix · Post by **Smix** » Tue Sep 23, 2008 12:32 pm

Try to use

$string_final = utf8_recode($string_to_recode, $original_encoding);

Your error is happening when feed has no encoding tag ...

clintz · Post by **clintz** » Tue Sep 23, 2008 1:44 pm

Hey Smix! Glad to see you are back!

blitztrading · Post by **blitztrading** » Tue Sep 23, 2008 1:47 pm

stupid question, but in your proposed function:

$string_final = utf8_recode($string_to_recode, $original_encoding);

how do I determine $original_encoding ? 'iso-8859-1' ?

if so, the subject should be cleaned like this:
$subject= utf8_recode($subject, 'iso-8859-1' );

Correct?

Smix · Post by **Smix** » Tue Sep 23, 2008 1:50 pm

Yes, it may work ... But it will recode all feeds ... not the only one ...

blitztrading · Post by **blitztrading** » Tue Sep 23, 2008 5:06 pm

Help !

I tried the recode function on the subject, but there is no point to do this. Actually, I checked that the topics were created, but the messages are not.

Smix, can you please have a look at the feed and error I got?

Thx

RSS feed: http://saxobanque.fr/rss

SQL ERROR [ mysql4 ]

Incorrect string value: '\xE9e, se...' for column 'post_text' at row 1 [1366]

SQL

INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES ('6', 2, 0, '82.251.118.145', 1222069900, 1, 1, 1, 1, 1, '', 'Saxo Banque | 22/09/08 - L\'actualité économique : M. Paulson au secours de l\'économie', 'Souhaitons que la\r\nsemaine qui s\'ouvre sera plus calme que la semaine pass�e, semaine historique\r\ntant par les mouvements de march�s que par les d�cisions des autorit�s\r\npubliques qu\'ont entra�n�es l\'annonce lundi dernier de la faillite de Lehman\r\nBrothers�:\r\n-��\r\nL\'annonce par le\r\nTr�sor am�ricain de la cr�ation d\'une structure devant reprendre pour 700 mds\r\nd\'USD les actifs ��toxiques�� d�tenus par les institutions financi�res\r\na �t� acceuillie avec un soulagement, voir euphorie, par la communaut�\r\n�conomique et financi�re mondiale.\r\n-��\r\nLes places\r\nboursi�res europ�ennes ont connu vendredi une journ�e historique. Le CAC a\r\nprogress� de 9.27%, effa�ant la quasi-totalit� des pertes de la semaine.\r\n�\r\nSi cette nouvelle\r\npeut marquer la fin de la crise financi�re, ne nous y trompons pas c\'est\r\nmaintenant une p�riode de grande incertitude qui nous attend�:\r\n-��\r\nA tr�s court\r\nterme, le gouvernement am�ricain doit d�terminer exactement les modalit�s de ce\r\nque l\'on appelle aujourd\'hui le plan Paulson�: Quels sont exactement les\r\nactifs qui seront rachet�s par la nouvelle structure�? Quel en sera le\r\nprix�?. On esp�re conna�tre ces modalit�s d\'ici la fin de la semaine,\r\nlaissant d\'ici l� les march�s sans tendance nette.\r\n-��\r\nA moyen et long\r\nterme, c\'est bien la question des r�percussions �conomiques de la crise\r\nfinanci�re qui se pose. A la crise financi�re le risque est de voir succ�der la\r\ncrise �conomique. Le plan Paulson, dont ce n\'est pas l\'objet, ne r�sout pas le\r\nprobl�me de l\'effondrement du march� immobilier am�ricain, de la faiblesse,\r\nvoir l\'atonie de la consommation des m�nages, de la contraction de l\'offre de\r\ncr�dit ou encore du recul du march� de l\'emploi aux Etats-Unis.\r\n�\r\nEn l\'absence de\r\npublication statistique majeure � suivre aujourd\'hui, c\'est l\'attentisme et la\r\nconsolidation qui devraient pr�valoir aujourd\'hui sur les march�s\r\nfinanciers�:\r\n-��\r\nSur les march�s\r\nactions, la tendance est � la prise de profit notamment en Europe\r\n-��\r\nSur le march� des\r\nchanges, le dollar teste actuellement des supports importants.\r\n\r\nTABLEAU DE BORD\r\n�\r\n\r\n\r\n\r\n\r\nDEVISES\r\n\r\n\r\nNiveau � 8h30\r\n\r\n\r\n+ bas\r\n\r\n\r\n+ haut\r\n\r\n\r\n\r\n\r\nEUR/USD\r\n\r\n\r\n1.4481\r\n\r\n\r\n1.4149\r\n\r\n\r\n1.4562\r\n\r\n\r\n\r\n\r\nGBP/USD\r\n\r\n\r\n1.8308\r\n\r\n\r\n1.7759\r\n\r\n\r\n1.8388\r\n\r\n\r\n\r\n\r\nUSD/JPY\r\n\r\n\r\n106.50\r\n\r\n\r\n105.36\r\n\r\n\r\n108.02\r\n\r\n\r\n\r\n\r\nUSD/CHF\r\n\r\n\r\n1.1026\r\n\r\n\r\n1.0972\r\n\r\n\r\n1.1279\r\n\r\n\r\n\r\n\r\nUSD/CAD\r\n\r\n\r\n1.0490\r\n\r\n\r\n1.0451\r\n\r\n\r\n1.0667\r\n\r\n\r\n\r\n\r\nEUR/GBP\r\n\r\n\r\n0.7904\r\n\r\n\r\n0.7946\r\n\r\n\r\n0.7931\r\n\r\n\r\n\r\n\r\nEUR/JPY\r\n\r\n\r\n154.19\r\n\r\n\r\n150.82\r\n\r\n\r\n155.50\r\n\r\n\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nMATIERES PREMIERES\r\n\r\n\r\nNiveau � 8h30\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nP�trole\r\n (WTI) ($/bar)\r\n\r\n\r\n104.90\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nOr ($/once)\r\n\r\n\r\n867.89\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nArgent ($/once)\r\n\r\n\r\n12.55\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nACTIONS\r\n\r\n\r\nCours de cl�ture\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nCAC 40\r\n\r\n\r\n4324.87\r\n (+9.27%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nDAX\r\n\r\n\r\n6189.53\r\n (+5.56%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nFTSE 100\r\n\r\n\r\n5311.30\r\n (+8.84%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nEurostoxx\r\n 50\r\n\r\n\r\n3253.53\r\n (+8.42%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nDow Jones\r\n\r\n\r\n11388.44\r\n (+3.35%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nNasdaq\r\n\r\n\r\n2273.90\r\n (+3.40%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nNikkei\r\n\r\n\r\n12091.59\r\n (+1.42%)\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\nSources�: Bloomberg, Saxo Banque\r\n(relev� � 8h30)\r\n�\r\n\r\nCALENDRIER ECONOMIQUE\r\n�\r\nPas de statistique\r\nmajeure � suivre aujourd\'hui\r\n�\r\nA suivre demain mardi\r\n23 septembre\r\n�\r\n\r\n\r\n\r\n\r\nHeure\r\n\r\n\r\nPays\r\n\r\n\r\n�v�nements\r\n\r\n\r\nP�r\r\n\r\n\r\nPr�v\r\n\r\n\r\nPr�c\r\n\r\n\r\n\r\n\r\n08:45\r\n\r\n\r\nFR\r\n\r\n\r\nConsommation des m�nages\r\n\r\n\r\nAo�t\r\n\r\n\r\n-0.1% \r\ngl.m\r\n\r\n\r\n-0.4%\r\ngl.m\r\n\r\n\r\n\r\n\r\n11�:00\r\n\r\n\r\nEC\r\n\r\n\r\nCommandes industrielles\r\n\r\n\r\nJuil\r\n\r\n\r\n-0.6%\r\ngl.m\r\n\r\n\r\n-0.3%\r\ngl.m\r\n\r\n\r\n\r\n\r\n16�:00\r\n\r\n\r\nUS\r\n\r\n\r\nIndice d\'activit� de la Fed de Richmond\r\n\r\n\r\nSept\r\n\r\n\r\n-12\r\n\r\n\r\n-16\r\n\r\n\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n�\r\n\r\n\r\n\r\n\r\n�\r\nAUTRES EVENEMENTS A SUIVRE\r\n�\r\nJapon�: publication des minutes de la r�union de la BOJ des 18 et 19\r\nao�t. \r\n \r\n © Saxo Banque 2006 \r\n [url:1mgfug71]http://saxobanque.fr/rss/l-actualite-economique-m.-paulson-au-secours-de-l-economie[/url:1mgfug71]', '224b8509d42ed54f9836490af3ccdd91', 0, 'EA==', '1mgfug71', 1, 1, 728)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_posting.php
LINE: 1856
CALL: dbal_mysql->sql_query()

FILE: includes/functions_lastrss_autopost.php
LINE: 247
CALL: submit_post()

FILE: includes/functions_lastrss_autopost.php
LINE: 95
CALL: autopost()

FILE: includes/functions_lastrss_autopost.php
LINE: 291
CALL: autopost_init()

FILE: index.php
LINE: 29
CALL: include('includes/functions_lastrss_autopost.php')

Smix · Post by **Smix** » Tue Sep 23, 2008 5:09 pm

Well I´ve checked the feed, and before trying to touch the code I can say only one thing : content of this feed is in CDATA tag, which is actually skipped in my lastrss class ...

You´ll have to wait for next version of the main class ...

Please be patient ...

prasham · Post by **prasham** » Wed Sep 24, 2008 8:10 am

Hi Guys,

While this mod looks pretty tempting I am willing to know about how error prone it is?

I have basic understanding of phpbb while the note on first page instructs me to install this mod only if I have good understanding of phpbb.

What should i do?

Smix · Post by **Smix** » Wed Sep 24, 2008 9:18 am

Hello,

I´ve noticed it, because this mod don´t have ACP management page yet and configuration is a bit "harder" than it should be with existing ACP. So some knowledge of php and phpBB is necessary - but I´ve already tell/wrote everything and there is also a short manual included in the package, containing everything you need to configure it ...

It´s not recommended to run this mod on a live board ... I recommend you to test it locally at first ...

You´ll need to know how to run SQL commands (there is a tutorial), sometimes you´ll have to edit the files and apply some hot bugfixes (or edit the configuration manually) ... When you´ll change the configuration, you have to know, that you have to purge cache ... And that´s all ...

It has some bugs, yes ... I think, all of them are known and all fixes are in this topic ... But if you don´t want to edit it yourself - please wait for next version of this mod, which will come soonly ...

Thank you

prasham · Post by **prasham** » Wed Sep 24, 2008 10:22 am

thanks for the quick reply smix.

damsprivate · Post by **damsprivate** » Wed Sep 24, 2008 10:44 am

is there a MODX or a easy install ? damn bloody hell nice mod . to bad i dont have a paypal nor a CC to support u . i just got a local bank

Smix · Post by **Smix** » Wed Sep 24, 2008 11:52 am

Hello,
MODX is not available (possibly with first BETA) yet ... I´ll do the MODX file when it become more stable and when ACP will be available ...

But installation is not difficult

...

Kalipo · Post by **Kalipo** » Thu Sep 25, 2008 10:30 pm

Installed/tested this MOD.

Although I didn't get the double-up posts in the feed forums, I did get reports of posts being published out of order in other active topics (as well as it happening to myself).

I look forward to installing the Beta as this is a wonderful and rather handy MOD.

blitztrading · Post by **blitztrading** » Fri Sep 26, 2008 8:05 am

Hi Smix,

I have another error when importing this feed : http://www.latribune.fr/Cobrand/Article ... ernational

See the error msg below.

Is that an issue with the feed format ?

Maybe useful for you to develop the next release ...

SQL ERROR [ mysql4 ]

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 'une récession en Allemagne possible à 75%""' at line 3 [1064]

SQL

SELECT topic_title FROM phpbb_topics WHERE topic_title = "La Tribune | 25/09/08 - Alexander Koch : "une récession en Allemagne possible à 75%""

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_lastrss_autopost.php
LINE: 198
CALL: dbal_mysql->sql_query()

FILE: includes/functions_lastrss_autopost.php
LINE: 95
CALL: autopost()

FILE: includes/functions_lastrss_autopost.php
LINE: 291
CALL: autopost_init()

FILE: index.php
LINE: 29
CALL: include('includes/functions_lastrss_autopost.php')

simvader · Post by **simvader** » Sat Sep 27, 2008 10:59 am

Nice MOD! can't wait when it is Beta!

Bookmarked!

Smix · Post by **Smix** » Sat Sep 27, 2008 3:34 pm

Hello,

4 blitztrading : ... it´s already a known bug ... But thanks - it´s better to report something what was already reported.

It´s nice to see that you are awaiting this mod, but please still be patient ... Next week I´ll release agregator´s RC2 and then I´ll move on this

...

advertisements