projects / infodrom.org / service.infodrom.org / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 0aa1127)
Aktuelle version
authorJoey Schulze <joey@infodrom.org>
Fri, 22 Sep 2000 19:04:06 +0000 (19:04 +0000)
committerJoey Schulze <joey@infodrom.org>
Fri, 22 Sep 2000 19:04:06 +0000 (19:04 +0000)
src/LTOL/2000/exhibition/edit.wml patch | blob | history
src/LTOL/2000/exhibition/index.wml patch | blob | history
src/LTOL/2000/exhibition/list.wml [new file with mode: 0644] patch | blob
src/LTOL/2000/exhibition/update.wml patch | blob | history
src/LTOL/2000/lists.wml patch | blob | history
src/LTOL/2000/personal.wml patch | blob | history
src/LTOL/2000/presse.wml [new file with mode: 0644] patch | blob

diff --git a/src/LTOL/2000/exhibition/edit.wml b/src/LTOL/2000/exhibition/edit.wml
index 537c4f1..623061c 100644 (file)
--- a/src/LTOL/2000/exhibition/edit.wml
+++ b/src/LTOL/2000/exhibition/edit.wml
@@ -108,6 +108,7 @@
   </font></td>
 </tr>
 
+<field d="Namensschild" n="badgeorga"  s=40 m=40>
 <field d="Beschreibung" n="description"  s=40 m=100>
 <field d="Themen"      n="themes"       s=40 m=100>
 <field d="Ansprechpartner"     n="name"         s=40 m=100>
diff --git a/src/LTOL/2000/exhibition/index.wml b/src/LTOL/2000/exhibition/index.wml
index e2ee5cc..07e548a 100644 (file)
--- a/src/LTOL/2000/exhibition/index.wml
+++ b/src/LTOL/2000/exhibition/index.wml
@@ -45,6 +45,13 @@
     $sum += $row['boothsize'];
     $amount += $row['amount'];
     $computers += $row['nr_computers'];
+    if ($row['type'] == "Sponsor") {
+      $sum_comm++;
+    } else if ($row['type'] == "LUGO") {
+      $sum_lugo++;
+    } else if ($row['type'] == "Projekt") {
+      $sum_proj++;
+    }
   }
 ?>
 <tr><th align=left width=76% colspan=2><font face="Helvetica,Arial">Summe</font></th>
@@ -54,7 +61,11 @@
     </tr>
 </table><p>
 
-<center><a href="edit.php3">Neue Organisation aufnehmen</a></center>
+<? printf ("(Stände: %d kommerzielle, %d Projekte, %d LUGO<p>", $sum_comm-3, $sum_proj, $sum_lugo); ?>
+
+<a href="edit.php3">Neue Organisation aufnehmen</a><br>
+<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
+<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
 
 </PAGE>
 
