}
$query .= "WHERE {$where}";
$db->send_query($query);
}
}
}
$express->count_ar['sym']['ex']++;
} else {
// check for similar symptoms in the database
$query = $express->build_select_duplicated_symptoms_query($symptom, $symptom1_similar_ar, $symptom2_similar_ar);
if ($query != "" && empty($_POST['insert_duplicated'])) {
// if there are some duplication
$express->count_ar['sym']['sim']++;
// execute the select query
$result = $db->send_query_limit($query, $number_duplicated_records, 0);
$results_table_ar[] = $express->build_possible_duplication_table($result);
$db->free_result($result);
$duplicated_symptoms_ar[] = $symptom;
$is_duplicated_symptom = 1;
$express->script .= "{$backup}: ";
} else {
if ($query != "" && !empty($_POST['insert_duplicated'])) {
$express->count_ar['sym']['sim_in']++;
}
$symptom = $db->escape_string($symptom);
$query = "INSERT INTO symptoms (symptom, rubric_id, lang_id, username) VALUES ('{$symptom}', '{$rubric_id}', '" . $express->src_lang . "', '{$current_user}')";
$db->send_query($query);
$sym_id = $db->db_insert_id();
if (!empty($page) || !empty($extra) || !empty($sym_kuenzli)) {
$query = "INSERT INTO sym_src (sym_id, src_id, src_page, extra, kuenzli, username) VALUES ('{$sym_id}', '{$express->src_id}', '{$page}', '{$extra}', '{$sym_kuenzli}', '{$current_user}')";
$db->send_query($query);
