$student_id = $regi['student_id'] = $q3aitUsers[$row['STGUID']]['user_id'];
$course_id = $regi['course_id'] = $q3aitCourses[$row['SectionID']]['course_id'];
$classes = get_classes_for_course($course_id);
while ($row2 = $classes->fetch_assoc()) {
array_push($register, array('user_id' => $student_id, 'class_id' => $row2['class_id']));
}
}
} else {
//print "Student {STGUID=".$row['STGUID']."} is not in the q3ait db.<br>\n";
//continue;
}
} else {
//print "Course {SectionID=".$row['SectionID']."} is not in the q3ait db.<br>\n";
//continue;
}
}
$errors = registerStudentInCourse($register);
if ($errors['error']) {
$msg = $errors['message'] . "<BR>\n";
array_push($messages, $msg);
}
/**
* Errors?
*/
$err = '';
if (count($messages) > 0) {
foreach ($messages as $message) {
$err .= $message . "\n";
}
email_admin("Q3AIT.ORG ERROR: Sync - ROSTERS", $err);
}
require '/usr/local/q3ait/config.php';
require $_CONF['webRoot'] . 'functionLib.php';
// Connect to DB
$db = new mysqli($_CONF['DB_host'], $_CONF['DB_user'], $_CONF['DB_pass'], $_CONF['DB_name']);
if (mysqli_connect_errno()) {
die("There was an error connecting to the database: " . mysqli_connect_error());
}
$regi = array();
$smsClassRosters = make_array_from_sql(getClassRostersFromSMS(), 'ms');
$q3aitUsers = make_assoc_array_from_sql(getCurrentUsersForSMS(), 'GUID', 'my');
$q3aitCourses = make_assoc_array_from_sql(getCoursesForSMS(), 'SectionID', 'my');
$smsRoster = array();
// user_id, class_id
foreach ($smsClassRosters as $row) {
if (array_key_exists($row['SectionID'], $q3aitCourses) && array_key_exists($row['STGUID'], $q3aitUsers)) {
$msg .= "Working on Student{" . $q3aitUsers[$row['STGUID']]['first_name'] . " " . $q3aitUsers[$row['STGUID']]['last_name'] . "} in class{" . $q3aitCourses[$row['SectionID']]['course_name'] . "}...<br>";
$student_id = $regi['student_id'] = $q3aitUsers[$row['STGUID']]['user_id'];
$course_id = $regi['course_id'] = $q3aitCourses[$row['SectionID']]['course_id'];
$classes = get_classes_for_course($course_id);
while ($row = $classes->fetch_assoc()) {
array_push($smsRoster, array('user_id' => $student_id, 'class_id' => $row['class_id']));
}
} else {
continue;
}
}
$errors = registerStudentInCourse($smsRoster);
if ($errors['error']) {
$msg .= $errors['message'] . "<BR>\n";
email_admin("Q3AIT.ORG ERROR: Syncing Class Rosters", $msg);
}
