Use ID instead of OID for activity

diff --git a/src/Infodrom/logbook/edit.wml b/src/Infodrom/logbook/edit.wml
index fe165d4..1e9fe2a 100644 (file)
--- a/src/Infodrom/logbook/edit.wml
+++ b/src/Infodrom/logbook/edit.wml
@@ -8,9 +8,9 @@
 
     pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
 
-  if ($_GET[oid] > 0) {
-    $query = sprintf ("SELECT * FROM logbook WHERE oid = %d", $_GET[oid]);
-    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+  if ($_GET['id'] > 0) {
+    $query = sprintf ("SELECT oid,* FROM logbook WHERE id = '%s'", $_GET['id']);
+    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage! ".$query);
 
     if (pg_NumRows ($sth) > 0) {
       $row = pg_fetch_array ($sth, 0);
@@ -26,7 +26,7 @@
 ?>
 
 <form method=post action="update.php">
-<input type=hidden name=oid value="<? echo $_GET[oid]; ?>">
+<input type=hidden name=oid value="<? echo $row['oid']; ?>">
 <b>Category:</b> <select name=category><?
   $sth = pg_exec ($dbh, "SELECT DISTINCT category FROM logbook ORDER BY category") or die("Datenbank-Abfrage!");
   for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
@@ -39,11 +39,11 @@
 <b>Text:</b> <br><textarea name=body rows=16 cols=79><? echo str_replace ("&", "&amp;", $row['body']); ?></textarea><p>
 <b>Public:</b> <input name=public type=checkbox value="1" <? if ($row['public']==1) { echo "checked";} ?>><br>
 
-<? if ($_GET[oid] > 0) { ?>
+<? if ($_GET['id'] > 0) { ?>
 <b>Created:</b> <? echo $date; ?><br>
 <? } ?>
 
-<p><center><input type=submit value="<? echo $_GET[oid]>0?"Update":"Insert"; ?>">\
+<p><center><input type=submit value="<? echo $_GET['id']>0?"Update":"Insert"; ?>">\
 &nbsp;&nbsp;&nbsp;&nbsp;
 <input type=reset value="Reset"></center><p>
 </form>