New module : News Tweet

[Xagone]

Simply put : it's the news module from wb2.8 with twitter updates
( work on 2.8 )

In the settings you can enable twitter support, add your twitter id, password and a prefix to your tweets like "New : "

then when you post you post, you have the choice to tweet that news, by default, when first creating the news, it suggest to tweet about it, when done, it automaticly goes to "no";

The tweet is the prefex, the title (shorten if necessary) followed by the link to the news (shorten by http://is.gd/ )

this is a first release, some texte have been directly inputed so no multilinguage yet, BUT charset is OK to tweet.

[bupaje]

Have to try this when I get home. Thanks for your efforts.

[Supertramp]

It works very fine... Thank you.

But i habe another question.
can i copy these files into the "News" folder?
Because, when i install the files normaly, the wsb create a new modul and all my news-entries from the past weren't in this modul.
when i copy the NewsTweet files into the News folder, i habe all my older news-entries??

I don't want to try it, because i think i will lost all my older news entries.

[Xagone]

I tried this at first, but there was too much problems doing this, that's why it's a separate module, if you try to move the file to the news folder you'll end up braking the news module.

this was not a news replacement.
BUT the database is the same to you could transfert some news. with some mysql

[snark]

does it work with the anynews?

[Xagone]

anynews only works with the news module

[Supertramp]

Thanks for the answer.

is it easy to transfer the news to newstweet? I doesn't have any skills in mysql...

best regards

[Supertramp]

I have now all older news included, manually.

But I have a last question.
Is it possible, that the characters " #fb "  in each message are the last characters? So I could use the facebook tool "selektive twitter".

Thanks,
tony

[Supertramp]

I have found it, to get the prefix after the short url.

But how can I do some with the mysql news-database? to get my older news to the new news-tweet module??
this is really the last question.

Best regards

[Xagone]

Ok, let's have some fun in MySQL

you need to have the old section_id & new page_id, section_id for your newstweet

first you copy every records in your news tweet, you only need your actual news section ID :

Code:

INSERT IGNORE INTO `wb_mod_newstweet_posts` (`post_id`,`section_id`,`page_id`,`group_id`,`active`,
`position`,`title`,`link`,`content_short`,`content_long`,`commenting`,
`published_when`,`published_until`,`posted_when`,`posted_by`)
SELECT `post_id`,`section_id`,`page_id`,`group_id`,`active`,
`position`,`title`,`link`,`content_short`,`content_long`,`commenting`,
`published_when`,`published_until`,`posted_when`,`posted_by` FROM `wb_mod_news_posts` WHERE `section_id` = *YOUR OLD NEWS SECTION_ID*;

INSERT IGNORE INTO `wb_mod_newstweet_groups` SELECT * FROM `wb_mod_news_groups` WHERE `section_id` = *YOUR OLD NEWS SECTION_ID*;

INSERT IGNORE INTO `wb_mod_newstweet_comments` SELECT * FROM `wb_mod_news_comments` WHERE `section_id` = *YOUR OLD NEWS SECTION_ID*;

Then you need to adapt your records

Code:

UPDATE `wb_mod_newstweet_posts` SET `section_id` = *YOUR NEWSTWEET PAGE_ID*, `page_id` = *YOUR NEWSTWEET SECTION_ID*, `twitted` = 1
WHERE `section_id` = *YOUR OLD NEWS SECTION_ID*;

UPDATE `wb_mod_newstweet_groups` SET `section_id` = *YOUR NEWSTWEET PAGE_ID*, `page_id` = *YOUR NEWSTWEET SECTION_ID*
WHERE `section_id` = *YOUR OLD NEWS SECTION_ID*;

UPDATE `wb_mod_newstweet_comments` SET `section_id` = *YOUR NEWSTWEET PAGE_ID*, `page_id` = *YOUR NEWSTWEET SECTION_ID*
WHERE `section_id` = *YOUR OLD NEWS SECTION_ID*;

in the first update i've noted tweeted as "1" so if you modify one of your news, it wont retweet an old news.

[Supertramp]

Thanks very much!
It works!!!
Thank you all alot

[Xagone]

this module is now deprecated, since Twitter change their authentification system.

i'll upgrade for my install and let you know.

[Xagone]

i've updated it.

it got an upgrade from the original

need a registered twitter api codes, all is explained in the settings.

[snaak]

Great module!
Only one problem when posting a new newsitem / tweet. When saving only 'twitting... ' is shown...All oAuth params are set. Someone got a clue?

[Xagone]

the module require cURL to work, is cURL active ?

[snaak]

Hi VotreSpace, thanks for reply.
Yes cURL is enabled:

cURL support enabled
cURL Information libcurl/7.15.5 OpenSSL/0.9.8c zlib/1.2.3 libidn/0.6.5

Any suggestions?

[Xagone]

can cURL takes outside links ?

I have no test to test it, but some bad hosting are blocking external connection of curl.