path . '/' . $selectedphoto->basename;
$ogimagewidth = $selectedphoto->width;
$ogimageheight = $selectedphoto->height;
}
$timeranges = getTimerange();
require('layout/header.php');
$sql = "select location, count(*) as c from " . TABLEPREFIX . "photos group by location order by c desc";
$locations = R::getAll($sql);
$sql = "select credit, count(*) as c from " . TABLEPREFIX . "photos group by credit order by c desc";
$credits = R::getAll($sql);
$sql = "select count(*) as c, ";
$sql .= ' CASE ';
$sql .= " WHEN (taketime = '' OR taketime is null OR taketime = '0000-00-00 00:00:00' ) THEN 0 ";
foreach ($timeranges as $timerangekey=>$timerange)
{
$sql .= " WHEN taketime >= '" . $timerange['start'] . "' AND taketime < '" . $timerange['end'] . "' THEN '" . $timerangekey . "' ";
}
$sql .= ' END AS `timerange` ';
$sql .= ' from ' . TABLEPREFIX . 'photos group by timerange order by c desc';
//d($sql);
$timerangescountrs = R::getAll($sql);
foreach ($timerangescountrs as $temp)
{
$timerangescount[$temp['timerange']] = $temp['c'];
}
//d($timerangescount);
$location_select = $_REQUEST['locationbuttons'];
$timerange_select = $_REQUEST['timerangbuttons'];
$credit_select = $_REQUEST['creditbuttons'];
?>