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";