diff options
| author | Jason Puglisi <jason@puglisi.im> | 2015-03-19 21:49:57 -0400 |
|---|---|---|
| committer | Jason Puglisi <jason@puglisi.im> | 2015-03-19 21:49:57 -0400 |
| commit | 1283e51ca50c9085a0f1b763fa4928c91b7c8e69 (patch) | |
| tree | 261cd1effa8ab676a52aae052e49780f82b0569f /templates/themes/recent | |
| parent | d4d5f594514976ad3f42c8ae9993ed6ed2c59867 (diff) | |
Fixed and re-enabled active content stat for recent theme
Diffstat (limited to 'templates/themes/recent')
| -rw-r--r-- | templates/themes/recent/theme.php | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/templates/themes/recent/theme.php b/templates/themes/recent/theme.php index 2ea6a7b9..9307c6a9 100644 --- a/templates/themes/recent/theme.php +++ b/templates/themes/recent/theme.php @@ -125,15 +125,18 @@ $stats['unique_posters'] = number_format($query->fetchColumn()); // Active content - /*$query = 'SELECT SUM(`filesize`) FROM ('; + $query = 'SELECT `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) + $stats['active_content'] += intval(preg_replace('/.*"size":([0-9]*).*/', '$1', $file[0])); return Element('themes/recent/recent.html', Array( 'settings' => $settings, |