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 ); }