Changed license type to GPLv3 in top of files

[fa-stable.git] / admin / db / maintenance_db.inc

diff --git a/admin/db/maintenance_db.inc b/admin/db/maintenance_db.inc
index 1a08ce62539a5785e6c258bf0351dbc04493d2af..a6d2ee80ce44c52819885421fe68912cec79cc11 100644 (file)
--- a/admin/db/maintenance_db.inc
+++ b/admin/db/maintenance_db.inc
@@ -1,4 +1,14 @@
 <?php
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+       Released under the terms of the GNU General Public License,
+       GPL, as published by the Free Software Foundation, either version 
+       3 of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
 
 function write_config_db($new = false)
 {
@@ -105,7 +115,7 @@ function db_drop_db($connection)
        }
 }
 
-function db_import($filename, $connection)
+function db_import($filename, $connection, $force=true)
 {
        global $db;
        $allowed_commands = array(
@@ -114,13 +124,22 @@ function db_import($filename, $connection)
                "insert" => 'data_queries', 
                "update" => 'data_queries', 
                "drop table if exists" => 'drop_queries');
-
+       $ignored_mysql_errors = array( //errors ignored in normal (non forced) mode
+               '1022', // duplicate key
+               '1050', // Table %s already exists
+               '1060', // duplicate column name
+               '1061', // duplicate key name
+               '1062', // duplicate key entry
+               '1091'  // can't drop key/column check if exists
+       );
        $data_queries = array();
        $drop_queries = array();
        $table_queries = array();
        $sql_errors = array();
 
        ini_set("max_execution_time", "180");
+       db_query("SET foreign_key_checks=0");
+
        // uncrompress gziped backup files
        if (strpos($filename, ".gzip") || strpos($filename, ".GZIP"))
                $lines = db_ungzip("lines", $filename);
@@ -144,6 +163,8 @@ function db_import($filename, $connection)
                                if (strtolower(substr($line, 0, strlen($cmd))) == $cmd) 
                                {
                                        $query_table = $table;
+                                       if (strstr(strtolower($line), ' drop column '))
+                                               $query_table = 'drop_queries';
                                        ${$query_table}[] = array('', $line_no+1);
                                        break;
                                }
@@ -161,24 +182,25 @@ function db_import($filename, $connection)
                }
                
        }
-
-/*     {       // for debugging purposes
+/*
+       {       // for debugging purposes
        global $path_to_root;
-       $f = fopen($path_to_root.'/tmp/dbimport.txt', 'w');
+       $f = fopen($path_to_root.'/tmp/dbimport.txt', 'w+');
        fwrite($f, print_r($drop_queries,true) ."\n");
-       fwrite(print_r($table_queries,true) ."\n");
-       fwrite(print_r($data_queries,true));
+       fwrite($f, print_r($table_queries,true) ."\n");
+       fwrite($f, print_r($data_queries,true));
        fclose($f);
        }
 */
        // execute drop tables if exists queries
-       if (is_array($drop_queries))
+       if ($force && is_array($drop_queries))
        {
                foreach($drop_queries as $drop_query)
                {
                        if (!db_query($drop_query[0]))
                        {
-                               $sql_errors[] = array(db_error_msg($db), $drop_query[1]);
+                               if (!in_array(db_error_no(), $ignored_mysql_errors))
+                                       $sql_errors[] = array(db_error_msg($db), $drop_query[1]);
                        }
                }
        }
@@ -189,8 +211,10 @@ function db_import($filename, $connection)
                foreach($table_queries as $table_query)
                {
                        if (!db_query($table_query[0]))
-                       {
-                               $sql_errors[] = array(db_error_msg($db), $table_query[1]);
+                       {       
+                               if (!in_array(db_error_no(), $ignored_mysql_errors) || !$force) {
+                                       $sql_errors[] = array(db_error_msg($db), $table_query[1]);
+                               }
                        }
                }
        }
@@ -202,12 +226,14 @@ function db_import($filename, $connection)
                {
                        if (!db_query($data_query[0]))
                        {
-                               $sql_errors[] = array(db_error_msg($db), $data_query[1]);
-                               break;
+                               if (!in_array(db_error_no(),$ignored_mysql_errors) || !$force)
+                                       $sql_errors[] = array(db_error_msg($db), $data_query[1]);
                        }
                }
        }
        
+       db_query("SET foreign_key_checks=1");
+
        if (count($sql_errors)) {
                // display first failure message; the rest are probably derivative 
                $err = $sql_errors[0];
@@ -277,13 +303,12 @@ function db_unzip($mode, $path)
 
 // generates a dump of $db database
 // $drop and $zip tell if to include the drop table statement or dry to pack
-function db_export($conn, $filename, $zip='no', $comment='')
+function db_export($conn, $filename, $zip='no', $comment='', $tbpref = TB_PREF)
 {
 
        global $app_title, $version, $power_url, $path_to_root;
 
     $error = false;
-
     // set max string size before writing to file
     $max_size = 1048576 * 2; // 2 MB
     // changes max size if value can be retrieved
@@ -297,7 +322,8 @@ function db_export($conn, $filename, $zip='no', $comment='')
        $backupfile = $filename . ".zip";
     else
        $backupfile = $filename;
-    $company = get_company_pref('coy_name');
+    $company = get_company_pref('coy_name', $tbpref);
+
     //create comment
     $out="# MySQL dump of database '".$conn["dbname"]."' on host '".$conn["host"]."'\n";
     $out.="# Backup Date and Time: ".date("Y-m-d H:i")."\n";
@@ -621,5 +647,21 @@ function save_to_file($backupfile, $zip, $fileData)
     }
 }
 
-
+function create_comp_dirs($comp_path, $comp_subdirs)
+{
+               $index = "<?php\nheader(\"Location: ../index.php\");\n?>";
+           $cdir = $comp_path;
+           @mkdir($cdir);
+               $f = @fopen("$cdir/index.php", "wb");
+               @fwrite($f, $index);
+               @fclose($f);
+
+           foreach($comp_subdirs as $dir)
+           {
+                       @mkdir($cdir.'/'.$dir);
+                       $f = @fopen("$cdir/$dir/index.php", "wb");
+                       @fwrite($f, $index);
+                       @fclose($f);
+           }
+}
 ?>
\ No newline at end of file