[phpBT-dev] CVS: phpbt query.php,1.79,1.80

[Jirka P. <fi...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv22200/phpbt

Modified Files:
	query.php 
Log Message:
Updated for DB and SITE TRACKING in advanced query.


Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.79
retrieving revision 1.80
diff -u -r1.79 -r1.80
--- query.php	13 Jun 2002 14:26:34 -0000	1.79
+++ query.php	13 Jun 2002 15:07:10 -0000	1.80
@@ -75,18 +75,30 @@
 		$flags = array();
 		// Need to check $array[0] for Opera -- 
 		// it passes non-empty arrays for every multi-choice select box
-		if (!empty($status) and $status[0])
+		if (!empty($status) and $status[0]) {
 			$flags[] = 'b.status_id in ('.delimit_list(',',$status).')';
-		if (!empty($resolution) and $resolution[0]) 
+		}
+		if (!empty($resolution) and $resolution[0]) {
 			$flags[] = 'b.resolution_id in ('.delimit_list(',',$resolution).')';
-		if (!empty($os) and $os[0]) 
+		}
+		if (!empty($os) and $os[0]) {
 			$flags[] = 'b.os_id in ('.delimit_list(',',$os).')';
-		if (!empty($priority) and $priority[0]) 
+		}
+		if (!empty($priority) and $priority[0]) {
 			$flags[] = 'b.priority in ('.delimit_list(',',$priority).')';
-		if (!empty($severity) and $severity[0]) 
+		}
+		if (!empty($severity) and $severity[0]) {
 			$flags[] = 'b.severity_id in ('.delimit_list(',',$severity).')';
-		if (!empty($flags)) 
+		}
+		if (!empty($database) and $database[0]) {
+			$flags[] = 'b.database_id in ('.delimit_list(',',$database).')';
+		}
+		if (!empty($site) and $site[0]) {
+			$flags[] = 'b.site_id in ('.delimit_list(',',$site).')';
+		}
+		if (!empty($flags)) {
 			$query[] = '('.delimit_list(' or ',$flags).')';
+		}
 
 		// Email field(s)
 		if (!empty($email1)) {