Re: Getting ftp-master mails as sponsor
On Tue, May 08, 2007 at 01:18:11AM +0200, Joerg Jaspert wrote:
> On 11013 March 1977, Roberto C. Sánchez wrote:
> >> This would need a new field defined in some sane way and then get
> >> enforced to use to make sense. And then the scripts can start using it.
> >> So the simple(r) option is "subscribe to pts".
> > Doesn't the key used to sign the upload tell you?
> Yes, then I know the key. What do I do with keys like the following
> (which are fine and valid and stuff) where the primary UID is without a
> gpg --list-keys 94c09c7f
> pub 1024D/94C09C7F 1999-11-10
> uid Peter Palfrader
> uid Weasel <email@example.com>
> uid Peter Palfrader <firstname.lastname@example.org>
> uid Peter Palfrader <email@example.com>
> uid Peter Palfrader <firstname.lastname@example.org>
> uid [jpeg image of size 7974]
> sub 1024D/AFA44BDD 2003-07-09 [expires: 2008-08-02]
> sub 2048g/E8F4A328 2003-07-09 [expires: 2008-08-02]
> Pick a random uid? Send no mail? Send mail to all?
> And no, simply "pick @debian.org" doesnt work, people may have chosen to
> deactivate that address because they use something different for all
> their debian activity now.
FROM fingerprint f LEFT JOIN uid u ON f.uid=u.id
LEFT JOIN source s ON f.id=s.sig_fpr
LEFT JOIN maintainer m ON s.maintainer=m.id
WHERE f.fingerprint='$yourvarhere' AND m.name LIKE '%' || u.uid || '%'
ORDER BY install_date DESC LIMIT 1;
Steve Langasek Give me a lever long enough and a Free OS
Debian Developer to set it on, and I can move the world.