PHP wpgmaps_get_plugin_url函数代码示例

//.........这里部分代码省略.........
    ?>
        <?php 
    if (get_option('wpgmza_google_maps_api_key')) {
        ?>
            <script type="text/javascript">
                var gmapsJsHost = (("https:" == document.location.protocol) ? "https://" : "http://");
                var wpgmza_api_key = '<?php 
        echo get_option('wpgmza_google_maps_api_key');
        ?>
';
                document.write(unescape("%3Cscript src='" + gmapsJsHost + "maps.google.com/maps/api/js?<?php 
        echo $api_version_string;
        ?>
key="+wpgmza_api_key+"' type='text/javascript'%3E%3C/script%3E"));
            </script>
        <?php 
    } else {
        ?>
            <script type="text/javascript">
                var wpgmza_temp_api_key = "<?php 
        echo get_option('wpgmza_temp_api');
        ?>
";
                var gmapsJsHost = (("https:" == document.location.protocol) ? "https://" : "http://");
                document.write(unescape("%3Cscript src='" + gmapsJsHost + "maps.google.com/maps/api/js?<?php 
        echo $api_version_string;
        ?>
key="+wpgmza_temp_api_key+"&libraries=places' type='text/javascript'%3E%3C/script%3E"));
            </script>
        <?php 
    }
    ?>
        <link rel='stylesheet' id='wpgooglemaps-css'  href='<?php 
    echo wpgmaps_get_plugin_url();
    ?>
/css/wpgmza_style.css' type='text/css' media='all' />
        <script type="text/javascript" >
             // polygons variables
            var poly;
            var poly_markers = [];
            var poly_path = new google.maps.MVCArray;
            var path;
                
            jQuery(document).ready(function(){
                
                    function wpgmza_InitMap() {
                        var myLatLng = new google.maps.LatLng(<?php 
    echo $wpgmza_lat;
    ?>
,<?php 
    echo $wpgmza_lng;
    ?>
);
                        MYMAP.init('#wpgmza_map', myLatLng, <?php 
    echo $start_zoom;
    ?>
);
                    }
                    jQuery("#wpgmza_map").css({
                        height:'<?php 
    echo $wpgmza_height;
    echo $wpgmza_height_type;
    ?>
',
                        width:'<?php 
    echo $wpgmza_width;

function wpgmza_return_marker_list($map_id, $admin = true, $width = "100%", $mashup = false, $mashup_ids = false)
{
    global $wpdb;
    global $wpgmza_tblname;
    if ($mashup) {
        // map mashup
        $map_ids = $mashup_ids;
        $wpgmza_cnt = 0;
        if ($mashup_ids[0] == "ALL") {
            $wpgmza_sql1 = "\r\n            SELECT *\r\n            FROM {$wpgmza_tblname}\r\n            ORDER BY `id` DESC\r\n            ";
        } else {
            $wpgmza_id_cnt = count($map_ids);
            $sql_string1 = "";
            foreach ($map_ids as $wpgmza_map_id) {
                $wpgmza_cnt++;
                if ($wpgmza_cnt == 1) {
                    $sql_string1 .= "`map_id` = '{$wpgmza_map_id}' ";
                } elseif ($wpgmza_cnt > 1 && $wpgmza_cnt < $wpgmza_id_cnt) {
                    $sql_string1 .= "OR `map_id` = '{$wpgmza_map_id}' ";
                } else {
                    $sql_string1 .= "OR `map_id` = '{$wpgmza_map_id}' ";
                }
            }
            $wpgmza_sql1 = "\r\n            SELECT *\r\n            FROM {$wpgmza_tblname}\r\n            WHERE {$sql_string1} ORDER BY `id` DESC\r\n            ";
        }
    } else {
        $wpgmza_sql1 = "\r\n            SELECT *\r\n            FROM {$wpgmza_tblname}\r\n            WHERE `map_id` = '{$map_id}' ORDER BY `id` DESC\r\n            ";
    }
    $marker_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$wpgmza_tblname} WHERE map_id = %d", $map_id));
    if ($marker_count > 2000) {
        return __("There are too many markers to make use of the live edit function. The maximum amount for this functionality is 2000 markers. Anything more than that could crash your browser. In order to edit your markers, you would need to download the table in CSV format, edit it and re-upload it.", "wp-google-maps");
    } else {
        $results = $wpdb->get_results($wpgmza_sql1);
        $wpgmza_tmp_body = "";
        $wpgmza_tmp_head = "";
        $wpgmza_tmp_footer = "";
        $res = wpgmza_get_map_data($map_id);
        if (!$res->default_marker) {
            $default_marker = "<img src='" . wpgmaps_get_plugin_url() . "/images/marker.png' />";
        } else {
            $default_marker = "<img src='" . $res->default_marker . "' />";
        }
        foreach ($results as $result) {
            $img = $result->pic;
            $link = $result->link;
            $icon = $result->icon;
            if (isset($result->approved)) {
                $approved = $result->approved;
                if ($approved == 0) {
                    $show_approval_button = true;
                } else {
                    $show_approval_button = false;
                }
            } else {
                $show_approval_button = false;
            }
            $category_icon = wpgmza_get_category_icon($result->category);
            if (!$img) {
                $pic = "";
            } else {
                $pic = "<img src=\"" . $result->pic . "\" width=\"40\" />";
            }
            if (!$category_icon) {
                if (!$icon) {
                    $icon = $default_marker;
                } else {
                    $icon = "<img src='" . $result->icon . "' />";
                }
            } else {
                if (!$icon) {
                    $icon = "<img src='" . $category_icon . "' />";
                } else {
                    $icon = "<img src='" . $result->icon . "' />";
                }
            }
            if (!$link) {
                $linktd = "";
            } else {
                $linktd = "<a href=\"" . $result->link . "\" target=\"_BLANK\" title=\"" . __("View this link", "wp-google-maps") . "\">&gt;&gt;</a>";
            }
            if ($admin) {
                $wpgmza_tmp_body .= "<tr id=\"wpgmza_tr_" . $result->id . "\" class=\"gradeU\">";
                $wpgmza_tmp_body .= "<td height=\"40\">" . $result->id . "</td>";
                $wpgmza_tmp_body .= "<td height=\"40\">" . $icon . "<input type=\"hidden\" id=\"wpgmza_hid_marker_icon_" . $result->id . "\" value=\"" . $result->icon . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_anim_" . $result->id . "\" value=\"" . $result->anim . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_category_" . $result->id . "\" value=\"" . $result->category . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_infoopen_" . $result->id . "\" value=\"" . $result->infoopen . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_retina_" . $result->id . "\" value=\"" . $result->retina . "\" /></td>";
                $wpgmza_tmp_body .= "<td>" . stripslashes($result->title) . "<input type=\"hidden\" id=\"wpgmza_hid_marker_title_" . $result->id . "\" value=\"" . stripslashes($result->title) . "\" /></td>";
                $wpgmza_tmp_body .= "<td>" . wpgmza_return_category_name($result->category) . "<input type=\"hidden\" id=\"wpgmza_hid_marker_category_" . $result->id . "\" value=\"" . $result->category . "\" /></td>";
                $wpgmza_tmp_body .= "<td>" . stripslashes($result->address) . "<input type=\"hidden\" id=\"wpgmza_hid_marker_address_" . $result->id . "\" value=\"" . stripslashes($result->address) . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_lat_" . $result->id . "\" value=\"" . $result->lat . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_lng_" . $result->id . "\" value=\"" . $result->lng . "\" /></td>";
                $wpgmza_tmp_body .= "<td>" . stripslashes($result->description) . "<input type=\"hidden\" id=\"wpgmza_hid_marker_desc_" . $result->id . "\" value=\"" . htmlspecialchars(stripslashes($result->description)) . "\" /></td>";
                $wpgmza_tmp_body .= "<td>{$pic}<input type=\"hidden\" id=\"wpgmza_hid_marker_pic_" . $result->id . "\" value=\"" . $result->pic . "\" /></td>";
                $wpgmza_tmp_body .= "<td>{$linktd}<input type=\"hidden\" id=\"wpgmza_hid_marker_link_" . $result->id . "\" value=\"" . $result->link . "\" /></td>";
                $wpgmza_tmp_body .= "<td width='170' align='center'>";
                $wpgmza_tmp_body .= "    <a href=\"#wpgmaps_marker\" title=\"" . __("Edit this marker", "wp-google-maps") . "\" class=\"wpgmza_edit_btn button\" id=\"" . $result->id . "\"><i class=\"fa fa-edit\"> </i> </a> ";
                $wpgmza_tmp_body .= "    <a href=\"?page=wp-google-maps-menu&action=edit_marker&id=" . $result->id . "\" title=\"" . __("Edit this marker", "wp-google-maps") . "\" class=\"wpgmza_edit_btn button\" id=\"" . $result->id . "\"><i class=\"fa fa-map-marker\"> </i></a> ";
                if ($show_approval_button) {
                    $wpgmza_tmp_body .= "    <a href=\"javascript:void(0);\" title=\"" . __("Approve this marker", "wp-google-maps") . "\" class=\"wpgmza_approve_btn button\" id=\"" . $result->id . "\"><i class=\"fa fa-check\"> </i> </a> ";
                }
                $wpgmza_tmp_body .= "    <a href=\"javascript:void(0);\" title=\"" . __("Delete this marker", "wp-google-maps") . "\" class=\"wpgmza_del_btn button\" id=\"" . $result->id . "\"><i class=\"fa fa-times\"> </i></a>";
                $wpgmza_tmp_body .= "</td>";
                $wpgmza_tmp_body .= "</tr>";
            } else {
//.........这里部分代码省略.........

 function list_markers($admin = false, $type = 1, $map_id = false, $category_data = false, $mashup = false, $mashup_ids = false, $marker_array = false, $order_by = false, $order = false, $include_mlist_div = true)
 {
     global $wpdb;
     global $wpgmza_tblname;
     $res = $this->get_map_data($map_id);
     if ($type == 4) {
         $additional_img_class = "wpgmza_small_img";
     } else {
         $additional_img_class = "";
     }
     if (!isset($res->default_marker) || !$res->default_marker) {
         $default_marker = "<img src='" . wpgmaps_get_plugin_url() . "/images/marker.png'  style='' class='{$additional_img_class}' />";
     } else {
         $default_marker = "<img src='" . $res->default_marker . "' style='' class='{$additional_img_class}' />";
     }
     $width = stripslashes(trim($res->map_width)) . stripslashes(trim($res->map_width_type));
     // marker sorting functionality
     if ($res->order_markers_by == '1') {
         $order_by = "id";
     } else {
         if ($res->order_markers_by == '2') {
             $order_by = "title";
         } else {
             if ($res->order_markers_by == '3') {
                 $order_by = "address";
             } else {
                 if ($res->order_markers_by == '4') {
                     $order_by = "description";
                 } else {
                     if ($res->order_markers_by == '5') {
                         $order_by = "category";
                     } else {
                         $order_by = "id";
                     }
                 }
             }
         }
     }
     if ($res->order_markers_choice == '1') {
         $order_choice = "ASC";
     } else {
         $order_choice = "DESC";
     }
     if ($mashup) {
         // map mashup
         $map_ids = $mashup_ids;
         $wpgmza_cnt = 0;
         if ($mashup_ids[0] == "ALL") {
             $wpgmza_sql1 = "\r\n                SELECT *\r\n                FROM {$wpgmza_tblname}\r\n                ORDER BY `id` DESC\r\n                ";
         } else {
             $wpgmza_id_cnt = count($map_ids);
             $sql_string1 = "";
             foreach ($map_ids as $wpgmza_map_id) {
                 $wpgmza_cnt++;
                 if ($wpgmza_cnt == 1) {
                     $sql_string1 .= "`map_id` = '{$wpgmza_map_id}' ";
                 } elseif ($wpgmza_cnt > 1 && $wpgmza_cnt < $wpgmza_id_cnt) {
                     $sql_string1 .= "OR `map_id` = '{$wpgmza_map_id}' ";
                 } else {
                     $sql_string1 .= "OR `map_id` = '{$wpgmza_map_id}' ";
                 }
             }
             $wpgmza_sql1 = "\r\n                SELECT *\r\n                FROM {$wpgmza_tblname}\r\n                WHERE {$sql_string1} ORDER BY `id` DESC\r\n                ";
         }
     } else {
         if ($order_by && $order_choice) {
             $wpgmza_sql1 = "\r\n                SELECT *\r\n                FROM {$wpgmza_tblname}\r\n                WHERE `map_id` = '{$map_id}' AND `approved` = 1 ORDER BY `{$order_by}` {$order_choice}\r\n                ";
         } else {
             $wpgmza_sql1 = "\r\n                SELECT *\r\n                FROM {$wpgmza_tblname}\r\n                WHERE `map_id` = '{$map_id}' AND `approved` = 1 ORDER BY `id` DESC\r\n                ";
         }
     }
     $marker_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$wpgmza_tblname} WHERE map_id = %d", $map_id));
     //        removed in 5.49 as it was showing up in the front end.
     //        =========================================================
     //        if ($marker_count > 5000) {
     //            return __("There are too many markers to make use of the live edit function. The maximum amount for this functionality is 2000 markers. Anything more than that could crash your browser. In order to edit your markers, you would need to download the table in CSV format, edit it and re-upload it.","wp-google-maps");
     //        } else {
     //
     //        }
     $results = $wpdb->get_results($wpgmza_sql1);
     $wpgmza_tmp_body = "";
     $wpgmza_tmp_head = "";
     $wpgmza_tmp_footer = "";
     $wpgmza_settings = get_option("WPGMZA_OTHER_SETTINGS");
     if (isset($wpgmza_settings['wpgmza_settings_image_resizing']) && $wpgmza_settings['wpgmza_settings_image_resizing'] == 'yes') {
         $wpgmza_image_resizing = true;
     } else {
         $wpgmza_image_resizing = false;
     }
     if (isset($wpgmza_settings['wpgmza_settings_image_height'])) {
         $wpgmza_image_height = $wpgmza_settings['wpgmza_settings_image_height'];
     } else {
         $wpgmza_image_height = false;
     }
     if (isset($wpgmza_settings['wpgmza_settings_image_width'])) {
         $wpgmza_image_width = $wpgmza_settings['wpgmza_settings_image_width'];
     } else {
         $wpgmza_image_width = false;
     }
     if (!$wpgmza_image_height || !isset($wpgmza_image_height)) {
//.........这里部分代码省略.........

function wpgmaps_b_admin_edit_poly_javascript($mapid, $polyid)
{
    $res = wpgmza_get_map_data($mapid);
    $wpgmza_settings = get_option("WPGMZA_OTHER_SETTINGS");
    $wpgmza_lat = $res->map_start_lat;
    $wpgmza_lng = $res->map_start_lng;
    $wpgmza_map_type = $res->type;
    $wpgmza_width = $res->map_width;
    $wpgmza_height = $res->map_height;
    $wpgmza_width_type = $res->map_width_type;
    $wpgmza_height_type = $res->map_height_type;
    if (!$wpgmza_map_type || $wpgmza_map_type == "" || $wpgmza_map_type == "1") {
        $wpgmza_map_type = "ROADMAP";
    } else {
        if ($wpgmza_map_type == "2") {
            $wpgmza_map_type = "SATELLITE";
        } else {
            if ($wpgmza_map_type == "3") {
                $wpgmza_map_type = "HYBRID";
            } else {
                if ($wpgmza_map_type == "4") {
                    $wpgmza_map_type = "TERRAIN";
                } else {
                    $wpgmza_map_type = "ROADMAP";
                }
            }
        }
    }
    $start_zoom = $res->map_start_zoom;
    if ($start_zoom < 1 || !$start_zoom) {
        $start_zoom = 5;
    }
    $wpgmza_settings = get_option("WPGMZA_OTHER_SETTINGS");
    ?>
        <script type="text/javascript">
                       var gmapsJsHost = (("https:" == document.location.protocol) ? "https://" : "http://");
                       document.write(unescape("%3Cscript src='" + gmapsJsHost + "maps.google.com/maps/api/js?sensor=false' type='text/javascript'%3E%3C/script%3E"));
        </script>
        <link rel='stylesheet' id='wpgooglemaps-css'  href='<?php 
    echo wpgmaps_get_plugin_url();
    ?>
/css/wpgmza_style.css' type='text/css' media='all' />
        <script type="text/javascript" >
             // polygons variables
            var poly;
            var poly_markers = [];
            var poly_path = new google.maps.MVCArray;
                
            jQuery(document).ready(function(){
                
                    function wpgmza_InitMap() {
                        var myLatLng = new google.maps.LatLng(<?php 
    echo $wpgmza_lat;
    ?>
,<?php 
    echo $wpgmza_lng;
    ?>
);
                        MYMAP.init('#wpgmza_map', myLatLng, <?php 
    echo $start_zoom;
    ?>
);
                    }
                    jQuery("#wpgmza_map").css({
                        height:'<?php 
    echo $wpgmza_height;
    echo $wpgmza_height_type;
    ?>
',
                        width:'<?php 
    echo $wpgmza_width;
    echo $wpgmza_width_type;
    ?>
'
                    });
                    wpgmza_InitMap();
                    
                    
                    jQuery("#poly_line").focusout(function() {
                        poly.setOptions({ strokeColor: "#"+jQuery("#poly_line").val() }); 
                    });
                    jQuery("#poly_fill").focusout(function() {
                        poly.setOptions({ fillColor: "#"+jQuery("#poly_fill").val() }); 
                    });
                    jQuery("#poly_opacity").keyup(function() {
                        poly.setOptions({ fillOpacity: jQuery("#poly_opacity").val() }); 
                    });
                    jQuery("#poly_line_opacity").keyup(function() {
                        poly.setOptions({ strokeOpacity: jQuery("#poly_line_opacity").val() }); 
                    });
            });
            

            var MYMAP = {
                map: null,
                bounds: null
            }
            MYMAP.init = function(selector, latLng, zoom) {
                  var myOptions = {
                    zoom:zoom,
//.........这里部分代码省略.........

//.........这里部分代码省略.........
                            ?>




     <?php 
                            if ($cloud_layer == 1 || $weather_layer == 1) {
                                ?>

    <script type="text/javascript">
        var gmapsJsHost = (("https:" == document.location.protocol) ? "https://" : "http://");
        document.write(unescape("%3Cscript src='" + gmapsJsHost + "maps.google.com/maps/api/js?<?php 
                                echo $api_version_string;
                                ?>
sensor=false&libraries=weather' type='text/javascript'%3E%3C/script%3E"));
    </script>

    <?php 
                            } else {
                                ?>

    <script type="text/javascript">
        var gmapsJsHost = (("https:" == document.location.protocol) ? "https://" : "http://");
        document.write(unescape("%3Cscript src='" + gmapsJsHost + "maps.google.com/maps/api/js?<?php 
                                echo $api_version_string;
                                ?>
sensor=false' type='text/javascript'%3E%3C/script%3E"));
    </script>

    <?php 
                            }
                            ?>
    <link rel="stylesheet" type="text/css" media="all" href="<?php 
                            echo wpgmaps_get_plugin_url();
                            ?>
/css/data_table.css" />
    <link rel="stylesheet" href="http://code.jquery.com/ui/1.10.2/themes/smoothness/jquery-ui.css" />

    <script type="text/javascript" src="<?php 
                            echo wpgmaps_get_plugin_url();
                            ?>
/js/markerclusterer.js"></script>
    <script type="text/javascript" src="<?php 
                            echo wpgmaps_get_plugin_url();
                            ?>
/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" >

    var marker_pull = '<?php 
                            echo $marker_pull;
                            ?>
';
    <?php 
                            if (isset($markers) && strlen($markers) > 0 && $markers != "[]") {
                                ?>
var db_marker_array = JSON.stringify(<?php 
                                echo $markers;
                                ?>
);<?php 
                            } else {
                                echo "var db_marker_array = '';";
                            }
                            ?>
    jQuery(function() {

function wpgmza_pro_category_edit_layout($cat_id)
{
    global $wpdb;
    global $wpgmza_tblname_categories;
    $map_ids = wpgmza_return_all_map_ids();
    $results = $wpdb->get_results("\r\n      SELECT *\r\n      FROM {$wpgmza_tblname_categories}\r\n      WHERE `id` = '{$cat_id}' LIMIT 1\r\n    ");
    if (isset($results[0]->category_icon) && $results[0]->category_icon != '') {
        $display_marker = "<img src='" . $results[0]->category_icon . "' />";
        $display_url = $results[0]->category_icon;
    } else {
        $display_marker = "<img src=\"" . wpgmaps_get_plugin_url() . "/images/marker.png\" />";
        $display_url = "";
    }
    if (isset($results[0]->retina) && intval($results[0]->retina) == 1) {
        $retina_checked = "checked='checked'";
    } else {
        $retina_checked = "";
    }
    echo "<div class='wrap'>";
    echo "  <h1>WP Google Maps</h1>";
    echo "  <div class='wide'>";
    echo "      <h2>" . __("Add a Marker Category", "wp-google-maps") . "</h2>";
    echo "      <form action='admin.php?page=wp-google-maps-menu-categories' method='post' id='wpgmaps_add_marker_category' name='wpgmaps_edit_marker_category_form'>";
    echo "      <table>";
    echo "          <tr>";
    echo "              <td><strong>" . __("Category Name", "wp-google-maps") . "</strong>:</td>";
    echo "              <td><input type='hidden' name='wpgmaps_marker_category_id' id='wpgmaps_marker_category_id' value='" . $results[0]->id . "' /><input type='text' name='wpgmaps_marker_category_name' id='wpgmaps_marker_category_name' value='" . $results[0]->category_name . "' /></td>";
    echo "              <td></td>";
    echo "          </tr>";
    echo "          <tr style='height:20px;'>";
    echo "              <td></td>";
    echo "              <td></td>";
    echo "              <td></td>";
    echo "          </tr>";
    echo "          <tr valign='top'>";
    echo "              <td valign='middle'><strong>" . __("Category Marker", "wp-google-maps") . "</strong>:</td>";
    echo "              <td align='left'><span id=\"wpgmza_mm\">{$display_marker}</span> </td>";
    echo "              <td valign='middle'>Enter URL <input id=\"upload_default_category_marker\" name=\"upload_default_category_marker\" type='text' size='35' class='regular-text' maxlength='700' value='{$display_url}' /> or <input id=\"upload_default_category_marker_btn\" type=\"button\" value=\"" . __("Upload Image", "wp-google-maps") . "\" /> <a href=\"javascript:void(0);\" onClick=\"document.forms['wpgmaps_edit_marker_category_form'].upload_default_category_marker.value = ''; var span = document.getElementById('wpgmza_mm'); while( span.firstChild ) { span.removeChild( span.firstChild ); } span.appendChild( document.createTextNode('')); return false;\" title=\"Reset to default\">-reset-</a> <small><i>" . __("Get great map markers <a href='http://mapicons.nicolasmollet.com/' target='_BLANK' title='Great Google Map Markers'>here</a>", "wp-google-maps") . "</i></small></td>";
    echo "          </tr>";
    echo "          <tr>";
    echo "              <td><strong>" . __("Retina Ready", "wp-google-maps") . "</strong>:</td>";
    echo "              <td><input type='checkbox' name='wpgmaps_marker_category_retina' value='1' {$retina_checked}>" . __("This marker is a retina-ready marker", "wp-google-maps") . "</td>";
    echo "              <td></td>";
    echo "          </tr>";
    echo "          <tr style='height:20px;'>";
    echo "              <td></td>";
    echo "              <td></td>";
    echo "              <td></td>";
    echo "          </tr>";
    echo "          <tr>";
    echo "              <td valign='top'><strong>" . __("Assigned to ", "wp-google-maps") . "</strong>:</td>";
    echo "              <td>";
    echo "                  <input type='checkbox' name='assigned_to_map[]' value='ALL' " . wpgmza_check_cat_map('ALL', $cat_id) . "> All Maps <br /><br />";
    foreach ($map_ids as $map_id) {
        $map_data = wpgmza_get_map_data($map_id);
        echo "                  <input type='checkbox' name='assigned_to_map[]' value='" . $map_id . "' " . wpgmza_check_cat_map($map_id, $cat_id) . "> " . $map_data->map_title . "  (id " . $map_id . ")<br />";
    }
    echo "              </td>";
    echo "          </tr>";
    echo "      </table>";
    echo "          <p class='submit'><input type='submit' name='wpgmza_edit_marker_category' class='button-primary' value='" . __("Save Category", "wp-google-maps") . " &raquo;' /></p>";
    echo "      </form>";
    echo "  </div>";
    echo "</div>";
}

function wpgmza_pro_advanced_menu()
{
    $wpgmza_csv = "<a href=\"" . wpgmaps_get_plugin_url() . "/csv.php\" title=\"" . __("Download ALL marker data to a CSV file", "wp-google-maps") . "\">" . __("Download ALL marker data to a CSV file", "wp-google-maps") . "</a>";
    echo "\n        <div class=\"wrap\"><div id=\"icon-tools\" class=\"icon32 icon32-posts-post\"><br></div><h2>" . __("Advanced Options", "wp-google-maps") . "</h2>\n        <div style=\"display:block; overflow:auto; background-color:#FFFBCC; padding:10px; border:1px solid #E6DB55; margin-top:35px; margin-bottom:5px;\">\n            {$wpgmza_csv}\n            <br /><br /><strong>- " . __("OR", "wp-google-maps") . " -<br /><br /></strong><form enctype=\"multipart/form-data\" method=\"POST\">\n                " . __("Upload CSV File", "wp-google-maps") . ": <input name=\"wpgmza_csvfile\" type=\"file\" /><br />\n                <input name=\"wpgmza_security\" type=\"hidden\" value=\"{$wpgmza_post_nonce}\" /><br />\n                " . __("Replace existing data with data in file", "wp-google-maps") . ": <input name=\"wpgmza_csvreplace\" type=\"checkbox\" value=\"Yes\" /><br />\n                <input type=\"submit\" name=\"wpgmza_uploadcsv_btn\" value=\"" . __("Upload File", "wp-google-maps") . "\" />\n            </form>\n        </div>\n\n\n\n    ";
}

function wpgmza_return_marker_list($map_id)
{
    wpgmaps_debugger("return_marker_start");
    global $wpdb;
    global $wpgmza_tblname;
    $marker_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM {$wpgmza_tblname} WHERE `map_id` = '{$map_id}';"));
    if ($marker_count > 2000) {
        return __("There are too many markers to make use of the live edit function. The maximum amount for this functionality is 2000 markers. Anything more than that number would crash your browser. In order to edit your markers, you would need to download the table in CSV format, edit it and re-upload it.", "wp-google-maps");
    } else {
        $results = $wpdb->get_results("\n\tSELECT *\n\tFROM {$wpgmza_tblname}\n\tWHERE `map_id` = '{$map_id}' ORDER BY `id` DESC\n    ");
        $wpgmza_tmp .= "\n        <table id=\"wpgmza_table\" class=\"display\" cellspacing=\"0\" cellpadding=\"0\">\n        <thead>\n        <tr>\n            <th><strong>" . __("ID", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Icon", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Title", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Address", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Description", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Image", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Link", "wp-google-maps") . "</strong></th>\n            <th><strong>" . __("Action", "wp-google-maps") . "</strong></th>\n        </tr>\n        </thead>\n        <tbody>\n";
        $wpgmza_data = get_option('WPGMZA');
        if ($wpgmza_data['map_default_marker']) {
            $default_icon = "<img src='" . $wpgmza_data['map_default_marker'] . "' />";
        } else {
            $default_icon = "<img src='" . wpgmaps_get_plugin_url() . "/images/marker.png' />";
        }
        foreach ($results as $result) {
            $img = $result->pic;
            $link = $result->link;
            $icon = $result->icon;
            if (!$img) {
                $pic = "";
            } else {
                $pic = "<img src=\"" . $result->pic . "\" width=\"40\" />";
            }
            if (!$icon) {
                $icon = $default_icon;
            } else {
                $icon = "<img src='" . $result->icon . "' />";
            }
            if (!$link) {
                $linktd = "";
            } else {
                $linktd = "<a href=\"" . $result->link . "\" target=\"_BLANK\" title=\"" . __("View this link", "wp-google-maps") . "\">&gt;&gt;</a>";
            }
            $wpgmza_tmp .= "\n            <tr id=\"wpgmza_tr_" . $result->id . "\">\n                <td height=\"40\">" . $result->id . "</td>\n                <td height=\"40\">" . $icon . "<input type=\"hidden\" id=\"wpgmza_hid_marker_icon_" . $result->id . "\" value=\"" . $result->icon . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_anim_" . $result->id . "\" value=\"" . $result->anim . "\" /><input type=\"hidden\" id=\"wpgmza_hid_marker_infoopen_" . $result->id . "\" value=\"" . $result->infoopen . "\" /></td>\n                <td>" . $result->title . "<input type=\"hidden\" id=\"wpgmza_hid_marker_title_" . $result->id . "\" value=\"" . $result->title . "\" /></td>\n                <td>" . $result->address . "<input type=\"hidden\" id=\"wpgmza_hid_marker_address_" . $result->id . "\" value=\"" . $result->address . "\" /></td>\n                <td>" . $result->desc . "<input type=\"hidden\" id=\"wpgmza_hid_marker_desc_" . $result->id . "\" value=\"" . $result->desc . "\" /></td>\n                <td>{$pic}<input type=\"hidden\" id=\"wpgmza_hid_marker_pic_" . $result->id . "\" value=\"" . $result->pic . "\" /></td>\n                <td>{$linktd}<input type=\"hidden\" id=\"wpgmza_hid_marker_link_" . $result->id . "\" value=\"" . $result->link . "\" /></td>\n                <td width='170' align='center'>\n                    <a href=\"#wpgmaps_marker\" title=\"" . __("Edit this marker", "wp-google-maps") . "\" class=\"wpgmza_edit_btn\" id=\"" . $result->id . "\">" . __("Edit", "wp-google-maps") . "</a> |\n                    <a href=\"?page=wp-google-maps-menu&action=edit_marker&id=" . $result->id . "\" title=\"" . __("Edit this marker", "wp-google-maps") . "\" class=\"wpgmza_edit_btn\" id=\"" . $result->id . "\">" . __("Edit Location", "wp-google-maps") . "</a> |\n                    <a href=\"javascript:void(0);\" title=\"" . __("Delete this marker", "wp-google-maps") . "\" class=\"wpgmza_del_btn\" id=\"" . $result->id . "\">" . __("Delete", "wp-google-maps") . "</a>\n                </td>\n            </tr>";
        }
        $wpgmza_tmp .= "</tbody></table>";
        wpgmaps_debugger("return_marker_end");
        return $wpgmza_tmp;
    }
}