[AppDB] Show the number of maintainers on the administrators menu
tony_lambregts at telusplanet.net
tony_lambregts at telusplanet.net
Tue Dec 7 20:37:16 CST 2004
Change Log: Show the number of maintainers on the administrators 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.5
diff -u -r1.5 sidebar_admin.php
--- include/sidebar_admin.php 1 Dec 2004 22:27:35 -0000 1.5
+++ include/sidebar_admin.php 8 Dec 2004 03:26:01 -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->addmisc(" ");
$g->add("Comment manager", $apidb_root."admin/adminCommentView.php");
Index: include/util.php
===================================================================
RCS file: /home/wine/appdb/include/util.php,v
retrieving revision 1.5
diff -u -r1.5 util.php
--- include/util.php 1 Dec 2004 22:26:50 -0000 1.5
+++ include/util.php 8 Dec 2004 03:26:01 -0000
@@ -189,7 +189,16 @@
return $ob->queued_maintainers;
}
-/* Get the number of users in the database */
+/* 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;
+}
+
+/* Get the number of comments in the database */
function getNumberOfComments()
{
$result = mysql_query("SELECT count(*) as num_comments FROM appComments;");
More information about the wine-patches
mailing list