Jump to Navigation

Me on Twitter

  • @twandroid #TinyTinyRss Défaut : s'installe sur votre propre hébergement. Avantage : s'installe sur votre propre hébergement. #OpenSource 10 years 39 weeks ago
  • Google Drive Linux Petition Now 10k Signatures Strong, Google Yet to Respond http://t.co/tJLY5KkkLi via @omgubuntu 10 years 39 weeks ago
  • I've found my new #GoogleReader : #TinyTinyRss http://t.co/0WFXlu6rRg. It has a very good #Android client. It's #OpenSource ! 10 years 39 weeks ago
  • @wadael I'm not at #droidcon Will you release the slides soon ? @am_technix 10 years 41 weeks ago
  • Forgot about that : you can't use \u000D in a String in #Java because the compiler parses it early... http://t.co/a0eL1WpgvT 10 years 43 weeks ago
  • Some #CSS3 transitions, a little bit of Javascript and you've got a nice Feedback button http://t.co/SVEbCAmq81 10 years 43 weeks ago
  • #angrybirdsScore I am definitely NOT an artist #absync http://t.co/qqTQ6mXB3k 10 years 43 weeks ago
  • #android Loaders : forceLoad or not ? Answer is : sometimes YES, sometimes NO. #NoClue http://t.co/8Po1SfDGuS 10 years 43 weeks ago
  • Never update #android sdk if ur not sure 2 be able 2 update ADT right after or u'll be stuck in #eclipse... Maybe I've 2 look at #intellij 10 years 44 weeks ago
  • Hey ! I have 2 #nexus7 ! http://t.co/SKxHWycW6x 10 years 45 weeks ago

Displaying your tweets on your Drupal blog

Twitter module for Drupal

If you want to display your latest tweets on your Drupal blog, you will probably want to use the dedicated Twitter module. Among other features, this module provides a new block type that lists a selection of tweets from an account. Tweets are retrieved via a cron job and stored in your website's database, making them available even through corporate firewalls that banish twitter.com. Just-what-you-need !

There are a few catches however : it will likely not work if you are on a shared host because Twitter puts rate limits to the usage of their API, and there is a bug in the block view that can be circumvented.

Here are the important steps to configure the module for our needs :

  1. Install Twitter module and some dependencies : OAuthAutoload, Views
  2. Activate the modules Twitter, OAuth, Autoload, Views and Views UI (the other Twitter modules 'actions', 'post' and 'signin' are not required for our purpose)
  3. Setup the Twitter module as described in the documentation : you will need to register your application and fill in OAuth consumer secret and key
  4. Associate a Twitter account with your user (this is also described in the documentation). This creates a line in the twitter_account table and is mandatory for OAuth requests.
  5. Start cron to retrieve your tweets. If this step gives you a "rate limit exceeded" message, welcome to the club : go ahead and read the next chapter.
  6. Lastly, create the block view that you will include in your layout. You don't need to follow the documentation : simply clone the twitter view as you wish and remove the user:uid filter to make it work (looks like a bug). Change the "Admin" field to help you distinguish it from the default twitter block.

 

Use Twitter API on localhost

If you want to register your local site (from your local computer), you can use http://127.0.0.1/twitter/oauth as the callback URL in step 3.
 
And if your test site does not respond to 127.0.0.1 (but for instance to mysite.localhost), the callback will fail, but you will still get the URL with the right query parameters (e.g. http://127.0.0.1/twitter/oauth?oauth_token=LbcMx...LcR3d&oauth_verifier=trdf5...aaOjQ) in step 4 : you can then simply change the host in the URL and try it a second time !
 

Patching for use on a shared host

In order to fetch twitter statuses (your tweets), the Twitter module makes unauthenticated calls to the API by default, and therefore is subject to a rate limit of 150 requests per hour measured against the IP address of the server making the request.

On shared hosts many sites use the same front IP address and thus the rate limit is reached every hour. In short, the sites trying to use this feature make it impossible to use for any host on the same shared host...!

Twitter's API allows for more requests if you use authenticated calls : up to 350 requests per hour measured against a token that's unique to your Twitter account. This is largely enough for our needs as it does not rely on the IP address.

 

First option : set a field in the database

To choose whether or not using an authenticated call, the module will look at some point for the value of the field named "protected" attached to the user in Drupal's database (twitter_account table). If this field has value that converts to TRUE in PHP, tweets will be retrieved through authentified calls.

You can the set the field value to 1 with your preferred database query tool.

However, setting this field to TRUE also allows other users to create tweets on behalf of this account. Furthermore, it may be set back to 0 by some parts of the module we don't control.

 

Second option : patch a line of code

Looking at the code, it looked to me more adequate to patch the code of the module.

Simply look for the file named twitter.inc in the module's files, and replace the use of $account->protected with_twitter_use_oauth() in the $twitter->user_timeline(...) call of the twitter_fetch_user_timeline function.

There is only one line to change :

<?php
...
function twitter_fetch_user_timeline($id) {
...
//  $statuses = $twitter->user_timeline($account->id, $params, $account->protected);
  $statuses = $twitter->user_timeline($account->id, $params, _twitter_use_oauth());
...
?>

 

And here we go : a nice Twitter timeline fetched and displayed on a shared host !

Sample site tweets block

 

References

 

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • E-Mail addresses are hidden with reCAPTCHA Mailhide.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>. The supported tag styles are: <foo>, [foo].
  • Twitter-style #hashtags are linked to search.twitter.com.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.