<?php /** Include Classes **/ require_once 'runtime.php'; require_once 'lib/core/Eventlist.class.php'; require_once 'lib/core/RouterStatus.class.php'; /** Get and assign global messages **/ $smarty->assign('message', Message::getMessage()); /** History **/ if (empty($_POST['event_count'])) { $event_count = 30; } else { $event_count = $_POST['event_count']; } $smarty->assign('event_count', $event_count); $eventlist = new Eventlist(); $eventlist->init(false, false, false, 0, $event_count, 'event_id', 'desc'); $smarty->assign('eventlist', $eventlist->getEventlist()); /** Display templates **/ $smarty->display("header.tpl.html"); $smarty->display("eventlist.tpl.html"); $smarty->display("footer.tpl.html");
//Delete old Crawls echo "Remove old crawl data\n"; Crawling::deleteOldCrawlDataExceptLastOnlineCrawl($GLOBALS['hours_to_keep_mysql_crawl_data'] * 60 * 60); //Remove old events echo "Remove old events\n"; //Get number of total events in db $total_count = new Eventlist(); $total_count->init(false, false, false, 0, 0); $total_count = $total_count->getTotalCount(); //Fetch the 50 oldest events from db and check if they need to be deleted. //Then fetch the next 50 oldest events until you get to an event that is not old enough to delete it //or if you looped through all events. for ($offset = 0; $offset < $total_count; $offset += 50) { $eventlist = new Eventlist(); $eventlist->init(false, false, false, $offset, 50, 'create_date', 'asc'); foreach ($eventlist->getEventlist() as $event) { if ($event->getCreateDate() < time() - 60 * 60 * $GLOBALS['hours_to_keep_history_table']) { $event->delete(); } else { $offset = $total_count; break; } } } //Remove old not assigned routers echo "Remove not assigned routers that haven´t been updated for a while\n"; DB::getInstance()->exec("DELETE FROM routers_not_assigned WHERE TO_DAYS(update_date) < TO_DAYS(NOW())-2"); /** * Crawl **/ echo "Do crawling\n";
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");