Re: Resend [AppDB] show total number of maintainers and applications in the appMaintainers table
This patch fails to apply to the tip. Update and resend. On Sun, 2004-11-21 at 09:50 -0700, Tony Lambregts wrote:
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; +} + ?>
participants (1)
-
Jeremy Newman