function dbem_global_map_json($eventful = false)
{
$json = '{"locations":[';
$locations = dbem_get_locations($eventful);
$json_locations = array();
foreach ($locations as $location) {
$json_location = array();
foreach ($location as $key => $value) {
$json_location[] = '"' . $key . '":"' . $value . '"';
}
$json_location[] = '"location_baloon":"' . dbem_replace_locations_placeholders(get_option('dbem_location_baloon_format'), $location) . '"';
$json_locations[] = "{" . implode(",", $json_location) . "}";
}
$json .= implode(",", $json_locations);
$json .= "]}";
echo $json;
}
function dbem_locations_page()
{
if (isset($_GET['action']) && $_GET['action'] == "edit") {
// edit location
$location_id = $_GET['location_ID'];
$location = dbem_get_location($location_id);
dbem_locations_edit_layout($location);
} else {
if (isset($_POST['action']) && $_POST['action'] == "editedlocation") {
// location update required
$location = array();
$location['location_id'] = $_POST['location_ID'];
$location['location_name'] = $_POST['location_name'];
$location['location_address'] = $_POST['location_address'];
$location['location_town'] = $_POST['location_town'];
$location['location_latitude'] = $_POST['location_latitude'];
$location['location_longitude'] = $_POST['location_longitude'];
$location['location_description'] = $_POST['content'];
if (empty($location['location_latitude'])) {
$location['location_latitude'] = 0;
$location['location_longitude'] = 0;
}
$validation_result = dbem_validate_location($location);
if ($validation_result == "OK") {
dbem_update_location($location);
if ($_FILES['location_image']['size'] > 0) {
dbem_upload_location_picture($location);
}
$message = __('The location has been updated.', 'dbem');
$locations = dbem_get_locations();
dbem_locations_table_layout($locations, $message);
} else {
$message = $validation_result;
dbem_locations_edit_layout($location, $message);
}
} elseif (isset($_POST['action']) && $_POST['action'] == "addlocation") {
$location = array();
$location['location_name'] = $_POST['location_name'];
$location['location_address'] = $_POST['location_address'];
$location['location_town'] = $_POST['location_town'];
$location['location_latitude'] = $_POST['location_latitude'];
$location['location_longitude'] = $_POST['location_longitude'];
$location['location_description'] = $_POST['content'];
$validation_result = dbem_validate_location($location);
if ($validation_result == "OK") {
$new_location = dbem_insert_location($location);
// uploading the image
if ($_FILES['location_image']['size'] > 0) {
dbem_upload_location_picture($new_location);
}
// -------------
//RESETME $message = __('The location has been added.', 'dbem');
$locations = dbem_get_locations();
dbem_locations_table_layout($locations, null, $message);
} else {
$message = $validation_result;
$locations = dbem_get_locations();
dbem_locations_table_layout($locations, $location, $message);
}
} else {
// no action, just a locations list
$locations = dbem_get_locations();
dbem_locations_table_layout($locations, $message);
}
}
}
<?php
require_once '../../../wp-load.php';
$locations = dbem_get_locations();
$return = array();
foreach ($locations as $item) {
$record = array();
$record['id'] = $item['location_id'];
$record['name'] = $item['location_name'];
$record['address'] = $item['location_address'];
$record['town'] = $item['location_town'];
$return[] = $record;
}
$q = strtolower($_GET["q"]);
if (!$q) {
return;
}
foreach ($return as $row) {
if (strpos(strtolower($row['name']), $q) !== false) {
$location = array();
$rows = array();
foreach ($row as $key => $value) {
$location[] = "'{$key}' : '" . str_replace("'", "\\'", $value) . "'";
}
echo "{" . implode(" , ", $location) . " }\n";
}
}
<?php
# LOCATIONS LIST
$locations = dbem_get_locations(true);
?>
<table id="events-table">
<col id="col120" />
<col id="col190" />
<?php
$seenlocation_id = '';
$echoend = false;
foreach ($locations as $listing) {
if ($seenlocation_id != $listing['location_id']) {
?>
<tbody>
<tr><th colspan="2" class="text-left">
<h4 class="event-date">
<a href="<?php
get_bloginfo("siteurl");
?>
/events/?location_id=<?php
echo $listing['location_id'];
?>
">
<?php
echo $listing['location_name'];
?>
</a>
</h4></th>
<th class="text-right"><?php