fix_course_sortorder(); } /****************************************************************************** * Update the segue_moodle link table ******************************************************************************/ $moodle_site_id = $newcourseid; if ($moodle_site_deleted == 1) { $query = "\n\t\t\tINSERT INTO\n\t\t\t\tsegue_moodle\n\t\t\tSET\n\t\t\t\tFK_moodle_site_id = '" . addslashes($moodle_site_id) . "',\n\t\t\t\tFK_segue_site_id = '" . addslashes($_REQUEST['siteid']) . "'\t\t\t\t\n\t\t\t"; } else { $query = "\n\t\t\tUPDATE\n\t\t\t\tsegue_moodle\n\t\t\tSET\n\t\t\t\tFK_moodle_site_id = '" . addslashes($moodle_site_id) . "'\n\t\t\tWHERE\n\t\t\t\tFK_segue_site_id = '" . addslashes($_REQUEST['siteid']) . "'\n\t\t\t\t\n\t\t\t"; } $r = mysql_query($query, $cid); // print $query."<br>"; //exit; // print "new moodle site_id: ".$moodle_site_id."<br>"; link_log($_REQUEST['userid'], $_REQUEST['siteid'], $category = "site_added", $description = "Measure site created"); //exit; } /****************************************************************************** * end new Moodle site ******************************************************************************/ /****************************************************************************** * if the Segue user is not the site owner, then enrol them as student * code adapted from: * moodle/course/student.php ******************************************************************************/ if ($segue_user_id != $site_owner_id) { //print "<hr>Adding student to site<br>"; //print "moodle_site_id: ".$moodle_site_id; $addstudent = $moodle_user_id; $timestart = $timeend = 0;
exit; } else { $admin_report = "no linked moodle site found<br>"; $query = "\n\t\tINSERT INTO\n\t\t\tsegue_moodle\n\t\tSET\n\t\t\tFK_segue_site_id = '" . addslashes($segue_site_id) . "',\n\t\t\tsite_title = '" . addslashes($site_title) . "',\n\t\t\tsite_slot = '" . addslashes($site_slot) . "',\n\t\t\tsite_owner_id = '" . addslashes($segue_site_owner) . "',\n\t\t\tsite_theme = '" . addslashes($site_theme) . "'\n\t\t"; // print $query."<br>"; //exit; $r = db_query($query); } } /****************************************************************************** * Check for corresponding Moodle user ******************************************************************************/ if (!isset($segue_user_id) || !$segue_user_id) { print "<div class='error'>No Segue user id passed...</div><br>"; print "</body</html>"; link_log(0, $segue_site_id, $category = "errors", $description = "No Segue user id passed"); exit; } else { $query = "\n\t\t\tSELECT\n\t\t\t\tuser_link.system, user_link.user_id, auth_id\n\t\t\tFROM\n\t\t\t\tuser_link\n\t\t\tINNER JOIN\n\t\t\t\tauthentication\n\t\t\tON\n\t\t\t\tFK_auth_id = auth_id\n\t\t\tWHERE\n\t\t\t\tauthentication.system = 'segue'\n\t\t\t\tAND\n\t\t\t\tuser_link.system = 'moodle'\n\t\t\t\tAND\n\t\t\t\tauthentication.user_id = '" . addslashes($segue_user_id) . "'\t\t\t\t\n\t"; } //print $query."<br>"; //exit; $r = db_query($query); /****************************************************************************** * Create an auth token for validation ******************************************************************************/ $auth_token = md5(time() . rand(1, 1000)); //print "auth_token: ".$auth_token."<hr \>"; /****************************************************************************** * Store the referrer so link to Segue in Moodle is more accurate * (i.e. to specific page in linked Segue where Moodle link is...)