diff options
| author | Marcin Łabanowski <marcin@6irc.net> | 2015-03-28 05:22:02 +0100 |
|---|---|---|
| committer | Marcin Łabanowski <marcin@6irc.net> | 2015-03-28 05:22:02 +0100 |
| commit | 8eb3d709f787834670a1d6547a905c84ebaa43fd (patch) | |
| tree | f8ae17606b99528486cf7d5730fbec5b06e14780 | |
| parent | 10f93d0d4367ade293c7a8733989cedcd7ca791a (diff) | |
| parent | 034b288a1317a940c3a5722c6d2864d1ea08f5db (diff) | |
Merge pull request #129 from JasonPuglisi/active-content-fix
Fixed and re-enabled active content stat for recent theme
| -rw-r--r-- | templates/themes/recent/theme.php | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/templates/themes/recent/theme.php b/templates/themes/recent/theme.php index 2ea6a7b9..ce64c80e 100644 --- a/templates/themes/recent/theme.php +++ b/templates/themes/recent/theme.php @@ -125,15 +125,20 @@ $stats['unique_posters'] = number_format($query->fetchColumn()); // Active content - /*$query = 'SELECT SUM(`filesize`) FROM ('; + $query = 'SELECT DISTINCT(`files`) FROM ('; foreach ($boards as &$_board) { if (in_array($_board['uri'], $this->excluded)) continue; - $query .= sprintf("SELECT `filesize` FROM ``posts_%s`` UNION ALL ", $_board['uri']); + $query .= sprintf("SELECT `files` FROM ``posts_%s`` UNION ALL ", $_board['uri']); } - $query = preg_replace('/UNION ALL $/', ') AS `posts_all`', $query); + $query = preg_replace('/UNION ALL $/', ' WHERE `num_files` > 0) AS `posts_all`', $query); $query = query($query) or error(db_error()); - $stats['active_content'] = $query->fetchColumn();*/ + $files = $query->fetchAll(); + $stats['active_content'] = 0; + foreach ($files as &$file) { + preg_match_all('/"size":([0-9]*)/', $file[0], $matches); + $stats['active_content'] += array_sum($matches[1]); + } return Element('themes/recent/recent.html', Array( 'settings' => $settings, |