Added support for people who are supporters not primarily

diff --git a/src/LinuxTag/2003/supporter/availability.wml b/src/LinuxTag/2003/supporter/availability.wml
index 44c3de5..a8a21d1 100644 (file)
--- a/src/LinuxTag/2003/supporter/availability.wml
+++ b/src/LinuxTag/2003/supporter/availability.wml
@@ -49,7 +49,10 @@
   $person = array ();
 
   if ($limitation != 1) {
-    $query = "SELECT oid,name FROM person WHERE project = 'Supporter' ORDER BY upper(name)";
+    $query = "SELECT person.oid,name FROM person,junction "
+           ."WHERE junction.person = person.name AND junction.project='Supporter' "
+           ."ORDER BY upper(name)";
+
     $sth = pg_exec ($dbh, $query) or die ("Datenbank-Abfrage!");
 
     for ($nr = 0; $nr < pg_NumRows($sth); $nr++)