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, '.
|
