session_start();
if (!isAdmin()) {
$_SESSION['login_return'] = getUrlFull(__FILE__) . "/index.php";
header('Location: ' . $CFG->wwwroot . '/login.php');
return;
}
$query_parms = false;
$searchfields = array("membership_id", "context_id", "user_id", "role", "role_override", "created_at", "updated_at", "email", "displayname", "user_key");
$sql = "SELECT membership_id AS Membership, context_id AS Context, M.user_id as User, \n role, role_override, M.created_at, M.updated_at, email, displayname, user_key\n FROM {$CFG->dbprefix}lti_membership as M\n JOIN {$CFG->dbprefix}lti_user AS U ON M.user_id = U.user_id\n WHERE context_id = :CID";
$query_parms = array(":CID" => $_REQUEST['context_id']);
if (!isAdmin()) {
die("Fix this");
$sql .= "\nWHERE R.user_id = :UID";
$query_parms = array(":UID" => $_SESSION['id']);
}
$newsql = Table::pagedQuery($sql, $query_parms, $searchfields);
// echo("<pre>\n$newsql\n</pre>\n");
$rows = $PDOX->allRowsDie($newsql, $query_parms);
$newrows = array();
foreach ($rows as $row) {
$newrow = $row;
$newrows[] = $newrow;
}
$OUTPUT->header();
$OUTPUT->bodyStart();
$OUTPUT->topNav();
$OUTPUT->flashMessages();
?>
<p>
<a href="index.php" class="btn btn-default">View Contexts</a>
</p>
public static function pagedAuto($sql, $query_parms, $searchfields, $orderfields = false, $view = false, $params = false)
{
global $PDOX;
$newsql = Table::pagedQuery($sql, $query_parms, $searchfields, $orderfields, $params);
//echo("<pre>\n$newsql\n</pre>\n");
$rows = $PDOX->allRowsDie($newsql, $query_parms);
Table::pagedTable($rows, $searchfields, $orderfields, $view, $params);
}
