- $res = XDB::query('SELECT date, naissance FROM auth_user_md5
- WHERE user_id={?}', S::v('uid'));
- list($date, $naissance) = $res->fetchOneRow();
-
- // incitation à mettre à jour la fiche
-
- $d2 = mktime(0, 0, 0, substr($date, 5, 2), substr($date, 8, 2),
- substr($date, 0, 4));
- if( (time() - $d2) > 60 * 60 * 24 * 400 ) {
- // si fiche date de + de 400j;
- $page->assign('fiche_incitation', $date);
+ // Profile update (appears when profile is > 400d old), and birthday
+ // oneboxes.
+ $res = XDB::query(
+ "SELECT date < DATE_SUB(NOW(), INTERVAL 400 DAY) AS is_profile_old,
+ MONTH(naissance) = MONTH(NOW()) AND DAYOFMONTH(naissance) = DAYOFMONTH(NOW()) AS is_birthday,
+ date AS profile_date, YEAR(NOW()) - YEAR(naissance) AS age
+ FROM auth_user_md5
+ WHERE user_id = {?}", S::user()->id());
+ list($is_profile_old, $is_birthday, $profile_date, $age) = $res->fetchOneRow();
+
+ if ($is_profile_old) {
+ $page->assign('fiche_incitation', $profile_date);