254 caracteres
function levenshtein255 ($a, $b) {
$a = substr($a, 0, 254);
$b = substr($b, 0, 254);
return @levenshtein($a,$b);
}
function mots_ressemblants($mot, $table_mots, $table_ids='') {
$lim = 2;
$nb = 0;
$opt = 1000000;
$mot_opt = '';
$mot = translitteration(strtolower(trim($mot)));
$len = strlen($mot);
if (!$table_mots) return '';
while (!$nb AND $lim < 10) {
reset($table_mots);
if ($table_ids) reset($table_ids);
while (list(, $val) = each($table_mots)) {
if ($table_ids) list(, $id) = each($table_ids);
else $id = $val;
$val2 = trim($val);
if ($val2) {
if (!($m = $distance[$id])) {
$val2 = translitteration(strtolower($val2));
$len2 = strlen($val2);
if ($val2 == $mot)
$m = -2; # resultat exact
else if (substr($val2, 0, $len) == $mot)
$m = -1; # sous-chaine
else {
# distance
$m = levenshtein255($val2, $mot);
# ne pas compter la distance due a la longueur
$m -= max(0, $len2 - $len);
}
$distance[$id] = $m;
}
if ($m <= $lim) {
$selection[$id] = $m;
if ($m < $opt) {
$opt = $m;
$mot_opt = $val;
}
$nb++;
}
}
}
$lim += 2;
}
if (!$nb) return '';
reset($selection);
if ($opt > -1) {
$moy = 1;
while(list(, $val) = each($selection)) $moy *= $val;
if($moy) $moy = pow($moy, 1.0/$nb);
$lim = ($opt + $moy) / 2;
}
else $lim = -1;
reset($selection);
while (list($key, $val) = each($selection)) {
if ($val <= $lim) {
$result[] = $key;
}
}
return $result;
}
/*
* Affiche la liste des mots-cles associes a l'objet
* specifie, plus le formulaire d'ajout de mot-cle
*/
function formulaire_mots($table, $id_objet, $nouv_mot, $supp_mot, $cherche_mot, $flag_editable) {
global $connect_statut, $options;
global $spip_lang_rtl, $spip_lang_right;
$select_groupe = $GLOBALS['select_groupe'];
if ($table == 'articles') {
$id_table = 'id_article';
$objet = 'article';
$url_base = "articles.php3?id_article=$id_objet";
}
else if ($table == 'breves') {
$id_table = 'id_breve';
$objet = 'breve';
$url_base = "breves_voir.php3?id_breve=$id_objet";
}
else if ($table == 'rubriques') {
$id_table = 'id_rubrique';
$objet = 'rubrique';
$url_base = "naviguer.php3?id_rubrique=$id_objet";
}
else if ($table == 'syndic') {
$id_table = 'id_syndic';
$objet = 'syndic';
$url_base = "sites.php3?id_syndic=$id_objet";
}
list($nombre_mots) = spip_fetch_array(spip_query("SELECT COUNT(*) FROM spip_mots AS mots, spip_mots_$table AS lien WHERE lien.$id_table=$id_objet AND mots.id_mot=lien.id_mot"));
if (!$nombre_mots) {
if (!$flag_editable) return;
list($nombre_groupes) = spip_fetch_array(spip_query("SELECT COUNT(*) FROM spip_groupes_mots WHERE $table = 'oui'
AND ".substr($connect_statut,1)." = 'oui'"));
if (!$nombre_groupes) return;
}
echo "";
if ($flag_editable){
if ($nouv_mot.$cherche_mot.$supp_mot)
$bouton = bouton_block_visible("lesmots");
else
$bouton = bouton_block_invisible("lesmots");
}
debut_cadre_enfonce("mot-cle-24.gif", false, "", $bouton._T('titre_mots_cles').aide ("artmots"));
//////////////////////////////////////////////////////
// Recherche de mot-cle
//
if ($nouv_mot)
$nouveaux_mots[] = $nouv_mot;
$tous_les_mots = split(" *[,;] *", $cherche_mot);
while ((list(,$cherche_mot) = each ($tous_les_mots)) AND $cherche_mot) {
echo "";
$query = "SELECT id_mot, titre FROM spip_mots WHERE id_groupe='$select_groupe'";
$result = spip_query($query);
unset($table_mots);
unset($table_ids);
while ($row = spip_fetch_array($result)) {
$table_ids[] = $row['id_mot'];
$table_mots[] = $row['titre'];
}
$resultat = mots_ressemblants($cherche_mot, $table_mots, $table_ids);
debut_boite_info();
if (!$resultat) {
echo ""._T('info_non_resultat', array('cherche_mot' => $cherche_mot))."
";
}
else if (count($resultat) == 1) {
list(, $nouv_mot) = each($resultat);
$nouveaux_mots[] = $nouv_mot;
echo ""._T('info_mot_cle_ajoute')." ";
if ($table == 'articles') echo _T('info_l_article');
else if ($table == 'breves') echo _T('info_la_breve');
else if ($table == 'rubriques') echo _T('info_la_rubrique');
echo " :
";
$query = "SELECT * FROM spip_mots WHERE id_mot=$nouv_mot";
$result = spip_query($query);
echo "
";
while ($row = spip_fetch_array($result)) {
$id_mot = $row['id_mot'];
$titre_mot = $row['titre'];
$type_mot = typo($row['type']);
$descriptif_mot = $row['descriptif'];
echo "- ".typo($titre_mot)."";
echo "\n";
}
echo "
";
}
else {
reset($resultat);
unset($les_mots);
while (list(, $id_mot) = each($resultat)
AND $nombre ++ < 17)
$les_mots[] = $id_mot;
if ($les_mots) {
if (count($resultat) > 17) {
echo "
"._T('info_trop_resultat', array('cherche_mot' => $cherche_mot))."\n";
}
$les_mots = join(',', $les_mots);
echo ""._T('info_plusieurs_mots_trouves', array('cherche_mot' => $cherche_mot))."
";
$query = "SELECT * FROM spip_mots WHERE id_mot IN ($les_mots) ORDER BY titre";
$result = spip_query($query);
echo "";
while ($row = spip_fetch_array($result)) {
$id_mot = $row['id_mot'];
$titre_mot = $row['titre'];
$type_mot = typo($row['type']);
$descriptif_mot = $row['descriptif'];
echo "- ".typo($titre_mot)."";
if ($type_mot) echo " ($type_mot)";
echo " | "._T('info_ajouter_mot')."";
if (strlen($descriptif_mot) > 1) {
echo "
".propre(couper($descriptif_mot, 100))."\n";
}
echo "\n";
}
echo "
";
}
}
if ($GLOBALS['connect_statut'] == '0minirezo') {
echo "";
$retour = urlencode($GLOBALS['clean_link']->getUrl());
$titre = urlencode($cherche_mot);
icone_horizontale(_T('icone_creer_mot_cle'), "mots_edit.php3?new=oui&ajouter_id_article=$id_objet&table=$table&id_table=$id_table&titre=$titre&redirect=$retour", "mot-cle-24.gif", "creer.gif");
echo "
";
}
fin_boite_info();
echo "";
}
//////////////////////////////////////////////////////
// Appliquer les modifications sur les mots-cles
//
if ($nouveaux_mots && $flag_editable) {
while ((list(,$nouv_mot) = each($nouveaux_mots)) AND $nouv_mot!='x') {
$query = "SELECT * FROM spip_mots_$table WHERE id_mot=$nouv_mot AND $id_table=$id_objet";
$result = spip_query($query);
if (!spip_num_rows($result)) {
$query = "INSERT INTO spip_mots_$table (id_mot,$id_table) VALUES ($nouv_mot, $id_objet)";
$result = spip_query($query);
}
}
$reindexer = true;
}
if ($supp_mot && $flag_editable) {
if ($supp_mot == -1)
$mots_supp = "";
else
$mots_supp = " AND id_mot=$supp_mot";
$query = "DELETE FROM spip_mots_$table WHERE $id_table=$id_objet $mots_supp";
$result = spip_query($query);
$reindexer = true;
}
if ($reindexer AND lire_meta('activer_moteur') == 'oui') {
include_ecrire ("inc_index.php3");
marquer_indexer($objet, $id_objet);
}
//
// Afficher les mots-cles
//
$query = "SELECT DISTINCT type FROM spip_mots";
$result = spip_query($query);
$plusieurs_types = (spip_num_rows($result) > 1);
unset($les_mots);
$query = "SELECT mots.* FROM spip_mots AS mots, spip_mots_$table AS lien WHERE lien.$id_table=$id_objet AND mots.id_mot=lien.id_mot ORDER BY mots.type, mots.titre";
$result = spip_query($query);
if (spip_num_rows($result) > 0) {
echo "
";
echo "
";
$ifond=0;
$tableau= '';
while ($row = spip_fetch_array($result)) {
$vals = '';
$id_mot = $row['id_mot'];
$titre_mot = $row['titre'];
$type_mot = typo($row['type']);
$descriptif_mot = $row['descriptif'];
$id_groupe = $row['id_groupe'];
$query_groupe = "SELECT * FROM spip_groupes_mots WHERE id_groupe = $id_groupe";
$result_groupe = spip_query($query_groupe);
while($row_groupe = spip_fetch_array($result_groupe)) {
$id_groupe = $row_groupe['id_groupe'];
$titre_groupe = entites_html($row_groupe['titre']);
$unseul = $row_groupe['unseul'];
$obligatoire = $row_groupe['obligatoire'];
$acces_admin = $row_groupe['minirezo'];
$acces_redacteur = $row_groupe['comite'];
$flag_groupe = ($flag_editable AND (($connect_statut == '1comite' AND $acces_redacteur == 'oui') OR ($connect_statut == '0minirezo' AND $acces_admin == 'oui')));
}
$groupes_vus[$id_groupe] = true;
$id_groupes_vus[] = $id_groupe;
if ($ifond==0){
$ifond=1;
$couleur="#FFFFFF";
}else{
$ifond=0;
$couleur="#EDF3FE";
}
$url = "mots_edit.php3?id_mot=$id_mot&redirect=".rawurlencode($url_base.'#mots');
$vals[] = "" . http_img_pack('petite-cle.gif', "", "width='23' height='12' border='0'") ."";
// Changer
if ($unseul == "oui" AND $flag_groupe) {
$s = "";
} else {
$s = "".typo($titre_mot)."";
}
$vals[] = $s;
$vals[] = "$type_mot";
if ($flag_editable){
$s = "";
if ($flag_groupe)
$s .= ""._T('info_retirer_mot')." " . http_img_pack('croix-rouge.gif', "X", "width='7' height='7' border='0' align='middle'") ."";
else $s .= " ";
}
$vals[] = $s;
$tableau[] = $vals;
$les_mots[] = $id_mot;
}
$largeurs = array('25', '', '', '');
$styles = array('arial11', 'arial2', 'arial2', 'arial1');
afficher_liste($largeurs, $tableau, $styles);
echo "
\n";
}
$form_mot = "