$stmt->execute();
$stmt->bind_result($id, $name, $latitude, $longitude);
while ($stmt->fetch()) {
$search_results[] = array($id, $name, $latitude, $longitude);
}
$stmt->close();
}
echo json_encode($search_results);
break;
case 'GetPlaces':
if (!isset($_COOKIE['session'])) {
die("Your session has expired due to inactivity.\n\nPlease reload the page.");
} else {
$key = $_COOKIE['session'];
if (IsValidKey($key)) {
RemoveKey($key);
$key = InsertKey();
setcookie('session', $key, time() + KEY_TIMEOUT, '/', '', false, true);
} else {
setcookie('session', $key, time() - 86400, '/', '', false, true);
die("Your session has expired due to inactivity.\n\nPlease reload the page.");
}
}
RemoveExpiredKeys();
$value = json_decode($_GET['value']);
$category_controller = new CategoryController($value->categories);
$centre_latitude = $value->position[0];
$centre_longitude = $value->position[1];
$sql = <<<SQL
t\t\tSELECT
t\t\t\t*
define('KEY_TIMEOUT', 60 * 60);
// 60 minutes
$key = InsertKey();
setcookie('master', $key, time() + KEY_TIMEOUT, '/', '', false, true);
} else {
$editable = false;
define('KEY_TIMEOUT', 5 * 60);
// 5 minutes
if (isset($_COOKIE['master'])) {
setcookie('master', $_COOKIE['master'], time() - 86400, '/', '', false, true);
}
}
include 'access.php';
InsertAccess();
if (isset($_COOKIE['session'])) {
RemoveKey($_COOKIE['session']);
}
RemoveExpiredKeys();
$key = InsertKey();
setcookie('session', $key, time() + KEY_TIMEOUT, '/', '', false, true);
?>
<!DOCTYPE html>
<html>
<head>
<script>
map_min_zoom=<?php
echo $editable ? 5 : 11;
?>
;
place_limit=<?php
echo $editable ? -1 : 30;
