Example #1
0
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);
        }
    }
}
Example #2
0
}
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";