statistics.php

Go to the documentation of this file.

<?php
function get_entity_statistics($owner_guid = 0) {
    global $CONFIG;

    $entity_stats = array();
    $owner_guid = (int)$owner_guid;

    $query = "SELECT distinct e.type,s.subtype,e.subtype as subtype_id
        from {$CONFIG->dbprefix}entities e left
        join {$CONFIG->dbprefix}entity_subtypes s on e.subtype=s.id";

    $owner_query = "";
    if ($owner_guid) {
        $query .= " where owner_guid=$owner_guid";
        $owner_query = "and owner_guid=$owner_guid ";
    }

    // Get a list of major types

    $types = get_data($query);
    foreach ($types as $type) {
        // assume there are subtypes for now
        if (!isset($entity_stats[$type->type]) || !is_array($entity_stats[$type->type])) {
            $entity_stats[$type->type] = array();
        }

        $query = "SELECT count(*) as count
            from {$CONFIG->dbprefix}entities where type='{$type->type}' $owner_query";

        if ($type->subtype) {
            $query .= " and subtype={$type->subtype_id}";
        }

        $subtype_cnt = get_data_row($query);

        if ($type->subtype) {
            $entity_stats[$type->type][$type->subtype] = $subtype_cnt->count;
        } else {
            $entity_stats[$type->type]['__base__'] = $subtype_cnt->count;
        }
    }

    return $entity_stats;
}

function get_number_users($show_deactivated = false) {
    global $CONFIG;

    $access = "";

    if (!$show_deactivated) {
        $access = "and " . _elgg_get_access_where_sql(array('table_alias' => ''));
    }

    $query = "SELECT count(*) as count
        from {$CONFIG->dbprefix}entities where type='user' $access";

    $result = get_data_row($query);

    if ($result) {
        return $result->count;
    }

    return false;
}

function get_online_users(array $options = array()) {
    $options = array_merge(array(
        'seconds' => 600,
    ), $options);

    return elgg_list_entities($options, 'find_active_users');
}

function statistics_init() {
    elgg_extend_view('core/settings/statistics', 'core/settings/statistics/online');
    elgg_extend_view('core/settings/statistics', 'core/settings/statistics/numentities');
}

elgg_register_event_handler('init', 'system', 'statistics_init');