Session construction query uses account (some fields still have to be moved).
[platal.git] / classes / xorgsession.php
1 <?php
2 /***************************************************************************
3 * Copyright (C) 2003-2008 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
5 * *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
10 * *
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 General Public License for more details. *
15 * *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
18 * Foundation, Inc., *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
21
22 class XorgSession extends PlSession
23 {
24 public function __construct()
25 {
26 parent::__construct();
27 }
28
29 public function startAvailableAuth()
30 {
31 if (!S::logged()) {
32 $cookie = $this->tryCookie();
33 if ($cookie == 0) {
34 return $this->start(AUTH_COOKIE);
35 } else if ($cookie == 1 || $cookie == -2) {
36 return false;
37 }
38 }
39 if ((check_ip('dangerous') && S::has('uid')) || check_account()) {
40 $_SESSION['log']->log("view_page", $_SERVER['REQUEST_URI']);
41 }
42 return true;
43 }
44
45 /** Check the cookie and set the associated user_id in the auth_by_cookie session variable.
46 */
47 private function tryCookie()
48 {
49 S::kill('auth_by_cookie');
50 if (Cookie::v('ORGaccess') == '' || !Cookie::has('ORGuid')) {
51 return -1;
52 }
53
54 $res = XDB::query('SELECT uid, password
55 FROM accounts
56 WHERE uid = {?} AND state = \'active\'',
57 Cookie::i('ORGuid'));
58 if ($res->numRows() != 0) {
59 list($uid, $password) = $res->fetchOneRow();
60 $expected_value = sha1($password);
61 if ($expected_value == Cookie::v('ORGaccess')) {
62 S::set('auth_by_cookie', $uid);
63 return 0;
64 } else {
65 return 1;
66 }
67 }
68 return -2;
69 }
70
71 private function checkPassword($uname, $login, $response, $login_type)
72 {
73 $res = XDB::query('SELECT a.uid, a.password
74 FROM accounts AS a
75 INNER JOIN aliases AS l ON (l.id = a.uid AND l.type != \'homonyme\')
76 WHERE l.' . $login_type . ' = {?} AND a.state = \'active\'',
77 $login);
78 if (list($uid, $password) = $res->fetchOneRow()) {
79 $expected_response = sha1("$uname:$password:" . S::v('challenge'));
80 /* XXX: Deprecates len(password) > 10 conversion */
81 if ($response != $expected_response) {
82 S::logger($uid)->log('auth_fail', 'bad password');
83 return null;
84 }
85 return $uid;
86 }
87 return null;
88 }
89
90
91 /** Check auth.
92 */
93 protected function doAuth($level)
94 {
95 global $globals;
96
97 /* Cookie authentication
98 */
99 if ($level == AUTH_COOKIE && !S::has('auth_by_cookie')) {
100 $this->tryCookie();
101 }
102 if ($level == AUTH_COOKIE && S::has('auth_by_cookie')) {
103 if (!S::logged()) {
104 S::set('auth', AUTH_COOKIE);
105 }
106 return S::i('auth_by_cookie');
107 }
108
109
110 /* We want to do auth... we must have infos from a form.
111 */
112 if (!Post::has('username') || !Post::has('response') || !S::has('challenge')) {
113 return null;
114 }
115
116 /** We come from an authentication form.
117 */
118 if (S::has('suid')) {
119 $suid = S::v('suid');
120 $login = $uname = $suid['uid'];
121 $redirect = false;
122 } else {
123 $uname = Env::v('username');
124 if (Env::v('domain') == "alias") {
125 $res = XDB::query('SELECT redirect
126 FROM virtual
127 INNER JOIN virtual_redirect USING(vid)
128 WHERE alias LIKE {?}',
129 $uname . '@' . $globals->mail->alias_dom);
130 $redirect = $res->fetchOneCell();
131 if ($redirect) {
132 $login = substr($redirect, 0, strpos($redirect, '@'));
133 } else {
134 $login = '';
135 }
136 } else {
137 $login = $uname;
138 $redirect = false;
139 }
140 }
141
142 $uid = $this->checkPassword($uname, $login, Post::v('response'), (!$redirect && is_numeric($uname)) ? 'id' : 'alias');
143 if (!is_null($uid) && S::has('suid')) {
144 $suid = S::v('suid');
145 if ($suid['uid'] == $uid) {
146 $uid = S::i('uid');
147 } else {
148 $uid = null;
149 }
150 }
151 if (!is_null($uid)) {
152 S::set('auth', AUTH_MDP);
153 if (!S::has('suid')) {
154 if (Post::has('domain')) {
155 if (($domain = Post::v('domain', 'login')) == 'alias') {
156 setcookie('ORGdomain', "alias", (time() + 25920000), '/', '', 0);
157 } else {
158 setcookie('ORGdomain', '', (time() - 3600), '/', '', 0);
159 }
160 // pour que la modification soit effective dans le reste de la page
161 $_COOKIE['ORGdomain'] = $domain;
162 }
163 }
164 S::kill('challenge');
165 S::logger($uid)->log('auth_ok');
166 }
167 return $uid;
168 }
169
170 protected function startSessionAs($uid, $level)
171 {
172 if ((!is_null(S::v('user')) && S::i('user') != $uid) || (S::has('uid') && S::i('uid') != $uid)) {
173 return false;
174 } else if (S::has('uid')) {
175 return true;
176 }
177 if ($level == AUTH_SUID) {
178 S::set('auth', AUTH_MDP);
179 }
180 unset($_SESSION['log']);
181
182 // Retrieves main user properties.
183 /** TODO: Move needed informations to account tables */
184 /** TODO: Currently suppressed data are matricule, promo */
185 /** TODO: Data to move are: banana_last, watch_last, last_version */
186 /** TODO: Switch to new permission system */
187 $res = XDB::query("SELECT a.uid, a.hruid, a.display_name, a.full_name, a.password,
188 a.sex = 'female' AS femme, a.mail_format as mail_fmt,
189 a.token, FIND_IN_SET('watch', a.flags) AS watch_account,
190 UNIX_TIMESTAMP(q.banana_last) AS banana_last, q.watch_last,
191 q.last_version, g.g_account_name IS NOT NULL AS googleapps,
192 UNIX_TIMESTAMP(s.start) AS lastlogin, s.host,
193 IF(a.is_admin, 'admin', 'user') AS perms
194 FROM accounts AS a
195 INNER JOIN auth_user_quick AS q ON(a.uid = q.user_id)
196 LEFT JOIN gapps_accounts AS g ON(a.uid = g.l_userid AND g.g_status = 'active')
197 LEFT JOIN logger.last_sessions AS ls ON (ls.uid = a.uid)
198 LEFT JOIN logger.sessions AS s ON(s.id = ls.id)
199 WHERE a.uid = {?} AND a.state = 'active'", $uid);
200 $sess = $res->fetchOneAssoc();
201 $perms = $sess['perms'];
202 unset($sess['perms']);
203
204 // Loads the data into the real session.
205 $_SESSION = array_merge($_SESSION, $sess);
206
207 // Starts the session's logger, and sets up the permanent cookie.
208 if (S::has('suid')) {
209 $suid = S::v('suid');
210 $logger = S::logger($uid);
211 $logger->log("suid_start", S::v('hruid') . " by " . $suid['hruid']);
212 } else {
213 $logger = S::logger($uid);
214 $logger->saveLastSession();
215 setcookie('ORGuid', $uid, (time() + 25920000), '/', '', 0);
216
217 if (S::i('auth_by_cookie') == $uid || Post::v('remember', 'false') == 'true') {
218 $cookie = sha1($sess['password']);
219 setcookie('ORGaccess', $cookie, (time() + 25920000), '/', '', 0);
220 if ($logger && S::i('auth_by_cookie') != $uid) {
221 $logger->log("cookie_on");
222 }
223 } else {
224 setcookie('ORGaccess', '', time() - 3600, '/', '', 0);
225 if ($logger) {
226 $logger->log("cookie_off");
227 }
228 }
229 }
230
231 // Finalizes the session setup.
232 S::set('perms', User::makePerms($perms));
233 $this->securityChecks();
234 $this->setSkin();
235 $this->updateNbNotifs();
236 check_redirect();
237
238 // We should not have to use this private data anymore
239 S::kill('auth_by_cookie');
240 return true;
241 }
242
243 private function securityChecks()
244 {
245 $mail_subject = array();
246 if (check_account()) {
247 $mail_subject[] = 'Connexion d\'un utilisateur surveillé';
248 }
249 if (check_ip('unsafe')) {
250 $mail_subject[] = 'Une IP surveillee a tente de se connecter';
251 if (check_ip('ban')) {
252 send_warning_mail(implode(' - ', $mail_subject));
253 $this->destroy();
254 Platal::page()->kill('Une erreur est survenue lors de la procédure d\'authentification. '
255 . 'Merci de contacter au plus vite '
256 . '<a href="mailto:support@polytechnique.org">support@polytechnique.org</a>');
257 return false;
258 }
259 }
260 if (count($mail_subject)) {
261 send_warning_mail(implode(' - ', $mail_subject));
262 }
263 }
264
265 public function tokenAuth($login, $token)
266 {
267 $res = XDB::query('SELECT a.hruid
268 FROM aliases AS l
269 INNER JOIN accounts AS a ON (l.id = a.uid AND a.state = \'active\')
270 WHERE a.token = {?} AND l.alias = {?} AND l.type != \'homonyme\'',
271 $token, $login);
272 if ($res->numRows() == 1) {
273 $data = $res->fetchOneAssoc();
274 return new User($data['hruid'], $data);
275 }
276 return null;
277 }
278
279 public function makePerms($perm)
280 {
281 $flags = new PlFlagSet();
282 if ($perm == 'disabled' || $perm == 'ext') {
283 S::set('perms', $flags);
284 return;
285 }
286 $flags->addFlag(PERMS_USER);
287 if ($perm == 'admin') {
288 $flags->addFlag(PERMS_ADMIN);
289 }
290 S::set('perms', $flags);
291 }
292
293 public function setSkin()
294 {
295 if (S::logged() && (!S::has('skin') || S::has('suid'))) {
296 $uid = S::v('uid');
297 $res = XDB::query('SELECT skin_tpl
298 FROM accounts AS a
299 INNER JOIN skins AS s on (a.skin = s.id)
300 WHERE a.uid = {?} AND skin_tpl != \'\'', S::i('uid'));
301 S::set('skin', $res->fetchOneCell());
302 }
303 }
304
305 public function loggedLevel()
306 {
307 return AUTH_COOKIE;
308 }
309
310 public function sureLevel()
311 {
312 return AUTH_MDP;
313 }
314
315
316 public function updateNbNotifs()
317 {
318 require_once 'notifs.inc.php';
319 $n = select_notifs(false, S::i('uid'), S::v('watch_last'), false);
320 S::set('notifs', $n->numRows());
321 }
322 }
323
324 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
325 ?>