Managing Planet feeds

Functions
	planet__build_user_feeds_table ()
	Fetches all feeds and build an html table for admnistration.
	planet__add_feed ($data)
	Adds a new feed to planet_feeds table.
	planet__update_feed ($data)
	Updates an existing feed in planet_feeds table.
	planet__build_admin_feeds_table ()
	builds an HTML table of feeds for administrator interaction.
	planet_multiple_delete_confirm_submit (&$form_state, $edit)
	TODO.

---

Function Documentation

planet__add_feed

(

$

data

)

Adds a new feed to planet_feeds table.

Parameters:

$data

associative array with keys 'uid' (optional), 'title', 'link', 'image' (optional)

Returns:

success status

                                 {
  $data['checked'] = 0;
  $data['frozen']  = 0;
  // @DIFFINFO Removed debugging block. Internal function is supposed to receive clean arguments. Checking will be left to planet_feed class

  $rslt = drupal_write_record('planet_feeds', $data);
  if ($rslt==SAVED_NEW) {
    $title = planet_refresh(intval($data['fid']));
    drupal_set_message('Added new feed: ' . $title);    
    return TRUE;
  }
  trigger_error('Failed to add new feed');
  return FALSE;
}

Here is the call graph for this function:

Here is the caller graph for this function:

planet__build_admin_feeds_table

(

)

builds an HTML table of feeds for administrator interaction.

Returns:

                                           {
  // @DIFFINFO renamed planet__build_feeds_table() {
  global $user;
  $feeds = db_query('SELECT  fid, title, checked, frozen FROM {planet_feeds} '
                    . ' WHERE uid = %d;', $user->uid);
  $rows = array();
  $headers = array('Feed', 'Items', 'Edit', 'Last checked', 'Refresh', 'Freeze');
  $now = time();
  $items_statement = 'SELECT count(*) FROM {planet_items} WHERE fid=%d';
  // TODO: change this to prepared statement when supported by drupal DB Abstraction Layer.
  while ($feed = db_fetch_object($feeds)) {
    $_checked = $now - $feed->checked;
    $checked = intval($_checked / 60) .' minutes';
    if ($_checked % 60 > 0) {
      $checked .= ', '. $feed->_checked % 60 .' seconds';
    }
    $checked .= ' ago';
    $items = db_query($items_statement, $feed->fid);
    if (!$items) trigger_error('ERROR while counting feed items.');
    $cnt = db_result($items);
    $fid = strval($feed->fid);
    array_push($rows, array(
                            $feed->title,
                            $cnt,
                            l('edit', 'admin/settings/planet/'. $fid),
                            $checked,
                            l('refresh', 'admin/settings/planet/refresh/'. $fid),
                            l($feed->frozen ? 'unfreeze' : 'freeze', 'admin/settings/planet/'. ($feed->frozen ? 'unfreeze/' : 'freeze/') . $fid)          
                            )
               );
  }
  return theme('table', $headers, $rows);      
}

Here is the call graph for this function:

Here is the caller graph for this function:

planet__build_user_feeds_table

(

)

Fetches all feeds and build an html table for admnistration.

See also:

planet__build_admin_feeds_table()

                                          {
  // @DIFFINFO renamed planet__build_feeds_table1
  global $user;
      $feeds = db_query('SELECT  fid, title, checked FROM {planet_feeds} '
                        . ' WHERE uid = %d;', $user->uid);
      $rows = array();
      $headers = array('Feed', 'Items', 'Edit', 'Last checked');
      $now = time();
      $items_statement = 'SELECT count(*) FROM {planet_items}'
        . ' WHERE fid=%d';
      // TODO: change this to prepared statement when supported by drupal DB abstraction layer.
      while ($feed = db_fetch_object($feeds)) {
        $_checked = $now - $feed->checked;
        $checked = intval($_checked / 60) .' minutes';
        if ($_checked % 60 > 0) {
          $checked .= ', '. $feed->_checked % 60 .' seconds';
        }
        $checked .= ' ago';
        $items = db_query($items_statement, $feed->fid);
        if (!$items) trigger_error('ERROR while counting feed items.');
        $cnt = db_result($items);
        array_push($rows, array(
          $feed->title,
          $cnt,
          l('edit', 'user/'. $user->uid .'/planet/'. intval($feed->fid)),
          $checked,
          )
        );
      }
      return theme('table', $headers, $rows);      
}

Here is the call graph for this function:

Here is the caller graph for this function:

planet__update_feed

(

$

data

)

Updates an existing feed in planet_feeds table.

Parameters:

$data

associative array with keys 'fid' (mandatory, primary key), other fields as needed: 'uid', 'title', 'link', 'image', 'checked', 'frozen'

Returns:

success status

                                    {
  $rslt = drupal_write_record('planet_feeds', $data, 'fid');

  if ($rslt==SAVED_UPDATED) { 
    drupal_set_message('Edited "'. $data['title'] .'" feed.');
    return TRUE;
  }
  if ($rslt==SAVED_NEW) // @DEBUGGING
    trigger_error('Feed {$data->fid} didn\'t exist. Record added.', E_ERROR);
  else 
    trigger_error('Failed to edit feed');
  return FALSE;
}      

Here is the call graph for this function:

Here is the caller graph for this function:

planet_multiple_delete_confirm_submit	(	&$	form_state,
		$	edit
	)

TODO.

Parameters:

	&$form_state
	$edit

Returns:

DB @CRUD: node[D]

DB @CRUD: planet_items[D]

DB @CRUD: planet_feeds[D]

                                                                    {
  $fid = $edit['fid'];
  if ($edit['confirm']) {
    foreach ($edit['nodes'] as $nid => $value) {
      node_delete($nid);
    }
    // @DIFFINFO inverted drop order to respect foreign keys
    db_query('DELETE FROM {planet_items} WHERE fid = %d', $fid);
    db_query('DELETE FROM {planet_feeds} WHERE fid = %d', $fid);
    drupal_set_message(t('The feed and items have been deleted.'));
  }
  drupal_goto($edit['redirect']);
}

Here is the call graph for this function: