public function make()
{
if (!$this->query || !$this->url) {
return false;
}
// get the current page
if (!isset($this->current_page)) {
if (isset($_GET[$this->GET_param])) {
$this->current_page = $_GET[$this->GET_param];
} else {
$this->current_page = 1;
}
}
$this->query = trim($this->query);
// get count of all items
if (!preg_match('#^SELECT(.*?)FROM(.*?)$#is', $this->query)) {
return false;
}
$query = preg_replace('#SELECT(.*?)FROM#is', 'SELECT COUNT(*) as count FROM', $this->query);
$sql = new SQLObject();
if (!$sql->query($query)) {
return false;
}
$count = $sql->fetch_one();
$this->count = $count->count;
// get count of all pages
$this->pages_count = ceil($this->count / $this->per_page);
$this->made = true;
return true;
}
public function users_getCounts()
{
$sql = new SQLObject();
if ($sql->query("SELECT COUNT(*) AS count_users FROM " . $sql->table('auth_users'))) {
TPL::add('USERS_COUNT_USERS', $sql->fetch_one()->count_users);
} else {
TPL::add('USERS_COUNT_USERS', 'N/A');
}
if ($sql->query("SELECT COUNT(*) AS count_groups FROM " . $sql->table('auth_groups'))) {
TPL::add('USERS_COUNT_GROUPS', $sql->fetch_one()->count_groups);
} else {
TPL::add('USERS_COUNT_GROUPS', 'N/A');
}
}
