diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-05-06 21:03:33 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-05-06 21:03:33 -0700 |
| commit | 25b599a4bd831f175572c2388754e8734a255d77 (patch) | |
| tree | 16559183d5d004c430dd8d83171bb9348e784021 /include/statistics_fns.php | |
| parent | 75b8bfc07a2431a6d4d5f2f72864d6cd3aa33cf6 (diff) | |
| download | volse-hubzilla-25b599a4bd831f175572c2388754e8734a255d77.tar.gz volse-hubzilla-25b599a4bd831f175572c2388754e8734a255d77.tar.bz2 volse-hubzilla-25b599a4bd831f175572c2388754e8734a255d77.zip | |
convert ITEM_WALL from bitfield to standalone
Diffstat (limited to 'include/statistics_fns.php')
| -rw-r--r-- | include/statistics_fns.php | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/include/statistics_fns.php b/include/statistics_fns.php index 288925a2c..ce2eee5e7 100644 --- a/include/statistics_fns.php +++ b/include/statistics_fns.php @@ -23,8 +23,7 @@ function update_channels_active_halfyear_stat() { $s .= ','; $s .= intval($rr['channel_id']); } - $x = q("select uid from item where uid in ( $s ) and (item_flags & %d)>0 and created > %s - INTERVAL %s group by uid", - intval(ITEM_WALL), + $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) { @@ -50,8 +49,7 @@ function update_channels_active_monthly_stat() { $s .= ','; $s .= intval($rr['channel_id']); } - $x = q("select uid from item where uid in ( $s ) and ( item_flags & %d )>0 and created > %s - INTERVAL %s group by uid", - intval(ITEM_WALL), + $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) { @@ -66,8 +64,7 @@ function update_channels_active_monthly_stat() { } function update_local_posts_stat() { - $posts = q("SELECT COUNT(*) AS local_posts FROM `item` WHERE (item_flags & %d)>0 ", - intval(ITEM_WALL) ); + $posts = q("SELECT COUNT(*) AS local_posts FROM `item` WHERE item_wall = 1 "); if (is_array($posts)) { $local_posts_stat = intval($posts[0]["local_posts"]); set_config('system','local_posts_stat',$local_posts_stat); |