X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Femails.inc.php;h=2d24ccdc7aa504cd85155fa1d89ab42ff4242d11;hb=2553b7686e0678b8e27858a7c377e73ecb410aec;hp=0984c3802d5bfec64bd570b2dbbb2a26fc845add;hpb=c66de9a010aefa5a0e8593a0bb205caf9957232b;p=platal.git diff --git a/include/emails.inc.php b/include/emails.inc.php index 0984c38..2d24ccd 100644 --- a/include/emails.inc.php +++ b/include/emails.inc.php @@ -1,6 +1,6 @@ id()); if ($res->fetchOneCell()) { return; } @@ -41,7 +41,7 @@ function fix_bestalias($uid) SET flags=CONCAT(flags,',','bestalias') WHERE id={?} AND type!='homonyme' ORDER BY !FIND_IN_SET('usage',flags),alias LIKE '%.%', LENGTH(alias) - LIMIT 1", $uid); + LIMIT 1", $user->id()); } // function valide_email() {{{1 @@ -80,26 +80,28 @@ class Bogo { // properties {{{2 - private $uid; + private $user; private $state; private $_states = Array('let_spams', 'tag_spams', 'tag_and_drop_spams', 'drop_spams'); // constructor {{{2 - public function __construct($uid) + public function __construct(User &$user) { - if (!$uid) { + if (!$user) { return; } - $this->uid = $uid; - $res = XDB::query('SELECT email FROM emails WHERE uid={?} AND flags="filter"', $uid); + $this->user = &$user; + $res = XDB::query('SELECT email FROM emails WHERE uid = {?} AND flags = "filter"', $user->id()); if ($res->numRows()) { $this->state = $res->fetchOneCell(); } else { $this->state = 'tag_and_drop_spams'; - $res = XDB::query("INSERT INTO emails (uid,email,rewrite,panne,flags) - VALUES ({?},'tag_and_drop_spams','','0000-00-00','filter')", $uid); + $res = XDB::query( + "INSERT INTO emails (uid, email, rewrite, panne, flags) + VALUES ({?}, 'tag_and_drop_spams', '', '0000-00-00', 'filter')", + $user->id()); } } @@ -108,8 +110,8 @@ class Bogo public function change($state) { $this->state = is_int($state) ? $this->_states[$state] : $state; - XDB::execute('UPDATE emails SET email={?} WHERE uid={?} AND flags = "filter"', - $this->state, $this->uid); + XDB::execute('UPDATE emails SET email = {?} WHERE uid = {?} AND flags = "filter"', + $this->state, $this->user->id()); } // pubic function level() {{{2 @@ -126,7 +128,7 @@ class Bogo // Storage emails (Polytechnique.org). abstract class Email { - protected $uid; + protected $user; // Basic email properties; $sufficient indicates if the email can be used as // an unique redirection; $email contains the delivery email address. @@ -176,9 +178,9 @@ class EmailRedirection extends Email { // constructor {{{2 - public function __construct($uid, $row) + public function __construct(User &$user, $row) { - $this->uid = $uid; + $this->user = &$user; $this->sufficient = true; list($this->email, $flags, $this->rewrite, $this->allow_rewrite, $this->hash, $this->panne, $this->last, $this->panne_level) = $row; @@ -196,8 +198,8 @@ class EmailRedirection extends Email XDB::execute("UPDATE emails SET panne_level = IF(flags = 'panne', panne_level - 1, panne_level), flags = 'active' - WHERE uid={?} AND email={?}", $this->uid, $this->email); - S::logger()->log("email_on", $this->email.($this->uid!=S::v('uid') ? "(admin on {$this->uid})" : "")); + WHERE uid = {?} AND email = {?}", $this->user->id(), $this->email); + S::logger()->log("email_on", $this->email . ($this->user->id() != S::v('uid') ? "(admin on {$this->user->login()})" : "")); $this->active = true; $this->broken = false; } @@ -209,8 +211,8 @@ class EmailRedirection extends Email { if ($this->active) { XDB::execute("UPDATE emails SET flags ='' - WHERE uid={?} AND email={?}", $this->uid, $this->email); - S::logger()->log("email_off",$this->email.($this->uid != S::v('uid') ? "(admin on {$this->uid})" : "") ); + WHERE uid = {?} AND email = {?}", $this->user->id(), $this->email); + S::logger()->log("email_off", $this->email . ($this->user->id() != S::v('uid') ? "(admin on {$this->user->login()})" : "") ); $this->active = false; } } @@ -225,7 +227,7 @@ class EmailRedirection extends Email if (!$rewrite || !isvalid_email($rewrite)) { $rewrite = ''; } - XDB::execute('UPDATE emails SET rewrite={?} WHERE uid={?} AND email={?}', $rewrite, $this->uid, $this->email); + XDB::execute('UPDATE emails SET rewrite = {?} WHERE uid = {?} AND email = {?}', $rewrite, $this->user->id(), $this->email); $this->rewrite = $rewrite; if (!$this->allow_rewrite) { global $globals; @@ -233,26 +235,15 @@ class EmailRedirection extends Email $this->hash = rand_url_id(); XDB::execute("UPDATE emails SET hash = {?} - WHERE uid = {?} AND email = {?}", $this->hash, $this->uid, $this->email); + WHERE uid = {?} AND email = {?}", $this->hash, $this->user->id(), $this->email); } - $res = XDB::query("SELECT IF(u.nom_usage = '', u.nom, u.nom_usage) AS nom, u.prenom, FIND_IN_SET('femme', u.flags) AS sex, - q.core_mail_fmt, a.alias AS forlife, a2.alias AS bestalias - FROM auth_user_md5 AS u - INNER JOIN auth_user_quick AS q ON (u.user_id = q.user_id) - INNER JOIN aliases AS a ON (a.id = u.user_id AND a.type = 'a_vie') - INNER JOIN aliases AS a2 ON (a2.id = u.user_id AND FIND_IN_SET('bestalias', a2.flags)) - WHERE u.user_id = {?}", $this->uid); - list($nom, $prenom, $sexe, $fmt, $forlife, $bestalias) = $res->fetchOneRow(); $mail = new PlMailer('emails/rewrite-in.mail.tpl'); $mail->assign('mail', $this); - $mail->assign('nom', $nom); - $mail->assign('prenom', $prenom); - $mail->assign('sexe', $sexe); - $mail->assign('forlife', $forlife); + $mail->assign('user', $this->user); $mail->assign('baseurl', $globals->baseurl); $mail->assign('sitename', $globals->core->sitename); $mail->assign('to', $this->email); - $mail->send($fmt == 'html'); + $mail->send($this->user->isEmailFormatHtml()); } return; } @@ -270,7 +261,7 @@ class EmailRedirection extends Email return XDB::execute("UPDATE emails SET panne_level = 0, panne = 0, last = 0 WHERE uid = {?} AND email = {?}", - $this->uid, $this->email); + $this->user->id(), $this->email); } // public function has_rewrite() {{{2 @@ -310,7 +301,7 @@ class EmailStorage extends Email { $res = XDB::query("SELECT mail_storage FROM auth_user_md5 - WHERE user_id = {?}", $this->uid); + WHERE user_id = {?}", $this->user->id()); return new PlFlagSet($res->fetchOneCell()); } @@ -319,11 +310,11 @@ class EmailStorage extends Email { XDB::execute("UPDATE auth_user_md5 SET mail_storage = {?} - WHERE user_id = {?}", $storages, $this->uid); + WHERE user_id = {?}", $storages, $this->user->id()); } // Returns the list of allowed storages for the @p user. - static public function get_allowed_storages($uid) + static public function get_allowed_storages(User &$user) { global $globals; $storages = array(); @@ -331,7 +322,7 @@ class EmailStorage extends Email // Google Apps storage is available for users with valid Google Apps account. require_once 'googleapps.inc.php'; if ($globals->mailstorage->googleapps_domain && - GoogleAppsAccount::account_status($uid) == 'active') { + GoogleAppsAccount::account_status($user->id()) == 'active') { $storages[] = 'googleapps'; } @@ -345,9 +336,9 @@ class EmailStorage extends Email } - public function __construct($uid, $name) + public function __construct(User &$user, $name) { - $this->uid = $uid; + $this->user = &$user; $this->email = $name; $this->display_email = (isset($this->display_names[$name]) ? $this->display_names[$name] : $name); @@ -402,30 +393,30 @@ class Redirect // properties {{{2 private $flag_active = 'active'; - private $uid; + private $user; public $emails; public $bogo; // constructor {{{2 - public function __construct($_uid) + public function __construct(User &$user) { - $this->uid = $_uid; - $this->bogo = new Bogo($_uid); + $this->user = &$user; + $this->bogo = new Bogo($user); // Adds third-party email redirections. $res = XDB::iterRow("SELECT email, flags, rewrite, allow_rewrite, hash, panne, last, panne_level FROM emails - WHERE uid = {?} AND flags != 'filter'", $_uid); + WHERE uid = {?} AND flags != 'filter'", $user->id()); $this->emails = Array(); while ($row = $res->next()) { - $this->emails[] = new EmailRedirection($_uid, $row); + $this->emails[] = new EmailRedirection($user, $row); } // Adds local email storage backends. - foreach (EmailStorage::get_allowed_storages($_uid) as $storage) { - $this->emails[] = new EmailStorage($_uid, $storage); + foreach (EmailStorage::get_allowed_storages($user) as $storage) { + $this->emails[] = new EmailStorage($user, $storage); } } @@ -448,8 +439,8 @@ class Redirect if (!$this->other_active($email)) { return ERROR_INACTIVE_REDIRECTION; } - XDB::execute('DELETE FROM emails WHERE uid={?} AND email={?}', $this->uid, $email); - S::logger()->log('email_del',$email.($this->uid!=S::v('uid') ? " (admin on {$this->uid})" : "")); + XDB::execute('DELETE FROM emails WHERE uid = {?} AND email = {?}', $this->user->id(), $email); + S::logger()->log('email_del', $email . ($this->user->id() != S::v('uid') ? " (admin on {$this->user->login()})" : "")); foreach ($this->emails as $i => $mail) { if ($email == $mail->email) { unset($this->emails[$i]); @@ -470,19 +461,19 @@ class Redirect if (!isvalid_email_redirection($email_stripped)) { return ERROR_LOOP_EMAIL; } - XDB::execute('REPLACE INTO emails (uid,email,flags) VALUES({?},{?},"active")', $this->uid, $email); + XDB::execute('REPLACE INTO emails (uid,email,flags) VALUES({?},{?},"active")', $this->user->id(), $email); if ($logger = S::v('log', null)) { // may be absent --> step4.php - S::logger()->log('email_add',$email.($this->uid!=S::v('uid') ? " (admin on {$this->uid})" : "")); + S::logger()->log('email_add', $email . ($this->user->id() != S::v('uid') ? " (admin on {$this->user->login()})" : "")); } foreach ($this->emails as $mail) { if ($mail->email == $email_stripped) { return SUCCESS; } } - $this->emails[] = new EmailRedirection($this->uid, array($email, 'active', '', 0, null, '0000-00-00', '0000-00-00', 0)); + $this->emails[] = new EmailRedirection($this->user, array($email, 'active', '', 0, null, '0000-00-00', '0000-00-00', 0)); // security stuff - check_email($email, "Ajout d'une adresse surveillée aux redirections de " . $this->uid); + check_email($email, "Ajout d'une adresse surveillée aux redirections de " . $this->user->login()); check_redirect($this); return SUCCESS; } @@ -562,7 +553,7 @@ class Redirect { XDB::execute("UPDATE emails SET flags = 'disable' - WHERE flags = 'active' AND uid = {?}", $this->uid); + WHERE flags = 'active' AND uid = {?}", $this->user->id); foreach ($this->emails as &$mail) { if ($mail->active && $mail->has_disable()) { $mail->disabled = true; @@ -578,7 +569,7 @@ class Redirect { XDB::execute("UPDATE emails SET flags = 'active' - WHERE flags = 'disable' AND uid = {?}", $this->uid); + WHERE flags = 'disable' AND uid = {?}", $this->user->id); foreach ($this->emails as &$mail) { if ($mail->disabled) { $mail->active = true; @@ -642,7 +633,7 @@ class Redirect public function get_uid() { - return $this->uid; + return $this->user->id(); } }