Exemple #1
0
function marker()
{
    if ((int) $_REQUEST['loc'] != 0) {
        $db = new db();
        $stmt = $db->connection->prepare("SELECT * FROM Buildings WHERE id = " . $_REQUEST['loc']);
        $stmt->execute();
        $data = $stmt->fetchAll();
        $lat = $data[0]['latitude'];
        $long = $data[0]['longitude'];
        $marker = marker_type($data[0]['type']);
        return $lat . "," . $long . "," . $marker;
    } else {
        if ($_REQUEST['all']) {
            $db = new db();
            $stmt = $db->connection->prepare("SELECT * FROM Buildings WHERE type = " . $_REQUEST['all']);
            $stmt->execute();
            $results = $stmt->fetchAll();
            $markers = "";
            foreach ($results as $result) {
                $lat = $data[0]['latitude'];
                $long = $data[0]['longitude'];
                $marker = marker_type($data[0]['type']);
                $markers .= $lat . "," . $long . "," . $marker . "|";
            }
            return $markers;
        }
    }
}
Exemple #2
0
function marker()
{
    global $mobile_web_addy, $theme;
    if ((int) $_REQUEST['loc'] != 0) {
        $places = MapAdapter::getPlace($_REQUEST['loc']);
        $place = $places[0];
        $lat = $place['latitude'];
        $long = $place['longitude'];
        $icon = "icon:http://" . $mobile_web_addy . "/map/templates/webkit/images/markers/" . $place['marker'] . ".png";
        return $icon . "|" . $lat . "," . $long;
    } else {
        if ($_REQUEST['all']) {
            // WTF does this do?
            $db = new db();
            $stmt =& $db->connection->prepare("SELECT * FROM Buildings WHERE type = " . $_REQUEST['all']);
            $result = $stmt->execute();
            $results = $result->fetchAll();
            $markers = "";
            foreach ($results as $result) {
                $lat = $data[0]['latitude'];
                $long = $data[0]['longitude'];
                $marker = marker_type($data[0]['type']);
                $markers .= $lat . "," . $long . "," . $marker . "|";
            }
            return $markers;
        }
    }
}