[Weberp-cvs] SF.net SVN: web-erp:[3467] trunk

[<tim...@us...>]

Revision: 3467
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3467&view=rev
Author:   tim_schofield
Date:     2010-05-24 18:11:14 +0000 (Mon, 24 May 2010)

Log Message:
-----------
Correct SQL error on Currency updater

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

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-05-24 17:48:19 UTC (rev 3466)
+++ trunk/doc/Change.log.html	2010-05-24 18:11:14 UTC (rev 3467)
@@ -14,6 +14,7 @@
 <p>08/05/10 Lindsay: API was broken after adding a test for global variable $DatabaseName in ConnectDB_mysql* for this variable being set and using it as DB name if so.  The variable of that name in the api_php.php has been changed to $api_DatabaseName.</p>
 <p>08/05/10 Phil: GetPrices.inc now uses the new price startdate and enddate to return the price which falls within the date range base on the current date. Changes to Prices.php and Prices_Customer.php to allow entry of effective from and effective to dates and updating/deleting of prices with appropriate error trapping and rescheduling of enddates where start and end dates would otherwise overlap.</p>
 <p>08/05/10 Phil: Found a bug in Date1GreaterThanDate2 function (in includes/DateFunction.inc) with SESSION['DefaultDateFormat'] = 'd/m/Y' this function had been broken  </p>
+<p>06/05/10 Keith: session.inc : Correct SQL error on Currency updater</p>
 <p>06/05/10 Lindsay: Tracker 2929564: dates mangled via QuicK Entry format</p>
 <p>06/05/10 Matt Taylor: upgrade3.11.1-3.12.sql : Added default startdate to prices table.</p>
 <p>06/05/10 Matt Taylor: weberp-demo.sql : Added startdate and enddate columns to prices table.</p>

Modified: trunk/includes/session.inc
===================================================================
--- trunk/includes/session.inc	2010-05-24 17:48:19 UTC (rev 3466)
+++ trunk/includes/session.inc	2010-05-24 18:11:14 UTC (rev 3467)
@@ -139,7 +139,9 @@
 				while ($CurrencyRow = DB_fetch_row($CurrenciesResult)){
 					if ($CurrencyRow[0]!=$_SESSION['CompanyRecord']['currencydefault']){
 						
-						$UpdateCurrRateResult = DB_query('UPDATE currencies SET rate=' . GetCurrencyRate ($CurrencyRow[0],$CurrencyRates) . " WHERE currabrev='" . $CurrencyRow[0] . "'",$db);
+						$UpdateCurrRateResult = DB_query('UPDATE currencies SET 
+							rate=' . GetCurrencyRate ($CurrencyRow[0],$CurrencyRates) . " '
+							WHERE currabrev='" . $CurrencyRow[0] . "'",$db);
 					}
 				}
 				$_SESSION['UpdateCurrencyRatesDaily'] = Date('Y-m-d');
@@ -265,4 +267,4 @@
     		return $Password;
     	}
  }
-?>
\ No newline at end of file
+?>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.