Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (1)

Resolved Users Near Me

  1. peacetree
    peacetree
  2. Support
  3. Friday, April 12 2019, 10:30 AM
I found a solution in the forum to show users that are located near me but I dont get it to work.

( 6371 * acos( cos( radians({user map_alias_lat raw}) ) * cos( radians( b.`map_lat` ) ) * cos( radians( b.`map_lng` ) - radians({user map_alias_lng raw}) ) + sin( radians({user map_alias_lat raw}) ) * sin( radians( b.`map_lat` ) ) ) ) < 20


I replaced "map_alias with the alias of my geo field and placed that string into the custom SQL field in user lists module (also tried in maps).


Thank you
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
have you also changed map_lat and map_lng with the alias of field? for example if your field have alias like "address" then the SQL code will be something like:

( 6371 * acos( cos( radians({user address_lat raw}) ) * cos( radians( b.`address_lat` ) ) * cos( radians( b.`address_lng` ) - radians({user address_lng raw}) ) + sin( radians({user address_lat raw}) ) * sin( radians( b.`address_lat` ) ) ) ) < 20
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (1)
peacetree
peacetree Accepted Answer
Of course... thank you.
  1. more than a month ago
  2. Support
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.