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']}";
} else {
try {
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;
}
}
}
<?php
require_once 'runtime.php';
require_once 'lib/core/routersnotassigned.class.php';
$smarty->assign('message', Message::getMessage());
$routerlist = RoutersNotAssigned::getRouters();
$smarty->assign('routerlist', $routerlist);
$smarty->display("header.tpl.html");
$smarty->display("routers_trying_to_assign.tpl.html");
$smarty->display("footer.tpl.html");
require_once 'lib/core/User.class.php';
require_once 'lib/core/routersnotassigned.class.php';
require_once 'lib/core/Eventlist.class.php';
require_once 'lib/core/Service.class.php';
require_once 'lib/core/Servicelist.class.php';
//get messages of the message system
$smarty->assign('message', Message::getMessage());
//get some status variables
$smarty->assign('is_logged_in', Permission::isLoggedIn($_SESSION['user_id']));
//get user data
$user = new User((int) $_GET['user_id']);
$user->fetch();
$smarty->assign('user', $user);
$evenlist = new Eventlist();
$routerlist = new Routerlist(false, (int) $_GET['user_id']);
foreach ($routerlist->getRouterlist() as $router) {
$tmp_eventlist = new Eventlist();
$tmp_eventlist->init('router', $router->getRouterId(), false, 0, 6, 'event_id', 'desc');
$evenlist->add($tmp_eventlist);
}
$evenlist->sort('create_date', 'desc');
$smarty->assign('eventlist', array_slice($evenlist->getEventlist(), 0, 10));
$smarty->assign('routersnotassigned_list', RoutersNotAssigned::getRouters());
$routerlist = new Routerlist(false, (int) $_GET['user_id']);
$smarty->assign('routerlist', $routerlist->getRouterlist());
$servicelist = new Servicelist((int) $_GET['user_id']);
$smarty->assign('servicelist', $servicelist->getServicelist());
//load the temlate
$smarty->display("header.tpl.html");
$smarty->display("user.tpl.html");
$smarty->display("footer.tpl.html");
