I have multiple installations of Oxwall and users are common for all sites.On main site i show all users on Browse Users page but on other ,city related, sites( subdomains) i would like to show users only from specific city.
Right now user location is in table googlelocation_data and specific field is address( example Toronto, ON, Canada) so it should be type of select statement that finds all users whose address field matches Toronto,ON,Canada and then that lists is used to filter users in users.php -->protected function process( $list, $showOnline )
There is need to check all three parts of address since it could be two cities with same name in State(ON) or Country( Canada).