Function Reference: geodir_filter_widget_listings_fields_set

Summary

Filters the Field clause of the query.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

Package

GeoDirectory_Location_Manager

Parameters

$fields

(string) (required) Fields string.

Default: None

$table

(string) (required) Table name.

Default: None

Return Values

(string)

• Filtered field clause.

Change Log

Since: 1.0.0

Source File

geodir_filter_widget_listings_fields_set() is located in geodir_location_manager/geodir_location_hooks_actions.php [Line: 1483]

Source Code

function geodir_filter_widget_listings_fields_set($fields,$table){
	// my location set start
	if(isset($_SESSION['all_near_me'])){
		global $wpdb;
	$mylat = $_SESSION['user_lat'];
	$mylon = $_SESSION['user_lon'];
	$DistanceRadius = geodir_getDistanceRadius(get_option('geodir_search_dist_1'));
	$fields .= $wpdb->prepare(" , (".$DistanceRadius." * 2 * ASIN(SQRT( POWER(SIN((ABS(%s) - ABS(".$table.".post_latitude)) * pi()/180 / 2), 2) +COS(ABS(%s) * pi()/180) * COS( ABS(".$table.".post_latitude) * pi()/180) *POWER(SIN((%s - ".$table.".post_longitude) * pi()/180 / 2), 2) )))as distance ",$mylat,$mylat,$mylon);
	}
	return $fields;	
}