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