<a href="./">LinuxTag 2000</a><br>
-<ifneq <get-var WML_SRC_BASENAME> "newsedit"
- <a href="newsedit.php3?id=0">News</a>
- News
-><br>
+<a href="news/edit.php3?id=0">News</a><br>
-<ifneq <get-var WML_SRC_BASENAME> "newslist"
- <a href="newslist.php3">Newslist</a>
- Newslist
-><br>
+<a href="news/">Newslist</a><br>
+
+# <ifneq <get-var WML_SRC_BASENAME> "newslist"
+# <a href="newslist.php3">Newslist</a>
+# Newslist
+# ><br>
<a href="http://oldenburger.linuxtage.de/">Homepage</a><br>
--- /dev/null
+#include "lt2k.style"
+
+<PAGE title="LinuxTag 2000">
+
+<h1 align=center>Oldenburger LinuxTag 2000</h1>
+
+<?
+ if ($id > 0) {
+ $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 * FROM news WHERE id = '$id'";
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ if (pg_NumRows ($sth) > 0) {
+ $row = pg_fetch_array ($sth, 0);
+ }
+ } else {
+ $row['releasedate'] = date ("Y-m-j H:i");
+ }
+?>
+
+<form method=post action="update.php3">
+<input type=hidden name=id value="<? echo $row['id']; ?>">
+<b>Subject:</b> <input name=subject size=60 maxlength=120 value="<? echo $row['subject']; ?>"><br>
+<b>Autor:</b> <input name=author size=20 maxlength=120 value="<? echo $row['author']; ?>">
+<b>Email:</b> <input name=email size=20 maxlength=120 value="<? echo $row['email']; ?>"><br>
+<b>Teaser:</b> <br><textarea name=teaser rows=5 cols=67><? echo $row['teaser']; ?></textarea><p>
+<b>Text:</b> <br><textarea name=body rows=16 cols=67><? echo $row['body']; ?></textarea><p>
+<b>Releasedate:</b> <input name=releasedate size=40 maxlength=120 value="<? echo $row['releasedate']; ?>"> (yyyy-mm-dd hh:mm)<br>
+<? if ($id > 0) { ?>
+<b>Deleted:</b> <input name=deleted type=radio value="1" <? if ($row['deleted']==1) { echo "checked";} ?>> yes
+<input name=deleted type=radio value="0" <? if ($row['deleted']==0) { echo "checked";} ?>> no<br>
+<? } ?>
+<p><center><input type=submit value="<? echo $id>0?"Update":"Insert"; ?>"></center><p>
+</form>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+#include "lt2k.style"
+
+<PAGE title="LinuxTag 2000">
+
+<h1 align=center>Oldenburger LinuxTag 2000</h1>
+
+<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>
+
+<?
+ $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,subject,author,releasedate,deleted FROM news ORDER BY releasedate DESC,insertd DESC";
+ $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['releasedate']);
+ $date = explode ("-", $date[0]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+
+ printf ("<tr><td>%d</td>", $nr+1);
+ if ($row['deleted'] == 1) {
+ $del = " (del)";
+ } else {
+ $del = "";
+ }
+ printf ("<td>%s</td><td><a href=\"edit.php3?id=%d\">%s</a>%s</td><td>%s</td></td></tr>",
+ $row['author'], $row['id'], $row['subject'], $del, $date);
+ }
+?>
+
+</table>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end:
--- /dev/null
+<a href="./">LinuxTag 2000</a><br>
+
+<ifneq <get-var WML_SRC_BASENAME> "edit"
+ <a href="edit.php3?id=0">News</a>
+ News
+><br>
+
+<ifneq <get-var WML_SRC_BASENAME> "index"
+ <a href="index.php3">Newslist</a>
+ Newslist
+><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">
+
+<h1 align=center>Oldenburger LinuxTag 2000</h1>
+
+<?
+
+ 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");
+
+<:
+ for $i (('subject','author','email','teaser','body')) {
+ printf " \$%s=sql_prepare (\$%s);\n", $i, $i;
+ }
+:>
+
+ if ($id > 0) {
+ $query = "UPDATE news SET "
+ . "subject='$subject',"
+ . "author='$author',"
+ . "email='$email',"
+ . "teaser='$teaser',"
+ . "body='$body',"
+ . "releasedate='$releasedate',"
+ . "deleted='$deleted'"
+ . " WHERE id = $id";
+ } else {
+ $sth = pg_exec ($dbh, "SELECT max(id) FROM news") or die("Datenbank-Abfrage!");
+ $oldid = pg_fetch_array ($sth, 0) or die("Datenbank-Abfrage!"); $oldid[0]++;
+ $date = date ("Y-m-j H:i");
+
+ $query = "INSERT INTO news "
+ . "(id,subject,author,email,teaser,body,releasedate,insertd,insertp,deleted) VALUES ("
+ . "$oldid[0],"
+ . "'$subject',"
+ . "'$author',"
+ . "'$email',"
+ . "'$teaser',"
+ . "'$body',"
+ . "'$releasedate',"
+ . "'$date',"
+ . "'$REMOTE_USER',0"
+ . ")";
+
+ }
+ //printf ("<pre>\n%s\n</pre>\n", $query);
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ $date = explode (" ", $releasedate);
+ $date = explode ("-", $date[0]);
+ $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);
+?>
+
+<h3><? echo $subject; ?></h3>
+
+<h5>Von <? echo $author . ", " . $date; ?></h5>
+
+<b><? echo $teaser; ?></b><p>
+
+<?
+ echo ereg_replace ("<newline>", "
+", ereg_replace ("<newline><newline>","<p>", ereg_replace ("
+", "<newline>", $body)));
+?>
+
+</PAGE>
+
+# Local variables:
+# mode: text
+# mode: auto-fill
+# mode: iso-accents
+# end: