GeoDirectory / geodirectory

geodirectory-functions/custom_functions.php

Indentation +203 added lines, -203 removed lines

@@ -2362,10 +2362,10 @@ 
 	?>

 	<input class="search_text" name="s"

 	       value="<?php if ( isset( $_REQUEST['s'] ) && trim( $_REQUEST['s'] ) != '' ) {

-		       echo esc_attr( stripslashes_deep( $_REQUEST['s'] ) );

-	       } else {

-		       echo $default_search_for_text;

-	       } ?>" type="text"

+			   echo esc_attr( stripslashes_deep( $_REQUEST['s'] ) );

+		   } else {

+			   echo $default_search_for_text;

+		   } ?>" type="text"

 	       onblur="if (this.value.trim() == '') {this.value = '<?php echo esc_sql( $default_search_for_text ); ?>';}"

 	       onfocus="if (this.value == '<?php echo esc_sql( $default_search_for_text ); ?>') {this.value = '';}"

 	       onkeydown="javascript: if(event.keyCode == 13) geodir_click_search(this);">

@@ -2492,11 +2492,11 @@ 
  * @return True if WPML is active else False.

  */

 function geodir_is_wpml() {

-    if (function_exists('icl_object_id')) {

-        return true;

-    }

+	if (function_exists('icl_object_id')) {

+		return true;

+	}

 

-    return false;

+	return false;

 }

 

 /**

@@ -2511,9 +2511,9 @@ 
  * @return Language code.

  */

 function geodir_get_language_for_element($element_id, $element_type) {

-    global $sitepress;

+	global $sitepress;

 

-    return $sitepress->get_language_for_element($element_id, $element_type);

+	return $sitepress->get_language_for_element($element_id, $element_type);

 }

 

 /**

@@ -2530,31 +2530,31 @@ 
  *                         Added to fix duplicate transaltion for front end.

  */

 function geodir_icl_make_duplicate($master_post_id, $lang, $postarr, $tr_post_id, $after_save = false) {

-    global $sitepress;

+	global $sitepress;

     

-    $post_type = get_post_type($master_post_id);

-    $icl_ajx_action = !empty($_REQUEST['icl_ajx_action']) && $_REQUEST['icl_ajx_action'] == 'make_duplicates' ? true : false;

-    if (!empty($_REQUEST['action']) && $_REQUEST['action'] == 'wpml_duplicate_dashboard' && !empty($_REQUEST['duplicate_post_ids'])) {

-        $icl_ajx_action = true;

-    }

+	$post_type = get_post_type($master_post_id);

+	$icl_ajx_action = !empty($_REQUEST['icl_ajx_action']) && $_REQUEST['icl_ajx_action'] == 'make_duplicates' ? true : false;

+	if (!empty($_REQUEST['action']) && $_REQUEST['action'] == 'wpml_duplicate_dashboard' && !empty($_REQUEST['duplicate_post_ids'])) {

+		$icl_ajx_action = true;

+	}

     

-    if (in_array($post_type, geodir_get_posttypes())) {

-        if ($icl_ajx_action || $after_save) {

-            // Duplicate post details

-            geodir_icl_duplicate_post_details($master_post_id, $tr_post_id, $lang);

+	if (in_array($post_type, geodir_get_posttypes())) {

+		if ($icl_ajx_action || $after_save) {

+			// Duplicate post details

+			geodir_icl_duplicate_post_details($master_post_id, $tr_post_id, $lang);

             

-            // Duplicate taxonomies

-            geodir_icl_duplicate_taxonomies($master_post_id, $tr_post_id, $lang);

+			// Duplicate taxonomies

+			geodir_icl_duplicate_taxonomies($master_post_id, $tr_post_id, $lang);

             

-            // Duplicate post images

-            geodir_icl_duplicate_post_images($master_post_id, $tr_post_id, $lang);

-        }

+			// Duplicate post images

+			geodir_icl_duplicate_post_images($master_post_id, $tr_post_id, $lang);

+		}

         

-        // Sync post reviews

-        if ($sitepress->get_setting('sync_comments_on_duplicates')) {

-            geodir_wpml_duplicate_post_reviews($master_post_id, $tr_post_id, $lang);

-        }

-    }

+		// Sync post reviews

+		if ($sitepress->get_setting('sync_comments_on_duplicates')) {

+			geodir_wpml_duplicate_post_reviews($master_post_id, $tr_post_id, $lang);

+		}

+	}

 }

 add_filter( 'icl_make_duplicate', 'geodir_icl_make_duplicate', 11, 4 );

 

