#include <infodrom.style>

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

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

    pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

    $query = "SELECT * FROM ticker WHERE oid = '$oid'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);

      $foo = explode (" ", $row['releasedate']);
      $row['releasedate'] = $foo[0];
      $foo = explode (":", $foo[1]);
      $row['releasedate'] .= " ". $foo[0] . ":". $foo[1];
    }
  } else {
    $row['releasedate'] = date ("Y-m-j H:i");
  }
?>

<form method=post action="update.php3">
<input type=hidden name=oid value="<? echo $oid; ?>">
<b>URL:</b> <input name=url size=60 maxlength=120 value="<? echo $row['url']; ?>"><br>
<b>Ticker:</b> <select name=ticker><?
  function sel ($myticker, $ticker, $descr)
  {
    printf ("<option value=\"%s\"%s>%s", $ticker, $myticker==$ticker?" selected":"", $descr);
  }

  sel ($row['ticker'], "ticker-chip", "CHIP Online");
  sel ($row['ticker'], "ticker-firstlinux", "FirstLinux");
  sel ($row['ticker'], "ticker-gnn", "Golem Network News");
  sel ($row['ticker'], "ticker-internetnews", "Internet News");
  sel ($row['ticker'], "ticker-heise", "Heise Newsticker");
  sel ($row['ticker'], "ticker-linuxcommunity", "Linux-Community");
  sel ($row['ticker'], "ticker-linuxde", "Linux.de");
  sel ($row['ticker'], "ticker-linuxmag", "Linux-Magazin");
  sel ($row['ticker'], "ticker-linuxpr", "LinuxPR");
  sel ($row['ticker'], "ticker-linuxtoday", "Linux Today");
  sel ($row['ticker'], "ticker-lwn", "Linux Weekly News");
  sel ($row['ticker'], "ticker-prolinux", "Pro Linux");
  sel ($row['ticker'], "ticker-slashdot", "Slashdot");
  sel ($row['ticker'], "ticker-zdnet", "ZDNet");
?></select><br>
<b>Subject:</b> <input name=subject size=60 maxlength=120 value="<? echo $row['subject']; ?>"><br>
<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 ($oid > 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 $oid>0?"Update":"Insert"; ?>"></center><p>
</form>

</page>

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