diff options
| author | redmatrix <mike@macgirvin.com> | 2016-09-25 17:06:13 -0700 |
|---|---|---|
| committer | redmatrix <mike@macgirvin.com> | 2016-09-25 17:06:13 -0700 |
| commit | fb9544badd66043bf7ee5a7566ba288ad7da29fa (patch) | |
| tree | 3bdb33ed9eef9101f1d6d6972ac9411051b988ce /Zotlabs/Module/Admin.php | |
| parent | 4e85bc66b8a5f5347ae15dda229f028d31b58469 (diff) | |
| download | volse-hubzilla-fb9544badd66043bf7ee5a7566ba288ad7da29fa.tar.gz volse-hubzilla-fb9544badd66043bf7ee5a7566ba288ad7da29fa.tar.bz2 volse-hubzilla-fb9544badd66043bf7ee5a7566ba288ad7da29fa.zip | |
null_date conversion; phase 1
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 e6a29fd8d..e3702992f 100644 --- a/Zotlabs/Module/Admin.php +++ b/Zotlabs/Module/Admin.php @@ -87,7 +87,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(*) 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), |