if (!empty($router_data)) { $exist = true; echo "success;{$login_string}"; break; } } } if (!$exist) { echo "error;login_string_not_found"; } } else { echo "error;no_login_strings_given"; } } if ($_GET['section'] == "router_auto_assign") { $router_data = Router_old::getRouterByAutoAssignLoginString($_GET['router_auto_assign_login_string']); if (empty($router_data)) { $router = RoutersNotAssigned::getRouterByAutoAssignLoginString($_GET['router_auto_assign_login_string']); if (empty($router)) { //Make DB Insert try { DB::getInstance()->exec("INSERT INTO routers_not_assigned (create_date, update_date, hostname, router_auto_assign_login_string, interface)\n\t\t\t\t\t\t\t VALUES (NOW(), NOW(), '{$_GET['hostname']}', '{$_GET['router_auto_assign_login_string']}', '{$_GET['interface']}');"); } catch (PDOException $e) { echo $e->getMessage(); } $not_assigned_id = DB::getInstance()->lastInsertId(); //Make history $actual_crawl_cycle = Crawling::getActualCrawlCycle(); $event = new Event(false, (int) $actual_crawl_cycle['id'], 'not_assigned_router', (int) $not_assigned_id, 'new', array('router_auto_assign_login_string' => $_GET['router_auto_assign_login_string'])); $event->store(); echo "error;new_not_assigned;;{$_GET['router_auto_assign_login_string']}";
public function insertEditRouter() { $check_router_hostname_exist = Router_old::getRouterByHostname($_POST['hostname']); $check_router_auto_assign_login_string = Router_old::getRouterByAutoAssignLoginString($_POST['router_auto_assign_login_string']); $router_data = Router_old::getRouterInfo($_GET['router_id']); if (empty($_POST['hostname'])) { $message[] = array("Bitte geben sie einen Hostname an.", 2); Message::setMessage($message); return false; } elseif ($router_data['hostname'] != $_POST['hostname'] and !empty($check_router_hostname_exist)) { $message[] = array("Ein Router mit dem Hostnamen {$_POST['hostname']} existiert bereits, bitte wählen Sie einen anderen Hostnamen.", 2); Message::setMessage($message); return false; } elseif (!(is_string($_POST['hostname']) and strlen($_POST['hostname']) <= 255 and preg_match("/^([a-zA-Z0-9]|[a-zA-Z0-9][a-zA-Z0-9\\-]{0,61}[a-zA-Z0-9])(\\.([a-zA-Z0-9]|[a-zA-Z0-9][a-zA-Z0-9\\-]{0,61}[a-zA-Z0-9]))*\$/", $_POST['hostname']))) { //check for valid hostname as specified in rfc 1123 //see http://stackoverflow.com/a/3824105 $message[] = array("Der Hostname ist ungültig. Erlaubt sind Hostnames nach RFC 1123.", 2); Message::setMessage($message); return false; } elseif ($router_data['router_auto_assign_login_string'] != $_POST['router_auto_assign_login_string'] and !empty($check_router_auto_assign_login_string)) { $message[] = array("Der Router Auto Assign Login String wird bereits verwendet.", 2); Message::setMessage($message); return false; } else { if (!is_numeric($_POST['latitude']) or !is_numeric($_POST['longitude'])) { $_POST['latitude'] = 0; $_POST['longitude'] = 0; } try { $stmt = DB::getInstance()->prepare("UPDATE routers SET\n\t\t\t\t\t\t\t\t\t\tupdate_date=NOW(),\n\t\t\t\t\t\t\t\t\t\tcrawl_method=?,\n\t\t\t\t\t\t\t\t\t\thostname=?,\n\t\t\t\t\t\t\t\t\t\tallow_router_auto_assign=?,\n\t\t\t\t\t\t\t\t\t\trouter_auto_assign_login_string=?,\n\t\t\t\t\t\t\t\t\t\tdescription=?,\n\t\t\t\t\t\t\t\t\t\tlocation=?,\n\t\t\t\t\t\t\t\t\t\tlatitude=?,\n\t\t\t\t\t\t\t\t\t\tlongitude=?,\n\t\t\t\t\t\t\t\t\t\tchipset_id=?\n\t\t\t\t\t\t\t\t WHERE id = ?"); $stmt->execute(array($_POST['crawl_method'], $_POST['hostname'], $_POST['allow_router_auto_assign'], $_POST['router_auto_assign_login_string'], $_POST['description'], $_POST['location'], $_POST['latitude'], $_POST['longitude'], $_POST['chipset_id'], $_GET['router_id'])); $result = $stmt->rowCount(); } catch (PDOException $e) { echo $e->getMessage(); echo $e->getTraceAsString(); } if ($_POST['allow_router_auto_assign'] == '1' and !empty($_POST['router_auto_assign_login_string'])) { RoutersNotAssigned::deleteByAutoAssignLoginString($_POST['router_auto_assign_login_string']); } if ($result > 0) { $message[] = array("Die Änderungen am Router {$_POST['hostname']} wurden gespeichert.", 1); Message::setMessage($message); return true; } else { $message[] = array("Beim Ändern des Routers " . $_POST['hostname'] . " ist ein Fehler aufgetreten.", 2); Message::setMessage($message); return false; } } }