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; }