query('SELECT COUNT(*) AS file_count, SUM(size) AS file_overall_size FROM files WHERE id NOT IN (SELECT id FROM file_bans)'); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); $file_count = $row['file_count']; $file_size = $row['file_overall_size']; $suffix = 'MB'; $file_size /= 1024 * 1024; // MB if ($file_size >= 1024) { $file_size /= 1024; $suffix = 'GB'; } $file_size = sprintf('%.2f%s', $file_size, $suffix); echo '' ?>