You are here

Home » API reference » User Stats 7 » views_handler_sort_ip_user_count.inc » views_handler_sort_ip_user_count

function views_handler_sort_ip_user_count::query in User Stats 7

Same name and namespace in other branches
  1. 6 views/views_handler_sort_ip_user_count.inc \views_handler_sort_ip_user_count::query()

Called to add the sort to a query.

Overrides views_handler_sort::query

File

views/views_handler_sort_ip_user_count.inc, line 12
User Stats user count by IP address.

Class

views_handler_sort_ip_user_count
Users by IP address count handler.

Code

function query() {
  $this->table_alias = $this
    ->ensure_my_table();

  // We need another subquery here to extract DISTINCT values
  $sql = "SELECT COUNT(usi.uid)\n      FROM (SELECT DISTINCT(uid), ip_address FROM {user_stats_ips}) usi\n      WHERE usi.ip_address = " . check_plain($this->table_alias) . ".ip_address";
  $this->field_alias = $this->query
    ->add_orderby(NULL, "(" . $sql . ")", $this->options['order'], $this->table_alias . '_' . $this->field);
}