/** * Associates users with an instance ID: ie make them an assessor * @global type $CFG * @param type $id the instance ID * @param type $userID a specific user ID * @return XML-formatted string containing details of the user, or an error if the insert query fails */ public function associateUsersWithInstance($id, $userID) { global $CFG; try { $conn = new PDO("mysql:host={$CFG->db};dbname={$CFG->schema}", $CFG->dbuser, $CFG->dbuserpass); } catch (PDOException $e) { die('<data><error>failed connecting to database</error><detail>' . $e->getMessage() . '</detail></data>'); } //$conn = mysqli_connect($CFG->db, $CFG->dbuser, $CFG->dbuserpass, $CFG->schema) or die('<data><error>failed connecting to database</error><detail>' . mysqli_error($conn) . '</detail></data>'); $query = "INSERT INTO users_exam_instances_link (exam_instances_ID, users_ID) \n VALUES(:id, :userID);"; $stmt = $conn->prepare($query); $stmt->bindValue(':id', $id, PDO::PARAM_INT); $stmt->bindValue(':userID', $userID, PDO::PARAM_INT); $result = $stmt->execute() or die('<data><error>associateUsersWithInstance query failed</error><detail>' . $stmt->errorCode() . '</detail></data>'); // $result = mysqli_query($conn, $query) or die('<data><error>insert query failed</error><detail>' . mysqli_error($conn) . $query . '</detail></data>'); if ($conn->lastInsertId() > 0) { $enumlib = new EnumLib(); return $enumlib->getUserByID($userID); } else { return '<data><error>operation failed</error><detail>' . mysqli_error($conn) . '</detail></data>'; } // return "<data><id>$returnStr</id></data>"; }
break; case 'updateuser': $returnStr = $authlib->update_user($_REQUEST['id'], $_REQUEST['user_type'], $_REQUEST['user_username'], $_REQUEST['user_fullname'], $_REQUEST['user_roleid'], $_REQUEST['user_password']); break; case 'deleteuser': $returnStr = $authlib->delete_user($_REQUEST['id']); break; case 'listusers': include 'lib/EnumLib.php'; $enumLib = new EnumLib(); $returnStr = $enumLib->getUsers(isset($_REQUEST['searchstr']) ? $_REQUEST['searchstr'] : ''); break; case 'getuserbyid': include 'lib/EnumLib.php'; $enumLib = new EnumLib(); $returnStr = $enumLib->getUserByID($_REQUEST['id']); break; /////////////////////////////////////////////////////////////////////////////////////////////// // student management /////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////// // student management /////////////////////////////////////////////////////////////////////////////////////////////// case 'newstudent': include 'lib/MediaLib.php'; $returnStr = $authlib->new_student($_REQUEST['student_fname'], $_REQUEST['student_lname'], $_REQUEST['student_num'], $_REQUEST['student_email'], $_REQUEST['student_cohort'], isset($_FILES['file']) ? $_FILES['file'] : null); break; case 'updatestudent': include 'lib/MediaLib.php'; $returnStr = $authlib->update_student($_REQUEST['studentID'], $_REQUEST['student_fname'], $_REQUEST['student_lname'], $_REQUEST['student_num'], $_REQUEST['student_email'], isset($_FILES['file']) ? $_FILES['file'] : null); break;
<span><input type='image' src='<?php print "{$CFG->wwwroot}{$CFG->basedir}/icons/dialog-information.png"; ?> ' BORDER='0' style='vertical-align: text-bottom;' onclick='show_information("<?php print simplexml_load_string($enumLib->getCriteriaScaleOverview($instanceData->instance[0]->scale_id))->item[0]->notes; ?> "); return false;'/></span><br/></div> </div> <div style="width: 99%; display: table-row"> <div style="display: table-cell"><b><?php print $stringlib->get_string('osce_session_owner'); ?> :</b></div> <div style="display: table-cell"><?php print simplexml_load_string($enumLib->getUserByID($instanceData->instance[0]->owner_id))->user[0]->name; ?> </div> </div> <div style="width: 99%; display: table-row"> <div style="display: table-cell"><b><?php print $stringlib->get_string('osce_session_description'); ?> :</b></div> <div style="display: table-cell"><?php print $instanceData->instance[0]->description; ?> </div> </div> </div> <?php