";
return $wpgmza_tmp;
}
/**
* Retrieve polygon options from DB
*
* @param integer $poly_id Polygon ID
* @return array MYSQL Array
*/
function wpgmza_b_return_poly_options($poly_id) {
global $wpdb;
global $wpgmza_tblname_poly;
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpgmza_tblname_poly WHERE `id` = %d LIMIT 1",intval($poly_id)) );
foreach ( $results as $result ) {
return $result;
}
}
/**
* Return the polygon data in the correct format
*
* @param integer $poly_id Polygon ID
* @return array Poly data array
*/
function wpgmza_b_return_polygon_array($poly_id) {
global $wpdb;
global $wpgmza_tblname_poly;
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpgmza_tblname_poly WHERE `id` = %d LIMIT 1",intval($poly_id)) );
foreach ( $results as $result ) {
$current_polydata = $result->polydata;
$new_polydata = str_replace("),(","|",$current_polydata);
$new_polydata = str_replace("(","",$new_polydata);
$new_polydata = str_replace("),","",$new_polydata);
$new_polydata = explode("|",$new_polydata);
foreach ($new_polydata as $poly) {
$ret[] = $poly;
}
return $ret;
}
}
/**
* Return polygon ID array
*
* This is used when creating the JSON array of all the polygons and their unique options
*
* @param integer $map_id Map ID
* @return array Array of IDs
*/
function wpgmza_b_return_polygon_id_array($map_id) {
global $wpdb;
global $wpgmza_tblname_poly;
$ret = array();
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpgmza_tblname_poly WHERE `map_id` = %d",intval($map_id)) );
foreach ( $results as $result ) {
$current_id = $result->id;
$ret[] = $current_id;
}
return $ret;
}
![](".wpgmaps_get_plugin_url()."/images/marker.png)
"; }
foreach ( $results as $result ) {
unset($poly_data);
unset($poly_array);
$poly_data = '';
$poly_array = wpgmza_b_return_polygon_array($result->id);
foreach ($poly_array as $poly_single) {
$poly_data .= $poly_single.",";
}
if (isset($result->polyname) && $result->polyname != "") { $polygon_name = $result->polyname; } else { $polygon_name = "Polygon".$result->id; }
$wpgmza_tmp .= "