function getAll() {
SecurityResource::requirePermission("VIEW");
$sql = "SELECT * from security_resource";
$result = Database::query($sql);
$all = array();
while($line = $result->next()) {
array_push($all, SecurityResource::build($line));
}
return $all;
}
function getById($id) {
SecurityResource::requirePermission("VIEW");
$sql = "SELECT * from security_resource WHERE id=".Database::sqlValue($id);
$result = Database::query($sql);
$r = NULL;
if ($line = $result->next()) {
$r = SecurityResource::build($line);
}
return $r;
}
