In Europe we use Kilometers instead of Miles. What should I change in the code to make the radius Kilometers? I could not find it. Would appreciate it very much.
To use kilometers its a pretty simple addition to the mysql query in the in_radius function in phpGoogleStoreLocator-functions.php. In the newer version I'm working on, KM is a switch that you can turn on/off in the settings table, it should be out sometime soonish.
Change Line 1258 from:
<?php $query="SELECT *,(((acos(sin(($lat*$pi/180)) * sin((lat*$pi/180)) + cos(($lat*$pi/180)) * cos((lat*$pi/180)) * cos((($lon - lon)*$pi/180))))*180/$pi)*60*1.423) as distance FROM locations HAVING distance <= $radius AND $category_search AND (expiration_date >= NOW() || expiration_date = '0000-00-00 00:00:00') ORDER BY distance ASC $results_limit"; ?>
To:
<?php $query="SELECT *,(((acos(sin(($lat*$pi/180)) * sin((lat*$pi/180)) + cos(($lat*$pi/180)) * cos((lat*$pi/180)) * cos((($lon - lon)*$pi/180))))*180/$pi)*60*1.423*1.85200) as distance FROM locations HAVING distance <= $radius AND $category_search AND (expiration_date >= NOW() || expiration_date = '0000-00-00 00:00:00') ORDER BY distance ASC $results_limit"; ?>
To use kilometers its a
To use kilometers its a pretty simple addition to the mysql query in the in_radius function in phpGoogleStoreLocator-functions.php. In the newer version I'm working on, KM is a switch that you can turn on/off in the settings table, it should be out sometime soonish.
Change Line 1258 from:
<?php$query="SELECT *,(((acos(sin(($lat*$pi/180)) * sin((lat*$pi/180)) + cos(($lat*$pi/180)) * cos((lat*$pi/180)) * cos((($lon - lon)*$pi/180))))*180/$pi)*60*1.423) as distance FROM locations HAVING distance <= $radius AND $category_search AND (expiration_date >= NOW() || expiration_date = '0000-00-00 00:00:00') ORDER BY distance ASC $results_limit";
?>
To:
<?php$query="SELECT *,(((acos(sin(($lat*$pi/180)) * sin((lat*$pi/180)) + cos(($lat*$pi/180)) * cos((lat*$pi/180)) * cos((($lon - lon)*$pi/180))))*180/$pi)*60*1.423*1.85200) as distance FROM locations HAVING distance <= $radius AND $category_search AND (expiration_date >= NOW() || expiration_date = '0000-00-00 00:00:00') ORDER BY distance ASC $results_limit";
?>