// find out if there are other students. only search for active students... $sql2 = "SELECT count(*) as count \n\t\t\t\t\t\t\tFROM parent2student,users , user2center\n\t\t\t\t\t\t\tWHERE parent2student.parent_id=" . $row1['parent_id'] . "\n\t\t\t\t\t\t\t\tAND user2center.user_id=parent2student.student_id\n AND user2center.isActive='Y'"; $result2 = $db->query($sql2); $row2 = $result2->fetch_assoc(); if ($row2['count'] <= 1) { // the parent had only 1 active child to watch // deactivate parent account... deActivate_parent($row1['parent_id'], $_SESSION[$_CONF['sess_name'] . "_myCenter"]); $debug .= "DeActivating Parent ID " . $row1['parent_id'] . "<br>"; } // end if only 1 child to watch.. } // end while fetch parent_id etc... } /** De-Activate the student - functionLib **/ deActivate_student($row['user_id'], $_SESSION[$_CONF['sess_name'] . "_myCenter"]); } $msg = "Parent accounts have been updated<br>"; $msg .= "Students have been updated<br>"; $msg .= $debug; $main .= make_box($t, $msg); /** now lets set set all grade 11 students to grade 12 ... This should simply be graduating each student (ie has grade_level > 0 and <= 12) **/ $t = "Next Year Prep - First Year Student Management"; $b = ""; $sql6 = "UPDATE users set grade_level=grade_level+1 \n\t\t\t\tWHERE (grade_level > 0 AND grade_level < 13)"; $result6 = $db->query($sql6); $b .= "Done.<br />"; $main .= make_box($t, $b);
/** Need to add logic here to test for changing isStudent/isTeacher So I can deal with dropbox, downloads etc... **/ if ($_POST['isTeacherChanged'] == "true") { if ($_POST['role:isTeacher'] == 'Y') { reActivate_teacher($_POST['u_id'], $_POST['c_id']); } else { deActivate_teacher($_POST['u_id'], $_POST['c_id']); } } if ($_POST['isStudentChanged'] == "true") { if ($_POST['role:isStudent'] == 'Y') { reActivate_student($_POST['u_id'], $_POST['c_id']); } else { deActivate_student($_POST['u_id'], $_POST['c_id']); } } $roles = array(); $sql = "UPDATE user2center set "; foreach ($_POST as $k => $v) { if (substr($k, 0, 5) == 'role:') { list($junk, $role) = preg_split("/:/", $k); $sql .= $role . "='" . $v . "',"; } } /** remove the last , from sql **/ $sql = rtrim($sql, ","); $sql .= " WHERE user_id=" . $_POST['u_id'] . " AND center_id=" . $_POST['c_id']; $result = $db->query($sql); }