1 #include <infodrom.style>
2 #include <phptools.inc>
4 <page func="Infodrom Oldenburg" title="Logbook">
8 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
9 or die("Unable to connect to SQL server");
12 for $i (('teaser','body')) {
13 printf " \$o_%s = \$_POST[%s];\n", $i, $i;
14 printf " \$%s = pg_escape_string(\$_POST[%s]);\n", $i, $i;
17 if ($_POST["public"] != 1) {
21 if ($_POST[oid] > 0) {
22 $query = sprintf ("UPDATE logbook SET category='%s',teaser='%s',public=%d,body='%s' "
30 $date = date ("Y-m-d H:i");
33 $query = sprintf ("INSERT INTO logbook (id,category,teaser,body,public,created) VALUES "
34 ."('%s','%s','%s','%s',%d,'%s')",
42 // printf ("<pre>\n%s\n</pre>\n", $query);
43 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
46 <h3><? echo $o_teaser; ?></h3>
49 if (! isset($_POST[oid]) || $_POST[oid] == 0) {
50 $oid = pg_getlastoid ($sth);
55 $query = sprintf ("SELECT id,public FROM logbook WHERE oid = %d", $oid);
56 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
57 if (pg_NumRows ($sth) > 0) {
58 $row = pg_fetch_array ($sth, 0);
60 printf ('<p><a href="edit.php?id=%d">edit</a>', $row['id']);
61 if ($row['public'] > 0) {
62 if ($_POST['category'] === 'absurd')
63 printf (' — <a href="http://www.infodrom.org/~joey/absurd/?%s">public link</a>',
66 printf (' — <a href="http://www.infodrom.org/~joey/log/?%s">public link</a>',
73 <? echo str_replace ("\\\n", "", str_replace ("\r", "", $o_body)); ?>