Stupid constraint, can't cheat anymore, need to filter out here.

diff --git a/src/LinuxTag/2003/projects/accounts.wml b/src/LinuxTag/2003/projects/accounts.wml
index c9dd5d2..d6be3d1 100644 (file)
--- a/src/LinuxTag/2003/projects/accounts.wml
+++ b/src/LinuxTag/2003/projects/accounts.wml
@@ -13,7 +13,7 @@
   $query = "SELECT person.project,person.name,person.email,person.admin "
           ."FROM project,person "
           ."WHERE project.name = person.project AND list = 0 AND login = 1 AND email <> ''"
-          ."ORDER BY project,name";
+          ."AND project.name <> 'Supporter' ORDER BY project,name";
   $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
 
   if (pg_NumRows ($sth) > 0) {

diff --git a/src/LinuxTag/2003/projects/index.wml b/src/LinuxTag/2003/projects/index.wml
index 8b01265..b22b427 100644 (file)
--- a/src/LinuxTag/2003/projects/index.wml
+++ b/src/LinuxTag/2003/projects/index.wml
@@ -51,7 +51,7 @@
 
   # pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
 
-  $query = "SELECT name,oid,boothsize,computer FROM project ORDER BY name";
+  $query = "SELECT name,oid,boothsize,computer FROM project WHERE name <> 'Supporter' ORDER BY name";
   $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
 
   if (pg_NumRows ($sth) > 0) {

diff --git a/src/LinuxTag/2003/projects/infomail_recipient.wml b/src/LinuxTag/2003/projects/infomail_recipient.wml
index 5e30f51..39122cc 100644 (file)
--- a/src/LinuxTag/2003/projects/infomail_recipient.wml
+++ b/src/LinuxTag/2003/projects/infomail_recipient.wml
@@ -13,7 +13,7 @@
   $query = "SELECT person.project,person.name,person.email,person.list,person.infomail "
           ."FROM project,person "
           ."WHERE project.name = person.project AND ( infomail = 1 OR list = 1) AND email <> ''"
-          ."ORDER BY project,name";
+          ."AND project.name <> 'Supporter' ORDER BY project,name";
   $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
 
   if (pg_NumRows ($sth) > 0) {

diff --git a/src/LinuxTag/2003/projects/infomail_send.wml b/src/LinuxTag/2003/projects/infomail_send.wml
index a018691..dfce650 100644 (file)
--- a/src/LinuxTag/2003/projects/infomail_send.wml
+++ b/src/LinuxTag/2003/projects/infomail_send.wml
@@ -45,7 +45,7 @@
 
     # pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
 
-    $query = "SELECT name FROM project ORDER by name";
+    $query = "SELECT name FROM project WHERE name <> 'Supporter' ORDER by name";
     $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
 
     if (pg_NumRows ($sth) > 0) {