Looks like I broke it slightly... Erik changed it so we can insert new

projects again.

diff --git a/src/LinuxTag/2002/projects/update.wml b/src/LinuxTag/2002/projects/update.wml
index 69229d4..c588027 100644 (file)
--- a/src/LinuxTag/2002/projects/update.wml
+++ b/src/LinuxTag/2002/projects/update.wml
@@ -64,26 +64,6 @@
   if ($type == "project") {
     pg_exec ($dbh, "BEGIN TRANSACTION") or die("Datenbank-Abfrage!");
 
-    $query = sprintf ("SELECT name FROM project WHERE oid = %d", $oid);
-    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
-    if (pg_NumRows ($sth) > 0) {
-      $row = pg_fetch_array ($sth, 0);
-      $oldname = $row['name'];
-    } else {
-      die ("Project without a name?  Uh?");
-    }
-
-    $query = sprintf ("SELECT oid FROM appendix WHERE project = '%s'", $oldname);
-    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
-    if (pg_NumRows ($sth) > 0) {
-      $row = pg_fetch_array ($sth, 0);
-      $appendixoid = $row['oid'];
-    } else {
-      $appendixoid = 0;
-    }
-
-    # Now we know enough and can continue
-
     if ($delete == 1) {
       pg_exec ($dbh, sprintf ("DELETE FROM project WHERE oid = %d", $oid));
 
@@ -110,6 +90,27 @@
       }
 
     } else {
+    $query = sprintf ("SELECT name FROM project WHERE oid = %d", $oid);
+    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+    if (pg_NumRows ($sth) > 0) {
+      $row = pg_fetch_array ($sth, 0);
+      $oldname = $row['name'];
+    } else {
+      die ("Project without a name?  Uh?");
+    }
+
+    $query = sprintf ("SELECT oid FROM appendix WHERE project = '%s'", $oldname);
+    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+    if (pg_NumRows ($sth) > 0) {
+      $row = pg_fetch_array ($sth, 0);
+      $appendixoid = $row['oid'];
+    } else {
+      $appendixoid = 0;
+    }
+
+    # Now we know enough and can continue
+
+
       $query = sprintf ("UPDATE project SET name='%s',url='%s',boothnr='%s',"
                       ."boothsize=%d,computer=%d,comment='%s' WHERE oid = %d",
                       addslashes ($name),