Virtual Directory Listing
fetch($db->query("SELECT description, parent FROM folders WHERE id = '" . $db->escape($folder) . "' ORDER BY name ASC;")); echo '' . nl2br($parent['description']) . '
'; } echo ''; echo breadcrumbs($folder); echo '
'; echo ''; ?>| Name | Size | Date |  .. | '; } $res = $db->query("SELECT id, name, description FROM folders WHERE parent = '" . $db->escape($folder) . "' ORDER BY name ASC;"); while ($row = $db->fetch($res)) { echo ' | ' . $row['name'] . '';
echo ' ' . nl2br($row['description']) . ''; echo ' | ';
if (!empty($row['description'])) {
echo ' | ';
} else {
echo ''; } echo ' | '; } $sql = "SELECT f.id, f.name, i.description, i.date, i.showdate, i.size, i.showsize, i.location FROM files f, fileinfo i WHERE i.id = f.info and f.folder = '" . $db->escape($folder) . "' ORDER BY f.name ASC;"; $res = $db->query($sql); while ($row = $db->fetch($res)) { echo ' |
|---|---|---|---|---|
' . $row['description'] . ' | ';
if (!empty($row['description'])) {
echo ' | ';
} else {
echo ''; } echo ' | '; if ($row['showsize']) { if (file_exists($row['location'])) echo byteConvert(filesize($row['location'])); else echo byteConvert($row['size']); } else { echo '-'; } echo ' | '; if ($row['showdate']) echo ' ' . date('j M Y G:i:s', $row['date']); else echo '-'; echo ' |