X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=inline;f=install%2Fsave.php;h=2b7d7ed83c44ab006e7f3878981914eb0aba1259;hb=380ae03e2df9602d07d156ae93b87cbe59b01b3a;hp=e6de3fe9297251518ee9e0a22e4a68f325365fbb;hpb=5928cc0bb4164cfd1dfc77f279f6b12d7806294f;p=fa-stable.git
diff --git a/install/save.php b/install/save.php
index e6de3fe9..2b7d7ed8 100644
--- a/install/save.php
+++ b/install/save.php
@@ -1,54 +1,49 @@
+ Copyright (C) 2004-2007, Ryan Djurovich.
+ The code is released under GPLv3
+ modified by FrontAcounting, LLC.
+***********************************************************************/
error_reporting(E_ALL);
ini_set("display_errors", "On");
+ini_set("max_execution_time", "180");
// Start a session
-if(!defined('SESSION_STARTED'))
+if(!defined('SESSION_STARTED'))
{
session_name('ba_session_id');
session_start();
define('SESSION_STARTED', true);
}
-// Function to set error
-function set_error($message)
+if (!function_exists("_")) {
+ function _($msg) {
+ return $msg;
+ }
+}
+// Installer version of display_error function.
+//
+function display_error($message)
{
- global $_POST;
- if(isset($message) AND $message != '')
+ global $_POST, $path_to_root;
+
+ if(isset($message) AND $message != '')
{
// Copy values entered into session so user doesn't have to re-enter everything
- if(isset($_POST['company_name']))
+ if(isset($_POST['company_name']))
{
$_SESSION['ba_url'] = $_POST['ba_url'];
- if(!isset($_POST['operating_system']))
- {
- $_SESSION['operating_system'] = 'linux';
- }
- else
- {
- $_SESSION['operating_system'] = $_POST['operating_system'];
- }
- if(!isset($_POST['world_writeable']))
- {
- $_SESSION['world_writeable'] = false;
- }
- else
- {
- $_SESSION['world_writeable'] = true;
- }
+ $_SESSION['operating_system'] = isset($_POST['operating_system']);
+ $_SESSION['world_writeable'] = isset($_POST['world_writeable']);
$_SESSION['database_host'] = $_POST['database_host'];
$_SESSION['database_username'] = $_POST['database_username'];
$_SESSION['database_password'] = $_POST['database_password'];
$_SESSION['database_name'] = $_POST['database_name'];
- $_SESSION['table_prefix'] = $_POST['table_prefix'];
- if(!isset($_POST['install_tables']))
- {
- $_SESSION['install_tables'] = false;
- }
- else
- {
- $_SESSION['install_tables'] = true;
- }
+ $_SESSION['demo_data'] = isset($_POST['demo_data']);
+ $_SESSION['table_prefix'] = isset($_POST['table_prefix']);
+ $_SESSION['install_tables'] = isset($_POST['install_tables']);
$_SESSION['company_name'] = $_POST['company_name'];
$_SESSION['admin_email'] = $_POST['admin_email'];
$_SESSION['admin_password'] = $_POST['admin_password'];
@@ -59,17 +54,18 @@ function set_error($message)
// Specify that session support is enabled
$_SESSION['session_support'] = 'Enabled';
// Redirect to first page again and exit
+ @unlink($path_to_root."/config.php"); // remove just created config file
header('Location: index.php?sessions_checked=true');
exit();
}
}
// Function to workout what the default permissions are for files created by the webserver
-function default_file_mode($temp_dir)
+function default_file_mode($temp_dir)
{
$v = explode(".",PHP_VERSION);
$v = $v[0].$v[1];
- if($v > 41 && is_writable($temp_dir))
+ if($v > 41 && is_writable($temp_dir))
{
$filename = $temp_dir.'/test_permissions.txt';
$handle = fopen($filename, 'w');
@@ -77,8 +73,8 @@ function default_file_mode($temp_dir)
fclose($handle);
$default_file_mode = '0'.substr(sprintf('%o', fileperms($filename)), -3);
unlink($filename);
- }
- else
+ }
+ else
{
$default_file_mode = '0777';
}
@@ -86,27 +82,27 @@ function default_file_mode($temp_dir)
}
// Function to workout what the default permissions are for directories created by the webserver
-function default_dir_mode($temp_dir)
+function default_dir_mode($temp_dir)
{
$v = explode(".",PHP_VERSION);
$v = $v[0].$v[1];
- if ($v > 41 && is_writable($temp_dir))
+ if ($v > 41 && is_writable($temp_dir))
{
$dirname = $temp_dir.'/test_permissions/';
mkdir($dirname);
$default_dir_mode = '0'.substr(sprintf('%o', fileperms($dirname)), -3);
rmdir($dirname);
- }
- else
+ }
+ else
{
$default_dir_mode = '0777';
}
return $default_dir_mode;
}
-function add_slashes($input)
+function add_slashes($input)
{
- if (get_magic_quotes_gpc() || (!is_string($input)))
+ if (get_magic_quotes_gpc() || (!is_string($input)))
{
return $input;
}
@@ -116,47 +112,47 @@ function add_slashes($input)
function check_db_error($err_msg, $sql)
{
return true;
-}
+}
if (isset($_POST['path_to_root']))
$path_to_root = $_POST['path_to_root'];
-else
+else
$path_to_root = "..";
-
+
// Begin check to see if form was even submitted
// Set error if no post vars found
-if (!isset($_POST['company_name']))
+if (!isset($_POST['company_name']))
{
- set_error('Please fill-in the form below');
+ display_error('Please fill-in the form below');
}
// End check to see if form was even submitted
// Begin path and timezone details code
// Check if user has entered the installation url
-if (!isset($_POST['ba_url']) || $_POST['ba_url'] == '')
+if (!isset($_POST['ba_url']) || $_POST['ba_url'] == '')
{
- set_error('Please enter an absolute URL');
-}
-else
+ display_error('Please enter an absolute URL');
+}
+else
{
$ba_url = $_POST['ba_url'];
}
// Remove any slashes at the end of the URL
-if(substr($ba_url, strlen($ba_url) - 1, 1) == "/")
+if(substr($ba_url, strlen($ba_url) - 1, 1) == "/")
{
$ba_url = substr($ba_url, 0, strlen($ba_url) - 1);
}
-if(substr($ba_url, strlen($ba_url) - 1, 1) == "\\")
+if(substr($ba_url, strlen($ba_url) - 1, 1) == "\\")
{
$ba_url = substr($ba_url, 0, strlen($ba_url) - 1);
}
-if(substr($ba_url, strlen($ba_url) - 1, 1) == "/")
+if(substr($ba_url, strlen($ba_url) - 1, 1) == "/")
{
$ba_url = substr($ba_url, 0, strlen($ba_url) - 1);
}
-if(substr($ba_url, strlen($ba_url) - 1, 1) == "\\")
+if(substr($ba_url, strlen($ba_url) - 1, 1) == "\\")
{
$ba_url = substr($ba_url, 0, strlen($ba_url) - 1);
}
@@ -164,26 +160,26 @@ if(substr($ba_url, strlen($ba_url) - 1, 1) == "\\")
// Begin operating system specific code
// Get operating system
-if (!isset($_POST['operating_system']) || $_POST['operating_system'] != 'linux' && $_POST['operating_system'] != 'windows')
+if (!isset($_POST['operating_system']) || $_POST['operating_system'] != 'linux' && $_POST['operating_system'] != 'windows')
{
- set_error('Please select a valid operating system');
-}
-else
+ display_error('Please select a valid operating system');
+}
+else
{
$operating_system = $_POST['operating_system'];
}
// Work-out file permissions
-if($operating_system == 'windows')
+if($operating_system == 'windows')
{
$file_mode = '0777';
$dir_mode = '0777';
-}
-elseif (isset($_POST['world_writeable']) && $_POST['world_writeable'] == 'true')
+}
+elseif (isset($_POST['world_writeable']) && $_POST['world_writeable'] == 'true')
{
$file_mode = '0777';
$dir_mode = '0777';
-}
-else
+}
+else
{
$file_mode = default_file_mode('../includes');
$dir_mode = default_dir_mode('../includes');
@@ -192,49 +188,53 @@ else
// Begin database details code
// Check if user has entered a database host
-if (!isset($_POST['database_host']) || $_POST['database_host'] == '')
+if (!isset($_POST['database_host']) || $_POST['database_host'] == '')
{
- set_error('Please enter a database host name');
-}
-else
+ display_error('Please enter a database host name');
+}
+else
{
$database_host = $_POST['database_host'];
}
// Check if user has entered a database username
-if (!isset($_POST['database_username']) || $_POST['database_username'] == '')
+if (!isset($_POST['database_username']) || $_POST['database_username'] == '')
{
- set_error('Please enter a database username');
-}
-else
+ display_error('Please enter a database username');
+}
+else
{
$database_username = $_POST['database_username'];
}
// Check if user has entered a database password
-if (!isset($_POST['database_password']))
+if (!isset($_POST['database_password']))
{
- set_error('Please enter a database password');
-}
-else
+ display_error('Please enter a database password');
+}
+else
{
$database_password = $_POST['database_password'];
}
// Check if user has entered a database name
-if (!isset($_POST['database_name']) || $_POST['database_name'] == '')
+if (!isset($_POST['database_name']) || $_POST['database_name'] == '')
{
- set_error('Please enter a database name');
-}
-else
+ display_error('Please enter a database name');
+}
+else
{
$database_name = $_POST['database_name'];
}
// Get table prefix
-$table_prefix = $_POST['table_prefix'];
+if (isset($_POST['table_prefix']) && $_POST['table_prefix'] == 'true')
+ $table_prefix = "0_";
+else
+ $table_prefix = "";
+
// Find out if the user wants to install tables and data
-if (isset($_POST['install_tables']) && $_POST['install_tables'] == 'true')
+if (isset($_POST['install_tables']) && $_POST['install_tables'] == 'true')
{
$install_tables = true;
-}
-else
+}
+else
{
$install_tables = false;
}
@@ -242,64 +242,86 @@ else
// Begin company name code
// Get company name
-if (!isset($_POST['company_name']) || $_POST['company_name'] == '')
+if (!isset($_POST['company_name']) || $_POST['company_name'] == '')
{
- set_error('Please enter a company name');
-}
-else
+ display_error('Please enter a company name');
+}
+else
{
$company_name = add_slashes($_POST['company_name']);
}
// End website company name
// Check if the user has entered a correct path
-if (!file_exists($path_to_root.'/sql/en_US-demo.sql'))
+if (!file_exists($path_to_root.'/sql/en_US-'.(isset($_POST['demo_data']) ? 'demo':'new').'.sql'))
{
- set_error('It appears the Absolute path that you entered is incorrect');
+ display_error('It appears the Absolute path that you entered is incorrect');
}
// Get admin email and validate it
-if (!isset($_POST['admin_email']) || $_POST['admin_email'] == '')
+if (!isset($_POST['admin_email']) || $_POST['admin_email'] == '')
{
- set_error('Please enter an email for the Administrator account');
-}
-else
+ display_error('Please enter an email for the Administrator account');
+}
+else
{
- if (eregi("^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$", $_POST['admin_email']))
+ if (preg_match("/^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$/i", $_POST['admin_email']))
{
$admin_email = $_POST['admin_email'];
- }
- else
+ }
+ else
{
- set_error('Please enter a valid email address for the Administrator account');
+ display_error('Please enter a valid email address for the Administrator account');
}
}
// Get the two admin passwords entered, and check that they match
-if (!isset($_POST['admin_password']) || $_POST['admin_password'] == '')
+if (!isset($_POST['admin_password']) || $_POST['admin_password'] == '')
{
- set_error('Please enter a password for the Administrator account');
-}
-else
+ display_error('Please enter a password for the Administrator account');
+}
+else
{
$admin_password = $_POST['admin_password'];
}
-if (!isset($_POST['admin_repassword']) || $_POST['admin_repassword'] == '')
+if (!isset($_POST['admin_repassword']) || $_POST['admin_repassword'] == '')
{
- set_error('Please make sure you re-enter the password for the Administrator account');
-}
-else
+ display_error('Please make sure you re-enter the password for the Administrator account');
+}
+else
{
$admin_repassword = $_POST['admin_repassword'];
}
-if ($admin_password != $admin_repassword)
+if ($admin_password != $admin_repassword)
{
- set_error('Sorry, the two Administrator account passwords you entered do not match');
+ display_error('Sorry, the two Administrator account passwords you entered do not match');
}
// End admin user details code
+copy($path_to_root. "/config.default.php", $path_to_root. "/config.php");
+
include_once($path_to_root . "/includes/db/connect_db.inc");
include_once($path_to_root . "/admin/db/maintenance_db.inc");
-include_once($path_to_root . "/config_db.php");
+
+if (!file_exists($path_to_root . "/installed_extensions.php")) {
+ $next_extension_id = 1;
+ write_extensions(array());
+ write_extensions(array(),0);
+}
+if (!file_exists($path_to_root . "/lang/installed_languages.inc")) {
+ $installed_languages = array (
+ 0 => array ('code' => 'en_GB', 'name' => 'English', 'encoding' => 'iso-8859-1'));
+ $dflt_lang = 'en_GB';
+ write_lang();
+}
+
+if (file_exists($path_to_root . "/config_db.php"))
+ include_once($path_to_root . "/config_db.php");
+ else
+{
+ $def_coy = 0;
+ $tb_pref_counter = 0;
+ $db_connections = array ();
+}
$id = count($db_connections);
if ($table_prefix != "" && $id > 0)
@@ -315,47 +337,54 @@ $def_coy = $id;
$config_filename = $path_to_root . '/config_db.php';
-$err = write_config_db($table_prefix != "");
-if ($err == -1)
- set_error("Cannot open the configuration file ($config_filename)");
-else if ($err == -2)
- set_error("Cannot write to the configuration file ($config_filename)");
-else if ($err == -3)
- set_error("The configuration file $config_filename is not writable. Change its permissions so it is, then re-run step 4.");
-
-// Try connecting to database
+// Try connecting to database
$db = mysql_connect($database_host, $database_username, $database_password);
if (!$db)
{
- set_error('Database host name, username and/or password incorrect. MySQL Error:
'.mysql_error());
-}
-
-if($install_tables == true)
-{
- if (!mysql_select_db($database_name, $db))
- {
-
- // Try to create the database
- mysql_query('CREATE DATABASE '.$database_name);
- mysql_select_db($database_name, $db);
- }
- $import_filename = $path_to_root."/sql/en_US-demo.sql";
- if (!db_import($import_filename, $db_connections[$id]))
- set_error("Import error, try to import $import_filename manually via phpMyAdmin");
-}
-else
-{
- mysql_select_db($database_name, $db);
+ display_error('Database host name, username and/or password incorrect. MySQL Error:
'.mysql_error());
+} else {
+ $result = true;
+ if($install_tables == true)
+ {
+ if (!mysql_select_db($database_name, $db))
+ {
+ // Try to create the database
+ if (!($result = mysql_query('CREATE DATABASE '.$database_name))) {
+ display_error(_("Cannot create database").
+ " '$database_name'");
+ } else
+ $result = mysql_select_db($database_name, $db);
+ }
+ if($result) {
+ $import_filename = $path_to_root.'/sql/en_US-'.(isset($_POST['demo_data']) ? 'demo':'new').'.sql';
+ db_import($import_filename, $db_connections[$id]);
+ }
+ }
+ else
+ {
+ $result = mysql_select_db($database_name, $db);
+ }
+ if ($result) {
+ $sql = "UPDATE ".$table_prefix."users SET password = '" . md5($admin_password) . "', email = ".db_escape($admin_email)." WHERE user_id = 'admin'";
+ db_query($sql, "could not update admin account");
+ $sql = "UPDATE ".$table_prefix."sys_prefs SET value = ".db_escape($company_name)." WHERE name='coy_name'";
+ db_query($sql, "could not update company name. Do it manually later in Setup");
+
+ $err = write_config_db($table_prefix != "");
+ if ($err == -1)
+ display_error("Cannot open the configuration file ($config_filename)");
+ else if ($err == -2)
+ display_error("Cannot write to the configuration file ($config_filename)");
+ else if ($err == -3)
+ display_error("The configuration file $config_filename is not writable. Change its permissions so it is, then re-run step 4.");
+ }
}
-$sql = "UPDATE ".$table_prefix."users SET password = '" . md5($admin_password) . "', email = ".db_escape($admin_email)." WHERE user_id = 'admin'";
-db_query($sql, "could not update admin account");
-$sql = "UPDATE ".$table_prefix."company SET coy_name = ".db_escape($company_name)." WHERE coy_code = 1";
-db_query($sql, "could not update company name. Do it manually later in Setup");
session_unset();
+session_regenerate_id();
session_destroy();
-$_SESSION = array();
+$_SESSION = array();
header("Location: ".$path_to_root."/index.php");
exit();