Changeset 26331 for extensions/rv_gmaps/trunk/admin/admin_boot.php
- Timestamp:
- Dec 29, 2013, 3:14:42 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/rv_gmaps/trunk/admin/admin_boot.php
r18951 r26331 31 31 { 32 32 if ($prefilter==="geotagged") 33 $query = 'lat IS NOT NULL AND lonIS NOT NULL';33 $query = 'latitude IS NOT NULL AND longitude IS NOT NULL'; 34 34 elseif ($prefilter==="not geotagged") 35 $query = 'lat IS NULL OR lonIS NULL';35 $query = 'latitude IS NULL OR longitude IS NULL'; 36 36 37 37 if ( isset($query) ) … … 74 74 if ( (double)$lat<=90 and (double)$lat>=-90 75 75 and (double)$lon<=180 and (double)$lon>=-180 ) 76 $update_query = 'lat ='.$lat.', lon='.$lon;76 $update_query = 'latitude='.$lat.', longitude='.$lon; 77 77 else 78 78 $page['errors'][] = 'Invalid lat or lon value'; 79 79 } 80 80 elseif ( strlen($lat)==0 and strlen($lon)==0 ) 81 $update_query = 'lat =NULL, lon=NULL';81 $update_query = 'latitude=NULL, longitude=NULL'; 82 82 else 83 83 $page['errors'][] = 'Both lat/lon must be empty or not empty'; … … 124 124 $data = array( 125 125 'id' => $row['id'], 126 'lat ' => trim($_POST['lat-'.$row['id']]),127 'lon ' => trim($_POST['lon-'.$row['id']])126 'latitude' => trim($_POST['lat-'.$row['id']]), 127 'longitude' => trim($_POST['lon-'.$row['id']]) 128 128 ); 129 129 130 if ( strlen($data['lat '])>0 and strlen($data['lon'])>0 )130 if ( strlen($data['latitude'])>0 and strlen($data['longitude'])>0 ) 131 131 { 132 if ( (double)$data['lat ']>90 or (double)$data['lat']<-90133 or (double)$data['lon ']>180 or (double)$data['lon']<-180 )132 if ( (double)$data['latitude']>90 or (double)$data['latitude']<-90 133 or (double)$data['longitude']>180 or (double)$data['longitude']<-180 ) 134 134 $error = true; 135 135 } 136 elseif ( strlen($data['lat '])==0 and strlen($data['lon'])==0 )136 elseif ( strlen($data['latitude'])==0 and strlen($data['longitude'])==0 ) 137 137 { 138 138 // nothing … … 153 153 array( 154 154 'primary' => array('id'), 155 'update' => array('lat ', 'lon')155 'update' => array('latitude', 'longitude') 156 156 ), 157 157 $datas … … 183 183 <td> 184 184 <label>{\'Latitude\'|@translate} 185 <input type="text" size="8" name="lat-{$element.id}" value="{$element.lat }">185 <input type="text" size="8" name="lat-{$element.id}" value="{$element.latitude}"> 186 186 </label> 187 187 <label>{\'Longitude\'|@translate} 188 <input type="text" size="9" name="lon-{$element.id}" value="{$element.lon }">188 <input type="text" size="9" name="lon-{$element.id}" value="{$element.longitude}"> 189 189 </label> 190 190 </td>
Note: See TracChangeset
for help on using the changeset viewer.