/**
* 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
