Save to the advisor_student table

File

modules/user/user.module, line 702

Code

function user_edit_user_advisees_form_submit($form, $form_state) {

  // Begin by clearing the table for this advisor.
  $faculty_cwid = trim($form_state ["values"]["faculty_cwid"]);
  db_query("DELETE FROM advisor_student WHERE faculty_id = ? ", $faculty_cwid);

  $students = trim($form_state ["values"]["students"]);
  $lines = explode("\n", $students);
  foreach ($lines as $line) {
    $temp = explode("#", $line);
    $line = trim($temp [0]);
    if ($line == "") {
      continue;
    }
    // Okay, $line should now contain the CWID.
    // Insert into db.  (use REPLACE to prevent an error if data was entered twice)
    db_query("REPLACE INTO advisor_student (faculty_id, student_id)
              VALUES (?, ?) ", $faculty_cwid, $line);

  }

  fp_add_message(t("The advisees have been updated for this faculty member."));

}