$resp = array();
$req = $app->request();
$sql = "SELECT id, datetime, count(*) as breeds FROM logs GROUP BY ip ";
$sql .= "ORDER BY datetime ASC";
$sessions = Database::queryToArray($sql);
echo json_encode($sessions);
});
/** get the complete logged breeding session which contains the sent id
* do it like this to avoid revealing IP addresses for privacy innit
*/
$app->get("/sessions/:id", function ($id) use($app) {
$resp = array();
$req = $app->request();
// first retrieve the required session so we can
// find the ip address
$id = Database::sanitise($id);
$sql = "SELECT id, ip FROM Logs where id='{$id}'";
$sessions = Database::queryToArray($sql);
if (sizeof($sessions) == 0) {
// invalid id
$resp["error"] = "invalid id";
echo json_encode($resp);
} else {
// valid id
$session = $sessions[0];
$ip = $session["ip"];
// get the rest of the logs for this session
$sql = "SELECT id, datetime, breeders from Logs where ip='{$ip}' ORDER BY datetime ASC";
$sessions = Database::queryToArray($sql);
$new_sess = array();
foreach ($sessions as $session) {
