function _drush_ip_backlog_comments_list in IP address manager 7.2

Get comments list (not int ip_posts).

1 call to _drush_ip_backlog_comments_list()

drush_ip_backlog_comments in ./ip.drush.inc

Drush command: ip backlog comments.

File

./ip.drush.inc, line 80

Code

function _drush_ip_backlog_comments_list() {
  $list = array();
  if (module_exists('comment')) {
    $list = db_query("SELECT c.cid AS cid, c.hostname AS hostname" . " FROM {comment} c" . " LEFT JOIN {ip_posts} i" . " ON i.type = 'comment'" . " AND (c.cid = i.id OR i.id IS NULL)" . " WHERE i.id IS NULL" . " ORDER BY c.cid DESC")
      ->fetchAll();
  }
  return $list;
}