[phpBT-dev] CVS: phpbt index.php,1.9,1.10

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

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

Modified Files:
	index.php 
Log Message:
DB conversion

Index: index.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/index.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- index.php	2001/08/09 12:54:47	1.9
+++ index.php	2001/08/17 01:25:48	1.10
@@ -34,20 +34,20 @@
 if (USE_JPGRAPH) {
 	$t->set_var('sblock', '<img src="images.php" align="right">');
 } else {
-	$q->query("select * from Status order by SortOrder");
+	$q->query("select * from status order by sort_order");
 	while ($row = $q->grab()) {
-		$stats[$row['StatusID']]['Name'] = $row['Name'];
+		$stats[$row['status_id']]['name'] = $row['status_name'];
 	}
-	$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'];
 	}
 	foreach ($stats as $stat) {
 		$t->set_var(array(
-			'status' => $stat['Name'],
-			'count' => $stat['Count'] ? $stat['Count'] : 0
+			'status' => $stat['name'],
+			'count' => $stat['count'] ? $stat['count'] : 0
 			));
-		$total += $stat['Count'];
+		$total += $stat['count'];
 		$t->parse('rows','row',true);
 	}
 	$t->set_var(array(