function reset_sequence($sequence, $newval)
{
$this->nextid($sequence);
$esequence = $sequence . "_seq";
$SQL = "setval('{$esequence}', {$newval})";
$query = new query($this, $SQL);
return $query->error();
}
function reset_sequence($sequence, $newval)
{
$this->nextid($sequence);
$esequence = $sequence . "_seq";
$sSQL = "Replace into {$esequence} values ('', {$newval})";
$query = new query($this, $sSQL);
return $query->error();
}
echo ".";
flush();
}
$SQL = "select id, attachment from {$rec['table_name']}";
$q->query($DB, $SQL);
if ($q->numrows() > 0) {
echo "Converting Attachments for {$rec['name']}<br />\n";
while ($rec2 = $q->getrow()) {
$id = $DB->nextid("{$rec['table_name']}_attachments");
if ($id == 0 && $DB->type != "mysql") {
echo "Could not get an id for the attachment.<br />\n";
} else {
if ($rec2[attachment]) {
$SQL = "Insert into {$rec['table_name']}_attachments (id, message_id, filename) values({$id}, {$rec2['id']}, '{$rec2['attachment']}')";
$q2->query($DB, $SQL);
$err = $q2->error();
if ($err == "") {
if ($DB->type == "mysql") {
$id = $DB->lastid();
}
$new_name = "{$AttachmentDir}/{$rec['table_name']}/{$rec2['id']}" . "_{$id}" . strtolower(strrchr($rec2["attachment"], "."));
if (!rename("{$AttachmentDir}/{$rec['table_name']}/{$rec2['attachment']}", $new_name)) {
echo "Can't save upload file.";
}
}
} else {
echo "Error adding attachment. DB said: {$err}<br />\n";
}
}
}
$SQL = "ALTER TABLE {$rec['table_name']} DROP attachment";
