xdb->query("SELECT matricule, matricule_ax, promo, promo_sortie, flags, deces, nom, prenom, nationalite, section, naissance FROM auth_user_md5 WHERE user_id = {?}", Session::getInt('uid')); $personnal_data = $res->fetchOneAssoc(); foreach ($fieldarr as $val) { /* on verifie qu'on n'a pas demandé une variable inexistante ! */ if (Session::has($val)) { $tohash .= Session::get($val); } else if (isset($personnal_data[$val])) { $tohash .= $personnal_data[$val]; } else if ($val == 'username') { $res = $globals->xdb->query("SELECT alias FROM aliases WHERE id = {?} AND FIND_IN_SET('bestalias', flags)", Session::getInt('uid')); $min_username = $res->fetchOneCell(); $tohash .= $min_username; } } $tohash .= "1"; return md5($tohash); } /* cree les parametres de l'URL de retour avec les champs demandes */ function gpex_make_params($chlg, $privkey, $datafields) { global $globals; $params = "&auth=".gpex_make_auth($chlg, $privkey, $datafields); $res = $globals->xdb->query("SELECT matricule, matricule_ax, promo, promo_sortie, flags, deces, nom, prenom, nationalite, section, naissance FROM auth_user_md5 WHERE user_id = {?}", Session::getInt('uid')); $personnal_data = $res->fetchOneAssoc(); $fieldarr = explode(",",$datafields); foreach ($fieldarr as $val) { if (Session::has($val)) { $tohash .= Session::get($val); } else if (isset($personnal_data[$val])) { $params .= "&$val=".$personnal_data[$val]; } else if ($val == 'username') { $res = $globals->xdb->query("SELECT alias FROM aliases WHERE id = {?} AND FIND_IN_SET('bestalias', flags)", Session::getInt('uid')); $min_username = $res->fetchOneCell(); $params .= "&$val=".$min_username; } } return $params; } ?>