[phpBT-dev] CVS: phpbt/inc functions.php,1.28,1.29

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

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

Modified Files:
	functions.php 
Log Message:
Modified build_select to handle database tracking.


Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.28
retrieving revision 1.29
diff -u -r1.28 -r1.29
--- functions.php	19 May 2002 12:24:42 -0000	1.28
+++ functions.php	21 May 2002 11:20:17 -0000	1.29
@@ -58,17 +58,19 @@
     'status' => TBL_STATUS,
     'resolution' => TBL_RESOLUTION,
     'severity' => TBL_SEVERITY,
-    'version' => TBL_VERSION
+    'version' => TBL_VERSION,
+    'database' => TBL_DATABASE,
   );
 
   $text = '';
   if (isset($cfgDatabase[$box])) {
     $querystart = "select {$box}_id, {$box}_name from $cfgDatabase[$box]";
+    $querymid = ' where sort_order > 0 order by sort_order';
     $queries = array(
       'group' => $querystart.' where group_name <> \'User\' order by group_name',
-      'severity' => $querystart.' where sort_order > 0 order by sort_order',
-      'status' => $querystart.' where sort_order > 0 order by sort_order',
-      'resolution' => $querystart.' where sort_order > 0 order by sort_order',
+      'severity' => $querystart.$querymid,
+      'status' => $querystart.$querymid,
+      'resolution' => $querystart.$querymid,
       'project' => $perm->have_perm('Admin')
         ? $querystart." where ".
 					($selected ? "(active > 0 or project_id in ($selected))" : 'active > 0').
@@ -78,7 +80,8 @@
 					($selected ? " (active > 0 or project_id in ($selected))" : 'active > 0').
 					" order by {$box}_name",
       'component' => $querystart." where project_id = $project and active = 1 order by {$box}_name",
-      'version' => $querystart." where project_id = $project and active = 1 order by {$box}_id desc"
+      'version' => $querystart." where project_id = $project and active = 1 order by {$box}_id desc",
+      'database' => "select {$box}_id, {$box}_name, {$box}_version from $cfgDatabase[$box]".$querymid
       );
   }
 
@@ -120,6 +123,15 @@
           $row[$box.'_id']."\"$sel>".$row[$box.'_name'].'</option>';
       }
       break;
+    case 'database' :
+	$rs = $db->query($queries[$box]);
+	while ($rs->fetchInto($row)) {
+        if ($selected == $row[$box.'_id'] and $selected != '') $sel = ' selected';
+        else $sel = '';
+        $text .= '<option value="'.
+          $row[$box.'_id'].'"'.$sel.'>'.$row[$box.'_name'].' '.$row[$box.'_version'].'</option>';
+	}
+	break;
     case 'os' :
       $rs = $db->query("select {$box}_id, {$box}_name, regex from ".TBL_OS." where sort_order > 0 order by sort_order");
       while ($rs->fetchInto($row)) {