Example #1
0
     } else {
         if ($mode == "including" && !in_array($name, $included)) {
             continue;
         }
     }
     if (isset($table['map']) && array_key_exists($name, $table['map'])) {
         $dst_name = $table['map'][$name];
         $field['src_name'] = $name;
     } else {
         $dst_name = $name;
     }
     $dst_fields[$dst_name] = $field;
 }
 $table_info = array("name" => $table['destination'], "fields" => $dst_fields);
 $update_mode = $db_dst->table_exists($table_info['name']);
 $res = $db_dst->process_table($table_info);
 if ($res != false) {
     $first_field = array_shift(array_keys($src_fields));
     $query = "SELECT * FROM {$db_src->name}.{$table['source']} ORDER BY {$first_field} ASC";
     $res = mysql_query($query, $db_src->dbh);
     while ($row = mysql_fetch_assoc($res)) {
         if (!$update_mode) {
             $q_insert = "INSERT INTO {$db_dst->name}.{$table['destination']} ";
             $pairs = get_field_pairs($dst_fields, $row);
             $columns = implode(",", array_keys($pairs));
             $values = implode(",", array_values($pairs));
             $q_insert .= "({$columns}) VALUES ({$values});";
             $res_insert = mysql_query($q_insert);
             if (!$res_insert) {
                 ER($res_insert . ": " . mysql_error());
             }