views_handler_sort_user_ip_count.inc in User Stats 7
Same filename and directory in other branches
User Stats IP address count by user.
File
views/views_handler_sort_user_ip_count.incView source
<?php
/**
* @file
* User Stats IP address count by user.
*/
/**
* IP addresses by user count handler.
*/
class views_handler_sort_user_ip_count extends views_handler_sort {
function query() {
$this
->ensure_my_table();
// We need another subquery here to extract DISTINCT values
$sql = "SELECT COUNT(usi.ip_address)\n FROM (SELECT DISTINCT(uid), ip_address FROM {user_stats_ips}) usi\n WHERE usi.uid = " . check_plain($this->table_alias) . ".uid";
$this->field_alias = $this->query
->add_orderby(NULL, "(" . $sql . ")", $this->options['order'], $this->table_alias . '_' . $this->field);
}
}
Classes
Name![]() |
Description |
---|---|
views_handler_sort_user_ip_count | IP addresses by user count handler. |