array(
'table' => array(
'group' => 'Twitter Feed',
'base' => array(
'field' => 'tid',
'title' => 'Twitter Feed Posts',
'weight' => -10,
),
),
'tid' => array(
'title' => t('Tid'),
'help' => t('The Drupal ID of the tweet'),
'field' => array(
'handler' => 'views_handler_field_numeric',
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
),
'tweet' => array(
'title' => t('Tweet Text'),
'help' => t('The actual 140 character tweet text.'),
'field' => array(
'handler' => 'views_handler_tweet_field',
'click sortable' => FALSE,
),
'sort' => array(
'handler' => 'views_handler_sort',
),
),
'created_at' => array(
'title' => t('Tweet Creation Time'),
'help' => t('The creation time stamp of the tweet.'),
'field' => array(
'handler' => 'views_handler_field_date',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
),
'user_id' => array(
'title' => t('User ID'),
'help' => t('The user_id of the person making the tweet'),
'field' => array(
'handler' => 'views_handler_field_numeric',
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
),
'profile_image_url' => array(
'title' => t('Profile Image URL'),
'help' => t('The url to the profile image of the tweeter.'),
'field' => array(
'handler' => 'views_handler_field',
),
),
'screen_name' => array(
'title' => t('Screen Name'),
'help' => t('Thre screen name of the tweeter.'),
'field' => array(
'handler' => 'views_handler_field',
),
),
),
);
}
/**
* override views_handler_field::render so that it does not sanitize our URL's and other links
*/
class views_handler_tweet_field extends views_handler_field {
function render($values) {
$tweet = $this->get_value($values);
/* based on our preference, assign all links to new windows or to the same window */
$target = (variable_get('twitter_new_window',0) == 1) ? '_blank' : '_self';
/* look for twitter handles and make them clickable */
/* modified so that slashes in the twitter handle are counted */
$pattern = '/@([A-Za-z0-9_]{1,15})(?![.A-Za-z])/';
$replace = '@\1';
$tweet = preg_replace($pattern,$replace,$tweet);
/* look for twitter hash tags and make them clickable */
/* modified so that slashes in the twitter handle are counted */
$tweet = preg_replace('/(^|\s)#(\w*+\w*)/', '\1#\2', $tweet);
return htmlspecialchars_decode($tweet);
}
}