3 * Laconica - a distributed open-source microblogging tool
4 * Copyright (C) 2008, Controlez-Vous, 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('LACONICA')) { exit(1); }
22 * Table Definition for user
24 require_once 'DB/DataObject.php';
25 require_once 'Validate.php';
27 class User extends DB_DataObject
30 /* the code below is auto generated do not remove the above tag */
32 public $__table = 'user'; // table name
33 public $id; // int(4) primary_key not_null
34 public $nickname; // varchar(64) unique_key
35 public $password; // varchar(255)
36 public $email; // varchar(255) unique_key
37 public $incomingemail; // varchar(255) unique_key
38 public $emailnotifysub; // tinyint(1) default_1
39 public $jabber; // varchar(255) unique_key
40 public $jabbernotify; // tinyint(1)
41 public $jabberreplies; // tinyint(1)
42 public $updatefrompresence; // tinyint(1)
43 public $sms; // varchar(64) unique_key
44 public $carrier; // int(4)
45 public $smsnotify; // tinyint(1)
46 public $smsreplies; // tinyint(1)
47 public $smsemail; // varchar(255)
48 public $uri; // varchar(255) unique_key
49 public $autosubscribe; // tinyint(1)
50 public $created; // datetime() not_null
51 public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
54 function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('User',$k,$v); }
56 /* the code above is auto generated do not remove the tag below */
59 function getProfile() {
60 $profile = DB_DataObject::factory('profile');
61 $profile->id = $this->id;
62 if ($profile->find()) {
69 function isSubscribed($other) {
70 assert(!is_null($other));
71 $sub = DB_DataObject::factory('subscription');
72 $sub->subscriber = $this->id;
73 $sub->subscribed = $other->id;
77 # 'update' won't write key columns, so we have to do it ourselves.
79 function updateKeys(&$orig) {
81 foreach (array('nickname', 'email', 'jabber', 'sms', 'carrier') as $k) {
82 if (strcmp($this->$k, $orig->$k) != 0) {
83 $parts[] = $k . ' = ' . $this->_quote($this->$k);
86 if (count($parts) == 0) {
90 $toupdate = implode(', ', $parts);
91 $qry = 'UPDATE ' . $this->tableName() . ' SET ' . $toupdate .
92 ' WHERE id = ' . $this->id;
93 return $this->query($qry);
96 function allowed_nickname($nickname) {
97 # XXX: should already be validated for size, content, etc.
98 static $blacklist = array('rss', 'xrds', 'doc', 'main',
99 'settings', 'notice', 'user',
101 $merged = array_merge($blacklist, common_config('nickname', 'blacklist'));
102 return !in_array($nickname, $merged);
105 function getCurrentNotice($dt=NULL) {
106 $profile = $this->getProfile();
110 return $profile->getCurrentNotice($dt);
113 function getCarrier() {
114 return Sms_carrier::staticGet($this->carrier);
117 function subscribeTo($other) {
118 $sub = new Subscription();
119 $sub->subscriber = $this->id;
120 $sub->subscribed = $other->id;
122 $sub->created = DB_DataObject_Cast::dateTime(); # current time
124 if (!$sub->insert()) {
131 function noticesWithFriends($offset=0, $limit=20) {
133 $notice = new Notice();
135 $notice->query('SELECT notice.* ' .
136 'FROM notice JOIN subscription on notice.profile_id = subscription.subscribed ' .
137 'WHERE subscription.subscriber = ' . $this->id . ' ' .
138 'ORDER BY created DESC, notice.id DESC ' .
139 'LIMIT ' . $offset . ', ' . $limit);