Resend [AppDB] show total number of maintainers and applications in the appMaintainers table

[Tony Lambregts]

There was a bug in last one, use this instead.

Change Log:  Show the total number of maintainers and applications in the
appMaintainers table in the admin menu

Files Changed: include/sidebar_admin.php include/util.php


Index: include/sidebar_admin.php
===================================================================
RCS file: /home/wine/appdb/include/sidebar_admin.php,v
retrieving revision 1.4
diff -u -r1.4 sidebar_admin.php
--- include/sidebar_admin.php    10 Nov 2004 16:36:25 -0000    1.4
+++ include/sidebar_admin.php    21 Nov 2004 07:50:43 -0000
@@ -19,7 +19,7 @@
      $g->add("List Users", $apidb_root."admin/");
      $g->add("View App Queue (".getQueuedAppCount().")", $apidb_root."admin/adminAppQueue.php");
      $g->add("View Maintainer Queue (".getQueuedMaintainerCount().")", $apidb_root."admin/adminMaintainerQueue.php");
-    $g->add("View Maintainers", $apidb_root."admin/adminMaintainers.php");
+    $g->add("View Maintainers (".getMaintainerCount().")", $apidb_root."admin/adminMaintainers.php");
      $g->done();

  }
Index: include/util.php
===================================================================
RCS file: /home/wine/appdb/include/util.php,v
retrieving revision 1.4
diff -u -r1.4 util.php
--- include/util.php    9 Nov 2004 22:51:38 -0000    1.4
+++ include/util.php    21 Nov 2004 07:50:43 -0000
@@ -189,4 +189,13 @@
      return $ob->queued_maintainers;
  }

+/* get the total number of maintainers and applications in the appMaintainers table */
+function getMaintainerCount()
+{
+    $qstring = "SELECT count(*) as maintainers FROM appMaintainers";
+    $result = mysql_query($qstring);
+    $ob = mysql_fetch_object($result);
+    return $ob->maintainers;
+}
+
  ?>