function table_list()
{
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_meta();
$fontsize = "16px";
$cs = 0;
$page = 1;
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
if (!is_numeric($rp)) {
$rp = 50;
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$_POST["query"] = trim($_POST["query"]);
$FORCE = "uuid='{$_GET["uuid"]}'";
$search = '%';
$table = "philesight";
if ($_GET["dev"] != null) {
$FORCE = " ((partition='{$_GET["dev"]}') OR (hd='{$_GET["dev"]}')) AND (uuid='{$_GET["uuid"]}')";
}
$page = 1;
if (!$q->TABLE_EXISTS($table, "artica_backup")) {
$q->check_storage_table();
}
if (!$q->TABLE_EXISTS($table, "artica_backup")) {
json_error_show("{$table} no such table", 1);
}
$total = 0;
if ($q->COUNT_ROWS($table, "artica_backup") == 0) {
json_error_show("no data", 1);
}
$searchstring = string_to_flexquery();
if ($searchstring != null) {
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE {$FORCE} {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup"));
if (!$q->ok) {
if (preg_match("#marked as crashed#", $q->mysql_error)) {
$q->QUERY_SQL("DROP TABLE `{$table}`", "artica_events");
}
}
$total = $ligne["TCOUNT"];
} else {
$total = $q->COUNT_ROWS($table, "artica_backup");
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
if (!is_numeric($rp)) {
$rp = 50;
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
$sql = "SELECT * FROM `{$table}` WHERE {$FORCE} {$searchstring} {$ORDER} {$limitSql}";
$results = $q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
if (preg_match("#marked as crashed#", $q->mysql_error)) {
$q->QUERY_SQL("DROP TABLE `{$table}`", "artica_events");
}
}
if (!$q->ok) {
json_error_show($q->mysql_error . "<br>{$sql}", 0);
}
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
$CurrentPage = CurrentPageName();
if (mysql_num_rows($results) == 0) {
json_error_show("no data");
}
$uuid = urlencode($_GET["uuid"]);
while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
$color = "black";
$icon = " ";
$directory = $ligne["directory"];
$md5 = md5($directory);
$partition = $ligne["partition"];
$hd = $ligne["hd"];
$maxtime = $ligne["maxtime"];
$lastscan = $ligne["lastscan"];
$USED = $ligne["USED"];
$md5 = $ligne["zmd5"];
$FREEMB = $ligne["FREEMB"];
if ($lastscan > 0) {
$lastscan = date("Y-m-d H:i:s", $lastscan);
}
$FREEMB = FormatBytes($FREEMB * 1024);
$directoryenc = urlencode($directory);
$jslink = "<a href=\"javascript:blur();\"\n\tOnClick=\"javascript:Loadjs('{$MyPage}?directory-js=yes&directory={$directoryenc}');\"\n\tstyle='font-size:{$fontsize};text-decoration:underline;color:{$color}'>";
$distance = $tpl->_ENGINE_parse_body(distanceOfTimeInWords($ligne["lastscan"], time(), true));
$icon = imgsimple("graph-32.png", null, "Loadjs('{$MyPage}?graph-js={$directoryenc}&uuid={$_GET["uuid"]}&md5={$md5}')");
$delete = imgsimple("delete-32.png", null, "Loadjs('{$MyPage}?delete-js={$directoryenc}&uuid={$_GET["uuid"]}')");
$data['rows'][] = array('id' => md5(serialize($ligne)), 'cell' => array("<span style='font-size:{$fontsize};color:{$color}'>{$jslink}{$lastscan}</a></span><br><i>{$distance}</i>", "<span style='font-size:{$fontsize};color:{$color}'>{$jslink}{$directory}</a></span>", "<span style='font-size:{$fontsize};color:{$color}'>{$jslink}{$partition}</a></span>", "<span style='font-size:{$fontsize};color:{$color}'>{$jslink}{$hd}</a></span>", "<span style='font-size:{$fontsize};color:{$color}'>{$jslink}{$USED}%</a></span>", "<span style='font-size:{$fontsize};color:{$color}'>{$jslink}{$FREEMB}</a></span>", "<span style='font-size:{$fontsize};color:{$color}'>{$icon}</a></span>"));
}
echo json_encode($data);
}
