X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Fmarketing.inc.php;h=c0d270733ed0ba08e464076e631e72285a5f7be2;hb=72bd919e5d2093a816036c6cecc9e2725bad35f8;hp=dfd523fd54005998d2c7e326c285d258123be5f0;hpb=9f5bd98e936d8cef7ca9f774eeef64dbb8a1b079;p=platal.git diff --git a/include/validations/marketing.inc.php b/include/validations/marketing.inc.php index dfd523f..c0d2707 100644 --- a/include/validations/marketing.inc.php +++ b/include/validations/marketing.inc.php @@ -57,10 +57,10 @@ class MarkReq extends Validate public function formu() { $res = XDB::query('SELECT IF(MAX(m.last)>p.relance, MAX(m.last), p.relance) - FROM auth_user_md5 AS u - LEFT JOIN register_pending AS p ON p.uid = u.user_id - LEFT JOIN register_marketing AS m ON m.uid = u.user_id - WHERE user_id = {?}', + FROM accounts AS a + LEFT JOIN register_pending AS p ON p.uid = a.uid + LEFT JOIN register_marketing AS m ON m.uid = a.uid + WHERE a.uid = {?}', $this->m_user->id()); $this->m_relance = $res->fetchOneCell(); return 'include/form.valid.mark.tpl';