function dl_read_stat_per_path($path = "%", $sortBy, $sort, $listType, $limit)
{
$config = dl_get_config();
if (!isset($sortBy)) {
$sortBy = $config["sortBy"];
}
if (!isset($sort)) {
$sort = $config["sortOrder"];
}
if (!isset($limit)) {
$limit = $config["top_max"];
}
$db = __do_db_connect();
$sth = $db->prepare("SELECT url, counter FROM dl_statistics WHERE url LIKE :path ORDER by {$sortBy} {$sort}");
if ($sth) {
$generic_path = "";
if ($path == "%") {
$generic_path = "%";
} else {
$generic_path = $path . '%';
}
$sth->bindParam(':path', $generic_path);
if (!$sth->execute()) {
print_r($sth->errorInfo());
die("Error executing statement ");
}
$result = $sth->fetchAll();
# Tidy array up, I only want named keys
$full_result = array();
foreach ($result as $elem => &$line) {
if (file_exists('/mnt/usb/LibraryBox' . $line['url'])) {
unset($line[0]);
unset($line[1]);
$url_expl = explode('/', $line['url']);
$line['filename'] = end($url_expl);
$line['url_encoded'] = rawurlencode($line['url']);
$line['filename_encoded'] = rawurlencode(get_utf8_encoded($line['filename']));
$full_result[] = $line;
}
}
if ($listType == "top") {
return array_slice($full_result, 0, $limit);
}
return $full_result;
} else {
print_r($db->errorInfo());
die("\n no valid statement could be found");
}
}
foreach ($folderlist as $folder) {
print "<tr><td class='n'><a id='folder' href='" . rawurlencode($folder['name']) . "'>" . get_utf8_encoded($folder['name']) . "</a>/</td>";
//print "<td class='m'>" . date('Y-M-d H:i:s', $folder['modtime']) . "</td>";
print "<td class='s hidden-sm hidden-xs'>" . ($calculate_folder_size ? format_bytes($folder['size'], 2) : '--') . " </td>";
print "<td class='t hidden-sm hidden-xs'>" . $folder['file_type'] . "</td></tr>\n";
}
// This simply creates an extra line for file/folder seperation
print "<tr><td colspan='4' style='height:7px;'></td></tr>\n";
// Print file information
foreach ($filelist as $file) {
global $collect_dl_count;
$file_link_prefix = "";
if ($collect_dl_count) {
$file_link_prefix = "/dl_statistics_counter.php?DL_URL=/" . rawurlencode($path);
}
print "<tr><td class='n'><a id='" . $file['img_id'] . "' href='{$file_link_prefix}" . rawurlencode($file['name']) . "'>" . get_utf8_encoded($file['name']) . "</a></td>";
// print "<td class='m'>" . date('Y-M-d H:i:s', $file['modtime']) . "</td>";
print "<td class='s hidden-sm hidden-xs'>" . format_bytes($file['size'], 2) . " </td>";
print "<td class='t hidden-sm hidden-xs'>" . $file['file_type'] . "</td>";
if ($display_dl_count) {
print "<td class='c hidden-sm hidden-xs'>" . $file['counter'] . "</td>";
}
print "</tr>\n";
}
// Print ending stuff
print "</tbody>\n\t</table>\n\t</div>";
if ($display_readme) {
if (is_file($path . '/README')) {
print "<pre>";
print nl2br(file_get_contents($path . '/README'));
print "</pre>";
