ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
es.label AS secteur, ef.fonction_fr AS fonction,
- IF(n.nat=\'\',n.pays,n.nat) AS nat, n.a2 AS iso3166,';
+ IF(n.nat=\'\',n.pays,n.nat) AS nat, n.a2 AS iso3166,
+ COUNT(em.email) > 0 AS actif,';
// hide private information if not logged
if (S::logged())
$globals->search->result_fields .='
LEFT JOIN geoloc_pays AS n ON (u.nationalite = n.a2)
LEFT JOIN adresses AS adr ON (u.user_id = adr.uid AND FIND_IN_SET(\'active\',adr.statut))
LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
- LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)';
+ LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
+ LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = \'active\')';
// }}}
// {{{ function display_lines()
function ThrowError($explain)
{
global $page;
- $page->trig_run('Erreur : '.$explain);
+ $page->trig('Erreur : '.$explain);
+ $page->run();
}
}
* on met une chaîne vide si le champ n'a pas été complété */
function get_request()
{
- $this->value = trim(Env::get($this->fieldFormName));
+ $this->value = trim(Env::v($this->fieldFormName));
}
// }}}
function MapSField($_fieldFormName, $_fieldDbName='', $_refTable, $_refAlias, $_refCondition, $_mapId=false)
{
if ($_mapId === false)
- $this->mapId = Env::get($_fieldFormName, '');
+ $this->mapId = Env::v($_fieldFormName, '');
else
$this->mapId = $_mapId;
$this->RefSField($_fieldFormName, $_fieldDbName, $_refTable, $_refAlias, $_refCondition, true, false);