[arch-dev-public] Website updated- package maintainer changes

[Daniel J Griffiths (Ghost1227)]

On 03/30/10 at 12:15am, K. Piche wrote:
> On Mon, 2010-03-29 at 20:00 -0500, Dan McGee wrote:
> > On Mon, Mar 29, 2010 at 2:06 AM, Pierre Schmitz <pierre at archlinux.de> wrote:
> > > Am Montag, 29. März 2010 00:01:03 schrieb Dan McGee:
> > >> Let me (and the list) know if you have any questions.
> > >
> > > Thanks for your work! Just one suggestion: Would it be possible to chagne the
> > > pacakge list view on the dev site to just operate on pkgbase and ignore the
> > > different pkgnames and architectures? This would managing package assignments
> > > and orphans a lot easier.
> > 
> > Agreed, I'll keep that in mind as I work on the website in the coming
> > weeks. Until then, here is that magic list.
> > 
> > mysql> select count(*), r.name, p.pkgbase, username from packages p
> > left join repos r on p.repo_id = r.id left join
> > packages_packagerelation pr on p.pkgbase = pr.pkgbase left join
> > auth_user u on pr.user_id = u.id where username is NULL and p.repo_id
> > in (1,2) group by r.name, p.pkgbase, username order by r.name,
> > p.pkgbase, count(*);
> > +----------+-------+------------------------------------+----------+
> > | count(*) | name  | pkgbase                            | username |
> > +----------+-------+------------------------------------+----------+
> 
> > |        2 | Extra | gift                               | NULL     |
> > |        2 | Extra | gift-fasttrack                     | NULL     |
> > |        2 | Extra | gift-gnutella                      | NULL     |
> > |        2 | Extra | gift-openft                        | NULL     |
> 
> I think we can safely throw these out along with bmp/bmpx if there are
> no objections.
> 
> > +----------+-------+------------------------------------+----------+
> > 478 rows in set (0.23 sec)
> 
> -- 
> K. Piche <kpiche at rogers.com>
> 
No objections here
--