id_mot." and type_lien=1 and mots.id_mot=linked_mots.num_linked_mot";
$execute_query1=mysql_query($rqt1);
while ($r1=mysql_fetch_object($execute_query1)) {
$t1=array();
$t1["code"]=$r1->id_mot;
$t1["mot"]=$r1->mot;
$t[]=$t1;
}
}
return $t;
}
//fonction qui r�cup�re le code php en base des mots vides du dernier calcul
function add_empty_words() {
//ajout des mots vides calcul�s
$rqt="select php_empty_words from empty_words_calculs where archive_calcul=1";
$execute_query=mysql_query($rqt);
if ($execute_query&&mysql_num_rows($execute_query)) {
$r=mysql_fetch_object($execute_query);
return $r->php_empty_words;
}
}
//fonction qui calcule les mots vides par rapport � l'index globale des mots
function calculate_empty_words($nb_notices_calcul=0) {
//si mot pas de lien suppression du mot
@mysql_query("delete from mots where id_mot in (select num_mot from linked_mots where linked_mots.type_lien=2 group by num_mot) and id_mot not in (select num_linked_mot from linked_mots group by num_linked_mot)");
//vidage des mots vides calcul�s de la table linked_mots
@mysql_query("delete from linked_mots where type_lien=2");
//si le param�tre de nombre de notices pour lequel le mot est consid�r� vide est vide, on consid�re que ce nombre est la moiti� des notices
//si le nombre de notices pour lequel le mot est pr�sent est sup�rieur au param�tre
if (!$nb_notices_calcul) $nb_noti="*2>nb";
else $nb_noti=">".$nb_notices_calcul;
$rqt1="select word, count(id_notice) as cm,(select count(*) from notices) as nb from notices_mots_global_index join words on num_word = id_word group by num_word having cm$nb_noti";
$execute_query1=mysql_query($rqt1);
//parcours de tous les mots trouv�s afin de g�n�rer le code php
while ($r1=mysql_fetch_object($execute_query1)) {
//v�rification de l'existence du mot dans la table mots
$rqt_select="select id_mot from mots where mot='".$r1->word."'";
$query_select=mysql_query($rqt_select);
if ($r_mot=mysql_num_rows($query_select)) {
$id_mot=$r_mot->id_mot;
// Verifier de l'existance en mot vide (type_lien � 3)
$rqt_words_created="select mot from mots,linked_mots where mots.id_mot=linked_mots.num_mot and linked_mots.type_lien=3";
$query_select=mysql_query($rqt_select);
if (!mysql_num_rows($query_select)) {
// Le mot est aussi un synonyme, donc insertion information mot vide calcul�
mysql_query("insert into linked_mots (num_mot,num_linked_mot, type_lien) values (".$id_mot.",0,2)");
}
} else {
//ajout du mot
@mysql_query("insert into mots (mot) values ('".$r1->word."')");
$id_mot=mysql_insert_id();
@mysql_query("insert into linked_mots (num_mot,num_linked_mot, type_lien) values (".$id_mot.",0,2)");
}
}
}
function gen_table_empty_word() {
//ajout des mots pour remplir $empty_word[]
global $empty_word;
mysql_query("delete from empty_words_calculs");
$temp="";
$rqt_words_created="select mot from mots,linked_mots where id_mot=num_mot and (type_lien=3 or type_lien=2)";
$query_words_created=mysql_query($rqt_words_created);
while ($result_words_created=mysql_fetch_object($query_words_created)) {
$mot = convert_diacrit($result_words_created->mot);
$words = pmb_alphabetic('^a-z0-9\s\*', ' ',pmb_strtolower($mot));
$words=explode(" ",$words);
//Variable de stockage des mots restants apr�s supression des mots vides
//Pour chaque mot
for ($i=0; $i