function create_maps_meta()
{
$sql = "CREATE TABLE IF NOT EXISTS ".map_bank_meta_table()." (
`meta_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`map_id` int(10) NOT NULL,
`map_meta_key` varchar(255) NOT NULL,
`map_meta_value` longtext NOT NULL,
PRIMARY KEY (`meta_id`)
) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
dbDelta($sql);
}
<?php
global $wpdb;
$unique_id = rand(100, 10000);
$frontend_map = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . map_bank_meta_table() . " INNER JOIN " . map_bank_create_new_map_table() . " ON " . map_bank_create_new_map_table() . ".id = " . map_bank_meta_table() . ".map_id WHERE " . map_bank_create_new_map_table() . ".id = %d or " . map_bank_create_new_map_table() . ".parent_id = %d", $map_id, $map_id));
if (!function_exists("get_frontend_map_settings")) {
function get_frontend_map_settings($id, $map_settings, $map_type)
{
$map_settings_array = array();
foreach ($map_settings as $row) {
if ($row->map_id == $id) {
$map_settings_array["{$row->map_meta_key}"] = $row->map_meta_value;
if ($map_type != "map") {
$map_settings_array["id"] = $row->id;
}
}
}
return $map_settings_array;
}
}
if (!function_exists("get_frontend_geo_settings")) {
function get_frontend_geo_settings($id, $map_settings, $match)
{
$map_marker_array = array();
foreach ($map_settings as $row) {
if ($row->parent_id == $id && $row->map_type == $match) {
$marker = get_frontend_map_settings($row->id, $map_settings, $match);
array_push($map_marker_array, $marker);
}
}
return array_unique($map_marker_array, SORT_REGULAR);
function form($instance)
{
global $wpdb;
$unique_id = rand(100, 10000);
$instance = wp_parse_args((array)$instance, array("title" => "","map_id" => "0","mapWidth" => "200","mapHeight" => "300",
"zoomlevel" => "7", "mapscrollwheel" => TRUE,"mapborder" => TRUE,"mappx" => "px", "mapborderwidth" =>"2","mappx_h" => "px", "mapborderstyle" => "1",
"mapborderradius" =>"1", "mapbordercolor" => "#000000", "show_title"=> TRUE));
$title = $instance["title"];
$maps = $wpdb->get_results
(
$wpdb->prepare
(
"SELECT * FROM " . map_bank_meta_table(). " INNER JOIN ".map_bank_create_new_map_table().
" ON ".map_bank_create_new_map_table().".id = ".map_bank_meta_table().".map_id WHERE ".map_bank_create_new_map_table().
".parent_id = %d and " . map_bank_create_new_map_table() . ".map_type=%s and ".map_bank_meta_table().".map_meta_key=%s ORDER BY " .map_bank_create_new_map_table().".id DESC " ,
0,
"map",
"map_title"
)
);
?>
<p>
<label for="<?php echo $this->get_field_id("title"); ?>"><?php _e("Title", map_bank); ?>:</label> <input
class="widefat" id="<?php echo $this->get_field_id("title"); ?>"
name="<?php echo $this->get_field_name("title"); ?>" type="text"
value="<?php echo esc_attr($title); ?>"/>
</p>
<p>
<label for="<?php echo $this->get_field_id("map_id"); ?>"><?php _e("Select Map", map_bank); ?> : </label>
<select size="1" name="<?php echo $this->get_field_name("map_id"); ?>"
id="<?php echo $this->get_field_id("map_id"); ?>" class="widefat">
<option value="0"><?php _e("Select a Map", map_bank); ?> </option>
<?php
if ($maps) {
foreach ($maps as $map)
{
echo "<option value=\"" . $map->id . "\"";
if ($map->id == $instance["map_id"]) echo "selected=\"selected\"";
echo ">" . stripslashes(html_entity_decode($map->map_meta_value)) . "</option>" . "\n\t";
}
}
?>
</select>
</p>
<p>
<label><?php _e("Width", map_bank); ?>:</label>
<br>
<input type="text" size="5" name="<?php echo $this->get_field_name("mapWidth"); ?>" id="<?php echo $this->get_field_id("mapWidth"); ?>"
value="<?php echo intval($instance["mapWidth"]);?>" class="widefat" />
</p>
<p>
<label><?php _e("Height", map_bank); ?>:</label><br>
<input type="text" size="5" name="<?php echo $this->get_field_name("mapHeight"); ?>" id="<?php echo $this->get_field_id("mapHeight"); ?>"
value="<?php echo intval($instance["mapHeight"]);?>" class="widefat" />
</p>
<p>
<label for="<?php echo $this->get_field_id("zoomlevel"); ?>"><?php _e("Zoom Level", map_bank); ?>
:</label>
<select name="<?php echo $this->get_field_name("zoomlevel"); ?>"
id="<?php echo $this->get_field_id("zoomlevel"); ?>" class="widefat">
<?php
for($flag = 1;$flag <=20;$flag++)
{
?>
<option value="<?php echo $flag;?>" <?php echo $flag == 12 ? "selected=\"selected\"" : ""; ?>><?php echo $flag . "";?></option>
<?php
}
?>
</select>
</p>
<p>
<label for="<?php echo $this->get_field_id("mapscrollwheel"); ?>"><?php _e("Scrolling Wheel", map_bank); ?>
:</label>
<input type="checkbox" class="widefat" name="<?php echo $this->get_field_name("mapscrollwheel"); ?>"
id="<?php echo $this->get_field_id("mapscrollwheel"); ?>" value="1" <?php checked(TRUE, $instance["mapscrollwheel"]); ?>/>
</p>
<p>
<label style="padding-right: 20px;" for="<?php echo $this->get_field_id("mapborder"); ?>"><?php _e("Map Border", map_bank); ?>
:</label>
<input type="checkbox" disabled="disabled" onclick="show_map_settings<?php echo $unique_id;?>();" class="widefat" name="<?php echo $this->get_field_name("mapborder"); ?>"
id="<?php echo $this->get_field_id("mapborder"); ?>" value="1" <?php checked(TRUE, $instance["mapborder"]); ?>/></br>
<i class="widget_premium_feature"><?php _e(" (Available in Premium Editions)", map_bank); ?></i>
</p>
<div id="div_map_settings<?php echo $unique_id;?>" style="display: none;">
<p>
<label for="<?php echo $this->get_field_id("mapborderwidth"); ?>"><?php _e("Map Border Width", map_bank); ?>
:</label>
<select disabled="disabled" name="<?php echo $this->get_field_name("mapborderwidth"); ?>"
id="<?php echo $this->get_field_id("mapborderwidth"); ?>" class="widefat">
<?php
for($flag = 1;$flag <=20;$flag++)
{
?>
<option value="<?php echo $flag;?>"><?php echo $flag. " px";?> <i class="widget_premium_feature"><?php _e(" (Available in Premium Editions)", map_bank); ?></i></option>
<?php
}
?>
</select>
</p>
<p>
<label for="<?php echo $this->get_field_id("mapborderstyle"); ?>"><?php _e("Map Border Style", map_bank); ?>
:</label>
<select disabled="disabled" name="<?php echo $this->get_field_name("mapborderstyle"); ?>"
id="<?php echo $this->get_field_id("mapborderstyle"); ?>" class="widefat">
<option value="Solid"><?php _e("Solid", map_bank); ?><i class="widget_premium_feature"><?php _e(" (Available in Premium Editions)", map_bank); ?></i></option>
<option value="Dotted"><?php _e("Dotted", map_bank); ?><i class="widget_premium_feature"><?php _e(" (Available in Premium Editions)", map_bank); ?></i></option>
<option value="Dashed"><?php _e("Dashed", map_bank); ?><i class="widget_premium_feature"><?php _e(" (Available in Premium Editions)", map_bank); ?></i></option>
</select>
</p>
<p>
<label for="<?php echo $this->get_field_id("mapbordercolor"); ?>"><?php _e("Map Border Color", map_bank); ?>
:</label>
<input disabled="disabled" type="text" size="5" name="<?php echo $this->get_field_name("mapbordercolor"); ?>" id="<?php echo $this->get_field_id("mapbordercolor"); ?>"
value="<?php echo esc_attr($instance["mapbordercolor"]);?><?php _e(" (Available in Premium Editions)", map_bank); ?>" class="widefat" />
</p>
<p>
<label for="<?php echo $this->get_field_id("mapborderradius"); ?>"><?php _e("Map Border Radius", map_bank); ?>
:</label>
<select disabled="disabled" name="<?php echo $this->get_field_name("mapborderradius"); ?>"
id="<?php echo $this->get_field_id("mapborderradius"); ?>" class="widefat">
<?php
for($flag = 1;$flag <=20;$flag++)
{
?>
<option value="<?php echo $flag;?>"><?php echo $flag. " px";?><i class="widget_premium_feature"><?php _e(" (Available in Premium Editions)", map_bank); ?></i></option>
<?php
}
?>
</select>
</p>
</div>
<p>
<label style="padding-right: 27px;" for="<?php echo $this->get_field_id("show_title"); ?>"><?php _e("Show_Title", map_bank); ?>
:</label>
<input type="checkbox" class="widefat" name="<?php echo $this->get_field_name("show_title"); ?>"
id="<?php echo $this->get_field_id("show_title"); ?>" value="1" <?php checked(TRUE, $instance["show_title"]); ?>/>
</p>
<script type="text/javascript">
jQuery(document).ready(function () {
jQuery("#<?php echo $this->get_field_id("zoomlevel"); ?>").val("<?php echo $instance["zoomlevel"]; ?>");
jQuery("#<?php echo $this->get_field_id("mapborderwidth"); ?>").val("<?php echo $instance["mapborderwidth"]; ?>");
jQuery("#<?php echo $this->get_field_id("mapborderstyle"); ?>").val("<?php echo $instance["mapborderstyle"]; ?>");
jQuery("#<?php echo $this->get_field_id("mapborderradius"); ?>").val("<?php echo $instance["mapborderradius"]; ?>");
jQuery("#<?php echo $this->get_field_id("mappx"); ?>").val("<?php echo $instance["mappx"]; ?>");
show_map_settings<?php echo $unique_id;?>();
});
function show_map_settings<?php echo $unique_id;?>()
{
var mapBorder = jQuery("#<?php echo $this->get_field_id("mapborder");?>").prop("checked");
if(mapBorder == true)
{
jQuery("#div_map_settings<?php echo $unique_id;?>").css("display","block");
}
else
{
jQuery("#div_map_settings<?php echo $unique_id;?>").css("display","none");
}
}
</script>
<?php
}
} else {
switch ($gmb_role) {
case "administrator":
$user_role_permission = "manage_options";
break;
case "editor":
$user_role_permission = "publish_pages";
break;
case "author":
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission)) {
return;
} else {
$map_details = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . map_bank_meta_table() . " INNER JOIN " . map_bank_create_new_map_table() . " ON " . map_bank_create_new_map_table() . ".id = " . map_bank_meta_table() . ".map_id WHERE " . map_bank_create_new_map_table() . ".parent_id = %d and " . map_bank_create_new_map_table() . ".map_type=%s and " . map_bank_meta_table() . ".map_meta_key=%s ORDER BY " . map_bank_create_new_map_table() . ".id DESC ", 0, "map", "map_title"));
?>
<div id="map-bank" style="display:none;">
<div class="fluid-layout responsive">
<div style="padding:0px 0 3px 10px;">
<h3 class="label-shortcode"><?php
_e("Insert Google Map Bank Shortcode", map_bank);
?>
</h3>
<span>
<i><?php
_e("Select a map below to add it to your post or page.", map_bank);
?>
</i>
</span>
</div>
<?php
global $wpdb;
$unique_id = rand(100, 10000);
$frontend_map = $wpdb->get_results
(
$wpdb->prepare
(
"SELECT * FROM " . map_bank_meta_table(). " INNER JOIN ".map_bank_create_new_map_table().
" ON ".map_bank_create_new_map_table().".id = ".map_bank_meta_table().".map_id WHERE ".map_bank_create_new_map_table().
".id = %d or ".map_bank_create_new_map_table().".parent_id = %d",
$map_id,
$map_id
)
);
if(!function_exists("get_frontend_map_settings"))
{
function get_frontend_map_settings($id,$map_settings,$map_type)
{
$map_settings_array = array();
foreach ($map_settings as $row)
{
if ($row->map_id == $id)
{
$map_settings_array["$row->map_meta_key"] = $row->map_meta_value;
if($map_type != "map")
{
$map_settings_array["id"] = $row->id;
}
}
}
return $map_settings_array;
$meta_map_key["map_id"] = intval($_REQUEST["map_id"]);
$meta_map_key["map_meta_key"] = $key;
$meta_map_value["map_meta_value"] = $val;
$insert->update_data(map_bank_meta_table(), $meta_map_value, $meta_map_key);
}
die;
}
break;
case "single_map_delete":
if (wp_verify_nonce($_REQUEST["_wpnonce"], "one_map_delete")) {
$wpdb->query($wpdb->prepare("DELETE FROM " . map_bank_meta_table() . " WHERE map_id IN (SELECT id FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d)", intval($_REQUEST["map_id"])));
$wpdb->query($wpdb->prepare("DELETE FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d)", intval($_REQUEST["map_id"])));
$delete_single_map = new save_data();
$where = array();
$where["map_id"] = intval($_REQUEST["map_id"]);
$delete_single_map->delete_data(map_bank_meta_table(), $where);
$where = array();
$where["parent_id"] = intval($_REQUEST["map_id"]);
$delete_single_map->delete_data(map_bank_create_new_map_table(), $where);
$where = array();
$where["id"] = intval($_REQUEST["map_id"]);
$delete_single_map->delete_data(map_bank_create_new_map_table(), $where);
die;
}
break;
case "google_map_plugin_updates":
if (wp_verify_nonce($_REQUEST["_wpnonce"], "update_plugin_nonce")) {
$plugin_update = esc_attr($_REQUEST["google_map_updates"]);
update_option("google-maps-bank-automatic-update", $plugin_update);
die;
}
$user_role_permission = "manage_options";
break;
case "editor":
$user_role_permission = "publish_pages";
break;
case "author":
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission)) {
return;
} else {
if (isset($_REQUEST["map_id"])) {
$map_id = intval($_REQUEST["map_id"]);
}
$map_settings = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . map_bank_meta_table() . " INNER JOIN " . map_bank_create_new_map_table() . " ON " . map_bank_create_new_map_table() . ".id = " . map_bank_meta_table() . ".map_id WHERE " . map_bank_create_new_map_table() . ".id = %d or " . map_bank_create_new_map_table() . ".parent_id = %d ORDER BY " . map_bank_create_new_map_table() . ".id DESC ", $map_id, $map_id));
if (!function_exists("get_map_settings")) {
function get_map_settings($id, $map_settings, $map_type)
{
$map_settings_array = array();
foreach ($map_settings as $row) {
if ($row->map_id == $id) {
$map_settings_array["{$row->map_meta_key}"] = $row->map_meta_value;
$map_settings_array["creation_date"] = $row->creation_date;
if ($map_type != "map") {
$map_settings_array["id"] = $row->id;
}
}
}
return $map_settings_array;
}
$user_role_permission = "publish_pages";
break;
case "author":
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission)) {
return;
} else {
$marker_one_delete = wp_create_nonce("marker_delete");
$bulk_marker_delete = wp_create_nonce("marker_delete_bulk");
$polygon_one_delete = wp_create_nonce("polygon_delete");
$bulk_polygon_delete = wp_create_nonce("polygon_delete_bulk");
$polyline_one_delete = wp_create_nonce("polyline_delete");
$bulk_polyline_delete = wp_create_nonce("polyline_delete_bulk");
$map_data_details = $wpdb->get_results($wpdb->prepare("SELECT " . map_bank_meta_table() . ".map_meta_value," . map_bank_create_new_map_table() . ".id FROM " . map_bank_meta_table() . " INNER JOIN " . map_bank_create_new_map_table() . " ON " . map_bank_create_new_map_table() . ".id = " . map_bank_meta_table() . ".map_id WHERE " . map_bank_create_new_map_table() . ".map_type = %s AND " . map_bank_meta_table() . ".map_meta_key = %s ORDER BY " . map_bank_create_new_map_table() . ".id DESC ", "map", "map_title"));
if (isset($_REQUEST["map_id"])) {
if (file_exists(MAP_BK_PLUGIN_DIR . "/lib/get-map-settings.php")) {
include_once MAP_BK_PLUGIN_DIR . "/lib/get-map-settings.php";
}
$map_marker_count = $wpdb->get_var($wpdb->prepare("SELECT count(id) FROM " . map_bank_create_new_map_table() . " where parent_id = %d AND map_type = %s ", $map_id, "marker"));
$map_polygon_count = $wpdb->get_var($wpdb->prepare("SELECT count(id) FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d AND map_type = %s ", $map_id, "polygon"));
$map_polylines_count = $wpdb->get_var($wpdb->prepare("SELECT count(id) FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d AND map_type = %s ", $map_id, "polyline"));
}
?>
<form id="frm_manage_map" name="frm_manage_map" class="layout-form" style="width:1000px;">
<div class="fluid-layout">
<div class="layout-span12 responsive">
<div class="widget-layout">
<div class="widget-layout-title">
<h4><?php
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission))
{
return;
}
else
{
$map_details = $wpdb->get_results
(
$wpdb->prepare
(
"SELECT * FROM " . map_bank_meta_table(). " INNER JOIN ".map_bank_create_new_map_table().
" ON ".map_bank_create_new_map_table().".id = ".map_bank_meta_table().".map_id WHERE ".map_bank_create_new_map_table().
".parent_id = %d and " . map_bank_create_new_map_table() . ".map_type=%s and ".map_bank_meta_table().".map_meta_key=%s ORDER BY " .map_bank_create_new_map_table().".id DESC ",
0,
"map",
"map_title"
)
);
?>
<div id="map-bank" style="display:none;">
<div class="fluid-layout responsive">
<div style="padding:0px 0 3px 10px;">
<h3 class="label-shortcode"><?php _e("Insert Google Map Bank Shortcode", map_bank); ?></h3>
<span>
<i><?php _e("Select a map below to add it to your post or page.", map_bank); ?></i>
</span>
</div>
<div class="layout-span12 responsive" style="padding:15px 15px 0 0;">