diff --git a/src/LTOL/2000/exhibition/list.wml b/src/LTOL/2000/exhibition/list.wml
new file mode 100644 (file)
index 0000000..e3eba3e
--- /dev/null
+++ b/src/LTOL/2000/exhibition/list.wml
@@ -0,0 +1,109 @@
+#include "lt2k.style"
+
+<PAGE title="LinuxTag 2000 - Ausstellung">
+
+<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Ausstellung -</font></h3>
+
+#<table border=0 cellspacing=3 bgcolor="#f7ba2e">
+
+<define-tag cell>
+<td><font face="Helvetica,Arial">
+</define-tag>
+<define-tag /cell>
+</font></td>
+</define-tag>
+
+<h3><font face="Helvetica,Arial">Detailierte Aufschlüsselung</font></h3>
+
+<table border=1 cellspacing=1 cellpadding=3>
+<tr bgcolor="#c0e4f0">
+    <th align=left width=10%><font face="Helvetica,Arial">Stand</font></th>
+    <th align=left width=30%><font face="Helvetica,Arial">Organisation</font></th>
+    <th align=left width=10%><font face="Helvetica,Arial">Computer</font></th>
+    <th align=left width=10%><font face="Helvetica,Arial">Personal</font></th>
+    <th align=left width=10%><font face="Helvetica,Arial">Tische</font></th>
+    <th align=left width=10%><font face="Helvetica,Arial">Stühle</font></th>
+    <th align=left width=10%><font face="Helvetica,Arial">Wände</font></th>
+    <th align=left width=10%><font face="Helvetica,Arial">Platz</font></th>
+    </tr>
+
+<?
+  if ($sort == "name") {
+    $sort = "organization";
+  } else {
+    $sort = "boothnr,organization";
+  }
+
+  $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+              or die("Unable to connect to SQL server");
+
+  $query = "SELECT id,organization,boothnr,boothsize,nr_computers,nr_tables,nr_chairs,nr_walls,personal FROM exhibitor ORDER BY $sort";
+  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+  $sum['boothsize']=0;
+  $sum['nr_computers']=0;
+  $sum['nr_tables']=0;
+  $sum['nr_chairs']=0;
+  $sum['nr_walls']=0;
+  $sum['personal']=0;
+
+  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+    $row = pg_fetch_array ($sth, $nr);
+    $personal = 1;
+    if (strlen ($row['personal'])) {
+      $p = explode ("\n", $row['personal']);
+      $personal += count ($p);
+    }
+    if (!strlen ($row['boothnr'])) {
+      $row['boothnr'] = "&nbsp;";
+    }
+
+    printf ("<tr>
+    <td        align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></td>
+    <td        align=\"left\" width=\"30%%\"><font size=\"-1\" face=\"Helvetica,Arial\"><a href=\"edit.php3?id=%d\">%s</a></font></td>
+    <td        align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
+    <td        align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
+    <td        align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
+    <td        align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
+    <td        align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
+    <td        align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d qm</font></td>
+    </tr>", $row['boothnr'], $row['id'], $row['organization'], $row['nr_computers'], $personal, 
+           $row['nr_tables'], $row['nr_chairs'], $row['nr_walls'], 
+            $row['boothsize']);
+
+    $sum['boothsize'] += $row['boothsize'];
+    $sum['nr_computers'] += $row['nr_computers'];
+    $sum['nr_tables'] += $row['nr_tables'];
+    $sum['nr_chairs'] += $row['nr_chairs'];
+    $sum['nr_walls'] += $row['nr_walls'];
+    $sum['personal'] += $personal;
+  }
+
+  printf ("<tr>
+  <th align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">&nbsp;</font></th>
+  <th align=\"left\" width=\"30%%\"><font face=\"Helvetica,Arial\">Summe</font></th>
+  <th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
+  <th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
+  <th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
+  <th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
+  <th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
+  <th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d qm</font></th>
+  </tr>", $sum['nr_computers'], $sum['personal'], $sum['nr_tables'],
+          $sum['nr_chairs'], $sum['nr_walls'], $sum['boothsize']);
+
+?>
+</table><p>
+
+
+<a href="index.php3">Index</a><br>
+<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
+<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
diff --git a/src/LTOL/2000/exhibition/update.wml b/src/LTOL/2000/exhibition/update.wml
index 872bc46..c56ab84 100644 (file)
--- a/src/LTOL/2000/exhibition/update.wml
+++ b/src/LTOL/2000/exhibition/update.wml
@@ -25,7 +25,7 @@
         or die("Unable to connect to SQL server");
 
 <:
