".htmlentities($msg["gen_phonetique_en_cours"], ENT_QUOTES, $charset)."
";
$query = mysql_query("select id_word,word from words LIMIT $start, $lot");
if(mysql_num_rows($query)) {
// définition de l'état de la jauge
$state = floor($start / ($count / $jauge_size));
// mise à jour de l'affichage de la jauge
print "";
print " |
";
// calcul pourcentage avancement
$percent = floor(($start/$count)*100);
// affichage du % d'avancement et de l'état
print "$percent%
";
while($row = mysql_fetch_object($query)){
$dmeta = new DoubleMetaPhone($row->word);
$stemming = new stemming($row->word);
$element_to_update = "";
if($dmeta->primary || $dmeta->secondary){
$element_to_update.="
double_metaphone = '".$dmeta->primary." ".$dmeta->secondary."'";
}
if($element_to_update) $element_to_update.=",";
$element_to_update.="stem = '".$stemming->stem."'";
if ($element_to_update){
mysql_query("update words set ".$element_to_update." where id_word = '".$row->id_word."'");
}
}
mysql_free_result($query);
$next = $start + $lot;
print "
";
} else {
$spec = $spec - GEN_PHONETIQUE;
$v_state .= "
";
$v_state .= $count." ".htmlentities($msg["gen_phonetique_end"], ENT_QUOTES, $charset);
$opt = mysql_query('OPTIMIZE TABLE words');
// mise à jour de l'affichage de la jauge
print "
100%
";
print "
";
}