Additional features

Hi,

I was very grateful to find your module, which I used in a site for which the client wanted to pull in the most recent post they had made to their blogger site and display the details on the front page of their new drupal site (via an RSS feed from blogger (via feedburner)).

The only problem was that they wanted to display some additional info that wasn't covered by the Feedblock module. So, I added in a few extra options to the feedblock menu and wonder if they would be of interest to the general project?

In feed_block.module in 6.x-1.3 I have added the following:

In the function feed_block_settings() at line 88 I have added:

  $form['feedblock_showexcerpt'] = array(
  '#type' => 'checkbox',
  '#title' => t('Show Excerpt'),
  '#description' => t('Show a 350 character excerpt from the feed item.'),
  '#default_value' => variable_get('feedblock_showexcerpt', 0),
  '#required' => FALSE,
  );
  
  $form['feedblock_showfeedtitle'] = array(
  '#type' => 'checkbox',
  '#title' => t('Show Feed Title'),
  '#description' => t('Show the source of the feed.'),
  '#default_value' => variable_get('feedblock_showfeedtitle', 1),
  '#required' => FALSE,
  );
  
  $form['feedblock_showdate'] = array(
  '#type' => 'checkbox',
  '#title' => t('Show feed date'),
  '#description' => t("Show the date of the feed, in the format 'Posted @ 11:47 AM Sep 9th'."),
  '#default_value' => variable_get('feedblock_showdate', 0),
  '#required' => FALSE,
  );

Then in the function feed_block_content(), between lines 10 to 23 where it said

while ($fq = db_fetch_object($q)) {
    $fid = $fq->fid;
    $feedtitle = check_plain($fq->feedtitle);
    $query = db_query('SELECT ai.title, ai.link FROM {aggregator_item} AS ai WHERE ai.fid = "%d" ORDER BY ai.timestamp DESC', $fid);
    $fquery = db_fetch_object($query);
    
    $title = check_plain($fquery->title);
    $link = $fquery->link;
    $line = '<div class="fb-title">' . $title . '</div><div class="fb-feed">' . variable_get('feedblock_prefix', '~') . $feedtitle . '</div>';
    
    $list .= '<li>' . l($line, $link, array('html' => TRUE, 'absolute' => TRUE)) . '</li>';
  }

I've changed it to read:

  $show_excerpt = variable_get('feedblock_showexcerpt', 0);
  $show_title = variable_get('feedblock_showfeedtitle', 1);
  $show_date = variable_get('feedblock_showdate', 0);
  
  while ($fq = db_fetch_object($q)) {
    $fid = $fq->fid;
    $feedtitle = check_plain($fq->feedtitle);
	$sql = 'SELECT ai.title, ';
	
	if ($show_excerpt) {
	  $sql .= 'ai.description, ';
	}
	
	if ($show_date) {
	  $sql .= 'ai.timestamp, ';
	}
	
	$sql .= 'ai.link FROM {aggregator_item} AS ai WHERE ai.fid = "%d" ORDER BY ai.timestamp DESC';
    $query = db_query($sql, $fid);
    $fquery = db_fetch_object($query);
    
    $title = check_plain($fquery->title);
    $link = $fquery->link;
	
    $line = '<div class="fb-title">' . $title . '</div>';
	if ($show_title) {
	  $line .= '<div class="fb-feed">' . variable_get('feedblock_prefix', '~') . $feedtitle . '</div>';
    }
    $list .= '<li>' . l($line, $link, array('html' => TRUE, 'absolute' => TRUE));
	
	if ($show_excerpt) {
	  $description = trim(substr(check_plain($fquery->description), 0, 350)) . '...';
	  $list .= $description;
	}
	
	if ($show_date) {
	  $posteddate = date('h:i A M jS', $fquery->timestamp);
	  $list .= '<br /><br /><span>Posted @ ' . $posteddate .'</span>';
	}
	
	$list .= '</li>';
  }

So this lets people show a 350 character excerpt from the feed item, show the source of the feed and show the date of the feed in the format 'Posted @ 11:47 AM Sep 9th', whilst the default settings remain as the original functionality of the feedblock module.

I hope this is of use, although perhaps it needs a bit more flexibility in terms of date format and number of characters?

Thanks again for the module,

David