aboutsummaryrefslogtreecommitdiffstats
path: root/include/statistics_fns.php
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2018-04-02 13:32:10 -0700
committerzotlabs <mike@macgirvin.com>2018-04-02 13:32:10 -0700
commit9a1f051068b5d301bbe1f08b6b160447fa94a34a (patch)
tree770c4dd4c241c2ed9a4cbd94fccf00f51e6228ee /include/statistics_fns.php
parentbcffb6cf55ff2d9d88fcb38105695b14ea3586b3 (diff)
downloadvolse-hubzilla-9a1f051068b5d301bbe1f08b6b160447fa94a34a.tar.gz
volse-hubzilla-9a1f051068b5d301bbe1f08b6b160447fa94a34a.tar.bz2
volse-hubzilla-9a1f051068b5d301bbe1f08b6b160447fa94a34a.zip
missing year on profile birthday input, some optimisations to stats
Diffstat (limited to 'include/statistics_fns.php')
-rw-r--r--include/statistics_fns.php44
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);