function og_views_handler_field_og_post_count_new::query in Organic groups 6.2

Same name and namespace in other branches

1. 6 modules/og_views/includes/og_views_handler_field_og_post_count_new.inc \og_views_handler_field_og_post_count_new::query()

File

modules/og_views/includes/og_views_handler_field_og_post_count_new.inc, line 6

Class

og_views_handler_field_og_post_count_new

We do not try to run db_rewrite_sql() on this subquery so the count is potentially more than the user can see.

Code

function query() {
  global $user;
  $table = $this->query
    ->ensure_table('og');
  $sql = "SELECT COUNT(*) FROM {node} n INNER JOIN {og_ancestry} oga ON n.nid = oga.nid LEFT JOIN {history} h ON n.nid=h.nid AND h.uid = %uid WHERE n.status = 1 AND oga.group_nid = {$table}.nid AND h.timestamp IS NULL AND n.created > %created";
  $sql = strtr($sql, array(
    '%uid' => $user->uid,
    '%created' => NODE_NEW_LIMIT,
  ));
  $this->query
    ->add_field('', "({$sql})", 'post_count_new');
  $this->field_alias = 'post_count_new';
}