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)) {
$wpgmza_image_height = "100";
}
if (!$wpgmza_image_width || !isset($wpgmza_image_width)) {
$wpgmza_image_width = "100";
}
if (isset($res->directions_enabled)) {
$d_enabled = $res->directions_enabled;
} else {
$d_enabled = false;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_image']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_image'] == "yes") {
$carousel_show_image = false;
} else {
$carousel_show_image = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_icon']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_icon'] == "yes") {
$carousel_show_icon = false;
} else {
$carousel_show_icon = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_title']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_title'] == "yes") {
$carousel_show_title = false;
} else {
$carousel_show_title = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_description']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_description'] == "yes") {
$carousel_show_description = false;
} else {
$carousel_show_description = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_address']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_address'] == "yes") {
$carousel_show_address = false;
} else {
$carousel_show_address = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_directions']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_directions'] == "yes") {
$carousel_show_directions = false;
} else {
$carousel_show_directions = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_marker_link']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_marker_link'] == "yes") {
$carousel_show_link = false;
} else {
$carousel_show_link = true;
}
if (isset($wpgmza_settings['wpgmza_settings_carousel_markerlist_resize_image']) && $wpgmza_settings['wpgmza_settings_carousel_markerlist_resize_image'] == "yes") {
$carousel_resize_image = true;
} else {
$carousel_resize_image = false;
}
if (isset($wpgmza_settings['wpgmza_settings_markerlist_category'])) {
$hide_category_column = $wpgmza_settings['wpgmza_settings_markerlist_category'];
} else {
$hide_category_column = false;
}
if (isset($wpgmza_settings['wpgmza_settings_markerlist_icon'])) {
$hide_icon_column = $wpgmza_settings['wpgmza_settings_markerlist_icon'];
} else {
$hide_icon_column = false;
}
if (isset($wpgmza_settings['wpgmza_settings_markerlist_title'])) {
$hide_title_column = $wpgmza_settings['wpgmza_settings_markerlist_title'];
} else {
$hide_title_column = false;
}
if (isset($wpgmza_settings['wpgmza_settings_markerlist_address'])) {
$hide_address_column = $wpgmza_settings['wpgmza_settings_markerlist_address'];
} else {
$hide_address_column = false;
}
if (isset($wpgmza_settings['wpgmza_settings_markerlist_description'])) {
$hide_description_column = $wpgmza_settings['wpgmza_settings_markerlist_description'];
} else {
$hide_description_column = false;
}
$wmcnt = 0;
foreach ($results as $result) {
/* this handles the ajax data requests for the store locator */
if (is_array($marker_array)) {
$display = 0;
foreach ($marker_array as $marker) {
if ($marker == $result->id) {
$display++;
}
}
} else {
$display = 1;
/* show all markers as we havent passed through any marker variables to check */
}
$c_display = 0;
/* this handles the ajax data requests for the category filtering */
$marker_category = $result->category;
$marker_category_data = explode(",", $marker_category);
if ($category_data == 'all' || !$category_data) {
$c_display++;
} else {
/* checkbox method */
if (is_array($category_data)) {
$c_display = 0;
foreach ($category_data as $cat) {
foreach ($marker_category_data as $marker_cat) {
if ($marker_cat == $cat) {
$c_display++;
}
}
}
} else {
/* select method */
$c_display = 0;
foreach ($marker_category_data as $marker_cat) {
if ($marker_cat == $category_data) {
$c_display++;
}
}
}
}
if ($display > 0 && $c_display > 0) {
$wmcnt++;
if ($wmcnt % 2) {
$carousel_oddeven = "wpgmza_carousel_odd";
$oddeven = "wpgmaps_odd";
} else {
$oddeven = "wpgmaps_even";
$carousel_oddeven = "wpgmza_carousel_even";
}
$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 (!$category_icon) {
if (!$icon) {
$icon = $default_marker;
} else {
$icon = "<img class=\"wpgmza_marker_icon {$additional_img_class}\" src='" . $result->icon . "' style='margin: 5px auto;' />";
}
} else {
if (!$icon) {
$icon = "<img class=\"wpgmza_marker_icon {$additional_img_class}\" src='" . $category_icon . "' style='margin: 5px auto;' />";
} else {
$icon = "<img class=\"wpgmza_marker_icon {$additional_img_class}\" src='" . $result->icon . "' style='margin: 5px auto;' />";
}
}
if (!$link) {
$linktd = "";
} else {
$linktd = "<a href=\"" . $result->link . "\" class=\"wpgmza_marker_link\" target=\"_BLANK\" title=\"" . __("View this link", "wp-google-maps") . "\">>></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>" . stripslashes(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 {
if ($type == 1) {
$img = $result->pic;
$wpgmaps_id = $result->id;
$link = $result->link;
$icon = $result->icon;
$wpgmaps_lat = $result->lat;
$wpgmaps_lng = $result->lng;
$wpgmaps_address = $result->address;
if (!$img) {
$pic = "<img src='" . plugins_url(plugin_basename(dirname(__FILE__))) . "/images/no-image.jpg' class='wpgmza_map_image' style=\"height:" . $wpgmza_image_height . "px; width:" . $wpgmza_image_width . "px\"\" />";
} else {
/* added in 5.52 - phasing out timthumb */
/* we have phased out timthumb in 5.54
if (isset($wpgmza_settings['wpgmza_settings_use_timthumb'])) { $wpgmza_use_timthumb = $wpgmza_settings['wpgmza_settings_use_timthumb']; } else { $wpgmza_use_timthumb = true; }
if ($wpgmza_use_timthumb == "" || !isset($wpgmza_use_timthumb) || $wpgmza_use_timthumb == 1) {
$pic = "<img src='".wpgmaps_get_plugin_url()."/timthumb.php?src=".$result->pic."&h=".$wpgmza_image_height."&w=".$wpgmza_image_width."&zc=1' title='' alt='' style=\"\" />";
} else {
*/
if ($wpgmza_image_resizing) {
$pic = "<img src='" . $result->pic . "' class='wpgmza_map_image' style=\"height:" . $wpgmza_image_height . "px; width:" . $wpgmza_image_width . "px\" />";
} else {
$pic = "<img src='" . $result->pic . "' class='wpgmza_map_image' />";
}
/* } */
}
if (!$icon) {
$icon = $default_marker;
} else {
$icon = "<img class='{$additional_img_class}' src='" . $result->icon . "' />";
}
if ($d_enabled == "1") {
$wpgmaps_dir_text = "<br /><a href=\"javascript:void(0);\" id=\"" . $map_id . "\" title=\"" . __("Get directions to", "wp-google-maps") . " " . $result->title . "\" class=\"wpgmza_gd\" wpgm_addr_field=\"" . $wpgmaps_address . "\" gps=\"{$wpgmaps_lat},{$wpgmaps_lng}\">" . __("Directions", "wp-google-maps") . "</a>";
} else {
$wpgmaps_dir_text = "";
}
if ($result->description) {
$wpgmaps_desc_text = "<br />" . $result->description . "";
} else {
$wpgmaps_desc_text = "";
}
if ($wmcnt % 2) {
$oddeven = "wpgmaps_odd";
} else {
$oddeven = "wpgmaps_even";
}
$wpgmza_tmp_body .= "<div id=\"wpgmza_marker_" . $result->id . "\" mid=\"" . $result->id . "\" mapid=\"" . $map_id . "\" class=\"wpgmaps_mlist_row wpgmza_basic_row {$oddeven}\">";
$wpgmza_tmp_body .= "<div class='wpgmza-basic-listing-content-holder'>";
$wpgmza_tmp_body .= "<div class='wpgmza-basic-listing-image-holder'>{$pic}</div>";
$wpgmza_tmp_body .= "";
$wpgmza_tmp_body .= "<div class='wpgmza-content-address-holder'>";
if (isset($result->title) && $result->title != "") {
$wpgmza_tmp_body .= "<p><strong><a href=\"javascript:void(0);\" id=\"wpgmaps_marker_{$wpgmaps_id}\" title=\"" . stripslashes($result->title) . "\">" . stripslashes($result->title) . "</a></strong></p>";
}
if (isset($hide_icon_column) && $hide_icon_column == "yes") {
} else {
$wpgmza_tmp_body .= "{$icon}";
}
if (isset($hide_address_column) && $hide_address_column == "yes") {
} else {
$wpgmza_tmp_body .= "<div class='wpgmza-address'>";
$wpgmza_tmp_body .= "" . stripslashes($result->address);
$wpgmza_tmp_body .= "</div>";
}
if (isset($hide_description_column) && $hide_description_column == "yes") {
} else {
$wpgmza_tmp_body .= "<div class='wpgmza-desc'>";
$wpgmza_tmp_body .= "<p>" . stripslashes($result->description) . "</p>";
$wpgmza_tmp_body .= "<p>" . $wpgmaps_dir_text . "</p>";
$wpgmza_tmp_body .= "</div>";
}
$wpgmza_tmp_body .= "</div>";
$wpgmza_tmp_body .= "</div>";
$wpgmza_tmp_body .= "</div>";
/*
$wpgmza_tmp_body .= "
<tr id=\"wpgmza_marker_".$result->id."\" mid=\"".$result->id."\" mapid=\"".$result->map_id."\" class=\"wpgmaps_mlist_row $oddeven\">
<td width=\"40\" class=\"wpgmaps_mlist_marker\">".$icon."</td>
<td class=\"wpgmaps_mlist_pic\" style=\"width:".($wpgmza_image_width+20)."px;\">$pic</td>
<td valign=\"top\" align=\"left\" class=\"wpgmaps_mlist_info\">
<strong><a href=\"javascript:openInfoWindow($wpgmaps_id);\" id=\"wpgmaps_marker_$wpgmaps_id\" title=\"".stripslashes($result->title)."\">".stripslashes($result->title)."</a></strong>
".stripslashes($wpgmaps_desc_text)."
$wpgmaps_dir_text
</td>
</tr>";
*/
} else {
if ($type == 2) {
$wpgmza_tmp_body .= "<tr id=\"wpgmza_marker_" . $result->id . "\" mid=\"" . $result->id . "\" mapid=\"" . $map_id . "\" class=\"wpgmaps_mlist_row\">";
if (isset($hide_icon_column) && $hide_icon_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_marker' height=\"40\">" . str_replace("'", "\"", $icon) . "</td>";
}
if (isset($hide_title_column) && $hide_title_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_title'>" . stripslashes($result->title) . "</td>";
}
if (isset($hide_category_column) && $hide_category_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_category'>" . stripslashes(wpgmza_return_category_name($result->category)) . " </td>";
}
if (isset($hide_address_column) && $hide_address_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_address'>" . stripslashes($result->address) . "</td>";
}
if (isset($hide_description_column) && $hide_description_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_description'>" . stripslashes($result->description) . "</td>";
}
/* deprecated in 5.54
$wpgmza_tmp_body .= " <td width='1px;' style='display:none; width:1px !important;'>".sprintf('%02d', $result->id)."</td>";
*/
$wpgmza_tmp_body .= "</tr>";
} else {
if ($type == 3) {
if (!$img) {
$pic = "";
} else {
/* added in 5.52 - phasing out timthumb */
/* we have phased out timthumb in 5.54
if (isset($wpgmza_settings['wpgmza_settings_use_timthumb'])) { $wpgmza_use_timthumb = $wpgmza_settings['wpgmza_settings_use_timthumb']; } else { $wpgmza_use_timthumb = true; }
if ($wpgmza_use_timthumb == "" || !isset($wpgmza_use_timthumb) || $wpgmza_use_timthumb == 1) {
$pic = "<img src='".wpgmaps_get_plugin_url()."/timthumb.php?src=".$result->pic."&h=".$wpgmza_image_height."&w=".$wpgmza_image_width."&zc=1' title='' alt='' style=\"\" />";
} else {
*/
if ($wpgmza_image_resizing) {
$pic = "<img src='" . $result->pic . "' class='wpgmza_map_image' style=\"margin:5px auto; height:" . $wpgmza_image_height . "px; width:" . $wpgmza_image_width . "px\" />";
} else {
$pic = "<img src='" . $result->pic . "' class='wpgmza_map_image' style=\"margin:5px auto;\" />";
}
/* } */
}
if ($d_enabled == "1") {
$wpgmaps_dir_text = "<p class=\"wpgmza_marker_directions_link\"><a href=\"javascript:void(0);\" id=\"" . $map_id . "\" title=\"" . __("Get directions to", "wp-google-maps") . " " . $result->title . "\" class=\"wpgmza_gd\" wpgm_addr_field=\"" . stripslashes($result->address) . "\" gps=\"" . stripslashes($result->lat) . "," . stripslashes($result->lng) . "\">" . __("Directions", "wp-google-maps") . "</a></p>";
} else {
$wpgmaps_dir_text = "";
}
$wpgmza_tmp_body .= "<div class=\"item wpgmaps_mlist_row {$carousel_oddeven}\" mid=\"" . $result->id . "\" mapid=\"" . $map_id . "\"> ";
if ($carousel_show_image) {
$wpgmza_tmp_body .= " <div class=\"wpgmza_carousel_image_holder\">{$pic}</div>";
}
if ($carousel_show_icon) {
$wpgmza_tmp_body .= " <div class=\"wpgmza_carousel_image_holder\">{$icon}</div>";
}
$wpgmza_tmp_body .= " <div class=\"wpgmza_carousel_info_holder\">";
if ($carousel_show_title) {
$wpgmza_tmp_body .= " <p class=\"wpgmza_marker_title\">" . stripslashes($result->title) . "</p>";
}
if ($carousel_show_address) {
$wpgmza_tmp_body .= " <p class=\"wpgmza_marker_address\">" . stripslashes($result->address) . "</p>";
}
if ($carousel_show_description) {
$wpgmza_tmp_body .= " <p class=\"wpgmza_marker_description\">" . stripslashes($result->description) . "</p>";
}
if ($carousel_show_link) {
$wpgmza_tmp_body .= " <p class=\"wpgmza_marker_link\">" . stripslashes($result->link) . "</p>";
}
if ($carousel_show_directions) {
$wpgmza_tmp_body .= " " . $wpgmaps_dir_text . "";
}
$wpgmza_tmp_body .= " </div>";
$wpgmza_tmp_body .= "</div>";
} else {
if ($type == 4) {
$wpgmza_tmp_body .= "<div id=\"wpgmza_marker_" . $result->id . "\" mid=\"" . $result->id . "\" mapid=\"" . $map_id . "\" class=\"wpgmaps_blist_row\">";
if (isset($hide_icon_column) && $hide_icon_column == "yes") {
} else {
$wpgmza_tmp_body .= " <div class='wpgmza-basic-list-item wpgmza_div_marker' style='max-width: 14px; max-height: 14px;'>" . str_replace("'", "\"", $icon) . "</div>";
}
if (isset($hide_title_column) && $hide_title_column == "yes") {
} else {
$wpgmza_tmp_body .= " <div class='wpgmza-basic-list-item wpgmza_div_title'> " . stripslashes($result->title) . "</div>";
}
if (isset($hide_address_column) && $hide_address_column == "yes") {
} else {
$wpgmza_tmp_body .= " <div class='wpgmza-basic-list-item wpgmza_div_address'> (" . stripslashes($result->address) . ")</div>";
}
$wpgmza_tmp_body .= "</div>";
} else {
$wpgmza_tmp_body .= "<tr id=\"wpgmza_marker_" . $result->id . "\" mid=\"" . $result->id . "\" mapid=\"" . $map_id . "\" class=\"wpgmaps_mlist_row\">";
if (isset($hide_icon_column) && $hide_icon_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_marker' height=\"40\">" . str_replace("'", "\"", $icon) . "</td>";
}
if (isset($hide_title_column) && $hide_title_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_title'>" . stripslashes($result->title) . "</td>";
}
if (isset($hide_category_column) && $hide_category_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_category'>" . stripslashes(wpgmza_return_category_name($result->category)) . " </td>";
}
if (isset($hide_address_column) && $hide_address_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_address'>" . stripslashes($result->address) . "</td>";
}
if (isset($hide_description_column) && $hide_description_column == "yes") {
} else {
$wpgmza_tmp_body .= " <td class='wpgmza_table_description'>" . stripslashes($result->description) . "</td>";
}
$wpgmza_tmp_body .= " <td width='1px;' style='display:none; width:1px !important;'><span style='display:none;'>" . sprintf('%02d', $result->id) . "</span></td>";
$wpgmza_tmp_body .= "</tr>";
}
}
}
}
}
}
}
if ($admin) {
$wpgmza_tmp_head .= "<table id=\"wpgmza_table\" class=\"display \" cellspacing=\"0\" cellpadding=\"0\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<thead>";
$wpgmza_tmp_head .= "<tr>";
$wpgmza_tmp_head .= " <th><strong>" . __("ID", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Icon", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Title", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Category", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Address", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Description", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Image", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Link", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th style='width:182px;'><strong>" . __("Action", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= "</tr>";
$wpgmza_tmp_head .= "</thead>";
$wpgmza_tmp_head .= "<tbody>";
} else {
if ($type == 1) {
$wpgmza_tmp_head .= "<div id=\"wpgmza_marker_list_" . $map_id . "\" class=\"wpgmza_marker_list_class\" style='width:" . $width . ";'>";
} else {
if ($type == 2) {
/* advanced marker listing */
if ($include_mlist_div) {
$wpgmza_tmp_head .= "<div id=\"wpgmza_marker_holder_" . $map_id . "\" class='wpgmza_marker_holder' style=\"width:{$width};\">";
}
$wpgmza_tmp_head .= "<table id=\"wpgmza_table_" . $map_id . "\" class=\"wpgmza_table responsive\" cellspacing=\"0\" cellpadding=\"0\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<thead>";
$wpgmza_tmp_head .= "<tr>";
if (isset($hide_icon_column) && $hide_icon_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_marker'><strong></strong></th>";
}
if (isset($hide_title_column) && $hide_title_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_title'><strong>" . __("Title", "wp-google-maps") . "</strong></th>";
}
if (isset($hide_category_column) && $hide_category_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_category'><strong>" . __("Category", "wp-google-maps") . "</strong></th>";
}
if (isset($hide_address_column) && $hide_address_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_address'><strong>" . __("Address", "wp-google-maps") . "</strong></th>";
}
if (isset($hide_description_column) && $hide_description_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_description'><strong>" . __("Description", "wp-google-maps") . "</strong></th>";
}
/* deprecated in 5.54
$wpgmza_tmp_head .= " <th width='1' style='display:none; width:1px !important;'>".__("Marker ID","wp-google-maps")."</th>";
*/
$wpgmza_tmp_head .= "</tr>";
$wpgmza_tmp_head .= "</thead>";
$wpgmza_tmp_head .= "<tbody>";
} else {
if ($type == 3) {
$wpgmza_tmp_head .= "<div id=\"wpgmza_marker_list_container_" . $map_id . "\" class=\"wpgmza_marker_carousel\"><div id=\"wpgmza_marker_list_" . $map_id . "\" class=\"wpgmza_marker_carousel owl-carousel\" style=\"width:{$width};\">";
} else {
if ($type == 4) {
$wpgmza_tmp_head .= " <div id=\"wpgmza_marker_list_" . $map_id . "\" class=\"wpgmza_marker_list_class wpgmza_basic_list\" style='width:" . $width . "'>";
} else {
/* advanced marker listing by default */
$wpgmza_tmp_head .= "<div id=\"wpgmza_marker_holder_" . $map_id . "\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<table id=\"wpgmza_table_" . $map_id . "\" class=\"wpgmza_table responsive\" cellspacing=\"0\" cellpadding=\"0\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<thead>";
$wpgmza_tmp_head .= "<tr>";
if (isset($hide_icon_column) && $hide_icon_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_marker'><strong></strong></th>";
}
if (isset($hide_title_column) && $hide_title_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_title'><strong>" . __("Title", "wp-google-maps") . "</strong></th>";
}
if (isset($hide_category_column) && $hide_category_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_category'><strong>" . __("Category", "wp-google-maps") . "</strong></th>";
}
if (isset($hide_address_column) && $hide_address_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_address'><strong>" . __("Address", "wp-google-maps") . "</strong></th>";
}
if (isset($hide_description_column) && $hide_description_column == "yes") {
} else {
$wpgmza_tmp_head .= "<th class='wpgmza_table_description'><strong>" . __("Description", "wp-google-maps") . "</strong></th>";
}
$wpgmza_tmp_head .= " <th width='1' style='display:none; width:1px !important;'></th>";
$wpgmza_tmp_head .= "</tr>";
$wpgmza_tmp_head .= "</thead>";
$wpgmza_tmp_head .= "<tbody>";
}
}
}
}
}
if ($admin) {
$wpgmza_tmp_footer .= "</tbody></table>";
} else {
if ($type == 1) {
$wpgmza_tmp_footer .= "</div>";
} else {
if ($type == 2) {
$wpgmza_tmp_footer .= "</tbody></table>";
if ($include_mlist_div) {
$wpgmza_tmp_footer .= "</div><!-- end of marker list -->";
}
} else {
if ($type == 3) {
$wpgmza_tmp_footer .= "</div></div>";
} else {
if ($type == 4) {
$wpgmza_tmp_footer .= "</div>";
} else {
$wpgmza_tmp_footer .= "</tbody></table></div>";
}
}
}
}
}
return $wpgmza_tmp_head . $wpgmza_tmp_body . $wpgmza_tmp_footer;
}
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") . "\">>></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 {
$wpgmza_tmp_body .= "<tr id=\"wpgmza_marker_" . $result->id . "\" mid=\"" . $result->id . "\" mapid=\"" . $result->map_id . "\" class=\"wpgmaps_mlist_row\">";
$wpgmza_tmp_body .= " <td width='1px;' style='display:none; width:1px !important;'><span style='display:none;'>" . sprintf('%02d', $result->id) . "</span></td>";
$wpgmza_tmp_body .= " <td class='wpgmza_table_marker' height=\"40\">" . str_replace("'", "\"", $icon) . "</td>";
$wpgmza_tmp_body .= " <td class='wpgmza_table_title'>" . stripslashes($result->title) . "</td>";
$wpgmza_tmp_body .= " <td class='wpgmza_table_category'>" . wpgmza_return_category_name($result->category) . "</td>";
$wpgmza_tmp_body .= " <td class='wpgmza_table_address'>" . stripslashes($result->address) . "</td>";
$wpgmza_tmp_body .= " <td class='wpgmza_table_description'>" . stripslashes($result->description) . "</td>";
$wpgmza_tmp_body .= "</tr>";
}
}
if ($admin) {
$wpgmza_tmp_head .= "<table id=\"wpgmza_table\" class=\"display\" cellspacing=\"0\" cellpadding=\"0\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<thead>";
$wpgmza_tmp_head .= "<tr>";
$wpgmza_tmp_head .= " <th><strong>" . __("ID", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Icon", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Title", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Category", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Address", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Description", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Image", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th><strong>" . __("Link", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th style='width:182px;'><strong>" . __("Action", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= "</tr>";
$wpgmza_tmp_head .= "</thead>";
$wpgmza_tmp_head .= "<tbody>";
} else {
$wpgmza_tmp_head .= "<div id=\"wpgmza_marker_holder_" . $map_id . "\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<table id=\"wpgmza_table_" . $map_id . "\" class=\"wpgmza_table\" cellspacing=\"0\" cellpadding=\"0\" style=\"width:{$width};\">";
$wpgmza_tmp_head .= "<thead>";
$wpgmza_tmp_head .= "<tr>";
$wpgmza_tmp_head .= " <th width='1' style='display:none; width:1px !important;'></th>";
$wpgmza_tmp_head .= " <th class='wpgmza_table_marker'><strong></strong></th>";
$wpgmza_tmp_head .= " <th class='wpgmza_table_title'><strong>" . __("Title", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th class='wpgmza_table_category'><strong>" . __("Category", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th class='wpgmza_table_address'><strong>" . __("Address", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= " <th class='wpgmza_table_description'><strong>" . __("Description", "wp-google-maps") . "</strong></th>";
$wpgmza_tmp_head .= "</tr>";
$wpgmza_tmp_head .= "</thead>";
$wpgmza_tmp_head .= "<tbody>";
}
if ($admin) {
$wpgmza_tmp_footer .= "</tbody></table>";
} else {
$wpgmza_tmp_footer .= "</tbody></table></div>";
}
return $wpgmza_tmp_head . $wpgmza_tmp_body . $wpgmza_tmp_footer;
}
}
