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

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

Revision: 3826
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3826&view=rev
Author:   tim_schofield
Date:     2010-09-28 19:24:12 +0000 (Tue, 28 Sep 2010)

Log Message:
-----------
SQL quoting corrections and layout changes and improvements

Modified Paths:
--------------
    trunk/UserSettings.php
    trunk/doc/Change.log.html

Modified: trunk/UserSettings.php
===================================================================
--- trunk/UserSettings.php	2010-09-28 19:13:27 UTC (rev 3825)
+++ trunk/UserSettings.php	2010-09-28 19:24:12 UTC (rev 3826)
@@ -8,7 +8,8 @@
 $title = _('User Settings');
 include('includes/header.inc');
 
-echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/user.png" title="' . _('User Settings') . '" alt="">' . ' ' . _('User Settings');
+echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/user.png" title="' .
+	_('User Settings') . '" alt="">' . ' ' . _('User Settings') . '</p>';
 
 $PDFLanguages = array(_('Latin Western Languages'),
 						_('Eastern European Russian Japanese'),
@@ -62,11 +63,11 @@
 		// no errors
 		if ($update_pw != 'Y'){
 			$sql = "UPDATE www_users
-				SET displayrecordsmax=" . $_POST['DisplayRecordsMax'] . ",
+				SET displayrecordsmax='" . $_POST['DisplayRecordsMax'] . "',
 					theme='" . $_POST['Theme'] . "',
 					language='" . $_POST['Language'] . "',
 					email='". $_POST['email'] ."',
-					pdflanguage=" . $_POST['PDFLanguage'] . "
+					pdflanguage='" . $_POST['PDFLanguage'] . "'
 				WHERE userid = '" . $_SESSION['UserID'] . "'";
 
 			$ErrMsg =  _('The user alterations could not be processed because');
@@ -77,11 +78,11 @@
 			prnMsg( _('The user settings have been updated') . '. ' . _('Be sure to remember your password for the next time you login'),'success');
 		} else {
 			$sql = "UPDATE www_users
-				SET displayrecordsmax=" . $_POST['DisplayRecordsMax'] . ",
+				SET displayrecordsmax='" . $_POST['DisplayRecordsMax'] . "',
 					theme='" . $_POST['Theme'] . "',
 					language='" . $_POST['Language'] . "',
 					email='". $_POST['email'] ."',
-					pdflanguage=" . $_POST['PDFLanguage'] . ",
+					pdflanguage='" . $_POST['PDFLanguage'] . "',
 					password='" . CryptPass($_POST['pass']) . "'
 				WHERE userid = '" . $_SESSION['UserID'] . "'";
 
@@ -111,7 +112,7 @@
 
 }
 
-echo '<table><tr><td>' . _('User ID') . ':</td><td>';
+echo '<table class=selection><tr><td>' . _('User ID') . ':</td><td>';
 echo $_SESSION['UserID'] . '</td></tr>';
 
 echo '<tr><td>' . _('User Name') . ':</td><td>';
@@ -205,7 +206,7 @@
 	}
 }
 echo "</select></td></tr></table>
-	<br><div class='centre'><input type='Submit' name='Modify' value=" . _('Modify') . '></div>
+	<br /><div class='centre'><input type='Submit' name='Modify' value=" . _('Modify') . '></div>
 	</form>';
 
 include('includes/footer.inc');

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-28 19:13:27 UTC (rev 3825)
+++ trunk/doc/Change.log.html	2010-09-28 19:24:12 UTC (rev 3826)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>28/09/10 Tim: UserSettings.php - SQL quoting corrections and layout changes and improvements</p>
 <p>28/09/10 Tim: UnitsOfMeasure.php - SQL quoting corrections and layout changes and improvements</p>
 <p>28/09/10 Tim: TopItems.php - SQL quoting corrections and layout changes and improvements</p>
 <p>28/09/10 Tim: TaxProvinces.php - SQL quoting corrections and layout changes and improvements</p>


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