[phpBT-dev] CVS: phpbt images.php,1.4,1.5

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

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

Modified Files:
	images.php 
Log Message:
DB conversion

Index: images.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/images.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- images.php	2001/08/09 12:54:47	1.4
+++ images.php	2001/08/17 01:34:55	1.5
@@ -31,22 +31,22 @@
 	include_once JPGRAPH_PATH.'jpgraph_pie.php';
 	
 	// Grab the legend
-	$q->query("select StatusID, Name from Status order by SortOrder");
+	$q->query("select status_id, status_name from status order by sort_order");
 	while ($row = $q->grab()) {
-		$stats[$row['StatusID']]['Name'] = $row['Name'];
+		$stats[$row['status_id']]['name'] = $row['status_name'];
 	}
 	
 	// Grab the data
-	$q->query("select Status, count(Status) as Count from Bug group by Status");
+	$q->query("select status_id, count(status_id) as count from bug group by status_id");
 	while ($row = $q->grab()) {
-		$stats[$row['Status']]['Count'] = $row['Count'];
+		$stats[$row['status_id']]['count'] = $row['count'];
 	}
 	$totalbugs = 0;
 	foreach ($stats as $stat) {
-		if ($stat['Count']) {
-			$data[] = $stat['Count'];
-			$legend[] = "{$stat['Name']} ({$stat['Count']})";
-			$totalbugs += $stat['Count'];
+		if ($stat['count']) {
+			$data[] = $stat['count'];
+			$legend[] = "{$stat['name']} ({$stat['count']})";
+			$totalbugs += $stat['count'];
 		}
 	}