// 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);
}
