// generaldata.tpl & last_run_report.tpl (last24bytes)
$client = $dbSql->link->query("select count(*) from Client")
or die ("Error query: 1");
$totalfiles = $dbSql->link->query("select count(FilenameId) from Filename")
or die ("Error query: 2");
if ( $dbSql->driver == "mysql")
$last24bytes = $dbSql->link->query("select sum(JobBytes),count(*) from Job where Endtime <= NOW() and UNIX_TIMESTAMP(EndTime) > UNIX_TIMESTAMP(NOW())-86400")
or die ("Error query: 3");
if ( $dbSql->driver == "pgsql")
$last24bytes = $dbSql->link->query("select sum(JobBytes),count(*) from Job where Endtime <= NOW() and EndTime > NOW() - 86400 * interval '1 second'")
or die ("Error query: 3");
$bytes_stored =& $dbSql->link->getOne("select SUM(VolBytes) from Media")
or die ("Error query: 4");
$smarty->assign('database_size', $dbSql->GetDbSize());
$smarty->assign('bytes_stored',$bytes_stored);
$tmp = $client->fetchRow();
$smarty->assign('clientes_totales',$tmp[0]);
$tmp = $last24bytes->fetchRow();
/*if ( empty($tmp[0]) ) { // No data for last 24, search last 48
if ( $dbSql->driver == "mysql" )
$last24bytes = $dbSql->link->query("select sum(JobBytes) from Job where Endtime <= NOW() and UNIX_TIMESTAMP(EndTime) > UNIX_TIMESTAMP(NOW())-172800" );
if ( $dbSql->driver == "pgsql")
$last24bytes = $dbSql->link->query("select sum(JobBytes) from Job where Endtime <= NOW() and EndTime > NOW()-172800 * interval '1 second'" )
or die ("Error query: 4.1");
$smarty->assign('when',"yesterday");
$tmp = $last24bytes->fetchRow();
}*/
