'emails/broken' => $this->make_hook('broken', AUTH_COOKIE),
'emails/redirect' => $this->make_hook('redirect', AUTH_MDP),
'emails/send' => $this->make_hook('send', AUTH_MDP),
+
+ 'admin/emails/duplicated' => $this->make_hook('duplicated', AUTH_MDP, 'admin')
);
}
- function handler_emails(&$page)
+ function handler_emails(&$page, $action = null, $email = null)
{
global $globals;
$uid = S::v('uid');
- if (Post::has('best')) {
+ if ($action == 'best' && $email) {
// bestalias is the first bit : 1
// there will be maximum 8 bits in flags : 255
XDB::execute("UPDATE aliases SET flags=flags & (255 - 1) WHERE id={?}", $uid);
XDB::execute("UPDATE aliases SET flags=flags | 1 WHERE id={?} AND alias={?}",
- $uid, Post::v('best'));
+ $uid, $email);
}
// on regarde si on a affaire à un homonyme
ORDER BY LENGTH(alias)";
$page->assign('aliases', XDB::iterator($sql, $uid));
+ $homonyme = XDB::query("SELECT alias FROM aliases INNER JOIN homonymes ON (id = homonyme_id) WHERE user_id = {?} AND type = 'homonyme'", $uid);
+ $page->assign('homonyme', $homonyme->fetchOneCell());
+
$sql = "SELECT email
FROM emails
WHERE uid = {?} AND FIND_IN_SET('active', flags)";
$uid = S::v('uid');
$forlife = S::v('forlife');
+ $page->assign('eleve', S::i('promo') >= date("Y") - 5);
+
$redirect = new Redirect(S::v('uid'));
if ($action == 'remove' && $email) {
- $page->assign('retour', $redirect->delete_email($email));
+ $retour = $redirect->delete_email($email);
+ $page->assign('retour', $retour);
}
-
+
+ if ($action == 'active' && $email) {
+ $redirect->modify_one_email($email, true);
+ }
+
+ if ($action == 'inactive' && $email) {
+ $redirect->modify_one_email($email, false);
+ }
+
+ if ($action == 'rewrite' && $email) {
+ $rewrite = @func_get_arg(3);
+ $redirect->modify_one_email_redirect($email, $rewrite);
+ }
+
if (Env::has('emailop')) {
$actifs = Env::v('emails_actifs', Array());
+ print_r(Env::v('emails_rewrite'));
if (Env::v('emailop') == "ajouter" && Env::has('email')) {
$page->assign('retour', $redirect->add_email(Env::v('email')));
} elseif (empty($actifs)) {
$page->assign('emails',$redirect->emails);
}
- function handler_antispam(&$page)
+ function handler_antispam(&$page, $statut_filtre = null)
{
require_once 'emails.inc.php';
$page->changeTpl('emails/antispam.tpl');
$bogo = new Bogo(S::v('uid'));
- if (Env::has('statut_filtre')) {
- $bogo->change(S::v('uid'), Env::i('statut_filtre'));
+ if (isset($statut_filtre)) {
+ $bogo->change(S::v('uid'), $statut_filtre + 0);
}
$page->assign('filtre',$bogo->level());
}
if ($x = $sel->fetchOneAssoc()) {
// on écrit dans la base que l'adresse est cassée
if (!$x['panne']) {
- XDB::execute("UPDATE emails SET panne=NOW() WHERE email = {?}", $email);
+ XDB::execute("UPDATE emails
+ SET panne=NOW(),
+ last=NOW(),
+ panne_level = 1
+ WHERE email = {?}", $email);
+ } else {
+ XDB::execute("UPDATE emails
+ SET panne_level = 1
+ WHERE email = {?} AND panne_level = 0");
}
$page->assign_by_ref('x', $x);
}
}
}
}
+
+ function handler_duplicated(&$page, $action = 'list', $email = null)
+ {
+ $page->changeTpl('emails/duplicated.tpl');
+
+ $states = array('pending' => 'En attente...',
+ 'safe' => 'Pas d\'inquiétude',
+ 'unsafe' => 'Recherches en cours',
+ 'dangerous' => 'Usurpations par cette adresse');
+ $page->assign('states', $states);
+
+ switch (Post::v('action')) {
+ case 'create':
+ if (trim(Post::v('emailN')) != '') {
+ Xdb::execute('INSERT IGNORE INTO emails_watch (email, state, detection, last, uid, description)
+ VALUES ({?}, {?}, CURDATE(), NOW(), {?}, {?})',
+ trim(Post::v('emailN')), Post::v('stateN'), S::i('uid'), Post::v('descriptionN'));
+ };
+ break;
+
+ case 'edit':
+ Xdb::execute('UPDATE emails_watch
+ SET state = {?}, last = NOW(), uid = {?}, description = {?}
+ WHERE email = {?}', Post::v('stateN'), S::i('uid'), Post::v('descriptionN'), Post::v('emailN'));
+ break;
+
+ default:
+ if ($action == 'delete' && !is_null($email)) {
+ Xdb::execute('DELETE FROM emails_watch WHERE email = {?}', $email);
+ }
+ }
+ if ($action != 'create' && $action != 'edit') {
+ $action = 'list';
+ }
+ $page->assign('action', $action);
+
+ if ($action == 'list') {
+ $sql = "SELECT w.email, w.detection, w.state, a.alias AS forlife
+ FROM emails_watch AS w
+ LEFT JOIN emails AS e USING(email)
+ LEFT JOIN aliases AS a ON (a.id = e.uid AND a.type = 'a_vie')
+ ORDER BY w.state, w.email, a.alias";
+ $it = Xdb::iterRow($sql);
+
+ $table = array();
+ $props = array();
+ while (list($email, $date, $state, $forlife) = $it->next()) {
+ if (count($props) == 0 || $props['mail'] != $email) {
+ if (count($props) > 0) {
+ $table[] = $props;
+ }
+ $props = array('mail' => $email,
+ 'detection' => $date,
+ 'state' => $state,
+ 'users' => array($forlife));
+ } else {
+ $props['users'][] = $forlife;
+ }
+ }
+ if (count($props) > 0) {
+ $table[] = $props;
+ }
+ $page->assign('table', $table);
+ } elseif ($action == 'edit') {
+ $sql = "SELECT w.detection, w.state, w.last, w.description,
+ a1.alias AS edit, a2.alias AS forlife
+ FROM emails_watch AS w
+ LEFT JOIN aliases AS a1 ON (a1.id = w.uid AND a1.type = 'a_vie')
+ LEFT JOIN emails AS e ON (w.email = e.email)
+ LEFT JOIN aliases AS a2 ON (a2.id = e.uid AND a2.type = 'a_vie')
+ WHERE w.email = {?}
+ ORDER BY a2.alias";
+ $it = Xdb::iterRow($sql, $email);
+
+ $props = array();
+ while (list($detection, $state, $last, $description, $edit, $forlife) = $it->next()) {
+ if (count($props) == 0) {
+ $props = array('mail' => $email,
+ 'detection' => $detection,
+ 'state' => $state,
+ 'last' => $last,
+ 'description' => $description,
+ 'edit' => $edit,
+ 'users' => array($forlife));
+ } else {
+ $props['users'][] = $forlife;
+ }
+ }
+ $page->assign('doublon', $props);
+ }
+ }
}
?>