diff options
| author | Mario Vavti <mario@mariovavti.com> | 2019-03-08 11:52:57 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2019-03-08 11:52:57 +0100 |
| commit | 8ecdde6cb573ace776b472046388bb046dc59451 (patch) | |
| tree | f568af943a17c3156adf2d34477cd424bc24bd94 /Zotlabs/Module/Admin.php | |
| parent | 90fd323ac54619766feedf699e5f53fce04fc295 (diff) | |
| parent | 5b3824917d591b27c4797971c8253ed67b41dc5a (diff) | |
| download | volse-hubzilla-8ecdde6cb573ace776b472046388bb046dc59451.tar.gz volse-hubzilla-8ecdde6cb573ace776b472046388bb046dc59451.tar.bz2 volse-hubzilla-8ecdde6cb573ace776b472046388bb046dc59451.zip | |
Merge branch '4.0RC'
Diffstat (limited to 'Zotlabs/Module/Admin.php')
| -rw-r--r-- | Zotlabs/Module/Admin.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Module/Admin.php b/Zotlabs/Module/Admin.php index 8ccdaf4f5..88b84b9d2 100644 --- a/Zotlabs/Module/Admin.php +++ b/Zotlabs/Module/Admin.php @@ -86,7 +86,7 @@ class Admin extends \Zotlabs\Web\Controller { // list total user accounts, expirations etc. $accounts = array(); - $r = q("SELECT COUNT(*) AS total, COUNT(CASE WHEN account_expires > %s THEN 1 ELSE NULL END) AS expiring, COUNT(CASE WHEN account_expires < %s AND account_expires > '%s' THEN 1 ELSE NULL END) AS expired, COUNT(CASE WHEN (account_flags & %d)>0 THEN 1 ELSE NULL END) AS blocked FROM account", + $r = q("SELECT COUNT(CASE WHEN account_id > 0 THEN 1 ELSE NULL END) AS total, COUNT(CASE WHEN account_expires > %s THEN 1 ELSE NULL END) AS expiring, COUNT(CASE WHEN account_expires < %s AND account_expires > '%s' THEN 1 ELSE NULL END) AS expired, COUNT(CASE WHEN (account_flags & %d)>0 THEN 1 ELSE NULL END) AS blocked FROM account", db_utcnow(), db_utcnow(), dbesc(NULL_DATE), |