function copy_table($table, $idvar, $cond = "", $delete = true) { global $do_delete, $do_insert, $new_db_name, $old_db_name; $dquery = "DELETE FROM " . $new_db_name . "." . table($table) . ""; if ($do_delete && $delete) { $done = or_query($dquery); } $squery = "SELECT * FROM " . $old_db_name . "." . table($table); if ($cond) { $squery .= ' ' . $cond; } $result = or_query($squery); while ($line = pdo_fetch_assoc($result)) { $line = convert_array_to_UTF8($line); if ($do_insert) { $done = orsee_db_save_array($line, $table, $line[$idvar], $idvar); } } }
} if ($continue) { echo "All checks succeeded.\n"; foreach ($participants as $participant) { $new_id = participant__create_participant_id($participant); $participant['participant_id'] = $new_id['participant_id']; $participant['participant_id_crypt'] = $new_id['participant_id_crypt']; $participant['status_id'] = $participant_status_id; $participant['creation_time'] = time(); $participant['deletion_time'] = 0; $participant['last_profile_update'] = $participant['creation_time']; $participant['last_activity'] = $participant['creation_time']; $participant['last_enrolment'] = 0; $participant['subpool_id'] = $subpool_id; $participant['subscriptions'] = id_array_to_db_string($cexptypes); if (!isset($participant['language']) || !$participant['language']) { $participant['language'] = $settings['public_standard_language']; } $participant = convert_array_to_UTF8($participant); //var_dump($participant); if (!$debug) { $done = orsee_db_save_array($participant, "participants", $participant['participant_id'], "participant_id"); } } if (!$debug) { echo "Imported " . $pcount . " participant profiles.\n"; } else { echo "Debugging run. Nothing imported.\n"; } } echo "\n";