$totalfiles->free();
$last24bytes->free();
// report_select.tpl & last_run_report.tpl
$res = $dbSql->link->query("select Name from Job group by Name");
$a_jobs = array();
while ( $tmp = $res->fetchRow() )
array_push($a_jobs, $tmp[0]);
$smarty->assign('total_name_jobs',$a_jobs);
$smarty->assign('time2',( (time())-2678400) ); // Current time - 1 month. <select> date
$res->free();
// volumes.tpl
$volumes = $dbSql->GetDataVolumes(); // Obtain array with info
$pools = array_keys($volumes); // Extract Pools
$smarty->assign('pools',$pools);
$smarty->assign('volumes',$volumes);
// last_run_report.tpl
if ($mode == "Lite" && $_GET['Full_popup'] != "yes") {
$tmp = array();
if ( $dbSql->driver == "mysql" )
$status = $dbSql->link->query("select JobId,Name,EndTime,JobStatus from Job where EndTime <= NOW() and UNIX_TIMESTAMP(EndTime) >UNIX_TIMESTAMP(NOW())-86400 and JobStatus!='T'" )
or die ("Error: query at row 95");
if ( $dbSql->driver == "pgsql" )
$status = $dbSql->link->query("select JobId,Name,EndTime,JobStatus from Job where EndTime <= NOW() and EndTime >NOW() - 86400 * interval '1 second' and JobStatus!= 'T'")
or die ( "Error: query at row 98" );
$smarty->assign('status', $status->numRows());
if ( $status->numRows() ) {
