txp_twitter
txp_twitter is a plugin which writes a tweet at your space at twitter, each time you write or edit a post.
The instructions to install this plugin are easy. First of all, you have to download the plugin and install it into your textpattern installation. Then you must edit the plugin to change the username and password in order to use your data from twitter and then, you must just activate it.
The plugin uses a library called curl that sometimes isn’t installed at the servers. But in my case, it was installed and it works fine.
Updated: The new release uses an extra field (custom_1) in order to know when a tweet has already been sent. You can change the extra field just editting the plugin for another extra field (from 1 to 10), but if you change it, you must provide a name to the extra field in the preferences of your textpattern installation (Admin > Preferences > Advanced preferences).
[Ruud: download link seems to be dead at the moment, plugin code pasted below]
# txp_twitter v1.3 # This plugin sends a tweet at our twitter space. # Fran Garcia # http://www.frangarcia.net# ...................................................................... # This is a plugin for Textpattern - http://textpattern.com/ # To install: textpattern > admin > plugins # Paste the following text into the 'Install plugin' box: # ......................................................................YTo5OntzOjQ6Im5hbWUiO3M6MTE6InR4cF90d2l0dGVyIjtzOjc6InZlcnNpb24iO3M6Mzoi MS4zIjtzOjY6ImF1dGhvciI7czoxMToiRnJhbiBHYXJjaWEiO3M6MTA6ImF1dGhvcl91cmki O3M6MjU6Imh0dHA6Ly93d3cuZnJhbmdhcmNpYS5uZXQiO3M6MTE6ImRlc2NyaXB0aW9uIjtz OjQ3OiJUaGlzIHBsdWdpbiBzZW5kcyBhIHR3ZWV0IGF0IG91ciB0d2l0dGVyIHNwYWNlLiI7 czo0OiJ0eXBlIjtpOjE7czo0OiJoZWxwIjtzOjczMDoiCjxzdHJvbmc+VFhQIFR3aXR0ZXI8 L3N0cm9uZz48YnI+PGJyPgoKVGhpcyBwbHVnaW4gc2VuZHMgYSB0d2VldCBhdCBvdXIgdHdp dHRlciBzcGFjZS48YnI+PGJyPgoKWW91IG11c3QganVzdCBpbnN0YWxsIHRoZSBwbHVnaW4g aW50byB5b3VyIHRleHRwYXR0ZXJuIGluc3RhbGxhdGlvbiwgY2hhbmdlIHRoZSB1c2VybmFt ZSBhbmQgcGFzc3dvcmQgYXQgdHdpdHRlciBhdCB0aGUgZnVuY3Rpb24gd3JpdGVfdHdlZXQg YW5kIGFjdGl2YXRlIHRoZSBwbHVnaW4uIFdoZW4geW91IHB1Ymxpc2ggYSBwb3N0LCBpdCB3 aWxsIGJlIHNlbnQgYSB0d2VldCB0byB5b3VyIGFjY291bnQgaW4gdHdpdHRlciwgYnV0IHlv dSBtdXN0IGtub3csIHRoYXQgdGhlIHBsdWdpbiB1c2VzIHRoZSBleHRyYSBmaWVsZCAnY3Vz dG9tXzEnLCBidXQgeW91IGNhbiBjaGFuZ2UgdGhpcyBleHRyYSBmaWVsZCBqdXN0IGVkaXR0 aW5nIHRoZSBwbHVnaW4gYW5kIGNoYW5naW5nIHdoZW4gaXQgc2F5cyAnY3VzdG9tXzEnIGZv ciBhbm90aGVyIG9uZSAodGhlcmUgYXJlIGF2YWlsYWJsZSAxMCBleHRyYSBmaWVsZHMsIHNv IHlvdSBjYW4gY2hvb3NlIGFub3RoZXIgb25lKS4gWW91IG11c3QgZ2l2ZSBhIG5hbWUgdG8g dGhpcyBleHRyYSBmaWVsZCBpbiB0aGUgcHJlZmVyZW5jZXMgb2YgeW91ciB0ZXh0cGF0dGVy biBpbnN0YWxsYXRpb24gKGl0IGRvZXMgbm90IG1hdHRlciB0aGUgbmFtZSwgYnV0IHdyaXRl IG9uZSkuCiI7czo0OiJjb2RlIjtzOjEzMzI6IgoKLy8gLS0tLSBBZGQgYSBuZXcgdGFiIHRv IHRoZSBFeHRlbnNpb25zIHRhYiAvICJwb3N0bWFzdGVyIgppZiAoQHR4cGludGVyZmFjZSA9 PSAnYWRtaW4nKSB7CglnbG9iYWwgJHR4cGNmZzsKCXJlZ2lzdGVyX2NhbGxiYWNrKCJ3cml0 ZV90d2VldCIsICdhcnRpY2xlJyAsICdlZGl0Jyk7Cn0KCgovLyAtLS0tIFBPU1RNQVNURVIg IldSSVRFIiBUQUIgRlVOQ1RJT04gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tCgpmdW5jdGlvbiB3cml0ZV90d2VldCgkZXZlbnQsICRzdGVwKQp7CiAgICAgIGluY2x1 ZGVfb25jZSB0eHBhdGguJy9wdWJsaXNoL3RhZ2hhbmRsZXJzLnBocCc7CgogICAgICAkcnMg PSBzYWZlX3JvdygiSUQsIFRpdGxlIiwgJ3RleHRwYXR0ZXJuJywgInN0YXR1cz00IEFORCBj dXN0b21fMTw+J3llcycgQU5EIFRJTUVESUZGKG5vdygpLExhc3RNb2QpPCcwMDowMDozMCcg T1JERVIgQlkgTGFzdE1vZCBBU0MiKTsKICAgICAgaWYgKGNvdW50KCRycyk+MCl7CgkgICAg ICBwb3N0VG9Ud2l0dGVyKCJoZXJlX3lvdXJfdXNlcm5hbWVfYXRfdHdpdHRlciIsImhlcmVf eW91cl9wYXNzd29yZF9hdF90d2l0dGVyIiwkcnNbJ1RpdGxlJ10uIjogIi5wZXJtbGlua3Vy bF9pZCgkcnNbJ0lEJ10pKTsKCSAgICAgIHNhZmVfdXBkYXRlKCJ0ZXh0cGF0dGVybiIsICJj dXN0b21fMSA9ICd5ZXMnIiwgImlkID0gIi4kcnNbJ0lEJ10pOwoJICB9Cn0KCmZ1bmN0aW9u IHBvc3RUb1R3aXR0ZXIoJHVzZXJuYW1lLCRwYXNzd29yZCwkbWVzc2FnZSl7CgogICAgJGhv c3QgPSAiaHR0cDovL3R3aXR0ZXIuY29tL3N0YXR1c2VzL3VwZGF0ZS54bWw/c3RhdHVzPSIu dXJsZW5jb2RlKHN0cmlwc2xhc2hlcyh1cmxkZWNvZGUoJG1lc3NhZ2UpKSk7CgogICAgJGNo ID0gY3VybF9pbml0KCk7CiAgICBjdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfVVJMLCAkaG9z dCk7CiAgICBjdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfVkVSQk9TRSwgMSk7CiAgICBjdXJs X3NldG9wdCgkY2gsIENVUkxPUFRfUkVUVVJOVFJBTlNGRVIsIDEpOwogICAgY3VybF9zZXRv cHQoJGNoLCBDVVJMT1BUX1VTRVJQV0QsICIkdXNlcm5hbWU6JHBhc3N3b3JkIik7CiAgICBj dXJsX3NldG9wdCgkY2gsIENVUkxPUFRfSFRUUF9WRVJTSU9OLCBDVVJMX0hUVFBfVkVSU0lP Tl8xXzEpOwogICAgY3VybF9zZXRvcHQoJGNoLCBDVVJMT1BUX1BPU1QsIDEpOwoKICAgICRy ZXN1bHQgPSBjdXJsX2V4ZWMgKCRjaCk7IC8vT2pvLCBoYXkgdW4gZXNwYWNpbyBlbiBleGVj CiAgICAkcmVzdWx0QXJyYXkgPSBjdXJsX2dldGluZm8oJGNoKTsKICAgIGN1cmxfY2xvc2Uo JGNoKTsKfQoKCiI7czozOiJtZDUiO3M6MzI6IjdhMDY4MzdiY2U5OTA4ZTc3ZjU5NTdjN2Mz YzJkZTNjIjt9
If there is a comment form at the Information URL, you may want to leave your comments/questions there for quicker feedback. Otherwise, comment away:
Commented (11)
Nice plugin, works great here. How would I include the posts title in the Twitter message? It would be nice to have the articles title wrapped in a permalink instead of “Look at this”
Hi Sven,
I have already uploaded a new version, which includes the title of the post instead of the text “Look at this”. Just download it and install it.
I hope you enjoy it!
Great, thank you!
Would be great if the Twitter-MSG would only be send when creating a new Article, not every edit/update. How could i do that?
Yes Christian,
that would be great, but I don’t know how could I do this.
Maybe you can play with the data posted and the last mod in the select, but I’m not sure. Let me investigate about this, but if you find a solution, let me know it.
I’ve upload a new version of this plugin. The new version sends a tweet to our space at twitter.com, only when the article is a published a article and not in the other cases.
There is a new release of this plugin. In older release, everytime you made a modification to an article, a tweet was sent to your twitter account, but now, just one tweet is sent the first time you publish the article.
Hi, Great plugin Fran.
How can I get it to post to Twitter when I post to Textpattern from XML-RPC?
Thanks!
hey fran buenisimo el plug! muchas gracias…
como hago para que se postee un Excerpt en twtter de mi post en el blog? saludos!!
Hola Anibal,
para hacer lo que quieres, debes editar el plugin desde la interfaz de textpattern y hacer lo siguiente:
1º) Cambiar $rs = safe_row(“ID, Title”, “textpattern”, “status=4 AND custom_1<>‘yes’ AND TIMEDIFF,LastMod)<‘00:00:30’ ORDER BY LastMod ASC”); por $rs = safe_row(“ID, Title,Excerpt”, “textpattern”, “status=4 AND custom_1<>‘yes’ AND TIMEDIFF,LastMod)<‘00:00:30’ ORDER BY LastMod ASC”);
2º) Cambiar postToTwitter(“frangarcia”,“llOE1978”,$rs[‘Title’].”: “.permlinkurl_id($rs[‘ID’])); por postToTwitter(“frangarcia”,“llOE1978”,$rs[‘Excerpt’].”: “.permlinkurl_id($rs[‘ID’]));
Eso es todo.
Error
Warning: 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 ‘(now(),LastMod)<‘00:00:30’ ORDER BY LastMod ASC’ at line 1 select ID, Title from sitetextpattern as textpattern where status=4 AND custom_1<>‘yes’ AND TIMEDIFF,LastMod)<‘00:00:30’ ORDER BY LastMod ASC in /home/l/xxx/public_html/site/textpattern/lib/txplib_db.php on line 82
Subscribe to this article's comments RSS feed. [ ? ] View Recent Comments across the site. Get a Gravatar.
Would you care to write a comment?