return 'http://www.facebook.com/login.php' === $url;
}
- function getAttachments($post_id) {
- $query = "select file.* from file join file_to_post on (file_id = file.id) join notice on (post_id = notice.id) where post_id = " . $this->escape($post_id);
- $this->query($query);
+ /**
+ * Get the attachments for a particlar notice.
+ *
+ * @param int $post_id
+ * @return array of File objects
+ */
+ static function getAttachments($post_id) {
+ $file = new File();
+ $query = "select file.* from file join file_to_post on (file_id = file.id) where post_id = " . $file->escape($post_id);
+ $file = Memcached_DataObject::cachedQuery('File', $query);
$att = array();
- while ($this->fetch()) {
- $att[] = clone($this);
+ while ($file->fetch()) {
+ $att[] = clone($file);
}
- $this->free();
return $att;
}
}
/**
+ * Go look at a URL and possibly save data about it if it's new:
+ * - follow redirect chains and store them in file_redirection
+ * - look up oEmbed data and save it in file_oembed
+ * - if a thumbnail is available, save it in file_thumbnail
+ * - save file record with basic info
+ * - optionally save a file_to_post record
+ * - return the File object with the full reference
+ *
* @fixme refactor this mess, it's gotten pretty scary.
- * @param bool $followRedirects
+ * @param string $given_url the URL we're looking at
+ * @param int $notice_id (optional)
+ * @param bool $followRedirects defaults to true
+ *
+ * @return mixed File on success, -1 on some errors
+ *
+ * @throws ServerException on some errors
*/
- function processNew($given_url, $notice_id=null, $followRedirects=true) {
+ public function processNew($given_url, $notice_id=null, $followRedirects=true) {
if (empty($given_url)) return -1; // error, no url to process
$given_url = File_redirection::_canonUrl($given_url);
if (empty($given_url)) return -1; // error, no url to process
{
return File_thumbnail::staticGet('file_id', $this->id);
}
+
+ /**
+ * Blow the cache of notices that link to this URL
+ *
+ * @param boolean $last Whether to blow the "last" cache too
+ *
+ * @return void
+ */
+
+ function blowCache($last=false)
+ {
+ self::blow('file:notice-ids:%s', $this->url);
+ if ($last) {
+ self::blow('file:notice-ids:%s;last', $this->url);
+ }
+ self::blow('file:notice-count:%d', $this->id);
+ }
+
+ /**
+ * Stream of notices linking to this URL
+ *
+ * @param integer $offset Offset to show; default is 0
+ * @param integer $limit Limit of notices to show
+ * @param integer $since_id Since this notice
+ * @param integer $max_id Before this notice
+ *
+ * @return array ids of notices that link to this file
+ */
+
+ function stream($offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
+ {
+ $stream = new FileNoticeStream($this);
+ return $stream->getNotices($offset, $limit, $since_id, $max_id);
+ }
+
+ function noticeCount()
+ {
+ $cacheKey = sprintf('file:notice-count:%d', $this->id);
+
+ $count = self::cacheGet($cacheKey);
+
+ if ($count === false) {
+
+ $f2p = new File_to_post();
+
+ $f2p->file_id = $this->id;
+
+ $count = $f2p->count();
+
+ self::cacheSet($cacheKey, $count);
+ }
+
+ return $count;
+ }
}