[phpBT-dev] CVS: phpbt/admin resolution.php,1.18,1.19 severity.php,1.14,1.15 status.php,1.18,1.19

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

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

Modified Files:
	resolution.php severity.php status.php 
Log Message:
dumb queries

Index: resolution.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/resolution.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- resolution.php	2001/11/22 05:14:33	1.18
+++ resolution.php	2001/12/19 14:05:14	1.19
@@ -90,8 +90,7 @@
 	
 	$page = isset($_gv['page']) ? $_gv['page'] : 0;
 	
-  $nr = $q->query("select count(*) from ".TBL_RESOLUTION.
-		" where resolution_id = '$resolutionid' order by $order $sort");
+  $nr = $q->query("select count(*) from ".TBL_RESOLUTION);
 
   list($selrange, $llimit, $npages, $pages) = multipages($nr,$page,
     "order=$order&sort=$sort");

Index: severity.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/severity.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- severity.php	2001/11/22 05:14:33	1.14
+++ severity.php	2001/12/19 14:05:15	1.15
@@ -93,8 +93,7 @@
 	
 	$page = isset($_gv['page']) ? $_gv['page'] : 0;
 	
-  $nr = $q->query("select count(*) from ".TBL_SEVERITY.
-		" where severity_id = '$severityid' order by $order $sort");
+  $nr = $q->query("select count(*) from ".TBL_SEVERITY);
 
   list($selrange, $llimit, $npages, $pages) = multipages($nr,$page,
     "order=$order&sort=$sort");

Index: status.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/status.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- status.php	2001/11/22 05:14:33	1.18
+++ status.php	2001/12/19 14:05:15	1.19
@@ -90,8 +90,7 @@
 	
 	$page = isset($_gv['page']) ? $_gv['page'] : 0;
 	
-  $nr = $q->query("select count(*) from ".TBL_STATUS.
-		" where status_id = '$statusid' order by $order $sort");
+  $nr = $q->query("select count(*) from ".TBL_STATUS);
 
   list($selrange, $llimit, $npages, $pages) = multipages($nr,$page,
     "order=$order&sort=$sort");