X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Femails.inc.php;h=37582e685d57ca9ecf5589f765569df1206d871b;hb=fe13bc1d7ba9f72d452ec07baf8538a74b7c67b8;hp=9905a732ecfa5c57c17a3d112f2cc6b21251497e;hpb=180627f3cd482a50406a3ad8d01e260a16e69957;p=platal.git diff --git a/include/emails.inc.php b/include/emails.inc.php index 9905a73..37582e6 100644 --- a/include/emails.inc.php +++ b/include/emails.inc.php @@ -1,6 +1,6 @@ id()); if ($res->fetchOneCell()) { return; @@ -39,7 +39,7 @@ function fix_bestalias(User &$user) XDB::execute("UPDATE aliases SET flags=CONCAT(flags,',','bestalias') - WHERE id={?} AND type!='homonyme' + WHERE uid={?} AND type!='homonyme' ORDER BY !FIND_IN_SET('usage',flags),alias LIKE '%.%', LENGTH(alias) LIMIT 1", $user->id()); } @@ -55,8 +55,11 @@ function valide_email($str) $em = trim(rtrim($str)); $em = str_replace('<', '', $em); $em = str_replace('>', '', $em); + if (strpos($em, '@') === false) { + return; + } list($ident, $dom) = explode('@', $em); - if ($dom == $globals->mail->domain or $dom == $globals->mail->domain2) { + if ($dom == $globals->mail->domain || $dom == $globals->mail->domain2) { list($ident1) = explode('_', $ident); list($ident) = explode('+', $ident1); } @@ -109,10 +112,9 @@ function ids_from_mails(array $emails) // Look up user ids for addresses in domain if (count($domain_mails)) { - $domain_users = array(); - $domain_users = array_map('XDB::escape', array_keys($domain_mails)); + $domain_users = array_map(array('XDB', 'escape'), array_keys($domain_mails)); $list = implode(',', $domain_users); - $res = XDB::query("SELECT alias, id + $res = XDB::query("SELECT alias, uid FROM aliases WHERE alias IN ($list)"); foreach ($res->fetchAllRow() as $row) { @@ -128,7 +130,7 @@ function ids_from_mails(array $emails) $alias_users[] = XDB::escape($user."@".$globals->mail->alias_dom); } $list = implode(',', $alias_users); - $res = XDB::query("SELECT v.alias, a.id + $res = XDB::query("SELECT v.alias, a.uid FROM virtual AS v INNER JOIN virtual_redirect AS r USING(vid) INNER JOIN aliases AS a ON (a.type = 'a_vie' @@ -142,8 +144,7 @@ function ids_from_mails(array $emails) // Look up user ids for other addresses in the email redirection list if (count($other_mails)) { - $other_users = array(); - $other_users = array_map('XDB::escape', $other_mails); + $other_users = array_map(array('XDB', 'escape'), $other_mails); $list = implode(',', $other_users); $res = XDB::query("SELECT email, uid FROM emails @@ -382,18 +383,18 @@ class EmailStorage extends Email // Retrieves the current list of actives storages. private function get_storages() { - $res = XDB::query("SELECT mail_storage - FROM auth_user_md5 - WHERE user_id = {?}", $this->user->id()); - return new PlFlagSet($res->fetchOneCell()); + return new PlFlagSet(XDB::fetchOneCell('SELECT storage + FROM email_options + WHERE uid = {?}', + $this->user->id())); } // Updates the list of active storages. private function set_storages($storages) { - XDB::execute("UPDATE auth_user_md5 - SET mail_storage = {?} - WHERE user_id = {?}", $storages, $this->user->id()); + XDB::execute("UPDATE email_options + SET storage = {?} + WHERE uid = {?}", $storages, $this->user->id()); } // Returns the list of allowed storages for the @p user.