[phpBT-dev] CVS: phpbt report.php,1.11,1.12

[Benjamin C. <bc...@us...>]

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

Modified Files:
	report.php 
Log Message:
Tighten this up a bit

Index: report.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/report.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- report.php	2001/08/12 23:04:51	1.11
+++ report.php	2001/08/14 13:19:39	1.12
@@ -43,6 +43,8 @@
 	
 	if ($projectid && is_numeric($projectid)) {
 		$projectquery = "where Project = $projectid";
+	} else {
+		$projectquery = '';
 	}
 	
 	$q->query("$querystring, count(BugID) as Total from Bug b left join User u on AssignedTo = UserID $projectquery group by AssignedTo");
@@ -57,9 +59,10 @@
 		$t->set_var('bgcolor', '#eeeeee');
 		$t->parse('rows', 'row', true);
 		$t->set_var('cols', '');
+		$i = 0;
 		while ($row = $q->grab()) {
 			foreach ($resfields as $col) {
-				if ($row[$col] == '') {
+				if (!isset($row[$col]) || $row[$col] == '') {
 					$coldata = 'Unassigned';
 				} elseif ($col == 'Assigned To') {
 					$coldata = maskemail($row[$col]);
@@ -79,6 +82,7 @@
 	}
 }
 
+$projectid = isset($_gv['projectid']) ? $_gv['projectid'] : 0;
 $t->set_file('wrap','wrap.html');
 $t->set_file('content','report.html');
 $t->set_var(array(