--- /dev/null
+#include "lt2k.style"
+
+<page title="LinuxTag 2000 - Calendar">
+
+<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Zeitplan -</font></h3>
+
+<? $dbh = pg_pconnect ("kuolema", "5432", "lt2k") or die("Unable to
+ connect to SQL server");
+
+ pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+ $query = sprintf ("SELECT deadline,subject,body,closed FROM jobs WHERE id = %d", $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ if (pg_NumRows ($sth) > 0) {
+ $row = pg_fetch_array ($sth, 0);
+ $date = explode (" ", $row['deadline']);
+ $date = explode ("-", $date[0]);
+ $deadline = sprintf ("%d-%d-%d", $date[0], $date[1], $date[2]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+
+ printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['subject']);
+ printf ("<b><font face=\"Helvetica,Arial\">Deadline: %s</font></h3>", $date);
+
+ echo "<blockquote><font face=\"Helvetica,Arial\">";
+ echo ereg_replace ("<newline>", "
+", ereg_replace ("<newline><newline>","<p>", ereg_replace ("
+", "<newline>", $row['body'])));
+ echo "</font></blockquote>";
+ } else {
+ $row['deadline'] = date("Y-m-j");
+ }
+?>
+
+<font face="Helvetica,Arial">
+Eine Leerzeile bedeutet Absatzende.<p>
+
+<form action=update.php3 method=post>
+<input type=hidden name=id value="<? echo $id; ?>">
+<b>Deadline:</b> <input name=deadline size=20 maxlength=12 value="<? echo $deadline; ?>"> (yyyy-mm-dd)<br>
+<b>Subject:</b> <input name=subject size=55 maxlength=40 value="<? echo $row['subject']; ?>"> <br>
+<b>Text:</b> <br><textarea name=body rows=16 cols=67><? echo $row['body']; ?></textarea><p>
+<input type=submit value=Aktualisieren> <input type=reset value=Reset>
+</form></font>
+
+</page>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+#include "lt2k.style"
+
+<page title="LinuxTag 2000 - Calendar">
+
+<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Zeitplan -</font></h3>
+
+<? $dbh = pg_pconnect ("kuolema", "5432", "lt2k") or die("Unable to
+ connect to SQL server");
+
+ pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+ $query = sprintf ("SELECT jobs_log.id,jobs_log.body,jobs.deadline,jobs.subject FROM jobs,jobs_log "
+ . "WHERE jobs_log.job = jobs.id AND jobs_log.id = %d", $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ if (pg_NumRows ($sth) > 0) {
+ $row = pg_fetch_array ($sth, 0);
+ $date = explode (" ", $row['deadline']);
+ $date = explode ("-", $date[0]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+ printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['subject']);
+ printf ("<b><font face=\"Helvetica,Arial\">Deadline: %s</font></h3>", $date);
+ }
+?>
+
+<font face="Helvetica,Arial">
+Eine Leerzeile bedeutet Absatzende.<p>
+
+<form action=updatelog.php3 method=post>
+<input type=hidden name=id value="<? echo $row['id']; ?>">
+<b>Subject:</b> <? echo $row['subject']; ?> <br>
+<b>Text:</b> <br><textarea name=body rows=16 cols=67><? echo $row['body']; ?></textarea><p>
+<input type=submit value=Aktualisieren>
+</form></font>
+
+</page>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+#include <lt2k.style>
+
+<page title="LinuxTag 2000 - Calendar">
+
+<headline "Zeitplan">
+
+<table width=100% border=1 cellspacing=0 cellpadding=3 bgcolor=#ffffff>
+<tr><th width=10% align=left><font face="Helvetica,Arial">Datum</font></th><th width=80% align=left><font face="Helvetica,Arial">Aufgabe</font></th><th width=10% align=left><font face="Helvetica,Arial">Erledigt</font></th></tr>
+
+<?
+ $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ or die("Unable to connect to SQL server");
+
+ pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+ $query = "SELECT id,deadline,subject,closed FROM jobs WHERE deleted = 0 ORDER BY deadline,subject";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+ $date = explode (" ", $row['deadline']);
+ $date = explode ("-", $date[0]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+
+ $fgcolor = "#000000";
+ $bgcolor = "#ffffff";
+ $overdue = "";
+ if (!$row['closed']) {
+ $now = explode ("-", date("Y-m-j"));
+ $now = mktime(0,0,0,$now[1],$now[2],$now[0]);
+ $dead = explode (" ", $row['deadline']);
+ $dead = explode ("-", $dead[0]);
+ $dead = mktime(0,0,0,$dead[1],$dead[2],$dead[0]);
+ $days = ceil (($now - $dead) / 86400);
+
+ if ($days > 0) { // überfällig
+ $fgcolor = "#000000";
+ $bgcolor = "#ff4500";
+ $overdue = "<font color=\"$bgcolor\" size=\"-2\">overdue</font>";
+ } elseif ($days > -10) {
+ $fgcolor = "#000000";
+ $bgcolor = "#ffff00";
+ }
+ }
+
+ printf ("<tr bgcolor=\"%s\"><td align=\"right\"><font color=\"%s\" face=\"Helvetica,Arial\">%s</font></td>",
+ $bgcolor, $fgcolor, $date);
+ printf ("<td><font color=\"%s\" face=\"Helvetica,Arial\"><a href=\"show.php3?id=%d\">%s</a></font></td>",
+ $fgcolor, $row['id'], $row['subject']);
+ if ($row['closed']) {
+ $closed = explode (" ", $row['closed']);
+ $closed = explode ("-", $closed[0]);
+ $closed = sprintf ("%d.%d.%d", $closed[2], $closed[1], $closed[0]);
+
+ printf ("<td align=\"right\"><font color=\"%s\" face=\"Helvetica,Arial\">%s</font></td></tr>",
+ $fgcolor, $closed);
+ } else {
+ echo ("<td>$overdue </td></tr>");
+ }
+ }
+?>
+
+</table>
+
+<p><font face="Helvetica,Arial"><a href="edit.php3">Termin hinzufügen</a></font><p>
+
+<h3><font face="Helvetica,Arial">Legende</font></h3>
+
+<table width=20% border=1 cellpadding=5 cellspacing=0>
+<tr align=center bgcolor=#ffffff><td><font face="Helvetica,Arial">normal</font></td></tr>
+<tr align=center bgcolor=#ffff00><td><font face="Helvetica,Arial">max. 10 Tage</font></td></tr>
+<tr align=center bgcolor=#ff4500><td><font face="Helvetica,Arial">überfällig</font></td></tr>
+</table>
+
+</page>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+DROP TABLE jobs;
+CREATE TABLE jobs (
+ id int4 NOT NULL,
+ subject text DEFAULT '' NOT NULL,
+ deadline datetime DEFAULT '1980-01-01 00:00' NOT NULL,
+ body text DEFAULT '' NOT NULL,
+ insertd datetime DEFAULT '1980-01-01 00:00' NOT NULL,
+ insertp text DEFAULT '' NOT NULL,
+ closed datetime DEFAULT NULL,
+ closep text DEFAULT '' NOT NULL,
+ "deleted" int4 DEFAULT 0);
+CREATE UNIQUE INDEX "jobs_id" on "jobs" using btree ( "id" "int4_ops" );
+
+DROP TABLE jobs_log;
+CREATE TABLE jobs_log (
+ id int4 NOT NULL,
+ job int4 NOT NULL,
+ body text DEFAULT '' NOT NULL,
+ insertd datetime DEFAULT '1980-01-01 00:00' NOT NULL,
+ insertp text DEFAULT '' NOT NULL,
+ "deleted" int4 DEFAULT 0);
+CREATE UNIQUE INDEX "jobs_log_id" on "jobs_log" using btree ( "id" "int4_ops" );
+
+GRANT ALL on jobs TO joey;
+GRANT ALL on jobs TO www;
+GRANT ALL on jobs_log TO joey;
+GRANT ALL on jobs_log TO www;
+
+INSERT INTO jobs VALUES (1,'1tes Orga-Treffen','2000-05-25','erstes Orga-Treffen','2000-05-25','joey',NULL,'',0);
+INSERT INTO jobs VALUES (2,'2tes Orga-Treffen','2000-06-08','zweites Orga-Treffen','2000-06-07','joey',NULL,'',0);
+INSERT INTO jobs_log VALUES (1,1,'blubber treffen fand statt','2000-06-07','joey',0);
+INSERT INTO jobs_log VALUES (2,2,'Treffen wird vorbereitet','2000-06-07','joey',0);
+
+CREATE TABLE "news" (
+ "id" int4 NOT NULL,
+ "subject" text DEFAULT '' NOT NULL,
+ "author" text DEFAULT '' NOT NULL,
+ "email" text DEFAULT '' NOT NULL,
+ "teaser" text DEFAULT '' NOT NULL,
+ "body" text DEFAULT '' NOT NULL,
+ "insertd" datetime DEFAULT '1980-01-01 00:00' NOT NULL,
+ "insertp" text DEFAULT '' NOT NULL,
+ "releasedate" datetime DEFAULT '1980-01-01 00:00' NOT NULL,
+ "deleted" int4 DEFAULT 0);
--- /dev/null
+#include <lt2k.style>
+
+<page title="LinuxTag 2000 - Calendar">
+
+<headline "Zeitplan">
+
+<? $dbh = pg_pconnect ("kuolema", "5432", "lt2k") or die("Unable to
+ connect to SQL server");
+
+ pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+
+ $query = sprintf ("SELECT deadline,subject,body,closed FROM jobs WHERE id = %d", $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ if (pg_NumRows ($sth) > 0) {
+ $row = pg_fetch_array ($sth, 0);
+ $date = explode (" ", $row['deadline']);
+ $date = explode ("-", $date[0]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+
+ printf ("<h3><font face=\"Helvetica,Arial\">%s</font></h3>", $row['subject']);
+ echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
+ echo "<tr><td width=\"85%\"align=\"left\">";
+ printf ("<b><font face=\"Helvetica,Arial\">Deadline: %s</font></b><br>", $date);
+
+ $dead = explode (" ", $row['deadline']);
+ $dead = explode ("-", $dead[0]);
+ $dead = mktime(0,0,0,$dead[1],$dead[2],$dead[0]);
+
+ if ($row['closed']) {
+ $closed = explode (" ", $row['closed']);
+ $closed = explode ("-", $closed[0]);
+ $closedate = mktime(0,0,0,$closed[1],$closed[2],$closed[0]);
+ $closed = sprintf ("%d.%d.%d", $closed[2], $closed[1], $closed[0]);
+
+ printf ("<b><font face=\"Helvetica,Arial\">Erledigt: %s</font></b><br>", $closed);
+
+ $days = ceil (($closedate - $dead) / 86400);
+ if ($days > 0) {
+ printf ("<b><font face=\"Helvetica,Arial\">Verzögerung: %d Tag%s</font></b><br>", $days, $days>1?"e":"");
+ }
+ } else {
+ $now = explode ("-", date("Y-m-j"));
+ $now = mktime(0,0,0,$now[1],$now[2],$now[0]);
+
+ $days = ceil (($now - $dead) / 86400);
+ if ($days > 0) {
+ printf ("<b><font face=\"Helvetica,Arial\">Überfällig seit %d Tag%s</font></b><br>", $days, $days>1?"en":"");
+ } else {
+ printf ("<b><font face=\"Helvetica,Arial\">Noch %d Tag%s Zeit</font></b><br>", -$days, $days!=-1?"e":"");
+ }
+
+ }
+ echo "</td><td width=\"15%\"align=\"right\">";
+
+ printf (" <a href=\"edit.php3?id=%d\"><phpedit></a>", $id);
+ printf (" <a href=\"update.php3?id=%d&delete=1\"><phpdel></a>", $id);
+ if (!$row['closed']) {
+ printf (" <a href=\"update.php3?id=%d&close=1\"><phpclose></a>", $id);
+ }
+
+ echo "</td></tr></table>";
+ echo "<p><font face=\"Helvetica,Arial\">";
+ echo ereg_replace ("<newline>", "
+", ereg_replace ("<newline><newline>","<p>", ereg_replace ("
+", "<newline>", $row['body'])));
+ echo "</font><p>";
+
+ $query = sprintf ("SELECT id,body,insertp,insertd FROM jobs_log WHERE deleted = 0 AND job = %d ORDER BY insertd DESC", $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+ $date = explode (" ", $row['insertd']);
+ $date = explode ("-", $date[0]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+
+ echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" bgcolor=\"#c0e4f0\">";
+ printf ("<tr><th align=\"left\" width=\"80%%\"><font face=\"Helvetica,Arial\">%s, %s</font></th>",
+ $date, $row['insertp']);
+ printf ("<th width=\"20%%\" align=\"right\"><a href=\"editlog.php3?id=%d\"><phpedit></a> "
+ . "<a href=\"updatelog.php3?id=%d&delete=1\"><phpdel></a></th></tr>", $row['id'], $row['id']);
+ printf ("<tr><td colspan=\"2\" width=\"100%%\"><font face=\"Helvetica,Arial\">%s</font></td></tr>",
+ ereg_replace ("<newline>", "
+", ereg_replace ("<newline><newline>","<p>", ereg_replace ("
+", "<newline>", $row['body']))));
+ echo "</table><p>";
+
+ }
+ echo "<b><font face=\"Helvetica,Arial\">Neuen Kommentar aufnehmen:</b>";
+ printf ("<form method=\"post\" action=\"updatelog.php3\"><input type=\"hidden\" name=\"job\" value=\"%d\">", $id);
+ echo "<textarea rows=\"10\" cols=\"67\" name=\"body\"></textarea><br>";
+ echo "<input type=\"submit\" value=\"Hinzufügen\"></form></font>";
+ } else {
+ printf ("<b><font face=\"Helvetica,Arial\">Job %d nicht gefunden</font></b>", $id);
+ }
+?>
+
+</page>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+<a href="<root_prefix>LinuxTag/">LinuxTag 2000</a><br>
+
+<a href="<root_prefix>LinuxTag/news/">Newslist</a><br>
+
+<a href="<root_prefix>LinuxTag/telefon/">Telefon</a><br>
+
+<a href="<root_prefix>LinuxTag/treffen/">Treffen</a><br>
+
+<ifneq <get-var WML_SRC_BASENAME> "index"
+ <a href="<root_prefix>LinuxTag/calendar/">Kalender</a>
+ Kalender
+><br>
+
+<a href="<root_prefix>LinuxTag/exhibition/">Ausstellung</a><br>
+
+<a href="<root_prefix>LinuxTag/costs/">Kosten</a><br>
+
+<a href="<root_prefix>LinuxTag/dinner/">Abendessen</a><br>
+
+<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
+<a href="<root_prefix>LinuxTag/download/">Download</a><br>
+
+<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
+
+# Local variables:
+# mode: indented-text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+#include "lt2k.style"
+
+<page title="LinuxTag 2000 - Calendar">
+
+<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Zeitplan -</font></h3>
+
+<?
+
+ function sql_prepare ($text)
+ {
+ # Der Himmel ist blau, das Wasser ist klar, die Vögel zwitschern
+ # draußen, doch PHP weigert sich beharrlich, vernünftig zu
+ # arbeiten.
+ #
+ # Problem: Im Form kommt " an, PHP macht daraus freundlicherweise \"
+ # und schon sind unsere Daten in der SQL-DB kaputt. Danke
+ # $mytext = ereg_replace ("\\\\", "\\\\", $text);
+ $mytext = ereg_replace ("\\\"", "\"", $text);
+ # $mytext = ereg_replace ("'", "\\'", $mytext);
+ return ($mytext);
+ }
+
+ $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ or die("Unable to connect to SQL server");
+
+ $body = sql_prepare ($body);
+ $subject = sql_prepare ($subject);
+
+ if ($id > 0) {
+ if ($delete == 1) {
+ $query = sprintf ("UPDATE jobs SET deleted=1 WHERE id = %d", $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ } elseif ($close == 1) {
+ $query = sprintf ("UPDATE jobs SET closed='now',closep='%s' WHERE id = %d", $REMOTE_USER, $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ } else {
+ if (strlen ($body) > 0 && strlen ($subject) > 0 && strlen ($deadline) > 0) {
+ $query = sprintf ("UPDATE jobs SET subject='%s',deadline='%s',body='%s' WHERE id = %d",
+ $subject, $deadline, $body, $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ } else {
+ echo "<p><b><font face=\"Helvetica,Arial\">Kein Subject, Text oder Datum angegeben!</font></b>";
+ }
+ }
+ } else {
+ if (strlen ($body) > 0 && strlen ($subject) > 0 && strlen ($deadline) > 0) {
+ $sth = pg_exec ($dbh, "SELECT max(id) FROM jobs") or die("Datenbank-Abfrage!");
+ $oldid = pg_fetch_array ($sth, 0) or die("Datenbank-Abfrage!"); $oldid[0]++;
+
+ $query = sprintf ("INSERT INTO jobs (id,subject,deadline,body,insertd,insertp,closed,closep,deleted) VALUES ("
+ . "%d,'%s','%s','%s','now','%s',NULL,'',0)", $oldid[0], $subject, $deadline, $body, $REMOTE_USER);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ } else {
+ echo "<p><b><font face=\"Helvetica,Arial\">Kein Subject, Text oder Datum angegeben!</font></b>";
+ }
+ }
+?>
+
+<p><b><font face="Helvetica,Arial">Aktion (unter Vorbehalt) durchgeführt</font></b>
+
+<p><b><font face="Helvetica,Arial"><a href="<? echo "show.php3?id=$id"; ?>">Zurück</a></font></b>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+#include "lt2k.style"
+
+<page title="LinuxTag 2000 - Calendar">
+
+<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
+<h3 align=center><font face="Helvetica,Arial">- Zeitplan -</font></h3>
+
+<?
+
+ function sql_prepare ($text)
+ {
+ # Der Himmel ist blau, das Wasser ist klar, die Vögel zwitschern
+ # draußen, doch PHP weigert sich beharrlich, vernünftig zu
+ # arbeiten.
+ #
+ # Problem: Im Form kommt " an, PHP macht daraus freundlicherweise \"
+ # und schon sind unsere Daten in der SQL-DB kaputt. Danke
+ # $mytext = ereg_replace ("\\\\", "\\\\", $text);
+ $mytext = ereg_replace ("\\\"", "\"", $text);
+ # $mytext = ereg_replace ("'", "\\'", $mytext);
+ return ($mytext);
+ }
+
+ $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ or die("Unable to connect to SQL server");
+
+ $body = sql_prepare ($body);
+
+ if ($id > 0) {
+ if ($delete == 1) {
+ $query = sprintf ("UPDATE jobs_log SET deleted=1 WHERE id = %d", $id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ echo "<p><b><font face=\"Helvetica,Arial\">Aktion durchgeführt.</font></b>";
+ echo "<p><b><font face=\"Helvetica,Arial\"><a href=\"index.php3\">Zurück</a></font></b>";
+ } else {
+ if (strlen ($body) > 0) {
+ $query = sprintf ("UPDATE jobs_log SET body='%s' WHERE id = %d", $body,$id);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ echo "<p><b><font face=\"Helvetica,Arial\">Aktion durchgeführt.</font></b>";
+ } else {
+ echo "<p><b><font face=\"Helvetica,Arial\">Text vergessen!</font></b>";
+ }
+ echo "<p><b><font face=\"Helvetica,Arial\"><a href=\"index.php3\">Zurück</a></font></b>";
+ }
+ } elseif ($job > 0) {
+ if (strlen ($body) > 0) {
+ $sth = pg_exec ($dbh, "SELECT max(id) FROM jobs_log") or die("Datenbank-Abfrage!");
+ $oldid = pg_fetch_array ($sth, 0) or die("Datenbank-Abfrage!"); $oldid[0]++;
+
+ $query = "INSERT INTO jobs_log "
+ . "(id,job,body,insertd,insertp,deleted) VALUES ("
+ . "$oldid[0],"
+ . "$job,"
+ . "'$body',"
+ . "'now',"
+ . "'$REMOTE_USER',0"
+ . ")";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ echo "<p><b><font face=\"Helvetica,Arial\">Aktion durchgeführt.</font></b>";
+ } else {
+ echo "<p><b><font face=\"Helvetica,Arial\">Text vergessen!</font></b>";
+ }
+ echo "<p><b><font face=\"Helvetica,Arial\"><a href=\"show.php3?id=$job\">Zurück</a></font></b>";
+ }
+?>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="<root_prefix>LinuxTag/download/">Download</a><br>
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
<h3><font face="Helvetica,Arial">Donnerstag, 12. Oktober 2000</font></h3>
<font face="Helvetica,Arial">
-Lokal: Santorini<br>
+Lokal: Santorini, Ammerländer Heerstraße 80<br>
Uhrzeit: 19:00-22:00 Uhr<p>
# printf (" <a href=\"update.php3?id=%d&delete=1\"><phpdel></a>", $id);
<h3><font face="Helvetica,Arial">Freitag, 13. Oktober 2000</font></h3>
<font face="Helvetica,Arial">
-Lokal: DaCapo<br>
+Lokal: DaCapo, Friedhofsweg 64<br>
Uhrzeit: 19:00-22:00 Uhr<p>
<daytable day=Fr>
<h3><font face="Helvetica,Arial">Samstag, 14. Oktober 2000</font></h3>
<font face="Helvetica,Arial">
-Lokal: Dubrovnik<br>
+Lokal: Kartoffelkiste, Artillerieweg 56<br>
Uhrzeit: 19:00-22:00 Uhr<p>
<daytable day=Sa>
<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="<root_prefix>LinuxTag/download/">Download</a><br>
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
$query = "DELETE FROM dinner WHERE oid = $oid";
}
} else {
- if (strlen ($name) > 0) {
+ if ((strlen ($name) > 0) && (strlen ($email) > 0) && (strlen ($day) > 0)) {
$query = "INSERT INTO dinner "
. "(name,email,day) VALUES ('$name','$email','$day')";
}
}
//printf ("<pre>\n%s\n</pre>\n", $query);
- $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ if (strlen ($query) > 0) {
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+ }
?>
<h3><? echo $name; ?> aufgenommen/aktualisiert</h3>
</tr>
</define-tag>
+<define-tag dinnertable>
+<set-var %attributes>
+<table width=100% border=0 cellpadding=0 cellspacing=2>
+<tr>
+ <th> </th>
+ <th><font face="Helvetica,Arial">Name</font></th>
+ <th><font face="Helvetica,Arial">Email</font></th>
+</tr>
+
+<:
+ $day="<get-var day>";
+ $nr=1;
+ while ($nr < 6) {
+ printf "<tr>
+ <td><font face=\"Helvetica,Arial\">%d.</font></td>
+ <td><font face=\"Helvetica,Arial\"><input type=\"text\" name=\"name%s%d\" size=\"20\" maxlength=\"100\"></font></td>
+ <td><font face=\"Helvetica,Arial\"><input type=\"text\" name=\"email%s%d\" size=\"20\" maxlength=\"100\"></font></td>
+</tr>", $nr, $day, $nr, $day, $nr;
+ $nr++;
+ }
+:>
+
+</table>
+</define-tag>
+
<?
if ($id > 0) {
$dbh = pg_pconnect ("kuolema", "5432", "lt2k")
if (pg_NumRows ($sth) > 0) {
$row = pg_fetch_array ($sth, 0);
+ if ($row['plz'] == 0) {
+ $row['plz'] = '';
+ }
}
} else {
+ $row['logo_url'] = "http://oldenburger.linuxtage.de/lt2000/";
$row['boothsize'] = 0;
$row['nr_tables'] = 0;
$row['nr_chairs'] = 0;
$row['nr_walls'] = 0;
$row['nr_computers'] = 0;
- $row['plz'] = 0;
+ $row['amount'] = 0;
+# $row['plz'] = 0;
}
if (strlen ($row['logo_url'])) {
</select>
</font></td>
</tr>
+
+<tr>
+ <th align=right width=20%><font face="Helvetica,Arial">Betrag</font></th>
+ <td align=left width=80%><font face="Helvetica,Arial">
+ <input type=text name=amount size=7 maxlength=5 value="<? echo $row['amount']; ?>">
+ <font size=-1>(inkl. MwSt., nur falls Sponsor)</font>
+ </font></td>
+</tr>
+
<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>
<field d="Zusatz" n="address0" s=40 m=100>
<field d="Zusatz" n="address1" s=40 m=100>
<field d="Straße" n="strasse" s=40 m=100>
-<field d="PLZ" n="plz" s=40 m=5>
-<field d="Stadt" n="stadt" s=40 m=100>
+
+<tr>
+ <th align=right width=20%><font face="Helvetica,Arial">PLZ, Ort</font></th>
+ <td align=left width=80%><font face="Helvetica,Arial">
+ <input type=text name=plz size=5 maxlength=5 value="<? echo $row['plz']; ?>">
+ <input type=text name=stadt size=35 maxlength=100 value="<? echo $row['stadt']; ?>">
+ </font></td>
+</tr>
+
<field d="E-Mail" n="email" s=40 m=100>
<field d="Telefon" n="telefon" s=40 m=25>
<field d="Fax" n="telefax" s=40 m=25>
</table>
-<p><center><input type=submit value="<? echo $id>0?"Update":"Insert"; ?>"></center><p>
+<?
+ if ($id == 0) {
+?>
+
+<hr align=center width=90%>
+<h3><font face="Helvetica,Arial">Abendessen: Donnerstag, 12. Oktober: Santorini, Ammerländer Heerstraße 80</font></h3>
+<dinnertable day="Do">
+
+<h3><font face="Helvetica,Arial">Abendessen: Freitag, 13. Oktober: DaCapo, Friedhofsweg 64</font></h3>
+<dinnertable day="Fr">
+
+<h3><font face="Helvetica,Arial">Abendessen: Samstag, 14. Oktober: Kartoffelkiste, Artillerieweg 56</font></h3>
+<dinnertable day="Sa">
+
+<?
+ }
+?>
+
+<p><center><input type=submit value="<? echo $id>0?"Update":"Insert"; ?>"></center><p>
</form>
<?
<h3><font face="Helvetica,Arial">Platzbedarf</font></h3>
<table border=1 cellspacing=1 cellpadding=3>
-<tr bgcolor="#c0e4f0"><th align=left width=60%><font face="Helvetica,Arial">Organisation</font></th>
+<tr bgcolor="#c0e4f0"><th align=left width=56%><font face="Helvetica,Arial">Organisation</font></th>
<th align=left width=20%><font face="Helvetica,Arial">Typ</font></th>
- <th align=left width=10%><font face="Helvetica,Arial">Platz</font></th>
- <th align=left width=10%><font face="Helvetica,Arial">Rechner</font></th>
+ <th align=left width=7%><font face="Helvetica,Arial">Platz</font></th>
+ <th align=left width=7%><font face="Helvetica,Arial">Rechner</font></th>
+ <th align=left width=10%><font face="Helvetica,Arial">Betrag</font></th>
</tr>
<?
$dbh = pg_pconnect ("kuolema", "5432", "lt2k")
or die("Unable to connect to SQL server");
- $query = "SELECT id,organization,type,boothsize,nr_computers FROM exhibitor ORDER BY organization";
+ $query = "SELECT id,organization,type,amount,boothsize,nr_computers FROM exhibitor ORDER BY organization";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
$sum=0;
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
- printf ("<tr><th align=\"left\" width=\"60%%\"><font face=\"Helvetica,Arial\">%d. <a href=\"edit.php3?id=%d\">%s</a></font></th>"
+ printf ("<tr><th align=\"left\" width=\"56%%\"><font face=\"Helvetica,Arial\">%d. <a href=\"edit.php3?id=%d\">%s</a></font></th>"
. "<th align=\"left\" width=\"20%%\"><font face=\"Helvetica,Arial\">%s</font></th>"
- . "<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>"
- . "<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>"
- . "</tr>\n", $nr+1, $row['id'], $row['organization'], $row['type'], $row['boothsize'], $row['nr_computers']);
+ . "<th align=\"right\" width=\"7%%\"><font face=\"Helvetica,Arial\">%s</font></th>"
+ . "<th align=\"right\" width=\"7%%\"><font face=\"Helvetica,Arial\">%s</font></th>"
+ . "<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%8.2f</font></th>"
+ . "</tr>\n", $nr+1, $row['id'], $row['organization'], $row['type'], $row['boothsize'],
+ $row['nr_computers'], $row['amount']);
$sum += $row['boothsize'];
+ $amount += $row['amount'];
$computers += $row['nr_computers'];
}
?>
-<tr><th align=left width=80% colspan=2><font face="Helvetica,Arial">Summe</font></th>
- <th align=right width=10%><font face="Helvetica,Arial"><? echo $sum; ?></font></th>
- <th align=right width=10%><font face="Helvetica,Arial"><? echo $computers; ?></font></th>
+<tr><th align=left width=76% colspan=2><font face="Helvetica,Arial">Summe</font></th>
+ <th align=right width=7%><font face="Helvetica,Arial"><? echo $sum; ?></font></th>
+ <th align=right width=7%><font face="Helvetica,Arial"><? echo $computers; ?></font></th>
+ <th align=right width=10%><font face="Helvetica,Arial"><? printf ("%9.2f",$amount); ?></font></th>
</tr>
</table><p>
<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="<root_prefix>LinuxTag/download/">Download</a><br>
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
}
:>
+ if ($type != "Sponsor") {
+ $amount = 0;
+ }
+
+ if (strlen($plz) == 0) { $plz=0; }
+ if (strlen($amount) ==0) { $amount=0; }
if ($id > 0) {
if ($delete == 1) {
$query = "DELETE FROM exhibitor WHERE id = $id";
'personal','boothnr','type','comment')) {
printf " . \"%s='\$%s',\"\n", $i, $i;
}
- for $i (('plz','boothsize','nr_tables','nr_chairs','logo_width','logo_height')) {
+ for $i (('plz','boothsize','nr_tables','nr_chairs','logo_width','logo_height','amount')) {
printf " . \"%s=\$%s,\"\n", $i, $i;
}
:>
} else {
$sth = pg_exec ($dbh, "SELECT max(id) FROM exhibitor") or die("Datenbank-Abfrage!");
$oldid = pg_fetch_array ($sth, 0) or die("Datenbank-Abfrage!"); $oldid[0]++;
+ $logo_height = sprintf ("%d", $logo_height);
+ $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) VALUES ("
+ . "(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 ("
. "$oldid[0]"
<:
for $i (('organization','type','description','themes','name','address0','address1',
'personal','boothnr','comment')) {
printf " . \",'\$%s'\"\n", $i;
}
- for $i (('plz','boothsize','nr_tables','nr_chairs','nr_computers','logo_width','logo_height')) {
+ for $i (('plz','boothsize','nr_tables','nr_chairs','nr_computers','logo_width','logo_height','amount')) {
printf " . \",\$%s\"\n", $i;
}
:>
}
//printf ("<pre>\n%s\n</pre>\n", $query);
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ if ($id == 0) {
+ $day = array ("Do","Fr","Sa");
+
+ for ($iday=0; $iday < count ($day); $iday++) {
+ for ($i=1; $i < 6; $i++) {
+ $name = sprintf ("name%s%d", $day[$iday], $i);
+ $email = sprintf ("email%s%d", $day[$iday], $i);
+
+ if (strlen (${$name}) > 0 && strlen (${$email}) > 0) {
+ $query = sprintf ("INSERT INTO dinner (name,email,day) VALUES ('%s','%s','%s')",
+ sql_prepare (${$name}), sql_prepare (${$email}), $day[$iday]);
+ $sth = pg_exec ($dbh, $query); #- ignore... or die("Datenbank-Abfrage!");
+ }
+ }
+ }
+ }
?>
<h3><? echo $organization; ?> aufgenommen/aktualisiert</h3>
<:
$bgcolor="#ffffff";
- @list = ('Martin Schulze, joey@infodrom.ffis.de, 0441/9738830, 0178/822/1036',
+ @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',
);
Ferien
><br>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="download/">Download</a><br>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
# Local variables:
}
:>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="<root_prefix>LinuxTag/download/">Download</a><br>
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
<a href="<root_prefix>LinuxTag/personal.html">Personal</a><br>
+<a href="http://www.infodrom.ffis.de/Mail-Archive/ffis-lt2k/">Mails</a><br>
+
<a href="<root_prefix>LinuxTag/download/">Download</a><br>
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>