Post by distance using "Post's custom Fields latitude & longitude " in wordpress

Just Copy the below query to find post on the basis of distance by using Post's custom field latitude & logitude.


"SELECT p.*, pm1.meta_value as lat, pm2.meta_value as lon, ACOS(SIN(RADIANS($lat))*SIN(RADIANS(pm1.meta_value))+COS(RADIANS($lat))*
COS(RADIANS(pm1.meta_value))*COS(RADIANS(pm2.meta_value)-RADIANS($long))) * 3959 AS distance FROM wp_posts p
INNER join wp_term_relationships on wp_term_relationships.object_id=p.id and wp_term_relationships.term_taxonomy_id= $catid
INNER JOIN wp_postmeta pm1 ON p.id = pm1.post_id AND pm1.meta_key = 'latitude'
INNER JOIN wp_postmeta pm2 ON p.id = pm2.post_id AND pm2.meta_key = 'longitude'
where post_status = 'publish'  having distance < 270
ORDER BY distance ASC "

Change password function in wordpress

function wp_set_password($password,$user_id)
{
       global $wpdb;
       $newpassword = ltrim( $_POST['newpassword']) ;
       $hash = wp_hash_password( $newPassword ) ;
       $wpdb->update( $wpdb->users, array('user_pass' => $hash , 'user_activation_key' => '') , array('ID' => $user_id )) ;

        wp_cache_delete($user_id,'users');
}

Loading overlay before page complete load

Place the below code at the top of  your respective page and copy image to your image folder.
Then load your page again.


<style>
 .progress-indicator {
   top:0;
   right:0;
   width:100%;
   height:100%;
   position:fixed;
   text-align:center;
   /* IE filter */
   filter: progid:DXImageTransform.Microsoft.Alpha(opacity=50);
   -moz-opacity:1.0;    /* Mozilla extension */
   -khtml-opacity:1.0;  /* Safari/Conqueror extension */
   opacity:1.0; /* CSS3 */
   z-index:1000;
   background-color:white;
   display:none;
 }

 .progress-indicator img {
   margin-top:150px;
 }
 .progress-indicator h1 {
   font-size:16px;
   font-weight:bold;
   margin-top:50px;
 }
</style>

<div class="progress-indicator">
   <img src="/images/icon_loading_75x75.gif'" alt="" />
   <h1>Loading.....</h1>
</div>

<script>
jQuery(document).ready(function() {
    jQuery('.progress-indicator').show();
    jQuery(window).load(function() { jQuery('.progress-indicator').hide(); });
});
</script>