@@ -2568,18 +2568,18 @@ 
  * @param array $request_info The post details in an array.

  */

 function geodir_wpml_duplicate_listing($post_id, $request_info) {

-    global $sitepress;

+	global $sitepress;

     

-    $icl_ajx_action = !empty($_REQUEST['icl_ajx_action']) && $_REQUEST['icl_ajx_action'] == 'make_duplicates' ? true : false;

-    if (!empty($_REQUEST['action']) && $_REQUEST['action'] == 'wpml_duplicate_dashboard' && !empty($_REQUEST['duplicate_post_ids'])) {

-        $icl_ajx_action = true;

-    }

+	$icl_ajx_action = !empty($_REQUEST['icl_ajx_action']) && $_REQUEST['icl_ajx_action'] == 'make_duplicates' ? true : false;

+	if (!empty($_REQUEST['action']) && $_REQUEST['action'] == 'wpml_duplicate_dashboard' && !empty($_REQUEST['duplicate_post_ids'])) {

+		$icl_ajx_action = true;

+	}

     

-    if (!$icl_ajx_action && in_array(get_post_type($post_id), geodir_get_posttypes()) && $post_duplicates = $sitepress->get_duplicates($post_id)) {

-        foreach ($post_duplicates as $lang => $dup_post_id) {

-            geodir_icl_make_duplicate($post_id, $lang, $request_info, $dup_post_id, true);

-        }

-    }

+	if (!$icl_ajx_action && in_array(get_post_type($post_id), geodir_get_posttypes()) && $post_duplicates = $sitepress->get_duplicates($post_id)) {

+		foreach ($post_duplicates as $lang => $dup_post_id) {

+			geodir_icl_make_duplicate($post_id, $lang, $request_info, $dup_post_id, true);

+		}

+	}

 }

 

 /**

@@ -2595,17 +2595,17 @@ 
  * @return bool True for success, False for fail.

  */

 function geodir_wpml_duplicate_post_reviews($master_post_id, $tr_post_id, $lang) {

-    global $wpdb;

+	global $wpdb;

 

-    $reviews = $wpdb->get_results($wpdb->prepare("SELECT comment_id FROM " . GEODIR_REVIEW_TABLE . " WHERE post_id=%d ORDER BY id ASC", $master_post_id), ARRAY_A);

+	$reviews = $wpdb->get_results($wpdb->prepare("SELECT comment_id FROM " . GEODIR_REVIEW_TABLE . " WHERE post_id=%d ORDER BY id ASC", $master_post_id), ARRAY_A);

 

-    if (!empty($reviews)) {

-        foreach ($reviews as $review) {

-            geodir_wpml_duplicate_post_review($review['comment_id'], $master_post_id, $tr_post_id, $lang);

-        }

-    }

+	if (!empty($reviews)) {

+		foreach ($reviews as $review) {

+			geodir_wpml_duplicate_post_review($review['comment_id'], $master_post_id, $tr_post_id, $lang);

+		}

+	}

 

-    return false;

+	return false;

 }

 

 /**

@@ -2622,22 +2622,22 @@ 
  * @return bool True for success, False for fail.

  */

 function geodir_icl_duplicate_post_details($master_post_id, $tr_post_id, $lang) {

-    global $wpdb, $plugin_prefix;

+	global $wpdb, $plugin_prefix;

 

-    $post_type = get_post_type($master_post_id);

-    $post_table = $plugin_prefix . $post_type . '_detail';

+	$post_type = get_post_type($master_post_id);

+	$post_table = $plugin_prefix . $post_type . '_detail';

 

-    $query = $wpdb->prepare("SELECT * FROM " . $post_table . " WHERE post_id = %d", array($master_post_id));

-    $data = (array)$wpdb->get_row($query);

+	$query = $wpdb->prepare("SELECT * FROM " . $post_table . " WHERE post_id = %d", array($master_post_id));

+	$data = (array)$wpdb->get_row($query);

 

-    if ( !empty( $data ) ) {

-        $data['post_id'] = $tr_post_id;

-        unset($data['default_category'], $data['marker_json'], $data['featured_image'], $data[$post_type . 'category']);

-        $wpdb->update($post_table, $data, array('post_id' => $tr_post_id));

-        return true;

-    }

+	if ( !empty( $data ) ) {

+		$data['post_id'] = $tr_post_id;

+		unset($data['default_category'], $data['marker_json'], $data['featured_image'], $data[$post_type . 'category']);

+		$wpdb->update($post_table, $data, array('post_id' => $tr_post_id));

+		return true;

+	}

 

-    return false;

+	return false;

 }

 

 /**

@@ -2654,40 +2654,40 @@ 
  * @return bool True for success, False for fail.

  */

 function geodir_icl_duplicate_taxonomies($master_post_id, $tr_post_id, $lang) {

-    global $sitepress, $wpdb;

-    $post_type = get_post_type($master_post_id);

+	global $sitepress, $wpdb;

+	$post_type = get_post_type($master_post_id);

 

-    remove_filter('get_term', array($sitepress,'get_term_adjust_id')); // AVOID filtering to current language

+	remove_filter('get_term', array($sitepress,'get_term_adjust_id')); // AVOID filtering to current language

 

-    $taxonomies = get_object_taxonomies($post_type);

-    foreach ($taxonomies as $taxonomy) {

-        $terms = get_the_terms($master_post_id, $taxonomy);

-        $terms_array = array();

+	$taxonomies = get_object_taxonomies($post_type);

+	foreach ($taxonomies as $taxonomy) {

+		$terms = get_the_terms($master_post_id, $taxonomy);

+		$terms_array = array();

         

-        if ($terms) {

-            foreach ($terms as $term) {

-                $tr_id = apply_filters( 'translate_object_id',$term->term_id, $taxonomy, false, $lang);

+		if ($terms) {

+			foreach ($terms as $term) {

+				$tr_id = apply_filters( 'translate_object_id',$term->term_id, $taxonomy, false, $lang);

                 

-                if (!is_null($tr_id)){

-                    // not using get_term - unfiltered get_term

-                    $translated_term = $wpdb->get_row($wpdb->prepare("

+				if (!is_null($tr_id)){

+					// not using get_term - unfiltered get_term

+					$translated_term = $wpdb->get_row($wpdb->prepare("

                         SELECT * FROM {$wpdb->terms} t JOIN {$wpdb->term_taxonomy} x ON x.term_id = t.term_id WHERE t.term_id = %d AND x.taxonomy = %s", $tr_id, $taxonomy));

 

-                    $terms_array[] = $translated_term->term_id;

-                }

-            }

+					$terms_array[] = $translated_term->term_id;

+				}

+			}

 

-            if (!is_taxonomy_hierarchical($taxonomy)){

-                $terms_array = array_unique( array_map( 'intval', $terms_array ) );

-            }

+			if (!is_taxonomy_hierarchical($taxonomy)){

+				$terms_array = array_unique( array_map( 'intval', $terms_array ) );

+			}

 

-            wp_set_post_terms($tr_post_id, $terms_array, $taxonomy);

+			wp_set_post_terms($tr_post_id, $terms_array, $taxonomy);

             

-            if ($taxonomy == $post_type . 'category') {

-                geodir_set_postcat_structure($tr_post_id, $post_type . 'category');

-            }

-        }

-    }

+			if ($taxonomy == $post_type . 'category') {

+				geodir_set_postcat_structure($tr_post_id, $post_type . 'category');

+			}

+		}

+	}

 }

 

 /**

@@ -2703,29 +2703,29 @@ 
  * @return bool True for success, False for fail.

  */

 function geodir_icl_duplicate_post_images($master_post_id, $tr_post_id, $lang) {

-    global $wpdb;

+	global $wpdb;

 

-    $query = $wpdb->prepare("DELETE FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE mime_type like %s AND post_id = %d", array('%image%', $tr_post_id));

-    $wpdb->query($query);

+	$query = $wpdb->prepare("DELETE FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE mime_type like %s AND post_id = %d", array('%image%', $tr_post_id));

+	$wpdb->query($query);

 

-    $query = $wpdb->prepare("SELECT * FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE mime_type like %s AND post_id = %d ORDER BY menu_order ASC", array('%image%', $master_post_id));

-    $post_images = $wpdb->get_results($query);

+	$query = $wpdb->prepare("SELECT * FROM " . GEODIR_ATTACHMENT_TABLE . " WHERE mime_type like %s AND post_id = %d ORDER BY menu_order ASC", array('%image%', $master_post_id));

+	$post_images = $wpdb->get_results($query);

 

-    if ( !empty( $post_images ) ) {

-        foreach ( $post_images as $post_image) {

-            $image_data = (array)$post_image;

-            unset($image_data['ID']);

-            $image_data['post_id'] = $tr_post_id;

+	if ( !empty( $post_images ) ) {

+		foreach ( $post_images as $post_image) {

+			$image_data = (array)$post_image;

+			unset($image_data['ID']);

+			$image_data['post_id'] = $tr_post_id;

             

-            $wpdb->insert(GEODIR_ATTACHMENT_TABLE, $image_data);

+			$wpdb->insert(GEODIR_ATTACHMENT_TABLE, $image_data);

             

-            geodir_set_wp_featured_image($tr_post_id);

-        }

+			geodir_set_wp_featured_image($tr_post_id);

+		}

         

-        return true;

-    }

+		return true;

+	}

 

-    return false;

+	return false;

 }

 

 

@@ -2744,73 +2744,73 @@ 
  * @return bool True for success, False for fail.

  */

 function geodir_wpml_duplicate_post_review($master_comment_id, $master_post_id, $tr_post_id, $lang) {

-    global $wpdb, $plugin_prefix, $sitepress;

-

-    $review = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . GEODIR_REVIEW_TABLE . " WHERE comment_id=%d ORDER BY id ASC", $master_comment_id), ARRAY_A);

-

-    if (empty($review)) {

-        return false;

-    }

-    if ($review['post_id'] != $master_post_id) {

-        $wpdb->query($wpdb->prepare("UPDATE " . GEODIR_REVIEW_TABLE . " SET post_id=%d WHERE comment_id=%d", $master_post_id, $master_comment_id));

-        geodir_update_postrating($master_post_id, $post_type);

-    }

-

-    $tr_comment_id = geodir_wpml_duplicate_comment_exists($tr_post_id, $master_comment_id);

-

-    if (empty($tr_comment_id)) {

-        return false;

-    }

-

-    $post_type = get_post_type($master_post_id);

-    $post_table = $plugin_prefix . $post_type . '_detail';

-

-    $translated_post = $wpdb->get_row($wpdb->prepare("SELECT post_title, post_latitude, post_longitude, post_city, post_region, post_country FROM " . $post_table . " WHERE post_id = %d", $tr_post_id), ARRAY_A);

-    if (empty($translated_post)) {

-        return false;

-    }

-

-    $review['comment_id'] = $tr_comment_id;

-    $review['post_id'] = $tr_post_id;

-    $review['post_title'] = $translated_post['post_title'];

-    $review['post_city'] = $translated_post['post_city'];

-    $review['post_region'] = $translated_post['post_region'];

-    $review['post_country'] = $translated_post['post_country'];

-    $review['post_latitude'] = $translated_post['post_latitude'];

-    $review['post_longitude'] = $translated_post['post_longitude'];

-

-    if (isset($review['id'])) {

-        unset($review['id']);

-    }

-

-    $tr_review_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM " . GEODIR_REVIEW_TABLE . " WHERE comment_id=%d AND post_id=%d ORDER BY id ASC", $tr_comment_id, $tr_post_id));

-

-    if ($tr_review_id) { // update review

-        $wpdb->update(GEODIR_REVIEW_TABLE, $review, array('id' => $tr_review_id));

-    } else { // insert review

-        $wpdb->insert(GEODIR_REVIEW_TABLE, $review);

-        $tr_review_id = $wpdb->insert_id;

-    }

-

-    if ($tr_post_id) {

-        geodir_update_postrating($tr_post_id, $post_type);

+	global $wpdb, $plugin_prefix, $sitepress;

+

+	$review = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . GEODIR_REVIEW_TABLE . " WHERE comment_id=%d ORDER BY id ASC", $master_comment_id), ARRAY_A);

+

+	if (empty($review)) {

+		return false;

+	}

+	if ($review['post_id'] != $master_post_id) {

+		$wpdb->query($wpdb->prepare("UPDATE " . GEODIR_REVIEW_TABLE . " SET post_id=%d WHERE comment_id=%d", $master_post_id, $master_comment_id));

+		geodir_update_postrating($master_post_id, $post_type);

+	}

+

+	$tr_comment_id = geodir_wpml_duplicate_comment_exists($tr_post_id, $master_comment_id);

+

+	if (empty($tr_comment_id)) {

+		return false;

+	}

+

+	$post_type = get_post_type($master_post_id);

+	$post_table = $plugin_prefix . $post_type . '_detail';

+

+	$translated_post = $wpdb->get_row($wpdb->prepare("SELECT post_title, post_latitude, post_longitude, post_city, post_region, post_country FROM " . $post_table . " WHERE post_id = %d", $tr_post_id), ARRAY_A);

+	if (empty($translated_post)) {

+		return false;

+	}

+

+	$review['comment_id'] = $tr_comment_id;

+	$review['post_id'] = $tr_post_id;

+	$review['post_title'] = $translated_post['post_title'];

+	$review['post_city'] = $translated_post['post_city'];

+	$review['post_region'] = $translated_post['post_region'];

+	$review['post_country'] = $translated_post['post_country'];

+	$review['post_latitude'] = $translated_post['post_latitude'];

+	$review['post_longitude'] = $translated_post['post_longitude'];

+

+	if (isset($review['id'])) {

+		unset($review['id']);

+	}

+

+	$tr_review_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM " . GEODIR_REVIEW_TABLE . " WHERE comment_id=%d AND post_id=%d ORDER BY id ASC", $tr_comment_id, $tr_post_id));

+

+	if ($tr_review_id) { // update review

+		$wpdb->update(GEODIR_REVIEW_TABLE, $review, array('id' => $tr_review_id));

+	} else { // insert review

+		$wpdb->insert(GEODIR_REVIEW_TABLE, $review);

+		$tr_review_id = $wpdb->insert_id;

+	}

+

+	if ($tr_post_id) {

+		geodir_update_postrating($tr_post_id, $post_type);

         

-        if (defined('GEODIRREVIEWRATING_VERSION') && get_option('geodir_reviewrating_enable_review') && $sitepress->get_setting('sync_comments_on_duplicates')) {

-            $wpdb->query($wpdb->prepare("DELETE FROM " . GEODIR_COMMENTS_REVIEWS_TABLE . " WHERE comment_id = %d", array($tr_comment_id)));

-            $likes = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . GEODIR_COMMENTS_REVIEWS_TABLE . " WHERE comment_id=%d ORDER BY like_date ASC", $master_comment_id, $tr_post_id), ARRAY_A);

-

-            if (!empty($likes)) {

-                foreach ($likes as $like) {

-                    unset($like['like_id']);

-                    $like['comment_id'] = $tr_comment_id;

+		if (defined('GEODIRREVIEWRATING_VERSION') && get_option('geodir_reviewrating_enable_review') && $sitepress->get_setting('sync_comments_on_duplicates')) {

+			$wpdb->query($wpdb->prepare("DELETE FROM " . GEODIR_COMMENTS_REVIEWS_TABLE . " WHERE comment_id = %d", array($tr_comment_id)));

+			$likes = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . GEODIR_COMMENTS_REVIEWS_TABLE . " WHERE comment_id=%d ORDER BY like_date ASC", $master_comment_id, $tr_post_id), ARRAY_A);

+

+			if (!empty($likes)) {

+				foreach ($likes as $like) {

+					unset($like['like_id']);

+					$like['comment_id'] = $tr_comment_id;

                     

-                    $wpdb->insert(GEODIR_COMMENTS_REVIEWS_TABLE, $like);

-                }

-            }

-        }

-    }

+					$wpdb->insert(GEODIR_COMMENTS_REVIEWS_TABLE, $like);

+				}