-    for $i (('organization','description','themes','name','address0','address1',
+    for $i (('organization','description','badgeorga','themes','name','address0','address1',
             'strasse','stadt','email','telefon','telefax','mobile','url','logo_url',
             'personal','boothnr','comment')) {
       printf "    \$%s=sql_prepare (\$%s);\n", $i, $i;
@@ -44,7 +44,7 @@
     } else {
       $query = "UPDATE exhibitor SET "
 <:
-    for $i (('organization','description','themes','name','address0','address1',
+    for $i (('organization','badgeorga','description','themes','name','address0','address1',
             'strasse','stadt','email','telefon','telefax','mobile','url','logo_url',
             'personal','boothnr','type','comment')) {
       printf "      . \"%s='\$%s',\"\n", $i, $i;
@@ -63,10 +63,10 @@
     $logo_width = sprintf ("%d", $logo_width);
 
     $query = "INSERT INTO exhibitor "
-      . "(id,organization,type,description,themes,name,address0,address1,strasse,stadt,email,telefon,telefax,mobile,url,logo_url,personal,boothnr,comment,plz,boothsize,nr_tables,nr_chairs,nr_computers,logo_width,logo_height,amount) VALUES ("
+      . "(id,organization,type,badgeorga,description,themes,name,address0,address1,strasse,stadt,email,telefon,telefax,mobile,url,logo_url,personal,boothnr,comment,plz,boothsize,nr_tables,nr_chairs,nr_computers,logo_width,logo_height,amount) VALUES ("
       . "$oldid[0]"
 <:
-    for $i (('organization','type','description','themes','name','address0','address1',
+    for $i (('organization','type','badgeorga','description','themes','name','address0','address1',
             'strasse','stadt','email','telefon','telefax','mobile','url','logo_url',
             'personal','boothnr','comment')) {
       printf "      . \",'\$%s'\"\n", $i;
@@ -101,6 +101,10 @@
 
 <h3><? echo $organization; ?> aufgenommen/aktualisiert</h3>
 
+<a href="edit.php3">Neue Organisation aufnehmen</a><br>
+<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
+<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
+
 </PAGE>
 
 # Local variables:
diff --git a/src/LTOL/2000/lists.wml b/src/LTOL/2000/lists.wml
index de6480f..42bdb58 100644 (file)
--- a/src/LTOL/2000/lists.wml
+++ b/src/LTOL/2000/lists.wml
@@ -9,7 +9,6 @@
 
 <pre>
 <?
-
   $referent["Elke Wilkeit"]       = "wilkeit@aol.com";
   $referent["Georg C.F. Greve"]   = "greve@gnu.org";
   $referent["Jens Finke"]         = "jens@gnome.org";
@@ -18,7 +17,7 @@
   $referent["Peter Ganten"]       = "peter@ganten.org";
   $referent["Robert Depenbrock"]  = "rd@linuxtag.de";
   $referent["Robert Möckel"]      = "robert.moeckel@innominate.de";
-  $referent["Stefan Koerner"]     = "ripclaw@rocklinux.org";
+  $referent["Stefan Körner"]     = "ripclaw@rocklinux.org";
   $referent["Stefan Westerfeld"]  = "stefan@space.twc.de";
   $referent["Tom Schier"]         = "schier@Media-Service-Group.com";
   $referent["Torsten Neumann"]    = "torsten@imke.infodrom.ffis.de";
@@ -45,7 +44,7 @@
   for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
     $row = pg_fetch_array ($sth, $nr);
 
-    printf ("  %s &lt;%s&gt;,\n", $row['name'], $row['email']);
+    printf ("  \"%s\" &lt;%s&gt;,\n", $row['name'], $row['email']);
   }
 ?>
 </pre>
@@ -72,36 +71,85 @@
 
 <pre>
 <?
+
+  $badgepos = 0;
+  function badge ($name,$email,$orga)
+  {
+    global $badgepos;
+
+    if ($badgepos == 0) {
+      echo ("\begin{picture}(0,0)\n");
+    }
+    printf ("\badge%s{%s}{%s}{%s}\n", chr(97+$badgepos),$name,$email,$orga);
+    if ($badgepos < 7) {
+      $badgepos++;
+    } else {
+      $badgepos = 0;
+      echo ("\end{picture}\n\clear\n");
+    }
+  }
+
+  $count = 0;
+
+  echo ("% Referenten\n");
+  for (reset ($referent); ($ref = key ($referent)); next ($referent)) {
+    badge ($ref, $referent[$ref], "Referent");
+    $badge[$ref] = 1;
+    $count++;
+  }
+
+  $helfer["Andre von Deetzen"]       = "andre.von.deetzen@t-online.de";
+  $helfer["Björn Schmidt"]           = "lhimdul@gmx.de";
+  $helfer["Carsten Vogel"]           = "kbs43.net@gmx.de";
+  $helfer["Dennis Giebel"]           = "dennis-linux@gmx.net";
+  $helfer["Karl Heinz Strotkamp"]    = "kh.strotkamp@t-online.de";
+  $helfer["Ralf Springwald"]         = "springwald@t-online.de";
+
+  echo ("% Helfer\n");
+  for (reset ($helfer); ($ref = key ($helfer)); next ($helfer)) {
+    badge ($ref, $helfer[$ref], "LinuxTag-Crew");
+    $badge[$ref] = 1;
+    $count++;
+  }
+
   $dbh = pg_pconnect ("kuolema", "5432", "<db>")
               or die("Unable to connect to SQL server");
 
-  $query = "SELECT name,email,themes,personal FROM exhibitor WHERE type <> 'Sponsor' ORDER BY name";
+  $query = "SELECT name,email,badgeorga,personal,organization, themes FROM exhibitor WHERE type <> 'Sponsor' ORDER BY name";
   $sth = pg_exec ($dbh, $query);
 
   for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
     $row = pg_fetch_array ($sth, $nr);
 
-    $themes = explode (",",$row['themes']);
-    $themes = ereg_replace ("&", "\&", $themes[0]);
-
-    printf ("\badge{%s}{%s}{%s}\n", $row['name'], $row['email'], $themes);
+    printf ("%% %s: %s\n", $row['organization'], $row['themes']);
+    if ($badge[$row['name']] != 1) {
+      badge($row['name'], $row['email'], $row['badgeorga']);
+      $count++;
+      $badge[$row['name']] = 1;
+    }
 
     if (strlen ($row['personal'])) {
       $row['personal'] = ereg_replace ("\r", "", $row['personal']);
       $personal = explode ("\n", $row['personal']);
       for ($i=0; $i < count ($personal); $i++) {
         $pers = explode ("<", $personal[$i]);
-       if (count ($pers) > 0) {
-         $emil = explode (">", $pers[1]);
-         $emil = $emil[0];
-       } else {
-         $emil = '';
-       }
-        printf ("\badge{%s}{%s}{%s}\n", $pers[0], $emil, $themes);
+       $pers[0] = ereg_replace (" $", "", $pers[0]);
+       if ($badge[$pers[0]] != 1) {
+         if (count ($pers) > 0) {
+           $emil = explode (">", $pers[1]);
+           $emil = $emil[0];
+         } else {
+           $emil = '';
+         }
+          badge ($pers[0], $emil, $row['badgeorga']);
+          $count++;
+         $badge[$pers[0]] = 1;
+        }
       }
     }
-  echo ("\n");
   }
+  echo ("\end{picture}\n");
+  printf ("\n%d Namensschilder\n", $count);
 ?>
 </pre>
 
diff --git a/src/LTOL/2000/personal.wml b/src/LTOL/2000/personal.wml
index 6bf694c..a4a4fb2 100644 (file)
--- a/src/LTOL/2000/personal.wml
+++ b/src/LTOL/2000/personal.wml
@@ -44,9 +44,12 @@ Das gilt insbesondere f
 
 <:
     $bgcolor="#ffffff";
-    @list = ('Andre von Deetzen, andre@webserv.de',
+    @list = ('Andre von Deetzen, andre@webserv.de, 0441/608222',
             'Dennis Giebel, dennis-linux@gmx.net',
             'Björn Schmidt, lhimdul@gmx.de, 04481/8826',
+            'Ralf Springwald, Springwald@t-online.de, 0441-608246',
+            'Karl Heinz Strotkamp, kh.strotkamp@t-online.de, 0441/2047495',
+            'Carsten Vogel, kbs43.net@gmx.de',
            );
 
     foreach $line (sort (@list)) {
diff --git a/src/LTOL/2000/presse.wml b/src/LTOL/2000/presse.wml
new file mode 100644 (file)
index 0000000..541437b
--- /dev/null
+++ b/src/LTOL/2000/presse.wml
@@ -0,0 +1,39 @@
+#include <lt2k.style>
+
+<PAGE title="LinuxTag 2000 - Presse-Resonanz">
+
+<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Personal -</font></h3>
+
+<font face="Helvetica,Arial">
+
+<h3>Presse</h3>
+
+<a href="http://www.entwickler.com/news/2000/09/14/news.html">Linux-Enterprise</a> (04.09.2000)<br>
+<a href="http://www.netzwerkinfo.de/haupt.htm">FQZ.de</a><br>
+<a href="http://news.gnome.org/gnome-news/">Gnome</a><br>
+<a href="http://www.pro-linux.de/news/2000/2121.html">Pro-Linux</a>br>
+<a href="https://www.linux-community.de/News/story?storyid=337">Linux-Community</a><br>
+<a href="http://www.home-of-linux.org/gnome/germany/">Gnome Germany</a><br>
+<a href="http://www.heise.de/ix/events/">Heise online</a><br>
+<a href="http://www.linuxde.org/news/9040.html">LINUXde.ORG</a><br>
+<a href="http://www.nordlicht.net/">Nordlicht</a><br>
+
+
+<h3>Private Links</h3>
+
+<a href="http://home.snafu.de/wehe/index.html">Werner Heuser</a><br>
+<a href="http://www.konqui.de/">Rainer Wiener</a><br>
+<a href="http://www.fh-wilhelmshaven.de/~brinkmah/home.html">Holger Brinkmann</a>br>
+<a href="http://www.infodrom.north.de/">Infodrom Oldenburg</a><br>
+<a href="http://www.infodrom.ffis.de/zeitungen/">Infodrom Zeitungen</a><br>
+
+</font>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
Website service.infodrom.org