// Remove dots, replace + by X $line[0] = str_replace(array('.', '+'), array('', 'X'), trim($line[0])); $cim = CCodeCIM10::get($line[0]); if (!$cim->exist) { $list_diff[] = $line; } } fclose($fp); if (count($list_diff)) { CAppUI::stepAjax("Il existe " . count($list_diff) . " codes supplémentaires dans la CIM v.11", UI_MSG_WARNING); } else { CAppUI::stepAjax("Il n'y a pas de code supplémentaires dans la CIM v.11", UI_MSG_OK); } foreach ($list_diff as $diff) { $abbrev = $diff[0]; $full_code = CCodeCIM10::addPoint($abbrev); // Insertion des nouveaux codes $query = "INSERT into master (`code`, `abbrev`, `level`, `type`, `valid`, `author`) VALUES (\r\n '" . $full_code . "','" . $abbrev . "','" . strlen($full_code) . "','S','1','atih')"; $ds->exec($query); // On récupère la clé primaire du code ajouté $query = "SELECT * FROM master WHERE 1 ORDER BY SID DESC LIMIT 1"; $result = $ds->exec($query); $row = $ds->fetchArray($result); $SID = $row['SID']; // On ajoute les niveaux supérieurs $prev_SID = 0; $offset = 0; for ($i = 1; $i <= 7; $i++) { if ($i <= 2) { $query = "SELECT * FROM master WHERE abbrev LIKE('%" . substr($abbrev, 0, $i) . "%') ORDER BY code ASC LIMIT 1"; } else {