function dlike_flag_get_active_users_counts in Drupal like (Flag counter) 7.2

get only active users flagged count

1 call to dlike_flag_get_active_users_counts()

dlike_append in ./dlike.inc

File

./dlike.inc, line 140

This files contains all the include functions.

Code

function dlike_flag_get_active_users_counts($flag_name, $content_id) {
  $query = db_select('flags', 'f');
  $query
    ->leftJoin('flag_content', 'fc', 'f.fid = fc.fid');
  $query
    ->leftJoin('users', 'u', 'fc.uid = u.uid');
  $result = $query
    ->fields('f', array(
    'name',
  ))
    ->fields('fc', array(
    'fid',
  ))
    ->condition('f.name', $flag_name)
    ->condition('fc.content_id', $content_id)
    ->condition('u.status', '1')
    ->countQuery()
    ->execute()
    ->fetchField();
  $count = array();
  $count[$flag_name] = $result;
  return $count;
}