public $created; // datetime() not_null
public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
- /* Static get */
- function staticGet($k,$v=NULL) {
- return Memcached_DataObject::staticGet('Profile',$k,$v);
- }
-
public static function schemaDef()
{
- return array(
+ $def = array(
'description' => 'local and remote users have profiles',
'fields' => array(
'id' => array('type' => 'serial', 'not null' => true, 'description' => 'unique identifier'),
- 'nickname' => array('type' => 'varchar', 'length' => 64, 'not null' => true, 'description' => 'nickname or username'),
- 'fullname' => array('type' => 'varchar', 'length' => 255, 'description' => 'display name'),
+ 'nickname' => array('type' => 'varchar', 'length' => 64, 'not null' => true, 'description' => 'nickname or username', 'collate' => 'utf8_general_ci'),
+ 'fullname' => array('type' => 'varchar', 'length' => 255, 'description' => 'display name', 'collate' => 'utf8_general_ci'),
'profileurl' => array('type' => 'varchar', 'length' => 255, 'description' => 'URL, cached so we dont regenerate'),
- 'homepage' => array('type' => 'varchar', 'length' => 255, 'description' => 'identifying URL'),
- 'bio' => array('type' => 'text', 'description' => 'descriptive biography'),
- 'location' => array('type' => 'varchar', 'length' => 255, 'description' => 'physical location'),
+ 'homepage' => array('type' => 'varchar', 'length' => 255, 'description' => 'identifying URL', 'collate' => 'utf8_general_ci'),
+ 'bio' => array('type' => 'text', 'description' => 'descriptive biography', 'collate' => 'utf8_general_ci'),
+ 'location' => array('type' => 'varchar', 'length' => 255, 'description' => 'physical location', 'collate' => 'utf8_general_ci'),
'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'),
'primary key' => array('id'),
'indexes' => array(
'profile_nickname_idx' => array('nickname'),
- ),
- 'fulltext indexes' => array(
- 'nickname' => array('nickname', 'fullname', 'location', 'bio', 'homepage')
- ),
+ )
);
- }
- function multiGet($keyCol, $keyVals, $skipNulls=true)
- {
- return parent::multiGet('Profile', $keyCol, $keyVals, $skipNulls);
- }
+ // Add a fulltext index
+
+ if (common_config('search', 'type') == 'fulltext') {
+ $def['fulltext indexes'] = array('nickname' => array('nickname', 'fullname', 'location', 'bio', 'homepage'));
+ }
+
+ return $def;
+ }
/* the code above is auto generated do not remove the tag below */
###END_AUTOCODE
+ public static function getByEmail($email)
+ {
+ // in the future, profiles should have emails stored...
+ $user = User::getKV('email', $email);
+ if (!($user instanceof User)) {
+ throw new NoSuchUserException(array('email'=>$email));
+ }
+ return $user->getProfile();
+ }
+
protected $_user = -1; // Uninitialized value distinct from null
- function getUser()
+ public function getUser()
{
- if (is_int($this->_user) && $this->_user == -1) {
- $this->_user = User::staticGet('id', $this->id);
+ if ($this->_user === -1) {
+ $this->_user = User::getKV('id', $this->id);
+ }
+ if (!($this->_user instanceof User)) {
+ throw new NoSuchUserException(array('id'=>$this->id));
}
return $this->_user;
}
- protected $_avatars = array();
-
- function getAvatar($width, $height=null)
+ public function isLocal()
{
- if (is_null($height)) {
- $height = $width;
- }
-
- if (array_key_exists($width, $this->_avatars)) {
- return $this->_avatars[$width];
- }
-
- $avatar = null;
-
- if (Event::handle('StartProfileGetAvatar', array($this, $width, &$avatar))) {
- $avatar = Avatar::pkeyGet(array('profile_id' => $this->id,
- 'width' => $width,
- 'height' => $height));
- Event::handle('EndProfileGetAvatar', array($this, $width, &$avatar));
+ try {
+ $this->getUser();
+ } catch (NoSuchUserException $e) {
+ return false;
}
-
- $this->_avatars[$width] = $avatar;
-
- return $avatar;
+ return true;
}
- function _fillAvatar($width, $avatar)
- {
- $this->_avatars[$width] = $avatar;
- }
-
- function getOriginalAvatar()
+ protected $_avatars = array();
+
+ public function getAvatar($width, $height=null)
{
- $avatar = DB_DataObject::factory('avatar');
- $avatar->profile_id = $this->id;
- $avatar->original = true;
- if ($avatar->find(true)) {
- return $avatar;
- } else {
- return null;
- }
+ return Avatar::byProfile($this, $width, $height);
}
- function setOriginal($filename)
+ public function setOriginal($filename)
{
$imagefile = new ImageFile($this->id, Avatar::path($filename));
$avatar->filename = $filename;
$avatar->original = true;
$avatar->url = Avatar::url($filename);
- $avatar->created = DB_DataObject_Cast::dateTime(); # current time
+ $avatar->created = common_sql_now();
// XXX: start a transaction here
-
- if (!$this->delete_avatars() || !$avatar->insert()) {
+ if (!Avatar::deleteFromProfile($this, true) || !$avatar->insert()) {
+ // If we can't delete the old avatars, let's abort right here.
@unlink(Avatar::path($filename));
return null;
}
foreach (array(AVATAR_PROFILE_SIZE, AVATAR_STREAM_SIZE, AVATAR_MINI_SIZE) as $size) {
// We don't do a scaled one if original is our scaled size
if (!($avatar->width == $size && $avatar->height == $size)) {
- $scaled_filename = $imagefile->resize($size);
-
- //$scaled = DB_DataObject::factory('avatar');
- $scaled = new Avatar();
- $scaled->profile_id = $this->id;
- $scaled->width = $size;
- $scaled->height = $size;
- $scaled->original = false;
- $scaled->mediatype = image_type_to_mime_type($imagefile->type);
- $scaled->filename = $scaled_filename;
- $scaled->url = Avatar::url($scaled_filename);
- $scaled->created = DB_DataObject_Cast::dateTime(); # current time
-
- if (!$scaled->insert()) {
- return null;
+ try {
+ Avatar::newSize($this, $size);
+ } catch (Exception $e) {
+ // should we abort the generation and live without smaller avatars?
}
}
}
return $avatar;
}
- /**
- * Delete attached avatars for this user from the database and filesystem.
- * This should be used instead of a batch delete() to ensure that files
- * get removed correctly.
- *
- * @param boolean $original true to delete only the original-size file
- * @return <type>
- */
- function delete_avatars($original=true)
- {
- $avatar = new Avatar();
- $avatar->profile_id = $this->id;
- $avatar->find();
- while ($avatar->fetch()) {
- if ($avatar->original) {
- if ($original == false) {
- continue;
- }
- }
- $avatar->delete();
- }
- return true;
- }
-
/**
* Gets either the full name (if filled) or the nickname.
*
return $stream->getNotices($offset, $limit, $since_id, $max_id);
}
- function getNotices($offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
+ function getNotices($offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0, Profile $scoped=null)
{
- $stream = new ProfileNoticeStream($this);
+ $stream = new ProfileNoticeStream($this, $scoped);
return $stream->getNotices($offset, $limit, $since_id, $max_id);
}
self::cacheSet($keypart, implode(',', $ids));
}
+ if (!is_null($offset) && !is_null($limit)) {
+ $ids = array_slice($ids, $offset, $limit);
+ }
+
return User_group::multiGet('id', $ids);
}
$lists = array();
foreach ($ids as $id) {
- $list = Profile_list::staticGet('id', $id);
+ $list = Profile_list::getKV('id', $id);
if (!empty($list) &&
($showPrivate || !$list->private)) {
return new ArrayWrapper($lists);
}
+ /**
+ * Get tags that other people put on this profile, in reverse-chron order
+ *
+ * @param (Profile|User) $auth_user Authorized user (used for privacy)
+ * @param int $offset Offset from latest
+ * @param int $limit Max number to get
+ * @param datetime $since_id max date
+ * @param datetime $max_id min date
+ *
+ * @return Profile_list resulting lists
+ */
+
function getOtherTags($auth_user=null, $offset=0, $limit=null, $since_id=0, $max_id=0)
{
- $lists = new Profile_list();
+ $list = new Profile_list();
- $tags = new Profile_tag();
- $tags->tagged = $this->id;
-
- $lists->joinAdd($tags);
+ $qry = sprintf('select profile_list.*, unix_timestamp(profile_tag.modified) as "cursor" ' .
+ 'from profile_tag join profile_list '.
+ 'on (profile_tag.tagger = profile_list.tagger ' .
+ ' and profile_tag.tag = profile_list.tag) ' .
+ 'where profile_tag.tagged = %d ',
+ $this->id);
- #@fixme: postgres (round(date_part('epoch', my_date)))
- $lists->selectAdd('unix_timestamp(profile_tag.modified) as "cursor"');
if ($auth_user instanceof User || $auth_user instanceof Profile) {
- $lists->whereAdd('( ( profile_list.private = false ) ' .
- 'OR ( profile_list.tagger = ' . $auth_user->id . ' AND ' .
- 'profile_list.private = true ) )');
+ $qry .= sprintf('AND ( ( profile_list.private = false ) ' .
+ 'OR ( profile_list.tagger = %d AND ' .
+ 'profile_list.private = true ) )',
+ $auth_user->id);
} else {
- $lists->private = false;
+ $qry .= 'AND profile_list.private = 0 ';
}
- if ($since_id>0) {
- $lists->whereAdd('cursor > '.$since_id);
+ if ($since_id > 0) {
+ $qry .= sprintf('AND (cursor > %d) ', $since_id);
}
- if ($max_id>0) {
- $lists->whereAdd('cursor <= '.$max_id);
+ if ($max_id > 0) {
+ $qry .= sprintf('AND (cursor < %d) ', $max_id);
}
- if($offset>=0 && !is_null($limit)) {
- $lists->limit($offset, $limit);
- }
+ $qry .= 'ORDER BY profile_tag.modified DESC ';
- $lists->orderBy('profile_tag.modified DESC');
- $lists->find();
+ if ($offset >= 0 && !is_null($limit)) {
+ $qry .= sprintf('LIMIT %d OFFSET %d ', $limit, $offset);
+ }
- return $lists;
+ $list->query($qry);
+ return $list;
}
function getPrivateTags($offset=0, $limit=null, $since_id=0, $max_id=0)
$lists = new Profile_list();
$subs = new Profile_tag_subscription();
- $lists->joinAdd('id', 'profile_tag_subscription:profile_tag_id');
+ $lists->joinAdd(array('id', 'profile_tag_subscription:profile_tag_id'));
#@fixme: postgres (round(date_part('epoch', my_date)))
$lists->selectAdd('unix_timestamp(profile_tag_subscription.created) as "cursor"');
if (Event::handle('StartJoinGroup', array($group, $this))) {
$join = Group_member::join($group->id, $this->id);
self::blow('profile:groups:%d', $this->id);
+ self::blow('group:member_ids:%d', $group->id);
+ self::blow('group:member_count:%d', $group->id);
Event::handle('EndJoinGroup', array($group, $this));
}
}
if (Event::handle('StartLeaveGroup', array($group, $this))) {
Group_member::leave($group->id, $this->id);
self::blow('profile:groups:%d', $this->id);
+ self::blow('group:member_ids:%d', $group->id);
+ self::blow('group:member_count:%d', $group->id);
Event::handle('EndLeaveGroup', array($group, $this));
}
}
function avatarUrl($size=AVATAR_PROFILE_SIZE)
{
- $avatar = $this->getAvatar($size);
- if ($avatar) {
- return $avatar->displayUrl();
- } else {
- return Avatar::defaultImage($size);
- }
+ return Avatar::urlByProfile($this, $size);
}
- function getSubscriptions($offset=0, $limit=null)
+ function getSubscribed($offset=0, $limit=null)
{
- $subs = Subscription::bySubscriber($this->id,
- $offset,
- $limit);
-
- $profiles = array();
-
- while ($subs->fetch()) {
- $profile = Profile::staticGet($subs->subscribed);
- if ($profile) {
- $profiles[] = $profile;
- }
+ $subs = Subscription::getSubscribedIDs($this->id, $offset, $limit);
+ try {
+ $profiles = Profile::listFind('id', $subs);
+ } catch (NoResultException $e) {
+ return $e->obj;
}
-
- return new ArrayWrapper($profiles);
+ return $profiles;
}
function getSubscribers($offset=0, $limit=null)
{
- $subs = Subscription::bySubscribed($this->id,
- $offset,
- $limit);
+ $subs = Subscription::getSubscriberIDs($this->id, $offset, $limit);
+ try {
+ $profiles = Profile::listFind('id', $subs);
+ } catch (NoResultException $e) {
+ return $e->obj;
+ }
+ return $profiles;
+ }
- $profiles = array();
+ function getTaggedSubscribers($tag, $offset=0, $limit=null)
+ {
+ $qry =
+ 'SELECT profile.* ' .
+ 'FROM profile JOIN subscription ' .
+ 'ON profile.id = subscription.subscriber ' .
+ 'JOIN profile_tag ON (profile_tag.tagged = subscription.subscriber ' .
+ 'AND profile_tag.tagger = subscription.subscribed) ' .
+ 'WHERE subscription.subscribed = %d ' .
+ "AND profile_tag.tag = '%s' " .
+ 'AND subscription.subscribed != subscription.subscriber ' .
+ 'ORDER BY subscription.created DESC ';
- while ($subs->fetch()) {
- $profile = Profile::staticGet($subs->subscriber);
- if ($profile) {
- $profiles[] = $profile;
- }
+ if ($offset) {
+ $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
}
- return new ArrayWrapper($profiles);
+ $profile = new Profile();
+
+ $cnt = $profile->query(sprintf($qry, $this->id, $profile->escape($tag)));
+
+ return $profile;
}
- function getTaggedSubscribers($tag)
+ function getTaggedSubscriptions($tag, $offset=0, $limit=null)
{
$qry =
'SELECT profile.* ' .
- 'FROM profile JOIN (subscription, profile_tag, profile_list) ' .
- 'ON profile.id = subscription.subscriber ' .
- 'AND profile.id = profile_tag.tagged ' .
- 'AND profile_tag.tagger = profile_list.tagger AND profile_tag.tag = profile_list.tag ' .
- 'WHERE subscription.subscribed = %d ' .
+ 'FROM profile JOIN subscription ' .
+ 'ON profile.id = subscription.subscribed ' .
+ 'JOIN profile_tag on (profile_tag.tagged = subscription.subscribed ' .
+ 'AND profile_tag.tagger = subscription.subscriber) ' .
+ 'WHERE subscription.subscriber = %d ' .
+ "AND profile_tag.tag = '%s' " .
'AND subscription.subscribed != subscription.subscriber ' .
- 'AND profile_tag.tagger = %d AND profile_tag.tag = "%s" ' .
- 'AND profile_list.private = false ' .
- 'ORDER BY subscription.created DESC';
+ 'ORDER BY subscription.created DESC ';
+
+ $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
$profile = new Profile();
- $tagged = array();
- $cnt = $profile->query(sprintf($qry, $this->id, $this->id, $tag));
+ $profile->query(sprintf($qry, $this->id, $profile->escape($tag)));
- while ($profile->fetch()) {
- $tagged[] = clone($profile);
- }
- return $tagged;
+ return $profile;
}
/**
$faves = new Fave();
$faves->user_id = $this->id;
- $cnt = (int) $faves->count('distinct notice_id');
+ $cnt = (int) $faves->count('notice_id');
if (!empty($c)) {
$c->set(Cache::key('profile:fave_count:'.$this->id), $cnt);
return $cnt;
}
+ function favoriteNotices($own=false, $offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
+ {
+ return Fave::stream($this->id, $offset, $limit, $own, $since_id, $max_id);
+ }
+
function noticeCount()
{
$c = Cache::instance();
return ($biolimit > 0 && !empty($bio) && (mb_strlen($bio) > $biolimit));
}
- function delete()
+ function update($dataObject=false)
+ {
+ if (is_object($dataObject) && $this->nickname != $dataObject->nickname) {
+ try {
+ $local = $this->getUser();
+ common_debug("Updating User ({$this->id}) nickname from {$dataObject->nickname} to {$this->nickname}");
+ $origuser = clone($local);
+ $local->nickname = $this->nickname;
+ $result = $local->updateKeys($origuser);
+ if ($result === false) {
+ common_log_db_error($local, 'UPDATE', __FILE__);
+ // TRANS: Server error thrown when user profile settings could not be updated.
+ throw new ServerException(_('Could not update user nickname.'));
+ }
+
+ // Clear the site owner, in case nickname changed
+ if ($local->hasRole(Profile_role::OWNER)) {
+ User::blow('user:site_owner');
+ }
+ } catch (NoSuchUserException $e) {
+ // Nevermind...
+ }
+ }
+
+ return parent::update($dataObject);
+ }
+
+ function delete($useWhere=false)
{
$this->_deleteNotices();
$this->_deleteSubscriptions();
$this->_deleteMessages();
$this->_deleteTags();
$this->_deleteBlocks();
- $this->delete_avatars();
+ Avatar::deleteFromProfile($this, true);
// Warning: delete() will run on the batch objects,
// not on individual objects.
$inst->delete();
}
- parent::delete();
+ return parent::delete($useWhere);
}
function _deleteNotices()
$sub->find();
while ($sub->fetch()) {
- $other = Profile::staticGet('id', $sub->subscribed);
+ $other = Profile::getKV('id', $sub->subscribed);
if (empty($other)) {
continue;
}
$subd->find();
while ($subd->fetch()) {
- $other = Profile::staticGet('id', $subd->subscriber);
+ $other = Profile::getKV('id', $subd->subscriber);
if (empty($other)) {
continue;
}
// XXX: identical to Notice::getLocation.
- function getLocation()
+ public function getLocation()
{
$location = null;
return $location;
}
+ public function shareLocation()
+ {
+ $cfg = common_config('location', 'share');
+
+ if ($cfg == 'always') {
+ return true;
+ } else if ($cfg == 'never') {
+ return false;
+ } else { // user
+ $share = common_config('location', 'sharedefault');
+
+ // Check if user has a personal setting for this
+ $prefs = User_location_prefs::getKV('user_id', $this->id);
+
+ if (!empty($prefs)) {
+ $share = $prefs->share_location;
+ $prefs->free();
+ }
+
+ return $share;
+ }
+ }
+
function hasRole($name)
{
$has_role = false;
function silence()
{
$this->grantRole(Profile_role::SILENCED);
+ if (common_config('notice', 'hidespam')) {
+ $this->flushVisibility();
+ }
}
function unsilence()
{
$this->revokeRole(Profile_role::SILENCED);
+ if (common_config('notice', 'hidespam')) {
+ $this->flushVisibility();
+ }
+ }
+
+ function flushVisibility()
+ {
+ // Get all notices
+ $stream = new ProfileNoticeStream($this, $this);
+ $ids = $stream->getNoticeIds(0, CachingNoticeStream::CACHE_WINDOW);
+ foreach ($ids as $id) {
+ self::blow('notice:in-scope-for:%d:null', $id);
+ }
}
/**
* @param $right string Name of the right, usually a constant in class Right
* @return boolean whether the user has the right in question
*/
- function hasRight($right)
+ public function hasRight($right)
{
$result = false;
case Right::SILENCEUSER:
case Right::DELETEUSER:
case Right::DELETEGROUP:
+ case Right::TRAINSPAM:
+ case Right::REVIEWSPAM:
$result = $this->hasRole(Profile_role::MODERATOR);
break;
case Right::CONFIGURESITE:
return $result;
}
- function hasRepeated($notice_id)
+ // FIXME: Can't put Notice typing here due to ArrayWrapper
+ public function hasRepeated($notice)
{
// XXX: not really a pkey, but should work
- $notice = Memcached_DataObject::pkeyGet('Notice',
- array('profile_id' => $this->id,
- 'repeat_of' => $notice_id));
+ $notice = Notice::pkeyGet(array('profile_id' => $this->id,
+ 'repeat_of' => $notice->id));
return !empty($notice);
}
return $noun->asString('activity:' . $element);
}
+ /**
+ * Returns the profile's canonical url, not necessarily a uri/unique id
+ *
+ * @return string $profileurl
+ */
+ public function getUrl()
+ {
+ if (empty($this->profileurl) ||
+ !filter_var($this->profileurl, FILTER_VALIDATE_URL)) {
+ throw new InvalidUrlException($this->profileurl);
+ }
+ return $this->profileurl;
+ }
+
/**
* Returns the best URI for a profile. Plugins may override.
*
* @return string $uri
*/
- function getUri()
+ public function getUri()
{
$uri = null;
if (Event::handle('StartGetProfileUri', array($this, &$uri))) {
// check for a local user first
- $user = User::staticGet('id', $this->id);
+ $user = User::getKV('id', $this->id);
if (!empty($user)) {
$uri = $user->uri;
return $uri;
}
- function hasBlocked($other)
+ /**
+ * Returns an assumed acct: URI for a profile. Plugins are required.
+ *
+ * @return string $uri
+ */
+ public function getAcctUri()
{
- $block = Profile_block::get($this->id, $other->id);
+ $acct = null;
- if (empty($block)) {
- $result = false;
- } else {
- $result = true;
+ if (Event::handle('StartGetProfileAcctUri', array($this, &$acct))) {
+ Event::handle('EndGetProfileAcctUri', array($this, &$acct));
}
- return $result;
+ if ($acct === null) {
+ throw new ProfileNoAcctUriException($this);
+ }
+
+ return $acct;
+ }
+
+ function hasBlocked($other)
+ {
+ $block = Profile_block::exists($this, $other);
+ return !empty($block);
}
function getAtomFeed()
$feed = null;
if (Event::handle('StartProfileGetAtomFeed', array($this, &$feed))) {
- $user = User::staticGet('id', $this->id);
+ $user = User::getKV('id', $this->id);
if (!empty($user)) {
$feed = common_local_url('ApiTimelineUser', array('id' => $user->id,
'format' => 'atom'));
$profile = null;
if (Event::handle('StartGetProfileFromURI', array($uri, &$profile))) {
- // Get a local user or remote (OMB 0.1) profile
- $user = User::staticGet('uri', $uri);
+ // Get a local user
+ $user = User::getKV('uri', $uri);
if (!empty($user)) {
$profile = $user->getProfile();
}
$skip = array('_user', '_avatars');
return array_diff($vars, $skip);
}
-
- static function fillAvatars(&$profiles, $width)
+
+ public function getProfile()
{
- $ids = array();
- foreach ($profiles as $profile) {
- $ids[] = $profile->id;
- }
-
- $avatars = Avatar::pivotGet('profile_id', $ids, array('width' => $width,
- 'height' => $width));
-
- foreach ($profiles as $profile) {
- $profile->_fillAvatar($width, $avatars[$profile->id]);
- }
+ return $this;
}
}