#include <infodrom.style>
#include <phptools.inc>

<page func="Infodrom Oldenburg" title="Logbook">

<sql_prepare>
<?
  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	 or die("Unable to connect to SQL server");

<:
  for $i (('teaser','body')) {
    printf "  \$o_%s = \$_POST[%s];\n", $i, $i;
    printf "  \$%s = pg_escape_string(\$_POST[%s]);\n", $i, $i;
  }
:>
  if ($_POST["public"] != 1) {
    $_POST["public"] = 0;
  }

  if ($_POST[oid] > 0) {
    $query = sprintf ("UPDATE logbook SET category='%s',teaser='%s',public=%d,body='%s' "
		     ."WHERE oid = %d",
		     $_POST[category],
		     $teaser,
		     $_POST["public"],
		     $body,
		     $_POST[oid]);
  } else {
    $date = date ("Y-m-d H:i");
    $id = date ("YmdHi");

    $query = sprintf ("INSERT INTO logbook (id,category,teaser,body,public,created) VALUES "
		     ."('%s','%s','%s','%s',%d,'%s')",
		     $id,
		     $_POST["category"],
		     $teaser,
		     $body,
		     $_POST["public"],
		     $date);
  }
  // printf ("<pre>\n%s\n</pre>\n", $query);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
?>

<h3><? echo $o_teaser; ?></h3>

<?
  if (! isset($_POST[oid]) || $_POST[oid] == 0) {
    $oid = pg_getlastoid ($sth);
  } else {
    $oid = $_POST[oid];
  }

  $query = sprintf ("SELECT id,public FROM logbook WHERE oid = %d", $oid);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
  if (pg_NumRows ($sth) > 0) {
    $row = pg_fetch_array ($sth, 0);

    printf ('<p><a href="edit.php?id=%d">edit</a>', $row['id']);
    if ($row['public'] > 0) {
      if ($_POST['category'] === 'absurd')
        printf (' &mdash; <a href="http://www.infodrom.org/~joey/absurd/?%s">public link</a>',
	   $row['id']);
      else
        printf (' &mdash; <a href="http://www.infodrom.org/~joey/log/?%s">public link</a>',
	   $row['id']);
    }
    echo "</p>";
  }
?>

<? echo str_replace ("\\\n", "", str_replace ("\r", "", $o_body)); ?>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# end: