$stmt = DB::getInstance()->prepare("SELECT *\n\t\t\t\t\t\t\t\t\t\t\t\tFROM interfaces\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE id not in (SELECT interface_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM crawl_interfaces\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE crawl_cycle_id={$actual_crawl_cycle['id']})");
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
echo $e->getMessage();
echo $e->getTraceAsString();
}
foreach ($result as $interface) {
echo "\tInserting offline data for interface " . $interface['name'] . "\n";
$networkinterface_status = new NetworkinterfaceStatus(false, (int) $actual_crawl_cycle['id'], (int) $interface['id'], (int) $interface['router_id']);
$networkinterface_status->store();
}
echo "Close old crawl cycle and create new one\n";
//Create new crawl cycle and close old crawl cycle
//Create new crawl cycle
Crawling::newCrawlCycle();
//Close old Crawl cycle
Crawling::closeCrawlCycle($actual_crawl_cycle['id']);
echo "Create graph statistics\n";
//Make statistic graphs
$online = Router_old::countRoutersByCrawlCycleIdAndStatus($actual_crawl_cycle['id'], 'online');
$offline = Router_old::countRoutersByCrawlCycleIdAndStatus($actual_crawl_cycle['id'], 'offline');
$unknown = Router_old::countRoutersByCrawlCycleIdAndStatus($actual_crawl_cycle['id'], 'unknown');
$total = $unknown + $offline + $online;
RrdTool::updateNetmonHistoryRouterStatus($online, $offline, $unknown, $total);
$client_count = Router_old::countRoutersByCrawlCycleId($actual_crawl_cycle['id']);
RrdTool::updateNetmonClientCount($client_count);
} else {
echo "There is an crawl cycle running actually. Doing nothing.\n";
}
/**
Config::writeConfigLine('mail_smtp_ssl', $_POST['mail_smtp_ssl']);
Config::writeConfigLine('twitter_consumer_key', "dRWT5eeIn9UiHJgcjgpPQ");
Config::writeConfigLine('twitter_consumer_secret', "QxcnltPX2sTH8E7eZlxyZeqTIVoIoRjlrmUfkCzGSA");
Config::writeConfigLine('enable_network_policy', 'false');
Config::writeConfigLine('network_policy_url', 'http://picopeer.net/PPA-de.html');
Config::writeConfigLine('template', "freifunk_oldenburg");
Config::writeConfigLine('hours_to_keep_mysql_crawl_data', 5);
Config::writeConfigLine('hours_to_keep_history_table', 72);
Config::writeConfigLine('crawl_cycle_length_in_minutes', 10);
Config::writeConfigLine('event_notification_router_offline_crawl_cycles', 6);
Config::writeConfigLine('community_essid', 'deinestadt.freifunk.net');
//create a default chipset
$default_chipset = new Chipset(false, "", "Unbekannt");
$default_chipset->store();
//create an initial crawl cycle
$crawl_cycle_id = Crawling::newCrawlCycle(10);
//require_once(ROOT_DIR.'/cronjobs.php');
header('Location: ./install.php?section=finish');
}
} elseif ($_GET['section'] == "finish") {
$config_path = "./config/config.local.inc.php";
$file = Install::getFileLineByLine($config_path);
$configs[0] = '$GLOBALS[\'installed\'] = true;';
$file = Install::changeConfigSection('//INSTALLED', $file, $configs);
Install::writeEmptyFileLineByLine($config_path, $file);
$message[] = array('Netmon wurde erfolgreich installiert.', 1);
$message[] = array('Die Installationsroutine wurde für weitere Zugriffe gesperrt.', 1);
$message[] = array('Bitte registrieren Sie sich, der erste registrierte Benutzer bekommt automatisch volle Root-Rechte!', 1);
Message::setMessage($message);
header('Location: ./register.php');
}
