Changeset 1443535

Timestamp:

06/26/2016 06:42:32 AM (10 years ago)

Author:

drobertsorg

Message:

Fixed cache bug where retrieved date wasn't updating

File:

• wp-legisearch/trunk/os-client/WpJsonCacheable.class.php (modified) (5 diffs)

wp-legisearch/trunk/os-client/WpJsonCacheable.class.php

@@ -29 +29 @@
         $sql = "SELECT * FROM {$this->cacheTableName} WHERE url = '{$url}';";
         $result = $wpdb->get_row( $sql );
-        if( $wpdb->num_rows > 0 && strtotime( $result->retrieved ) >= strtotime( "- {$this->cacheTimeout} hours" ) ) {
+
+        if( $wpdb->num_rows > 0 && ( strtotime( $result->retrieved ) >= strtotime( "- {$this->cacheTimeout} hours" ) ) ) {
             // Cache match and it's fresh
             return $result->data;
@@ -44 +45 @@
                 array(      // data
                     'url' => $url,
-                    'data' => $json
+                    'data' => $json,
+                    'retrieved' => current_time( 'mysql' )
                 ),
                 array(      // where
@@ -52 +54 @@
                     '%s',
                     '%s',
+                    '%s'
                 ),
                 array(      // where format
@@ -68 +71 @@
                 array(      // data
                     'url' => $url,
-                    'data' => $json
+                    'data' => $json,
+                    'retrieved' => current_time( 'mysql' )
                 ),
                 array(      // data format
                     '%s',
                     '%s',
+                    '%s'
                 )
             );
@@ -87 +92 @@
     }
 }
+