Plain file from Erik (v1.9)

diff --git a/src/LinuxTag/2002/supporter/job.wml b/src/LinuxTag/2002/supporter/job.wml
new file mode 100644 (file)
index 0000000..d6e235f
--- /dev/null
+++ b/src/LinuxTag/2002/supporter/job.wml
@@ -0,0 +1,33 @@
+#include <lt2002.style>
+#include "../edit.style"
+#include "../phpfunctions.inc"
+
+<page func="LinuxTag 2002 Organisation" title="Jobs">
+<job>
+
+<?
+  $dbh = pg_pconnect ("<dbconnstring>")
+              or die("Unable to connect to SQL server");
+  pg_exec($dbh, "SET DateStyle='ISO'") or die ("Cannot set datestyle");
+
+  $query = sprintf("SELECT id, title from job order by priority");
+  $sth = pg_exec($dbh, $query) or die ("Datenbank-Fehler");
+
+  for ($x = 0; $x < pg_NumRows($sth); $x++)
+  {
+  $row = pg_fetch_array($sth, $x);
+  $query = sprintf("SELECT * from fragment where job = %d", $row['id']);
+  $sth2 = pg_exec($dbh, $query) or die ("Cannot find fragments");
+  echo '<h2><a href="edit_job.php3?id=' . $row['id'] . '">' . $row['title'] . '</a></h2> ';
+  echo '<a href="edit_job_fragment.php3?job=' . $row['id'] . '">Add fragment</a><br>';
+  echo '<a href="update.php3?type=delete_job&id=' . $row['id'] . '">Delete job</a><br>';
+  for ($y = 0; $y < pg_NumRows($sth2); $y++)
+  {
+       $row2 = pg_fetch_array($sth2, $y);
+       fragment_overview($row2['id'], 1, 1, 1);
+  }
+  echo '<br><br>';
+  }
+  
+?>
+</page>