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; } ?>