return null;
}
@list($prenom, $nom, $promo) = explode('.', $login);
- $where = 'REPLACE(REPLACE(REPLACE(nom, " ", ""), "-", ""), "\'", "") LIKE CONCAT("%", {?}, "%")
- AND REPLACE(REPLACE(REPLACE(prenom, " ", ""), "-", ""), "\'", "") LIKE CONCAT("%", {?}, "%")';
+ $where = 'REPLACE(REPLACE(REPLACE(nom, " ", ""), "-", ""), "\'", "")
+ LIKE CONCAT("%", REPLACE(REPLACE(REPLACE({?}, " ", ""), "-", ""), "\'", ""), "%")
+ AND REPLACE(REPLACE(REPLACE(prenom, " ", ""), "-", ""), "\'", "")
+ LIKE CONCAT("%", REPLACE(REPLACE(REPLACE({?}, " ", ""), "-", ""), "\'", ""), "%")';
if ($promo) {
if (preg_match('/^[0-9]{2}$/', $promo)) {
$where .= 'AND MOD(promo, 100) = {?}';
$adrid = 0;
}
foreach ($adrs as $adr) {
- add_user_address($uid, $adrid, $adr);
- ++$adrid;
+ if (!@$adr['remove']) {
+ add_user_address($uid, $adrid, $adr);
+ ++$adrid;
+ }
}
require_once 'geoloc.inc.php';
localize_addresses($uid);
$entrid = 0;
}
foreach ($pros as $pro) {
- add_user_pro($uid, $entrid, $pro);
- ++$entrid;
+ if (!@$pro['remove']) {
+ add_user_pro($uid, $entrid, $pro);
+ ++$entrid;
+ }
}
}