blob: ce601e7b4c402a6942fe67099b4003bb570725d7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
<?php
/**
* Elgg statistics library.
* This file contains a number of functions for obtaining statistics about the running system.
* These statistics are mainly used by the administration pages.
*
* @package Elgg
* @subpackage Core
* @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU Public License version 2
* @author Marcus Povey
* @copyright Curverider Ltd 2008
* @link http://elgg.org/
*/
// number of users
// Number of objects broken down into type
// who' s online now
/**
* Return an array reporting the number of various entities in the system.
*
* @return array
*/
function get_entity_statistics()
{
global $CONFIG;
$entity_stats = array();
// Get a list of major types
$types = get_data("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");
foreach ($types as $type) {
if (!is_array($entity_stats[$type->type]))
$entity_stats[$type->type] = array(); // assume there are subtypes for now
$query = "SELECT count(*) as count from {$CONFIG->dbprefix}entities where type='{$type->type}'";
if ($type->subtype) $query.= " and subtype={$type->subtype_id}";
$subtype_cnt = get_data($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;
}
?>
|
