X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=config%2Fdebian%2Fcontributor.source;h=e364ccd5542e519ed21882fb79ec0568c5505a10;hb=7461bfcbebaba6b6734c5b568e49f256bd0bb41c;hp=2d9ce6d4ca9efcddc9c20453bba42de2778f6432;hpb=dd372146adf36fbb72f4065747f00fba210448b6;p=dak.git

diff --git a/config/debian/contributor.source b/config/debian/contributor.source
index 2d9ce6d4..e364ccd5 100644
--- a/config/debian/contributor.source
+++ b/config/debian/contributor.source
@@ -2,21 +2,27 @@ contribution: upload
 method: postgres
 db: service=projectb
 query:
-        SELECT s.install_date as date,
-               u.uid as id,
-               u.name as desc
-          FROM source s
-          JOIN fingerprint f ON s.sig_fpr = f.id
-          JOIN uid u ON f.uid = u.id
-url: http://qa.debian.org/developer.php?login={id}&comaint=yes
+        SELECT fingerprint AS id,
+               SUBSTRING(fingerprint FROM 40-7) AS key_id,
+               seen AS date
+          FROM changes
+         WHERE architecture LIKE '%source%'
+         ORDER BY seen DESC
+url: https://qa.debian.org/developer.php?login={key_id}&comaint=yes
 
 contribution: maint
 method: postgres
 db: service=projectb
 query:
-        SELECT s.install_date as date,
-               c.name as id
-          FROM source s
-          JOIN maintainer c ON s.changedby = c.id
-url: http://qa.debian.org/developer.php?login={id}&comaint=yes
+        SELECT changedby AS id,
+               seen AS date
+          FROM changes
+         WHERE architecture LIKE '%source%'
+url: https://qa.debian.org/developer.php?login={id}&comaint=yes
 
+contribution: patch_contributor
+method: gitlogs
+dirs:
+   /srv/ftp.debian.org/git/dak.git
+   /srv/ftp.debian.org/git/dakbot.git
+   /srv/ftp.debian.org/git/website.git