diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-09-01 13:43:32 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-09-01 13:43:32 +0200 |
| commit | 4376f8f030ea36fd5fed263efcee3a5276af0da1 (patch) | |
| tree | 33952d0b5147bca6133214d8a273fdbb80cd85f4 /Zotlabs | |
| parent | d377660b5a8800fdce33bbafcc166a8b2a6076d1 (diff) | |
| download | volse-hubzilla-4376f8f030ea36fd5fed263efcee3a5276af0da1.tar.gz volse-hubzilla-4376f8f030ea36fd5fed263efcee3a5276af0da1.tar.bz2 volse-hubzilla-4376f8f030ea36fd5fed263efcee3a5276af0da1.zip | |
do not count sys channel in totals
Diffstat (limited to 'Zotlabs')
| -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 2df8dc25d..6edced9b5 100644 --- a/Zotlabs/Module/Admin.php +++ b/Zotlabs/Module/Admin.php @@ -109,7 +109,7 @@ class Admin extends \Zotlabs\Web\Controller { // available channels, primary and clones $channels = array(); - $r = q("SELECT COUNT(*) AS total, COUNT(CASE WHEN channel_primary = 1 THEN 1 ELSE NULL END) AS main, COUNT(CASE WHEN channel_primary = 0 THEN 1 ELSE NULL END) AS clones FROM channel WHERE channel_removed = 0"); + $r = q("SELECT COUNT(*) AS total, COUNT(CASE WHEN channel_primary = 1 THEN 1 ELSE NULL END) AS main, COUNT(CASE WHEN channel_primary = 0 THEN 1 ELSE NULL END) AS clones FROM channel WHERE channel_removed = 0 and channel_system = 0"); if ($r) { $channels['total'] = array('label' => t('Channels'), 'val' => $r[0]['total']); $channels['main'] = array('label' => t('Primary'), 'val' => $r[0]['main']); |