X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fmaintenance_db.inc;h=444ac100d2f3cc72b0f32f2827dab98578e9742f;hb=b32d16b2c0c6c43e569ebe87e2a13ceb892b5788;hp=fdbd51bfc835aa4bad44400e63d47fb302d8db74;hpb=a12f6c16cc6e51cc8b3d02dfde9db3a028219199;p=fa-stable.git
diff --git a/admin/db/maintenance_db.inc b/admin/db/maintenance_db.inc
index fdbd51bf..444ac100 100644
--- a/admin/db/maintenance_db.inc
+++ b/admin/db/maintenance_db.inc
@@ -96,7 +96,7 @@ function db_drop_db($connection)
// get table structures
foreach ($all_tables as $table)
{
- if (strpos($table['Name'], $connection["tbpref"]) !== false)
+ if (strpos($table['Name'], $connection["tbpref"]) === 0)
db_query("DROP TABLE `".$table['Name'] . "`");
}
//deleting the tables, how??
@@ -136,6 +136,12 @@ function db_import($filename, $connection)
{
$data_queries[] = substr($line, 0, strlen($line) - 1);
+ // this line does not, too
+ }
+ elseif (strtolower(substr($line,0,6)) == "update")
+ {
+ $data_queries[] = substr($line, 0, strlen($line) - 1);
+
// this line does not, too
}
elseif (strtolower(substr($line, 0, 20)) == "drop table if exists")
@@ -149,6 +155,10 @@ function db_import($filename, $connection)
$table = true;
$table_queries[] = $line . "\n";
}
+ elseif (strtolower(substr($line, 0, 11)) == "alter table")
+ {
+ $data_queries[] = substr($line, 0, strlen($line) - 1);
+ }
// the current line belongs to a create sql query
}
@@ -156,8 +166,10 @@ function db_import($filename, $connection)
{
// create sql query ending in this line
- if (strtolower(substr($line, 0, 1)) == ")")
+ if (strtolower(substr($line, 0, 1)) == ")") {
$table = false;
+ $line = substr($line,0,strlen($line)-1);
+ }
$table_queries[count($table_queries) - 1] .= $line . "\n";
}
}
@@ -202,6 +214,7 @@ function db_import($filename, $connection)
{
//if ($CONF['import_error']) echo $data_query."\n
".mysql_error()."
\n";
$sql_error = true;
+ return false;
}
}
}
@@ -398,11 +411,7 @@ function db_export($conn, $filename, $zip='no', $comment='')
// run through each field
for ($k = 0; $k < $nf = db_num_fields($res2); $k++)
{
- // identify null values and save them as null instead of ''
- if ($field_type[$k] != "" && $field_type[$k] != "NO" && $row2[$k] == "")
- $out .= "NULL";
- else
- $out .= "'" . db_escape($row2[$k]) . "'";
+ $out .= db_escape($row2[$k]);
if ($k < ($nf - 1))
$out .= ", ";
}
@@ -422,7 +431,7 @@ function db_export($conn, $filename, $zip='no', $comment='')
}
elseif ($error)
{
- @unlink($path_to_root . BACKUP_PATH . $backupfile);
+ @unlink(BACKUP_PATH . $backupfile);
return false;
}
@@ -440,7 +449,7 @@ function db_export($conn, $filename, $zip='no', $comment='')
}
else
{
- @unlink($path_to_root . BACKUP_PATH . $backupfile);
+ @unlink(BACKUP_PATH . $backupfile);
return false;
}
@@ -455,7 +464,7 @@ function db_export($conn, $filename, $zip='no', $comment='')
}
else
{
- @unlink($path_to_root . BACKUP_PATH . $backupfile);
+ @unlink(BACKUP_PATH . $backupfile);
return false;
}
return $backupfile;
@@ -518,7 +527,7 @@ function save_to_file($backupfile, $zip, $fileData)
if ($zip == "gzip")
{
- if ($zp = @gzopen($path_to_root . BACKUP_PATH . $backupfile, "a9"))
+ if ($zp = @gzopen(BACKUP_PATH . $backupfile, "a9"))
{
@gzwrite($zp, $fileData);
@gzclose($zp);
@@ -594,7 +603,7 @@ function save_to_file($backupfile, $zip, $fileData)
// total # of entries "on this disk", total # of entries overall, size of central dir, offset to start of central dir, .zip file comment length
$fileData .= pack('v', 1) . pack('v', 1) . pack('V', strlen($cdrec)) . pack('V', strlen($fr)) . "\x00\x00";
- if ($zp = @fopen($path_to_root . BACKUP_PATH . $backupfile, "a"))
+ if ($zp = @fopen(BACKUP_PATH . $backupfile, "a"))
{
@fwrite($zp, $fileData);
@fclose($zp);
@@ -609,7 +618,7 @@ function save_to_file($backupfile, $zip, $fileData)
}
else
{
- if ($zp = @fopen($path_to_root . BACKUP_PATH . $backupfile, "a"))
+ if ($zp = @fopen(BACKUP_PATH . $backupfile, "a"))
{
@fwrite($zp, $fileData);
@fclose($zp);