[phpBT-dev] CVS: phpbt/inc/db mssql.php,1.8,1.9 mysql.php,1.31,1.32 mysqli.php,1.5,1.6 oci8.php,1.24,1.25 pgsql.php,1.32,1.33

[Ulf E. <ulf...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1698/inc/db

Modified Files:
	mssql.php mysql.php mysqli.php oci8.php pgsql.php 
Log Message:
Adding a role-based permission system


Index: mssql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mssql.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- mssql.php	18 Oct 2005 18:45:10 -0000	1.8
+++ mssql.php	31 Oct 2005 21:34:35 -0000	1.9
@@ -47,6 +47,8 @@
 			TBL_AUTH_GROUP.' ag '.
 			'left join '.TBL_USER_GROUP.' ug on ug.group_id = ag.group_id '.
 			'left join '.TBL_AUTH_USER.' au on ug.user_id = au.user_id '.
+		'where '.
+			' %s '.
 		'group by '.
 			'ag.group_id, '.
 			'group_name, '.

Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- mysql.php	18 Oct 2005 18:45:10 -0000	1.31
+++ mysql.php	31 Oct 2005 21:34:35 -0000	1.32
@@ -47,6 +47,8 @@
 			TBL_AUTH_GROUP.' ag '.
 			'left join '.TBL_USER_GROUP.' ug using (group_id) '.
 			'left join '.TBL_AUTH_USER.' using (user_id) '.
+		'where '.
+			' %s '.
 		'group by '.
 			'ag.group_id, '.
 			'group_name, '.

Index: mysqli.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysqli.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- mysqli.php	18 Oct 2005 18:45:10 -0000	1.5
+++ mysqli.php	31 Oct 2005 21:34:35 -0000	1.6
@@ -47,6 +47,8 @@
 			TBL_AUTH_GROUP.' ag '.
 			'left join '.TBL_USER_GROUP.' ug using (group_id) '.
 			'left join '.TBL_AUTH_USER.' using (user_id) '.
+		'where '.
+			' %s '.
 		'group by '.
 			'ag.group_id, '.
 			'group_name, '.

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -r1.24 -r1.25
--- oci8.php	18 Oct 2005 18:45:10 -0000	1.24
+++ oci8.php	31 Oct 2005 21:34:35 -0000	1.25
@@ -53,6 +53,7 @@
 		'where '.
 			'ag.group_id = ug.group_id(+) '.
 			'and ug.user_id = au.user_id(+) '.
+			'and %s '.
 		'group by '.
 			'ag.group_id, '.
 			'ag.group_name, '.

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.32
retrieving revision 1.33
diff -u -r1.32 -r1.33
--- pgsql.php	18 Oct 2005 18:45:10 -0000	1.32
+++ pgsql.php	31 Oct 2005 21:34:35 -0000	1.33
@@ -47,6 +47,8 @@
 			TBL_AUTH_GROUP.' ag '.
 			'left join '.TBL_USER_GROUP.' ug using (group_id) '.
 			'left join '.TBL_AUTH_USER.' using (user_id) '.
+		'where '.
+			' %s '.
 		'group by '.
 			'ag.group_id, '.
 			'group_name, '.