function es_print_scripts() { global $wpdb; $sql = 'SELECT prop_address FROM ' . $wpdb->prefix . 'estatik_properties WHERE prop_pub_unpub = 1 order by prop_id desc'; $es_addresses = $wpdb->get_results($sql); echo "<script type='text/javascript'>\n"; $es_settings = es_front_settings(); if (is_singular('properties')) { echo "jQuery(window).load(function(e) { \r\r\n\t\t\t \t \r\r\n\t\t\t\tvar navPos = parseInt(jQuery('.es_prop_single_tabs').offset().top);\r\r\n\t\t\t\tvar navPosLeft = parseInt(jQuery('.es_prop_single_tabs').offset().left);\r\r\n\t\t\t\tvar navWidth = parseInt(jQuery('.es_prop_single_tabs').width());\r\r\n\t\t\t\tjQuery(window).scroll(function(e) { \r\r\n\t\t\t\t\tif(jQuery(this).scrollTop()>=navPos){\r\r\n\t\t\t\t\t\tjQuery('.es_prop_single_tabs').addClass('fixed');\r\r\n\t\t\t\t\t\tjQuery('.es_prop_single_tabs').css({'left':navPosLeft+'px','width':navWidth+'px'});\t\t\r\r\n\t\t\t\t\t} else {\r\r\n\t\t\t\t\t\tjQuery('.es_prop_single_tabs').removeClass('fixed');\r\r\n\t\t\t\t\t\tjQuery('.es_prop_single_tabs').css({'left':'0px','width':'auto'});\r\r\n\t\t\t\t\t}\r\r\n\t\t\t\t});\r\r\n\t\t\t });"; } echo " jQuery(document).ready(function(e) { \r\r\n\t\t\t\t\tvar pagerWidth = jQuery('#es_prop_single_pager_outer').width()/" . $es_settings->prop_singleview_photo_thumb_width . ";\r\r\n\t\t\t\t\tjQuery('.es_prop_single_pics').bxSlider({\r\r\n\t\t\t\t\t slideMargin: 0,\r\r\n\t\t\t\t\t controls: false,\r\r\n\t\t\t\t\t infiniteLoop: false,\r\r\n\t\t\t\t\t maxSlides: 1,\r\r\n\t\t\t\t\t pagerCustom: '.es_prop_single_pager'\r\r\n\t\t\t\t\t});\r\r\n\t\t\t\t\tjQuery('.es_prop_single_pager').bxSlider({\r\r\n\t\t\t\t\t slideWidth: " . $es_settings->prop_singleview_photo_thumb_width . ",\r\r\n\t\t\t\t\t slideMargin: 10,\r\r\n\t\t\t\t\t pager: false,\r\r\n\t\t\t\t\t infiniteLoop: false,\r\r\n\t\t\t\t\t minSlides: parseInt(pagerWidth),\r\r\n\t\t\t\t\t maxSlides: parseInt(pagerWidth),\r\r\n\t\t\t\t\t});\r\r\n\t\t\t\t\tjQuery('.es_prop_single_pager li a').each(function(index, element) {\r\r\n\t\t\t\t\t\tjQuery(this).attr('data-slide-index',index);\r\r\n\t\t\t\t\t});\r\r\n\t\t\t\t});"; echo "jQuery(function() {\r\r\n\t\t\t\tvar availableTags = ["; if (!empty($es_addresses)) { foreach ($es_addresses as $es_addres) { echo "'" . $es_addres->prop_address . "',"; } } echo "];\r\r\n\t\t\t\tjQuery( '.es_address_auto' ).autocomplete({\r\r\n\t\t\t\t\tsource: availableTags\r\r\n\t\t\t\t});\r\r\n\t\t\t});\r\r\n\t\t"; echo "\n</script>"; }
function get_images($listing_id) { global $wpdb; $image_sql = "SELECT prop_meta_value FROM {$wpdb->prefix}estatik_properties_meta \r\r\n WHERE prop_id={$listing_id} AND prop_meta_key = 'images'"; unset($uploaded_images, $image_url); $uploaded_images = $wpdb->get_row($image_sql); $uploaded_images_count = "0"; if (!empty($uploaded_images)) { $upload_image_data = unserialize($uploaded_images->prop_meta_value); $uploaded_images_count = count($upload_image_data); } if (!empty($uploaded_images) && !empty($upload_image_data)) { $upload_dir = wp_upload_dir(); $es_settings = es_front_settings(); $list_image_name = explode("/", $upload_image_data[0]); $list_image_name = end($list_image_name); $list_image_path = str_replace($list_image_name, "", $upload_image_data[0]); return array("{$upload_dir['baseurl']}{$list_image_path}{$list_image_name}", $uploaded_images_count); } return array(get_template_directory_uri() . "/images/placeholder_banner.png", 0); }
function es_prop_media_images() { $es_prop_id = sanitize_text_field($_GET['es_prop_id']); $uploadedfile = $_FILES['es_media_images']; $upload_dir = wp_upload_dir(); $save_image_array = array(); $es_settings = es_front_settings(); for ($i = 0; $i < count($uploadedfile['name']); $i++) { $es_extention = explode(".", $uploadedfile['name'][$i]); $es_extention = strtolower(end($es_extention)); if ($es_extention == "zip") { $file_name = time() . "_" . $uploadedfile['name'][$i]; $sourcePath = $uploadedfile['tmp_name'][$i]; $targetPath = $upload_dir['path'] . "/" . $file_name; move_uploaded_file($sourcePath, $targetPath); $zip = new ZipArchive(); $zip = zip_open($targetPath); if ($zip) { while ($zip_entry = zip_read($zip)) { $save_image_array[] = $upload_dir['subdir'] . "/" . zip_entry_name($zip_entry); } } $zip = new ZipArchive(); $res = $zip->open($targetPath); $zip->extractTo($upload_dir['path']); $zip->close(); @unlink($targetPath); } else { if ($_FILES["es_media_images"]["error"][$i] == 0) { $image_name = time() . "_" . $_FILES['es_media_images']['name'][$i]; $sourcePath = $_FILES['es_media_images']['tmp_name'][$i]; $targetPath = $upload_dir['path'] . "/" . $image_name; move_uploaded_file($sourcePath, $targetPath); es_crop($targetPath, $upload_dir['path'] . "/list_" . $image_name, $es_settings->prop_listview_list_width, $es_settings->prop_listview_list_height); es_crop($targetPath, $upload_dir['path'] . "/2column_" . $image_name, $es_settings->prop_listview_2column_width, $es_settings->prop_listview_2column_height); es_crop($targetPath, $upload_dir['path'] . "/table_" . $image_name, $es_settings->prop_listview_table_width, $es_settings->prop_listview_table_height); es_crop($targetPath, $upload_dir['path'] . "/single_lr_" . $image_name, $es_settings->prop_singleview_photo_lr_width, $es_settings->prop_singleview_photo_lr_height); es_crop($targetPath, $upload_dir['path'] . "/single_center_" . $image_name, $es_settings->prop_singleview_photo_center_width, $es_settings->prop_singleview_photo_center_height); es_crop($targetPath, $upload_dir['path'] . "/single_thumb_" . $image_name, $es_settings->prop_singleview_photo_thumb_width, $es_settings->prop_singleview_photo_thumb_height); $save_image_array[] = $upload_dir['subdir'] . "/" . $image_name; } } } global $wpdb; $old_images = ""; $prop_images = $wpdb->get_row('SELECT prop_meta_value FROM ' . $wpdb->prefix . 'estatik_properties_meta WHERE prop_id = ' . $es_prop_id . " and prop_meta_key = 'images'"); if (!empty($prop_images)) { $old_images = $prop_images->prop_meta_value; } $upload_image_data = array(); if ($old_images != "") { $old_image_data = unserialize($old_images); $upload_image_data = array_merge($old_image_data, $save_image_array); } else { $upload_image_data = $save_image_array; } $wpdb->query('delete from ' . $wpdb->prefix . 'estatik_properties_meta WHERE prop_id = ' . $es_prop_id . " and prop_meta_key = 'images'"); $wpdb->insert($wpdb->prefix . 'estatik_properties_meta', array('prop_id' => $es_prop_id, 'prop_meta_key' => 'images', 'prop_meta_value' => serialize($upload_image_data))); include "es_property_temps/es_property_images.php"; die; }
<?php $es_settings = es_front_settings(); ?> <?php if (is_search() || isset($_GET['s'])) { ?> <div class="es_success"><?php _e("Your search results.", 'es-plugin'); ?> </div> <?php } ?> <div class="es_my_listing clearfix"> <ul> <?php global $wpdb; $address = isset($_GET['address']) ? sanitize_text_field($_GET['address']) : ""; $country = isset($_GET['country']) ? sanitize_text_field($_GET['country']) : ""; $state = isset($_GET['state']) ? sanitize_text_field($_GET['state']) : ""; $city = isset($_GET['city']) ? sanitize_text_field($_GET['city']) : ""; $key_words = isset($_GET['key_words']) ? sanitize_text_field($_GET['key_words']) : ""; $agent = isset($_GET['agent']) ? sanitize_text_field($_GET['agent']) : ""; $type = isset($_GET['type']) ? sanitize_text_field($_GET['type']) : ""; $category = isset($_GET['category']) ? sanitize_text_field($_GET['category']) : "";