<?php
try
{ 
  require_once("config.php");

  $toilets = array();

  if (@$user_info["is_admin"]) {
    $sql = "select toilets.*, concat(images.id, '.', images.type) as image  from toilets left join images on images.toiletId = toilets.id and images.`index` = 0 where toilets.status <= 3 group by toilets.id order by dateUpdated desc limit 12";
  }
  else {
    $sql = "select toilets.*, concat(images.id, '.', images.type) as image  from toilets left join images on images.toiletId = toilets.id and images.`index` = 0 where toilets.status = 0 group by toilets.id order by dateUpdated desc limit 12";
  }
  $stmt = $pdo->query($sql);
  while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
  {
    $toilet = $row;
    $dateChecked = new DateTime($toilet["dateChecked"]);
    $toilet["dateChecked"] = $dateChecked->format("Y/m/d");
    $toilets[] = $toilet;
  }

  $smarty->assign("toilets", $toilets);
  $smarty->display("index.html");
}
catch (Exception $e)
{
  $code = $e->getCode();
  $message = $e->getMessage();
  header("HTTP/1.1 ".$code." ".$message);
  echo $message;
}
?>