<?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");
