1 #include <infodrom.style>
2 #include <debian.style>
5 <page title="Debian Events -- LinuxTag 2001">
7 <eventpg name="LinuxTag 2001" date="July 5th - 8th, 2001" place="Stuttgart, Germany">
9 <p>These people will be be at LinuxTag. Not all will be able to staff
10 the booth due to other obligations. The ZIP code should help you
11 build groups to minimize transportation costs.
13 # <: $color = "<coln>"; :>
14 # <define-tag row whitespace=delete>
15 # <preserve country zip city name hardware booth>
16 # <set-var %attributes>
17 # <if <not <get-var hardware>>
18 # <set-var hardware=" ">>
19 # <if <not <get-var booth>>
20 # <set-var booth=" ">>
22 # <tr bgcolor="<: $color=$color eq "<cold>"?"<coln>" : "<cold>";print $color:>">
23 # <td><font face="Helvetica,Arial"><get-var name></font></td>
24 # <td align=center><font face="Helvetica,Arial"><get-var country></font></td>
25 # <td><font face="Helvetica,Arial"><get-var zip></font></td>
26 # <td><font face="Helvetica,Arial"><get-var city></font></td>
27 # <td align=center><font face="Helvetica,Arial"><get-var hardware></font></td>
28 # <td align=center><font face="Helvetica,Arial"><get-var booth></font></td>
31 # <restore country zip city name hardware booth>
35 <preserve country zip city name hardware booth>
39 " $country[\"<get-var name>\"] = \"<get-var country>\";">
41 " $zip[\"<get-var name>\"] = \"<get-var zip>\";">
43 " $city[\"<get-var name>\"] = \"<get-var city>\";">
44 <if <get-var hardware>
45 " $hardware[\"<get-var name>\"] = \"<get-var hardware>\";">
47 " $booth[\"<get-var name>\"] = \"<get-var booth>\";">
49 <restore country zip city name hardware booth>
52 <center><table border=0 cellpadding=2 cellspacing=0>
53 <tr bgcolor="<eventcolh>">
54 <th><font face="Helvetica,Arial">Name</font></th>
55 <th><font face="Helvetica,Arial">Country</font></th>
56 <th><font face="Helvetica,Arial">ZIP</font></th>
57 <th><font face="Helvetica,Arial">City</font></th>
58 <th><font face="Helvetica,Arial">Hardware</font></th>
59 <th><font face="Helvetica,Arial">Booth</font></th>
63 <row name="Andreas Fuchs"
66 <row name="Alexander Reelsen"
68 city="Rheda-Wiedenbrück">
69 <row name="Andreas Schuldei"
73 # <row name="Christian Kurz"
77 <row name="Daniel Mester"
81 <row name="Eduard Bloch"
86 <row name="Gerfried Fuchs"
91 <row name="Henning Heinold"
96 <row name="Jens Neppe"
101 <row name="Goswin Brederlow"
106 <row name="Martin Schulze"
110 <row name="Martin Michlmayr"
113 # Nur 1 Tag insgesamt
114 <row name="Matthias Kabel"
119 <row name="Michael Bramer"
124 <row name="Michael Meskes"
128 <row name="Noél Köthe"
132 <row name="Oliver Bolzer"
137 <row name="Othmar Pasteka"
142 <row name="Peter Palfrader"
147 <row name="Stefan Gybas"
151 <row name="Roland Bauerschmidt"
156 #<row name="Thomas Lange"
161 <row name="Torsten Landschoff"
169 <td><font face="Helvetica,Arial">%s</font></td>
170 <td align=center><font face="Helvetica,Arial">%s</font></td>
171 <td><font face="Helvetica,Arial">%s</font></td>
172 <td><font face="Helvetica,Arial">%s</font></td>
173 <td align=center><font face="Helvetica,Arial">%s</font></td>
174 <td align=center><font face="Helvetica,Arial">%s</font></td>
177 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
178 or die("Unable to connect to SQL server");
180 $query = "SELECT name FROM person WHERE project = 'Debian' AND list = 0 ORDER BY name";
181 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
183 if (pg_NumRows ($sth) > 0) {
184 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
185 $row = pg_fetch_array ($sth, $nr);
186 $color=$color == "<cold>"?"<coln>":"<cold>";
187 $tcountry=$tzip=$tcity=$thardware=$tbooth = '';
189 $tcountry = $country[$row['name']]; if (!strlen ($tcountry)) {$tcountry = " ";}
190 $tzip = $zip[$row['name']]; if (!strlen ($tzip)) {$tzip = " ";}
191 $tcity = $city[$row['name']]; if (!strlen ($tcity)) {$tcity = " ";}
192 $thardware = $hardware[$row['name']]; if (!strlen ($thardware)) {$thardware = " ";}
193 $tbooth = $booth[$row['name']]; if (!strlen ($tbooth)) {$tbooth = " ";}
195 printf ($trow, $color, $row['name'], $tcountry, $tzip, $tcity, $thardware, $tbooth);
203 #<a href="http://www.linuxtag.org/"><img src="<root_prefix>gifs/lt2kblue.gif" width=100 height=66 alt="LinuxTag 2001" border=0></a>