// erwartet einen Parameter in der Form: dateFrom=2007-12-12+08:00:00 , dateTo=2007-12-19+20:59:59
$timeStampFrom = FX::parseDBDate(str_replace("+", " ", $d0));
$timeStampTo = FX::parseDBDate(str_replace("+", " ", $d1));
echo "Dateien, auf die zwischen den Daten " . FX::makeDBDate($timeStampFrom) . " und " . FX::makeDBDate($timeStampTo) . " schreibend zugegriffen wurde.\n";
$sql = "SELECT path, fname, mtime FROM files WHERE " . "(mtime > '" . FX::makeDBDate($timeStampFrom) . "') " . " AND (mtime < '" . FX::makeDBDate($timeStampTo) . "') " . " AND (status='C')" . " ORDER BY mtime DESC;";
$result = @mysqli_query($LNK, $sql);
if (!$result) {
errlog(__FILE__ . "@" . __LINE__ . ": " . mysqli_error($LNK) . " ( SQL = " . $sql . ")");
}
while ($row = mysqli_fetch_assoc($result)) {
extract($row);
echo $path . "/" . $fname . " [" . $mtime . "]" . "\n";
}
}
if (isset($sameName)) {
echo "Dateien mit dem Namen " . FX::html_encode($sameName) . " existieren in den Verzeichnissen:\n";
$sql = "SELECT path, size FROM files WHERE fname LIKE '" . mysqli_escape_string($LNK, $sameName) . "' AND status='C';";
$result = @mysqli_query($LNK, $sql);
if (!$result) {
errlog(__FILE__ . "@" . __LINE__ . ": " . mysqli_error($LNK) . " ( SQL = " . $sql . ")");
}
while ($row = mysqli_fetch_assoc($result)) {
echo $row["path"] . " [" . $row["size"] . " bytes]" . "\n";
}
}
if (isset($largeFiles)) {
$sql = "SELECT path, fname, size FROM files WHERE size > (100 * 1048000) AND status='C'";
if (isset($ext)) {
$sql .= " AND extension LIKE '" . mysqli_escape_string($LNK, $ext) . "'";
}
$sql .= " ORDER BY size DESC;";
static function toHtmlTable($obj, $htmlEncode = false)
{
$retval = array();
if (is_object($obj)) {
$retval[] = '<table>';
$retval[] = '<tr><th>' . get_class($obj) . '</th><th> </th></tr>';
$retval[] = '<tr><th>Field</th><th>Value</th></tr>';
foreach (get_object_vars($obj) as $key => $value) {
if ($value === false) {
$value = '<em>false</em>';
}
if ($value === null) {
$value = '<em>null</em>';
}
if (is_array($value) or is_object($value)) {
$value = FX::toHtmlTable($value, $htmlEncode);
} else {
if ($htmlEncode) {
$value = FX::html_encode($value);
}
}
$retval[] = '<tr><td valign="top">' . $key . '</td><td valign="top">' . $value . '</td></tr>';
}
$retval[] = '</table>';
} else {
if (is_array($obj)) {
if (count($obj) == 0) {
$retval[] = '<em>(empty array)</em>';
} else {
$retval[] = '<table>';
$retval[] = '<tr><th>Key</th><th>Value</th></tr>';
foreach ($obj as $key => $value) {
if ($value === false) {
$value = '<em>false</em>';
}
if ($value === null) {
$value = '<em>null</em>';
}
if (is_array($value) or is_object($value)) {
$value = FX::toHtmlTable($value, $htmlEncode);
} else {
if ($htmlEncode) {
$value = FX::html_encode($value);
}
}
$retval[] = '<tr><td valign="top">' . $key . '</td><td valign="top">' . $value . '</td></tr>';
}
$retval[] = '</table>';
}
} else {
if ($htmlEncode) {
$obj = FX::html_encode($obj);
}
$retval[] = $obj;
}
}
return implode("\n", $retval);
}