+			}

+		}

+	}

 

-    return $tr_review_id;

+	return $tr_review_id;

 }

 

 /**

@@ -2825,36 +2825,36 @@ 
  * @param int $comment_id The Comment ID.

  */

 function gepdir_wpml_sync_comment($comment_id) {

-    global $wpdb, $sitepress, $gd_wpml_posttypes;

-

-    if (empty($gd_post_types)) {

-        $gd_wpml_posttypes = geodir_get_posttypes();

-    }

-

-    $comment = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->comments} WHERE comment_ID=%d", $comment_id), ARRAY_A);

-    if (empty($comment)) {

-        return;

-    }

-

-    $post_id = $comment['comment_post_ID'];

-    $post_type = $post_id ? get_post_type($post_id) : NULL;

-

-    if (!($post_type && in_array($post_type, $gd_wpml_posttypes))) {

-        return;

-    }

-

-    $post_duplicates = $sitepress->get_duplicates($post_id);

-    if (empty($post_duplicates)) {

-        return;

-    }

-

-    foreach ($post_duplicates as $lang => $dup_post_id) {

-        if (empty($comment['comment_parent'])) {

-            geodir_wpml_duplicate_post_review($comment_id, $post_id, $dup_post_id, $lang);

-        }

-    }

+	global $wpdb, $sitepress, $gd_wpml_posttypes;

