FrontAccounting Update

From 9a3a8ed9f332f5483e049a82795d7215a79b1f99 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 11 Feb 2008 14:56:31 +0000 Subject: [PATCH] Added file, update_db.php, for updating company databases from an SQL script. --- CHANGELOG.txt | 5 +++ update.html | 42 +++++++++--------- update_db.php | 117 ++++++++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 144 insertions(+), 20 deletions(-) create mode 100644 update_db.php diff --git a/CHANGELOG.txt b/CHANGELOG.txt index a292e98f..670871cf 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,11 @@ Legend: ! -> Note $ -> Affected files +11-Feb-2008 Joe Hunt ++ Added file, update_db.php, for updating company databases from an SQL script. +$ update_db.php (New file) + update.html + 06-Fef-2008 Joe Hunt + Added Report, Salesman Listing, rep106.php. $ /reporting/reports_main.php diff --git a/update.html b/update.html index e6114b00..5731d24f 100644 --- a/update.html +++ b/update.html @@ -4,7 +4,7 @@ - + FrontAccounting Update @@ -17,40 +17,42 @@

Important Notes

You can easily upload all the files to your installation folder on the -server overwriting the existing files, if you take these important -steps: +
You can easily upload all the files to your installation folder on the +server overwriting the existing files, if you take these important +steps:
1. Backup (download) the following files to another folder: +
2. Backup (download) the following files to another folder:
  1. config_db.php (contains information about the companies and -connection info). +
  2. config_db.php (contains information about the companies and +connection info).
  3. config.php (contains various settings. You only need to -backup this file if you have done manually changes to it. +
  4. config.php (contains various settings. You only need to +backup this file if you have done manually changes to it.
  5. /lang/installed_languages.inc (contains information about the -installed languages) +
  6. /lang/installed_languages.inc (contains information about the +installed languages)
  7. /modules/installed_modules.php (contains information about -installed modules, only vers. 1.1) +
  8. /modules/installed_modules.php (contains information about +installed modules, only vers. 1.1)
  9. if you have made changes to other files, like themes or so, backup +
  10. if you have made changes to other files, like themes or so, backup these files too.
3. Upload all the new files. +
4. Upload all the new files.
5. Restore the files mentioned in #1. Be careful with - config.db. Look into variances. There might be new variables in -the new version. It might be easier to manually change your former values in -the new file. +
6. Restore the files mentioned in #1. Be careful with + config.db. Look into variances. There might be new variables in +the new version. It might be easier to manually change your former values in +the new file.
7. Rename or remove the /install folder (you have already performed the install +
8. Rename or remove the /install folder (you have already performed the install process earlier).
If there are changes to the database structure, please run the script update_db.php +from FrontAccounting root installation, Enter the database user and the password and choose the update script from the local harddisk.

diff --git a/update_db.php b/update_db.php new file mode 100644 index 00000000..4b14ad70 --- /dev/null +++ b/update_db.php @@ -0,0 +1,117 @@ + + + + +

$msg

\n"; +} + +function display_notification($msg, $center=true) +{ + echo " + + + +

$msg

\n"; +} + + +function db_open($conn) +{ + $db = mysql_connect($conn["host"] ,$conn["dbuser"], $conn["dbpassword"]); + if (!$db) + return false; + if (!mysql_select_db($conn["dbname"], $db)) + return false; + return $db; +} + +echo "\n"; +echo "$title\n"; +echo "\n"; +echo "\n"; +echo $js; +echo " \n"; +echo ""; + +echo "

"; +echo "\n"; +echo "\n"; +echo "

\n"; + +echo "

"; +echo "$title\n"; +echo "
"; + +if (isset($_POST["submit"])) +{ + if (!isset($_FILES['uploadfile']['tmp_name']) || !is_uploaded_file($_FILES['uploadfile']['tmp_name'])) + { + display_error("You must select an SQL script for update");; + } + else + { + include_once($path_to_root."/config_db.php"); + if (!isset($_POST['user']) || !isset($_POST['passwd']) || $_POST['user'] == "") + { + display_error("You must select a user name and an optional password"); + } + else + { + foreach($db_connections as $id => $conn) + { + $conn['dbuser'] = $_POST['user']; + $conn['dbpassword'] = $_POST['passwd']; + if (!($db = db_open($conn))) + { + display_error("Wrong user name or password - ".mysql_error()); + } + else + { + if (!db_import($_FILES['uploadfile']['tmp_name'], $conn)) + display_error("Bad SQL file or you have already updated the company: " + . $id . " " . $conn['name']." - ".mysql_error()); + else + display_notification("Database has been updated for company: " + . $id . " " . $conn['name']); + } + } + } + } +} +if (!isset($_POST['passwd'])) + $_POST['passwd'] = ""; + +echo "\n"; + +echo "\n"; +?> \ No newline at end of file -- 2.30.2