- $query = XDB::query('SELECT a.fullname, a.uid, a.password,
- ml.ml, ml.domain, ml.mid, ml.action, ml.message
- FROM accounts AS a
- INNER JOIN email_list_moderate AS ml ON (a.uid = ml.uid)
- WHERE ml.handler = {?}', $handler);
- list($fullname, $uid, $password, $list, $domain, $mid, $action, $reason) = $query->fetchOneRow();
-
- // build the client
- $client = new MMList($uid, $password, $domain);
+ $query = XDB::query('SELECT uid, ml, domain, mid, action, message
+ FROM email_list_moderate
+ WHERE handler = {?}', $handler);
+ list($uid, $list, $domain, $mid, $action, $reason) = $query->fetchOneRow();
+ $user = User::get($uid);
+ $fullname = $user->fullName();
+ $mlist = new MailingList($list, $domain, $user);