function addRange($range, $id)
{
$rangeString = "";
if ($id > 1) {
$rangeString .= ",";
}
$rangeString .= "{";
$rangeString .= '"@type":"OpeningHoursSpecification",';
$rangeString .= '"dayOfWeek":[';
$rangeString .= '"' . implode('","', $range) . '"';
$rangeString .= '],';
$GLOBALS['hoursString'] .= $rangeString;
addTime($id, count($range));
}
function addTime($star, $start, $len, &$chartData, &$TIME_SIZE)
{
if ($len <= 0) {
return;
}
if ($len < $TIME_SIZE) {
$chartData[$star][$start] += $len;
$len = 0;
} else {
$len -= $TIME_SIZE;
$chartData[$star][$start] += $TIME_SIZE;
}
addTime($star, $start + 1, $len, $chartData, $TIME_SIZE);
}
function schedule($db, $scheduleId, $timeToSchedule, $startTime, $endTime)
{
$query = "SELECT startTime, endTime FROM scheduleEvent se JOIN event e WHERE scheduleId=:id AND eventId = e.id" . " ORDER BY startTime";
$query = $db->prepare($query);
$query->execute(array(':id' => $scheduleId));
$eventEndTime = addTime($startTime, $timeToSchedule);
$eventStartTime = $startTime;
foreach ($query->fetchAll() as $event) {
if (greaterThanOrEqualToTime($event['startTime'], $eventEndTime)) {
break;
} else {
$eventStartTime = $event['endTime'];
$eventEndTime = addTime($event['endTime'], $timeToSchedule);
}
}
return array('startTime' => $eventStartTime, 'endTime' => $eventEndTime);
}
$probed_lessons = array();
foreach ($result as $value) {
$probed_lessons[$value['id']] = array("lessons_ID" => $value['id'], "lessons_name" => $value['name'], "active" => $value['active']);
}
foreach ($probed_lessons as $id => $lesson) {
$userTraffic = $allStats[$id];
//$userTraffic = EfrontStats :: getUsersTime($id, $user_logins, $from, $to);
foreach ($user_logins as $user => $login) {
if ($userTraffic[$login]['accesses']) {
if (!isset($traffic['lessons'][$id])) {
$traffic['lessons'][$id] = $userTraffic[$login];
$traffic['lessons'][$id]['name'] = $lesson['lessons_name'];
$traffic['lessons'][$id]['active'] = $lesson['active'];
} else {
$traffic['lessons'][$id]['accesses'] += $userTraffic[$login]['accesses'];
addTime($traffic['lessons'][$id], $userTraffic[$login]);
//$traffic['lessons'][$id]['total_seconds'] +=???????
}
$traffic['total_access'] += $userTraffic[$login]['accesses'];
}
}
}
//and timestamp between $from and $to
$result = eF_getTableData("logs", "count(*)", "action = 'login' and users_LOGIN in ('" . implode("','", $user_logins) . "') order by timestamp");
$traffic['total_logins'] = $result[0]['count(*)'];
$smarty->assign("T_USER_TRAFFIC", $traffic);
$actions = array('login' => _LOGIN, 'logout' => _LOGOUT, 'lesson' => _ACCESSEDLESSON, 'content' => _ACCESSEDCONTENT, 'tests' => _ACCESSEDTEST, 'test_begin' => _BEGUNTEST, 'lastmove' => _NAVIGATEDSYSTEM);
$smarty->assign("T_ACTIONS", $actions);
$smarty->display($_SESSION['s_type'] . '.tpl');
} else {
if (isset($_GET['add_to_existing_group'])) {
if ($GLOBALS['VDATA']['sp.seamless'] == "true") {
$truncate = mysql_query("TRUNCATE TABLE `{$_DDATA['tablename']}`;", $_DDATA['link']);
$insert = mysql_query("INSERT INTO `{$_DDATA['tablename']}` SELECT * FROM `{$_DDATA['tabletemp']}`;", $_DDATA['link']);
$drop = mysql_query("DROP TABLE `{$_DDATA['tabletemp']}`;", $_DDATA['link']);
}
$optimize = mysql_query("OPTIMIZE TABLE `{$_DDATA['tablename']}`;", $_DDATA['link']);
$update = mysql_query("UPDATE `{$_DDATA['tablestat']}` SET `cache`='';", $_DDATA['link']);
OS_setData("sp.lock", "false");
$lasttime = array_sum(explode(" ", microtime())) - $_SDATA['now'];
if (!$_XDATA['reindex']) {
OS_setData("sp.time", time());
OS_setData("sp.fullscan", "false");
OS_setData("sp.lasttime", $lasttime);
OS_setData("sp.alldata", $_XDATA['dataleng']);
}
addTime("MySQL");
restore_error_handler();
$_LOG[] = "*** " . sprintf($_LANG['0pn'], count($_XDATA['scanned'])) . " ***";
$_LOG[] = "{$_LANG['0po']}: " . sprintf("%01.2f", $lasttime) . "s";
if (count($_XDATA['scanned'])) {
$_LOG[] = "{$_LANG['0pp']}: " . sprintf("%01.3f", $lasttime / count($_XDATA['scanned'])) . "s";
}
$_LOG[] = "{$_LANG['0pq']}: {$_XDATA['stats']['New']}";
$_LOG[] = "{$_LANG['0pr']}: {$_XDATA['stats']['Updated']}";
$_LOG[] = "{$_LANG['0ps']}: {$_XDATA['stats']['Not Found']}";
$_LOG[] = "{$_LANG['0pt']}: {$_XDATA['stats']['Orphan']}";
$_LOG[] = "{$_LANG['0pu']}: {$_XDATA['stats']['Blocked']}";
/* ***** End Spider *******************************************
***************************************************************
******** Begin Sitemap ************************************* */
if ($GLOBALS['VDATA']['sm.enable'] == "true") {
