}
?> <input name=newcategory size=20 maxlength=50 value=""><br>
-<b>Abs./Empf.:</b> <input name=from_to size=50 maxlength=120 value="<? echo $row['from_to']; ?>"><br>
+<b>Abs.Æmpf.:</b> <select name=from_to>
+<option>
+<?
+ $query = "SELECT DISTINCT from_to FROM account ORDER BY from_to";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {
+ $cat = pg_fetch_array ($sth, $nr);
+ printf ("<option value=\"%s\"%s>%s", $cat['from_to'], $cat['from_to'] == $row['from_to']?" selected":"", $cat['from_to']);
+ }
+
+?> <input name=newfrom_to size=30 maxlength=120 value=""><br>
<b>Betrag:</b> <input name=value_dm size=40 maxlength=20 value="<? echo $row['value_dm']; ?>"> (nnn.mm)<br>
<b>Verwendungszweck:</b> <br><textarea name=descr rows=5 cols=67><? echo $row['descr']; ?></textarea><p>
if (strlen ($category) == 0 && strlen ($newcategory) > 0) {
$category = $newcategory;
}
+ if (strlen ($from_to) == 0 && strlen ($newfrom_to) > 0) {
+ $from_to = $newfrom_to;
+ }
$category = sql_prepare ($category);
$descr = sql_prepare ($descr);
$from_to = sql_prepare ($from_to);
<page title="Infodrom Oldenburg - News">
+<headline "News">
+
<?
if ($id > 0) {
$dbh = pg_pconnect ("kuolema", "5432", "web")
<page title="Infodrom Oldenburg - News">
+<headline "News">
+
<table border=0 cellspacing=3 bgcolor="#f7ba2e">
<tr><td>Nr.</td><td><b>Autor</b></td><td><b>Titel</b></td><td><b>Datum</b></td></tr>
<PAGE title="Infodrom Oldenburg - News">
+<headline "News">
+
<?
function sql_prepare ($text)
if ($delete > 0) {
$query = "DELETE FROM patches WHERE oid = $id";
} else {
- $query = "UPDATE patches SET"
+ $query = "UPDATE patches SET "
. "subject='$subject',"
. "package='$package',"
. "version='$version',"
$query = "DELETE FROM todo WHERE oid = $id";
} else {
if ($done > 0) {
- $query = "UPDATE todo SET"
+ $query = "UPDATE todo SET "
. "subject='$subject',"
. "package='$package',"
. "done='now',"
. "description='$description'"
. " WHERE oid = $id";
} else {
- $query = "UPDATE todo SET"
+ $query = "UPDATE todo SET "
. "subject='$subject',"
. "package='$package',"
. "description='$description'"
. "(subject,package,description,submitted,done) VALUES ("
. "'$subject',"
. "'$package',"
- . "'$version',"
+ . "'$description',"
. "'now',"
. "NULL"
. ")";
<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");
+<?
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
<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");
+<?
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
<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");
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
<headline "Zeitplan">
-<? $dbh = pg_pconnect ("kuolema", "5432", "lt2k") or die("Unable to
- connect to SQL server");
+<? $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
return ($mytext);
}
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
$body = sql_prepare ($body);
<p><b><font face="Helvetica,Arial"><a href="<? echo "show.php3?id=$id"; ?>">Zurück</a></font></b>
+<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</PAGE>
# Local variables:
return ($mytext);
}
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
$body = sql_prepare ($body);
}
?>
+<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</PAGE>
# Local variables:
<headline "Kostenverteilung">
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
if ($oid) {
<costs_init>
<get_sponsoring>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
<form_to_yyyymmdd>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
$category = sql_prepare ($category);
<a href="list.php3?category=pr">Öffentlichkeitsarbeit</a> -
<a href="list.php3?category=devel">Entwicklertreffen</a>
+#<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</page>
# Local variables:
<table width=100% cellpadding=0 cellspacing=0 border=0>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
$query = "SELECT oid,name,email FROM dinner WHERE day = '<get-var day>' ORDER BY name";
<sql_prepare>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
<:
<h3><? echo $name; ?> aufgenommen/aktualisiert</h3>
+<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</PAGE>
# Local variables:
<?
if ($id > 0) {
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
$query = "SELECT * FROM exhibitor WHERE id = '$id'";
</tr>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
$query = "SELECT id,organization,type,amount,boothsize,nr_computers FROM exhibitor ORDER BY organization";
return ($mytext);
}
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
<:
<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
+<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</PAGE>
# Local variables:
<li> <a href="index.php3">Index</a>
<li> <a href="edit.php3">Neues Gerät hinzufügen</a>
+<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</page>
# Local variables:
<?
if ($id > 0) {
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
<tr><td>Nr.</td><td><b>Autor</b></td><td><b>Titel</b></td><td><b>Datum</b></td></tr>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
return ($mytext);
}
- $dbh = pg_pconnect ("kuolema", "5432", "lt2k")
+ $dbh = pg_pconnect ("kuolema", "5432", "<db>")
or die("Unable to connect to SQL server");
<:
", "<newline>", $body)));
?>
+<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+
</PAGE>
# Local variables: