3 // Needs $content_id and $member_id for the BasicLTI placement
4 $sql = "SELECT * FROM ".TABLE_PREFIX."basiclti_content
5 WHERE content_id=".$content_id;
6 $instanceresult = mysql_query($sql, $db);
7 $basiclti_content_row = mysql_fetch_assoc($instanceresult);
8 if ( ! $basiclti_content_row ) {
9 loadError("Not Configured\n");
12 // echo("basiclti_content_row<br/>\n");print_r($basiclti_content_row); echo("<hr>\n");
14 $toolid = $basiclti_content_row['toolid'];
15 $sql = "SELECT * FROM ".TABLE_PREFIX."basiclti_tools
16 WHERE toolid='".$toolid."'";
17 $contentresult = mysql_query($sql, $db);
18 $basiclti_tool_row = mysql_fetch_assoc($contentresult);
19 if ( ! $basiclti_tool_row ) {
20 loadError("Tool definition missing\n");
23 // echo("basiclti_tool_row<br/>\n");print_r($basiclti_tool_row); echo("<hr>\n");
25 $sql = "SELECT * FROM ".TABLE_PREFIX."content
26 WHERE content_id=".$content_id;
27 $contentresult = mysql_query($sql, $db);
28 $atutor_content_row = mysql_fetch_assoc($contentresult);
29 if ( ! $atutor_content_row ) {
30 loadError("Not Configured\n");
33 // echo("atutor_content_row<br/>\n");print_r($atutor_content_row); echo("<hr>\n");
35 $sql = "SELECT * FROM ".TABLE_PREFIX."courses
36 WHERE course_id='".$atutor_content_row['course_id']."'";
37 $courseresult = mysql_query($sql, $db);
38 $atutor_course_row = mysql_fetch_assoc($courseresult);
39 if ( ! $atutor_course_row ) {
40 loadError("Course definition missing\n");
43 // echo("atutor_course_row<br/>\n");print_r($atutor_course_row); echo("<hr>\n");
45 $sql = "SELECT * FROM ".TABLE_PREFIX."course_enrollment
46 WHERE member_id='".$member_id."'";
47 $enrollresult = mysql_query($sql, $db);
48 $atutor_course_enrollment_row = mysql_fetch_assoc($enrollresult);
49 if ( ! $atutor_course_enrollment_row ) {
50 loadError("Course enrollment missing\n");
53 // echo("atutor_course_enrollment_row<br/>\n");print_r($atutor_course_enrollment_row); echo("<hr>\n");
55 $sql = "SELECT * FROM ".TABLE_PREFIX."members
56 WHERE member_id='".$member_id."'";
57 $memberresult = mysql_query($sql, $db);
58 $atutor_member_row = mysql_fetch_assoc($memberresult);
59 if ( ! $atutor_member_row ) {
60 loadError("Course definition missing\n");
63 // echo("atutor_member_row<br/>\n");print_r($atutor_member_row); echo("<hr>\n");