Added information about the social event

diff --git a/src/LinuxTag/2002/projects/show.wml b/src/LinuxTag/2002/projects/show.wml
index 737a947..dc23ab6 100644 (file)
--- a/src/LinuxTag/2002/projects/show.wml
+++ b/src/LinuxTag/2002/projects/show.wml
@@ -54,6 +54,19 @@
     }
   }
 
+  function socialevent ($project)
+  {
+    global $dbh;
+
+    $query = sprintf ("SELECT COUNT(*) FROM person WHERE project = '%s' AND list = 0 AND socialevent = 1", $project);
+    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+    if (pg_NumRows ($sth) > 0) {
+      $row = pg_fetch_array ($sth, 0);
+      return $row[0];
+    }
+  }
+
   $dbh = pg_pconnect ("<dbconnstring>")
               or die("Unable to connect to SQL server");
 
@@ -84,7 +97,13 @@
     if ($night > 0) {
       printf ("<strong>Night</strong>: %d<br>", $night);
     }
-    $query = sprintf ("SELECT name,email,list,oid FROM person WHERE project = '%s' ORDER BY name", $project);
+
+    $se = socialevent ($project);
+    if ($se > 0) {
+      printf ("<strong>Social Event Tickets</strong>: %d<br>", $se);
+    }
+
+    $query = sprintf ("SELECT name,email,list,socialevent,oid FROM person WHERE project = '%s' ORDER BY name", $project);
     $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
 
     if (pg_NumRows ($sth) > 0) {
@@ -98,9 +117,13 @@
            printf ("&nbsp;&nbsp;(<a href=\"edit_person.php3?oid=%d\">%s</a>)<br>", $row['oid'], $row['email']);
          }
        } elseif ($row['email']) {
-         printf ("&nbsp;&nbsp;<a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt;<br>", $row['oid'], $row['name'], $row['email']);
+         printf ("&nbsp;&nbsp;<a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt;%s<br>",
+                 $row['oid'], $row['name'], $row['email'],
+                 $row['socialevent'] == 1?" [S]":"");
        } else {
-         printf ("&nbsp;&nbsp;<a href=\"edit_person.php3?oid=%d\">%s</a><br>", $row['oid'], $row['name']);
+         printf ("&nbsp;&nbsp;<a href=\"edit_person.php3?oid=%d\">%s</a>%s<br>",
+                 $row['oid'], $row['name'],
+                 $row['socialevent'] == 1?" [S]":"");
        }
       }
     }