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 $emailmicroid; // tinyint(1) default_1
40 public $language; // varchar(50)
41 public $timezone; // varchar(50)
42 public $emailpost; // tinyint(1) default_1
43 public $jabber; // varchar(255) unique_key
44 public $jabbernotify; // tinyint(1)
45 public $jabberreplies; // tinyint(1)
46 public $jabbermicroid; // tinyint(1) default_1
47 public $updatefrompresence; // tinyint(1)
48 public $sms; // varchar(64) unique_key
49 public $carrier; // int(4)
50 public $smsnotify; // tinyint(1)
51 public $smsreplies; // tinyint(1)
52 public $smsemail; // varchar(255)
53 public $uri; // varchar(255) unique_key
54 public $autosubscribe; // tinyint(1)
55 public $created; // datetime() not_null
56 public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
59 function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('User',$k,$v); }
61 /* the code above is auto generated do not remove the tag below */
64 function getProfile() {
65 $profile = DB_DataObject::factory('profile');
66 $profile->id = $this->id;
67 if ($profile->find()) {
74 function isSubscribed($other) {
75 assert(!is_null($other));
76 $sub = DB_DataObject::factory('subscription');
77 $sub->subscriber = $this->id;
78 $sub->subscribed = $other->id;
82 # 'update' won't write key columns, so we have to do it ourselves.
84 function updateKeys(&$orig) {
86 foreach (array('nickname', 'email', 'jabber', 'incomingemail', 'sms', 'carrier', 'smsemail', 'language', 'timezone') as $k) {
87 if (strcmp($this->$k, $orig->$k) != 0) {
88 $parts[] = $k . ' = ' . $this->_quote($this->$k);
91 if (count($parts) == 0) {
95 $toupdate = implode(', ', $parts);
96 $qry = 'UPDATE ' . $this->tableName() . ' SET ' . $toupdate .
97 ' WHERE id = ' . $this->id;
98 return $this->query($qry);
101 function allowed_nickname($nickname) {
102 # XXX: should already be validated for size, content, etc.
103 static $blacklist = array('rss', 'xrds', 'doc', 'main',
104 'settings', 'notice', 'user',
106 $merged = array_merge($blacklist, common_config('nickname', 'blacklist'));
107 return !in_array($nickname, $merged);
110 function getCurrentNotice($dt=NULL) {
111 $profile = $this->getProfile();
115 return $profile->getCurrentNotice($dt);
118 function getCarrier() {
119 return Sms_carrier::staticGet($this->carrier);
122 function subscribeTo($other) {
123 $sub = new Subscription();
124 $sub->subscriber = $this->id;
125 $sub->subscribed = $other->id;
127 $sub->created = DB_DataObject_Cast::dateTime(); # current time
129 if (!$sub->insert()) {
136 function noticesWithFriends($offset=0, $limit=20) {
138 $notice = new Notice();
140 $notice->query('SELECT notice.* ' .
141 'FROM notice JOIN subscription on notice.profile_id = subscription.subscribed ' .
142 'WHERE subscription.subscriber = ' . $this->id . ' ' .
143 'ORDER BY created DESC, notice.id DESC ' .
144 'LIMIT ' . $offset . ', ' . $limit);