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

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

Revision: 4968
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4968&view=rev
Author:   daintree
Date:     2012-02-25 01:49:00 +0000 (Sat, 25 Feb 2012)
Log Message:
-----------
added module to www-users

Modified Paths:
--------------
    trunk/includes/ConnectDB.inc
    trunk/sql/mysql/upgrade4.07-4.08.sql

Modified: trunk/includes/ConnectDB.inc
===================================================================
--- trunk/includes/ConnectDB.inc	2012-02-24 10:35:15 UTC (rev 4967)
+++ trunk/includes/ConnectDB.inc	2012-02-25 01:49:00 UTC (rev 4968)
@@ -4,7 +4,7 @@
  * this value is saved in the $_SESSION['Versionumber'] when includes/GetConfig.php is run
  * if  VersionNumber is < $Version  then the DB update script is run */
 
-$Version='4.08.1'; //must update manually every time there is a DB change
+$Version='4.08'; //must update manually every time there is a DB change
 
 require_once ($PathPrefix .'includes/MiscFunctions.php');
 

Modified: trunk/sql/mysql/upgrade4.07-4.08.sql
===================================================================
--- trunk/sql/mysql/upgrade4.07-4.08.sql	2012-02-24 10:35:15 UTC (rev 4967)
+++ trunk/sql/mysql/upgrade4.07-4.08.sql	2012-02-25 01:49:00 UTC (rev 4968)
@@ -4,6 +4,7 @@
 INSERT INTO `scripts` (`script` ,`pagesecurity` ,`description`) VALUES ('reportwriter/admin/ReportCreator.php', '15', 'Report Writer');
 INSERT INTO `scripts` (`script` ,`pagesecurity` ,`description`) VALUES ('RecurringSalesOrdersProcess.php', '1', 'Process Recurring Sales Orders');
 
-UPDATE `scripts` SET `script`='CopyBOM.php' WHERE `script`='Z_CopyBOM.php';
+DELETE `scripts` WHERE `script`='Z_CopyBOM.php';
 
-UPDATE config SET confvalue='4.08.1' WHERE confname='VersionNumber';
\ No newline at end of file
+UPDATE `www_users` SET `modulesallowed` = CONCAT(`modulesallowed`,'0,'); 
+UPDATE config SET confvalue='4.08' WHERE confname='VersionNumber';
\ No newline at end of file

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