/** * Answer true if the cache of the feed is current. * * @param string $url * @return boolean * @access protected * @since 7/8/08 */ protected function isCacheCurrent($url) { $dbc = Services::getService("DatabaseManager"); $query = new SelectQuery(); $query->addTable('segue_plugins_rssfeed_cache'); $query->addColumn('COUNT(*)', 'num'); $query->addWhereEqual('url', $url); $query->addWhereRawGreaterThan('cache_time', $dbc->toDBDate(DateAndTime::now()->minus(Duration::withSeconds(600)), IMPORTER_CONNECTION)); try { $result = $dbc->query($query, IMPORTER_CONNECTION); } catch (NoSuchTableDatabaseException $e) { return false; } $num = intval($result->field('num')); $result->free(); if ($num > 0) { return true; } else { return false; } }