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); }