X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Fmarketing.inc.php;h=3d724d55f59bc77a7f1dd02469dae1498115929d;hb=ee682285d39f3358b1c50e672f7cbd001d6a9ac9;hp=9f2161cc762e6163047c9ba4d55eb57a1524c59a;hpb=8d84c630f353ef0534e02325507ed35cc2f0d28f;p=platal.git diff --git a/include/validations/marketing.inc.php b/include/validations/marketing.inc.php index 9f2161c..3d724d5 100644 --- a/include/validations/marketing.inc.php +++ b/include/validations/marketing.inc.php @@ -55,10 +55,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';