[Aimmath-commit] moodle/mod/math_assignment config.html,1.4,1.5

[<ma...@us...>]

Update of /cvsroot/aimmath/moodle/mod/math_assignment
In directory sc8-pr-cvs1:/tmp/cvs-serv2167/mod/math_assignment

Modified Files:
	config.html 
Log Message:
Added code to delete entries from the subject table left over after a course is deleted

Index: config.html
===================================================================
RCS file: /cvsroot/aimmath/moodle/mod/math_assignment/config.html,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** config.html	19 Sep 2003 11:58:27 -0000	1.4
--- config.html	23 Sep 2003 17:54:40 -0000	1.5
***************
*** 71,78 ****
  
          // get aim server
!         unset($options);
          if ($servers = get_records("math_assignment_server", "", "", "name ASC")) {
              foreach ($servers as $server) {
!                 $option[$server->id] = $server->name;
              }
          }
--- 71,78 ----
  
          // get aim server
!         $options = array();
          if ($servers = get_records("math_assignment_server", "", "", "name ASC")) {
              foreach ($servers as $server) {
!                 $options[$server->id] = $server->name;
              }
          }
***************
*** 90,94 ****
              echo "<td align=\"right\"><p><b>$straimserver : </b></p></td>\n";
              echo "<td align=\"left\">";
!             choose_from_menu ($option, "server$course->id", $subject->server, "choose", "", 0);
              echo "</td>\n";
              echo "<td align=\"left\">";
--- 90,94 ----
              echo "<td align=\"right\"><p><b>$straimserver : </b></p></td>\n";
              echo "<td align=\"left\">";
!             choose_from_menu ($options, "server$course->id", $subject->server, "choose", "", 0);
              echo "</td>\n";
              echo "<td align=\"left\">";
***************
*** 112,115 ****
--- 112,125 ----
          }
      }
+ 
+     // remove any entries in the subjects table which correspond to non-existent courses
+     unset($courseids);
+     foreach ($courses as $course) {
+         if (isset($courseids))
+             $courseids .= ", $course->id";
+         else
+             $courseids = "$course->id";
+     }
+     $db->Execute("DELETE FROM `{$CFG->prefix}math_assignment_subject` WHERE `course` NOT IN ($courseids)");
  
  ?>