| 364,12 → 364,12 |
|---|
| // et auquel cas laisser au client le choix du couteux "%" ? |
| $tags = $p['masque.tag_cel']['AND']; |
| array_walk($tags, create_function('&$val, $k, $db', |
| '$val = sprintf("CONCAT(vdi.mots_cles_texte,vdi.i_mots_cles_texte) LIKE %s", |
| '$val = sprintf("CONCAT(IFNULL(vdi.mots_cles_texte,\'\'),IFNULL(vdi.i_mots_cles_texte,\'\')) LIKE %s", |
| $db->proteger("%".$val."%"));'), |
| $db); |
| $req['where'][] = '(' . implode(' AND ', $tags) . ')'; |
| } else { |
| $req['where'][] = sprintf("CONCAT(vdi.mots_cles_texte,vdi.i_mots_cles_texte) REGEXP %s", |
| $req['where'][] = sprintf("CONCAT(IFNULL(vdi.mots_cles_texte,\'\'),IFNULL(vdi.i_mots_cles_texte,\'\')) REGEXP %s", |
| $db->proteger(implode('|', $p['masque.tag_cel']['OR']))); |
| } |
| } |