- $res = XDB::query('SELECT date < DATE_SUB(NOW(), INTERVAL 365 DAY) AS is_profile_old,
- date AS profile_date, LENGTH(p.attach) > 0 AS has_photo
- FROM auth_user_md5 AS u
- LEFT JOIN photo AS p ON (u.user_id = p.uid)
- WHERE user_id = {?}',
- $this->user->id());
- list($is_profile_old, $profile_date, $has_photo) = $res->fetchOneRow();
-
- $page->assign('profile_incitation', $is_profile_old);
- $page->assign('profile_last_update', $profile_date);
- $page->assign('photo_incitation', !$has_photo);
-
- $res = XDB::query('SELECT COUNT(*)
- FROM profile_addresses
- WHERE pid = {?} AND accuracy = 0',
- $this->user->id());
- $page->assign('geocoding_incitation', $res->fetchOneCell());
+ $page->assign('profile_merge', self::ListMergeIssues($profile));
+ $page->assign('profile_incitation', $profile->is_old);
+ $page->assign('profile_last_update', $profile->last_change);
+ $page->assign('photo_incitation', !$profile->has_photo);
+ $page->assign('geocoding_incitation', Geocoder::countNonGeocoded($profile->id()));