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

[Jeremy Newman]

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;
> +}
> +
>   ?>