[Web-erp-svn] SF.net SVN: web-erp:[6531] trunk

[<dai...@us...>]

Revision: 6531
          http://sourceforge.net/p/web-erp/reponame/6531
Author:   daintree
Date:     2014-01-10 11:37:27 +0000 (Fri, 10 Jan 2014)
Log Message:
-----------
Tims fix for upper case database names

Modified Paths:
--------------
    trunk/doc/Change.log
    trunk/includes/ConnectDB.inc

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2014-01-09 17:17:00 UTC (rev 6530)
+++ trunk/doc/Change.log	2014-01-10 11:37:27 UTC (rev 6531)
@@ -1,9 +1,12 @@
 webERP Change Log
+
 2/1/14 Exson: Fixed php-mbstring extension detection failure in install/index.php during installation. 
 27/12/13 Thumb: Fixed the stock location will loss problem when move to StockAdjustmentsControlled.php interface in StockAdjustments.php.
 23/12/13 Exson: Fixed the controlled items cannot be removed due to the negative operator is modified and balance of a serial no is wrong due negative operator is missing during credit controlled items by KEYED method. Other input method has not be inspected. 
-22/12/2013 Exson: Add a fool-proof to Credit_Invoice.php to prevent an invoice was credit again and again. 
-22/12/2013 Exson: Modify the stock select element to a combox box which autocomplete the limited stock ID options to 300 in PriceMatrix.php. Otherwise, users have to input an stock ID themselves. To avoid a too long stock list as pointed by Tim.
+6/1/14 Phil: Apply Tim's bug report regarding conversion of database name to lower case in ConnectDB.inc Although uppercase characters should not be included in database names, removing this trap allows backward compatibility with users who did install with upper case database name
+4/1/14 Phil: Add option to create CSV from inventory valuation rather than create PDF
+22/12/13 Exson: Add a fool-proof to Credit_Invoice.php to prevent an invoice was credit again and again. 
+22/12/13 Exson: Modify the stock select element to a combox box which autocomplete the limited stock ID options to 300 in PriceMatrix.php. Otherwise, users have to input an stock ID themselves. To avoid a too long stock list as pointed by Tim.
 
 21/12/13 Exson: Add price matrix features. Modified MainMenuLinksArray.php, GetPrice.inc and add pricematrix table and PriceMatrix.php
 20/12/13 Thumb: Salesman can only review his own customer's data 

Modified: trunk/includes/ConnectDB.inc
===================================================================
--- trunk/includes/ConnectDB.inc	2014-01-09 17:17:00 UTC (rev 6530)
+++ trunk/includes/ConnectDB.inc	2014-01-10 11:37:27 UTC (rev 6531)
@@ -10,8 +10,8 @@
 if (!isset($_SESSION['DatabaseName'])){ //need to get the database name from the file structure
 	if (isset($_POST['CompanyNameField'])){
 	    if (isset($CompanyList) && is_array($CompanyList)) {
-            foreach ($CompanyList as $key => $CompanyEntry){
-               if (is_dir('./companies/'.strtolower($CompanyEntry['database']).'') && ($key == $_POST['CompanyNameField']) ) {
+            foreach ($CompanyList as $CompanyEntryKey => $CompanyEntry){
+               if (is_dir('./companies/'. $CompanyEntry['database']) AND ($CompanyEntryKey == $_POST['CompanyNameField']) ) {
                    $_SESSION['DatabaseName'] = $CompanyEntry['database'];
                    $_SESSION['CompanyName'] = $CompanyEntry['company'];
                     include_once ($PathPrefix . 'includes/ConnectDB_' . $DBType . '.inc');