public function getLastMapCoord($user)
{
$data = array();
$data[] = $this->conn->cleanData($user->getId());
$query = <<<SQL
\t\t\t\tSELECT
\t\t\t\t\tlatitude,
\t\t\t\t\tlongitude,
\t\t\t\t\taltitude,
\t\t\t\t\ttime
\t\t\t\t\tFROM
\t\t\t\t\t\tlaa_coordinate
\t\t\t\t\tWHERE
\t\t\t\t\t\tid_user = {$data['0']}
\t\t\t\t\tORDER BY
\t\t\t\t\t\tid DESC
\t\t\t\t\tLIMIT 1
SQL;
$query = $this->conn->removeBreakLine($query);
$result = $this->conn->getConn()->query($query);
$map = NULL;
while ($data = $result->fetch_object()) {
$map = new Map();
$map->setId($data->id);
$map->setLatitude($data->latitude);
$map->setLongitude($data->longitude);
$map->setAltitude($data->altitude);
break;
}
$result->free();
return $map;
}
public function selectAll()
{
$all = array();
if ($this->conn) {
$query = "SELECT * FROM maps";
$res = mysql_query($query, $this->conn);
if ($res) {
while ($row = mysql_fetch_assoc($res)) {
$m = new Map();
$m->setId((int) $row['id']);
$m->setName($row['name']);
$m->setTiles($row['tiles']);
array_push($all, $m);
}
}
}
return $all;
}
public function addMap($title)
{
$map = new Map($this->addSubElement("map"));
$map->setId($this->getId() . "_map_" . $this->getNewMapId());
$map->setTitle($title);
$this->saveDOM();
return $map;
}
