function search() { $tpl = new templates(); $MyPage = CurrentPageName(); $sock = new sockets(); $q = new mysql(); $t = $_GET["t"]; $search = '%'; $page = 1; $FORCE_FILTER = null; $total = 0; $table = "last_boot"; $data = array(); $data['page'] = $page; $data['total'] = 0; $data['rows'] = array(); $fontsize = 20; $style = "style='font-size:20px'"; $c = 0; $tpl = new templates(); $curr = $tpl->javascript_parse_text("{current}"); $tables = $tpl->javascript_parse_text("{tables}"); $db = new influx(); $DBS = $db->ROOT_DUMP_ALL_DATABASES(); while (list($database, $size) = each($DBS)) { $c++; $current = null; $ms5 = md5($database); $TABLES = $db->LIST_TABLES($database); $CountOfTables = count($TABLES); $delete = imgsimple("delete-32.png", null, "Loadjs('{$MyPage}?delete-db-js={$database}')"); $color = "black"; if ($database == $db->systemid) { $current = " ({$curr})"; } $size = FormatBytes(intval($size) / 1024); $data['rows'][] = array('id' => $ms5, 'cell' => array("<span {$style}>{$database}{$current} {$CountOfTables} {$tables}</a></span>", "<center>{$delete}</a></center>")); } if ($c == 0) { json_error_show("no data"); } $data['total'] = $c; echo json_encode($data); }
function query_influx($sql) { $GLOBALS["VERBOSE"] = true; $GLOBALS["DEBUG_INFLUX_VERBOSE"] = true; $influx = new influx(); $influx->ROOT_DUMP_ALL_DATABASES(); $main = $influx->QUERY_SQL($sql); foreach ($main as $row) { echo "TIME: " . date("Y-m-d H:i:s", $row->time) . "\n"; echo "SIZE: {$row->size}\n"; var_dump($row, $row->time); } echo "today is " . strtotime(date("Y-m-d H:i:s")) . "\n"; }