Beispiel #1
0
                 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);
                 }
                 $inserted_symptoms_ar[] = $symptom;
                 $express->count_ar['sym']['in']++;
             }
         }
         $express->insert_remedy($sympt_id, $sym_id, $current_user, $is_duplicated_symptom);
     }
     $db->free_result($result_symptoms);
 }
 $query = "SELECT COUNT(*) FROM express_alias";
 $db->send_query($query);
 $count_alias = $db->db_fetch_row();
 $db->free_result();
 if ($count_alias[0] != 0) {
     $query = "SELECT remedy, aliase FROM express_alias";
     $result_alias = $db->send_query($query);
     while (list($rem_short, $aliase) = $db->db_fetch_row($result_alias)) {
         $alias_ar = explode(", ", $aliase);
         $express->count_ar['rec']['all']++;
         $express->count_ar['rec']['alias']['all']++;
         $query = "SELECT rem_id FROM remedies WHERE rem_short = '{$rem_short}.' OR rem_short = '{$rem_short}'";