3 * StatusNet - the distributed open-source microblogging tool
4 * Copyright (C) 2008, 2009, StatusNet, Inc.
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU Affero General Public License as published by
8 * the Free Software Foundation, either version 3 of the License, or
9 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU Affero General Public License for more details.
16 * You should have received a copy of the GNU Affero General Public License
17 * along with this program. If not, see <http://www.gnu.org/licenses/>.
20 if (!defined('STATUSNET') && !defined('LACONICA')) { exit(1); }
23 * Table Definition for profile
25 require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
27 class Profile extends Memcached_DataObject
30 /* the code below is auto generated do not remove the above tag */
32 public $__table = 'profile'; // table name
33 public $id; // int(4) primary_key not_null
34 public $nickname; // varchar(64) multiple_key not_null
35 public $fullname; // varchar(255) multiple_key
36 public $profileurl; // varchar(255)
37 public $homepage; // varchar(255) multiple_key
38 public $bio; // text() multiple_key
39 public $location; // varchar(255) multiple_key
40 public $lat; // decimal(10,7)
41 public $lon; // decimal(10,7)
42 public $location_id; // int(4)
43 public $location_ns; // int(4)
44 public $created; // datetime() not_null
45 public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
48 function staticGet($k,$v=NULL) {
49 return Memcached_DataObject::staticGet('Profile',$k,$v);
52 /* the code above is auto generated do not remove the tag below */
57 return User::staticGet('id', $this->id);
60 function getAvatar($width, $height=null)
62 if (is_null($height)) {
65 return Avatar::pkeyGet(array('profile_id' => $this->id,
67 'height' => $height));
70 function getOriginalAvatar()
72 $avatar = DB_DataObject::factory('avatar');
73 $avatar->profile_id = $this->id;
74 $avatar->original = true;
75 if ($avatar->find(true)) {
82 function setOriginal($filename)
84 $imagefile = new ImageFile($this->id, Avatar::path($filename));
86 $avatar = new Avatar();
87 $avatar->profile_id = $this->id;
88 $avatar->width = $imagefile->width;
89 $avatar->height = $imagefile->height;
90 $avatar->mediatype = image_type_to_mime_type($imagefile->type);
91 $avatar->filename = $filename;
92 $avatar->original = true;
93 $avatar->url = Avatar::url($filename);
94 $avatar->created = DB_DataObject_Cast::dateTime(); # current time
96 # XXX: start a transaction here
98 if (!$this->delete_avatars() || !$avatar->insert()) {
99 @unlink(Avatar::path($filename));
103 foreach (array(AVATAR_PROFILE_SIZE, AVATAR_STREAM_SIZE, AVATAR_MINI_SIZE) as $size) {
104 # We don't do a scaled one if original is our scaled size
105 if (!($avatar->width == $size && $avatar->height == $size)) {
106 $scaled_filename = $imagefile->resize($size);
108 //$scaled = DB_DataObject::factory('avatar');
109 $scaled = new Avatar();
110 $scaled->profile_id = $this->id;
111 $scaled->width = $size;
112 $scaled->height = $size;
113 $scaled->original = false;
114 $scaled->mediatype = image_type_to_mime_type($imagefile->type);
115 $scaled->filename = $scaled_filename;
116 $scaled->url = Avatar::url($scaled_filename);
117 $scaled->created = DB_DataObject_Cast::dateTime(); # current time
119 if (!$scaled->insert()) {
128 function delete_avatars($original=true)
130 $avatar = new Avatar();
131 $avatar->profile_id = $this->id;
133 while ($avatar->fetch()) {
134 if ($avatar->original) {
135 if ($original == false) {
145 * Gets either the full name (if filled) or the nickname.
149 function getBestName()
151 return ($this->fullname) ? $this->fullname : $this->nickname;
155 * Gets the full name (if filled) with nickname as a parenthetical, or the nickname alone
156 * if no fullname is provided.
160 function getFancyName()
162 if ($this->fullname) {
163 // TRANS: Full name of a profile or group followed by nickname in parens
164 return sprintf(_m('FANCYNAME','%1$s (%2$s)'), $this->fullname, $this->nickname);
166 return $this->nickname;
171 * Get the most recent notice posted by this user, if any.
173 * @return mixed Notice or null
176 function getCurrentNotice()
178 $notice = $this->getNotices(0, 1);
180 if ($notice->fetch()) {
187 function getTaggedNotices($tag, $offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
189 $ids = Notice::stream(array($this, '_streamTaggedDirect'),
191 'profile:notice_ids_tagged:' . $this->id . ':' . $tag,
192 $offset, $limit, $since_id, $max_id);
193 return Notice::getStreamByIds($ids);
196 function getNotices($offset=0, $limit=NOTICES_PER_PAGE, $since_id=0, $max_id=0)
198 // XXX: I'm not sure this is going to be any faster. It probably isn't.
199 $ids = Notice::stream(array($this, '_streamDirect'),
201 'profile:notice_ids:' . $this->id,
202 $offset, $limit, $since_id, $max_id);
204 return Notice::getStreamByIds($ids);
207 function _streamTaggedDirect($tag, $offset, $limit, $since_id, $max_id)
209 // XXX It would be nice to do this without a join
211 $notice = new Notice();
214 "select id from notice join notice_tag on id=notice_id where tag='".
215 $notice->escape($tag) .
216 "' and profile_id=" . $notice->escape($this->id);
218 if ($since_id != 0) {
219 $query .= " and id > $since_id";
223 $query .= " and id <= $max_id";
226 $query .= ' order by id DESC';
228 if (!is_null($offset)) {
229 $query .= " LIMIT $limit OFFSET $offset";
232 $notice->query($query);
236 while ($notice->fetch()) {
237 $ids[] = $notice->id;
243 function _streamDirect($offset, $limit, $since_id, $max_id)
245 $notice = new Notice();
247 // Temporary hack until notice_profile_id_idx is updated
248 // to (profile_id, id) instead of (profile_id, created, id).
249 // It's been falling back to PRIMARY instead, which is really
250 // very inefficient for a profile that hasn't posted in a few
251 // months. Even though forcing the index will cause a filesort,
252 // it's usually going to be better.
253 if (common_config('db', 'type') == 'mysql') {
256 "select id from notice force index (notice_profile_id_idx) ".
257 "where profile_id=" . $notice->escape($this->id);
259 if ($since_id != 0) {
260 $query .= " and id > $since_id";
264 $query .= " and id <= $max_id";
267 $query .= ' order by id DESC';
269 if (!is_null($offset)) {
270 $query .= " LIMIT $limit OFFSET $offset";
273 $notice->query($query);
277 $notice->profile_id = $this->id;
279 $notice->selectAdd();
280 $notice->selectAdd('id');
282 if ($since_id != 0) {
283 $notice->whereAdd('id > ' . $since_id);
287 $notice->whereAdd('id <= ' . $max_id);
290 $notice->orderBy('id DESC');
292 if (!is_null($offset)) {
293 $notice->limit($offset, $limit);
301 while ($notice->fetch()) {
302 $ids[] = $notice->id;
308 function isMember($group)
310 $mem = new Group_member();
312 $mem->group_id = $group->id;
313 $mem->profile_id = $this->id;
322 function isAdmin($group)
324 $mem = new Group_member();
326 $mem->group_id = $group->id;
327 $mem->profile_id = $this->id;
337 function getGroups($offset=0, $limit=null)
340 'SELECT user_group.* ' .
341 'FROM user_group JOIN group_member '.
342 'ON user_group.id = group_member.group_id ' .
343 'WHERE group_member.profile_id = %d ' .
344 'ORDER BY group_member.created DESC ';
346 if ($offset>0 && !is_null($limit)) {
348 if (common_config('db','type') == 'pgsql') {
349 $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
351 $qry .= ' LIMIT ' . $offset . ', ' . $limit;
356 $groups = new User_group();
358 $cnt = $groups->query(sprintf($qry, $this->id));
363 function avatarUrl($size=AVATAR_PROFILE_SIZE)
365 $avatar = $this->getAvatar($size);
367 return $avatar->displayUrl();
369 return Avatar::defaultImage($size);
373 function getSubscriptions($offset=0, $limit=null)
376 'SELECT profile.* ' .
377 'FROM profile JOIN subscription ' .
378 'ON profile.id = subscription.subscribed ' .
379 'WHERE subscription.subscriber = %d ' .
380 'AND subscription.subscribed != subscription.subscriber ' .
381 'ORDER BY subscription.created DESC ';
383 if ($offset>0 && !is_null($limit)){
384 if (common_config('db','type') == 'pgsql') {
385 $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
387 $qry .= ' LIMIT ' . $offset . ', ' . $limit;
391 $profile = new Profile();
393 $profile->query(sprintf($qry, $this->id));
398 function getSubscribers($offset=0, $limit=null)
401 'SELECT profile.* ' .
402 'FROM profile JOIN subscription ' .
403 'ON profile.id = subscription.subscriber ' .
404 'WHERE subscription.subscribed = %d ' .
405 'AND subscription.subscribed != subscription.subscriber ' .
406 'ORDER BY subscription.created DESC ';
408 if ($offset>0 && !is_null($limit)){
410 if (common_config('db','type') == 'pgsql') {
411 $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
413 $qry .= ' LIMIT ' . $offset . ', ' . $limit;
418 $profile = new Profile();
420 $cnt = $profile->query(sprintf($qry, $this->id));
425 function getConnectedApps($offset = 0, $limit = null)
429 'FROM oauth_application_user u, oauth_application a ' .
430 'WHERE u.profile_id = %d ' .
431 'AND a.id = u.application_id ' .
432 'AND u.access_type > 0 ' .
433 'ORDER BY u.created DESC ';
436 if (common_config('db','type') == 'pgsql') {
437 $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
439 $qry .= ' LIMIT ' . $offset . ', ' . $limit;
443 $apps = new Oauth_application_user();
445 $cnt = $apps->query(sprintf($qry, $this->id));
450 function subscriptionCount()
452 $c = common_memcache();
455 $cnt = $c->get(common_cache_key('profile:subscription_count:'.$this->id));
456 if (is_integer($cnt)) {
461 $sub = new Subscription();
462 $sub->subscriber = $this->id;
464 $cnt = (int) $sub->count('distinct subscribed');
466 $cnt = ($cnt > 0) ? $cnt - 1 : $cnt;
469 $c->set(common_cache_key('profile:subscription_count:'.$this->id), $cnt);
475 function subscriberCount()
477 $c = common_memcache();
479 $cnt = $c->get(common_cache_key('profile:subscriber_count:'.$this->id));
480 if (is_integer($cnt)) {
485 $sub = new Subscription();
486 $sub->subscribed = $this->id;
487 $sub->whereAdd('subscriber != subscribed');
488 $cnt = (int) $sub->count('distinct subscriber');
491 $c->set(common_cache_key('profile:subscriber_count:'.$this->id), $cnt);
498 * Is this profile subscribed to another profile?
500 * @param Profile $other
503 function isSubscribed($other)
505 return Subscription::exists($this, $other);
509 * Are these two profiles subscribed to each other?
511 * @param Profile $other
514 function mutuallySubscribed($other)
516 return $this->isSubscribed($other) &&
517 $other->isSubscribed($this);
520 function hasFave($notice)
522 $cache = common_memcache();
524 // XXX: Kind of a hack.
526 if (!empty($cache)) {
527 // This is the stream of favorite notices, in rev chron
528 // order. This forces it into cache.
530 $ids = Fave::stream($this->id, 0, NOTICE_CACHE_WINDOW);
532 // If it's in the list, then it's a fave
534 if (in_array($notice->id, $ids)) {
538 // If we're not past the end of the cache window,
539 // then the cache has all available faves, so this one
542 if (count($ids) < NOTICE_CACHE_WINDOW) {
546 // Otherwise, cache doesn't have all faves;
547 // fall through to the default
550 $fave = Fave::pkeyGet(array('user_id' => $this->id,
551 'notice_id' => $notice->id));
552 return ((is_null($fave)) ? false : true);
557 $c = common_memcache();
559 $cnt = $c->get(common_cache_key('profile:fave_count:'.$this->id));
560 if (is_integer($cnt)) {
566 $faves->user_id = $this->id;
567 $cnt = (int) $faves->count('distinct notice_id');
570 $c->set(common_cache_key('profile:fave_count:'.$this->id), $cnt);
576 function noticeCount()
578 $c = common_memcache();
581 $cnt = $c->get(common_cache_key('profile:notice_count:'.$this->id));
582 if (is_integer($cnt)) {
587 $notices = new Notice();
588 $notices->profile_id = $this->id;
589 $cnt = (int) $notices->count('distinct id');
592 $c->set(common_cache_key('profile:notice_count:'.$this->id), $cnt);
598 function blowFavesCache()
600 $cache = common_memcache();
602 // Faves don't happen chronologically, so we need to blow
604 $cache->delete(common_cache_key('fave:ids_by_user:'.$this->id));
605 $cache->delete(common_cache_key('fave:ids_by_user:'.$this->id.';last'));
606 $cache->delete(common_cache_key('fave:ids_by_user_own:'.$this->id));
607 $cache->delete(common_cache_key('fave:ids_by_user_own:'.$this->id.';last'));
609 $this->blowFaveCount();
612 function blowSubscriberCount()
614 $c = common_memcache();
616 $c->delete(common_cache_key('profile:subscriber_count:'.$this->id));
620 function blowSubscriptionCount()
622 $c = common_memcache();
624 $c->delete(common_cache_key('profile:subscription_count:'.$this->id));
628 function blowFaveCount()
630 $c = common_memcache();
632 $c->delete(common_cache_key('profile:fave_count:'.$this->id));
636 function blowNoticeCount()
638 $c = common_memcache();
640 $c->delete(common_cache_key('profile:notice_count:'.$this->id));
644 static function maxBio()
646 $biolimit = common_config('profile', 'biolimit');
647 // null => use global limit (distinct from 0!)
648 if (is_null($biolimit)) {
649 $biolimit = common_config('site', 'textlimit');
654 static function bioTooLong($bio)
656 $biolimit = self::maxBio();
657 return ($biolimit > 0 && !empty($bio) && (mb_strlen($bio) > $biolimit));
662 $this->_deleteNotices();
663 $this->_deleteSubscriptions();
664 $this->_deleteMessages();
665 $this->_deleteTags();
666 $this->_deleteBlocks();
668 $related = array('Avatar',
672 Event::handle('ProfileDeleteRelated', array($this, &$related));
674 foreach ($related as $cls) {
676 $inst->profile_id = $this->id;
683 function _deleteNotices()
685 $notice = new Notice();
686 $notice->profile_id = $this->id;
688 if ($notice->find()) {
689 while ($notice->fetch()) {
690 $other = clone($notice);
696 function _deleteSubscriptions()
698 $sub = new Subscription();
699 $sub->subscriber = $this->id;
703 while ($sub->fetch()) {
704 $other = Profile::staticGet('id', $sub->subscribed);
708 if ($other->id == $this->id) {
711 Subscription::cancel($this, $other);
714 $subd = new Subscription();
715 $subd->subscribed = $this->id;
718 while ($subd->fetch()) {
719 $other = Profile::staticGet('id', $subd->subscriber);
723 if ($other->id == $this->id) {
726 Subscription::cancel($other, $this);
729 $self = new Subscription();
731 $self->subscriber = $this->id;
732 $self->subscribed = $this->id;
737 function _deleteMessages()
739 $msg = new Message();
740 $msg->from_profile = $this->id;
743 $msg = new Message();
744 $msg->to_profile = $this->id;
748 function _deleteTags()
750 $tag = new Profile_tag();
751 $tag->tagged = $this->id;
755 function _deleteBlocks()
757 $block = new Profile_block();
758 $block->blocked = $this->id;
761 $block = new Group_block();
762 $block->blocked = $this->id;
766 // XXX: identical to Notice::getLocation.
768 function getLocation()
772 if (!empty($this->location_id) && !empty($this->location_ns)) {
773 $location = Location::fromId($this->location_id, $this->location_ns);
776 if (is_null($location)) { // no ID, or Location::fromId() failed
777 if (!empty($this->lat) && !empty($this->lon)) {
778 $location = Location::fromLatLon($this->lat, $this->lon);
782 if (is_null($location)) { // still haven't found it!
783 if (!empty($this->location)) {
784 $location = Location::fromName($this->location);
791 function hasRole($name)
794 if (Event::handle('StartHasRole', array($this, $name, &$has_role))) {
795 $role = Profile_role::pkeyGet(array('profile_id' => $this->id,
797 $has_role = !empty($role);
798 Event::handle('EndHasRole', array($this, $name, $has_role));
803 function grantRole($name)
805 if (Event::handle('StartGrantRole', array($this, $name))) {
807 $role = new Profile_role();
809 $role->profile_id = $this->id;
811 $role->created = common_sql_now();
813 $result = $role->insert();
816 throw new Exception("Can't save role '$name' for profile '{$this->id}'");
819 Event::handle('EndGrantRole', array($this, $name));
825 function revokeRole($name)
827 if (Event::handle('StartRevokeRole', array($this, $name))) {
829 $role = Profile_role::pkeyGet(array('profile_id' => $this->id,
833 // TRANS: Exception thrown when trying to revoke an existing role for a user that does not exist.
834 // TRANS: %1$s is the role name, %2$s is the user ID (number).
835 throw new Exception(sprintf(_('Cannot revoke role "%1$s" for user #%2$d; does not exist.'),$name, $this->id));
838 $result = $role->delete();
841 common_log_db_error($role, 'DELETE', __FILE__);
842 // TRANS: Exception thrown when trying to revoke a role for a user with a failing database query.
843 // TRANS: %1$s is the role name, %2$s is the user ID (number).
844 throw new Exception(sprintf(_('Cannot revoke role "%1$s" for user #%2$d; database error.'),$name, $this->id));
847 Event::handle('EndRevokeRole', array($this, $name));
853 function isSandboxed()
855 return $this->hasRole(Profile_role::SANDBOXED);
858 function isSilenced()
860 return $this->hasRole(Profile_role::SILENCED);
865 $this->grantRole(Profile_role::SANDBOXED);
870 $this->revokeRole(Profile_role::SANDBOXED);
875 $this->grantRole(Profile_role::SILENCED);
880 $this->revokeRole(Profile_role::SILENCED);
884 * Does this user have the right to do X?
886 * With our role-based authorization, this is merely a lookup for whether the user
887 * has a particular role. The implementation currently uses a switch statement
888 * to determine if the user has the pre-defined role to exercise the right. Future
889 * implementations may allow per-site roles, and different mappings of roles to rights.
891 * @param $right string Name of the right, usually a constant in class Right
892 * @return boolean whether the user has the right in question
894 function hasRight($right)
898 if ($this->hasRole(Profile_role::DELETED)) {
902 if (Event::handle('UserRightsCheck', array($this, $right, &$result))) {
905 case Right::DELETEOTHERSNOTICE:
906 case Right::MAKEGROUPADMIN:
907 case Right::SANDBOXUSER:
908 case Right::SILENCEUSER:
909 case Right::DELETEUSER:
910 case Right::DELETEGROUP:
911 $result = $this->hasRole(Profile_role::MODERATOR);
913 case Right::CONFIGURESITE:
914 $result = $this->hasRole(Profile_role::ADMINISTRATOR);
916 case Right::GRANTROLE:
917 case Right::REVOKEROLE:
918 $result = $this->hasRole(Profile_role::OWNER);
920 case Right::NEWNOTICE:
921 case Right::NEWMESSAGE:
922 case Right::SUBSCRIBE:
923 $result = !$this->isSilenced();
925 case Right::PUBLICNOTICE:
926 case Right::EMAILONREPLY:
927 case Right::EMAILONSUBSCRIBE:
928 case Right::EMAILONFAVE:
929 $result = !$this->isSandboxed();
939 function hasRepeated($notice_id)
941 // XXX: not really a pkey, but should work
943 $notice = Memcached_DataObject::pkeyGet('Notice',
944 array('profile_id' => $this->id,
945 'repeat_of' => $notice_id));
947 return !empty($notice);
951 * Returns an XML string fragment with limited profile information
952 * as an Atom <author> element.
954 * Assumes that Atom has been previously set up as the base namespace.
956 * @param Profile $cur the current authenticated user
960 function asAtomAuthor($cur = null)
962 $xs = new XMLStringer(true);
964 $xs->elementStart('author');
965 $xs->element('name', null, $this->nickname);
966 $xs->element('uri', null, $this->getUri());
969 $attrs['following'] = $cur->isSubscribed($this) ? 'true' : 'false';
970 $attrs['blocking'] = $cur->hasBlocked($this) ? 'true' : 'false';
971 $xs->element('statusnet:profile_info', $attrs, null);
973 $xs->elementEnd('author');
975 return $xs->getString();
979 * Returns an XML string fragment with profile information as an
980 * Activity Streams <activity:actor> element.
982 * Assumes that 'activity' namespace has been previously defined.
986 function asActivityActor()
988 return $this->asActivityNoun('actor');
992 * Returns an XML string fragment with profile information as an
993 * Activity Streams noun object with the given element type.
995 * Assumes that 'activity', 'georss', and 'poco' namespace has been
996 * previously defined.
998 * @param string $element one of 'actor', 'subject', 'object', 'target'
1002 function asActivityNoun($element)
1004 $noun = ActivityObject::fromProfile($this);
1005 return $noun->asString('activity:' . $element);
1009 * Returns the best URI for a profile. Plugins may override.
1011 * @return string $uri
1017 // give plugins a chance to set the URI
1018 if (Event::handle('StartGetProfileUri', array($this, &$uri))) {
1020 // check for a local user first
1021 $user = User::staticGet('id', $this->id);
1023 if (!empty($user)) {
1026 // return OMB profile if any
1027 $remote = Remote_profile::staticGet('id', $this->id);
1028 if (!empty($remote)) {
1029 $uri = $remote->uri;
1032 Event::handle('EndGetProfileUri', array($this, &$uri));
1038 function hasBlocked($other)
1040 $block = Profile_block::get($this->id, $other->id);
1042 if (empty($block)) {
1051 function getAtomFeed()
1055 if (Event::handle('StartProfileGetAtomFeed', array($this, &$feed))) {
1056 $user = User::staticGet('id', $this->id);
1057 if (!empty($user)) {
1058 $feed = common_local_url('ApiTimelineUser', array('id' => $user->id,
1059 'format' => 'atom'));
1061 Event::handle('EndProfileGetAtomFeed', array($this, $feed));
1067 static function fromURI($uri)
1071 if (Event::handle('StartGetProfileFromURI', array($uri, &$profile))) {
1072 // Get a local user or remote (OMB 0.1) profile
1073 $user = User::staticGet('uri', $uri);
1074 if (!empty($user)) {
1075 $profile = $user->getProfile();
1077 $remote_profile = Remote_profile::staticGet('uri', $uri);
1078 if (!empty($remote_profile)) {
1079 $profile = Profile::staticGet('id', $remote_profile->profile_id);
1082 Event::handle('EndGetProfileFromURI', array($uri, $profile));