<?php
/***************************************************************************
- * Copyright (C) 2003-2008 Polytechnique.org *
+ * Copyright (C) 2003-2011 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
function handlers()
{
return array(
- 'register' => $this->make_hook('register', AUTH_PUBLIC),
- 'register/end' => $this->make_hook('end', AUTH_PUBLIC),
- 'register/end.php' => $this->make_hook('end_old', AUTH_PUBLIC),
- 'register/success' => $this->make_hook('success', AUTH_MDP),
- 'register/save' => $this->make_hook('save', AUTH_MDP),
+ 'register' => $this->make_hook('register', AUTH_PUBLIC),
+ 'register/end' => $this->make_hook('end', AUTH_PUBLIC),
);
}
- function handler_register(&$page, $hash = null)
+ function handler_register($page, $hash = null)
{
- $alert = null;
- $sub_state = S::v('sub_state', Array());
- if (!isset($sub_state['step'])) {
- $sub_state['step'] = 0;
+ $page->forceSkin('register');
+
+ $alert = array();
+ $alert_details = '';
+ $subState = new PlDict(S::v('subState', array()));
+ if (!$subState->has('step')) {
+ $subState->set('step', 0);
}
- if (!isset($sub_state['backs'])) {
- $sub_state['backs'] = array();
+ if (!$subState->has('backs')) {
+ $subState->set('backs', new PlDict());
}
- if (Get::has('back') && Get::i('back') < $sub_state['step']) {
- $sub_state['step'] = max(0,Get::i('back'));
- $state = $sub_state;
- unset($state['backs']);
- $sub_state['backs'][] = $state;
- if (count($sub_state['backs']) == 3) {
- $alert .= "Tentative d'inscription tres hesitante - ";
+ if (Get::has('back') && Get::i('back') < $subState->i('step')) {
+ $subState->set('step', max(0, Get::i('back')));
+ $subState->v('backs')->set($subState->v('backs')->count() + 1, $subState->dict());
+ $subState->v('backs')->kill('backs');
+ if ($subState->v('backs')->count() == 3) {
+ $alert[] = "Tentative d'inscription très hésitante";
+ $alert_details .= "\n * Retours en arrières : 3.";
}
}
- // Compatibility with old sources, keep it atm
- if (!$hash && Env::has('hash')) {
- $hash = Env::v('hash');
- }
-
if ($hash) {
- $res = XDB::query(
- "SELECT m.uid, u.promo, u.nom, u.prenom, u.matricule, u.naissance_ini, FIND_IN_SET('watch', u.flags)
- FROM register_marketing AS m
- INNER JOIN auth_user_md5 AS u ON u.user_id = m.uid
- WHERE m.hash={?}", $hash);
- if (list($uid, $promo, $nom, $prenom, $ourmat, $naiss, $watch) = $res->fetchOneRow()) {
- $sub_state['uid'] = $uid;
- $sub_state['hash'] = $hash;
- $sub_state['promo'] = $promo;
- $sub_state['nom'] = $nom;
- $sub_state['prenom'] = $prenom;
- $sub_state['ourmat'] = $ourmat;
- $sub_state['watch'] = $watch;
- $sub_state['naissance_ini'] = $naiss;
-
- XDB::execute(
- "REPLACE INTO register_mstats (uid,sender,success)
- SELECT m.uid, m.sender, 0
+ $res = XDB::query("SELECT a.uid, a.hruid, ppn.lastname_initial AS lastname, ppn.firstname_initial AS firstname, p.xorg_id AS xorgid,
+ pd.promo, pe.promo_year AS yearpromo, pde.degree AS edu_type,
+ p.birthdate_ref AS birthdateRef, FIND_IN_SET('watch', a.flags) AS watch, m.hash, a.type, a.comment
FROM register_marketing AS m
- WHERE m.hash", $sub_state['hash']);
+ INNER JOIN accounts AS a ON (m.uid = a.uid)
+ INNER JOIN account_profiles AS ap ON (a.uid = ap.uid AND FIND_IN_SET('owner', ap.perms))
+ INNER JOIN profiles AS p ON (p.pid = ap.pid)
+ INNER JOIN profile_display AS pd ON (p.pid = pd.pid)
+ INNER JOIN profile_education AS pe ON (pe.pid = p.pid AND FIND_IN_SET('primary', pe.flags))
+ INNER JOIN profile_education_degree_enum AS pde ON (pde.id = pe.degreeid)
+ INNER JOIN profile_public_names AS ppn ON (ppn.pid = p.pid)
+ WHERE m.hash = {?} AND a.state = 'pending'",
+ $hash);
+
+ if ($res->numRows() == 1) {
+ $subState->merge($res->fetchOneRow());
+ $subState->set('main_mail_domain', User::$sub_mail_domains[$subState->v('type')]);
+
+ XDB::execute('INSERT INTO register_mstats (uid, sender, success)
+ SELECT m.uid, m.sender, 0
+ FROM register_marketing AS m
+ WHERE m.hash
+ ON DUPLICATE KEY UPDATE sender = VALUES(sender), success = VALUES(success)',
+ $subState->s('hash'));
}
}
- switch ($sub_state['step']) {
+ switch ($subState->i('step')) {
case 0:
- require_once('wiki.inc.php');
- wiki_require_page('Reference.Charte');
+ $wp = new PlWikiPage('Reference.Charte');
+ $wp->buildCache();
if (Post::has('step1')) {
- $sub_state['step'] = 1;
- if (isset($sub_state['hash'])) {
- $sub_state['step'] = 3;
- require_once(dirname(__FILE__) . '/register/register.inc.php');
- create_aliases($sub_state);
+ $subState->set('step', 1);
+ if ($subState->has('hash')) {
+ $subState->set('step', 3);
+ $this->load('register.inc.php');
+ createAliases($subState);
}
}
break;
case 1:
- if (Post::has('promo')) {
- $promo = Post::i('promo');
- $res = XDB::query("SELECT COUNT(*)
- FROM auth_user_md5
- WHERE perms='pending' AND deces = '0000-00-00'
- AND promo = {?}",
- $promo);
+ if (Post::has('yearpromo')) {
+ $edu_type = Post::t('edu_type');
+ $yearpromo = Post::i('yearpromo');
+ $promo = Profile::$cycle_prefixes[$edu_type] . $yearpromo;
+ $res = XDB::query("SELECT COUNT(*)
+ FROM accounts AS a
+ INNER JOIN account_profiles AS ap ON (a.uid = ap.uid AND FIND_IN_SET('owner', ap.perms))
+ INNER JOIN profiles AS p ON (p.pid = ap.pid)
+ INNER JOIN profile_education AS pe ON (pe.pid = p.pid AND FIND_IN_SET('primary', pe.flags))
+ WHERE a.state = 'pending' AND p.deathdate IS NULL AND pe.promo_year = {?}",
+ $yearpromo);
+
if (!$res->fetchOneCell()) {
- $err = "La promotion saisie est incorrecte ou tous les camardes de cette promo sont inscrits !";
+ $error = 'La promotion saisie est incorrecte ou tous les camarades de cette promotion sont inscrits !';
} else {
- $sub_state['step'] = 2;
- $sub_state['promo'] = $promo;
- if ($promo >= 1996 && $promo<2000) {
- $sub_state['mat'] = ($promo % 100)*10 . '???';
- } elseif($promo >= 2000) {
- $sub_state['mat'] = 100 + ($promo % 100) . '???';
+ $subState->set('step', 2);
+ $subState->set('promo', $promo);
+ $subState->set('yearpromo', $yearpromo);
+ $subState->set('edu_type', $edu_type);
+ if ($edu_type == Profile::DEGREE_X) {
+ if ($yearpromo >= 1996 && $yearpromo < 2000) {
+ $subState->set('schoolid', ($yearpromo % 100) * 10 . '???');
+ $subState->set('schoolid_exemple', ($yearpromo % 100) * 10000 + 532);
+ $subState->set('schoolid_exemple_ev2', (($yearpromo + 1) % 100) * 10000 + 532);
+ } elseif($yearpromo >= 2000) {
+ $subState->set('schoolid', 100 + ($yearpromo % 100) . '???');
+ $subState->set('schoolid_exemple', (100 + ($yearpromo % 100)) * 1000 + 532);
+ $subState->set('schoolid_exemple_ev2', (100 + (($yearpromo + 1) % 100)) * 1000 + 532);
+ }
}
}
}
case 2:
if (count($_POST)) {
- require_once(dirname(__FILE__) . '/register/register.inc.php');
- $sub_state['prenom'] = Post::v('prenom');
- $sub_state['nom'] = Post::v('nom');
- $sub_state['mat'] = Post::v('mat');
- $err = check_new_user($sub_state);
-
- if ($err !== true) { break; }
- $err = create_aliases($sub_state);
- if ($err === true) {
- unset($err);
- $sub_state['step'] = 3;
+ $this->load('register.inc.php');
+ $subState->set('firstname', Post::t('firstname'));
+ $subState->set('lastname', Post::t('lastname'));
+ if (Post::has('schoolid')) {
+ $subState->set('schoolid', Post::i('schoolid'));
+ }
+ $error = checkNewUser($subState);
+
+ if ($error !== true) {
+ break;
+ }
+ $error = createAliases($subState);
+ if ($error === true) {
+ unset($error);
+ $subState->set('step', 3);
}
}
break;
case 3:
if (count($_POST)) {
- require_once(dirname(__FILE__) . '/register/register.inc.php');
+ $this->load('register.inc.php');
+
+ // Validate the email address format and domain.
+ require_once 'emails.inc.php';
+
+ $user = User::get($subState->s('uid'));
if (!isvalid_email(Post::v('email'))) {
- $err[] = "Le champ 'E-mail' n'est pas valide.";
- } elseif (!isvalid_email_redirection(Post::v('email'))) {
- $err[] = $sub_state['forlife']." doit renvoyer vers un email existant ".
- "valide, en particulier, il ne peut pas être renvoyé vers lui-même.";
+ $error[] = "Le champ 'Email' n'est pas valide.";
+ } elseif (!isvalid_email_redirection(Post::v('email'), $user)) {
+ $error[] = $subState->s('forlife') . ' doit renvoyer vers un email existant '
+ . 'valide, en particulier, il ne peut pas être renvoyé vers lui-même.';
}
- $birth = trim(Env::v('naissance'));
+
+ // Validate the birthday format and range.
+ $birth = Post::t('birthdate');
if (!preg_match('@^[0-3]?\d/[01]?\d/(19|20)?\d{2}$@', $birth)) {
- $err[] = "La 'Date de naissance' n'est pas correcte.";
+ $error[] = "La 'Date de naissance' n'est pas correcte.";
} else {
$birth = explode('/', $birth, 3);
- for ($i = 0; $i < 3; $i++)
+ for ($i = 0; $i < 3; ++$i)
$birth[$i] = intval($birth[$i]);
- if ($birth[2] < 100) $birth[2] += 1900;
- $year = $birth[2];
- $promo = (int)$sub_state['promo'];
- if ($year > $promo - 15 || $year < $promo - 30) {
- $err[] = "La 'Date de naissance' n'est pas correcte.";
- $alert = "Date de naissance incorrecte a l'inscription - ";
- $sub_state['wrong_naissance'] = $birth;
+ if ($birth[2] < 100) {
+ $birth[2] += 1900;
+ }
+ $year = $birth[2];
+ $ref_year = substr($subState->v('birthdateRef'), 0, 4);
+ if (abs($ref_year - $year) > 2) {
+ $error[] = "La 'Date de naissance' n'est pas correcte.";
+ $alert[] = "Date de naissance incorrecte à l'inscription";
+ $alert_details .= "\n * Date de naissance renseignée : " . Post::t('birthdate');
+ if ($subState->v('birthdateRef') == '0000-00-00') {
+ $alert_details .= ' (date inconnue)';
+ } else {
+ $alert_details .= ' (date connue : ' . $subState->v('birthdateRef') . ')';
+ }
+ $subState->set('wrong_birthdate', $birth);
+ }
+ }
+
+ // Register the optional services requested by the user.
+ $services = array();
+ foreach (array('ax_letter', 'imap', 'ml_promo', 'nl') as $service) {
+ if (Post::b($service)) {
+ $services[] = $service;
}
}
+ $subState->set('services', $services);
- // Check if the given email is known as dangerous
- $res = Xdb::iterRow("SELECT w.state, w.description, a.alias
- FROM emails AS e
- INNER JOIN emails_watch AS w ON (e.email = w.email AND w.state != 'safe')
- INNER JOIN aliases AS a ON (e.uid = a.id AND a.type = 'a_vie')
- WHERE e.email = {?}
- ORDER BY a.alias", Post::v('email'));
- $aliases = array();
- while(list($gstate, $gdescription, $alias) = $res->next()) {
- $state = $gstate;
- $description = $gdescription;
- $aliases[] = $alias;
+ // Validate the password.
+ if (!Post::v('pwhash', false)) {
+ $error[] = "Le mot de passe n'est pas valide.";
}
- if (count($aliases) != 0) {
- $alert .= "Email surveille propose a l'inscription - ";
+
+ // Check if the given email is known as dangerous.
+ $res = XDB::query("SELECT state, description
+ FROM email_watch
+ WHERE email = {?} AND state != 'safe'",
+ Post::v('email'));
+ $bannedEmail = false;
+ if ($res->numRows()) {
+ list($state, $description) = $res->fetchOneRow();
+ $alert[] = "Email surveillé proposé à l'inscription";
+ $alert_details .= "\n * Email surveillé : " . Post::v('email');
+ $subState->set('email_desc', $description);
+ if ($state == 'dangerous') {
+ $bannedEmail = true;
+ }
}
- if ($sub_state['watch']) {
- $alter .= "Inscription d'un utilisateur surveillé - ";
+ if ($subState->i('watch') != 0) {
+ $alert[] = "Inscription d'un utilisateur surveillé";
+ $alert_details .= "\n * Commentaire pour la surveillance : " . $subState->v('comment');
}
- if (check_ip('unsafe')) {
- unset($err);
+ if (($bannedIp = check_ip('unsafe'))) {
+ unset($error);
}
- if (isset($err)) {
- $err = join('<br />', $err);
+ if (isset($error)) {
+ $error = join('<br />', $error);
} else {
- $sub_state['naissance'] = sprintf("%04d-%02d-%02d",
- intval($birth[2]), intval($birth[1]), intval($birth[0]));
- if ($sub_state['naissance_ini'] != '0000-00-00' && $sub_state['naissance'] != $sub_state['naissance_ini']) {
- $alert .= "Date de naissance incorrecte à l'inscription - ";
+ $subState->set('birthdate', sprintf("%04d-%02d-%02d",
+ intval($birth[2]), intval($birth[1]), intval($birth[0])));
+ $subState->set('email', Post::t('email'));
+ $subState->set('password', Post::t('pwhash'));
+
+ // Update the current alert if the birthdate is incorrect,
+ // or if the IP address of the user has been banned.
+ if ($subState->s('birthdateRef') != '0000-00-00'
+ && $subState->s('birthdateRef') != $subState->s('birthdate')) {
+ $alert[] = "Date de naissance incorrecte à l'inscription";
+ $alert_details .= "\n * Date de naissance renseignée : " . Post::t('birthdate');
+ if ($subState->v('birthdateRef') == '0000-00-00') {
+ $alert_details .= ' (date inconnue)';
+ } else {
+ $alert_details .= ' (date connue : ' . $subState->v('birthdateRef') . ')';
+ }
}
- $sub_state['email'] = Post::v('email');
- if (check_ip('unsafe')) {
- $err = "Une erreur s'est produite lors de l'inscription."
+ if ($bannedIp) {
+ $alert[] = "Tentative d'inscription depuis une IP surveillée";
+ $alert_details .= "\n * IP surveillée : " . $_SESSION['check_ip'];
+ }
+
+ // Prevent banned user from actually registering; save the current state for others.
+ if ($bannedEmail || $bannedIp) {
+ global $globals;
+ $error = "Une erreur s'est produite lors de l'inscription."
. " Merci de contacter <a href='mailto:register@{$globals->mail->domain}>"
. " register@{$globals->mail->domain}</a>"
- . " pour nous faire part de cette erreur";
- $alert .= "Tentative d'inscription depuis une IP surveillee";
+ . " pour nous faire part de cette erreur.";
} else {
- $sub_state['step'] = 4;
- if (count($sub_state['backs']) >= 3) {
- $alert .= "Fin d'une inscription hésitante";
+ $subState->set('step', 4);
+ if ($subState->v('backs')->count() >= 3) {
+ $alert[] = "Fin d'une inscription hésitante";
+ $alert_details .= "\n * Nombre de retours en arrière : " . $subState->v('backs')->count();
}
- finish_ins($sub_state);
+ finishRegistration($subState);
}
}
}
break;
}
- $_SESSION['sub_state'] = $sub_state;
- if ($alert) {
- send_warning_mail($alert);
+ $_SESSION['subState'] = $subState->dict();
+ if (count($alert)) {
+ $alert_details = "Détails des alertes :" . $alert_details . "\n\n";
+ $alert_details .= 'Compte concerné : ' . $subState->s('forlife') . ' (redirection vers : '
+ . ($subState->s('email') == '' ? Post::t('email') : $subState->s('email')). ")\n\n\n";
+ send_warning_mail(implode(' - ', $alert), $alert_details);
}
- $page->changeTpl('register/step'.intval($sub_state['step']).'.tpl');
- if (isset($err)) {
- $page->trig($err);
- }
- }
- function handler_end_old(&$page)
- {
- return $this->handler_end($page, Env::v('hash'));
+ $page->changeTpl('register/step' . $subState->i('step') . '.tpl');
+ if (isset($error)) {
+ $page->trigError($error);
+ }
}
- function handler_end(&$page, $hash = null)
+ function handler_end($page, $hash = null)
{
global $globals;
+ $_SESSION['subState'] = array('step' => 5);
-
- $page->changeTpl('register/end.tpl');
- $_SESSION['sub_state'] = array('step' => 5);
-
+ // Reject registration requests from unsafe IP addresses (and remove the
+ // registration information from the database, to prevent IP changes).
if (check_ip('unsafe')) {
- send_warning_mail('Une IP surveillée a tenté de finaliser son inscription');
- XDB::execute('DELETE FROM register_pending
- WHERE hash = {?} AND hash != \'INSCRIT\'', $hash);
+ send_warning_mail('Une IP surveillée a tenté de finaliser son inscription.');
+ XDB::execute("DELETE FROM register_pending
+ WHERE hash = {?} AND hash != 'INSCRIT'", $hash);
return PL_FORBIDDEN;
}
- require_once('user.func.inc.php');
-
- if ($hash) {
- $res = XDB::query(
- "SELECT r.uid, r.forlife, r.bestalias, r.mailorg2,
- r.password, r.email, r.naissance, u.nom, u.prenom,
- u.promo, FIND_IN_SET('femme', u.flags), u.naissance_ini
- FROM register_pending AS r
- INNER JOIN auth_user_md5 AS u ON r.uid = u.user_id
- WHERE hash={?} AND hash!='INSCRIT'", $hash);
- }
-
- if (!$hash || !list($uid, $forlife, $bestalias, $mailorg2, $password, $email,
- $naissance, $nom, $prenom, $promo, $femme, $naiss_ini) = $res->fetchOneRow())
- {
+ // Retrieve the pre-registration information using the url-provided
+ // authentication token.
+ $res = XDB::query("SELECT r.uid, p.pid, r.forlife, r.bestalias, r.mailorg2,
+ r.password, r.email, r.services, r.naissance,
+ ppn.lastname_initial, ppn.firstname_initial, pe.promo_year,
+ pd.promo, p.sex, p.birthdate_ref, a.type, a.email AS old_account_email
+ FROM register_pending AS r
+ INNER JOIN accounts AS a ON (r.uid = a.uid)
+ INNER JOIN account_profiles AS ap ON (a.uid = ap.uid AND FIND_IN_SET('owner', ap.perms))
+ INNER JOIN profiles AS p ON (p.pid = ap.pid)
+ INNER JOIN profile_public_names AS ppn ON (ppn.pid = p.pid)
+ INNER JOIN profile_display AS pd ON (p.pid = pd.pid)
+ INNER JOIN profile_education AS pe ON (pe.pid = p.pid AND FIND_IN_SET('primary', pe.flags))
+ WHERE hash = {?} AND hash != 'INSCRIT' AND a.state = 'pending'",
+ $hash);
+ if (!$hash || $res->numRows() == 0) {
$page->kill("<p>Cette adresse n'existe pas, ou plus, sur le serveur.</p>
- <p>Causes probables :</p>
+ <p>Causes probables :</p>
<ol>
<li>Vérifie que tu visites l'adresse du dernier
- e-mail reçu s'il y en a eu plusieurs.</li>
+ email reçu s'il y en a eu plusieurs.</li>
<li>Tu as peut-être mal copié l'adresse reçue par
- mail, vérifie-la à la main.</li>
+ email, vérifie-la à la main.</li>
<li>Tu as peut-être attendu trop longtemps pour
- confirmer. Les pré-inscriptions sont annulées
+ confirmer. Les pré-inscriptions sont annulées
tous les 30 jours.</li>
<li>Tu es en fait déjà inscrit.</li>
</ol>");
}
+ list($uid, $pid, $forlife, $bestalias, $emailXorg2, $password, $email, $services,
+ $birthdate, $lastname, $firstname, $yearpromo, $promo, $sex, $birthdate_ref, $type, $old_account_email) = $res->fetchOneRow();
+ $isX = ($type == 'x');
+ $mail_domain = User::$sub_mail_domains[$type] . $globals->mail->domain;
+ // Prepare the template for display.
+ $page->changeTpl('register/end.tpl');
+ $page->assign('forlife', $forlife);
+ $page->assign('firstname', $firstname);
+
+ // Check if the user did enter a valid password; if not (or if none is found),
+ // get her an information page.
+ if (Post::has('response')) {
+ $expected_response = sha1("$forlife:$password:" . S::v('challenge'));
+ if (Post::v('response') != $expected_response) {
+ $page->trigError("Mot de passe invalide.");
+ S::logger($uid)->log('auth_fail', 'bad password (register/end)');
+ return;
+ }
+ } else {
+ return;
+ }
- /***********************************************************/
- /****************** REALLY CREATE ACCOUNT ******************/
- /***********************************************************/
-
- XDB::execute('UPDATE auth_user_md5
- SET password={?}, perms="user",
- date=NOW(), naissance={?}, date_ins = NOW()
- WHERE user_id={?}', $password, $naissance, $uid);
- XDB::execute('REPLACE INTO auth_user_quick (user_id) VALUES ({?})', $uid);
- XDB::execute('INSERT INTO aliases (id,alias,type)
- VALUES ({?}, {?}, "a_vie")', $uid,
- $forlife);
- XDB::execute('INSERT INTO aliases (id,alias,type,flags)
- VALUES ({?}, {?}, "alias", "bestalias")',
- $uid, $bestalias);
- if ($mailorg2) {
- XDB::execute('INSERT INTO aliases (id,alias,type)
- VALUES ({?}, {?}, "alias")', $uid,
- $mailorg2);
+ //
+ // Create the user account.
+ //
+ XDB::startTransaction();
+ XDB::execute("UPDATE accounts
+ SET password = {?}, state = 'active',
+ registration_date = NOW(), email = NULL
+ WHERE uid = {?}", $password, $uid);
+ XDB::execute("UPDATE profiles
+ SET birthdate = {?}, last_change = NOW()
+ WHERE pid = {?}", $birthdate, $pid);
+ XDB::execute('INSERT INTO email_source_account (email, uid, type, flags, domain)
+ SELECT {?}, {?}, \'forlife\', \'\', id
+ FROM email_virtual_domains
+ WHERE name = {?}',
+ $forlife, $uid, $mail_domain);
+ XDB::execute('INSERT INTO email_source_account (email, uid, type, flags, domain)
+ SELECT {?}, {?}, \'alias\', \'bestalias\', id
+ FROM email_virtual_domains
+ WHERE name = {?}',
+ $bestalias, $uid, $mail_domain);
+ if ($emailXorg2) {
+ XDB::execute('INSERT INTO email_source_account (email, uid, type, flags, domain)
+ SELECT {?}, {?}, \'alias\', \'\', id
+ FROM email_virtual_domains
+ WHERE name = {?}',
+ $emailXorg2, $uid, $mail_domain);
}
+ XDB::commit();
- require_once('emails.inc.php');
- $redirect = new Redirect($uid);
+ // Add the registration email address as first and only redirection.
+ require_once 'emails.inc.php';
+ $user = User::getSilentWithUID($uid);
+ $redirect = new Redirect($user);
$redirect->add_email($email);
+ fix_bestalias($user);
+
+ // If the user was registered to some aliases and MLs, we must change
+ // the subscription to her forlife email.
+ if ($old_account_email) {
+ $listClient = new MMList($user);
+ $listClient->change_user_email($old_account_email, $user->forlifeEmail());
+ update_alias_user($old_account_email, $user->forlifeEmail());
+ }
- // on cree un objet logger et on log l'inscription
- $logger = new CoreLogger($uid);
- $logger->log('inscription', $email);
-
- XDB::execute('UPDATE register_pending SET hash="INSCRIT" WHERE uid={?}', $uid);
-
- global $platal;
- $platal->on_subscribe($forlife, $uid, $promo, $password);
+ // Try to start a session (so the user don't have to log in); we will use
+ // the password available in Post:: to authenticate the user.
+ Platal::session()->start(AUTH_PASSWD);
+
+ // Subscribe the user to the services she did request at registration time.
+ require_once 'newsletter.inc.php';
+ foreach (explode(',', $services) as $service) {
+ switch ($service) {
+ case 'ax_letter':
+ NewsLetter::forGroup(NewsLetter::GROUP_AX)->subscribe($user);
+ break;
+ case 'nl':
+ NewsLetter::forGroup(NewsLetter::GROUP_XORG)->subscribe($user);
+ break;
+ case 'imap':
+ Email::activate_storage($user, 'imap', Bogo::IMAP_DEFAULT);
+ break;
+ case 'ml_promo':
+ if ($isX) {
+ $r = XDB::query('SELECT id FROM groups WHERE diminutif = {?}', $yearpromo);
+ if ($r->numRows()) {
+ $asso_id = $r->fetchOneCell();
+ XDB::execute('INSERT IGNORE INTO group_members (uid, asso_id)
+ VALUES ({?}, {?})',
+ $uid, $asso_id);
+ try {
+ $mmlist = new MMList($user);
+ $mmlist->subscribe("promo" . $yearpromo);
+ } catch (Exception $e) {
+ PlErrorReport::report($e);
+ $page->trigError("L'inscription à la liste promo" . $yearpromo . " a échouée.");
+ }
+ }
+ }
+ break;
+ }
+ }
- $mymail = new PlMailer('register/inscription.reussie.tpl');
+ // Log the registration in the user session.
+ S::logger($uid)->log('inscription', $email);
+ XDB::execute("UPDATE register_pending
+ SET hash = 'INSCRIT'
+ WHERE uid = {?}", $uid);
+
+ // Congratulate our newly registered user by email.
+ $mymail = new PlMailer('register/success.mail.tpl');
+ $mymail->addTo("\"{$user->fullName()}\" <{$user->forlifeEmail()}>");
+ if ($isX) {
+ $mymail->setSubject('Bienvenue parmi les X sur le web !');
+ } else {
+ $mymail->setSubject('Bienvenue sur Polytechnique.org !');
+ }
$mymail->assign('forlife', $forlife);
- $mymail->assign('prenom', $prenom);
+ $mymail->assign('firstname', $firstname);
$mymail->send();
- require_once('user.func.inc.php');
- user_reindex($uid);
-
- // update number of subscribers (perms has changed)
- update_NbIns();
+ // Index the user, to allow her to appear in searches.
+ Profile::rebuildSearchTokens($pid);
+
+ // Notify other users which were watching for her arrival.
+ XDB::execute('INSERT INTO contacts (uid, contact)
+ SELECT uid, {?}
+ FROM watch_nonins
+ WHERE ni_id = {?}', $pid, $uid);
+ XDB::execute('DELETE FROM watch_nonins
+ WHERE ni_id = {?}', $uid);
+ Platal::session()->updateNbNotifs();
+
+ // Forcibly register the new user on default forums.
+ $registeredForums = array('xorg.general', 'xorg.pa.divers', 'xorg.pa.logements');
+
+ if ($isX) {
+ $promoForum = 'xorg.promo.' . strtolower($promo);
+ $exists = XDB::fetchOneCell('SELECT COUNT(*)
+ FROM forums
+ WHERE name = {?}',
+ $promoForum);
+
+ if ($exists == 0) {
+ // Notify the newsgroup admin of the promotion forum needs be created.
+ $promoFull = new UserFilter(new UFC_Promo('=', UserFilter::DISPLAY, $promo));
+ $promoRegistered = new UserFilter(new PFC_And(
+ new UFC_Promo('=', UserFilter::DISPLAY, $promo),
+ new UFC_Registered(true),
+ new PFC_Not(new UFC_Dead())
+ ));
+ if ($promoRegistered->getTotalCount() > 0.2 * $promoFull->getTotalCount()) {
+ $mymail = new PlMailer('admin/forums-promo.mail.tpl');
+ $mymail->assign('promo', $promo);
+ $mymail->send();
+ }
+ } else {
+ $registeredForums[] = $promoForum;
+ }
+ }
- if (!start_connexion($uid, false)) {
- return PL_FORBIDDEN;
+ foreach ($registeredForums as $forum) {
+ XDB::execute("INSERT INTO forum_subs (fid, uid)
+ SELECT fid, {?}
+ FROM forums
+ WHERE name = {?}",
+ $uid, $val);
}
- $_SESSION['auth'] = AUTH_MDP;
-
- /***********************************************************/
- /************* envoi d'un mail au démarcheur ***************/
- /***********************************************************/
- $res = XDB::iterRow(
- "SELECT sa.alias, IF(s.nom_usage,s.nom_usage,s.nom) AS nom,
- s.prenom, FIND_IN_SET('femme', s.flags) AS femme,
- GROUP_CONCAT(m.email) AS mails
- FROM register_marketing AS m
- INNER JOIN auth_user_md5 AS s ON ( m.sender = s.user_id )
- INNER JOIN aliases AS sa ON ( sa.id = m.sender
- AND FIND_IN_SET('bestalias', sa.flags) )
- WHERE m.uid = {?}
- GROUP BY m.sender", $uid);
- XDB::execute("UPDATE register_mstats SET success=NOW() WHERE uid={?}", $uid);
+
+ // Update the global registration count stats.
+ $globals->updateNbIns();
+
+ //
+ // Update collateral data sources, and inform watchers by email.
+ //
+
+ // Email the referrer(s) of this new user.
+ $res = XDB::iterRow("SELECT sender, GROUP_CONCAT(email SEPARATOR ', ') AS mails, MAX(last) AS lastDate
+ FROM register_marketing
+ WHERE uid = {?}
+ GROUP BY sender
+ ORDER BY lastDate DESC", $uid);
+ XDB::execute("UPDATE register_mstats
+ SET success = NOW()
+ WHERE uid = {?}", $uid);
$market = array();
- while (list($salias, $snom, $sprenom, $sfemme, $mails) = $res->next()) {
- $market[] = " - par $snom $sprenom sur $mails";
- $mymail = new PlMailer();
- $mymail->setSubject("$prenom $nom s'est inscrit à Polytechnique.org !");
- $mymail->setFrom('"Marketing Polytechnique.org" <register@' . $globals->mail->domain . '>');
- $mymail->addTo("\"$sprenom $snom\" <$salias@{$globals->mail->domain}>");
- $msg = ($sfemme?'Chère':'Cher')." $sprenom,\n\n"
- . "Nous t'écrivons pour t'informer que $prenom $nom (X$promo), "
- . "que tu avais incité".($femme?'e':'')." à s'inscrire à Polytechnique.org, "
- . "vient à l'instant de terminer son inscription.\n\n"
- . "Merci de ta participation active à la reconnaissance de ce site !!!\n\n"
- . "Bien cordialement,\n"
- . "L'équipe Polytechnique.org";
+ while (list($senderid, $maketingEmails, $lastDate) = $res->next()) {
+ $sender = User::getWithUID($senderid);
+ $market[] = " - par {$sender->fullName()} sur $maketingEmails (le plus récemment le $lastDate)";
+ $mymail = new PlMailer('register/marketer.mail.tpl');
+ $mymail->setSubject("$firstname $lastname s'est inscrit à Polytechnique.org !");
+ $mymail->setTo($sender);
+ $mymail->assign('sender', $sender);
+ $mymail->assign('firstname', $firstname);
+ $mymail->assign('lastname', $lastname);
+ $mymail->assign('promo', $promo);
+ $mymail->assign('sex', $sex);
$mymail->setTxtBody(wordwrap($msg, 72));
$mymail->send();
}
- /**** send a mail to X.org administrators ****/
+ // Email the plat/al administrators about the registration.
if ($globals->register->notif) {
- $mymail = new PlMailer();
- $mymail->setSubject("Inscription de $prenom $nom (X$promo)");
- $mymail->setFrom('"Webmaster Polytechnique.org" <web@' . $globals->mail->domain . '>');
- $mymail->addTo($globals->register->notif);
- $msg = "$prenom $nom (X$promo) a terminé son inscription avec les données suivantes :\n"
- . " - nom : $nom\n"
- . " - prenom : $prenom\n"
- . " - promo : $promo\n"
- . " - naissance : $naissance (date connue : $naiss_ini)\n"
- . " - forlife : $forlife\n"
- . " - email : $email\n"
- . " - sexe : $femme\n"
- . " - ip : {$logger->ip} ({$logger->host})\n"
- . ($logger->proxy_ip ? " - proxy : {$logger->proxy_ip} ({$logger->proxy_host})\n" : "")
- . "\n\n"
- . "Les marketings suivants avaient été effectués :\n"
- . implode("\n", $market);
+ $mymail = new PlMailer('register/registration.mail.tpl');
+ $mymail->setSubject("Inscription de $firstname $lastname ($promo)");
+ $mymail->assign('firstname', $firstname);
+ $mymail->assign('lastname', $lastname);
+ $mymail->assign('promo', $promo);
+ $mymail->assign('sex', $sex);
+ $mymail->assign('birthdate', $birthdate);
+ $mymail->assign('birthdate_ref', $birthdate_ref);
+ $mymail->assign('forlife', $forlife);
+ $mymail->assign('email', $email);
+ $mymail->assign('logger', S::logger());
+ if (count($market) > 0) {
+ $mymail->assign('market', implode("\n", $market));
+ }
$mymail->setTxtBody($msg);
$mymail->send();
}
+ // Remove old pending marketing requests for the new user.
Marketing::clear($uid);
- pl_redirect('register/success');
- $page->assign('uid', $uid);
- }
-
- function handler_success(&$page)
- {
- $page->changeTpl('register/success.tpl');
-
- $_SESSION['sub_state'] = array('step' => 5);
- if (Env::has('response2')) {
- $_SESSION['password'] = $password = Post::v('response2');
-
- XDB::execute('UPDATE auth_user_md5 SET password={?}
- WHERE user_id={?}', $password,
- S::v('uid'));
-
- $log = S::v('log');
- $log->log('passwd', '');
-
- if (Cookie::v('ORGaccess')) {
- require_once('secure_hash.inc.php');
- setcookie('ORGaccess', hash_encrypt($password), (time()+25920000), '/', '' ,0);
- }
-
- $page->assign('mdpok', true);
- }
-
- $res = XDB::iterRow("SELECT sub, domain
- FROM register_subs
- WHERE uid = {?} AND type = 'list'
- ORDER BY domain",
- S::i('uid'));
- $current_domain = null;
- $lists = array();
- while (list($sub, $domain) = $res->next()) {
- if ($current_domain != $domain) {
- $current_domain = $domain;
- $client = new MMList(S::v('uid'), S::v('password'), $domain);
- }
- list($details, ) = $client->get_members($sub);
- $lists["$sub@$domain"] = $details;
- }
- $page->assign_by_ref('lists', $lists);
-
- $page->addJsLink('motdepasse.js');
- }
-
- function handler_save(&$page)
- {
- global $globals;
-
- // Finish registration procedure
- if (Post::v('register_from_ax_question')) {
- XDB::execute('UPDATE auth_user_quick
- SET profile_from_ax = 1
- WHERE user_id = {?}',
- S::v('uid'));
- }
- if (Post::v('add_to_nl')) {
- require_once 'newsletter.inc.php';
- NewsLetter::subscribe();
- }
- if (Post::v('add_to_ax')) {
- require_once dirname(__FILE__) . '/axletter/axletter.inc.php';
- AXLetter::subscribe();
- }
- if (Post::v('add_to_promo')) {
- $r = XDB::query('SELECT id FROM groupex.asso WHERE diminutif = {?}',
- S::v('promo'));
- $asso_id = $r->fetchOneCell();
- XDB::execute('REPLACE INTO groupex.membres (uid,asso_id)
- VALUES ({?}, {?})',
- S::v('uid'), $asso_id);
- $mmlist = new MMList(S::v('uid'), S::v('password'));
- $mmlist->subscribe("promo".S::v('promo'));
- }
- if (Post::v('sub_ml')) {
- $subs = array_keys(Post::v('sub_ml'));
- $current_domain = null;
- foreach ($subs as $list) {
- list($sub, $domain) = explode('@', $list);
- if ($domain != $current_domain) {
- $current_domain = $domain;
- $client = new MMList(S::v('uid'), S::v('password'), $domain);
- }
- $client->subscribe($sub);
- }
- }
- if (Post::v('imap')) {
- require_once 'emails.inc.php';
- $storage = new MailStorageIMAP(S::v('uid'));
- $storage->enable();
- }
-
pl_redirect('profile/edit');
}
}