diff options
| author | mrjive <mrjive@mrjive.it> | 2018-04-05 10:52:39 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-04-05 10:52:39 +0200 |
| commit | a7ff2cc5ea11afd7b832bef24866abfb0220d022 (patch) | |
| tree | e7dcd63bbfdaa6ae564c60d59ef60edf0e6ba7a7 /include/statistics_fns.php | |
| parent | 20ac91703d54679d2e5080ba2d4985e93986a515 (diff) | |
| parent | dcacdd23c87061dc15bd12ed2e959bcbe020c5df (diff) | |
| download | volse-hubzilla-a7ff2cc5ea11afd7b832bef24866abfb0220d022.tar.gz volse-hubzilla-a7ff2cc5ea11afd7b832bef24866abfb0220d022.tar.bz2 volse-hubzilla-a7ff2cc5ea11afd7b832bef24866abfb0220d022.zip | |
Merge pull request #3 from redmatrix/dev
Dev
Diffstat (limited to 'include/statistics_fns.php')
| -rw-r--r-- | include/statistics_fns.php | 44 |
1 files changed, 9 insertions, 35 deletions
diff --git a/include/statistics_fns.php b/include/statistics_fns.php index d213485bf..98b0efd41 100644 --- a/include/statistics_fns.php +++ b/include/statistics_fns.php @@ -17,23 +17,10 @@ function update_channels_active_halfyear_stat() { db_utcnow(), db_quoteinterval('6 MONTH') ); if($r) { - $s = ''; - foreach($r as $rr) { - if($s) - $s .= ','; - $s .= intval($rr['channel_id']); - } - $x = q("select uid from item where uid in ( $s ) and item_wall = 1 and created > %s - INTERVAL %s group by uid", - db_utcnow(), db_quoteinterval('6 MONTH') - ); - if($x) { - $channels_active_halfyear_stat = count($x); - set_config('system','channels_active_halfyear_stat',$channels_active_halfyear_stat); - } else { - set_config('system','channels_active_halfyear_stat',0); - } - } else { - set_config('system','channels_active_halfyear_stat',0); + set_config('system','channels_active_halfyear_stat',count($r)); + } + else { + set_config('system','channels_active_halfyear_stat','0'); } } @@ -43,28 +30,15 @@ function update_channels_active_monthly_stat() { db_utcnow(), db_quoteinterval('1 MONTH') ); if($r) { - $s = ''; - foreach($r as $rr) { - if($s) - $s .= ','; - $s .= intval($rr['channel_id']); - } - $x = q("select uid from item where uid in ( $s ) and item_wall = 1 and created > %s - INTERVAL %s group by uid", - db_utcnow(), db_quoteinterval('1 MONTH') - ); - if($x) { - $channels_active_monthly_stat = count($x); - set_config('system','channels_active_monthly_stat',$channels_active_monthly_stat); - } else { - set_config('system','channels_active_monthly_stat',0); - } - } else { - set_config('system','channels_active_monthly_stat',0); + set_config('system','channels_active_monthly_stat',count($r)); + } + else { + set_config('system','channels_active_monthly_stat','0'); } } function update_local_posts_stat() { - $posts = q("SELECT COUNT(*) AS local_posts FROM item WHERE item_wall = 1 "); + $posts = q("SELECT COUNT(*) AS local_posts FROM item WHERE item_wall = 1 and id = parent"); if (is_array($posts)) { $local_posts_stat = intval($posts[0]["local_posts"]); set_config('system','local_posts_stat',$local_posts_stat); |