<a href="<root_prefix>LinuxTag/dinner/">Abendessen</a><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/2000/">Mails</a><br>
$catname['talks'] = "Vorträge";
$catname['exhibition'] = "Ausstellung";
$catname['devel'] = "Entwicklertreffen";
+ $catname['sponsor'] = "Sponsoring";
$num_exhibitors = get_exhibitor_num ($dbh);
}
?>
-<b>Datum:</b> <input name=datum size=60 maxlength=120 value="<? echo $date; ?>"> (dd.mm.yyyy)<br>
+<b>Datum:</b> <input name=datum size=60 maxlength=12 value="<? echo $date; ?>"> (dd.mm.yyyy)<br>
<b>Kategorie:</b> <select name=category>
<?
$cat="exhibition"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Ausstellung");
$cat="pr"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Öffentlichkeitsarbeit");
$cat="talks"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Vorträge");
$cat="devel"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Entwicklertreffen");
+ if ($row['category'] == "sponsor") {
+ $cat="sponsor"; printf ("<option value=\"%s\"%s>%s", $cat, $cat == $row['category']?" selected":"", "Sponsoring");
+ }
?> </select><br>
<b>Verwendungszweck:</b> <input name=descr size=40 maxlength=80 value="<? echo $row['descr']; ?>"> <br>
<b>Betrag:</b> <input name=value_dm size=40 maxlength=20 value="<? echo $row['value_dm']; ?>"> (nnn.mm)<br>
function category ($dbh, $name, $cat, $start)
{
- global $num_exhibitors;
- global $kosten_pro_kommerzieller_aussteller;
$zug = "Zugewiesen";
if ($name == "Gesamt") {
# Sponsoren
#
- if (!strlen ($category)) {
- $color = "ff4500";
- $date = "18.8.2000";
- $cat = "Ausstellung";
- $descr = "Sponsoreinnahmen";
- $status = "open";
- $val = get_sponsoring ($dbh);
- } else {
- $color = "ffffff";
- $date = "18.8.2000";
- $cat = $catname[$category];
- $descr = "Zugewiesen";
- $status = "done";
- $val = $zugewiesen[$category];
- }
- printf ("<tr bgcolor=\"#%s\">", $color);
- printf ("<td width=\"15%%\" align=\"right\">%s</td>", $date);
- printf ("<td width=\"20%%\">%s</td>", $cat);
- printf ("<td width=\"50%%\">%s</td>", $descr);
- printf ("<td width=\"15%%\" align=\"right\">%5.2f</td>", $val);
- if (strstr ($HTTP_USER_AGENT, "Lynx")) {
- printf ("<td> %s</td>", $status);
- }
- $sum += $val;
- echo ("</tr>");
+ # if (!strlen ($category)) {
+ # $color = "ff4500";
+ # $date = "18.8.2000";
+ # $cat = "Ausstellung";
+ # $descr = "Sponsoreinnahmen";
+ # $status = "open";
+ # $val = get_sponsoring ($dbh);
+ # } else {
+ # $color = "ffffff";
+ # $date = "18.8.2000";
+ # $cat = $catname[$category];
+ # $descr = "Zugewiesen";
+ # $status = "done";
+ # $val = $zugewiesen[$category];
+ # }
+ # printf ("<tr bgcolor=\"#%s\">", $color);
+ # printf ("<td width=\"15%%\" align=\"right\">%s</td>", $date);
+ # printf ("<td width=\"20%%\">%s</td>", $cat);
+ # printf ("<td width=\"50%%\">%s</td>", $descr);
+ # printf ("<td width=\"15%%\" align=\"right\">%5.2f</td>", $val);
+ # if (strstr ($HTTP_USER_AGENT, "Lynx")) {
+ # printf ("<td> %s</td>", $status);
+ # }
+ # $sum += $val;
+ # echo ("</tr>");
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
<a href="<root_prefix>LinuxTag/dinner/">Abendessen</a><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/2000/">Mails</a><br>
Abendessen
><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/2000/">Mails</a><br>
$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";
+ $query = "SELECT id,organization,boothnr,boothsize,nr_computers,nr_tables,nr_chairs,nr_walls,personal "
+ . "FROM exhibitor "
+ . "WHERE type <> 'intern' "
+ . "ORDER BY $sort";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
$sum['boothsize']=0;
<a href="<root_prefix>LinuxTag/dinner/">Abendessen</a><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/2000/">Mails</a><br>
}
if (strlen($plz) == 0) { $plz=0; }
+ if (strlen($boothsize) == 0) { $boothsize=0; }
if (strlen($amount) ==0) { $amount=0; }
if ($id > 0) {
if ($delete == 1) {
<a href="<root_prefix>LinuxTag/dinner/">Abendessen</a><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/2000/">Mails</a><br>
<pre>
<?
- $referent["Elke Wilkeit"] = "wilkeit@aol.com";
- $referent["Georg C.F. Greve"] = "greve@gnu.org";
- $referent["Jens Finke"] = "jens@gnome.org";
- $referent["Martin Garlichs"] = "mg@giant.north.de";
- $referent["Michael Tepperis"] = "MOhe@pdv-online.de";
- $referent["Peter Ganten"] = "peter@ganten.org";
- $referent["Robert Depenbrock"] = "rd@linuxtag.de";
- $referent["Robert Möckel"] = "robert.moeckel@innominate.de";
- $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";
- $referent["Werner Heuser"] = "wehe@snafu.de";
- $referent["Wolfgang Reinfeldt"] = "info@a-fair.de";
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ or die("Unable to connect to SQL server");
- for (reset ($referent); ($ref = key ($referent)); next ($referent)) {
- printf (" %s <%s>,\n", $ref, $referent[$ref]);
+ $query = "SELECT name,email FROM personal WHERE type = 'Referent' ORDER BY name";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+ printf (" %s <%s>,\n", $row['name'], $row['email']);
+ $referent[$row['name']] = $row['email'];
}
?>
<pre>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
- or die("Unable to connect to SQL server");
-
$query = "SELECT name,email FROM exhibitor WHERE type <> 'Sponsor' ORDER BY name";
$sth = pg_exec ($dbh, $query);
function badge ($name,$email,$orga)
{
global $badgepos;
+ global $proceedings;
if ($badgepos == 0) {
echo ("\begin{picture}(0,0)\n");
}
printf ("\badge%s{%s}{%s}{%s}\n", chr(97+$badgepos),$name,$email,$orga);
+ $proceedings[] = $name . "}{" . $email . "}";
if ($badgepos < 7) {
$badgepos++;
} else {
$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++;
- }
+ $query = "SELECT name,email FROM personal WHERE type = 'Helfer' ORDER BY name";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
- or die("Unable to connect to SQL server");
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+ badge ($row['name'], $row['email'], "LinuxTag-Crew");
+ $badge[$row['name']] = 1;
+
+ }
$query = "SELECT name,email,badgeorga,personal,organization, themes FROM exhibitor WHERE type <> 'Sponsor' ORDER BY name";
$sth = pg_exec ($dbh, $query);
?>
</pre>
+<h3><font face="Helvetica,Arial">Proceedings</font></h3>
+
+<pre>
+<?
+ $proceedings[] = "Jürgen Dollinger}{}";
+ $proceedings[] = "Oliver Zendel}{}";
+ sort ($proceedings);
+ $count = 0;
+ for ($i=0; $i< count ($proceedings); $i++) {
+ $count++;
+ if (($count % 5) == 0) {
+ $add = "\hline";
+ } else {
+ $add = "";
+ }
+ printf ("\\proceeding{%s%s\n", $proceedings[$i], $add);
+ }
+
+ $query = "SELECT name,organization,email FROM exhibitor WHERE type = 'Sponsor' ORDER BY name";
+ $sth = pg_exec ($dbh, $query);
+
+ echo ("\hline\hline\n");
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+ printf ("\\proceeding{%s}{%s}\n", $row['organization'],$row['email']);
+ printf ("\\proceeding{%s}{%s}\hline\n", $row['organization'],$row['email']);
+ $count++;$count++;
+ }
+
+ printf ("\n%d Proceedings\n", $count);
+?>
+</pre>
<!-- ------------------------------------------------------------------------ -->
<table width=100% border=1 cellspacing=0 cellpadding=3 bgcolor=#ffffff>
<tr><th width=35% align=left><font face="Helvetica,Arial">Name</font></th><th width=35% align=left><font face="Helvetica,Arial">E-Mail</font></th><th width=15% align=left><font face="Helvetica,Arial">Telefon</font></th><th width=15% align=left><font face="Helvetica,Arial">Mobil</font></th></tr>
-<:
- $bgcolor="#ffffff";
- @list = ('Martin Schulze, joey@ffis.de, 0441/9738830, 0178/822 1036',
- 'Martin Garlichs, mg@giant.north.de, 04486/505, 0175/2416861',
- 'Michael Tepperis-von der Ohe, michael@linux-garage.de, 0441/9570914, 0172/4347196',
- 'Christian Wenke, cw81@gmx.de, 0441/203465',
- 'Florian Zumbiehl, florz@gmx.de, 0441/55259',
- 'Joachim Janßen, jj@iqual.de',
- );
-
- foreach $line (sort (@list)) {
- @arr = split (/,\s*/, $line);
- printf "<tr><td><font face=\"Helvetica,Arial\">%s</font></td>", $arr[0];
- printf "<td><font color=\"%s\"><</font><font face=\"Helvetica,Arial\">%s</font><font color=\"%s\">></font></td>",
- $bgcolor, $arr[1], $bgcolor;
- printf "<td><font face=\"Helvetica,Arial\">%s</font></td>", $arr[2];
- printf "<td><font color=\"%s\"> · </font><font face=\"Helvetica,Arial\">%s</font></td></tr>", $bgcolor, $arr[3];
- }
-:>
+<?
+ $bgcolor="#ffffff";
+
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ or die("Unable to connect to SQL server");
+
+ $query = "SELECT name,email,telefon,mobil FROM personal WHERE type = 'Orga' ORDER BY name";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+
+ printf ("<tr><td><font face=\"Helvetica,Arial\">%s</font></td>", $row['name']);
+ printf ("<td><font color=\"%s\"><</font><font face=\"Helvetica,Arial\">%s</font><font color=\"%s\">></font></td>",
+ $bgcolor, $row['email'], $bgcolor);
+ printf ("<td><font face=\"Helvetica,Arial\">%s</font></td>", $row['telefon']);
+ printf ("<td><font color=\"%s\"> · </font><font face=\"Helvetica,Arial\">%s</font></td></tr>", $bgcolor, $row['mobil']);
+ }
+?>
</table><p>
<table width=100% border=1 cellspacing=0 cellpadding=3 bgcolor=#ffffff>
<tr><th width=35% align=left><font face="Helvetica,Arial">Name</font></th><th width=35% align=left><font face="Helvetica,Arial">E-Mail</font></th><th width=15% align=left><font face="Helvetica,Arial">Telefon</font></th><th width=15% align=left><font face="Helvetica,Arial">Mobil</font></th></tr>
-<:
- $bgcolor="#ffffff";
- @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)) {
- @arr = split (/,\s*/, $line);
- printf "<tr><td><font face=\"Helvetica,Arial\">%s</font></td>", $arr[0];
- printf "<td><font color=\"%s\"><</font><font face=\"Helvetica,Arial\">%s</font><font color=\"%s\">></font></td>",
- $bgcolor, $arr[1], $bgcolor;
- printf "<td><font face=\"Helvetica,Arial\">%s</font></td>", $arr[2];
- printf "<td><font color=\"%s\"> · </font><font face=\"Helvetica,Arial\">%s</font></td></tr>", $bgcolor, $arr[3];
- }
-:>
+<?
+ $bgcolor="#ffffff";
+
+ $query = "SELECT name,email,telefon,mobil FROM personal WHERE type = 'Helfer' ORDER BY name";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+
+ printf ("<tr><td><font face=\"Helvetica,Arial\">%s</font></td>", $row['name']);
+ printf ("<td><font color=\"%s\"><</font><font face=\"Helvetica,Arial\">%s</font><font color=\"%s\">></font></td>",
+ $bgcolor, $row['email'], $bgcolor);
+ printf ("<td><font face=\"Helvetica,Arial\">%s</font></td>", $row['telefon']);
+ printf ("<td><font color=\"%s\"> · </font><font face=\"Helvetica,Arial\">%s</font></td></tr>", $bgcolor, $row['mobil']);
+ }
+?>
</table>
<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>
+<a href="http://www.is-bremen.de/ca/0010/05.html">CA 10/2000</a><br>
<h3>Private Links</h3>
<a href="dinner/">Abendessen</a><br>
<ifneq <get-var WML_SRC_BASENAME> "personal"
- <a href="personal.html">Personal</a>
+ <a href="personal.php3">Personal</a>
Personal
><br>
# Newslist
# ><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<b>Treffen:</b><br>
<a href="<root_prefix>LinuxTag/dinner/">Abendessen</a><br>
-<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="<root_prefix>LinuxTag/personal.php3">Personal</a><br>
<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/2000/">Mails</a><br>