Table editor fills the new entry form with the default values of the fields
[platal.git] / modules / platal.php
CommitLineData
e59506eb 1<?php
2/***************************************************************************
3 * Copyright (C) 2003-2006 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
5de0b7e1 22function bugize($list)
23{
24 $list = split(',', $list);
25 $ans = array();
26
27 foreach ($list as $bug) {
28 $clean = str_replace('#', '', $bug);
29 $ans[] = "<a href='http://trackers.polytechnique.org/task/$clean'>$bug</a>";
30 }
31
32 return join(',', $ans);
33}
34
35
e59506eb 36class PlatalModule extends PLModule
37{
38 function handlers()
39 {
40 return array(
c9178c75 41 'index' => $this->make_hook('index', AUTH_PUBLIC),
dc41059a 42 'cacert.pem' => $this->make_hook('cacert', AUTH_PUBLIC),
5de0b7e1 43 'changelog' => $this->make_hook('changelog', AUTH_PUBLIC),
44
4da0b8d7 45 // Preferences thingies
bee33d93 46 'prefs' => $this->make_hook('prefs', AUTH_COOKIE),
47 'prefs/rss' => $this->make_hook('prefs_rss', AUTH_COOKIE),
bce2f8eb 48 'prefs/webredirect'
bee33d93 49 => $this->make_hook('webredir', AUTH_MDP),
50 'prefs/skin' => $this->make_hook('skin', AUTH_COOKIE),
4da0b8d7 51
52 // password related thingies
1a5da857 53 'password' => $this->make_hook('password', AUTH_MDP),
54 'tmpPWD' => $this->make_hook('tmpPWD', AUTH_PUBLIC),
55 'password/smtp' => $this->make_hook('smtppass', AUTH_MDP),
8858cfc1 56 'recovery' => $this->make_hook('recovery', AUTH_PUBLIC),
5de0b7e1 57 'exit' => $this->make_hook('exit', AUTH_PUBLIC),
58abb43b 58 'deconnexion.php' => $this->make_hook('exit', AUTH_PUBLIC),
4da0b8d7 59
60 // happenings related thingies
61 'rss' => $this->make_hook('rss', AUTH_PUBLIC),
e59506eb 62 );
63 }
64
c9178c75 65 function handler_index(&$page)
66 {
cab08090 67 if (S::logged()) {
8b00e0e0 68 pl_redirect('events');
c9178c75 69 }
c9178c75 70 }
71
5de0b7e1 72 function handler_cacert(&$page)
73 {
ca877168 74 $data = file_get_contents("/etc/ssl/xorgCA/cacert.pem","r");
75 header("Pragma:");
dc41059a 76 header("Set-Cookie:");
77 header("Cache-Control:");
78 header("Expires:");
79 header("Content-Type: application/x-x509-ca-cert");
ca877168 80 header("Content-Length: ".strlen($data));
5de0b7e1 81 echo $data;
82 exit;
83 }
84
85 function handler_changelog(&$page)
86 {
87 $page->changeTpl('changeLog.tpl');
88
89 $clog = htmlentities(file_get_contents(dirname(__FILE__).'/../ChangeLog'));
90 $clog = preg_replace('!(#[0-9]+(,[0-9]+)*)!e', 'bugize("\1")', $clog);
9408f155 91 $clog = preg_replace('!vim:.*$!', '', $clog);
5de0b7e1 92 $page->assign('ChangeLog', $clog);
93 }
94
7927d719 95 function __set_rss_state($state)
96 {
7927d719 97 if ($state) {
98 $_SESSION['core_rss_hash'] = rand_url_id(16);
08cce2ff 99 XDB::execute('UPDATE auth_user_quick
7927d719 100 SET core_rss_hash={?} WHERE user_id={?}',
cab08090 101 S::v('core_rss_hash'), S::v('uid'));
7927d719 102 } else {
08cce2ff 103 XDB::execute('UPDATE auth_user_quick
7927d719 104 SET core_rss_hash="" WHERE user_id={?}',
cab08090 105 S::v('uid'));
106 S::kill('core_rss_hash');
7927d719 107 }
108 }
109
e59506eb 110 function handler_prefs(&$page)
111 {
e59506eb 112 $page->changeTpl('preferences.tpl');
113 $page->assign('xorg_title','Polytechnique.org - Mes préférences');
114
bee33d93 115 if (Post::has('mail_fmt')) {
5e2307dc 116 $fmt = Post::v('mail_fmt');
e59506eb 117 if ($fmt != 'texte') $fmt = 'html';
08cce2ff 118 XDB::execute("UPDATE auth_user_quick
e59506eb 119 SET core_mail_fmt = '$fmt'
120 WHERE user_id = {?}",
cab08090 121 S::v('uid'));
e59506eb 122 $_SESSION['mail_fmt'] = $fmt;
e59506eb 123 }
124
bee33d93 125 if (Post::has('rss')) {
5e2307dc 126 $this->__set_rss_state(Post::b('rss'));
e59506eb 127 }
e59506eb 128 }
9bae6004 129
bce2f8eb 130 function handler_webredir(&$page)
131 {
bce2f8eb 132 $page->changeTpl('webredirect.tpl');
133
134 $page->assign('xorg_title','Polytechnique.org - Redirection de page WEB');
135
cab08090 136 $log =& S::v('log');
5e2307dc 137 $url = Env::v('url');
bce2f8eb 138
5e2307dc 139 if (Env::v('submit') == 'Valider' and Env::has('url')) {
08cce2ff 140 XDB::execute('UPDATE auth_user_quick
bce2f8eb 141 SET redirecturl = {?} WHERE user_id = {?}',
cab08090 142 $url, S::v('uid'));
5e2307dc 143 $log->log('carva_add', 'http://'.Env::v('url'));
bce2f8eb 144 $page->trig("Redirection activée vers <a href='http://$url'>$url</a>");
5e2307dc 145 } elseif (Env::v('submit') == "Supprimer") {
08cce2ff 146 XDB::execute("UPDATE auth_user_quick
bce2f8eb 147 SET redirecturl = ''
148 WHERE user_id = {?}",
cab08090 149 S::v('uid'));
bce2f8eb 150 $log->log("carva_del", $url);
151 Post::kill('url');
152 $page->trig('Redirection supprimée');
153 }
154
08cce2ff 155 $res = XDB::query('SELECT redirecturl
bce2f8eb 156 FROM auth_user_quick
157 WHERE user_id = {?}',
cab08090 158 S::v('uid'));
bce2f8eb 159 $page->assign('carva', $res->fetchOneCell());
bce2f8eb 160 }
161
4da0b8d7 162 function handler_prefs_rss(&$page)
7927d719 163 {
7927d719 164 $page->changeTpl('filrss.tpl');
165
5e2307dc 166 $page->assign('goback', Env::v('referer', 'login'));
7927d719 167
5e2307dc 168 if (Env::v('act_rss') == 'Activer') {
7927d719 169 $this->__set_rss_state(true);
170 $page->trig("Ton Fil RSS est activé.");
171 }
7927d719 172 }
173
7c77c3ee 174 function handler_password(&$page)
175 {
7c77c3ee 176 if (Post::has('response2')) {
177 require_once 'secure_hash.inc.php';
178
5e2307dc 179 $_SESSION['password'] = $password = Post::v('response2');
7c77c3ee 180
08cce2ff 181 XDB::execute('UPDATE auth_user_md5
7c77c3ee 182 SET password={?}
183 WHERE user_id={?}', $password,
cab08090 184 S::v('uid'));
7c77c3ee 185
cab08090 186 $log =& S::v('log');
7c77c3ee 187 $log->log('passwd', '');
188
5e2307dc 189 if (Cookie::v('ORGaccess')) {
7c77c3ee 190 setcookie('ORGaccess', hash_encrypt($password), (time()+25920000), '/', '' ,0);
191 }
192
193 $page->changeTpl('motdepasse.success.tpl');
eb56722b 194 $page->assign('now', strftime("%Y%m%d%H%M%S"));
7c77c3ee 195 $page->run();
196 }
197
198 $page->changeTpl('motdepasse.tpl');
c99ef281 199 $page->addJsLink('motdepasse.js');
7c77c3ee 200 $page->assign('xorg_title','Polytechnique.org - Mon mot de passe');
7c77c3ee 201 }
202
1a5da857 203 function handler_smtppass(&$page)
204 {
1a5da857 205 $page->changeTpl('acces_smtp.tpl');
206 $page->assign('xorg_title','Polytechnique.org - Acces SMTP/NNTP');
207
cab08090 208 $uid = S::v('uid');
5e2307dc 209 $pass = Env::v('smtppass1');
cab08090 210 $log = S::v('log');
1a5da857 211
5e2307dc 212 if (Env::v('op') == "Valider" && strlen($pass) >= 6
213 && Env::v('smtppass1') == Env::v('smtppass2'))
1a5da857 214 {
08cce2ff 215 XDB::execute('UPDATE auth_user_md5 SET smtppass = {?}
1a5da857 216 WHERE user_id = {?}', $pass, $uid);
217 $page->trig('Mot de passe enregistré');
218 $log->log("passwd_ssl");
5e2307dc 219 } elseif (Env::v('op') == "Supprimer") {
08cce2ff 220 XDB::execute('UPDATE auth_user_md5 SET smtppass = ""
1a5da857 221 WHERE user_id = {?}', $uid);
222 $page->trig('Compte SMTP et NNTP supprimé');
223 $log->log("passwd_del");
224 }
225
08cce2ff 226 $res = XDB::query("SELECT IF(smtppass != '', 'actif', '')
1a5da857 227 FROM auth_user_md5
228 WHERE user_id = {?}", $uid);
229 $page->assign('actif', $res->fetchOneCell());
1a5da857 230 }
231
8858cfc1 232 function handler_recovery(&$page)
233 {
234 global $globals;
235
236 $page->changeTpl('recovery.tpl');
237
238 if (!Env::has('login') || !Env::has('birth')) {
fd8f77de 239 return;
8858cfc1 240 }
241
5e2307dc 242 if (!ereg('[0-3][0-9][0-1][0-9][1][9]([0-9]{2})', Env::v('birth'))) {
c9110c6c 243 $page->trig('Date de naissance incorrecte ou incohérente');
244 return;
8858cfc1 245 }
c9110c6c 246
247 $birth = sprintf('%s-%s-%s',
5e2307dc 248 substr(Env::v('birth'), 4, 4),
249 substr(Env::v('birth'), 2, 2),
250 substr(Env::v('birth'), 0, 2));
8858cfc1 251
5e2307dc 252 $mailorg = strtok(Env::v('login'), '@');
8858cfc1 253
254 // paragraphe rajouté : si la date de naissance dans la base n'existe pas, on l'update
255 // avec celle fournie ici en espérant que c'est la bonne
256
08cce2ff 257 $res = XDB::query(
8858cfc1 258 "SELECT user_id, naissance
259 FROM auth_user_md5 AS u
3a5c1551 260 INNER JOIN aliases AS a ON (u.user_id=a.id AND type != 'homonyme')
8858cfc1 261 WHERE a.alias={?} AND u.perms IN ('admin','user') AND u.deces=0", $mailorg);
262 list($uid, $naissance) = $res->fetchOneRow();
263
264 if ($naissance == $birth) {
265 $page->assign('ok', true);
266
267 $url = rand_url_id();
08cce2ff 268 XDB::execute('INSERT INTO perte_pass (certificat,uid,created) VALUES ({?},{?},NOW())', $url, $uid);
269 $res = XDB::query('SELECT email FROM emails WHERE uid = {?} AND NOT FIND_IN_SET("filter", flags)', $uid);
8858cfc1 270 $mails = implode(', ', $res->fetchColumn());
271
272 require_once "diogenes/diogenes.hermes.inc.php";
273 $mymail = new HermesMailer();
274 $mymail->setFrom('"Gestion des mots de passe" <support+password@polytechnique.org>');
275 $mymail->addTo($mails);
276 $mymail->setSubject('Ton certificat d\'authentification');
277 $mymail->setTxtBody("Visite la page suivante qui expire dans six heures :
278{$globals->baseurl}/tmpPWD/$url
279
280Si en cliquant dessus tu n'y arrives pas, copie intégralement l'adresse dans la barre de ton navigateur.
281
282--
283Polytechnique.org
5e2307dc 284\"Le portail des élèves & anciens élèves de l'Ecole polytechnique\"".(Post::v('email') ? "
8858cfc1 285
286Adresse de secours :
5e2307dc 287 ".Post::v('email') : "")."
8858cfc1 288
5e2307dc 289Mail envoyé à ".Env::v('login'));
8858cfc1 290 $mymail->send();
291
292 // on cree un objet logger et on log l'evenement
c4271d38 293 $logger = $_SESSION['log'] = new CoreLogger($uid);
8858cfc1 294 $logger->log('recovery', $emails);
295 } else {
3a5c1551 296 $page->trig('Les informations que tu as rentrées ne permettent pas de récupérer ton mot de passe.<br />'.
297 'Si tu as un homonyme, utilise prenom.nom.promo comme login');
8858cfc1 298 }
8858cfc1 299 }
300
6c49d0af 301 function handler_tmpPWD(&$page, $certif = null)
302 {
08cce2ff 303 XDB::execute('DELETE FROM perte_pass
6c49d0af 304 WHERE DATE_SUB(NOW(), INTERVAL 380 MINUTE) > created');
305
08cce2ff 306 $res = XDB::query('SELECT uid FROM perte_pass WHERE certificat={?}', $certif);
6c49d0af 307 $ligne = $res->fetchOneAssoc();
308 if (!$ligne) {
309 $page->changeTpl('index.tpl');
310 $page->kill("Cette adresse n'existe pas ou n'existe plus sur le serveur.");
311 }
312
313 $uid = $ligne["uid"];
314 if (Post::has('response2')) {
5e2307dc 315 $password = Post::v('response2');
c4271d38 316 $logger = new CoreLogger($uid);
08cce2ff 317 XDB::query('UPDATE auth_user_md5 SET password={?}
6c49d0af 318 WHERE user_id={?} AND perms IN("admin","user")',
319 $password, $uid);
08cce2ff 320 XDB::query('DELETE FROM perte_pass WHERE certificat={?}', $certif);
6c49d0af 321 $logger->log("passwd","");
322 $page->changeTpl('tmpPWD.success.tpl');
eb56722b 323 $page->assign('now', strftime("%Y%m%d%H%M%S"));
6c49d0af 324 } else {
325 $page->changeTpl('motdepasse.tpl');
c99ef281 326 $page->addJsLink('motdepasse.js');
6c49d0af 327 }
6c49d0af 328 }
329
9bae6004 330 function handler_skin(&$page)
331 {
332 global $globals;
333
f09cee18 334 $page->changeTpl('skins.tpl');
9bae6004 335 $page->assign('xorg_title','Polytechnique.org - Skins');
336
337 if (Env::has('newskin')) { // formulaire soumis, traitons les données envoyées
08cce2ff 338 XDB::execute('UPDATE auth_user_quick
63528107 339 SET skin={?} WHERE user_id={?}',
5e2307dc 340 Env::i('newskin'), S::v('uid'));
92e6a287 341 S::kill('skin');
9bae6004 342 set_skin();
343 }
344
92e6a287 345 $res = XDB::query('SELECT id FROM skins WHERE skin_tpl={?}', S::v('skin'));
346 $page->assign('skin_id', $res->fetchOneCell());
347
9bae6004 348 $sql = "SELECT s.*,auteur,count(*) AS nb
349 FROM skins AS s
350 LEFT JOIN auth_user_quick AS a ON s.id=a.skin
351 WHERE skin_tpl != '' AND ext != ''
352 GROUP BY id ORDER BY s.date DESC";
08cce2ff 353 $page->assign_by_ref('skins', XDB::iterator($sql));
9bae6004 354 }
4da0b8d7 355
5de0b7e1 356 function handler_exit(&$page, $level = null)
357 {
cab08090 358 if (S::has('suid')) {
359 if (S::has('suid')) {
360 $a4l = S::v('forlife');
361 $suid = S::v('suid');
362 $log = S::v('log');
363 $log->log("suid_stop", S::v('forlife') . " by " . $suid['forlife']);
5de0b7e1 364 $_SESSION = $suid;
cab08090 365 S::kill('suid');
8b00e0e0 366 pl_redirect('admin/utilisateurs.php', 'login='.$a4l);
5de0b7e1 367 } else {
8b00e0e0 368 pl_redirect('events');
5de0b7e1 369 }
370 }
371
372 if ($level == 'forget' || $level == 'forgetall') {
373 setcookie('ORGaccess', '', time() - 3600, '/', '', 0);
374 Cookie::kill('ORGaccess');
375 if (isset($_SESSION['log']))
376 $_SESSION['log']->log("cookie_off");
377 }
378
379 if ($level == 'forgetuid' || $level == 'forgetall') {
380 setcookie('ORGuid', '', time() - 3600, '/', '', 0);
381 Cookie::kill('ORGuid');
382 setcookie('ORGdomain', '', time() - 3600, '/', '', 0);
383 Cookie::kill('ORGdomain');
384 }
385
386 if (isset($_SESSION['log'])) {
387 $ref = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
388 $_SESSION['log']->log('deconnexion',$ref);
389 }
390
391 XorgSession::destroy();
392
393 if (Get::has('redirect')) {
5e2307dc 394 http_redirect(rawurldecode(Get::v('redirect')));
5de0b7e1 395 } else {
396 $page->changeTpl('exit.tpl');
397 }
5de0b7e1 398 }
399
4da0b8d7 400 function handler_rss(&$page, $user = null, $hash = null)
401 {
4da0b8d7 402 require_once 'rss.inc.php';
403
404 $uid = init_rss('rss.tpl', $user, $hash);
405
08cce2ff 406 $rss = XDB::iterator(
522162cc 407 'SELECT e.id, e.titre, e.texte, e.creation_date,
408 IF(u2.nom_usage = "", u2.nom, u2.nom_usage) AS nom, u2.prenom, u2.promo
4da0b8d7 409 FROM auth_user_md5 AS u
410 INNER JOIN evenements AS e ON ( (e.promo_min = 0 || e.promo_min <= u.promo)
522162cc 411 AND (e.promo_max = 0 || e.promo_max >= u.promo) )
412 INNER JOIN auth_user_md5 AS u2 ON (u2.user_id = e.user_id)
4da0b8d7 413 WHERE u.user_id = {?} AND FIND_IN_SET(e.flags, "valide")
414 AND peremption >= NOW()', $uid);
415 $page->assign('rss', $rss);
4da0b8d7 416 }
e59506eb 417}
418
419?>