ZoneMinder Forums

Code: Select all

               $sql = "select E.*,M.Name as MonitorName,M.DefaultRate,M.DefaultScale from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.Id = ".dbEscape($_REQUEST['id']).monitorLimitSql();

Code: Select all

 
//
// PHP variables to JS
//
var connKey = '638597';
 
var event = {
    Id: 1841,
    Width: 320,
    Height: 240,
    Length: 1.00};
 
var filterQuery = '&filter[terms][0][attr]=Archived&filter[terms][0][op]=%3D&filter[terms][0][val]=0&filter[terms][1][cnj]=and&filter[terms][1][attr]=DateTime&filter[terms][1][op]=%3E%3D&filter[terms][1][val]=-1+hour&filter[terms][2][cnj]=and&filter[terms][2][attr]=MonitorId&filter[terms][2][op]=%3D&filter[terms][2][val]=1';
var sortQuery = '&sort_field=StartTime&sort_asc=1';
 
var scale = 100;
var canEditEvents = true;
var streamTimeout = 3000;
 
var canStreamNative = false;
 
//
// Strings
//
var deleteString = "Delete";
var causeString = "Cause";

Code: Select all

/* MAR - next line has a problem */
                //$sql = "select E.*,M.Name as MonitorName,M.DefaultRate,M.DefaultScale from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.Id = ".dbEscape($_REQUEST['id']).monitorLimitSql();
                $sql = "select E.*,M.Name as MonitorName,M.DefaultRate,M.DefaultScale from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.Id = ".dbEscape($_REQUEST['eid']).monitorLimitSql();
                if ( !($event = dbFetchOne( $sql )) )