define('MAX_BOXCARS', 128);
-class Notice extends Memcached_DataObject
+class Notice extends Managed_DataObject
{
###START_AUTOCODE
/* the code below is auto generated do not remove the above tag */
public $location_id; // int(4)
public $location_ns; // int(4)
public $repeat_of; // int(4)
+ public $verb; // varchar(255)
public $object_type; // varchar(255)
public $scope; // int(4)
/* the code above is auto generated do not remove the tag below */
###END_AUTOCODE
+ public static function schemaDef()
+ {
+ $def = array(
+ 'fields' => array(
+ 'id' => array('type' => 'serial', 'not null' => true, 'description' => 'unique identifier'),
+ 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'who made the update'),
+ 'uri' => array('type' => 'varchar', 'length' => 255, 'description' => 'universally unique identifier, usually a tag URI'),
+ 'content' => array('type' => 'text', 'description' => 'update content', 'collate' => 'utf8_general_ci'),
+ 'rendered' => array('type' => 'text', 'description' => 'HTML version of the content'),
+ 'url' => array('type' => 'varchar', 'length' => 255, 'description' => 'URL of any attachment (image, video, bookmark, whatever)'),
+ 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
+ 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
+ 'reply_to' => array('type' => 'int', 'description' => 'notice replied to (usually a guess)'),
+ 'is_local' => array('type' => 'int', 'size' => 'tiny', 'default' => 0, 'description' => 'notice was generated by a user'),
+ 'source' => array('type' => 'varchar', 'length' => 32, 'description' => 'source of comment, like "web", "im", or "clientname"'),
+ 'conversation' => array('type' => 'int', 'description' => 'id of root notice in this conversation'),
+ 'lat' => array('type' => 'numeric', 'precision' => 10, 'scale' => 7, 'description' => 'latitude'),
+ 'lon' => array('type' => 'numeric', 'precision' => 10, 'scale' => 7, 'description' => 'longitude'),
+ 'location_id' => array('type' => 'int', 'description' => 'location id if possible'),
+ 'location_ns' => array('type' => 'int', 'description' => 'namespace for location'),
+ 'repeat_of' => array('type' => 'int', 'description' => 'notice this is a repeat of'),
+ 'object_type' => array('type' => 'varchar', 'length' => 255, 'description' => 'URI representing activity streams object type', 'default' => 'http://activitystrea.ms/schema/1.0/note'),
+ 'verb' => array('type' => 'varchar', 'length' => 255, 'description' => 'URI representing activity streams verb', 'default' => 'http://activitystrea.ms/schema/1.0/post'),
+ 'scope' => array('type' => 'int',
+ 'description' => 'bit map for distribution scope; 0 = everywhere; 1 = this server only; 2 = addressees; 4 = followers; null = default'),
+ ),
+ 'primary key' => array('id'),
+ 'unique keys' => array(
+ 'notice_uri_key' => array('uri'),
+ ),
+ 'foreign keys' => array(
+ 'notice_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
+ 'notice_reply_to_fkey' => array('notice', array('reply_to' => 'id')),
+ 'notice_conversation_fkey' => array('conversation', array('conversation' => 'id')), # note... used to refer to notice.id
+ 'notice_repeat_of_fkey' => array('notice', array('repeat_of' => 'id')), # @fixme: what about repeats of deleted notices?
+ ),
+ 'indexes' => array(
+ 'notice_created_id_is_local_idx' => array('created', 'id', 'is_local'),
+ 'notice_profile_id_idx' => array('profile_id', 'created', 'id'),
+ 'notice_repeat_of_created_id_idx' => array('repeat_of', 'created', 'id'),
+ 'notice_conversation_created_id_idx' => array('conversation', 'created', 'id'),
+ 'notice_replyto_idx' => array('reply_to')
+ )
+ );
+
+ if (common_config('search', 'type') == 'fulltext') {
+ $def['fulltext indexes'] = array('content' => array('content'));
+ }
+
+ return $def;
+ }
+
function multiGet($kc, $kvs, $skipNulls=true)
{
return Memcached_DataObject::multiGet('Notice', $kc, $kvs, $skipNulls);
* notice in place of extracting links from content
* boolean 'distribute' whether to distribute the notice, default true
* string 'object_type' URL of the associated object type (default ActivityObject::NOTE)
+ * string 'verb' URL of the associated verb (default ActivityVerb::POST)
* int 'scope' Scope bitmask; default to SITE_SCOPE on private sites, 0 otherwise
*
* @fixme tag override
'reply_to' => null,
'repeat_of' => null,
'scope' => null,
- 'distribute' => true);
+ 'distribute' => true,
+ 'object_type' => null,
+ 'verb' => null);
if (!empty($options) && is_array($options)) {
$options = array_merge($defaults, $options);
$notice->rendered = common_render_content($final, $notice);
}
+ if (empty($verb)) {
+ if (!empty($notice->repeat_of)) {
+ $notice->verb = ActivityVerb::SHARE;
+ $notice->object_type = ActivityObject::ACTIVITY;
+ } else {
+ $notice->verb = ActivityVerb::POST;
+ }
+ } else {
+ $notice->verb = $verb;
+ }
+
if (empty($object_type)) {
$notice->object_type = (empty($notice->reply_to)) ? ActivityObject::NOTE : ActivityObject::COMMENT;
} else {
$this->blowStream('public');
}
- // XXX: Before we were blowing the casche only if the notice id
- // was not the root of the conversation. What to do now?
-
- self::blow('notice:conversation_ids:%d', $this->conversation);
+ self::blow('notice:list-ids:conversation:%s', $this->conversation);
self::blow('conversation::notice_count:%d', $this->conversation);
if (!empty($this->repeat_of)) {
+ // XXX: we should probably only use one of these
$this->blowStream('notice:repeats:%d', $this->repeat_of);
+ self::blow('notice:list-ids:repeat_of:%d', $this->repeat_of);
}
$original = Notice::staticGet('id', $this->repeat_of);
return true;
}
- function getUploadedAttachment() {
- $post = clone $this;
- $query = 'select file.url as up, file.id as i from file join file_to_post on file.id = file_id where post_id=' . $post->escape($post->id) . ' and url like "%/notice/%/file"';
- $post->query($query);
- $post->fetch();
- if (empty($post->up) || empty($post->i)) {
- $ret = false;
- } else {
- $ret = array($post->up, $post->i);
- }
- $post->free();
- return $ret;
- }
-
- function hasAttachments() {
- $post = clone $this;
- $query = "select count(file_id) as n_attachments from file join file_to_post on (file_id = file.id) join notice on (post_id = notice.id) where post_id = " . $post->escape($post->id);
- $post->query($query);
- $post->fetch();
- $n_attachments = intval($post->n_attachments);
- $post->free();
- return $n_attachments;
- }
-
+ protected $_attachments = -1;
+
function attachments() {
- $keypart = sprintf('notice:file_ids:%d', $this->id);
-
- $idstr = self::cacheGet($keypart);
-
- if ($idstr !== false) {
- $ids = explode(',', $idstr);
- } else {
- $ids = array();
- $f2p = new File_to_post;
- $f2p->post_id = $this->id;
- if ($f2p->find()) {
- while ($f2p->fetch()) {
- $ids[] = $f2p->file_id;
- }
- }
- self::cacheSet($keypart, implode(',', $ids));
+ if ($this->_attachments != -1) {
+ return $this->_attachments;
}
-
- $att = array();
-
- foreach ($ids as $id) {
- $f = File::staticGet('id', $id);
- if (!empty($f)) {
- $att[] = clone($f);
- }
+
+ $f2ps = Memcached_DataObject::listGet('File_to_post', 'post_id', array($this->id));
+
+ $ids = array();
+
+ foreach ($f2ps[$this->id] as $f2p) {
+ $ids[] = $f2p->file_id;
}
+
+ $files = Memcached_DataObject::multiGet('File', 'id', $ids);
- return $att;
+ $this->_attachments = $files->fetchAll();
+
+ return $this->_attachments;
}
+ function _setAttachments($attachments)
+ {
+ $this->_attachments = $attachments;
+ }
function publicStream($offset=0, $limit=20, $since_id=0, $max_id=0)
{
$users = $ptag->getUserSubscribers();
foreach ($users as $id) {
if (!array_key_exists($id, $ni)) {
- $user = User::staticGet('id', $id);
- if (!$user->hasBlocked($profile)) {
- $ni[$id] = NOTICE_INBOX_SOURCE_PROFILE_TAG;
- }
+ $ni[$id] = NOTICE_INBOX_SOURCE_PROFILE_TAG;
}
}
}
if (!array_key_exists($recipient, $ni)) {
$ni[$recipient] = NOTICE_INBOX_SOURCE_REPLY;
}
+ }
- // Exclude any deleted, non-local, or blocking recipients.
- $profile = $this->getProfile();
- $originalProfile = null;
- if ($this->repeat_of) {
- // Check blocks against the original notice's poster as well.
- $original = Notice::staticGet('id', $this->repeat_of);
- if ($original) {
- $originalProfile = $original->getProfile();
- }
+ // Exclude any deleted, non-local, or blocking recipients.
+ $profile = $this->getProfile();
+ $originalProfile = null;
+ if ($this->repeat_of) {
+ // Check blocks against the original notice's poster as well.
+ $original = Notice::staticGet('id', $this->repeat_of);
+ if ($original) {
+ $originalProfile = $original->getProfile();
}
- foreach ($ni as $id => $source) {
- $user = User::staticGet('id', $id);
- if (empty($user) || $user->hasBlocked($profile) ||
- ($originalProfile && $user->hasBlocked($originalProfile))) {
- unset($ni[$id]);
- }
+ }
+
+ foreach ($ni as $id => $source) {
+ $user = User::staticGet('id', $id);
+ if (empty($user) || $user->hasBlocked($profile) ||
+ ($originalProfile && $user->hasBlocked($originalProfile))) {
+ unset($ni[$id]);
}
}
return $reply;
}
+ protected $_replies = -1;
+
/**
* Pull the complete list of @-reply targets for this notice.
*
*/
function getReplies()
{
- $keypart = sprintf('notice:reply_ids:%d', $this->id);
-
- $idstr = self::cacheGet($keypart);
+ if ($this->_replies != -1) {
+ return $this->_replies;
+ }
- if ($idstr !== false) {
- $ids = explode(',', $idstr);
- } else {
- $ids = array();
+ $replyMap = Memcached_DataObject::listGet('Reply', 'notice_id', array($this->id));
- $reply = new Reply();
- $reply->selectAdd();
- $reply->selectAdd('profile_id');
- $reply->notice_id = $this->id;
+ $ids = array();
- if ($reply->find()) {
- while($reply->fetch()) {
- $ids[] = $reply->profile_id;
- }
- }
- self::cacheSet($keypart, implode(',', $ids));
+ foreach ($replyMap[$this->id] as $reply) {
+ $ids[] = $reply->profile_id;
}
+ $this->_replies = $ids;
+
return $ids;
}
+ function _setReplies($replies)
+ {
+ $this->_replies = $replies;
+ }
+
/**
* Pull the complete list of @-reply targets for this notice.
*
*
* @return array of Group objects
*/
+
+ protected $_groups = -1;
+
function getGroups()
{
// Don't save groups for repeats
if (!empty($this->repeat_of)) {
return array();
}
+
+ if ($this->_groups != -1)
+ {
+ return $this->_groups;
+ }
+
+ $gis = Memcached_DataObject::listGet('Group_inbox', 'notice_id', array($this->id));
$ids = array();
- $keypart = sprintf('notice:groups:%d', $this->id);
-
- $idstr = self::cacheGet($keypart);
-
- if ($idstr !== false) {
- $ids = explode(',', $idstr);
- } else {
- $gi = new Group_inbox();
-
- $gi->selectAdd();
- $gi->selectAdd('group_id');
-
- $gi->notice_id = $this->id;
-
- $ids = $gi->fetchAll('group_id');
-
- self::cacheSet($keypart, implode(',', $ids));
- }
-
+ foreach ($gis[$this->id] as $gi)
+ {
+ $ids[] = $gi->group_id;
+ }
+
$groups = User_group::multiGet('id', $ids);
- return $groups->fetchAll();
+ $this->_groups = $groups->fetchAll();
+
+ return $this->_groups;
+ }
+
+ function _setGroups($groups)
+ {
+ $this->_groups = $groups;
}
/**
$act->actor = ActivityObject::fromProfile($profile);
$act->actor->extra[] = $profile->profileInfo($cur);
- if ($this->repeat_of) {
+ $act->verb = $this->verb;
+ if ($this->repeat_of) {
$repeated = Notice::staticGet('id', $this->repeat_of);
-
- $act->verb = ActivityVerb::SHARE;
- $act->objects[] = $repeated->asActivity($cur);
-
+ $act->objects[] = $repeated->asActivity($cur);
} else {
-
- $act->verb = ActivityVerb::POST;
- $act->objects[] = ActivityObject::fromNotice($this);
-
+ $act->objects[] = ActivityObject::fromNotice($this);
}
// XXX: should this be handled by default processing for object entry?
if (!empty($this->repeat_of)) {
$repeat = Notice::staticGet('id', $this->repeat_of);
- $ctx->forwardID = $repeat->uri;
- $ctx->forwardUrl = $repeat->bestUrl();
+ if (!empty($repeat)) {
+ $ctx->forwardID = $repeat->uri;
+ $ctx->forwardUrl = $repeat->bestUrl();
+ }
}
$act->context = $ctx;
$result = self::cacheGet($keypart);
if ($result === false) {
- $bResult = $this->_inScope($profile);
+ $bResult = false;
+ if (Event::handle('StartNoticeInScope', array($this, $profile, &$bResult))) {
+ $bResult = $this->_inScope($profile);
+ Event::handle('EndNoticeInScope', array($this, $profile, &$bResult));
+ }
$result = ($bResult) ? 1 : 0;
self::cacheSet($keypart, $result, 0, 300);
}
protected function _inScope($profile)
{
- // If there's no scope, anyone (even anon) is in scope.
-
- if ($this->scope == 0) {
- return true;
+ if (!is_null($this->scope)) {
+ $scope = $this->scope;
+ } else {
+ $scope = self::defaultScope();
}
- // If there's scope, anon cannot be in scope
+ // If there's no scope, anyone (even anon) is in scope.
- if (empty($profile)) {
- return false;
- }
+ if ($scope == 0) { // Not private
- // Author is always in scope
+ return !$this->isHiddenSpam($profile);
- if ($this->profile_id == $profile->id) {
- return true;
- }
+ } else { // Private, somehow
- // Only for users on this site
+ // If there's scope, anon cannot be in scope
- if ($this->scope & Notice::SITE_SCOPE) {
- $user = $profile->getUser();
- if (empty($user)) {
+ if (empty($profile)) {
return false;
}
- }
- // Only for users mentioned in the notice
+ // Author is always in scope
- if ($this->scope & Notice::ADDRESSEE_SCOPE) {
+ if ($this->profile_id == $profile->id) {
+ return true;
+ }
+
+ // Only for users on this site
- $repl = Reply::pkeyGet(array('notice_id' => $this->id,
- 'profile_id' => $profile->id));
+ if ($scope & Notice::SITE_SCOPE) {
+ $user = $profile->getUser();
+ if (empty($user)) {
+ return false;
+ }
+ }
+
+ // Only for users mentioned in the notice
+
+ if ($scope & Notice::ADDRESSEE_SCOPE) {
+
+ $repl = Reply::pkeyGet(array('notice_id' => $this->id,
+ 'profile_id' => $profile->id));
- if (empty($repl)) {
- return false;
+ if (empty($repl)) {
+ return false;
+ }
}
- }
- // Only for members of the given group
+ // Only for members of the given group
- if ($this->scope & Notice::GROUP_SCOPE) {
+ if ($scope & Notice::GROUP_SCOPE) {
- // XXX: just query for the single membership
+ // XXX: just query for the single membership
- $groups = $this->getGroups();
+ $groups = $this->getGroups();
- $foundOne = false;
+ $foundOne = false;
- foreach ($groups as $group) {
- if ($profile->isMember($group)) {
- $foundOne = true;
- break;
+ foreach ($groups as $group) {
+ if ($profile->isMember($group)) {
+ $foundOne = true;
+ break;
+ }
+ }
+
+ if (!$foundOne) {
+ return false;
}
}
- if (!$foundOne) {
- return false;
+ // Only for followers of the author
+
+ $author = null;
+
+ if ($scope & Notice::FOLLOWER_SCOPE) {
+
+ $author = $this->getProfile();
+
+ if (!Subscription::exists($profile, $author)) {
+ return false;
+ }
}
+
+ return !$this->isHiddenSpam($profile);
}
+ }
+
+ function isHiddenSpam($profile) {
+
+ // Hide posts by silenced users from everyone but moderators.
- // Only for followers of the author
+ if (common_config('notice', 'hidespam')) {
- if ($this->scope & Notice::FOLLOWER_SCOPE) {
$author = $this->getProfile();
- if (!Subscription::exists($profile, $author)) {
- return false;
+
+ if ($author->hasRole(Profile_role::SILENCED)) {
+ if (empty($profile) || !$profile->hasRight(Right::REVIEWSPAM)) {
+ return true;
+ }
}
}
- return true;
+ return false;
}
static function groupsFromText($text, $profile)
function __sleep()
{
$vars = parent::__sleep();
- $skip = array('_original', '_profile');
+ $skip = array('_original', '_profile', '_groups', '_attachments', '_faves', '_replies', '_repeats');
return array_diff($vars, $skip);
}
return Memcached_DataObject::pivotGet('Profile', 'id', $ids);
}
+
+ static function fillGroups(&$notices)
+ {
+ $ids = self::_idsOf($notices);
+
+ $gis = Memcached_DataObject::listGet('Group_inbox', 'notice_id', $ids);
+
+ $gids = array();
+
+ foreach ($gis as $id => $gi)
+ {
+ foreach ($gi as $g)
+ {
+ $gids[] = $g->group_id;
+ }
+ }
+
+ $gids = array_unique($gids);
+
+ $group = Memcached_DataObject::pivotGet('User_group', 'id', $gids);
+
+ foreach ($notices as $notice)
+ {
+ $grps = array();
+ $gi = $gis[$notice->id];
+ foreach ($gi as $g) {
+ $grps[] = $group[$g->group_id];
+ }
+ $notice->_setGroups($grps);
+ }
+ }
+
+ static function _idsOf(&$notices)
+ {
+ $ids = array();
+ foreach ($notices as $notice) {
+ $ids[] = $notice->id;
+ }
+ $ids = array_unique($ids);
+ return $ids;
+ }
+
+ static function fillAttachments(&$notices)
+ {
+ $ids = self::_idsOf($notices);
+
+ $f2pMap = Memcached_DataObject::listGet('File_to_post', 'post_id', $ids);
+
+ $fileIds = array();
+
+ foreach ($f2pMap as $noticeId => $f2ps) {
+ foreach ($f2ps as $f2p) {
+ $fileIds[] = $f2p->file_id;
+ }
+ }
+
+ $fileIds = array_unique($fileIds);
+
+ $fileMap = Memcached_DataObject::pivotGet('File', 'id', $fileIds);
+
+ foreach ($notices as $notice)
+ {
+ $files = array();
+ $f2ps = $f2pMap[$notice->id];
+ foreach ($f2ps as $f2p) {
+ $files[] = $fileMap[$f2p->file_id];
+ }
+ $notice->_setAttachments($files);
+ }
+ }
+
+ protected $_faves;
+
+ /**
+ * All faves of this notice
+ *
+ * @return array Array of Fave objects
+ */
+
+ function getFaves()
+ {
+ if (isset($this->_faves) && is_array($this->_faves)) {
+ return $this->_faves;
+ }
+ $faveMap = Memcached_DataObject::listGet('Fave', 'notice_id', array($this->id));
+ $this->_faves = $faveMap[$this->id];
+ return $this->_faves;
+ }
+
+ function _setFaves($faves)
+ {
+ $this->_faves = $faves;
+ }
+
+ static function fillFaves(&$notices)
+ {
+ $ids = self::_idsOf($notices);
+ $faveMap = Memcached_DataObject::listGet('Fave', 'notice_id', $ids);
+ $cnt = 0;
+ $faved = array();
+ foreach ($faveMap as $id => $faves) {
+ $cnt += count($faves);
+ if (count($faves) > 0) {
+ $faved[] = $id;
+ }
+ }
+ foreach ($notices as $notice) {
+ $faves = $faveMap[$notice->id];
+ $notice->_setFaves($faves);
+ }
+ }
+
+ static function fillReplies(&$notices)
+ {
+ $ids = self::_idsOf($notices);
+ $replyMap = Memcached_DataObject::listGet('Reply', 'notice_id', $ids);
+ foreach ($notices as $notice) {
+ $replies = $replyMap[$notice->id];
+ $ids = array();
+ foreach ($replies as $reply) {
+ $ids[] = $reply->profile_id;
+ }
+ $notice->_setReplies($ids);
+ }
+ }
+
+ protected $_repeats;
+
+ function getRepeats()
+ {
+ if (isset($this->_repeats) && is_array($this->_repeats)) {
+ return $this->_repeats;
+ }
+ $repeatMap = Memcached_DataObject::listGet('Notice', 'repeat_of', array($this->id));
+ $this->_repeats = $repeatMap[$this->id];
+ return $this->_repeats;
+ }
+
+ function _setRepeats($repeats)
+ {
+ $this->_repeats = $repeats;
+ }
+
+ static function fillRepeats(&$notices)
+ {
+ $ids = self::_idsOf($notices);
+ $repeatMap = Memcached_DataObject::listGet('Notice', 'repeat_of', $ids);
+ foreach ($notices as $notice) {
+ $repeats = $repeatMap[$notice->id];
+ $notice->_setRepeats($repeats);
+ }
+ }
}
projects / quix0rs-gnu-social.git / blobdiff