$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']);
