aboutsummaryrefslogtreecommitdiffstats
path: root/include/statistics_fns.php
blob: 98b0efd418a7be2f78375979ded029b279a0b4bd (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?php /** @file */

function update_channels_total_stat() {
	$r = q("select count(channel_id) as channels_total from channel left join account on account_id = channel_account_id
			where account_flags = 0 ");
	if($r) {
		$channels_total_stat = intval($r[0]['channels_total']);
		set_config('system','channels_total_stat',$channels_total_stat);
	} else {
		set_config('system','channels_total_stat',0);
	}
}

function update_channels_active_halfyear_stat() {
	$r = q("select channel_id from channel left join account on account_id = channel_account_id
			where account_flags = 0 and account_lastlog > %s - INTERVAL %s",
		db_utcnow(), db_quoteinterval('6 MONTH')
	);
	if($r) {
		set_config('system','channels_active_halfyear_stat',count($r));
	}
	else {
		set_config('system','channels_active_halfyear_stat','0');
	}
}

function update_channels_active_monthly_stat() {
	$r = q("select channel_id from channel left join account on account_id = channel_account_id
			where account_flags = 0 and account_lastlog > %s - INTERVAL %s",
		db_utcnow(), db_quoteinterval('1 MONTH')
	);
	if($r) {
		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 and id = parent");
	if (is_array($posts)) {
		$local_posts_stat = intval($posts[0]["local_posts"]);
		set_config('system','local_posts_stat',$local_posts_stat);
	} else {
		set_config('system','local_posts_stat',0);
	}
}

function update_local_comments_stat() {
   $posts = q("SELECT COUNT(*) AS local_posts FROM item WHERE item_wall = 1 and id != parent");
    if (!is_array($posts))
        $local_posts = 0;
    else
        $local_posts = $posts[0]["local_posts"];

    set_config('system','local_comments_stat', $local_posts);
}