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

<future>
<page func="Infodrom Oldenburg" title="Patches">

<?
  if ($_POST['id'] > 0) {
    if ($_POST['delete'] > 0) {
      $sql = sprintf("DELETE FROM patches WHERE oid = %d", $_POST['id']);
    } else {
      $sql = sprintf("UPDATE patches SET subject=%s, package=%s, version=%s, description=%s, download=%s WHERE oid = %d",
		     $db->quote($_POST['subject']),
		     $db->quote($_POST['package']),
		     $db->quote($_POST['version']),
		     $db->quote($_POST['description']),
		     $db->quote($_POST['download']),
		     $_POST['id']);
    }
  } else {
    $date = date ("Y-m-j H:i");

    $sql = sprintf("INSERT INTO patches (subject,package,version,description,download,submitted) VALUES (%s,%s,%s,%s,%s,%s)",
		   $db->quote($_POST['subject']),
		   $db->quote($_POST['package']),
		   $db->quote($_POST['version']),
		   $db->quote($_POST['description']),
		   $db->quote($_POST['download']),
		   $db->quote($date));
  }
  //printf ("<pre>\n%s\n</pre>\n", $sql);
  $db->execute($sql);
?>

<h3><? echo $_POST['subject']; ?></h3>

<h5><? echo $_POST['package'] . " " . $_POST['version']; ?></h5>

<b><? echo $_POST['description']; ?></b><p>

<b>Download:</b> <? echo $_POST['download']; ?><p>

</page>

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