prefix}amazon_cache ORDER BY asin"; return $wpdb->get_results($query, ARRAY_A); } public static function formatExpireTime($expire) { $diff = $expire - time(); $days = (int) ($diff / 60 / 60 / 24); $diff = $diff - ($days * 60 * 60 * 24); $hours = (int) ($diff / 60 / 60); $diff = $diff - ($hours * 60 * 60); $minutes = (int) ($diff / 60); $diff = $diff - ($minutes * 60); $seconds = $diff; return "$days days $hours hours $minutes minutes"; } public static function delete($asin, $field = '') { if($asin == '') return; global $wpdb; $wpdb->escape_by_ref($asin); $where = "WHERE asin='$asin'"; if($field != '') { $wpdb->escape_by_ref($field); $where .= " AND field='$field'"; } $query = "DELETE FROM {$wpdb->prefix}amazon_cache $where"; return $wpdb->query($query); } } if(isset($_GET['action']) && $_GET['action'] == 'delete') { $delete_count = AmazonCache::delete($_GET['asin'], $_GET['field']); $row_str = ($delete_count > 1) ? 'rows' : 'row'; if($delete_count) $message = "$delete_count $row_str deleted."; } if($_SERVER['REQUEST_METHOD'] == 'POST') { if(isset($_POST['amazon_cache_delete'])) { //delete cache amazon_delete_cache(); $message = 'Cache Emptied'; } } $cache = AmazonCache::getCache(); $last_asin = ''; ?>

Cache



150) : ?>
ASIN Entry Name Entry Value Expires In Delete
Cache is empty
Delete All
Delete