+

+	if (empty($gd_post_types)) {

+		$gd_wpml_posttypes = geodir_get_posttypes();

+	}

+

+	$comment = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->comments} WHERE comment_ID=%d", $comment_id), ARRAY_A);

+	if (empty($comment)) {

+		return;

+	}

+

+	$post_id = $comment['comment_post_ID'];

+	$post_type = $post_id ? get_post_type($post_id) : NULL;

+

+	if (!($post_type && in_array($post_type, $gd_wpml_posttypes))) {

+		return;

+	}

+

+	$post_duplicates = $sitepress->get_duplicates($post_id);

+	if (empty($post_duplicates)) {

+		return;

+	}

+

+	foreach ($post_duplicates as $lang => $dup_post_id) {

+		if (empty($comment['comment_parent'])) {

+			geodir_wpml_duplicate_post_review($comment_id, $post_id, $dup_post_id, $lang);

+		}

+	}

     

-    return true;

+	return true;

 }

 

 /**

@@ -2869,11 +2869,11 @@ 
  * @return int The duplicate comment ID.

  */

 function geodir_wpml_duplicate_comment_exists($dup_post_id, $original_cid) {

-    global $wpdb;

+	global $wpdb;

 

-    $duplicate = $wpdb->get_var(

-        $wpdb->prepare(

-            "   SELECT comm.comment_ID

+	$duplicate = $wpdb->get_var(

+		$wpdb->prepare(

+			"   SELECT comm.comment_ID

                 FROM {$wpdb->comments} comm

                 JOIN {$wpdb->commentmeta} cm

                     ON comm.comment_ID = cm.comment_id

@@ -2881,12 +2881,12 @@ 
                     AND cm.meta_key = '_icl_duplicate_of'

                     AND cm.meta_value = %d

                 LIMIT 1",

-            $dup_post_id,

-            $original_cid

-        )

-    );

+			$dup_post_id,

+			$original_cid

+		)

+	);

 

-    return $duplicate;

+	return $duplicate;

 }

 

 /**