function getNearEvents()
{
global $user, $sortColumn, $sortOrder;
$eventId = $_REQUEST['id'];
$event = dbFetchOne('select * from Events where Id = ?', NULL, array($eventId));
parseFilter($_REQUEST['filter']);
parseSort();
if ($user['MonitorIds']) {
$midSql = " and MonitorId in (" . join(",", preg_split('/["\'\\s]*,["\'\\s]*/', $user['MonitorIds'])) . ")";
} else {
$midSql = '';
}
$sql = "select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where {$sortColumn} " . ($sortOrder == 'asc' ? '<=' : '>=') . " '" . $event[$_REQUEST['sort_field']] . "'" . $_REQUEST['filter']['sql'] . $midSql . " order by {$sortColumn} " . ($sortOrder == 'asc' ? 'desc' : 'asc');
$result = dbQuery($sql);
while ($id = dbFetchNext($result, 'Id')) {
if ($id == $eventId) {
$prevEvent = dbFetchNext($result);
break;
}
}
$sql = "select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where {$sortColumn} " . ($sortOrder == 'asc' ? '>=' : '<=') . " '" . $event[$_REQUEST['sort_field']] . "'" . $_REQUEST['filter']['sql'] . $midSql . " order by {$sortColumn} {$sortOrder}";
$result = dbQuery($sql);
while ($id = dbFetchNext($result, 'Id')) {
if ($id == $eventId) {
$nextEvent = dbFetchNext($result);
break;
}
}
$result = array('EventId' => $eventId);
$result['PrevEventId'] = empty($prevEvent) ? 0 : $prevEvent['Id'];
$result['NextEventId'] = empty($nextEvent) ? 0 : $nextEvent['Id'];
$result['PrevEventDefVideoPath'] = empty($prevEvent) ? 0 : getEventDefaultVideoPath($prevEvent);
$result['NextEventDefVideoPath'] = empty($nextEvent) ? 0 : getEventDefaultVideoPath($nextEvent);
return $result;
}
$sql = "select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where {$sortColumn} <= ?" . $_REQUEST['filter']['sql'] . $midSql . " order by {$sortColumn} desc";
} else {
$sql = "select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where {$sortColumn} >= ?" . $_REQUEST['filter']['sql'] . $midSql . " order by {$sortColumn} asc";
}
$result = dbQuery($sql, array($event[$_REQUEST['sort_field']]));
while ($row = dbFetchNext($result)) {
if ($row['Id'] == $_REQUEST['eid']) {
$prevEvent = dbFetchNext($result);
break;
}
}
$sql = "select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where {$sortColumn} " . ($sortOrder == 'asc' ? '>=' : '<=') . ' ?' . $_REQUEST['filter']['sql'] . $midSql . " order by {$sortColumn} {$sortOrder}";
$result = dbQuery($sql, array($event[$_REQUEST['sort_field']]));
while ($row = dbFetchNext($result)) {
if ($row['Id'] == $_REQUEST['eid']) {
$nextEvent = dbFetchNext($result);
break;
}
}
$framesPerPage = 15;
$framesPerLine = 3;
$maxShortcuts = 3;
$paged = $event['Frames'] > $framesPerPage;
if ($paged && !empty($_REQUEST['page'])) {
$loFrameId = ($_REQUEST['page'] - 1) * $framesPerPage + 1;
$hiFrameId = min($_REQUEST['page'] * $framesPerPage, $event['Frames']);
} else {
$loFrameId = 1;
$hiFrameId = $event['Frames'];
}
$sql = 'SELECT * FROM Frames WHERE EventID = ?';
$currFrameSlots[$i] = array("count" => 1, "value" => $event['MaxScore'], "event" => $event, "frame" => $frame);
} else {
$currFrameSlots[$i]['count']++;
if ($event['MaxScore'] > $currFrameSlots[$i]['value']) {
$currFrameSlots[$i]['value'] = $event['MaxScore'];
$currFrameSlots[$i]['event'] = $event;
$currFrameSlots[$i]['frame'] = $frame;
}
}
if ($event['MaxScore'] > $chart['data']['y']['hi']) {
$chart['data']['y']['hi'] = $event['MaxScore'];
}
} else {
$framesSql = "select FrameId,Delta,unix_timestamp(TimeStamp) as TimeT,Score from Frames where EventId = ? and Score > 0";
$result = dbQuery($framesSql, array($event['Id']));
while ($frame = dbFetchNext($result)) {
if ($frame['Score'] == 0) {
continue;
}
$frameTimeT = $frame['TimeT'];
$frameTimeT = $startTimeT + $frame['Delta'];
$frameIndex = (int) (($frameTimeT - $chart['data']['x']['lo']) / $chart['data']['x']['density']);
if ($frameIndex < 0) {
continue;
}
if ($frameIndex >= $chart['graph']['width']) {
continue;
}
if (!isset($currFrameSlots[$frameIndex])) {
$currFrameSlots[$frameIndex] = array("count" => 1, "value" => $frame['Score'], "event" => $event, "frame" => $frame);
} else {
function loadConfig($defineConsts = true)
{
global $config;
global $configCats;
global $dbConn;
$config = array();
$configCat = array();
$result = $dbConn->query('select * from Config order by Id asc');
if (!$result) {
echo mysql_error();
}
$monitors = array();
while ($row = dbFetchNext($result)) {
if ($defineConsts) {
define($row['Name'], $row['Value']);
}
$config[$row['Name']] = $row;
if (!($configCat =& $configCats[$row['Category']])) {
$configCats[$row['Category']] = array();
$configCat =& $configCats[$row['Category']];
}
$configCat[$row['Name']] = $row;
}
//print_r( $config );
//print_r( $configCats );
}
