[GNUnet-SVN] r2300 - GNUnet-docs/WWW/test/tmp

[grothoff]

Author: grothoff
Date: 2005-11-30 17:33:38 -0800 (Wed, 30 Nov 2005)
New Revision: 2300

Modified:
   GNUnet-docs/WWW/test/tmp/jobs.php
Log:
sync

Modified: GNUnet-docs/WWW/test/tmp/jobs.php
===================================================================
--- GNUnet-docs/WWW/test/tmp/jobs.php   2005-12-01 01:31:34 UTC (rev 2299)
+++ GNUnet-docs/WWW/test/tmp/jobs.php   2005-12-01 01:33:38 UTC (rev 2300)
@@ -12,6 +12,7 @@
 $query = "SELECT * FROM universities";
 $result = mysql_query($query, $connection);
 $skipped = 0;
+$noad = 0;
 $num = 0;
 if ($result)
   $num = mysql_num_rows($result);
@@ -26,17 +27,27 @@
   if ($result2)
     $num2 = mysql_num_rows($result2);
   if ($num2 == 0) {
-    printf("<tr><td>%s</td><td><a href=\"%s\">%s</a><td><td><a href=\"%s\">* 
%s</a></td></tr>\n", 
+    $query3 = "SELECT * FROM noads WHERE id=$id";
+    $result3 = mysql_query($query2, $connection);
+    $num3 = 0;
+    $reason = "";
+    if ($result3) 
+      $num3 = mysql_num_rows($result3);
+    if ($num3 == 0) {
+      printf("<tr><td>%s</td><td><a href=\"%s\">%s</a><td><td><a href=\"%s\">* 
%s</a></td></tr>\n", 
          $id,
          $row["url"], 
          $row["name"],
         $row["appUrl"],
          $row["appDeadline"]);
+    } else {
+      $noad++;
+    }
   } else {
     $skipped++;
   }
 }
 echo "</table>\n";
-echo "Skipped $skipped entries.<br>";
+echo "Submitted $skipped applications, $noad marked to not have 
positions.<br>";
 echo "</body></html>\n"
 ?>