$result = DB::getInstance()->query($sql); foreach ($result as $row) { echo $row['mac_addr'] . " " . $row['hostname'] . "_" . $row['name'] . "\n"; } } catch (PDOException $e) { echo $e->getMessage(); } } /** Nodewatcher Version >18 */ if ($_GET['section'] == "insert_crawl_data") { $router_data = Router_old::getRouterInfo($_POST['router_id']); //If is owning user or if root if ($_POST['authentificationmethod'] == 'hash' and ($router_data['allow_router_auto_assign'] == 1 and !empty($router_data['router_auto_assign_hash']) and $router_data['router_auto_assign_hash'] == $_POST['router_auto_update_hash'])) { echo "success;" . $router_data['hostname'] . ";"; $actual_crawl_cycle = Crawling::getActualCrawlCycle(); $router_has_been_crawled = Crawling::checkIfRouterHasBeenCrawled($_POST['router_id'], $actual_crawl_cycle['id']); if (!$router_has_been_crawled) { $last_endet_crawl_cycle = Crawling::getLastEndedCrawlCycle(); /**Insert Router System Data*/ $router_status = new RouterStatus(false, (int) $actual_crawl_cycle['id'], (int) $_POST['router_id'], $_POST['status'], false, $_POST['hostname'], (int) $_POST['client_count'], $_POST['chipset'], $_POST['cpu'], (int) $_POST['memory_total'], (int) $_POST['memory_caching'], (int) $_POST['memory_buffering'], (int) $_POST['memory_free'], $_POST['loadavg'], $_POST['processes'], $_POST['uptime'], $_POST['idletime'], $_POST['local_time'], $_POST['distname'], $_POST['distversion'], $_POST['openwrt_core_revision'], $_POST['openwrt_feeds_packages_revision'], $_POST['firmware_version'], $_POST['firmware_revision'], $_POST['kernel_version'], $_POST['configurator_version'], $_POST['nodewatcher_version'], $_POST['fastd_version'], $_POST['batman_advanced_version']); $router_status->store(); /**Insert Router Interfaces*/ foreach ($_POST['int'] as $sendet_interface) { /** * Interface */ //check if interface already exists $networkinterface_test = new Networkinterface(false, (int) $_POST['router_id'], $sendet_interface['name']); //if interface not exist, create new if (!$networkinterface_test->fetch()) { $networkinterface_new = new Networkinterface(false, (int) $_POST['router_id'], $sendet_interface['name']);