www.mapsmarker.com"); } include('inc' . DIRECTORY_SEPARATOR . 'admin-header.php'); ?>

prefix.'leafletmapsmarker_layers'; $table_name_markers = $wpdb->prefix.'leafletmapsmarker_markers'; $action = isset($_POST['action']) ? $_POST['action'] : (isset($_GET['action']) ? $_GET['action'] : ''); $searchtext = isset($_POST['searchtext']) ? '%' .esc_sql($_POST['searchtext']) . '%' : (isset($_GET['searchtext']) ? '%' . esc_sql($_GET['searchtext']) : '') . '%'; if ($action == 'search') { $layersearchnonce = isset($_POST['_wpnonce']) ? $_POST['_wpnonce'] : ''; if (! wp_verify_nonce($layersearchnonce, 'layersearch-nonce') ) die('
'.__('Security check failed - please call this function from the according admin page!','lmm').''); $lcount = intval($wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `$table_name_layers` WHERE id like '%s' OR name like '%s' OR address like '%s'", $searchtext, $searchtext, $searchtext))); $layerlist = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `$table_name_layers` WHERE id like '%s' OR name like '%s' OR address like '%s' order by $columnsort $columnsortorder", $searchtext, $searchtext, $searchtext), ARRAY_A); } else { $layerlist = $wpdb->get_results( "SELECT * FROM `$table_name_layers` WHERE `id`>0 order by `$columnsort` $columnsortorder", ARRAY_A ); $lcount = intval($wpdb->get_var('SELECT COUNT(*)-1 FROM '.$table_name_layers)); } ?>
"/>
" . __('list all layers','lmm') . "" : ""; ?>

:

'; else foreach ($layerlist as $row) { $markercount = 0; //info: needed for multi-layer-map count-bug if (current_user_can( $lmm_options[ 'capabilities_delete' ])) { $delete_link_layer = '
' . __('delete layer','lmm') . '
'; } else { $delete_link_layer = ''; } $column_address = ((isset($lmm_options[ 'misc_layer_listing_columns_address' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_address' ] == 1 )) ? '' : ''; if ($row['multi_layer_map'] == 0) { $markercount = $wpdb->get_var('SELECT count(*) FROM `'.$table_name_layers.'` as l INNER JOIN `'.$table_name_markers.'` AS m ON l.id=m.layer WHERE l.id='.$row['id']); } else if ( ($row['multi_layer_map'] == 1) && ( $row['multi_layer_map_list'] == 'all' ) ) { $markercount = intval($wpdb->get_var('SELECT COUNT(*) FROM '.$table_name_markers)); } else if ( ($row['multi_layer_map'] == 1) && ( $row['multi_layer_map_list'] != NULL ) && ($row['multi_layer_map_list'] != 'all') ) { $multi_layer_map_list_exploded = explode(",", $wpdb->get_var('SELECT l.multi_layer_map_list FROM `'.$table_name_layers.'` as l WHERE l.id='.$row['id'])); foreach ($multi_layer_map_list_exploded as $mlmrowcount){ $mlm_count_temp{$mlmrowcount} = $wpdb->get_var('SELECT count(*) FROM `'.$table_name_layers.'` as l INNER JOIN `'.$table_name_markers.'` AS m ON l.id=m.layer WHERE m.layer='.$mlmrowcount); $markercount = $markercount + $mlm_count_temp{$mlmrowcount}; } } else if ( ($row['multi_layer_map'] == 1) && ( $row['multi_layer_map_list'] == NULL ) ) { $markercount = 0; } $multi_layer_map_type = ($row['multi_layer_map'] == 0) ? '  ' : '  '; $openpanelstatus = ($row['panel'] == 1) ? __('visible','lmm') : __('hidden','lmm'); if ($row['controlbox'] == 0) { $controlboxstatus = __('hidden','lmm'); } else if ($row['controlbox'] == 1) { $controlboxstatus = __('collapsed (except on mobiles)','lmm'); } else if ($row['controlbox'] == 2) { $controlboxstatus = __('expanded','lmm'); }; //info: set column display variables - need for for-each $column_layercenter = ((isset($lmm_options[ 'misc_layer_listing_columns_layercenter' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_layercenter' ] == 1 )) ? '' : ''; $column_mapsize = ((isset($lmm_options[ 'misc_layer_listing_columns_mapsize' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_mapsize' ] == 1 )) ? '' : ''; $column_panelstatus = ((isset($lmm_options[ 'misc_layer_listing_columns_panelstatus' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_panelstatus' ] == 1 )) ? '' : ''; $column_zoom = ((isset($lmm_options[ 'misc_layer_listing_columns_zoom' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_zoom' ] == 1 )) ? '' : ''; $column_controlbox = ((isset($lmm_options[ 'misc_layer_listing_columns_controlbox' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_controlbox' ] == 1 )) ? '' : ''; //info: workaround - select shortcode on input focus doesnt work on iOS global $wp_version; if ( version_compare( $wp_version, '3.4', '>=' ) ) { $is_ios = wp_is_mobile() && preg_match( '/iPad|iPod|iPhone/', $_SERVER['HTTP_USER_AGENT'] ); $shortcode_select = ( $is_ios ) ? '' : 'onfocus="this.select();" readonly="readonly"'; } else { $shortcode_select = ''; } $column_shortcode = ((isset($lmm_options[ 'misc_layer_listing_columns_shortcode' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_shortcode' ] == 1 )) ? '' : ''; $column_kml = ((isset($lmm_options[ 'misc_layer_listing_columns_kml' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_kml' ] == 1 )) ? '' : ''; $column_fullscreen = ((isset($lmm_options[ 'misc_layer_listing_columns_fullscreen' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_fullscreen' ] == 1 )) ? '' : ''; $column_qr_code = ((isset($lmm_options[ 'misc_layer_listing_columns_qr_code' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_qr_code' ] == 1 )) ? '' : ''; if ($row['multi_layer_map_list'] == NULL ) { $geojson_api_link = $row['id']; } else { $geojson_api_link = $row['multi_layer_map_list']; } $column_geojson = ((isset($lmm_options[ 'misc_layer_listing_columns_geojson' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_geojson' ] == 1 )) ? '' : ''; $column_georss = ((isset($lmm_options[ 'misc_layer_listing_columns_georss' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_georss' ] == 1 )) ? '' : ''; $column_basemap = ((isset($lmm_options[ 'misc_layer_listing_columns_basemap' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_basemap' ] == 1 )) ? '' : ''; $column_createdby = ((isset($lmm_options[ 'misc_layer_listing_columns_createdby' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_createdby' ] == 1 )) ? '' : ''; $column_createdon = ((isset($lmm_options[ 'misc_layer_listing_columns_createdon' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_createdon' ] == 1 )) ? '' : ''; $column_updatedby = ((isset($lmm_options[ 'misc_layer_listing_columns_updatedby' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_updatedby' ] == 1 )) ? '' : ''; $column_updatedon = ((isset($lmm_options[ 'misc_layer_listing_columns_updatedon' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_updatedon' ] == 1 )) ? '' : ''; $add_new_marker_to_layer = ( $row['multi_layer_map'] == 0 ) ? '  |  ' . __('add new marker to this layer','lmm') . '' : ''; echo ' ' . $column_address . ' ' . $column_layercenter . ' ' . $column_mapsize . ' ' . $column_panelstatus . ' ' . $column_zoom . ' ' . $column_basemap . ' ' . $column_createdby . ' ' . $column_createdon . ' ' . $column_updatedby . ' ' . $column_updatedon . ' ' . $column_controlbox; echo ((isset($lmm_options[ 'misc_layer_listing_columns_used_in_content' ] ) == TRUE ) && ( $lmm_options[ 'misc_layer_listing_columns_used_in_content' ] == 1 )) ? '' : ''; echo $column_shortcode . ' ' . $column_kml . ' ' . $column_fullscreen . ' ' . $column_qr_code . ' ' . $column_geojson . ' ' . $column_georss . ' '; } ?>
ID #  KML      GeoJSON  GeoRSS 
ID #  KML      GeoJSON  GeoRSS 
' . __('No layer created yet', 'lmm') . '
' . $row['address'] . 'Lat: ' . $row['layerviewlat'] . '
Lon: ' . $row['layerviewlon'] . '		' . __('Width','lmm') . ': '.$row['mapwidth'].$row['mapwidthunit'].'
' . __('Height','lmm') . ': '.$row['mapheight'].'px		' . $openpanelstatus . '' . $row['layerzoom'] . '' . $controlboxstatus . 'KML-Logo
KML		Fullscreen-Logo
' . __('Fullscreen','lmm') . '		QR-code-logo
' . __('QR code','lmm') . '		' . esc_attr__('Export as GeoJSON','lmm') . '
GeoJSON		GeoRSS-logo
GeoRSS		' . $row['basemap'] . '' . esc_html($row['createdby']) . '' . $row['createdon'] . '' . esc_html($row['updatedby']) . '' . $row['updatedon'] . '

get_results('SELECT * FROM `'.$table_name_layers.'` WHERE `id` > 0 AND `multi_layer_map` = 0', ARRAY_A); ?>