[Web-erp-svn] SF.net SVN: web-erp:[6952] trunk/WWW_Users.php

[<te...@us...>]

Revision: 6952
          http://sourceforge.net/p/web-erp/reponame/6952
Author:   tehonu
Date:     2014-10-29 15:15:29 +0000 (Wed, 29 Oct 2014)
Log Message:
-----------
When deleting a user, delete also the locationusers related records to avoid orfaned info

Modified Paths:
--------------
    trunk/WWW_Users.php

Modified: trunk/WWW_Users.php
===================================================================
--- trunk/WWW_Users.php	2014-10-29 06:29:22 UTC (rev 6951)
+++ trunk/WWW_Users.php	2014-10-29 15:15:29 UTC (rev 6952)
@@ -258,6 +258,9 @@
 		if (DB_num_rows($result)!=0) {
 			prnMsg(_('Cannot delete user as entries already exist in the audit trail'), 'warn');
 		} else {
+			$sql="DELETE FROM locationusers WHERE userid='" . $SelectedUser . "'";
+			$ErrMsg = _('The Location - User could not be deleted because');;
+			$result = DB_query($sql,$ErrMsg);
 
 			$sql="DELETE FROM www_users WHERE userid='" . $SelectedUser . "'";
 			$ErrMsg = _('The User could not be deleted because');;