- public function fields()
- {
- return "u.user_id AS id, u.*," .
- "u.perms != 'pending' AS inscrit,
- u.perms != 'pending' AS wasinscrit,
- u.deces != 0 AS dcd, u.deces,
- FIND_IN_SET('femme', u.flags) AS sexe,
- " // adr.city, gr.name AS region
- . "gc.iso_3166_1_a2, gc.countryFR AS countrytxt" .
- (S::logged() ? ", c.contact AS contact" : '');
- }
-
- public function joins()
- {
- return "LEFT JOIN profile_addresses AS adr ON (u.user_id = adr.pid AND
- FIND_IN_SET('current', adr.flags)"
- . (S::logged() ? "" : "AND adr.pub = 'public'") . ")
- LEFT JOIN geoloc_countries AS gc ON (adr.countryId = gc.iso_3166_1_a2)
- LEFT JOIN geoloc_administrativeareas AS gr ON (adr.countryId = gr.country
- AND adr.administrativeAreaId = gr.id)
- " . (S::logged() ?
- "LEFT JOIN contacts AS c ON (c.contact = u.user_id
- AND c.uid = " . S::v('uid') . ")" : "");
- }
-