1 #include <infodrom.style>
2 #include <phptools.inc>
4 <page func="Infodrom Oldenburg" title="Patches">
7 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
8 or die("Unable to connect to SQL server");
11 if ($_POST[delete] > 0) {
12 $query = "DELETE FROM patches WHERE oid = $_POST[id]";
14 $query = "UPDATE patches SET "
15 . sprintf ("subject='%s',package='%s',version='%s',description='%s',download='%s'",
16 addslashes ($_POST[subject]),
17 addslashes ($_POST[package]),
18 addslashes ($_POST[version]),
19 addslashes ($_POST[description]),
20 addslashes ($_POST[download]))
21 . " WHERE oid = $_POST[id]";
24 $date = date ("Y-m-j H:i");
26 $query = "INSERT INTO patches "
27 . "(subject,package,version,description,download,submitted) VALUES ("
28 . sprintf ("'%s','%s','%s','%s','%s','%s'",
29 addslashes ($_POST[subject]),
30 addslashes ($_POST[package]),
31 addslashes ($_POST[version]),
32 addslashes ($_POST[description]),
33 addslashes ($_POST[download]),
38 //printf ("<pre>\n%s\n</pre>\n", $query);
39 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
43 <h3><? echo $_POST[subject]; ?></h3>
45 <h5><? echo $_POST[package] . " " . $_POST[version]; ?></h5>
47 <b><? echo $_POST[description]; ?></b><p>
49 <b>Download:</b> <? echo $_POST[download]; ?><p>