
![]() |
|
Enable Location_Type searchWed, 08/08/2007 - 14:13
******************************************* /modules/location/location.inc $option_list[$row[tid]] = $row[name]; } returns array: which comprises the select option list on the proximity search form ********************************************* /modules/location/location.module ...edits to db queries to use Al's View instead of node table) Line 189: $query = 'SELECT v.Node_ID, l.*, '. earth_distance_sql($latlon['lon'], $latlon['lat'], 'l') .' as distance FROM {View_Pre_Radius_Query} v INNER JOIN {location} l ON v.Node_ID = l.eid WHERE v.Location_Type_ID = ' . $proximity_params['location_type'] . ' AND l.type =\'node\' AND l.latitude > %f AND l.latitude < %f AND l.longitude > %f AND l.longitude < %f AND '. earth_distance_sql($latlon['lon'], $latlon['lat']) .' < %f GROUP BY v.Node_ID ORDER by distance'; ... Line 205: $pager_count_query = 'SELECT COUNT(DISTINCT Node_ID) AS count FROM {View_Pre_Radius_Query} v INNER JOIN {location} l ON v.Node_ID = l.eid WHERE v.Location_Type_ID = ' . $proximity_params['location_type'] . ' AND l.type =\'node\' AND l.latitude > '. $latrange[0] .' AND l.latitude < '. $latrange[1] .' AND l.longitude > '. $lonrange[0] .' AND l.longitude < '. $lonrange[1] .' AND '. earth_distance_sql($latlon['lon'], $latlon['lat']) .' < '. $distance_float; Line 209: $pager_query = 'SELECT v.Node_ID, l.*, '. earth_distance_sql($latlon['lon'], $latlon['lat'], 'l') .' AS distance FROM {View_Pre_Radius_Query} v INNER JOIN {location} l ON v.Node_ID = l.eid WHERE v.Location_Type_ID = ' . $proximity_params['location_type'] . ' AND l.type =\'node\' AND l.latitude > '. $latrange[0] .' AND l.latitude < '. $latrange[1] .' AND l.longitude > '. $lonrange[0] .' AND l.longitude < '. $lonrange[1] .' AND '. earth_distance_sql($latlon['lon'], $latlon['lat']) .' < '. $distance_float .' GROUP BY v.Node_ID ORDER by distance'; ...... Line 274-9: $node = node_load($row->Node_ID); |
|
|
|
Post new comment