function create_new_map_bank()
{
$sql = "CREATE TABLE IF NOT EXISTS " . map_bank_create_new_map_table()." (
`id` int(10) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL,
`map_type` varchar(100) NOT NULL,
`creation_date` DATE NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
dbDelta($sql);
}
function gmb_create_new_map()
{
global $wpdb, $current_user;
if (is_super_admin()) {
$gmb_role = "administrator";
} else {
$gmb_role = $wpdb->prefix . "capabilities";
$current_user->role = array_keys($current_user->{$gmb_role});
$gmb_role = $current_user->role[0];
}
$map_count = $wpdb->get_var($wpdb->prepare("SELECT count(id) FROM " . map_bank_create_new_map_table() . " where map_type=%s", "map"));
if (file_exists(MAP_BK_PLUGIN_DIR . "/includes/tabs.php")) {
include_once MAP_BK_PLUGIN_DIR . "/includes/tabs.php";
}
if ($map_count < 3) {
if (file_exists(MAP_BK_PLUGIN_DIR . "/views/create-map.php")) {
include_once MAP_BK_PLUGIN_DIR . "/views/create-map.php";
}
} else {
header("Location: " . admin_url() . "admin.php?page=gmb_dashboard");
}
}
<?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 widget($args, $instance)
{
global $wpdb,$showtitle;
$maps = $wpdb->get_var
(
$wpdb->prepare
(
"SELECT count(*) FROM " . map_bank_create_new_map_table() . " WHERE id = %d and map_type=%s",
$instance["map_id"],
"map"
)
);
extract($args, EXTR_SKIP);
echo $before_widget;
$title = empty($instance["title"]) ? " " : apply_filters("widget_title", $instance["title"]);
$showtitle = ($instance["show_title"] == 1)? "show_title = \"true\"" : "show_title = \"false\"";
$map_border = ($instance["mapborder"] == 1) ? "map_border = \"true\"" : "map_border = \"false\"";
$map_scrollwheel = ($instance["mapscrollwheel"] == 1) ? "scrolling_wheel = \"true\"" : "scrolling_wheel = \"false\"";
if ($maps > 0)
{
if ($instance["map_id"] != 0)
{
echo $before_title . $title . $after_title;
$shortcode_for_maps = "[map_bank map_id=\"" . $instance["map_id"] . "\" map_width=\"".$instance["mapWidth"]."\" map_width_type=\"".$instance["mappx"]."\"
map_height=\"".$instance["mapHeight"]."\" map_height_type=\"".$instance["mappx_h"]."\" map_zoom=\"".$instance["zoomlevel"]."\" ".$map_scrollwheel." ".$map_border."
border_width=\"".$instance["mapborderwidth"]."\" border_style=\"".$instance["mapborderstyle"]."\" border_color=\"".$instance["mapbordercolor"]."\" border_radius=\"".$instance["mapborderradius"]."\"
".$showtitle."]";
}
}
echo do_shortcode($shortcode_for_maps);
echo $after_widget;
}
} 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>
$user_role_permission = "publish_pages";
break;
case "author":
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission)) {
return;
} else {
$add_new_marker = wp_create_nonce("new_marker_add");
$update_marker = wp_create_nonce("marker_update");
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"));
}
?>
<form id="frm_edit_marker" class="layout-form" style="max-width:1000px;">
<div class="fluid-layout">
<div class="layout-span12 responsive">
<div class="widget-layout">
<div class="widget-layout-title">
<h4>
<?php
_e("Edit Marker", map_bank);
?>
</h4>
</div>
<div class="widget-layout-body">
<div class="fluid-layout">
</div>
<script>
jQuery(document).ready(function()
{
jQuery(".nav-tab-wrapper > a#<?php echo $_REQUEST["page"];?>").addClass("nav-tab-active");
});
</script>
<h2 class="nav-tab-wrapper" style="max-width: 1000px;">
<a style="display:none;" class="nav-tab" id="gmb_dashboard" href=""><?php _e("Dashboard", map_bank);?></a>
<a class="nav-tab" id="gmb_dashboard" href="admin.php?page=gmb_dashboard"><?php _e("Dashboard", map_bank);?></a>
<?php
$map_count = $wpdb->get_var
(
$wpdb->prepare
(
"SELECT count(id) FROM ".map_bank_create_new_map_table()." where map_type=%s",
"map"
)
);
if($map_count < 2)
{
?>
<a class="nav-tab" id="gmb_create_new_map" href="admin.php?page=gmb_create_new_map"><?php _e("Create Map", map_bank);?></a>
<?php
}
?>
<a class="nav-tab" id="manage_map" href="admin.php?page=manage_map"><?php _e("Manage Maps", map_bank);?></a>
<a class="nav-tab" id="short_code_map" href="admin.php?page=short_code_map"><?php _e("Short Codes", map_bank);?></a>
<a class="nav-tab" id="gmb_recommended_plugins" href="admin.php?page=gmb_recommended_plugins"><?php _e("Recommendations", map_bank);?></a>
<a class="nav-tab" id="gmb_pro_version" href="admin.php?page=gmb_pro_version"><?php _e("Premium Editions", map_bank);?></a>
<a class="nav-tab" id="gmb_other_services" href="admin.php?page=gmb_other_services"><?php _e("Our Other Services", map_bank);?></a>
break;
case "author":
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission)) {
return;
} else {
$add_new_polyline = wp_create_nonce("new_polyline_add");
$polyline_one_delete = wp_create_nonce("polyline_delete");
$bulk_polyline_delete = wp_create_nonce("polyline_delete_bulk");
if (file_exists(MAP_BK_PLUGIN_DIR . "/lib/get-map-settings.php")) {
include_once MAP_BK_PLUGIN_DIR . "/lib/get-map-settings.php";
}
$polyline_count = $wpdb->get_var($wpdb->prepare("SELECT count(parent_id) FROM " . map_bank_create_new_map_table() . " WHERE parent_id = %d AND map_type = %s ", $map_id, "polyline"));
$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_add_polyline" class="layout-form" style="max-width:1000px;">
<div class="fluid-layout">
<div class="layout-span12">
<?php
if (file_exists(MAP_BK_PLUGIN_DIR . "/includes/headers.php")) {
include_once MAP_BK_PLUGIN_DIR . "/includes/headers.php";
}
?>
<div class="widget-layout">
<div class="widget-layout-title">
<h4><?php
_e("Step 5 - Add Polyline", map_bank);
?>
</h4>
}
$polyline_count = $wpdb->get_var
(
$wpdb->prepare
(
"SELECT count(parent_id) FROM " .map_bank_create_new_map_table() . " WHERE parent_id = %d AND map_type = %s ",
$map_id,
"polyline"
)
);
$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_add_polyline" class="layout-form" style="max-width:1000px;">
<div class="fluid-layout">
<div class="layout-span12">
<?php
if(file_exists(MAP_BK_PLUGIN_DIR ."/includes/headers.php"))
{
include_once MAP_BK_PLUGIN_DIR ."/includes/headers.php";
}
?>
<div class="widget-layout">
<?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;
<?php
/////////////////////////////////// Map Bank Menus Icons /////////////////////////////////////////////////////
if (!is_user_logged_in()) {
return;
} else {
$wp_admin_bar->add_menu(array("id" => "map_bank_links", "title" => "<span class=\"color_map\">Google Maps</span>", "href" => site_url() . "/wp-admin/admin.php?page=gmb_dashboard"));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gmb_dashboard", "title" => __("Dashboard", map_bank)));
$map_count = $wpdb->get_var($wpdb->prepare("SELECT count(id) FROM " . map_bank_create_new_map_table() . " where map_type=%s", "map"));
if ($map_count < 2) {
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "create_new_map_links", "href" => site_url() . "/wp-admin/admin.php?page=gmb_create_new_map", "title" => __("Create New Map", map_bank)));
}
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "manage_map_links", "href" => site_url() . "/wp-admin/admin.php?page=manage_map", "title" => __("Manage Maps", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_short_code_links", "href" => site_url() . "/wp-admin/admin.php?page=short_code_map", "title" => __("Short Codes", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_plugin_updates_links", "href" => site_url() . "/wp-admin/admin.php?page=gmb_plugin_updates", "title" => __("Plugin Updates", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_feature_request_links", "href" => site_url() . "/wp-admin/admin.php?page=gmb_feature_requests", "title" => __("Feature Requests", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gmb_system_status", "title" => __("System Status", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_recommended_plugins_links", "href" => site_url() . "/wp-admin/admin.php?page=gmb_recommended_plugins", "title" => __("Recommendations", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_pro_version_link", "href" => site_url() . "/wp-admin/admin.php?page=gmb_pro_version", "title" => __("Premium Editions", map_bank)));
$wp_admin_bar->add_menu(array("parent" => "map_bank_links", "id" => "gmb_other_services_linkes", "href" => site_url() . "/wp-admin/admin.php?page=gmb_other_services", "title" => __("Our Other Services", map_bank)));
}
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;
}
break;
}
}
}
}
$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_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;">
