X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.3.php;h=bdeab5c67c88f6374160729bbe82c2818b9a1692;hb=1d8bbcbf6bf6c663d83283be329758a936f863fa;hp=e480eda5eb12eed2e79079ffb518722d7bd42890;hpb=39150665d5955716247c6c6e06adbcc2cad037a9;p=fa-stable.git

diff --git a/sql/alter2.3.php b/sql/alter2.3.php
index e480eda5..bdeab5c6 100644
--- a/sql/alter2.3.php
+++ b/sql/alter2.3.php
@@ -26,7 +26,7 @@ class fa2_3 {
 	//
 	function install($pref, $force) 
 	{
-		global $db_version;
+		global $db_version, $dflt_lang;
 
 		if (!$this->preconf)
 			return false;
@@ -91,6 +91,7 @@ class fa2_3 {
 			if (!db_query($sql))
 				return false;
 		}
+		$this->update_lang_cfg();
 		return  update_company_prefs(array('version_id'=>$db_version), $pref);
 	}
 	//
@@ -137,14 +138,15 @@ class fa2_3 {
 		include_once("$path_to_root/sales/includes/cart_class.inc");
 		include_once("$path_to_root/purchasing/includes/po_class.inc");
 		$cart = new cart(ST_SALESORDER);
-		$sql = "SELECT order_no FROM {$pref}sales_orders";
+		$sql = "SELECT order_no, trans_type FROM {$pref}sales_orders";
 		$orders = db_query($sql);
 		if (!$orders)
 			return false;
-
-		while ($order_no = db_fetch($orders)) {
-			read_sales_order($order_no[0], $cart, ST_SALESORDER);
-			$result = db_query("UPDATE {$pref}sales_orders SET total=".$cart->get_trans_total());
+		while ($order = db_fetch($orders)) {
+			read_sales_order($order['order_no'], $cart, $order['trans_type']);
+			$result = db_query("UPDATE {$pref}sales_orders 
+				SET total=".$cart->get_trans_total()
+				." WHERE order_no=".$order[0]);
 			unset($cart->line_items);
 		}
 		unset($cart);
@@ -279,12 +281,15 @@ class fa2_3 {
 		if ($lang_chd)
 			write_lang();
 
-		$installed_extensions= get_company_extensions();
 		
+		$installed_extensions= get_company_extensions();
 		if (!isset($next_extension_id))
 			$next_extension_id = 1;
 		$new_exts = array();
 		
+/*	Old extension modules are uninstalled - they need manual porting after 
+	heavy changes in extension system in FA2.3
+	
 		foreach($installed_extensions as $i => $ext)
 		{
 			if (isset($ext['title'])) // old type entry
@@ -313,14 +318,15 @@ class fa2_3 {
 				}
 				if (isset($ext['acc_file']))
 					$new['acc_file'] = $ext['acc_file'];
-				$new['name'] = $ext['name']; // albo access_string(title)
+				$new['name'] = $ext['name'];
 				$new['package'] = $new['package'] = '';
 				$new['active'] = 1;
 
 				$new_exts[$i] = $new;
 			}
 		}
-		// Add non-standard themes
+*/		
+		// Preserve non-standard themes
 		$path = $path_to_root.'/themes/';
 		$themes = array();
 		$themedir = opendir($path);
@@ -348,6 +354,22 @@ class fa2_3 {
 		} else
 			return true;
 	}
+	
+	function update_lang_cfg()
+	{
+		global $dflt_lang, $installed_languages;
+
+		foreach($installed_languages as $n => $lang) {
+			if ($lang['code'] == 'en_GB') {
+				$installed_languages[$n] = array('code'=>'C','name'=>'English',
+					'encoding'=>'iso-8859-1', 'path' => '', 'package' => '');
+				if ($dflt_lang == 'en_GB')
+					$dflt_lang = 'C';
+				write_lang();
+			}
+		}
+	}
+
 }
 
 $install = new fa2_3;