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

<page func="Oldenburger LinuxTag" title="Update News">

<sql_prepare>

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

<:
    $savedbody = $body;
    for $i (('subject','author','email','teaser','body')) {
      printf "    \$%s=sql_prepare (\$_POST[%s]);\n", $i, $i;
    }
:>

  if ($_POST[id] > 0) {
    $query = "UPDATE news SET "
      . "subject='$subject',"
      . "author='$author',"
      . "email='$email',"
      . "teaser='$teaser',"
      . "body='$body',"
      . "releasedate='$_POST[releasedate]',"
      . "deleted=$_POST[deleted]"
      . " WHERE id = $_POST[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',"
      . "'$_POST[releasedate]',"
      . "'$date',"
      . "'$_SERVER[REMOTE_USER]',0"
      . ")";

  }
  //printf ("<pre>\n%s\n</pre>\n", $query);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  $date = explode (" ", $_POST[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>

<p><b><? echo $teaser; ?></b>

<p><?
  echo ereg_replace ("<newline>", "
", ereg_replace ("<newline><newline>","<p>", ereg_replace ("
", "<newline>", $savedbody)));
?>

</page>

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