function inCurrentCourse($moodleId) { // Checks to see if the currently logged in student is in courses that are in the current term. global $CFG; $moodledb = mysql_connect($CFG->dbhost, $CFG->dbuser, $CFG->dbpass); if (!$moodledb) { die('Could not connect to moodle: ' . mysql_error()); } mysql_select_db($CFG->dbname, $moodledb); $filter = getCurrentCourseFilter(); $query = 'select * from mdl_user_enrolments ue join mdl_enrol e on ue.enrolid = e.id join mdl_course c on c.id = e.courseid where c.shortname like "' . $filter . '" and ue.userid = ' . $moodleId . ';'; //echo $query; $res = mysql_query($query); $num = mysql_num_rows($res); mysql_close(); if ($num > 0) { return true; } else { return false; } }
function checkSurveyStatus($stdid) { // Checks to see if the current user has alreay completed the survey for the semester. global $LIME; $lime = mysql_connect($LIME->dbhost, $LIME->dbuser, $LIME->dbpass); if (!$lime) { die('Could not connect: ' . mysql_error()); } $query = 'select * from lime_survey_' . $LIME->surveyid . ' where ((' . $LIME->surveyid . 'X' . $LIME->surveygroup . 'X' . $LIME->surveyquestion . ' = "' . $stdid . '") and (submitdate is not null));'; mysql_select_db($LIME->db, $lime); $res = mysql_query($query); $num = mysql_num_rows($res); mysql_close(); if ($num == 0) { if ($stdid != "") { $tc = getCurrentCourseFilter(); $tc = substr($tc, 2); $json = '{ "studentid":"' . $stdid . '","termcode":"' . $tc . '"}'; $result = $json; } else { $result = "0"; } } else { $result = "0"; } return $result; }